So you want to move to a new CRM solution. This might be your first time using CRM with this organisation, or you could be migrating from one CRM solution to another. Perhaps you feel your existing solution has become too expensive; there are countless reasons that might prompt a move.

On top of getting the new system up and running and educating your Users, one of the main challenges is getting your data imported.

There are a number of things which can make this task either quick and simple, or long and painful. Having been in involved in the data migration process for numerous systems, here are a few pointers which might help.

• Have you mapped all the fields you need in the information you are exporting? One field that is often not present in data we see is the “assigned to” field. It is easy to add this field to a csv file by copying and pasting the relevant users prior to import, and this means that ownership is assigned to your data right from the start.

• Have you looked at the format in which the data is presented in the system you will be using? Look at the fields that contain details such as name and address – are they separated into first and last name? Is the street address all contained in one field? And is the data in the correct field? Looking at data on a csv file it is easy to see where email addresses have erroneously slipped into the phone number field.

• Have you looked at the related entities and how the data needs to interact within your new system? If you are importing companies and contacts, do you have the right company name on the contact record and are those names consistent? If you have a “Jones Limited” in one spreadsheet and a “Jones Ltd” in the next, this will create two unrelated records, which brings you quickly into those murky waters known as duplication.

• If you are importing other data such as Activities, do you have a means of identifying the related contacts and companies in the import data?

• Remember, all of your information is easy to merge, delete, re-arrange and tidy up at this early stage, when your data is contained in a spreadsheet format such as csv.

Of course in a CRM solution such as OpenCRM you can filter your data and should you need to bulk update records, this is easily done. But the earlier you start to tidy up your records and data, the easier it will be to manage when on your CRM solution, not to mention starting with a clean slate like this will help encourage a solid practise for future data management.

For more advice and tips have a look here: http://opencrm.co.uk/crm-knowledgebase/kb1401086/Things-to-consider-when-importing-data-into-OpenCRM--Troubleshooting-imports-that-are-not-working.html