• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to import PDF with CSV index
#6
(05-21-2018, 08:47 PM)art Wrote: hi there can someone explain how I change the CSV file when I try to import I get, all columns are  invalid message, itsme says you have to use a semicolon as separator, how do you do that, thanks

Art,
I've attached a complete csv file that I've used successfully to import the Firehouse Jazz Band book as separate songs.  In case you have trouble seeing that, here is an excerpt of the first several lines:

title;pages;keys;composers;collections;genres
Title page;1;;;Firehouse JB;Dixieland
TOC;3-8;;;Firehouse JB;Dixieland
Sunday;9;Bb;Chester Conn, Benny Kreuger, Jule Styne 1926 T: Ned Miller;Firehouse JB;Dixieland
Bill Bailey, Won't You Please;10-11;F;Hughie Cannon 1902;Firehouse JB;Dixieland
Doodle-Doo-Doo;12;Bb;;Firehouse JB;Dixieland
Oh, By Jingo!;13;F;;Firehouse JB;Dixieland
Tishomingo Blues;14-15;Ab;;Firehouse JB;Dixieland

I don't know exactly what file you're starting with, or what tools you have but I'll offer a couple suggestions.  

If you're starting with a spreadsheet, Microsoft Excel won't export to CSV with a semi-colon.  But LibreOffice will - it's free open source. In LibreOffice, in the export dialog box, you simply check the box to choose a semicolon separator.

You MIGHT be able to change a comma separated file to a semicolon separated file using a text editor, doing a 'global' search+replace. 2 things might "break" it:
- if there are commas in any of the titles or other field data, a global replace will also replace those commas, messing up the field parsing.
- some text editors add CR and / or LF characters to the ends of lines, also messing things up.

You could also attach the file you're trying to work with, and we might be able to help.
Reply


Messages In This Thread
How to import PDF with CSV index - by chrisss - 05-12-2018, 08:40 AM
RE: How to import PDF with CSV index - by itsme - 05-13-2018, 10:46 PM
RE: How to import PDF with CSV index - by chrisss - 05-13-2018, 11:32 PM
RE: How to import PDF with CSV index - by art - 05-21-2018, 08:42 PM
RE: How to import PDF with CSV index - by art - 05-21-2018, 08:47 PM
RE: How to import PDF with CSV index - by chrisss - 05-21-2018, 11:39 PM
RE: How to import PDF with CSV index - by art - 05-22-2018, 12:00 AM
RE: How to import PDF with CSV index - by chrisss - 05-22-2018, 05:24 AM
RE: How to import PDF with CSV index - by itsme - 05-22-2018, 03:05 AM
RE: How to import PDF with CSV index - by art - 05-24-2018, 02:33 AM
RE: How to import PDF with CSV index - by chrisss - 05-24-2018, 03:07 AM
RE: How to import PDF with CSV index - by art - 05-24-2018, 04:59 AM
RE: How to import PDF with CSV index - by itsme - 05-24-2018, 07:01 AM
RE: How to import PDF with CSV index - by chrisss - 05-24-2018, 07:02 AM
RE: How to import PDF with CSV index - by art - 05-24-2018, 11:12 PM
RE: How to import PDF with CSV index - by chrisss - 05-25-2018, 12:53 AM
RE: How to import PDF with CSV index - by art - 05-25-2018, 05:23 AM
RE: How to import PDF with CSV index - by art - 05-26-2018, 01:02 AM
RE: How to import PDF with CSV index - by chrisss - 05-26-2018, 02:02 AM
RE: How to import PDF with CSV index - by itsme - 05-26-2018, 08:25 AM
RE: How to import PDF with CSV index - by art - 05-28-2018, 10:41 PM
RE: How to import PDF with CSV index - by art - 05-29-2018, 01:03 AM
RE: How to import PDF with CSV index - by art - 05-29-2018, 03:15 AM



Users browsing this thread:
1 Guest(s)


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