CC Migration

[bthuronyi]

We need a script to allow us or external users to copy the user-entered data from one CC instance into another. This would be used for migrating from an older CC version into a newer one.

A key convention is that all user-entered data is part of Named Ranges. Not every Named Range has user-entered data, though, so we need to ensure that we don't copy formula-containing Named Ranges. We can assume all Named Range names stay the same between CC versions (source and destination).

This script implements the copying process, but its approach is too slow because the Apps Script spreadsheet functions are operated server-side and are very slow. The script times out before getting close to copying the current Thuronyi lab CC instance's data into a blank CC instance. So some elements of the script below could be used, but we need a fundamentally different approach, e.g. exporting sheet (and Named Range) data into a Javascript object or a CSV and then importing it, rather than doing Sheet to Sheet transfer. https://docs.google.com/spreadsheets/d/1i_gmMxcEh5WLFV3_J_O1bebn3VLEPtboXS-Z3yERH3Q/edit?usp=drive_link

[bthuronyi]

Revised approach to this significantly! @ixf1 please document the new strategy here, or I can

[bthuronyi]

New strategy: use importrange to transfer data; script creation of importrange formulas and copy/paste. No data transfer within the script!