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