GD not importing csv
This topic contains 17 replies, has 5 voices, and was last updated by Paolo 8 years, 12 months ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support TicketTagged: importing
-
AuthorPosts
-
October 12, 2015 at 3:49 am #56585
GD is not importing my data at all. I purchased GD Framework plus addons days ago via Theme Tailors:)
I read the https://wpgeodirectory.com/docs/core-export/ several times and used OpenOffice to create the csv. I have 78 rows (records) but the import says I hve 135 rows (see below). My default location is USA and all data is from the USA only until I get money for the multilocation plugin. The csv file is https://www.dropbox.com/s/zqqfyrf4anfkhgu/shlistingallusa.csv?dl=0
Here’s the error message I get.
Total 135 item(s) found.
135 / 135 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
135 / 135 item(s) could not be added due to blank title/invalid post type.
October 12, 2015 at 5:12 pm #56616Hi,
I see a couple of issues with that file. 1st it isn’t saved as CSV, but ODS. Make sure to save it as CSV file.
In the post_author column you should have only IDs.
You shouldm’t delete empty columns (I’m referring to IMAGE). Just keep them blank.All the rest looks correct to me.
Let us know if this helped.
Thanks
October 12, 2015 at 7:39 pm #56645“In the post_author column you should have only IDs.”
When you say IDs, do you mean numbers, like 1, 2, 3…?
The first row/record has admin id so I should change it to a number?October 12, 2015 at 8:06 pm #56647That is correct.
Thanks
October 12, 2015 at 11:50 pm #56669I fixed the post_author ID in the 1st row and still the csv isn’t importing. Now I’m getting:
Total 72 item(s) found.
72 / 72 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
File at https://www.dropbox.com/s/zqqfyrf4anfkhgu/shlistingallusa.csv?dl=0
October 12, 2015 at 11:50 pm #56670see above
October 13, 2015 at 3:57 pm #56744Hi again,
this is something I didn’t notice in the previous file.
There are several cells with spaces in front of the data in post_address, post_city and post_country.
I guess you copied and pasted from a source with extra formatting and didn’t notice that.
The first address with this formatting issue is in cell J-14 : 13420 Reese Blvd. West.
For post_city is K-3: Santa Ynez. There are a lot in this column
In addition you really need to add back the empty columns you deleted.
I’d suggest to start over on a clean sample csv file and add back data removing all extra spaces in front of words.
Let us know,
Thanks
October 14, 2015 at 12:29 am #56814I fixed all problems and I uploaded 3 forms of the csv but still I get the following error:
Total 72 item(s) found.
72 / 72 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
I’m so sick of this _____. I have to go to another location to use oo and create a csv and I’ve done this several days now.
https://www.dropbox.com/s/3jxkl0j1ooekpfg/shlistingallusa2.csv?dl=0 and
https://www.dropbox.com/s/l03wrs8d4goj30s/shlistingallusa3.csv?dl=0October 14, 2015 at 12:59 am #56816Hi,
please provide URL and admin credentials in a private reply. We will import for you and let you know why it wasn’t importing.
Thanks
October 14, 2015 at 1:18 am #56817This reply has been marked as private.October 14, 2015 at 10:45 am #56857Hi Lee,
You seem to have some non uft8 characters, please save your csv in utf8 and make sure there are no wee black diamonds with questions marks that mean there is a broken character.
Thanks,
Stiofan
October 15, 2015 at 8:09 pm #57064This happens if post_region is left blank (depending on settings I guess?), at laest for me that’s what was causing the issue
October 15, 2015 at 11:14 pm #57112Hi,
post_region is a mandatory field. Please see: https://wpgeodirectory.com/docs/core-export/#mandatory
Thanks
October 16, 2015 at 1:56 am #57135I have post_region field filled in (it’s the state). What settings do you have that works?
October 16, 2015 at 3:06 am #57144I am reading https://wpgeodirectory.com/support/topic/please-help-with-my-site/
#3 states that ” You will need to enable the Location Manager addon. Without that your listings can only be in your default location.”
My default location is USA, California, Los Angeles. I have records for other US states in my csv. Since my default location is USA, records for other US states will populate from my csv, correct? I want to ensure that this is not the problem.
In the meantime, I’m working on saving my csv as utf8 format so I can upload and fix this problem with the csv not importing.
-
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket