Support forum of the software localization tool Sisulizer


.NET, Delphi, ... - Sisulizer Localization Tool Support Home

Get in contact with the makers of Sisulizer.
Our forum is open for all questions around Sisulizer from customers and prospects.
Don't hesitate to register and ask. The Sisulizer team will answer ASAP.

Search     Help Home Sisulizer Website Download
Search by username
Not logged in - Login | Register 

 Moderated by: Sisusupport, Renate.Reinartz, Markus.Kreisel, Ilkka.Salmenius
New Topic Reply Printer Friendly
How to import component (Devart ODAC) - Usage - Three simple steps to localize - Technical Support (You need to be registered at the forum to write) - .NET, Delphi, ... - Sisulizer Localization Tool Support
AuthorPost
 Posted: Fri Aug 30th, 2019 03:37 pm
PM Private Upload Quote Reply
btomljanovic
Member
 

Joined: Fri Aug 30th, 2019
Location: Croatia
Posts: 5
Status: 
Offline
Hi,
I'm evaluating Sisulizer and have slight problem whith Devart Odac components.
Namely components have properties that should be excluded.
For example TSmartQuery has properties
SQLDelete
SQLInsert
SQLrefresh

I've tried to use Tools->Platform and add component in similar way as TSQL or TQuery but properties are not excluded.

Best regards
Boris

Last edited on Fri Aug 30th, 2019 03:37 pm by btomljanovic

Back To Top PM Private Upload Quote Reply

 Posted: Fri Aug 30th, 2019 03:43 pm
PM Private Upload Quote Reply
Markus.Kreisel
Administrator


Joined: Sat Apr 8th, 2006
Location: Monschau, Germany
Posts: 3297
Status: 
Offline
The easiest and clearest way is the following:
a) Filter for the rows you don't want to localize (you have many options in the filter panel)
b) Select them all in the translation grid (multi-select)
c) Right click and choose "Do not translate"

Yes, you will still use the rows, but your translator will not be able to translate them.
Hope this helps
Markus



____________________
http://www.sisulizer.com - Three simple steps to localize
Back To Top PM Private Upload Quote Reply

 Posted: Fri Aug 30th, 2019 04:22 pm
PM Private Upload Quote Reply
btomljanovic
Member
 

Joined: Fri Aug 30th, 2019
Location: Croatia
Posts: 5
Status: 
Offline
Yep, that much I figured out :)
Problem is that each TsmartQuerry have 7 properties that need to be excluded. With more than 150 scatered over app that's a pain in the neck, so I was hopping that there is a way to specify properties to exclude.

Boris

Last edited on Fri Aug 30th, 2019 04:52 pm by btomljanovic

Back To Top PM Private Upload Quote Reply

 Posted: Fri Aug 30th, 2019 05:42 pm
PM Private Upload Quote Reply
santra
Member
 

Joined: Thu Jun 2nd, 2016
Location:  
Posts: 6
Status: 
Offline
I've tried to use Tools->Platform and add component in similar way as TSQL or TQuery but properties are not excluded.

This is the right way to do. However the property name in the component mapping must match the name used in DFM. So open the DFM that contains TsmartkQuery and see what property name is used. It is not SQLDelete because that did not work. I may be SQLDelete.Strings or something similar.

Back To Top PM Private Upload Quote Reply

 Posted: Sat Aug 31st, 2019 11:16 am
PM Private Upload Quote Reply
btomljanovic
Member
 

Joined: Fri Aug 30th, 2019
Location: Croatia
Posts: 5
Status: 
Offline
I think the name is correct, export of component from Sisulizer (tried variants)
<component name="TSmartQuery" class="TVisHiddenComponent">
<property name="*.SQLInsert"/>
<property name="*.SQLInsert.Strings.*"/>
<property name="*.SQLRefresh.Strings.*"/>
<property name="SQLInsert"/>
<property name="SQLInsert."/>
<property name="SQLInsert.Strings.*"/>
<property name="SQLLock.Strings.*"/>
</component>

From DFM

