Anyone uploaded a csv yet for import?
This topic contains 9 replies, has 8 voices, and was last updated by Pieter Ravelli 9 years ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support TicketTagged: import
-
AuthorPosts
-
April 27, 2014 at 6:16 pm #872
Anyone uploaded a csv yet for import?
April 27, 2014 at 6:40 pm #873Hi Nitefader,
I will be getting onto this hopefully a bit later tonight, I know I had a few issues with this last time, the csv file I managed to pull down from my old GT site doesn’t have the address in the correct order.
I went back to basics after a few fails and uploaded the sample csv to my new site, this works perfectly – I then worked my way through the csv replacing and deleting each coloumn for example:
1) I change the content for the title and did a test upload – All good
2) I left the content in the title row blank and did an upload – All goodI did this for nearly every column until I got the ‘no records added’ error – it seems that nearly every column can even be left blank and an upload is fine IF:
You have the following correct:
– Address
– City
– Region
– Country
– Zip
– Long
– LatAs far as my testing has gone, it will add the records if this information is correct – it also added the city – region and country to the map as well – i have only done this so far in testing.
I am a little concerned about having 100’s of cities and region all added to my directory, in the past i just has a worldwide include all GT directory that worked well.
I will update as I go
Cheers
April 28, 2014 at 5:36 am #880Hi Nitefader,
Plz let me know if u have any problem after get such a helpful explanation from Strou.
Advise ?
Thanks
April 28, 2014 at 4:50 pm #929demo has been built through CSV imports and it worked flawlessly. Not that many listings, but not one error while uploading them either…
See here the full documentation about importing and exporting a csv with GeoDirectory
April 28, 2014 at 8:42 pm #936Just to confirm…
I agree with the team here… just pull down the sample csv and open in OPEN OFFICE (don’t use excel) – you will be successful if you use the demo csv file in open office software which is FREE for mac and PC – YOU MUST have the following columns completed for every place in your csv file:
post_type I put: gd_place
post_address I put the full address I had, mine are not complete
post_city I put the word ‘city’
post_region I put the word ‘region’
post_country I put the word ‘country’
post_zip I put the word ‘postcode’
post_latitude All my listings are geo coded so this must be put in
post_longitude All my listings are geo coded so this must be put inThe only other things I completed on the file was
post_title
geodir_timing
geodir_contactEvery other column was left blank – when I say blank I mean the structure of the file and headers were NOT TOUCHED – but the fields below were left empty ( see file attached)
The reason why I did the above is two fold, One – I am not looking for a directory that runs by city or region, I want a single worldwide searchable directory – also it looked very busy when I started entering 100’s of cities and region’s – also your database needs to be 110% clean and broken down exactly as above for the directory to work as it should, ie. when searching by city, region zip etc… if any of the columns for any of your places are missing a zip, region etc – the file will not load or will fail while loading…
And Two.. I needed this running NOW, I have would rather have everything uploaded and then can work on changing or cleaning things at my leisure.
If you are starting a brand new venture or directory the team has done you a massive favour, just use the sample csv file with the correct software and you should be fine…
Remember to only upload 250 listings a time – I uploaded 250 then saved that csv file (250-1) then another 250 and saved (250-2) this means if things go wrong I haven’t over written just one file and then have to start again.
Things I recommend you do to save yourself from going a little crazy..
** if you have a spare site or test install – play for a day testing things and learn what not to do – I broke the plugin twice 😉
Now…
1) Start with a completely clean install and immediately back it up – so you can revert back to that completely untouched install if you need to.
2) Install required core and plugins and activate – the first time I put in demo data which later caused trouble so I would avoid.
3) I would then complete all the settings in the plugin, going through every option even if you think you don’t need to and save each section.
4) Download the Open office which is FREE
5) Download the sample CSV and open in Open Office – now save it and upload it to the new site – if it works go back to the file in Open Office and remove the three demo places and put a single one of your places in the file and save – upload – if this works you know you have the ability to upload all your places, if it doesn’t and it did with the demo places you have done something wrong… you have to then work out what you did – but if you follow my guide above you can’t go far wrong.
6) Don’t try and upload to many files at once – I found 250 to be a happy number.
Problems I found…
1) Open Office sometimes drops of zero’s from the end of your geocoded addresses – right click on the longitude and latitude columns – go to ‘format cells’ and drop to ‘text’ input and click ok.
NOT RELATED TO THE ABOVE
1) Flex slider caused problems in my theme so I switched to elastic slide.
2) I had the image problems – again this was under flew slider in css, I removed the min width and height.
3) Under events – if a show runs over three days it shouldn’t have three entries – ideal home show is on for 2 months nearly so it would have 50 entries?
I hope this helps.
Dave
June 17, 2014 at 5:11 am #4442Hello,
I am importing csv but its give error for address field because i have not specified latitude and longitutde, if i specified then it insert correctly.
can you Pleae give me clear picture that it should not asked for lat/long instead it should automatically set by going through address when importing csv..
Please Reply ASAP
Thanks
June 17, 2014 at 7:42 am #4455At the moment you need to specify Lat and Lon, don’t know if this is going to be addressed in the future?
June 17, 2014 at 9:08 am #4474Thanks for replying, there is no other way that it must automatically set the lat and long while importing csv rather than manually adding it..
September 2, 2015 at 11:02 am #51666Working on client project and trying to import sample csv and getting ERROR
Fail, something wrong to create csv file.
please let me know the fix,
: ALL PHP requrements and fodler permissions are set as per requirements.
December 4, 2015 at 11:19 pm #62631There is a workflow:
– Import gd samples;
– Open .csv and select first column (A);
– Data > text to column > folow instructions (save and keep row’s 1+2);
– Copy/paste address in this long/lat converter (external link);
– Change long and lat column’s property’s to text;
– Copy/past long/lat data + rest of your own data in Excel (.xls);
– Select table and give selection field a name (see: image);
– Delete other .xls tab’s from the bottom of your spread sheet (see: image)
– Use .csv converter (download zip file);
– unzip file with basic winRAR Upload .csv file.Now the problem remains that listings are the quality service’s that I (want) to provide. As it seems, I need helpers that visit my site and optimize my data(service). It seems so that, my visitors have to (re)visit all my uploaded custom post types to “accept” the long/lat coordinates I have imported.
Does anyone get my point of getting a way to upload great (long/lat-)data and getting a perfect gd-response?
Neither, me or my potential costumers, service takers and/or visitors are willing to compromise but, like the GDmap (widgit) visible without moderate/edit CPT’s to make our databases; need, current and complete.
My motivation, asking for help? I researched a lot of functionalities and found a perfect combination for my business-model. I solved Kleo theme, Geodirectory in combination with *multy site, issue’s but one;
“Please support the direct-set-location-on-map cause to not-have-to-visit-individual-costum-post-types-begore-gd-is-set-on.”
🙂
Sebastiaan -
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket