Print this page

How to resolve the error “The State and country conversion tool can map up to 2,000 records, and your organization exceeds that limit. You'll need to manually export and convert your data, then reimport it, before you can turn on the picklists.”?

Knowledge Article Number 000220548
Description During state and Country picklist conversion the following error is prompted by the system.

“The State and country conversion tool can map up to 2,000 records, and your organization exceeds that limit. You'll need to manually export and convert your data, then reimport it, before you can turn on the picklists.”.  

How can it be resolved?
Resolution The error is received because there are more than 2,000 different State and Country values in the org.  For example, this means the org has 2000+ variations of State/Country such as CA, California, Cali, US, USA, United States, United States of America, and etc.  Or if your org is storing other numbers or addresses inside the State and Country field, the org could easily have more than 2,000+ unique values in State and Country fields.  To fix issue, please do the following:

Step 1. Export data into a CSV file which can be done a number of ways. 

          Option A. Export using Data Loader see Export Data.
          Option B. Export using the Export Service see Salesforce Data Export Service
          Option C. Export by building a report see Build a New Report and Export a Report

Step 2.  Manually change the values in the CSV file to match the picklist value.  For example "Californa","Ca", "ca", should be corrected to "California" and Country should be spelled out “United States”.  If you are storing other unique numbers or other address information in State/Country fields, you may need to move that information to a different column in CSV file and make sure you use state/country fields with only valid picklist values.  

Step 3. Once done perform a mass update the existing records with the correct values which can be done in a couple of ways.

          Option A. Update using Data Loader see Insert, Update, or Delete Data Using Data Loader
          Option B. Update using the Import Wizard see How do I update records using the Import Wizard?

Step 4. Enable State and Country Picklists. Refer the document Convert State and Country Data.




promote demote