CSV Export
This topic contains 14 replies, has 8 voices, and was last updated by Paolo 10 years, 2 months ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support TicketTagged: Export CSV Import CSV
-
AuthorPosts
-
May 27, 2014 at 10:27 am #3075
Hello,
I would like to export the csv file of all the listings. I found the option of importing a csv and downloading a sample csv but not where to download the actual csv. Can you please tell me from where can i export it.Thanks!
May 27, 2014 at 11:08 am #3076Sorry, GD does not have any option to export data at this moment. I am not getting you, from where u are trying to export the csv and why ?
August 26, 2014 at 12:04 am #13111Just wondering – are there any plans to add this feature in the future?
September 6, 2014 at 12:55 pm #14510I really want to buy this product but really would like the export feature. Is it possible or if not alternative ? In essence I want to be able to present the info on various fields to people more familiar with excel.
October 22, 2014 at 11:20 am #19097I’ve just found out that I need to export my data in order to know the exact “field” names as I’ve customised the categories and field so much that it bears no resemblence to your example CSV. For example I’ve changed the contact field to Phone and added a new one for Mobile (sic: Cell). Does this mean I now have input fields called geodir_mobile …. or is my Phone field still called geodir_contact ?
I’m ready to load 740 entries and cannot go back and edit them individually if the fields load in the wrong place.
October 22, 2014 at 8:26 pm #19139You phone field will still be geodir_contact, but you have to add the custom fields you created at the end of the file.
Let us know,
October 23, 2014 at 11:12 am #19201I was looking at exporting listings from one custom post type to another with the same fields so I can remove the additional custom post type.
So there is no export options? sorry I am slightly confused with the setting for allowing export if there is no export option :/
October 23, 2014 at 11:26 am #19207OK Paulo, so are you saying that the “HTML variable name” for each field is what should be used but preceeded with geodir_ eg: see attached image = geodir_phone2
October 23, 2014 at 2:49 pm #19236OK everyone we’ve exported out test data as a CSV via PHP Admin (see attached).
The big mystery now is that the data does not match the header fields eg:Look at columns ‘V’ onwards. “post_latitude” is the field name for ‘address’. “geodir_timing” is the field name for ‘latitude number’. Everything is out of sync.
Any ideas as we tried a test IMPORT using the fields names and got the following: “11 out of 11 record(s) could not be inserted due to invalid/blank post type. Only use geodirectory’s post type.”
October 23, 2014 at 5:33 pm #19286Hi,
what you are trying to do is conceptually wrong.
You are exporting the data from the DB and trying to import it back from the CSV file.
If you wish to import anything from the CSV upload within GD, you must ONLY use the provided Sample file and add data to it in the right format as shown in the example. You can only add custom field usgin geodir_html_variable at the end of it.
Thanks,
October 23, 2014 at 6:13 pm #19307This reply has been marked as private.October 23, 2014 at 7:16 pm #19317Hi again Steve,
the file you sent is different from our sample file and have mixed up fields, some are missing, some that shouldn’t be in it are in it.
The original file should not be changed. You can only add data below headings keeping exact order.
post_title
post_author
post_content
post_category
post_tags
post_type
geodir_video
post_address
post_city
post_region
post_country
post_zip
post_latitude
post_longitude
geodir_timing
geodir_contact
geodir_email
geodir_website
geodir_twitter
geodir_facebook
IMAGE
IMAGE
IMAGE
IMAGE
IMAGECustom fields must be added at the end of the file only after the last IMAGE.
For example if you have added the CF cusine and features after the 5 images headings you would add:
geodir_cuisine
geodir_featuresand below the new column headings, the corresponding data for each listing.
I’m not 100% sure, but I think that it will accept listings without post_content. In any case it is worth a try.
Hope it is clearer now.
Thx
October 29, 2014 at 12:52 pm #19963Hooray !!! It works (apart from one issue which I’ll post as a seperate discussion.)
It wasn’t clear that you have to keep ALL the original field names in the same order and then add the new ones afterwards before importing. We were treating it as a CRM where it would automatically identify the fields and content regardless of order.
Thanks Paulo.
November 5, 2014 at 7:56 pm #20731These support threads are very poorly done in most of these, so, it never says, how do you export to csv, for example, backing up JUST your listings for later re-importing.
November 5, 2014 at 8:02 pm #20732Hi Chris,
it doesn’t say, because it’s an option provided by the plugin.
He’s exporting via phpmyadmin.
Thx
-
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket