too many variants to allow csv download

hello,

I'm trying to download a csv file in order to upload my listings to a seperate website. the problem I have is that I have too many characteristics so excel can't open the file properly. is there some way around this that you know of? or is this something I need to ask about in an excel forum...

Tanya

Hi,

I'm afraid we can't help you with excel problems unfortunately as it's not our speciality. Looking a bit around, it sounds like it's only a problem in Excel 2003 and previous versions:
www.cpearson.com/excel/ImportBigFiles.aspx

ok thanks for that.

I understand that I can edit what columns appear in the export to excel by editing the file 'export'.
say i want to remove the collumn 'price_min_quantity' from the export, what parts of the file do i need to delete to achieve this?

Tanya

You would have to remove the line:
$columns='price_min_quantity';

and change the code:
if(empty($values)){
echo '""'.$separator.'""'.$separator.'""'.$separator.'""'.$separator;
}else{
echo '"'.implode('|',$values).'"'.$separator.'"'.implode('|',$codes).'"'.$separator.'"'.implode('|',$qtys).'"'.$separator.'"'.implode('|',$accesses).'"'.$separator;
}

to:
if(empty($values)){
echo '""'.$separator.'""'.$separator.'""'.$separator;
}else{
echo '"'.implode('|',$values).'"'.$separator.'"'.implode('|',$codes).'"'.$separator.'"'.implode('|',$accesses).'"'.$separator;
}