12-10-2023, 11:29 PM (This post was last modified: 12-11-2023, 12:23 AM by JimR.)
I have attached an example csv file that uses a comma as a delimiter and all works except it will not import "sources" (I also tried "source"). Suggestions needed before I start creating a bunch of index files. Here is the layout and one (currently the only one) line of data.
Title,Albums,Collections,pages,genres,sources,Custom Groups
Book Of Songs,Book Of Songs,Fake Book,1-28,Christmas,Lead Sheet,No Index
title;pages;keys;composers;year;signatures;collections;source types;genres
Sunday;9;Bb;Chester Conn|Benny Kreuger|Jule Styne;1926;4/4;The Firehouse Jazz Band Fake Book;Sheet Music;Jazz
Bill Bailey, Won't You Please;10-11;F;Hughie Cannon;1902;4/4;The Firehouse Jazz Band Fake Book;Sheet Music;Jazz
12-11-2023, 04:56 AM (This post was last modified: 12-11-2023, 04:57 AM by itsme.)
Column names should not be the problem. Only title and pages are mandatory. When one of the other column name is unknown for MobileSheets, the column is just ignored. That's nice and useful for adding additional info to a CSV.
Several names are accepted, the keywords from "Song Title Formatting" (%TITLE% %KEYS% ...) also work fine.
Quote:That's nice and useful for adding additional info to a CSV.
And not so useful when you create a csv and import it and discover that you've misspelled a field name and the data wasn't imported as you expected it would be.
It would be nice if the program brought up some kind of a warning "Unknown field name, proceed anyway?" and then you'd have a chance to back out and change it instead of just charging ahead and finding out later....
If you're a zombie and you know it, bite your friend!
We got both kinds of music: Country AND Western