40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Issue with Addresses

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

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

Open Support Ticket
  • Author
    Posts
  • August 20, 2017 at 1:06 pm #392058

    Caroline Baxter
    Expired Member
    Post count: 68

    Hi,

    I’ve an issue with the addresses while importing the listings. I exported and downloaded the sample sheet to get an idea of how to import the listings. The sample sheet has the following fields for addresses:

    post_address, post_city, post_region, post_country, post_zip

    On the database that I have some of the addresses are in a format which don’t fit the sample sheet that I downloaded. For example, this address RON YOUNG MOTORS LTD,UNIT E4 / E5,MERIDIAN INDUSTRIAL ESTATE,HOYLE ROAD,PEACEHAVEN,BN10 8LW does not have the region part. We don’t know how we will fill out the sample sheet with addresses that are formatted like this. Because this part of the address UNIT E4 / E5,MERIDIAN INDUSTRIAL ESTATE,HOYLE ROAD is the main address and should go into the address field, there is no region
    part, Peacehaven will go to city field and then BN10 8LW can go into the zip field. I tried importing this listing but it won’t. If I split the address somehow to fit the fields on the sample sheet, it does import but because the data is not correct and hence the map on the listings page doesn’t update correctly.

    Can you help me with this please?

    Thanks

    August 20, 2017 at 1:34 pm #392060

    Guust
    Moderator
    Post count: 29970

    Please review https://wpgeodirectory.com/docs/definitions/#location
    So to get the region, you can paste the address in the street address field, and let Google do its magic.
    See image.
    Thanks

    August 20, 2017 at 1:42 pm #392062

    Caroline Baxter
    Expired Member
    Post count: 68

    You’re right but it’s not possible for us to do that for all the addresses one by one – as they are in thousands. I need to import the listings. Do you see?

    August 20, 2017 at 1:50 pm #392064

    Caroline Baxter
    Expired Member
    Post count: 68

    I have attached a sample sheet from the database, can you guide me on how to go about setting this up for the import? Thanks

    August 20, 2017 at 1:59 pm #392067

    Guust
    Moderator
    Post count: 29970

    That will never work like that, the columns need to have exactly the same name as an exported test CSV, and needs all the compulsory data:
    https://wpgeodirectory.com/docs/core-export/
    https://wpgeodirectory.com/docs/core-export/#important

    To do batches, see some resources here: https://wpgeodirectory.com/docs/core-export/#resources

    Thanks

    August 20, 2017 at 2:19 pm #392068

    Caroline Baxter
    Expired Member
    Post count: 68

    So the region field cannot be empty?

    August 20, 2017 at 11:19 pm #392085

    Guust
    Moderator
    Post count: 29970

    No, the region field cannot be empty.
    And it is also used to create pages and maps relevant for that region.

    Thanks

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)

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

Open Support Ticket