CSV Export appearantly does not really work

This topic contains 3 replies, has 3 voices, and was last updated by terrencehill 9 years, 5 months ago.

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

Open Support Ticket

Tagged: CSV, export

Author

Posts
June 1, 2015 at 10:46 pm #41244

terrencehill
Buyer

Post count: 26

Hello all!

Unfortunately I seem to encounter a problem when using the EXPORT function. No matter what kind of CPT i export, when I open the exported CSV-file and try to process it via EXCEL the columns start off correctly but then everything ends up in chaos. data is in the wrong columns etc….
I also encountered the issue using the freeware “CSV VIEWER”.

June 2, 2015 at 12:24 pm #41291

Simone
Expired Member

Post count: 3515

Hello, it is probably due to a wrong character used as delimiter, please use COMMA.

June 2, 2015 at 5:23 pm #41319

Paolo
Site Admin

Post count: 31206

Make sure to only use Open Office or Libre Office.

This are the only 2 CSV editing softwares that we know for sure it will work and that we support.

If using one of the 2 still doesn’t work, provide url and admin credentials for the website and we will have a look at your issue.

Thanks

June 2, 2015 at 5:40 pm #41322

terrencehill
Buyer

Post count: 26

Wow, its really just LIBRE and OPEN office that is compatible! I downloaded Libre and now it works thx! I was aware that it wont work with Excel, so i tried a freeware called CSV Viewer…but that didnt help at all. So its really only LIBRE and OPEN office compatible….Thanks!
Author

Posts

Viewing 4 posts - 1 through 4 (of 4 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