Import CSV

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

Open Support Ticket

Tagged: Import CSV, neighborhoods

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