CSV Won't Import

This topic contains 4 replies, has 2 voices, and was last updated by  Jacob Paulsen 7 years, 9 months ago.

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

Open Support Ticket
  • Author
    Posts
  • August 6, 2016 at 5:16 am #241679

    Jacob Paulsen
    Full Member
    Post count: 45

    Team, In the past when I first started using GeoDirectory I imported about 83000 businesses. Now… a few months later I just tried and failed to upload some more businesses using the same format as before. I’m attaching a CSV file.

    I get error blank/invalid address.

    Let me know if you would like login access.

    Jacob

    August 6, 2016 at 6:26 am #241747

    Guust
    Moderator
    Post count: 29970

    Post_id and default_category columns are missing – maybe others too.
    Other columns are out of order.
    Invalid characters like �

    Best is to download a CSV from your site and use that as a basis.
    https://wpgeodirectory.com/docs/core-export/#important

    August 6, 2016 at 12:41 pm #241992

    Jacob Paulsen
    Full Member
    Post count: 45

    Thank you. When I open the file, I see those columns and I don’t see the symbols. What program are you using our do you recommend to look at the files or generate the CSV?

    Jacob

    August 6, 2016 at 12:46 pm #241995

    Guust
    Moderator
    Post count: 29970

    From https://wpgeodirectory.com/docs/core-export/#important

    CSV files should only be edited with OpenOffice or LibreOffice Calc. This is because Microsoft Excel has auto-formatting built in which can not be disabled; we have seen many cases where this leads to broken phone numbers, addresses and 90% of the time wrong GPS information.

    August 6, 2016 at 5:47 pm #242075

    Jacob Paulsen
    Full Member
    Post count: 45

    Thank you sooo much for your speedy help. I will report back if I still can’t figure it out.

  • 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