Using Ezpopulate with Excel csv

[patternstore]

We have our inventory in excel csv file. I have read the ezpopulate docs but it says it can't work with excel csv??? Does anyone know how to configure this so it will import? Would pay if job done.

 

thanks.

 

derek

www.patternstore.com

[VJ]

I'm sure there's an option to export an Excel csv file as tab-delimited.

 

Or, you could try to alter the following code in admin/easypopulate.php (to use a comma), and give it a shot.

 

// **** Field Separator ****
// change this if you can't use the default of tabs
// Tab is the default, comma and semicolon are commonly supported by various progs
// Remember, if your descriptions contain this character, you will confuse EP!
global $separator;
$separator = "\t"; // tab is default
//$separator = ","; // comma
//$separator = ";"; // semi-colon
//$separator = "~"; // tilde
//$separator = "-"; // dash
//$separator = "*"; // splat

 

HTH,

VJ