object qry_faktura: TSmartQuery
KeyFields = 'BROJ_INT'
SQLInsert.Strings = (
'INSERT INTO FAKTURA_GLAVA'

' (BROJ_INT, BROJ, PUNKT, IZNOS, PRODAJNI, DAT_MJES, DATUM, DAT_' +
'GOD, PRIV_BROJ, GODINA, KORISNIK, DATUM_KNJIZI, DOMACA_VALUTA, P' +
'RODAJNA_VALUTA, PRODODNOS, EU, TIP)'
'VALUES'

' (:BROJ_INT, :BROJ, :PUNKT, :IZNOS, :PRODAJNI, :DAT_MJES, :DATU' +
'M, :DAT_GOD, :PRIV_BROJ, :GODINA, :KORISNIK, :DATUM_KNJIZI, :DOM' +
'ACA_VALUTA, :PRODAJNA_VALUTA, :PRODODNOS, :EU, :TIP)')
SQLUpdate.Strings = (
'UPDATE FAKTURA_GLAVA'
'SET'

' BROJ_INT = :BROJ_INT, BROJ = :BROJ, PUNKT = :PUNKT, IZNOS = :I' +
'ZNOS, PRODAJNI = :PRODAJNI, DAT_MJES = :DAT_MJES, DATUM = :DATUM' +
', DAT_GOD = :DAT_GOD, PRIV_BROJ = :PRIV_BROJ, GODINA = :GODINA, ' +
'KORISNIK = :KORISNIK, DATUM_KNJIZI = :DATUM_KNJIZI, DOMACA_VALUT' +
'A = :DOMACA_VALUTA, PRODAJNA_VALUTA = :PRODAJNA_VALUTA, PRODODNO' +
'S = :PRODODNOS, EU = :EU, TIP = :TIP'
'WHERE'
' BROJ_INT = :Old_BROJ_INT')
SQLRefresh.Strings = (

'SELECT BROJ_INT, BROJ, PUNKT, IZNOS, PRODAJNI, DAT_MJES, DATUM, ' +
'DAT_GOD, PRIV_BROJ, GODINA, KORISNIK, DATUM_KNJIZI, DOMACA_VALUT' +
'A, PRODAJNA_VALUTA, PRODODNOS, EU, TIP FROM FAKTURA_GLAVA'
'WHERE'
' BROJ_INT = :BROJ_INT')
SQLLock.Strings = (

'SELECT BROJ_INT, BROJ, PUNKT, IZNOS, PRODAJNI, DAT_MJES, DATUM, ' +
'DAT_GOD, PRIV_BROJ, GODINA, KORISNIK, DATUM_KNJIZI, DOMACA_VALUT' +
'A, PRODAJNA_VALUTA, PRODODNOS, EU, TIP FROM FAKTURA_GLAVA'
'WHERE'
' BROJ_INT = :Old_BROJ_INT'
'FOR UPDATE NOWAIT')
SQLRecCount.Strings = (
'SELECT Count(*) FROM ('
'SELECT * FROM FAKTURA_GLAVA'
''
')')
Session = csd_session
SQL.Strings = (
'SELECT g.tip,'
' g.broj_int,'
' g.broj,'
' g.punkt,'
' g.iznos,'
' g.prodajni,'
' g.dat_mjes,'
' g.datum,'
' g.dat_god,'
' g.priv_broj,'
' g.godina,'
' g.korisnik,'
' g.datum_knjizi,'
' g.domaca_valuta,'
' g.prodajna_valuta,'
' g.prododnos,'
' g.eu,'
' g.efta,'
' g.principal_valuta'
' FROM faktura_glava g'
' WHERE g.godina = :godina')
Left = 128
Top = 100
ParamData = <
item
DataType = ftUnknown
Name = 'godina'
Value = nil
end>
object qry_fakturaBROJ: TStringField
DisplayLabel = 'Broj'
DisplayWidth = 11
FieldName = 'BROJ'
Required = True
Size = 10
end
object qry_fakturaPUNKT: TStringField
DisplayLabel = 'Punkt'
DisplayWidth = 10
FieldName = 'PUNKT'
Required = True
Size = 10
end
object qry_fakturaIZNOS: TFloatField
DisplayLabel = 'Nab.Iznos'
DisplayWidth = 10
FieldName = 'IZNOS'
DisplayFormat = '#,##0.00'
end
object qry_fakturaPRODAJNI: TFloatField
DisplayLabel = 'Prodajni Iznos'
DisplayWidth = 10
FieldName = 'PRODAJNI'
DisplayFormat = '#,##0.00'
end
object qry_fakturaDAT_MJES: TDateTimeField
DisplayLabel = 'Mjese'#263'ni'
DisplayWidth = 18
FieldName = 'DAT_MJES'
end
object qry_fakturaDATUM: TDateTimeField
DisplayLabel = 'Datum ra'#269'una'
DisplayWidth = 18
FieldName = 'DATUM'
Required = True
end
object qry_fakturaDAT_GOD: TDateTimeField
DisplayWidth = 18
FieldName = 'DAT_GOD'
Required = True
end
object qry_fakturaPRIV_BROJ: TStringField
DisplayLabel = 'Int.Broj'
DisplayWidth = 10
FieldName = 'PRIV_BROJ'
Required = True
Size = 10
end
object qry_fakturaGODINA: TStringField
DisplayLabel = 'Godina'
DisplayWidth = 4
FieldName = 'GODINA'
Size = 4
end
object qry_fakturaBROJ_INT: TStringField
DisplayLabel = 'Int.Broj'
DisplayWidth = 22
FieldName = 'BROJ_INT'
Required = True
Visible = False
Size = 22
end
object qry_fakturaKORISNIK: TStringField
DisplayLabel = 'Izradio'
FieldName = 'KORISNIK'
end
object qry_fakturaDATUM_KNJIZI: TDateTimeField
DisplayLabel = 'Datum kjni'#382'enja'
FieldName = 'DATUM_KNJIZI'
end
object qry_fakturaDOMACA_VALUTA: TStringField
DisplayLabel = 'Doma'#263'a valuta'
FieldName = 'DOMACA_VALUTA'
Size = 3
end
object qry_fakturaPRODAJNA_VALUTA: TStringField
DisplayLabel = 'Prodajna valuta'
FieldName = 'PRODAJNA_VALUTA'
Size = 3
end
object qry_fakturaPRODODNOS: TFloatField
DisplayLabel = 'Prodajni te'#269'aj'
FieldName = 'PRODODNOS'
end
object qry_fakturaEU: TStringField
DisplayLabel = 'EU prodaja'
DisplayWidth = 10
FieldName = 'EU'
Size = 1
end
object qry_fakturaTIP: TStringField
DisplayLabel = 'Tip skladi'#353'ta'
FieldName = 'TIP'
Size = 1
end
object qry_fakturaEFTA: TStringField
FieldName = 'EFTA'
Size = 8
end
object qry_fakturaPRINCIPAL_VALUTA: TStringField
DisplayLabel = 'Nabavna valuta'
FieldName = 'PRINCIPAL_VALUTA'
Size = 12
end

Image with translation editor attached.
Boris

Attachment: Capture.PNG (Downloaded 3 times)

Back To Top PM Private Upload Quote Reply

 Posted: Sat Aug 31st, 2019 11:16 am
PM Private Upload Quote Reply
btomljanovic
Member
 

Joined: Fri Aug 30th, 2019
Location: Croatia
Posts: 5
Status: 
Offline
Component view

Attachment: Capture Component view.PNG (Downloaded 3 times)

Last edited on Sat Aug 31st, 2019 11:18 am by btomljanovic

Back To Top PM Private Upload Quote Reply

 Posted: Sat Aug 31st, 2019 02:06 pm
PM Private Upload Quote Reply
santra
Member
 

Joined: Thu Jun 2nd, 2016
Location:  
Posts: 6
Status: 
Offline
These are the component mapping settings you have to use in order to skip TSmartQuery.SQL property.

Attachment: ODAC.png (Downloaded 3 times)

Back To Top PM Private Upload Quote Reply

 Posted: Sat Aug 31st, 2019 03:43 pm
PM Private Upload Quote Reply
btomljanovic
Member
 

Joined: Fri Aug 30th, 2019
Location: Croatia
Posts: 5
Status: 
Offline
Unfortunately not working.
Guess I'll have to live with it.
Tx for trying.
Boris

Back To Top PM Private Upload Quote Reply

Current time is 12:52 am  
.NET, Delphi, ... - Sisulizer Localization Tool Support > Technical Support (You need to be registered at the forum to write) > Usage - Three simple steps to localize > How to import component (Devart ODAC)



WowUltra modified by Sisulizer Copyright © 2007-18 by Jim Hale - Based on WowBB Copyright © 2003-2006 Aycan Gulez

Impress - Privacy statement

Sisulizer software localization tool - Three simple steps to localize