Hello community,
I'm have a SQLite data base (.sq3) and should translate it in several target language. I'm able to add this .sq3 file to the 'sources' but I'm not able to read out any data.
The following questions I'm not able to answer:
TIA
Alexander Sailer
Translating SQLite (.sq3) Files:
Extract Text:
Use an SQLite tool like DB Browser for SQLite.
Query translatable text with SELECT id, text FROM table_name.
Export .csv, .xml, or .xliff.
Add File to CAT Tool:
Import the exported file into your CAT tool.
Set the correct parser (CSV/XML) and define the translatable fields.
Translate:
Translate the file in your CAT tool and export the target file.
Reimport Text:
Use the SQLite tool to re-import translated text back into the database.
Assure that the structure is identical to the original.
This way, it keeps the database intact but allows translation.
Translating SQLite (.sq3) Files:
Extract Text:
Use an SQLite tool like DB Browser for SQLite.
Query translatable text with SELECT id, text FROM table_name.
Export .csv, .xml, or .xliff.
Add File to CAT Tool:
Import the exported file into your CAT tool.
Set the correct parser (CSV/XML) and define the translatable fields.
Translate:
Translate the file in your CAT tool and export the target file.
Reimport Text:
Use the SQLite tool to re-import translated text back into the database.
Assure that the structure is identical to the original.
This way, it keeps the database intact but allows translation.
Translate
