I can not import the places
This topic contains 22 replies, has 2 voices, and was last updated by Guust 9 years ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket-
AuthorPosts
-
November 25, 2015 at 2:53 pm #61451
Hi
I have red a lot of comments in this web about people how have the similar problem but I can not solve it.
This is the error notification:
397 / 397 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
397 / 397 item(s) could not be added due to blank title/invalid post type.I have saved this file that I attach like UTF8 but this do not solve the problem.
And I do not know where can I create the post type in the admin panel.
Thanks a lot in advance
November 25, 2015 at 9:38 pm #61528Please review https://wpgeodirectory.com/docs/core-export/
Your CSV has listings without addresses, etc.
Export a sample one using OpenOffice and use that file to create your CSV after reading the documentation.You can create other post types if you are using the Custom Post Type addon: https://wpgeodirectory.com/addons/custom-post-types/
Let us know how you went.
November 26, 2015 at 2:30 pm #61561This reply has been marked as private.November 26, 2015 at 10:03 pm #61630Are you saying that you have a CSV file that you downloaded from your site and it gives that error?
Or did you try to open your existing CSV file with OpenOffice – because that might be the error.
You need to use OpenOffice to create the CSV file, not convert from another format or program.If you provide a link to your site and WP admin details in private reply, it might be faster to help you.
Also upload the CSV file somewhere on your site with FTP and give us a link to the CSV file.November 27, 2015 at 9:37 am #61654This reply has been marked as private.November 27, 2015 at 10:38 am #61657The file is not COMMA delimited, but SEMICOLON delimited.
I fixed it, and re-attached here.1. You will need the Multilocations [location manager] addon before you will be able to upload the file, if you want to add locations outside your default location: https://wpgeodirectory.com/addons/multilocation/
2. The geodir_website column needs to include http:// or https:// as part of the URL
3. You need to create your categories before you can import: https://wpgeodirectory.com/docs/core-export/#mandatory
November 27, 2015 at 12:33 pm #61663This reply has been marked as private.November 27, 2015 at 1:36 pm #61666Always create a listing first on your site, then export, so you can see how to do it.
I attach a sample.See how the location gets exported? Your import needs to match that format of country, region and city. Once you have the Multilocation installed, you can import other regions and cities as well.
November 27, 2015 at 2:14 pm #61673Great! I am going to buy Multilocation, have I to pay just one time or each year?
November 27, 2015 at 2:31 pm #61676Have a read here: https://wpgeodirectory.com/docs/buying-addons-and-support/
If you just by per addon at themetailors, then you get lifetime updates and support, or if you buy a membership, you get everything for a period that you choose.
November 27, 2015 at 4:10 pm #61703This reply has been marked as private.November 27, 2015 at 11:08 pm #617581. The CSV file is not comma delimited but semicolon delimited:
When opening the file, choose to open as semicolon delimited, then save a copy as comma delimited.2. I have changed your map language to Spanish
https://wpgeodirectory.com/docs/translating-countries-and-map-directions/2. All your locations still refer to Espana instead of Spain.
To get the correct city, region and country, go to add a new place at /wp-admin/post-new.php?post_type=gd_place and drag the marker to the city. You will see the locations adjust. Example
Madrid – Comunidad de Madrid – Spain
Barcelona – Catalunya – Spain
Those are the locations you need to use in your CSV file.3. There are some listings without lat and lng [ORTOPEDIA GUERNICA]
4. I suggest to upload 5 or 10 listings only so you can see the result before you try all of them.
November 27, 2015 at 11:08 pm #61759This reply has been marked as private.December 1, 2015 at 3:31 pm #62137This reply has been marked as private.December 2, 2015 at 1:25 pm #62232So 14 + 105 listings did not have the correct data.
If you export the ones that worked, you can compare to find which ones are missing.
That is why I suggested to do in small batches until you are confident you no longer make mistakes.Your image names need to be unique and need to include the extension like .jpg.
If you want to use the same image for all listings add a default image to the category at Places > Categories.There is no need to add “” around your regions and addresses etc.
You still have a lot of invalid characters, like G�imar
You still have listings without lat and lng: import can NOT work without the mandatory fields.You need to add icons to your categories.
-
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket