• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Testing CSV Import fails repeatedly
#3
(03-08-2020, 04:10 PM)Zubersoft Wrote: The title column needs to be singular: title

So it should be:

title;pages
Audience;77-80
Back Doors Crying;6-10

Give that a shot and it should work as long as you have a PDF named the same thing as the .csv file in the same directory. I tested those exact three lines in a file and it worked.

Mike
Funny that it would be the "title" column that needed to be singular, but the error message referred to the "pages" column! I'll try this one more variation. In the meantime, is there a requirement for the "encoding" of the simple .CSV file? My database export defaults to "UTF-16" but I've tried others to see if that's the problem.

Just tried another one with "title" instead of "titles" and now the error is "There is no title column and one is required." IRONIC, huh? Tried title and Title and the result is the same.

BTW, I see that you removed my leading zeroes in the pages field. Is that required? Most of my fake books are over 100 pages so I've used 3-digit numbers for the ranges. This particular PDF has less than 100 pages, but is extracted from a larger songbook that has over 100 pages, so I stuck with the 3-digit numbers even though there are only 80 or so in the PDF.
Reply


Messages In This Thread
Testing CSV Import fails repeatedly - by KHS - 03-08-2020, 03:44 PM
RE: Testing CSV Import fails repeatedly - by KHS - 03-08-2020, 04:27 PM
RE: Testing CSV Import fails repeatedly - by KHS - 03-08-2020, 04:34 PM
RE: Testing CSV Import fails repeatedly - by KHS - 03-09-2020, 02:53 AM
RE: Testing CSV Import fails repeatedly - by KHS - 03-09-2020, 04:49 AM
RE: Testing CSV Import fails repeatedly - by KHS - 03-10-2020, 04:23 AM



Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.