How to handle regular change to localization from Sheet Service on a larger scale?

Unity Engine
, ,
1

Hello,

I have a game in Early access and I’m looking for way to make the localization easier.
Currently I’m using Google sheet to push and pull the different translations. But it started to get a bit messy with the number of locales raising with time.

So as of now each time there was an update of the game I would go to all String Table Collection, check each Extension and push the english mapped column, then pull the translated locale column to get the translation. This way I could push the new change to the sheet for my translators and pull their last version of the translation. The problem is this is taking a lot of time and it is really easy to have a human mistake and do a pull before a push thus erasing all the change from the current table.

I’m wondering if there would be a way to automate all of this. I tried to do my own script but I don’t really know how can I change and call function to the CollectionExtension of the StringTableCollection class.

Any help is welcome!

Also 2 other small questions :
Is there a way to automatically set LocalizedString to Smart? It is really annoying to have to go on each string for each locale and click on the smart toggle.

Maybe this is the wrong place to ask but in Google sheet I can see the version history and the changes made compared to last version but it says everything changed even if that’s not the case, a bit like if the push from unity would erase everything and rewrite the same data. This is problematic because it would have been a great way to notice my translators when a previously translated string changed.

2

Hi,

We have some sample code to show how to do this here.

You can do this in script.
I also recently created a custom google sheet custom column that can be used to enable/disable it for all entries.
https://gist.github.com/karljj1/17938907c2068223e33a07e127a06849

When we do a push we do a complete push of everything, not the changed items. So we are erasing everything.

There’s 2 reasons for this:

  1. it is hard to figure out what has changed since the last push. We don’t know if the sheet was changed since.
  2. It’s faster. Sending lots of small changes for selected cells is much slower than sending a big single update. It takes longer to figure out what changed and the json that gets sent in the update can be slower to process and larger when its sent.

It would be nice if Google sheets was able to detect if a cell didn’t actually change during the update though. Ill make a task for us to look further into this, maybe there’s something we can do.

3

As always thank you for the fast response, the support is really good! I will look into these and send another message if I have more questions.

1 Like