Sync backlog and error

[Aslam_Vally]

Hi,

I have a little issue where a colleague of mine has a backlog 800 pending syncs because of one wrong data type, over the period of a month. Is there any way to save this so they don’t have to start fresh if I reset the app.
Is there anyway to change what’s trying to be saved, or to skip a sync.

Anything would be greatly appreciated.

[Stefan_QREW]

Wow! That’s a really rough situation… I have had many nightmares of this situation.

Much of the data should be recoverable if you’re unable to force it through.

What type of data source are you using?

[Aslam_Vally]

Google sheets. anyway to recover anything would be awesome!

[Stefan_QREW · Accepted solution]

Removing the “Sync Block” is probably not an option with Google Sheets… sadly.

You can follow the instructions here to work through a manual Recovery Process. It will give you probably 800 sync files that you can use the AppSheet Toolbox Chrome Extension to collate and upload to your Google Sheet.

If the Chrome extension is giving you issues, you can also use an updated version of the tool on https://www.qrewtech.com/recovery/

[Aurelien]

Hi @Stefan_Quartemont

About that:

Stefan_Quartemont:

It will give you probably 800 sync files that you can use the AppSheet Toolbox Chrome Extension to collate and upload to your Google Sheet.

How do you manage to do that ?

With my AppSheet apprentice, we managed to make a macro with Google Apps Script in order to read all the files from the recovery folder, and write the data down in order to be used and copy-pasted: every similar structure together, one sheet per table/structure.
Is it possible to do the same with AppSheet Toolbox ?
I can provide the code we made if needed, in addition to the procedure you shared on another post.

[Stefan_QREW]

Hi @Aurelien !

That’s a really cool GAS solution. We are doing the same approach with client side JavaScript in the chrome extension. Collating all files and separating them into individual tables. You just have to download the recover data folder to your desktop and multi select all the files you want to merge.

I don’t think we could directly incorporate the AppScript components without having to manage user authentication to Google Drive via the chrome extension, which would be quite a lift.

[Aurelien]

Stefan_Quartemont:

You just have to download the recover data folder to your desktop and multi select all the files you want to merge

Hi @Stefan_Quartemont

Would that possible to get a short video explaining how to do so ? I don’t see any option that suggest I can do that. Maybe it’s because I didn’t log in ?

[SkrOYC]

@Aurelien
Schema → Bottom part

[Aurelien]

Thanks @SkrOYC !!! My eyes were away…so far away !

[SkrOYC]

Stefan_Quartemont:

you can also use an updated version of the tool on No Code Training Tools for the Citizen Developer - QREW Technologies

Good to see it as a standalone option

[Stefan_QREW]

SkrOYC:

Good to see it as a standalone option

Yeah… maintaining chrome extension code is really slow and obnoxious.

The standalone is much easier to support and push fixes to.

[Aslam_Vally]

Thank you so much for the replies, I’ll give this a shot as soon as I get to work

[Aslam_Vally]

I just used this, got a CSV file and with a bit of editing I was able to recover almost everything, if not everything.
You are a lifesaver sir @Stefan_Quartemont , thank you very much

[Stefan_QREW]

Been there before… it involved lots of tears that’s why I built the tool.

I’m so glad you were able to recover basically everything!! From 800 backed-syncs… I think you may have set a record.