Import Data

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

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

Open Support Ticket
  • Author
    Posts
  • September 3, 2017 at 9:46 am #394106

    Jay Kanabar
    Expired Member
    Post count: 166

    Get the following error when importing data:

    766 / 766 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).

    I did not want to import the address so switched off the location in the Multilocation (I think).

    Thanking you

    September 3, 2017 at 9:47 am #394107

    Jay Kanabar
    Expired Member
    Post count: 166
    This reply has been marked as private.
    September 3, 2017 at 12:32 pm #394114

    Guust
    Moderator
    Post count: 29970

    Post a sample of the CSV file if we need to have a look.
    https://wpgeodirectory.com/docs/core-export/

    Thanks

    September 3, 2017 at 6:06 pm #394124

    Jay Kanabar
    Expired Member
    Post count: 166
    This reply has been marked as private.
    September 3, 2017 at 10:10 pm #394131

    Guust
    Moderator
    Post count: 29970

    * Column default_category missing
    * post_author and post_title in incorrect order
    * geodir_video out of order
    * no pricing package or Listing Claims columns like claimed, package_id, alive_days, expire_date
    * no data in post_address, post_city and post_region, post_latitude and post_longitude
    * you are not using neighborhoods so should not have neighborhood columns
    * geodir_special_offers, linked_cpt_ID and geodir_Club_Introduction columns are missing

    I suggest you add at least one place from the frontend, and then export the file. That will give you the correctly structured CSV file.

    Thanks

    September 4, 2017 at 12:05 pm #394185

    Jay Kanabar
    Expired Member
    Post count: 166

    Hi Guust,

    I want most of the data to be completed by the user, accept the title (place name), and may be Zip Code and email.
    Is that possible?
    Why does all the field you mention need to be the key field to complete a record,
    particularly the point:
    “no data in post_address, post_city and post_region, post_latitude and post_longitude”

    September 4, 2017 at 12:53 pm #394194

    Guust
    Moderator
    Post count: 29970

    No that is not possible. Every listing needs a complete address or it cannot be shown on the map or added to the database.
    You can add whatever you like, but those fields cannot be blank.

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