A way of editing Google Sheets without re-doing TTS settings

[waltex]

THANK YOU very much Erine for explaining how to backup decks to Google Drive.

Doing the method you've described below actually saves me a lot of time having to re-input most of the Sound and TTS settings.

Previously I've had to re-enter all of these Sound and TTS settings every time I inserted a new slide or changed a slide in Google Sheets.

But now, I don't have to do this, as I've followed your instructions below (lightly edited):

Hi waltex,

The Backup/Restore does not work with Google Drive. But you can still export/backup, just differently.

1. In the Decks screen, swipe left on a deck,

2. Tap Edit, then Export/Share, then Google Drive.

3. Tick "Export TTS", "Export Media Files" (if appropriate), Tick "Export TTS" and tick Export Statistics.
If you export statistics, they will be included in the spreadsheet file.

4. Tap "Select Decks to Export" and turn on all decks you want to export.

5. Tap Export in the bottom right of the screen.

Backup/Restore will export a single database with all the app data (media files separate). When exporting individual decks, some settings won't be exported, such a global options and deck order and combination decks. But the important stuff will be backed up / exported.

Ernie

THANK YOU for saving me a lot of time! I used to dread making a correction or change to a slide, because that would mean re-doing all of the TTS settings AGAIN.

Please note: to make it easier, please choose the Android voices in Sound. If you choose the Amazon Polly voices then, I believe you will have to re-download them every time which is an extra step to re-do.

I've created this new thread so that people can see the subject heading and find this topic and get help with this too.

[Ernie]

Hi waltex,

Thank you for sharing your findings.

I get the impression that when you make updates, you are adding the deck back as a NEW deck. Did you know you can update an existing deck?

First, you add as a new deck, as usual.
If you want to make a change, you update your Google Sheet. Easy. But instead of adding back as a new deck, update and exiting deck....

In the app, swipe left on a deck, then tap Edit.
Notice the "deck code". This should start with "G:" for Google Drive sources, then be the name of your file.
Tap "Download/Update". The deck you should selected in the "Also in Google" section.
Tap "Update 1" to perform the update.

What the update will do is download your new Google Sheet, delete all existing cards, and replace with the new cards in Google Drive.
1) The app will try to match up old and new cards so that statistics are maintained. You generally won't lose any statistics, as long as you don't have duplicate cards.
2) Existing settings in the app will be kept.

If you haven't tried this, and you think it might be useful, give it a try. I feel like you might be creating a new deck each time you update the google drive sheet, which is not my intention.

ERnie