Export to Google Issues

More
4 years 8 months ago #324 by Frank
Replied by Frank on topic Export to Google Issues
Hi,
I tested the csv files and prefab and coudn't find anyway to make it missbehave.

I tried the following steps:
1- Imported the I2_Exported.csv into the LanguageSource.
2- Exported the source into google using Replace
3- Verified that the spreadsheet in google gives the exact result than importing the Google CSV you sent me.

4- Added a new key to the source in unity
5- Filled the English section
6- Exported to Google using Add New
7- Verified that the new key was only on the English section and no other term was modified.

8- Created a new term in google, filled all fields with 1, 2, 3, 4
9- From unity, imported with Add New
10- Verified that the numbers were in the correct language

The differences you see on the CSV file exported from Google and the one exported directly from the language Source are because while in google, I convert the Term type (e.g. Text) and Term Description into Notes added to the Term's first column.

Can you please list me the steps you do from the examples you sent me to reproduce a missbehavior?

Thank,
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

Please Log in or Create an account to join the conversation.

More
4 years 8 months ago - 4 years 8 months ago #326 by dchau_hh
Replied by dchau_hh on topic Export to Google Issues
Hi Frank,

I just reproduced it with these steps...
- Created new project

- Imported I2 V2.3.0 package

- In the Global Resource:
  * Added 3 Languages:
     1. English (US)
     2. Afrikaans
     3. Japanese
  * Added 3 Terms:
     1. Key = ENGLISH
       English (US) = English
       Afrikaans = <empty>
       Japanese = <empty>
     2. Key = JAPANESE
       English (US) = <empty>
       Afrikaans = <empty>
       Japanese = Japanese
     3. Key = AFRIKANS
       English (US) = <empty>
       Afrikaans = Afrikaans
       Japanese = <empty>

- Configured the Google integration following instructions in your Youtube video

- In the Global Resource:
  * Created a New Google Drive sheet
  * Refreshed list
  * Selected newly created sheet
  * Did Export – Replace

- In the Google Sheet, verified that the Export worked correctly and sheet contents were updated as expected

- In the Global Resource:
  * Added one new Term:
      1. Key = NEW_KEY
          English (US) = English
          Afrikaans = <empty>
          Japanese = <empty>
  * Did Export – Add New

Google Sheet now looks like:

Attachment Export-AddNew.jpg not found



I'm running Unity 4.6 RC2
Attachments:
Last edit: 4 years 8 months ago by dchau_hh.

Please Log in or Create an account to join the conversation.

More
4 years 8 months ago #328 by Frank
Replied by Frank on topic Export to Google Issues
Hi
I was able to reproduce and fix the issue!
Thanks a lot for the giving me the steps.

The way the plugin handles the spreadsheet was changed in the last version, but updating new elements was still using the old way (the one where with Term Type and Description as rows) So it was skipping the first two languages and adding them as the last ones.

The change doesn't involve installing the package again as it was only in the WebService. I fix it there and anyone installing the service from now on will have the updated version.

For you and those who already installed the WebService, you need to delete the I2LocalizationWebService from your google drive and clicking the install button again on the Unity editor. That will create a new copy of the localization Service with the updated code. After installing you need to follow the publish steps again to deploy the new webservice.

If you already made changes to the WebService code and don't want to get a new version, just need to change line 57 in ImportCSV.cs from
for (var i=3; i<rangeData[0].length; ++i)

into
for (var i=1; i<rangeData[0].length; ++i)

Thanks,
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

Please Log in or Create an account to join the conversation.

Time to create page: 0.134 seconds
Template by JoomlaShine