Page 1 of 1

Csv format for bulk upload

Posted: Thu Jul 25, 2019 2:44 pm
by Escallonia
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”

Re: Csv format for bulk upload

Posted: Thu Jul 25, 2019 2:47 pm
by Phil Smith
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.

Re: Csv format for bulk upload

Posted: Thu Jul 25, 2019 2:53 pm
by Escallonia
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?

Re: Csv format for bulk upload

Posted: Thu Jul 25, 2019 2:58 pm
by Phil Smith
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.

Re: Csv format for bulk upload

Posted: Thu Jul 25, 2019 8:01 pm
by Escallonia
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.