• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
csv input question
#1
Hi
Forgive a beginners question!

My first go at a csv import. First line was...
title,pages,key,composer,collection

... and composer and collection were the same for all items. 
It has imported them all, but not into a collection. Should I have created the collection first?? (I assumed it would create it if it didn't exist!)

Second question - is there a way to delete all 100 of them other than individually? (They are all titled Interlude xx)

Thanks
Reply
#2
I would generally recommend using a semi-colon instead of a comma for the delimiter, as that will ensure if you have any values that have a comma in them that it won't mess up the parsing. I'll need to see the file you imported in order to provide information on why it didn't work. There isn't enough information for me to say with any certainty, as I don't know what the lines looked like that followed the first.

As far as deleting, just enter "Interlude" in the search box, which should limit all the songs to only those containing Interlude in the title or one of the fields (and the dropdown can be used to limit it to the title or a specific field if needed), then long press to select one, tap the select all icon at the bottom right in the floating toolbar, and then tap "Delete".

Mike
Reply
#3
(Yesterday, 04:55 AM)Zubersoft Wrote: I would generally recommend using a semi-colon instead of a comma for the delimiter, as that will ensure if you have any values that have a comma in them that it won't mess up the parsing. I'll need to see the file you imported in order to provide information on why it didn't work. There isn't enough information for me to say with any certainty, as I don't know what the lines looked like that followed the first.

As far as deleting, just enter "Interlude" in the search box, which should limit all the songs to only those containing Interlude in the title or one of the fields (and the dropdown can be used to limit it to the title or a specific field if needed), then long press to select one, tap the select all icon at the bottom right in the floating toolbar, and then tap "Delete".

Mike

Here are a few lines....
title,pages,key,composer,collection
Interlude 1,1,C,Murray,Murray - Liturgical Interludes
Interlude 2,2,C#m,Murray,Murray - Liturgical Interludes
Interlude 3,3,D,Murray,Murray - Liturgical Interludes

There are no commas other than the delimiters. 
It has not imported the key, composer or the collection. The titles are there and bring up the correct pages.
Thanks
Steve
Reply
#4
The fields are plural - title,pages,keys,composers,collections

That's the only issue. I'll update the parser to support non-pluralized versions of the fields for users that accidentally use those.

Mike
Reply
#5
Thanks Mike - that sorted it.
Apologies for the silly mistake!
Steve
Reply




Users browsing this thread:
3 Guest(s)


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