Welcome, Guest
Username: Password: Remember me

TOPIC: Spreadsheet not exporting in 'Last modified' order

Spreadsheet not exporting in 'Last modified' order 2 months 2 hours ago #2512

  • jimmyt3d
  • jimmyt3d's Avatar
  • Offline
  • Senior Member
  • Posts: 44
  • Thank you received: 1
  • Karma: 1
Hi Frank,

When exporting to Google spreadsheet, the resulting spreadsheet has always been ordered in the order in which the keys were created in the plugin.
This has always worked really well for me, as a lot of the keys has been translated in the order they were made so it made it very easy to have all the new, untranslated text in a block at the bottom.
Also, this is the order the spreadsheet was in when I sent it away for translation.

Today I have set up a new Google account and set up a new webservice etc, now when I export the same keys to the new sheet, they all appear in alphabetical order, which is completely different from the order I need it to be in.

Can you advise how to get it back into 'Last modified' order?

v2.7.0f1 - Unity 5.3.5

Thanks
Last Edit: 2 months 2 hours ago by jimmyt3d. Reason: Updated info.
The administrator has disabled public write access.

Spreadsheet not exporting in 'Last modified' order 1 month 4 weeks ago #2513

  • Frank
  • Frank's Avatar
  • Offline
  • Administrator
  • Posts: 915
  • Thank you received: 196
  • Karma: 58
Hi,
Can you please update to 2.8.0f2? (its now in the AssetStore).

I tried Importing from google and then exporting back, and the order is kept as it was (no sorting). Some versions ago I stopped sorting automatically in order to speed up the import/export with google. Although I don't remember it that was in 2.7.0 or before it.

Said that, exporting to Google Spreadsheet doesn't sort, but exporting to CSV (local file) does apply sorting to make the spreadsheet easier to manage. If you want to disable that behavior (for local spreadsheets), you can comment the sorting code at Assets\I2\Localization\Scripts\Google\LanguageSource_Export_CSV.cs
line 110-117

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.
Time to create page: 0.226 seconds
Colors