I am looking for a wpallimport expert!
We have a xml export with all property details.
We can insert all basic data that is in the element items.
But we are missing gps coordinates and image url's that are in different elements
The main data is in the items xpath but for latitute and longitude look for "_ct_latlng" key in wp_postmeta table for a particular listing... and for the image, look for post_type = attachment where parent_post is the listing for which you need to findout the image
the image references are stored in wp_post table
See xml file in attachment
PS: Elements is also xpath