pilot-db-list

[pilot-db-list] Converting CSV to PDB problems...

[<ky...@ky...>]

Quoting Andreas Joebges:
> 
> --__--__--
> 
> Message: 1
> Date: Sun, 03 Jul 2005 01:14:40 +0200
> From: Andreas Joebges <bag...@gm...>
> To: pil...@li...
> Subject: [pilot-db-list] problems with csv2pdb
> 
> This is a multi-part message in MIME format.
> --------------050506060505060501090606
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: 7bit
> 
> Hi,
> 
> I have problems converting the included csv file to pdb. I get the
> following error:
> 
> CSV2PDB.EXE: csv file:1: number of fields doesn't match csv file: nb
> fields found 1 nb field requested 4
> 
> Has anyone got an ideas?
> 
> Best regards
> Andreas Joebges
> 
Always nice to find somebody else interested in the bagpipes.

Maybe I'm just being stupid, but the file you posted here isn't a csv (comma 
separated value) file.

Instead, it seems to be separated by semicolons.  If this is the case, I 
suggest you open this "CSV" file up in notepad or your favorite text editor, 
and do a seek & destroy operation with all semicolons to be replaced with 
commas.

Then, when you save the modified contents, name the file toonbook.csv or 
something like that.  Try and open it up in Excel or some other csv supported 
spreadsheet program first, then try and run csv2pdb.

Good luck, and cheers aye.

I'm always looking for my next bagpipe set on ebay.  I'll probably make a move 
after I get back from vacation.

Kyle

Re: [pilot-db-list] Converting CSV to PDB problems...

[Andreas J. <bag...@gm...>]

Hi,

this is not the solution. The documentation states that you can choose 
the separator (and I tried it out). I can not even retransform a csv 
database which I made from a PDB. I allway get the error.


ky...@ky... wrote:
> Maybe I'm just being stupid, but the file you posted here isn't a csv (comma 
> separated value) file.
> 
> Instead, it seems to be separated by semicolons.  If this is the case, I 
> suggest you open this "CSV" file up in notepad or your favorite text editor, 
> and do a seek & destroy operation with all semicolons to be replaced with 
> commas.
> 
> Then, when you save the modified contents, name the file toonbook.csv or 
> something like that.  Try and open it up in Excel or some other csv supported 
> spreadsheet program first, then try and run csv2pdb.