• State Suggested Answer
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 64 subscribers
  • Views 962 views
  • Users 0 members are here
Options

How2: Translate a SQLite DB (*.sq3)

Alexander Sailer

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: 

  • Generall Q: Is the translation of an SQLite (.sq3) source possible? 
    if yes:
    • How2 correct add the .sq3 file as an source? 
    • what settings are needed for the 'file parser'?
    • what settings are needed for the 'file parser'?

TIA 

Alexander Sailer
emoji
Rate translation
×
Suggest better translation
×
  • 0

    Passolo cannot handle a database using a file parser, as databases might not be stored physically as a file. To import translatable data from databases, you need to have a licensed version of the Database / Excel parser add-in. In addition, you need an OLE DB driver for SQLite installed on your system. The Passolo database add-in then will access your database as a data source using ODBC technology, and you can select which tables / columns should be imported for translation.

    I used the database add-in to connect to various database technologies, it might be tricky to find an appropriate ODBC driver and to find out if the SQL statements that will be created are completely compatible with the database technology. If you could send a small example SQ3 file by email, I would be able to test it.
    emoji
  • 0 in reply to Achim Herrmann

    THX 4 help.

    I think it will take about 2-3 weeks before I can send you a sample.  

    Regarding the licensed version of the Database / Excel parser add-in: We are using for about 10 years an add-in for a MS-Access data base. Is this enough to access an SQ3 file? 
    emoji
  • 0 in reply to Alexander Sailer

    Yes, when already using it for MS-Access, you have the database add-in available and properly licensed. So now we have to check, if it properly works for SQLite. Please contact me, if you have a sample file.
    emoji
  • 0 in reply to Achim Herrmann

    Dear Mr. Herrmann, 

    Due to the maintainability and clarity of the content, we decided against an SQLite database.
    Thank you very much for your help
    This request is now closed for me.

    Kind regards
    Alexander Sailer
    emoji
  • 0

    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.
    emoji