Spreadsheet web app questions

Hi,

If I I go to the script and open the publishing window, I get a very different URL than what I have in Unity right now.

If you get a different URL, it means the script was not the same than the one you are installing now or that the script was unpublished before.

Every time you publish the script and get its URL, the URL should be the same. Google Scripts allows to change the script and every redeploy is just a change to the already published service without changing the URL so that clients already using that URL can keep working.

If you don't see the password field in either Unity or the WebService, then you have an older version of them (mabe one of the old betas).

To be sure you have the latest:
- Download and install the latest I2 Localization.
- Click Install in the Google tab, so that a new copy of the WebService gets added to your Google Drive.
- That copy will have the latest v5 with the password field.
- change the password (if you want to password protect it, or leave it if you don't)
- Follow the steps again to publish the WebService.
- Paste the new URL in Unity.
- Click verify, a green checkmark should show next to the URL saying everything went fine (or a red x if there was an error)

* another way to verify that the integration works, is by importing or exporting to a Google Spreadsheet, that uses the WebService.

If I Use the Install button, what will happen?

Clicking Install in Unity, just copies the latest version of the WebService from my server and copies that to your Google Drive.

Presuming that there is a newer version of the script, will it overwrite the currently published version?

No, it will create a copy next to that one.
The old is kept, so that if your players are using the URL from that WebService, they can still access your spreadsheets.

If so - what will happen with all current users that has an old client without any password?

New versions deploy to a separate URL, so your existing users will still use the old webservice.
And given that the I2 Localization they have built into the game they are using, then, it will work fine. Once they update the game, they will have the new I2 Localization which will point to the new WebService, and so, will use the password.

Nonetheless, if the password is not changed in neither Unity and the WebService (i.e. has the default value "change_this") then, the password protection is ignored.

Hope that helps,
Frank

Hi,
I have trying to reproduce an issue in the Google Live Synchronization but it seems to be working fine in my devices as well.

Things to check:
- When you installed the game in your device you accepted the Internet Access permission

- When building, the Update Frequency was set to ALWAYS not DAILY or WEEKLY (as the default), otherwise you will only be albe to do a test per day/week

- There is a new setting next to the Update Frequency that defines when the update is applied after its downloaded. It can be OnSceneLoaded, Manual or AsSoonAsDownloaded.
If you have it set as OnSceneLoaded, then, it will only be applied when you start loading into a new scene (to avoid a lag/hitch while playing).
So, for testing, be sure is AsSoonAsDownloaded or that you are switching levels/scenes for testing that it works.


- If nothing seems to be working anyway, try checking the Android Console (logcat), If you are using Unity 2019.1, I think they even linked it to the Untiy Console, but in previous version you have to run the logcat separately.
In that logs there will be a line for when it start downloading, for when it finishes and for when it applies it. If it doesn't do that flow, there should be a warning saying what happened

Hope that helps,
Frank