Support forum of the software localization tool Sisulizer


Localization Tool for VB, Delphi, .NET, C#, VB.NET, XML, Online Help, HTML ... 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: Renate.Reinartz, Markus.Kreisel, Jaakko.Salmenius, Ilkka.Salmenius
New Topic Reply Printer Friendly
Sisulizer looses database fields configuration - Bugs and Quirks in Sisulizer - Technical Support (You need to be registered at the forum to write) - Localization Tool for VB, Delphi, .NET, C#, VB.NET, XML, Online Help, HTML ...
AuthorPost
 Posted: Tue Nov 11th, 2008 06:57 pm
PM Quote Reply
Matthew
Member
 

Joined: Mon Nov 10th, 2008
Location:  
Posts: 6
Status: 
Offline
We created a Sisulizer project with the 271 build of Sisulizer. One Subproject was a connection to a SQL-Database on a server. Some fields in some tables have a scheme like this: Name_DE, Name_EN, Name_FR. The Name_DE field holds some text in German (our original language), Name_EN and Name_FR the English and French translations. The initial assignement of the fields was very cumbersome due to the following reasons:

Every table that includes a string is presented in the configuration menu for the database and has to be exluded from the configuration by clicking with the mouse or if we choose to include some of the fields we had to drag the Name_EN and Name_FR under the Name_DE. I had to exclude some hundred tables and only include about 20. This was really a tedious work (especially since the Dialog in which this has to be done cannot be resized!).

After I did this once, I thought I would never have to do this again. But after our first change of the database, Sisuzlizer lost the complete configuration! So I have to do this work again?

Is there a possibility to configure the fields and tables by means of a script or any other automated way?

 

Back To Top PM Quote Reply

 Posted: Tue Nov 11th, 2008 07:37 pm
PM Quote Reply
Matthew
Member
 

Joined: Mon Nov 10th, 2008
Location:  
Posts: 6
Status: 
Offline
Furthermore: If I try to repair the configuration (with Sisulizer build 274) this configuration is accepted by Sisulizer without an error but is not stored, i.e. when I look into the properties of the database project the configuration is lost. I can not repair this project!

Back To Top PM Quote Reply

 Posted: Wed Nov 12th, 2008 09:07 am
PM Quote Reply
Matthew
Member
 

Joined: Mon Nov 10th, 2008
Location:  
Posts: 6
Status: 
Offline
Meanwhile I made some experiments with Sisulizer build 274:
During the database field configuration there is no need to disable tables without translatable fields, this is a great improvement.
The configuration even works but cannot be changed. When reentering the configuration all previous inputs are lost. This bug can reproduced with a new project: Configure a sql database project by dragging localized fields (e.g. Name_EN) as child fields of the original fields (e.g. Name_DE), accept the configuration and leave the configuration mode. When reentering the configuration mode, all changes are lost, that is the child fields are again in the same flat hierarchy level as the original fields.

Back To Top PM Quote Reply

 Posted: Wed Nov 12th, 2008 10:31 am
PM Quote Reply
Markus.Kreisel
Administrator


Joined: Sat Apr 8th, 2006
Location: Bedburg, Germany
Posts: 829
Status: 
Offline
Hi Matthew,

in the moment we are exhibiting at the Tech-Ed EMEA in Barcelona and do not have access to a SQL-Server test system.

Perhaps there is one helpful hint you could try until we have the ability to get further into it. The Sisulizer project file is a XML file. It might be faster if you add your database with all fields, save you .slp and then try to adapt the .slp (a XML file) e.g. in Notepad. I've not tested that from here while I've not database server on my laptop. But it might worth a try for a quick solution.

Markus



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

 Posted: Wed Nov 12th, 2008 02:02 pm
PM Quote Reply
Matthew
Member
 

Joined: Mon Nov 10th, 2008
Location:  
Posts: 6
Status: 
Offline
Hi Markus,

thanks a lot for this tip! By changing the content of the project file I'm able to retain my previous changes and it is really a piece of cake to configure the database fields in the xml-code. I am really happy with this solution. As far as I'm concerned you don't need to reproduce my configuration error.

Although I have some questions concerning the necessary xml attributes:

A Part of the xml file looks like this:










May I remove the table ="dbo.ManuProcessStepClasses"
and the field "DIN" which have no translations?
May I remove the xml-attribute id="ParentId" in the first table?
Does the attribute 'method="dlField"' indicate a translatebale table?

Please feel free to answer any time you like, I am not in a hurry any more.

Thanks again and good success at the Tech-Ed,

Matthew

Back To Top PM Quote Reply

 Posted: Wed Nov 12th, 2008 02:07 pm
PM Quote Reply
Matthew
Member
 

Joined: Mon Nov 10th, 2008
Location:  
Posts: 6
Status: 
Offline
The copied xml-code didn't show in the previous message, so I type it here:




Back To Top PM Quote Reply

 Posted: Wed Nov 12th, 2008 02:11 pm
PM Quote Reply
Matthew
Member
 

Joined: Mon Nov 10th, 2008
Location:  
Posts: 6
Status: 
Offline
As xml-code won't show at all, I try to type it without the brakets:

table name="dbo.ManuProcesses" method="dlField" id="ParentId"
field name="DIN"/
field name="ImageHash"/
field name="Name_DE"
field name="Name_EN" lang="en"/
field name="Name_FR" lang="fr"/
/field
field name="Number"/
/table
table name="dbo.ManuProcessStepClasses"/

Back To Top PM Quote Reply

 Posted: Wed Nov 12th, 2008 02:33 pm
PM Quote Reply
Markus.Kreisel
Administrator


Joined: Sat Apr 8th, 2006
Location: Bedburg, Germany
Posts: 829
Status: 
Offline
Hi Matthew,

we do not recommend to edit the XML in general. Sometimes it is just the faster way if you need to change many entries in a batch with search and replace. And sometimes it is a nice workaround if the editor denies something that should be possible.

Here at support we do not have a documentation for the .slp where I find out what you changes you ask for may cause. Perhaps you make a copy of the .slp and find out if SL is going to like it. But my advice would be to not stress the system too much until we find the reason why the editor could not save the needed settings :-)

Markus



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

Current time is 12:46 am  
Localization Tool for VB, Delphi, .NET, C#, VB.NET, XML, Online Help, HTML ... > Technical Support (You need to be registered at the forum to write) > Bugs and Quirks in Sisulizer > Sisulizer looses database fields configuration



WowUltra 1.11 Copyright © 2007 by Jim Hale - Based on WowBB Copyright © 2003-2006 Aycan Gulez

Sisulizer software localization tool - Three simple steps to localize