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”
Csv format for bulk upload
- Phil Smith
- iGigBook Specialist
- Posts: 2773
- Joined: Tue Oct 19, 2010 8:00 pm
Re: Csv format for bulk upload
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.Escallonia wrote: ↑Thu Jul 25, 2019 2:44 pmI 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”
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.
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.
-
- iGigBook User
- Posts: 10
- Joined: Fri Jul 19, 2019 6:16 pm
Re: Csv format for bulk upload
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?
- Phil Smith
- iGigBook Specialist
- Posts: 2773
- Joined: Tue Oct 19, 2010 8:00 pm
Re: Csv format for bulk upload
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.Escallonia wrote: ↑Thu Jul 25, 2019 2:53 pmIs 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?
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.
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.
-
- iGigBook User
- Posts: 10
- Joined: Fri Jul 19, 2019 6:16 pm
Re: Csv format for bulk upload
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.
Thanks for your help.