How2: Translate a SQLite DB (*.sq3)

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