Welcome, Guest
Username: Password: Remember me

TOPIC: Merging localized text from a 3rd party

Merging localized text from a 3rd party 1 week 16 hours ago #2433

  • miked
  • miked's Avatar
  • Offline
  • New Member
  • Posts: 3
  • Karma: 0
What's the recommended way to merge localized text (CSV) from a 3rd party for which the loc keys match but the ordering of the rows doesn't? Does I2 directly provide a way to match the keys between two sources and merge into the google spreadsheet column? In this case I have an entire new language (column) I need to bring into the main spreadsheet, but don't want to manually splice it in, and can't rely on the ordering for copy/paste.

Thanks,
Mike

P.S. I've tried the "Merge Sheets" add on for Google Sheets and it just hangs forever.
The administrator has disabled public write access.

Merging localized text from a 3rd party 6 days 20 hours ago #2436

  • Frank
  • Frank's Avatar
  • Offline
  • Administrator
  • Posts: 853
  • Thank you received: 185
  • Karma: 55
Hi,
The easiest way is to open I2Languages.prefab, then go to Spreadsheets tab, and Import CSV (Replace). Do that for the first CSV.
Then, click Import CSV (Merge) with the second spreadsheet.

That will merge all the localization data into the I2Languages.prefab. Then, click Google, Export (Replace) to upload all the data into Google Spreadsheet.

If that doesn't work for you, can you please, email me two of the CSV that are giving you issues. I could take a look and let you know what's wrong.
Hope that helps,
Frank
Are you :-) Give I2L 5 stars!
Are you :-( Please lets us know how to improve it!
To get the betas as soon as they are ready, check this out
The administrator has disabled public write access.

Merging localized text from a 3rd party 6 days 18 hours ago #2437

  • miked
  • miked's Avatar
  • Offline
  • New Member
  • Posts: 3
  • Karma: 0
So in theory that should automatically handle gaps in the rows and the key/row ordering being different between the two sources? For example our main google doc looks something like this:

Keys:
key_1
key_2
key_3
key_6
key_4

(key_5 has been removed after we submitted for translation, and the ordering of key_4 and key_6 changed)

and the csv we're getting back from the translator is like this:
key_2
key_4
key_5 (no longer in our main document and we won't need it)
key_6
The administrator has disabled public write access.

Merging localized text from a 3rd party 6 days 18 hours ago #2438

  • Frank
  • Frank's Avatar
  • Offline
  • Administrator
  • Posts: 853
  • Thank you received: 185
  • Karma: 55
Yes,
Import (Merge) handles missing terms, new terms, new Languages and Terms.

Basically, when you import as Merge, what the code does, is that it reads the CSV, finds the languages, and creates anyone that is new.
Then, it goes through all of the terms in that CSV and finds the corresponding term in the current source.
If it finds a term with that name, then it modifies the translations to match the CSV file, otherwise, it creates a new term and fills the translations.

That way, it doesn't matter the order of the terms, or even if not all terms are merged, or if there are new terms/languages.

Hope that helps,
Frank
Are you :-) Give I2L 5 stars!
Are you :-( Please lets us know how to improve it!
To get the betas as soon as they are ready, check this out
The administrator has disabled public write access.

Merging localized text from a 3rd party 6 days 18 hours ago #2439

  • miked
  • miked's Avatar
  • Offline
  • New Member
  • Posts: 3
  • Karma: 0
Ok, now to be clear, here's the interface I see in the prefab, attached. Clicking Import (any type) seems to just load the google sheets doc, which is our master file that I want to update with a separate CSV provided via email. I don't see an option to import CSV. (And frankly I'm scared to just poke around with a live document used by many people, so I haven't played with all the buttons). Is importing a CSV a step hidden behind one of those "Open" or "New" buttons?

Thanks for the help!
The administrator has disabled public write access.

Merging localized text from a 3rd party 6 days 18 hours ago #2440

  • Frank
  • Frank's Avatar
  • Offline
  • Administrator
  • Posts: 853
  • Thank you received: 185
  • Karma: 55
Hi,
Yes, that's the right Spreadsheet section, but in there you can find 2 tabs, one for Local spreadsheets (CSV) and one for Google (Google Spreadsheets).

If you select the Local tab, then you wont be modifying any of the Google Spreadsheets.

Are you :-) Give I2L 5 stars!
Are you :-( Please lets us know how to improve it!
To get the betas as soon as they are ready, check this out
The administrator has disabled public write access.
Time to create page: 0.093 seconds
Colors