[Cerio]

For exemple here:
   
 
In this case, I can batch edit all Diana Ross songs and assign "Diana Ross" as artist, which is great. But if I'd like to remove "Diana Ross" from the titles, do I need to change the title one by one, or is it there any faster way ?

(I have hundreds of examples like that on my DB)

[Zubersoft]

You'll have to change the titles one-by-one. There is no easy way to batch edit titles like that (the logic of trying to find characters that are identical between every selected title would be a little tedious, as well as trying to create a UI for editing only the sections of the title that are identical between every title).

Mike

[Cerio]

Thanks Mike

[itsme]

With Sciurius' MSPro Tools https://github.com/sciurius/MSPro-Tools you might be able to do what you want. It's a packet of Perl scripts for a number of useful tasks.
With get_meta.pl you can read all meta data out of the MobileSheets database into a .JSON file. Then you can manipulate this .JSON export with any text editor, apply search & replace actions as required and reimport it into the MobileSheets database with upd_meta.pl.
I used MSPro Tools several times successfully. Maybe it needs an update to handle the new database format, but that should not be problem as Sciurius is very active, kind and cooperative.

[Zubersoft]

It's also true that if you know how to use SQL queries, you can just open the SQLite database file in a SQLite editor like SQLiteStudio, and perform a query on the Songs table to replace "Diana Ross" with "", effectively removing it from all titles.

Mike

[Cerio]

Thanks both for the tips. In my case, I suspect this task would be faster just by renaming those files one by one, but it's good to know that these kind of tools these kind of tasks, it may come handy in the future.

[Cerio]

It's also true that if you know how to use SQL queries, you can just open the SQLite database file in a SQLite editor like SQLiteStudio, and perform a query on the Songs table to replace "Diana Ross" with "", effectively removing it from all titles.

Mike

I've finally tried this method and, after 20minutes learning the basics of SQLITE queries (I'm not a tecnhical user), it works just fine.

Thanks!

EDIT: Unfortunately it only worked well in the Windows version, but for some reason, after syncying the collection with my tablets, the modified songs can't be seen on my other devices (songs appear just fine on the lists, but if I click on any of them, instead of showing the right pdf, MS for Android shows a black page)

Any ideas?

[Zubersoft]

What sync settings did you use? The simple fix would be to create a backup on the Windows device under Settings->Backup and Restore->Backup Library and restore that on the other devices under Settings->Backup and Restore->Restore Library from Backup.

Mike

[Cerio]

These are my sync settings, the ones I always use to sync from PC > Android:

   

However, I've just realized that changing the title with this query:

UPDATE Songs
  SET Title = replace(Title, 'The Beatles ', '')
WHERE Title IN ('The Beatles A Day In The Life'), etc etc;

Messes up the sorting in MSP when reimporting the mobilsheets.db database:

   

I guess I probably need more time to research about that DB structure and how queires work, so restoring my backup for now. Not so urgent