08-15-2023, 08:04 AM
Sharing out my process, and tools, for my own migration from forScore to MobileSheets.
Note-1: I am waiting for one tweak from Mike to be able to import forScore's 'Reference' metadata field into MobileSheets' 'SourceType' field. But I have run this process with a sample of a 100 scores and it worked fine, absent that one metadata property.
Note-2: I am a Linux guy, so some of the process steps and instructions may be a bit fuzzy on Windows and Mac. I believe it should all work, but, for example, details about installing the required ExifTool utility will be a bit different on Windows and Mac than on Linux. So if any Windows or Mac user tries these instructions out and has comments, improvements, corrections that'd be good.
Note-3: Mike has stated his eventual intent to provide a handy migration feature, or utility, that will make this post obsolete. So this process should at best be considered a temporary stop gap until Mike has been able to get to that. Because of that, and wanting to keep the process as cross-platform as possible, I avoided any programming or scripting; relying instead on the ubiquitous spreadsheet application that we all likely have. The downside is that this is a pretty manual process. Not manual in the sense of having to go score-by-score; but manual in the sense of copying and pasting rows of data and formulas in a few spreadsheets.
Note-4: I have run the process only twice, on small samples of my full 1,000+ scores. And I'm probably the only MobileSheets user in the world on Linux. So for sure, as written, it has flaws in it. If you try it, and have problems, I'll try to help; but my ability to do so may be limited. Just a fair warning here. Be sure to make backups!
I put all the documentation, the spreadsheets, and a detailed step-by-step guide in a repository on my github account.
* Step-by-Step Guide (pdf doc) @ https://github.com/JeffRocchio/forScoreM...ctions.pdf
* Github Repository @ https://github.com/JeffRocchio/forScoreMigration
Have fun!
Note-1: I am waiting for one tweak from Mike to be able to import forScore's 'Reference' metadata field into MobileSheets' 'SourceType' field. But I have run this process with a sample of a 100 scores and it worked fine, absent that one metadata property.
Note-2: I am a Linux guy, so some of the process steps and instructions may be a bit fuzzy on Windows and Mac. I believe it should all work, but, for example, details about installing the required ExifTool utility will be a bit different on Windows and Mac than on Linux. So if any Windows or Mac user tries these instructions out and has comments, improvements, corrections that'd be good.
Note-3: Mike has stated his eventual intent to provide a handy migration feature, or utility, that will make this post obsolete. So this process should at best be considered a temporary stop gap until Mike has been able to get to that. Because of that, and wanting to keep the process as cross-platform as possible, I avoided any programming or scripting; relying instead on the ubiquitous spreadsheet application that we all likely have. The downside is that this is a pretty manual process. Not manual in the sense of having to go score-by-score; but manual in the sense of copying and pasting rows of data and formulas in a few spreadsheets.
Note-4: I have run the process only twice, on small samples of my full 1,000+ scores. And I'm probably the only MobileSheets user in the world on Linux. So for sure, as written, it has flaws in it. If you try it, and have problems, I'll try to help; but my ability to do so may be limited. Just a fair warning here. Be sure to make backups!
I put all the documentation, the spreadsheets, and a detailed step-by-step guide in a repository on my github account.
* Step-by-Step Guide (pdf doc) @ https://github.com/JeffRocchio/forScoreM...ctions.pdf
* Github Repository @ https://github.com/JeffRocchio/forScoreMigration
Have fun!