Import of Datas for Custom Post Type including Adress Field for maps

This thread is resolved. Here is a description of the problem and solution.

Problem:

Import custom address field value with CSV file.

Solution:

The Toolset custom address field is using same field slug structure as other types of custom fields.

For example, custom address field "my-address", in the database, the field slug is "wpcf-my-address", you can import the address values into field "wpcf-my-address".

Toolset Maps plugin is using anther custom database table "wp_toolset_maps_address_cache" to store the address coordinate values(latitude and longitude). The address coordinate values will be generated and stored/cached into database automatically when you display the address field as marker of a map.

Relevant Documentation:

https://toolset.com/course-lesson/data-caching-for-maps-addresses/

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Tagged: Setting up custom fields, Types plugin

This topic contains 5 replies, has 3 voices.

Last updated by stefanieR 6 months, 3 weeks ago.

Assigned support staff: Luo Yang.

Author

Posts

June 29, 2020 at 6:16 am #1679967

thomasB-2

Tell us what you are trying to do?
We try to import 2200 Datasets with local offers for support, wich have a street, Postal Code and city. These Datas should be imported and the combination street, PostalCode and city should be create a Toolset Maps Adress field.
In my actual used importing tool WP All Import i see that Adress Field was not supported.
Is there an other other solution for such task?

June 30, 2020 at 6:57 am #1681577

Luo Yang

Supporter

Languages: English (English ) Chinese (Simplified) (简体中文 )

Timezone: Asia/Hong_Kong (GMT+08:00)

Hello,

The Toolset custom address field is using same field slug structure as other types of custom fields.
For example, custom address field "my-address", in the database, the field slug is "wpcf-my-address", you can import the address values into field "wpcf-my-address".

June 30, 2020 at 9:38 am #1682139

thomasB-2

But will these Adress field then while import also geolocated?

July 1, 2020 at 6:45 am #1683381

Luo Yang

Supporter

Languages: English (English ) Chinese (Simplified) (简体中文 )

Timezone: Asia/Hong_Kong (GMT+08:00)

Toolset Maps plugin is using anther custom database table "wp_toolset_maps_address_cache" to store the address coordinate values(latitude and longitude), I don't think WP All Import can generate or import those coordinate data.
See our document:
https://toolset.com/course-lesson/data-caching-for-maps-addresses/

The address coordinate values will be generated and stored into database automatically when you:
Display the address field as marker of a map

So you don't need to import those coordinate data.

July 5, 2020 at 4:04 pm #1688077

thomasB-2

My issue is resolved now. Thank you!

November 11, 2020 at 2:20 pm #1841239

stefanieR

Hey Luo Yang,

sorry for opening an old ticket. I found following undocumented solution to import lat/lng into the Address, which saved me a lot of time. We dont need the address string and are using the lat/lng for a distance filter.
https://toolset.com/forums/topic/how-to-add-latlon-coordinates-when-importing-existing-records/

I hope this helps, i searched nearly every ticket with lat/lng in it.