GD location import (Upload) not working on csv

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

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

Open Support Ticket
  • Author
    Posts
  • #295597

    loibor
    Expired Member
    Post count: 3

    Hello Support

    i have tried to change change my csv to suite the conditions to upload but fail always the same error massage( item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).)
    and all is fine i have no idea what is wrong but for sure something is hidden. i change the codes to upload all and edit, but in vein.

    someone help me

    #296261

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    please provide a link to your website and admin credentials in a private reply and also attach a copy of the CSV file you are trying to import and we will have a look.

    Thank you,

    #296778

    loibor
    Expired Member
    Post count: 3
    This reply has been marked as private.
    #296781

    loibor
    Expired Member
    Post count: 3
    This reply has been marked as private.
    #296899

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    there are few things that are not correct.

    1) the file was saved with wrong separators.

    CSV means Comma Separated Values.

    If I try to open your file as CSV, I get all data in the 1st cell (see image attached 1.jpg)

    If I try to open it using semicolon as separators it looks as it should (see image attached 2.jpg)

    You need to open the file and save it with the correct separators. Please see: https://wpgeodirectory.com/support/topic/bulk-csv-importer-now-working/#post-131913

    2) The location ID column should be blank when importing. The application will set the ID after the import is completed.

    3) You don’t really need to import the locations in advance. You can set your default location and in MultiLocations settings set the directory to only use the default Country. So the directory will be restricted to Switzerland.

    Locations are created automatically when adding new listings from the both the front or back end. They are also created automatically when importing listings in bulk.

    Hope this helps.

    Thanks

    #302539

    loibor
    Expired Member
    Post count: 3

    Thanks allot you are good. it works at the end using the same method but not in bulk i have divided into small csv.

    Your support was of Great help

    #302776

    Paolo
    Site Admin
    Post count: 31211

    You are welcome 🙂

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