|
|||
|
.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 localize table with multiple language entries
|
|
|||
|
.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 localize table with multiple language entries
|
| Moderated by: Renate.Reinartz, Markus.Kreisel, Jaakko.Salmenius, Ilkka.Salmenius |
|
||||||||||||||||
| How to localize table with multiple language entries - Usage - Three simple steps to localize - Technical Support (You need to be registered at the forum to write) - .NET, Delphi, ... - Sisulizer Localization Tool Support | |||||||||||||||||
| Author | Post | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||
|
karsara Member
|
Dear support team, our company would like to buy your product, but we have to be sure it is usable for our needs. Therefore I need your help. Using SQL Server database, I have table with primary key ( ID and IDlanguage ) with German and English entries. When I create new project, select database, select table to localize, there is IDlang field, and I select the original language. After finishing project wizard I get a strange result. Please see the attached pic. The result I need is: in Original column all German entries and in English column all English entries from my table. Can you tell me exact steps how to do this, please? Thank you in advance for your reply. Attachment: Sisulizer.png (Downloaded 20 times)
|
||||||||||||||||
| |||||||||||||||||
| |||||||||||||||||
|
Markus.Kreisel Administrator 
|
Hi, Sounds like the "Field Database Localization Method" (http://www.sisulizer.com/localization/software/server-desktop-database.shtml) is what you are looking for, correct? Your shot looks like you have the "Row Database Localization Method" right now. Markus
____________________ http://www.sisulizer.com - Three simple steps to localize |
||||||||||||||||
| |||||||||||||||||
|
|||||||||||||||||
|
Markus.Kreisel Administrator
|
Btw: Here is the section in the manual how to prepare your database for Field localization: http://www.sisulizer.com/online-help/DatabaseLocalization.shtml#FieldLocalization Hope this helps Markus
____________________ http://www.sisulizer.com - Three simple steps to localize |
||||||||||||||||
| |||||||||||||||||
| |||||||||||||||||
|
Ilkka.Salmenius Administrator 
|
karsara wrote: Using SQL Server database, I have table with primary key ( ID and IDlanguage ) with German and English entries. Your database seems just right for localization. Unlike Markus told you do not use "Field localization" but recommend "Row localization". For some reason Sisulizer does not correctly read the database sturcture and this is why your result is incorrect. What you need to have is a primary key that combined LanguageId and Id. Something like this CREATE TABLE Sample ( LanguageId VARCHAR(10) NOT NULL, Id INTEGER NOT NULL, Text VARCHAR(50) NOT NULL, PRIMARY KEY(LanguageId, Id) ); Can you give me the SQL script that defines your table? Best regards, Ilkka
____________________ http://www.sisulizer.com - Three simple steps to localize |
||||||||||||||||
| |||||||||||||||||
|
|||||||||||||||||
|
karsara Member
|
Hi Ilkka, this is the script: CREATE TABLE [dbo].[Table_1]( [LanguageID] [nvarchar](50) NOT NULL, [ID] [nvarchar](50) NOT NULL, [Text] [nvarchar](max) NOT NULL, CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED ( [LanguageID] ASC, [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
|
||||||||||||||||
| |||||||||||||||||
| |||||||||||||||||
|
Ilkka.Salmenius Administrator
|
Your table structure is correct. Sisulizer reads it correctly. I guess the problem is the original language. Make sure that you select German as original language when you create a new project. Add English as target language. See the screenshot. Best regards, Ilkka Attachment: Untitled.png (Downloaded 16 times)
____________________ http://www.sisulizer.com - Three simple steps to localize |
||||||||||||||||
| |||||||||||||||||
|
|||||||||||||||||
|
karsara Member
|
Hi Ilkka, of course I have selected German language as the source language. Isn't there a possibility to have a TeamViewer session with you, please?
|
||||||||||||||||
| |||||||||||||||||
| Current time is 05:43 pm | |
| .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 localize table with multiple language entries | |
Sisulizer software localization tool - Three simple steps to localize
