CSV Import Question

This topic contains 2 replies, has 2 voices, and was last updated by Trex888 10 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Author

Posts
May 12, 2014 at 4:04 pm #1853

Trex888
Expired Member

Post count: 101

When I download the sample csv and upload it through the CSV Upload page all works fine. As soon as I open and resave that same file, the import no longer works. I’m opening/saving the file in OpenOffice and believe my settings are not quite right and so the file is opening, then saving in the wrong format. Here’s what I see when I open the sample CSV:

Can anyone indicate what needs to be selected or unselected in order for the csv to open and save properly?

May 12, 2014 at 4:25 pm #1857

Paolo
Site Admin

Post count: 31206

HI,

that is the correct format when opening it.

Demlimiters must be , (commas) and ” (double quotes).

Make sure when saving this is the format too.

http://stackoverflow.com/questions/10905588/exporting-csv-properly-open-office-save-numbers-as-text

May 12, 2014 at 11:53 pm #1873

Trex888
Expired Member

Post count: 101

Thanks Paolo,

It was saving that was causing the issue. I followed the instructions in the link you provided and all is perfect. For anyone else that’s got slightly different OpenOffice settings, the key when saving is to select Edit Filter Settings in the Save As screen, then change the Character Set to Unicode (UTF-8) in the popup.

T
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Hurry! Get your 20% discount before it expires. Get 20% Discount