• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Deleting many songs by a list
#1
Hi,

I used a CSV file to import several hundred songs from a PDF fakebook. I was expecting to get the dialog to add the songs to a collection after the import, but didn't. I would have liked to have added the songs to a collection named after the fakebook they came from. I've since figured out how by adding a "collections" column to the CSV file. I can't figure out how to fix this easily. How to delete the songs imported by this CSV so I can do it over without creating a lot of duplicate songs?

Thanks,
John
Reply
#2
Look in the recent tab. If you didn't open any (or many) other files, they should be the last couple hundred of entries there which you can select and add to the collection you want.
Reply
#3
Thanks for the tip, but many, many more have been imported since.
Reply
#4
If you sort by date created on the songs tab, you should be able to locate the last song added from the CSV, and select all the songs down to the first one added from the CSV. You can use the companion application to shift-select if you have a large number of songs to delete. I haven't found a good way to implement a ranged selection on android yet (I need to look into adding options when the checkbox is long pressed).

Mike
Reply
#5
But don't delete, just assign the selected ones to the collection you want to assign them (if that's the only thing you want to correct by reimport).
Reply
#6
BRX is correct, if you just want to make sure they are assigned to a collection, there is no need to delete them.
Reply
#7
Thanks BRX and Mike. I'll give it a try. The other way I was wanting to approach this is to search for songs that are not in any collection, but I couldn't find a filter for that. That might be a handy feature besides this particular issue. I set the song display to show the collections with each song's name and saw that I had been very rigorous about assigning a collection to all imports since that early CSV import, so all the songs I want to delete are probably this set of unassigned songs, about 270/4250 song density. I probably could have gone through and done it manually by now, but I like elegant solutions Smile And it's a great way to learn about the software!

Is there a central repo for CSV files or are they just referenced and included in various messages on this list? I've made about 6 for myself for some common jazz fake books and I'd like to post them in the best place for sharing (or find out I reinvented the wheel).

John
Reply
#8
There is no central repo at the moment. Just these two threads to my knowledge:

https://zubersoft.com/mobilesheets/forum...p?tid=3276
https://www.zubersoft.com/mobilesheets/f...p?tid=3450

Mike
Reply
#9
To find your songs with the missing collection:
1. On Android you can filter by "File Paths". This has been added in one of the last versions. Don't know why that hasn't made it into the Win10 version.
2. If you go to Library Settings - Song Title Formatting and add "FIle names" to the beginning of the song name the songs will be sorted on the songs tab first by filename. Remove "File Names" again when you're done
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#10
Please add your CSV Files to "General Discussion > CSV Files". One thread per fakebook and set the thread title to "CSVFile for ..."
Please write "CSVFile" without blank. Thus the thread can be found through the search function. It requires keywords to be at least four characters long, so we cannot search for just "CSV"
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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