• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to bulk remove songs from failed CSV import
#1
I've been working on importing large fakebook files with the publicly available CSV indexes. I'm finding that some of the indexes aren't as good as others and I ended up with a few hundred "bad" songs in my list (image attached). The bad song entries point to the wrong part of the pdf file, usually the first page. My thought was to simply remove the bad batch and re-import. The issue I'm having is that I don't see a way to identify just the "bad" songs. I don't have access to any metadata that I could use to identify the bad batch (i.e. import date, batch id, etc.) If I could do that, I could bulk delete a result set.

I know that I could delete my whole library and rebuild it, but I'm hoping there's a better way. I already did that, forgetting that I would lose my annotations. Lesson learned. I wrote a tiny bit of python to fix formatting and integrity in any CSVs that I'm trying to import and that looks like a good way forward, but I'm hoping to learn how to elegantly recover from a bad import should it happen again.

I'm using MSP on Windows.

Thanks,

Matt Trimboli


Attached Files Thumbnail(s)
   
Reply
#2
The only things that come to mind are sorting by date created with the newest songs at the top so you can delete recently created songs, or you can go to Settings->Backup and Restore->Restore Automatic Database Backup and just revert the entire library to the point before you imported those bad songs. You could also go to Settings->Library Settings->Song Title Formatting, include page order as one of the fields, and then delete every song that points to the start of the PDF.

Mike
Reply
#3
The only 'sure' way I've found is to do a backup before importing.
Dell Latitude 13.5" 2-in-1 Ubuntu/Win 11
Samsung Note Pro SM-P900 12.2 Android 5.0.2
Samsung S7+, Android 12
Reply
#4
When importing using CSV, I always include a collection name in the .csv file.
This allows one to filter the results by collection so that you can delete and reimport the songs.

Not much help now but might be useful for future imports

Geoff
PS the keyword in the .csv file is "collections"  (and not "collection")
Samsung Galaxy Tab A6
Reply
#5
(06-27-2022, 03:49 AM)Zubersoft Wrote: The only things that come to mind are sorting by date created with the newest songs at the top so you can delete recently created songs, or you can go to Settings->Backup and Restore->Restore Automatic Database Backup and just revert the entire library to the point before you imported those bad songs. You could also go to Settings->Library Settings->Song Title Formatting, include page order as one of the fields, and then delete every song that points to the start of the PDF.

Mike

 That was exactly what I needed. When I sort by date added it exposed the timestamp which made it trivially easy to delete the bad batch. Thank you! - Matt
Reply
#6
I had the same issue, see https://zubersoft.com/mobilesheets/forum...p?tid=8740
Scroll doen to see how I solved it
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#7
Has there some improvement made here ?
Re-importing a CSV file should not duplicate the songs but only update them.
There is a new option in the Import dialog that says "Modify the songs after import" (*) which is NOT documented in the manual. I wish it was that option to update the songs instead of duplicating them. But it is not.

(*) freely translated from my french UI
Reply
#8
I haven't had time to work on this yet - it's on my list of things to do in one of the next big updates though.

Mike
Reply




Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.