Export CSV gives strange result

-- url of the page with the problem -- : www.ckdev.info/daeg
-- HikaShop version -- : 2.3.4
-- Joomla version -- : 2.5.27
-- PHP version -- : 5.3.29

My client asked me to export a CSV to help set up his Amazon shop. I hit export (nothing selected) and sent the file to the company he's using for the Amazon setup.

Just got a call from them saying the file is unusable and is impossible to follow. I have no idea - if I hit export I just expect to get a file that is of some use. All the column names. for instance are in A1 - not spread along the A row which is what I'd expect.

I've attached the output CSV.

Hi,

I am sorry but I don't see what is strange in the CSV you got.

Regards,

All the product headers are in A1. Shouldn't these be above their respective entries over the whole top row?

product_id;"product_parent_id";"product_name";"product_description";

Shouldn't these be in cells A1, B1, C1, D1? It seems illogical to have them all in A1. How will the person using the data ever map fields? I have always seen this type of dump appear in it's own columns.

Hi,

When you open the CSV with a spreadsheet software, you can logically select the column separator character.
In the generated CSV you got, the column separator character is the semi colon " ; ".

Regards,

Jerome

I'm really not sure what you're trying to say there. Why are all the column headers in one cell rather than different cells. Makes the CSV unusable to the person setting up Amazon for my client as he can't map anything.

Hi,

The CSV is a valid and working CSV file ; you just have to open it with a software which can manage the CSV file using a ";" as separator.

en.wikipedia.org/wiki/Comma-separated_values

Example of an analogous European CSV/DSV file (where the decimal separator is a comma and the value separator is a semicolon):

Code:

Year;Make;Model;Length 1997;Ford;E350;2,34 2000;Mercury;Cougar;2,38

Because the coma can be a decimal separator, we are using the semi colon as separator ; it still produce a valid CSV file.

Regards,