csv problem - the 2nd

[VipersGarden]

Hello, its me again!

DaDaBik 4.2
mySQL 5

When I save the exported CSV to my harddrive and import this into EXCEL, everything works perfect.
When I try to open it direct in EXCEL, column separator is not accepted, and all inserts (fields) are within one EXCEL-cell (I have the tab-stop separator now "\t"). But didnt work with others.

Any suggestions, please?

Mario



Post Edited (03-03-09 14:30)

 

[billthecat]

CSV stands for "Comma Separated Value". When you're using Excel to open the file and it goes through that wizard, make sure it's delimited fields, separated with comma (,) and your text qualifier is quote (")

 

[VipersGarden]

Sorry, billthecat,

doesn´t work with comma either.
But I was searching the net and found the answer.
In MS Excel from 2003 (XP) on, the column separator is the semilocon ";" and cannot be charged for the automatic section.

With semilocon it works perfect now!

Mario

 

[billthecat]

Did you change the config.php file to use semicolon?

// csv separator
$csv_separator = ";";