During a migration from 1x to 2x on an EE site, I needed to switch to current Google Maps add-ons and chose MX Google Maps (for now anyway). The site was using a geotagger that filled a Latitude field and Longitude field with data, so those are still in place.
Since MX Google Maps uses it's own fields, I need to find a way to migrate current db data to MX Maps. But I'm hella bad at this SQL query stuff.
Right now, the lat/lon are stored in exp_channel_data in field_id_41 (lat) and field_id_42 (lon). MX Maps stores Lat/Lon in field_id_46 as a pipe delimited set (lat|lon). It also stores data for each entry in it's own table at exp_mx_google_map.
In exp_mx_google_map it has
- point_id (a sequential number for each post)
- entry_id (tied to the entry itself)
- address (not using)
- city (not using)
- zipcode (not using)
- state (not using)
- field_id (in this case 46)
With about 2400 entries storing lat/lon, what's the best way to go about moving this data over? Besides drinking heavily and sleeping on it, which I've tried and doesn't work.