Csv vs Csv

HI,

While on this site I noticed some difference with the format of CSV files.
I have created a file that has the "Hikashop" header names in row 1 from column A to column F. ( This format worked for me.)
Now, I also see that some user have the "Header" in column A only. But, the headers are separated with ";".

I know this is a generic example. But, can someone tell me why the difference?

Thanks

charlesdh wrote: HI,
Now, I also see that some user have the "Header" in column A only. But, the headers are separated with ";".

It''s not that all headers are in column A. This means that Excel didn't recognize csv format and you have to open it using "Get external data from text " on Data tab.
Excel recognize csv files with separator based on your system regional settings.

Korzo,

Thanks for your reply. But, I'm not sure if I explaned myself on I'm not understanding your response.
Attached you will see what I'm referring to.
Attachment 1 is a file that I created and saved as "CSV".


Attachment2 is the file that I was looking at and trying to understand the difference.

Second csv (hikashop-test.csv) is faulty.
There is mix of separators and in from second line, all separators are enclosed in quotes and therefore not recognized.
For example, here is snippet from csv: and here is corrected version:

Korzo,

Thanks for the update on the correct format for the product information. But, in "A1" there is a string of data that I would assume is the formatted "Header" information( attachment2). This data is different than the formatted "Header" information in attachment 1.

This is what I was referring to in my first reply.
According to your time zone and what you wrote, I suppose you have comma as csv separator in your regional settings.

File Test_2015-01-10.csv has comma as separator and it opens correctly in your Excel.
File hikashop-test.csv has semicolon as separator and it opens all data in one column.

For me it's exactly opposite situation as I have semicolon as default separator in regional settings.

If I missed the point of your question, please post the screenshot of your problem.

Korzo,

Thanks. I'll check into changing my settings.
To see how attachment2 loads.
All I have to do is find the option for this. The web site you referred me to say's I need to change "Regional" settings. I can not locate it per the direction on the web site.

You don't have to change your regional settings.
If Excel doesn't recognize your csv file format, use "Get external data from text" on Data tab to import data from csv.
There is interactive interface where you can select delimiter, data format etc.

Thanks.
In attachment2. That is the "Exported" file to excel.
I can now see why the "Header" is in "A1" and different than my file.

My file attachment1 is a file that is to be uploaded to "Hikashop".
I wrote a code to convert this file.


to the example in my original attachment1


I know this format works as I have already uploaded it via "Joomla" with the Ext.for "Hikashop".
Thanks for your help.

CSV files can have either commas or semi colons as separator. HikaShop can export CSVs with both. There is an option in the HikaShop configuration that you can use to select the CSV separator you want in the CSVs exported by HikaShop.
Both are valid but based on how you have configured your Excel (the language, the version, etc) or other CSV reader software, it might not handle properly one or the other and that's why we have that option.

nicolas,

Thanks. I reset the option and the export worked.
But, my primary concern was the format for a excel file (Csv) to be uploaded.
Between you and Korzo my thoughts are now straight.

Hi,

HikaShop can import both types of CSVs, with commas or semi colons, it doesn't matter, as long that it is a CSV with the column names corresponding to what HikaShop is expecting (like in the exported CSV).

nicolas,

Thanks.
My original confusion was when I look at a file that another user posted the "Hikashop Headers" were in "A1" and not across the columns.
With the file file that I uploaded thru "Joomla". I exported it and the data had a lot of ";". I then changed the Hikashop setting to ";" and exported again. This time the download was what I expected to see.

Once again thanks to you and Korzo.