[Stephan]

Hello,

I need sometimes to reorganize directories on my computer and this generates lots of duplicate names with broken links when I mass import all my scores again to Mobile Sheets.
=> Is there a way to mass clean all broken links ?
I mean I don't want to erase the full database as I need to keep all annotations I have on some scores, I just want to mass erase all duplicate names with broken links.
Thank you.

[Zubersoft]

Are you reorganizing things under the MobileSheets storage location? If so, please do not just reimport everything. Instead, go to Settings->Other Settings->Fix Broken File Paths and let MobileSheets can to find all the files that have been moved. As long as each file is uniquely named, this should work well.

Mike

[Stephan]

Thank you Mike, but this is not convenient for me as I don't have only unique names.
Ex. I have lots of polyphonic masses, therefore, lots of files named Kyrie, Gloria and so on.
I've tried this method, but I need to confirm each multiple file and that's very long as I have more than 7000 scores at all.

=> the best would really be to just remove broken links from the database and make a mass reload, not updating existing files => How can I do that ?

[Zubersoft]

Go to Settings->Other Settings->Find Missing Files and there is an option to delete all of the songs listed. That's going to remove all the annotations though. I recognize this is not what you want - there is nothing that matches what you are asking for. If you rearrange the files that MobileSheets is referencing, it's going to cause chaos. If you don't let MobileSheets manage your files though, that's on you to fix. If it's okay to just delete the songs that no longer correctly reference their file, then that will work.

Mike

[itsme]

Sciurius' MSProTools https://github.com/sciurius/MSPro-Tools allows manipulating paths in a MobileSheets database manually.
get_meta reads meta data (including paths) into a JSON file. JSON is a text format that you can easily modify with a text editor (my favorite for windows is Notepad++) or a script. Probably just search & replace changed paths will fulfill your needs.
upd_meta writes the modified JSON data back into the database
Make sure that you have a recent backup and that you know what you're doing.

[Stephan]

Thank you for your answers.
Settings->Other Settings->Find Missing Files  and then Delete All      is what I was looking for, didn't see this option before. Thanks.
Happy new year !