Had some time off so here is a summary what can be done. This if you have hundreds/thousands projects well organized in hundreds of folders in macOS and need you projects locally for some reason…
WARNING; YOU NEED TO KNOW WHAT YOU ARE DOING OR YOU RISC YOUR DATA (projects).
To update from ≤5.900 to the latest:
Check the downloaded status of projects, in terminal, run;
sqlite3 ~/Library/Containers/com.shapr3d.shapr/Data/Library/Application\ Support/com.shapr3d.shapr/storage/projectStorage.db “SELECT isOffloaded FROM Projects;”
ALL SHOULD be 0
If offloaded is ‘1’ of ANY project AND you later set isOffLoaded = ‘0’ et al. you WILL LOSE access to those projects!
(if any ‘1’ seen you need to run S3D to identify and download the missing projects before proceeding (or if hard to find; take a dive in to Sqlite3or a SQL editor)
After confirming all is downloaded ‘0’ take a backup of all the projects:
~/Library/Containers/com.shapr3d.shapr/Data/Documents/
Also check that there are no empty project folders by ‘View> Show View Options> Calculate all sizes’ in Finder.
And to be safe also backup the projectStorage.db that will be edited.
~/Library/Containers/com.shapr3d.shapr/Data/Library/Application Support/com.shapr3d.shapr/storage
You can use ‘Go> Go to Folder…’ in Finder.
Update S3D and all ‘old’ local (and hopefully uploaded) projects is ins[t]an[t]ly erased.
Quit S3D and restore all the deleted projects to …/Documents/
In terminal run;
sqlite3 ~/Library/Containers/com.shapr3d.shapr/Data/Library/Application\ Support/com.shapr3d.shapr/storage/projectStorage.db “UPDATE Projects SET ShouldKeepDownloaded = 1; UPDATE Projects SET isRemotePlaceholder = 0; UPDATE Projects SET isOffLoaded = 0;”
Now all present projects is set to be local and downloaded. You can check by running;
sqlite3 ~/Library/Containers/com.shapr3d.shapr/Data/Library/Application\ Support/com.shapr3d.shapr/storage/projectStorage.db “SELECT ShouldKeepDownloaded FROM Projects;”
All should read ‘1’.
Then I run following commands (Execute Shell Script) by Keyboard Maestro every week - if I ever forget to set a project to be kept downloaded.
sqlite3 ~/Library/Containers/com.shapr3d.shapr/Data/Library/Application\ Support/com.shapr3d.shapr/storage/projectStorage.db “UPDATE Projects SET ShouldKeepDownloaded = 1;”
Though, if you already got busted through an upgrade from 5.900, this will NOT help, as all deleted projects needs to be dowloaded again, one by one, even if ShouldKeepDownloaded are set to ‘1’. Or you can do de scary pirouette needed by restoring from a backup, taking in to the account files you worked on since backup.
(This could be also done on iOS and I expect the same SQL on Windows.)
Be very careful!!