Basic do's and don'ts of importing questions

This topic contains 4 replies, has 3 voices, and was last updated by  Sam 9 years, 7 months ago.

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

Open Support Ticket
  • Author
    Posts
  • October 9, 2014 at 5:21 pm #17890

    Sam
    Expired Member
    Post count: 27

    I got the look of my gd to my liking and am ready to import my database.

    I saw the “CSV upload” area in geodirectory. I downloaded the sample csv file and took a look at it. I have most of the information, except the google map coordinates. Do I simply just delete the dummy data in the sample csv file (place_listing.csv) and replace it with my information and then upload the file?

    Do I just leave the google maps coordinates column blank? Is this fine?

    Is it okay to be working in excel 2010 to modify the sample csv file?

    Is there any specific name that the file should be saved as before uploading?

    Is there any special considerations that need to be made before uploading my database?

    All help is appreciated. Thanks.

    October 9, 2014 at 5:40 pm #17894

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    all questions should be answered here: http://docs.wpgeodirectory.com/core-general/#csv

    Let us know,

    Thx

    October 10, 2014 at 5:13 am #17926

    Sam
    Expired Member
    Post count: 27

    Thanks for the link. It answered most of my questions. A few more questions:

    1.
    Does the name of the file matter?

    2.
    Regarding post_latitude and post_longitude. I noticed that page said that it was manditory. Can geodirectory auto generate these somehow? I have a database of 4000 businesses with addresses. The links provided for generating coordinates do not have any batching options.

    October 10, 2014 at 10:53 am #17955

    Guust
    Moderator
    Post count: 29970

    1. No
    2. The second link has a batch option:
    http://www.findlatitudeandlongitude.com/batch-geocode/#.VDe6NhY0-GQ
    GD can only auto-generate if you add listings one by one.

    October 10, 2014 at 5:46 pm #17982

    Sam
    Expired Member
    Post count: 27

    okay, thanks.

    missed it on the 2nd link. will check 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