How to migrate coordinates in to the new Geolocation fields if I used the old workaround?

Introduction

Back in v2.26.4 and lower there were no GPS question type that you could directly map into fields, as such a workaround involving a lookup relationship to Submission object was needed. Now that TaroWorks fully support GPS Location question and mapping into geolocation fields, we recommend using the new approach instead.

If you have used the workaround in the past, it is best that you migrate your coordinates into the new geolocation field instead as Salesforce intends to expand special functionality to them. (Currently you can use a built-in formula to measure distance between two points recorded in geolocation fields.)

The basic premise is to export the latitude and longitude (formula fields with lookups to the Submissions object gps x and gps y fields) from existing records and then re-import the into the geolocation field Longitude and Latitude fields respectively.

Steps

As each salesforce user have different preferences on how to export and import, these steps will give one possible solution for you to adopt. 

1. Create a report in salesforce for your object, displaying the record identifier (Object name, salesforce ID, etc) and the Latitude (Auto) / Longitude (Auto) values. 
2. Run the report and export the values to a csv file. We recommend using filters to export in blocks of 50,000 or less as there is an import limit later.
3. Go to Setup > Data Management > Import Custom Object (or Import Accounts/Contacts if appropriate), start the import wizard as usual.
4. You will reach a step where you can map to TestGeolocation (Latitude) and TestGeolocation (Longitude) from the columns of your exported csv file.
5. Complete the import. We recommend using a report to confirm that you have completed the import successfully.
6. After this is done, you may decide to remove the lookup relationship from your object to Submission. (Assuming you have no other reasons for keeping that relationship active.)

Notes

• Dataloader is also a good free method to do the migration.
• At the time of this article, geolocation fields for Salesforce.com are in beta. For more information, please see this salesforce article.
• You still display coordinates after you have migrated the data, please read this article for more details.