Import not working from export
This topic contains 9 replies, has 4 voices, and was last updated by Garth Lategan 9 years, 1 month ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket-
AuthorPosts
-
September 21, 2016 at 11:51 am #270339
I’ve tried everything to import my data
So I exported my data as I have two listing in there.
I then just imported the same I just exported and I still get the error
Total 2 item(s) found.
2 / 2 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.I have also opened the fill on open office calc and then save it but that did not work either.
I have attached the file that I exported and then tried to import
I have also attached the file that I am trying to import
September 21, 2016 at 7:02 pm #270691Hi,
the 1st file (export) looks correct, the second file has post_type and post_status filled only for the 1st row.
If you provide a link and admin credentials in a private reply (only our staff can read them), we will have a better look.
Let us know,
Thanks
September 22, 2016 at 6:49 am #270994This reply has been marked as private.September 22, 2016 at 4:18 pm #271309Hi,
I believe the problem are addresses. Google Maps treats Australian suburbs as cities.
For example, the 1st address on your CSV file: “325 Johnston Street Abbotsford”
Is returned to be an address in City of Yarra, not Melbourne. You will need the location manager add-on to be able to import these listings successfully.
However I can’t find out why the export file cannot be re-imported to update existing listings.
I asked to a developer to have a look and let us know.
Thanks for your patience,
September 22, 2016 at 4:46 pm #271314On that’s annoying so the free plugin is no good in Australia without purchasing the product.
I hesitant to purchase the product as it has not been easy to use and just the basic features are not working.
Thanks for your help IM keep me posted I’m keen to role this platform out
September 23, 2016 at 9:05 am #271827Hi Garth,
I have done some test by importing csv file version-2.csv that you attached, and it successfully imported without any error.
Please check attachment import-version-2.csv.pngI have tested re-import by exporting file and importing same file, it also worked fine.
When tried to import file gd_place_2109161058.csv that you attached after import seen some messages. Please check attachment import-gd_place_2109161058.csv.png.
1 item successfully imported because that row has all data correct.
17 items have invalid characters in address field.
135 items have empty post_type field. You must fill post_type field for all items.You can also debug import process if site has debug log enabled (https://codex.wordpress.org/Debugging_in_WordPress#WP_DEBUG_LOG).
If debug enabled on site then the import process will log the items which has problem in import. So you can easily find which row has the problem and what is the problem.All 136 items successfully imported when removed invalid characters from 17 rows and adding post_type for all rows. Check attached file working-gd_place_2109161058.csv which is modified and working fine.
Let us know.
Thanks,
KiranSeptember 23, 2016 at 10:59 am #271885Hmm, i replied here yesterday but it seems to have not went through, i had mentioned that Google api splits the outskirts of Melbourne into different cities, and only the center will return as actual Melbourne.
Stiofan
September 23, 2016 at 11:11 am #271887I guess What I need from your team.
What is it going to cost me to get this plugin working.
What add on do I need to purchase and what support can you give me to get this upload to work correctly with the right postcodes.
September 23, 2016 at 11:17 am #271888This reply has been marked as private.September 23, 2016 at 11:22 am #271889skype is **REMOVED**
-
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket