Native functions called by sisulizer? - Wish list for software localization tool - Technical Support (You need to be registered at the forum to write) - .NET, Delphi, ... - Sisulizer Localization Tool Support

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.

Not logged in - Login | Register

.NET, Delphi, ... - Sisulizer Localization Tool Support > Technical Support (You need to be registered at the forum to write) > Wish list for software localization tool > Native functions called by sisulizer?

Moderated by: Renate.Reinartz, Markus.Kreisel, Jaakko.Salmenius, Ilkka.Salmenius

Printer Friendly

Native functions called by sisulizer? - Wish list for software localization tool - Technical Support (You need to be registered at the forum to write) - .NET, Delphi, ... - Sisulizer Localization Tool Support

Author

Post

Posted: Fri Oct 9th, 2009 09:16 am

WolfgangE
Member

Joined:	Fri Oct 9th, 2009
Location:
Posts:	8
Status:	Offline

Hi.

During our evaluation period with several translation-applications we have found, that your tool seems to be a good solution for our tasks.

The only difficulty we have found is, that we need to translate parts of a xml-content inside some database (MS-Access) fields.

I will show you a simplified example.
Inside our database there exists a table with a description-field ("normal" text) and a memo-field, containing the xml-content. The other fields do not have anything to do with the translation-process.
The translation of the description-field is no problem. But the content of the memo-field looks as follows:

<P>
<C>
    <CO ID="13" V="" In="0" N="OuCom" D="Aussen über Common" PR="24" DT="21" K="1" />
    <CO ID="16" V="" In="0" N="StartupCom" D="Startup über Common" PR="37" DT="21" K="1" />
</C>
<Las>
    <N La="0">Sup1st</N>
    <D La="0">Startup01 Master</D>
    <CO ID="13">
      <N La="0">OuCom</N>
      <D La="0">Aussen über Common</D>
    </CO>
    <CO ID="16">
      <N La="0">StartupCom</N>
      <D La="0">Startup über Common</D>
    </CO>
</Las>
</P>

You see, there are some strings (the german ones) which must be translated.
Moreover, if the content of this field exceeds the maximum size of the memo-field, it will be splitted into two or more parts. All other parts except the first one are stored in another table.

Therefore, I have the following question:
We have some .Net-classes which scan the whole content of such fields and return all of the texts to be translated. Also we have the opposite function, which writes back the tranlated texts into the field(s).
Is it possible to call such native functions from your tool, during the load (and store) process?
Or do you have any other ideas which could solve this problem?

Best regards
Wolfgang

Posted: Fri Oct 9th, 2009 12:11 pm

Jaakko.Salmenius
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Espoo, Finland
Posts:	2275
Status:	Offline

The current version can not handle DB data as XML but I will implement it. It will be in the next build 292 that will come out next week.

Jaakko

____________________
http://www.sisulizer.com - Three simple steps to localize

Posted: Fri Oct 9th, 2009 12:56 pm

Jaakko.Salmenius
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Espoo, Finland
Posts:	2275
Status:	Offline

The next version can scan single fields as XML data. However the feature you suggested (e.g. calling fucntion that combines data from several tables) is a bit difficult.

Why don't you store that XML data in a singel field. Is it because it is just too big.

Another question. Is the structure of the XML data always the same.?

What DB localization method do you use? Fields, table to row-localization.

Can you upload a sample Access fiel to me. Click Private Upload to send it to me.

Jaakko

____________________
http://www.sisulizer.com - Three simple steps to localize

Posted: Fri Oct 9th, 2009 01:02 pm

WolfgangE
Member

Joined:	Fri Oct 9th, 2009
Location:
Posts:	8
Status:	Offline

Hi Jaakko.

Thank you very much for your quick reply.
Your answer makes me happy and the news is good because this would solve our last remaining problem.

Wolfgang

Posted: Fri Oct 9th, 2009 02:00 pm

WolfgangE
Member

Joined:	Fri Oct 9th, 2009
Location:
Posts:	8
Status:	Offline

Hi Jaakko.

We store the field-content in different db-fields, because the content is too big. There may be fields with more than 10.000 Bytes.

The structure of the xml-contents differs, because we have different fields with different meanings.

In this special case (for this database) I don't know the right name of the method. In german, the localization-method is "Kopie der Originaldatenbank erstellen". I hope this helps.

I will prepare you an example database, but I'm sorry that I can do it not before monday, because at 16:00 I have a meeting before our weekend.

Wolfgang

Posted: Fri Oct 9th, 2009 02:08 pm

Markus.Kreisel
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Bedburg, Germany
Posts:	1815
Status:	Offline

Hi,

"Kopie der Originaldatenbank erstellen" => Database Clone

Markus

____________________
http://www.sisulizer.com - Three simple steps to localize

Posted: Mon Oct 12th, 2009 07:27 am

WolfgangE
Member

Joined:	Fri Oct 9th, 2009
Location:
Posts:	8
Status:	Offline

Hi Jaakko,

now I have finished the example database for you.
For a xml-field which is continued, you can take a look at the table "UserBaustein_Ub" and there the record with the guid="13BC4412...". This one has two following records in the table "AdditionalParameter_Ap". The order of them is given by the field "iOrder".
The table "AdditionalInternalParameter_Ip" is another example. Here are some records (xml-fields), which also belong to another item in the tables "UserBaustein" or "Plan". But these one represent xml-fields, which are not continued from the content of the source table.
I hope that you can understand my description.

Wolfgang

Posted: Mon Oct 12th, 2009 07:44 am

Jaakko.Salmenius
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Espoo, Finland
Posts:	2275
Status:	Offline

Hi Wolfgang

Thank you for the file. I got your point.

Sisulizer now has ability to parse DB data as XML or HTML. I implemented it. However the data must be in a single field. You have the data in several fields and even in several tables. I would be quite difficult to build in a direct support for this in Sisulizer. This is why we should use your DLL that reads data as single entity. Can you tell me about it.

Is it a native or .NET DLL?

What is the interface (e.g. functions) that it contains.

You can send a reply as private message as well.

Jaakko

____________________
http://www.sisulizer.com - Three simple steps to localize

Posted: Mon Oct 12th, 2009 07:55 am

Jaakko.Salmenius
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Espoo, Finland
Posts:	2275
Status:	Offline

One more question? Is it always so that when you have these extension tables the primary key field(s) and the data field names are the same.

In your sample there is primary key guidID in UserBaustein_Ub. The data is in strParameter. The extension are also in strParameter fields in AdditionalParameter_Ap and the table has the primary key values are the same as in the main table.

If this is the case we can implement a direct support without calling any DLLs

Jaakko

____________________
http://www.sisulizer.com - Three simple steps to localize

Posted: Mon Oct 12th, 2009 03:00 pm

WolfgangE
Member

Joined:	Fri Oct 9th, 2009
Location:
Posts:	8
Status:	Offline

Hi Jaakko,

sorry for the long time for my respond, but on Friday I got mails if there was a new entry, today not. So I haven't looked inside the forum until now.
To your questions:
1. Our dll is a .net-dll. The interface would be no problem, because we can write arbitrary functions. They can performed on your wishes.
2. In our database-structure the primary-keys are always the same over the tables. These are always Guids, which are the same in the main and the other (extension) table. We need such unique keys in our application to get the access to the right records (fields).
With the name of the fields (strParameter) I'm not sure yet, I think they are the same, but it's possible that they differ. If this would be a problem, I will make a deeper analysis of our tables to give you the right answer.

Wolfgang

Posted: Mon Oct 12th, 2009 03:04 pm

Jaakko.Salmenius
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Espoo, Finland
Posts:	2275
Status:	Offline

There is no need for DLLs. I will implement a direct support for data that spans over multiple fields or tables. This will take few days. I let you know when you can test it.

Jaakko

____________________
http://www.sisulizer.com - Three simple steps to localize

Posted: Mon Oct 12th, 2009 03:18 pm

WolfgangE
Member

Joined:	Fri Oct 9th, 2009
Location:
Posts:	8
Status:	Offline

Hi Jaakko,

Great!
I will wait until you have performed the changes.

Wolfgang

Posted: Fri Feb 26th, 2010 08:28 am

Jaakko.Salmenius
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Espoo, Finland
Posts:	2275
Status:	Offline

Hi

The current build (299) has this feature. Take a look at <sisulizerdir>\Database\Extended\Close directory. It contains an Access db that has Country table where Description field contains extended data. Data that does not fit into the Description field is stored in the Extended table.

The following screenshot shows how to configure Sisulizer to read data from extended table.

Sisulizer's online help contains "Database Localization" topic that also contains information about extended fields.

Jaakko

Attachment: Untitled.png (Downloaded 23 times)

____________________
http://www.sisulizer.com - Three simple steps to localize

Posted: Fri Feb 26th, 2010 10:44 am

WolfgangE
Member

Joined:	Fri Oct 9th, 2009
Location:
Posts:	8
Status:	Offline

Hi Jaakko,

thank you very much for your great work.
I will take a look at this new version.

Best regards
Wolfgang

Posted: Mon Mar 1st, 2010 02:47 pm

Jaakko.Salmenius
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Espoo, Finland
Posts:	2275
Status:	Offline

Hi Wolfgang,

Can you send me your Access table. Use the Private Upload button. Send me the database and some instructions what field(s) you tried to drag and drop.

Jaakko

____________________
http://www.sisulizer.com - Three simple steps to localize

Posted: Thu Mar 4th, 2010 10:11 am

Jaakko.Salmenius
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Espoo, Finland
Posts:	2275
Status:	Offline

Thank you for the file. I found the bug. Sisulizer failed to D&D if you had scrolled the table view. I fixed this in build 301.

I also implemented feature that will automatically detect you tables. You have Windows language id as number appened to the field name. Now Sisulizer ask what is the original field and then moves all other localized fields underneath the original one.

New build will come out later this week.

Jaakko

____________________
http://www.sisulizer.com - Three simple steps to localize

Posted: Thu Mar 4th, 2010 10:40 am

WolfgangE
Member

Joined:	Fri Oct 9th, 2009
Location:
Posts:	8
Status:	Offline

Hi Jaakko,

thank you for fixing this.
I'll try out the new build.

Best regards
Wolfgang

Current time is 06:26 pm
.NET, Delphi, ... - Sisulizer Localization Tool Support > Technical Support (You need to be registered at the forum to write) > Wish list for software localization tool > Native functions called by sisulizer?

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

Sisulizer software localization tool - Three simple steps to localize