35% OFF EVERYTHING
WordPress 21st BIRTHDAY SALE
Buy Now

Problems with CSV import

This topic contains 13 replies, has 5 voices, and was last updated by  Paolo 5 years, 11 months ago.

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

Open Support Ticket
  • Author
    Posts
  • June 6, 2018 at 1:56 pm #433940

    Sameep Kaul
    Expired Member
    Post count: 12

    Hey! How are you? I’m having trouble uploading listings through the bulk import feature. I keep getting the error: 1 / 1 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).

    I’m not sure what the problem is. I used the sample CSV file and just changed some data. I’ve attached the modified sample file I’m trying to upload.

    Thanks in advance.

    June 6, 2018 at 2:19 pm #433945

    Kor
    Moderator
    Post count: 16516

    Hi Sameep,

    Could you please share WP admin access in private reply so that we could check on it?

    Thanks!

    June 6, 2018 at 2:38 pm #433948

    Sameep Kaul
    Expired Member
    Post count: 12
    This reply has been marked as private.
    June 6, 2018 at 2:39 pm #433949

    Sameep Kaul
    Expired Member
    Post count: 12
    This reply has been marked as private.
    June 6, 2018 at 8:19 pm #433984

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    I cannot see any immediate formatting issues with the sheet. Have you tried adding the listing manually and comparing the values you are trying to import?

    Which editor did you use? Only LibreOffice is recommended.

    https://wpgeodirectory.com/docs/core-export/#import

    June 6, 2018 at 8:22 pm #433985

    Paolo
    Site Admin
    Post count: 31206

    HI,

    your location are a bit of a mess. You don’t have a default location and that is causing most of the problems. You probably activated the location manager before creating a default location.

    Please deactivate the location manager, set your default location and than reactivate the location manager.

    Once that done the import should work fine.

    Let us know how it goes,

    Thanks

    June 6, 2018 at 9:30 pm #434001

    Sameep Kaul
    Expired Member
    Post count: 12

    Thanks. I tried that and I’m still having the same problem. I deactivated the multi location, set New York as the default location and then re-enabled multi location. I even used a new CSV. I’m still getting the same error. I’m attaching the new CSV to this message in case you want to check it out.

    June 6, 2018 at 9:36 pm #434003

    Paolo
    Site Admin
    Post count: 31206

    The error is in the CSV now.

    You have city : New York City
    Region : blank
    Country : United States.

    You must have:

    City: New York
    Region: New York
    Country: United States

    All the rest in the CSV looks good. Your location are still a mess. You should delete them all and only add location while adding a listing for that location. Having empty locations is a big mistakes that will cause your website to have countless soft 404 errors.

    Thanks

    June 7, 2018 at 8:15 am #434067

    Sameep Kaul
    Expired Member
    Post count: 12

    Thanks a lot. Is there any quick way to delete all the locations? The one from the dashboard only deletes a few at a time and will take forever.

    June 7, 2018 at 8:21 am #434069

    Sameep Kaul
    Expired Member
    Post count: 12

    I figured out how to delete all the locations and I’ve done it. I’m still having a problem with the CSV. I modified it as per your instructions. I’ve attached it to this message.

    June 7, 2018 at 5:44 pm #434120

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    this is very strange, everything looks correct to me too now. Could you provide FTP credentials so that we can check the debug log for more info about the error?

    Let us know,

    Thanks

    June 8, 2018 at 6:43 am #434172

    Kiran
    Moderator
    Post count: 7069

    Hi Sameep,

    There are illegal characters in description & address field (see attachment). I corrected it and now it successfully imported.

    I have attached corrected csv file.

    Thanks,
    Kiran

    June 10, 2018 at 8:21 am #434389

    Sameep Kaul
    Expired Member
    Post count: 12

    Great. Thanks a lot for all your help.

    June 10, 2018 at 4:49 pm #434430

    Paolo
    Site Admin
    Post count: 31206

    Thanks Kiran!

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

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

Open Support Ticket