Csv format for bulk upload

The data that drives the apps
Post Reply
Escallonia
iGigBook User
Posts: 3
Joined: Fri Jul 19, 2019 6:16 pm

Csv format for bulk upload

Post by Escallonia » Thu Jul 25, 2019 2:44 pm

I am working on using 0CR for creating CSV files for the bulk upload. The 0CR program I am using doesn’t automatically recognize multiple columns. I take an image scan of the table of contents for PDF facbook, overlay a grid to make it look like a table, and then try to get it into a spreadsheet for editing and export as Csv.
The bulk upload fails and it looks as though it can’t see the end of the first line: all of the items in the first five or six songs are smooshed together as if it was one entry.
I am wondering what the exact delimiter is for the end of each line, that is, what character (tab, line feed, etc.) separates each song entry from the next one?
Specifically, I dump from the Ocr program to Internet explorer, which renders it as a table. I copy and paste from there into Google sheets, a spreadsheet application. When I export to csv from there I have some choices about delimiters .
The lines look ok in notepad:
“Moon river”, 32,1,”n\a, n\a”

User avatar
Phil Smith
iGigBook Specialist
Posts: 2606
Joined: Tue Oct 19, 2010 8:00 pm

Re: Csv format for bulk upload

Post by Phil Smith » Thu Jul 25, 2019 2:47 pm

Escallonia wrote:
Thu Jul 25, 2019 2:44 pm
I am working on using 0CR for creating CSV files for the bulk upload. The 0CR program I am using doesn’t automatically recognize multiple columns. I take an image scan of the table of contents for PDF facbook, overlay a grid to make it look like a table, and then try to get it into a spreadsheet for editing and export as Csv.
The bulk upload fails and it looks as though it can’t see the end of the first line: all of the items in the first five or six songs are smooshed together as if it was one entry.
I am wondering what the exact delimiter is for the end of each line, that is, what character (tab, line feed, etc.) separates each song entry from the next one?
Specifically, I dump from the Ocr program to Internet explorer, which renders it as a table. I copy and paste from there into Google sheets, a spreadsheet application. When I export to csv from there I have some choices about delimiters .
The lines look ok in notepad:
“Moon river”, 32,1,”n\a, n\a”
The Bulk Upload screen shows you what the exact format is. Copy the example, paste it into a text editor and use that as your template.
Are you happy with iGigBook?
Tell the world about it by leaving a rating or a review in the App or Google Play Store.
Got Questions? Click Here For The How To Section
iGigBook: The Go-To Gig Tool.

Escallonia
iGigBook User
Posts: 3
Joined: Fri Jul 19, 2019 6:16 pm

Re: Csv format for bulk upload

Post by Escallonia » Thu Jul 25, 2019 2:53 pm

Is a “dumb“ text editor like notepad the only program that can make the upload files? If I have a spreadsheet with four columns, one for each of the four sections of an index entry, I can save in CSV format. Are you saying that a spreadsheet program can’t generate proper bulk upload files?

User avatar
Phil Smith
iGigBook Specialist
Posts: 2606
Joined: Tue Oct 19, 2010 8:00 pm

Re: Csv format for bulk upload

Post by Phil Smith » Thu Jul 25, 2019 2:58 pm

Escallonia wrote:
Thu Jul 25, 2019 2:53 pm
Is a “dumb“ text editor like notepad the only program that can make the upload files? If I have a spreadsheet with four columns, one for each of the four sections of an index entry, I can save in CSV format. Are you saying that a spreadsheet program can’t generate proper bulk upload files?
Using a text editor assures you won't have things like quotes that aren't actual quotes. When you save in CSV format you still need to verify that what you have matches the format present in the Bulk Upload screen.
Are you happy with iGigBook?
Tell the world about it by leaving a rating or a review in the App or Google Play Store.
Got Questions? Click Here For The How To Section
iGigBook: The Go-To Gig Tool.

Escallonia
iGigBook User
Posts: 3
Joined: Fri Jul 19, 2019 6:16 pm

Re: Csv format for bulk upload

Post by Escallonia » Thu Jul 25, 2019 8:01 pm

Solved it--when exporting from Open Office Calc spreadsheet, there is a default option to "save cell content as shown" that exports the number formatting as well as the numbers. Unchecking this creates a .csv file that is formatted properly.
Thanks for your help.

Post Reply