[Jeffrocchio@gmail.com]

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!

[Jeffrocchio@gmail.com]

Update: I ended up creating two Python scripts to replace the two spreadsheets in order to create the metadata CSV file and the Setlist.mss file. This does make the process faster and simpler. I just completed an end-to-end export / import of all of my 1,194 scores with no issues. Total roundtrip time from iPad (forScore docs) up to Dropbox, onto my PC, run my tools, then back down to the iPad importing into MobileSheets was about 1 hour. All my scores, metadata (with that 'SourceType' field exception noted in my 8/14 post), and setlists are now in MobileSheets.

  * Python Script Instructions @ https://github.com/JeffRocchio/forScoreM.../README.md
  * Github Repository @ https://github.com/JeffRocchio/forScoreMigration

Some of you may well be nervous about github, the command line, Python, and ExifTool. That is understandable. But...ask for help as needed if you give this a go for yourself.

If you are a developer - please feel free to contribute improvements via the github repo.