Bug – CSV export column data misalignment

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

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • #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

    #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.

    #171031

    Paul Rogers
    Buyer
    Post count: 75
    This reply has been marked as private.
    #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.

    #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

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
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount