My Community

Please login or register.

Login with username, password and session length
Advanced search  


My Time at Portia enters Early Access on Jan 23rd 2018!

Author Topic: SQL command for auto-translation of repeated words[marked]  (Read 588 times)


  • Colonist
  • **
  • Karma: 2
  • Posts: 76
    • View Profile
SQL command for auto-translation of repeated words[marked]
« on: January 07, 2017, 12:42:41 PM »

This command that can be used in DB browser for SQLite in the tab "Execute SQL" can be very useful to translate words repeated in the translation file. First the English column must be duplicated and renamed as your translated language. Do also a backup of the file.

Code: [Select]
UPDATE translation SET language = replace( language, "OriginalString", "TranslatedString");

For Example, to translate IN ALL CELLS the string "Buying price:" in "Prezzo di Acquisto:" (italian translation) you can use this command:

Code: [Select]
UPDATE translation SET italiano = replace( italiano, "Buying price:", "Prezzo di Acquisto:");

I hope this can be useful to speed up all other translations! :)
« Last Edit: January 09, 2017, 05:48:31 AM by Dorist1 »


  • Enlistee
  • *
  • Karma: 0
  • Posts: 2
    • View Profile
Re: SQL command for auto-translation of repeated words
« Reply #1 on: January 07, 2017, 05:31:56 PM »

You are a Saint! Thank you!
I've logged in to complain about how hopeless it is to try and translate this game from scratch.
It really needs a cleanup, there are some strings that are clearly unused since early alpha.