Column Data not in correct Columns following .CSV export

  • Posts: 15
  • Thank you received: 0
1 week 2 days ago #324001

-- url of the page with the problem -- : hallamfc.co.uk
-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.8.7

Hello,

We are exporting our Orders to .csv and have noticed that the " appears in every cell surrounding the data. We are having to Find and Replace this with a Space to remove it.
When we then Separate the data into Columns using the Semicolon the data is not sitting under the right Columns.

item1_order_product_name contains City data as an example.

I have shared a snip of an export showing some of this behavior.

We assume we are not doing this correctly so require some assistance on exporting and separating in Excel.

Able to help please?
John

Attachments:
Last edit: 1 week 2 days ago by stonedbloke.

Please Log in or Create an account to join the conversation.

  • Posts: 15
  • Thank you received: 0
1 week 2 days ago #324004

Following further reading I have found that going into the System Configuration and changing the CSV separator from the default Semicolon to a Comma output the data into the correct columns in Excel without having to find and replace the speech marks.

Hope this helps someone else.

Please Log in or Create an account to join the conversation.

  • Posts: 70518
  • Thank you received: 10587
  • MODERATOR
1 week 2 days ago #324008

Hi,

For others reading this, not that you can actually not change anything in HikaShop and open the CSV file fine in Excel, but you need to do it via the import tool there so that you can choose the separator etc:
www.copytrans.net/support/how-to-open-a-csv-file-in-excel/

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum