|
|||
|
|||
| Moderated by: Renate.Reinartz, Markus.Kreisel, Jaakko.Salmenius, Ilkka.Salmenius |
|
|||||||||||||
| translation of a database - Usage - Three simple steps to localize - 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 ... | ||||||||||||||
| Author | Post | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||
|
ektoras Member
|
I use the trial version of Enterprise edition and I am trying to translate an access database (mdb) but since i am not really familiar with databases in general, i don't understand the procedure. I manage somehow to start a project with the wizard, but i don't see anything to translate! I click on the left tree window on the strings, but i don't see any strings to translate on the left. I don't know if the database is wrong, or i am doing something wrong. I tried the help files but it is not so detailed. Is there a tutorial that can help me?
|
|||||||||||||
| ||||||||||||||
| ||||||||||||||
|
Janusz Grzybek Super Moderator 
|
Hello, Together with Sisulizer application, Sisulizer Setup could to install some example projects (with source files) for different platforms, also for Access database. If you chosen examples installation during setup, you could to find in Sisulizer directory subdirectory named Database. This directory contains next subdirectories Country and Combined with included different variants of localization projects for Access database, for example Row, Field, Table. I suggest after opening these projects go to menu Project > Edit source. In opened properties dialog you could find in Items tab localization structure of your project for database. If you use right click on item you can to see context menu, where you could e.g. toggle localization for selected item or set up Index item. If you want create your first database localization project, I suggest using as source, sample databases included to Sisulizer Database subdirectory instead normal complicated database, because these sample files are very basic Access files, and for this reason are good examples to learning. On below screenshot you can to see Items tab contents for Sisulizer 2008\Database\Country\Table\Access.slp Janusz Attachment: screen.png (Downloaded 36 times)
____________________ http://www.sisulizer.com - Three simple steps to localize |
|||||||||||||
| ||||||||||||||
|
||||||||||||||
|
ektoras Member
|
Thanks for the reply, but i am missing some basic knowledge like, what is the id table, the language id, etc.. These things are not described in the manual for somenone that is not familiar with databases etc.. Is there a document that describes all these terms in detail? Or a step by step tutorial for these projects that you mentioned? I try to do what you proposed in the screenshot, and still didn't achieve anything.. Also, could you post a screenshot of how the translation sheet looks like from the example database ? Last edited on Fri Oct 10th, 2008 10:05 am by ektoras |
|||||||||||||
| ||||||||||||||
| ||||||||||||||
|
Markus.Kreisel Administrator 
|
Hi, there are many ways to localize a database. Perhaps we need to find out which of these are what you like to reach. Please read: http://www.sisulizer.com/localization/software/server-desktop-database.shtml and find out what result you need. Sisulizer supports:
Markus Attachment: 0128.JPG (Downloaded 32 times)
____________________ http://www.sisulizer.com - Three simple steps to localize |
|||||||||||||
| ||||||||||||||
|
||||||||||||||
|
khoonseang.kang Member
|
Trying to connect to Oracle database with Sisulizer Enterprise 2008, it does not have the radio button to "Clone Database" as shown in the image.
|
|||||||||||||
| ||||||||||||||
| ||||||||||||||
|
Markus.Kreisel Administrator
|
Hi, sorry, Database cloning is available only for those databases that use single database file such as Access and Interbase. If it is not supported for your database type you have to modify your database structure to make it localizable. You find more information here: http://www.sisulizer.com/online-help/DatabaseLocalization.htm Markus
____________________ http://www.sisulizer.com - Three simple steps to localize |
|||||||||||||
| ||||||||||||||
|
||||||||||||||
|
khoonseang.kang Member
|
Hi, Unfortunately due to some reason we cannot change the database schema. How about can Sisulizer create a kind-of lookup database that refers the legacy database as Foreign Key? We can do a one time translation of current data in legacy, and subsequently the application that allows user to enter data will have localization support. Thank you.
|
|||||||||||||
| ||||||||||||||
| ||||||||||||||
|
Markus.Kreisel Administrator
|
Hi, this would mean an additional logic for database localization in Sisulizer. Nothing we could implement shortly. I have to ask our R&D if there is something we can do in this case. Markus
____________________ http://www.sisulizer.com - Three simple steps to localize |
|||||||||||||
| ||||||||||||||
|
||||||||||||||
|
Markus.Kreisel Administrator
|
I just saw, that you can change the structure of your database because you say: >>How about can Sisulizer create a kind-of lookup database that refers the legacy database as Foreign Key? If you can have addition tables, then you could use Sisulizer's: Table Database Localization Method This method adds localized tables for those tables that you want to localize. The localized tables contain only the primary key and those fields that are localized. The result is written to new tables with the same structure. The database tables only have different names, like description and description_ja: (see http://www.sisulizer.com/localization/software/server-desktop-database.shtml) Perhaps that helps you? This does not need the clone option. The clone option is only needed if a complete localized copy of a database file is created. Markus
____________________ http://www.sisulizer.com - Three simple steps to localize |
|||||||||||||
| ||||||||||||||
| ||||||||||||||
|
khoonseang.kang Member
|
I was thinking of putting the translation in the database of my application. The master database was from the legacy system which we are not allowed to touch...not even creating some new tables  This is I was thinking: A table in my legacy, say, has country table, with all english name. When my application retrieve the values from legacy table, it do a lookup from a application localization database, with the country name as well as the language as the key. Does that make sense? Doable with Sisulizer?
|
|||||||||||||
| ||||||||||||||
|
||||||||||||||
|
Markus.Kreisel Administrator
|
How about synchronizing your Oracle database with some local database (e.g. Access) and then localize that local database without the restrictions of your master database? Markus
____________________ http://www.sisulizer.com - Three simple steps to localize |
|||||||||||||
| ||||||||||||||
| ||||||||||||||
|
khoonseang.kang Member
|
How about the translation memory? Can I use it as "application" translation database?
|
|||||||||||||
| ||||||||||||||
|
||||||||||||||
|
Markus.Kreisel Administrator
|
Hmmm, you mean, that you query the tables of the TM yourself at runtime of your application? Yes, that would be possible at the moment. But there are problems guaranteed. Our TM format has to change in near future for new features, e.g. unlimited field size. Markus
____________________ http://www.sisulizer.com - Three simple steps to localize |
|||||||||||||
| ||||||||||||||
| Current time is 01:00 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) > Usage - Three simple steps to localize > translation of a database | |
Sisulizer software localization tool - Three simple steps to localize
