Bug – CSV export column data misalignment

This topic contains 4 replies, has 2 voices, and was last updated by Paul Rogers 8 years, 7 months ago.

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

Open Support Ticket

Tagged: CSV

Author

Posts
April 26, 2016 at 10:07 am #171011

Paul Rogers
Buyer

Post count: 75

I am getting misaligned data when I export a place to csv

The first column misaligned is post_region which contains the post_zip value and everything from then on i wrong

I am testing the import functionality at the moment and will let you know if this is also a problem.

All was ok prior to latest release but to confuse matters I have just added custom fields o not sure if the issue is related to custom fields or the latest release.

I have attached example of problematic CSV

April 26, 2016 at 11:31 am #171025

Guust
Moderator

Post count: 29970

The first wrong field is actually the address field. It contains street address, city and region, and that is why everything shifts up two columns.

Can we have a look at your admin area? Post your URL and WP admin details in a private reply, so we can check things out.

April 26, 2016 at 11:45 am #171031

Paul Rogers
Buyer

Post count: 75

This reply has been marked as private.

April 26, 2016 at 12:04 pm #171035

Guust
Moderator

Post count: 29970

The problem was that the Street address was put in quotes, so that tripped the CSV.
Once the quotes are deleted, the CSV works fine.

April 26, 2016 at 12:28 pm #171040

Paul Rogers
Buyer

Post count: 75

Ahh! So I need to change the delimiters for opening the CSV file? Thanks for a speedy response
Author

Posts

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