+- MobileSheets Forums (https://www.zubersoft.com/mobilesheets/forum)
+-- Forum: Support (https://www.zubersoft.com/mobilesheets/forum/forum-1.html)
+--- Forum: MobileSheets (Android) (https://www.zubersoft.com/mobilesheets/forum/forum-23.html)
+--- Thread: csv input question (/thread-13250.html)
csv input question - steveg - 04-24-2025
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
RE: csv input question - Zubersoft - 04-24-2025
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
RE: csv input question - steveg - 04-24-2025
(04-24-2025, 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
RE: csv input question - Zubersoft - 04-24-2025
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
RE: csv input question - steveg - 04-24-2025
Thanks Mike - that sorted it.
Apologies for the silly mistake!
Steve