Problem Importing Province

Hi,

Thanks for your response. This is Dominic switching over. I’ve attached a list of our addresses that didn’t automatically link with a region code. We have about 200. When entered into google maps none of them have a region code in their address. If you could update that list that would be great. Additionally, if you have a list of accepted regions and the cities that are contained within them, that would be great.

To give some context, in some cases we can guess the region code by knowing that the UK uses county as region, and Germany uses state, but in many cases in those countries, the region is still unclear, e.g. Britain has Ceremonial and Historical Counties. We also don’t know what the region unit for other countries is used such as Thailand for example. Out list is very international containing addresses from countries all over the world although the most of our list is in the UK and Germany.

Thanks,
Dominic

Hi,

We geocoded the import addresses but still have ~90 that are not importing. Can you tell me why these may be wrong:

WP DEBUG:

[06-Jul-2018 16:17:37 UTC] GD IMPORT LISTINGS [ROW 3]: Could not be added due to blank/invalid address(city, region, country, latitude, longitude).
[06-Jul-2018 16:17:37 UTC] GD IMPORT LISTINGS [ROW 5]: Could not be added due to blank/invalid address(city, region, country, latitude, longitude).
[06-Jul-2018 16:17:37 UTC] GD IMPORT LISTINGS [ROW 6]: Could not be added due to blank/invalid address(city, region, country, latitude, longitude).
[06-Jul-2018 16:17:38 UTC] GD IMPORT LISTINGS [ROW 7]: Could not be added due to blank/invalid address(city, region, country, latitude, longitude).
[06-Jul-2018 16:17:38 UTC] GD IMPORT LISTINGS [ROW 8]: Could not be added due to blank/invalid address(city, region, country, latitude, longitude).
[06-Jul-2018 16:17:38 UTC] GD IMPORT LISTINGS [ROW 9]: Could not be added due to blank/invalid address(city, region, country, latitude, longitude).
[06-Jul-2018 16:17:38 UTC] GD IMPORT LISTINGS [ROW 10]: Could not be added due to blank/invalid address(city, region, country, latitude, longitude).

SAMPLE DATA:

post_city	post_region	post_zip	post_country	post_latitude	post_longitude
London	The City of Brighton And Hove	NW8 OQG	United Kingdom	51.53805	-0.179737
New York	New York		United States	40.712784	-74.005941
Stroud	Gloucestershire	GL6 8NX	United Kingdom	51.758915	-2.140212
Canterbury	Kent		United Kingdom	51.277269	1.080517
Brighton	The City of Brighton And Hove		United Kingdom	50.82253	-0.137163
Schlangenbad	Hesse		Germany	50.092381	8.102423
Tourne	Occitanie	9420	France	42.983243	1.344138
Brighton	The City of Brighton And Hove	BNI 7BJ	United Kingdom	50.819522	-0.13642
Brighton	The City of Brighton And Hove		United Kingdom	50.819522	-0.13642
Darmstadt	Hesse	64297	Germany	49.87088	8.64565

Sorry, I should have mentioned that I have successfully imported 300+ locations so the configuration is fine. 92 locations failed all for same reason “Could not be added due to blank/invalid address(city, region, country, latitude, longitude)” but looking at the CSV I cannot see what is wrong with the addresses as the first 5 error rows I checked had valid data for the fields indicated.

Can you see a problem with the data in those fields?

Address is not a required field.

Hi Alex,

You are correct that ‘post_address’ field cannot be blank when importing. I set it to text “NONE” for all rows that did not have it and the import was successful.

So this is a bug since the plug-in has an option “Location Settings -> Address -> Is required” which is set to “No”. See attached screen-shot. The error message only lists “city, region, country, latitude, longitude” as being invalid/blank.

The import function should probably be fixed to ignore the ‘address’ field when it is not required.