Import woes!

This topic contains 13 replies, has 3 voices, and was last updated by  Josh Elledge 9 years, 6 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • #40763

    Josh Elledge
    Expired Member
    Post count: 11

    Happy to go full-tilt boogie with this plugin – but I could use help with importing. Currently, I cannot even import the exported sample content (even without opening the file locally). I keep getting:

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

    I’ve reviewed every bit of info on the subject – and have tried everything I can think of to get this to work.

    #40764

    Josh Elledge
    Expired Member
    Post count: 11
    This reply has been marked as private.
    #40782

    Simone
    Expired Member
    Post count: 3515

    Hello Josh, and welcome on board.
    I tried to login but it won’t let me in, could you please check the login details? Thanks

    #40786

    Josh Elledge
    Expired Member
    Post count: 11
    This reply has been marked as private.
    #40791

    Simone
    Expired Member
    Post count: 3515

    Hello Josh, you had that error because you don’t have the MultiLocation addon, and your default city is Orlando, FL.
    In the sample CSV there are three listings, with three different cities in the US, the free GD plugin allows only one default city.
    I tried to upload a CSV with three different listings from the same city (Orlando) and it works as expected, attached you can find the sample .csv I used

    #40795

    Josh Elledge
    Expired Member
    Post count: 11

    Ahhh… I didn’t catch that. Thanks.

    #40872

    Josh Elledge
    Expired Member
    Post count: 11

    If you don’t mind me asking a related question prior to purchase…

    How will a large bulk import likely work? I have 20k records. Another plugin I was trying would simply time out after 22 records. I could increase my timeout limit significantly – but this felt like a bad path as it would kill my server during the process – which I believed would last more than a day.

    #40874

    Josh Elledge
    Expired Member
    Post count: 11
    This reply has been marked as private.
    #40898

    Simone
    Expired Member
    Post count: 3515

    Hi Josh, 20k records are quite a big number, I personally would split them in multiple files, it is easy, straightforward and quick to do 🙂
    I will check your .csv soon and get back at you asap.

    #40902

    Simone
    Expired Member
    Post count: 3515

    Ok, here we are..

    issues:

    1- author mush have the ID, your id in this case is number 1
    2- custom fields should have appended geodir_ before the name, e.g., geodir_editor if the html variable name is “editor”, as in your case.
    3- most important: you had in your region, FL, which is wrong, the correct region name must be as set in the Location, Florida.

    #40903

    Simone
    Expired Member
    Post count: 3515
    This reply has been marked as private.
    #41350

    Josh Elledge
    Expired Member
    Post count: 11

    Hey – thank you so much for this. I want to test with a big file to see how it works – since getting 20K records into my database is mission critical. I’ll see how big of batches I can get away with. It looks like geodirectory handles imports different than the other plugin I tried that would simply time out after 22 records. 1000 import processes won’t work for me! 🙂

    #41356

    Paolo
    Site Admin
    Post count: 31206

    I’ve imported files with over 20k listings on our dedicated server in one file.

    It really depends on your server’s resources, but I think that on any decent VPS, files with +5000 listings should be a problem.

    Our import is Ajax based, so it does 1 listings at a time to avoid time out problems…

    Let us know how you went!

    The import export feature is quite new and some fine tuning could still be nevessary.

    Thanks

    #41387

    Josh Elledge
    Expired Member
    Post count: 11

    I love this and upgraded today. Thank you for the excellent support. Things are starting to look really good!

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