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

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
×
Parents
  • 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
Reply
  • 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
Children