Import CSV

This topic contains 17 replies, has 10 voices, and was last updated by  Tasara T Rusike 8 years, 8 months ago.

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • May 26, 2014 at 10:55 am #3034

    mkblogic
    Expired Member
    Post count: 5

    Hello Support,

    I am trying to upload a file with companies.

    I have attached the file. I have tried different things, but it wont import.

    Very important, this is just small subset.

    May 26, 2014 at 11:24 am #3036

    Vikas
    Full Member
    Post count: 1128

    Plz specify correct ‘Region’ as the part of address for the Place.
    I found that Region field is blank in ur css.

    Here you find the full documentation about import csv for GeoDirectory
    Thanks

    May 26, 2014 at 11:26 am #3037

    Vikas
    Full Member
    Post count: 1128

    And correct longitude and latitude too.

    May 26, 2014 at 11:32 am #3038

    mkblogic
    Expired Member
    Post count: 5

    Thanks for your quick reply!

    Is it a problem that it’s in the Netherlands? We have a different notation for street address.

    The longitude and latitude are required? I don’t have that information.

    Is there a tool that can do that?

    May 26, 2014 at 1:19 pm #3045

    Vikas
    Full Member
    Post count: 1128

    Yes, i think if u will use maps.google.com and put address, it will return longitude and latitude of it.

    Thanks

    May 29, 2014 at 9:08 pm #3236

    Paolo
    Site Admin
    Post count: 31206

    or you can use a tool like this:

    http://www.findlatitudeandlongitude.com/batch-geocode/

    June 25, 2014 at 5:15 pm #6151

    abhishek
    Free User
    Post count: 2

    hello when i try to upload my csv it it says Data inserted successfully.
    Total of 0 records inserted. and im not able to find the data which i inserted and i dont know the reason why..the screenshot of what is showing is attached please let me know as soon as possible
    Thank you

    June 26, 2014 at 6:48 am #6228

    abhishek
    Free User
    Post count: 2

    Its weird the sample csv file which i downloaded is not importing the data.. I mean i did not modify the sample file and i tried to upload the exact same sample file which i downloaded but it show this messages

    “Data inserted successfully.
    Total of 0 records inserted.
    Total of 3 records not inserted due to invalid address.
    Please trasfer all images in ‘/wp_content/uploads /2014/06 ‘ folder.”

    i dont know how i will upload my csv if im unable to upload the sample csv which i downloaded from your plugin only.
    please i request wpgeodirtectory site admin to solve this issues

    I am attaching the sample file i downloaded please have a look and help
    Thank you

    July 5, 2014 at 7:56 pm #7574

    drashida
    Expired Member
    Post count: 129

    Hello,

    I cannot import my CSV. Please see attached. I believe I have filled out all mandatory fields correctly.

    Also, I have created neighborhoods in my goedirectory. Can we import neighborhoods? If so, how?

    Thank you.

    July 5, 2014 at 8:24 pm #7577

    drashida
    Expired Member
    Post count: 129

    Hi,

    I have cleaned up my csv file a bit but it doesn’t seem to matter. Please see attached.

    July 5, 2014 at 8:37 pm #7579

    drashida
    Expired Member
    Post count: 129
    This reply has been marked as private.
    July 7, 2014 at 2:31 pm #7674

    Vikas
    Full Member
    Post count: 1128

    @drashida
    I am looking into it and get back to asap with the solution.

    July 8, 2014 at 8:03 am #7753

    Vikas
    Full Member
    Post count: 1128

    Hi,
    Thanks for spotting such a rare issue. I have fixed it and it will work fine in next release.
    There was an issue in ur csv too. Instead of userid, u wrote ‘admin’, so please replace that text with real id of admin user, probably it will 1.

    If u need a quick solution then plz download attached zip, extract it and upload admin_functions.php file to geodirectory > geodirectory-admin > admin-functions.php

    Thanks

    August 7, 2014 at 3:38 am #11262

    Mike McClellan
    Lifetime Member
    Post count: 11

    Has the next release you discussed been released, or do we still need to manually update the admin_functions.php file. I’m running Version 1.1.8.

    August 27, 2014 at 1:32 am #13274

    TØm Babwá
    Buyer
    Post count: 42

    Hello,

    When I tried to upload data, I got a message “data inserted successfuly” but no datas are uploaded.

    I tried to use the patch of Vikas and I got a new error message “Please trasfer all images in ‘/wp_content/uploads/ ‘ folder”.

    Here my CSV example file :
    https://drive.google.com/file/d/0B9uJ_PXc-ZX_a0xjQ1FseXZTLTQ/edit?usp=sharing

    I put images in the following folders:
    /wp_content/uploads/
    /wp_content/uploads/2014/08/

    I saw mandatory fields are : « post_title, post_author (the ID), post_category, post_type, post_address, post_city, post_region, post_country, post_zip, post_latitude, post_longitude »

    Each mandatory fields was full.

    What is wrong in my file ?

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

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

Open Support Ticket