Things to consider when importing data into OpenCRM. Troubleshooting imports that are not working.
|Updated: 23 January 2012 12:20:38||OpenCRM::Data Import-Export|
There are a number of ways in which a data import can be unsuccessful. Here are some typical scenarios you may encounter and how you can resolve the problems.
Fields are incorrectly mapped and cause a conflict - the whole import does not work.
This can happen if two different fields in your import data are mapped to the same field in OpenCRM.
Required fields are not mapped - the import will run but no records will be imported
A common reason for this not working is with an import of Contact records where the Contact Last Name is missing. As a general guide the key field in all modules e.g. Contact Last Name, Company Name or Product Name needs to be mapped for an import in the relevant module to be successful
Company fields are mapped on a Contacts import but there some of the records contain no Company Name - this will create blank Company records
Care must be taken when you are importing Companies and Contacts. Importing the Company name field in a Contacts import will create a link on the Contact record in OpenCRM to a Company of the name in the import sheet. If a Company name is spelt incorrectly this will create a new Company record under that misspelt Name, and if the Company field is blank then this will create a blank Company record. A quick solution to this problem is to sort the Contacts import according to Company Name, and splitting the import in two - one import for Contacts linked to a Company and a second import for Contacts without a Company - for this import you do not map the Company field.
Date fields are mapped but are not importing - date format is incorrect
Date fields to be imported into OpenCRM need to be in the correct format - this is either YYYY-MM-DD or YYYY-MM-DD HH:SS when importing data and time. To change the date format on the import csv, you need to highlight the column you wish to reformat and right click on the mouse to open the following menu:
Select the Format Cells option, and on the next screen under the Number Tab, select Date, then Custom, and enter yyyy-mm-dd into the available field.
You can then save the changes and proceed with the import. Please note that the csv strips formatting, so when you reopen the data you will not see the altered formatting.
User Names are mapped but are not importing - wrong User Name format has been used
If you are importing information related to system users such as Assigned to, Created by or Last Modified, you need to map this field to the user name as defined by the system, in the example given below you can find the correct User Names by going into Settings and Users under User Management. In the example below, the User name to use in mapping is "alexh" and not "Hamley Alex"
Number fields are not importing correctly - other characters such as currency symbols or thousand separators may be present in the import data.
Characters and symbols can prevent a number field from importing correctly. This can be prevented by stripping these symbols. As with the date formatting, you need to right click the mouse and select Format Cells from the menu that appears. You can then select Number from the menu. This will strip currency symbols and you can also untick the "Use 1000 Separator" box to remove additional commas which cause problems on import.
Reimporting data is creating duplicate records - External ID or CRM ID not used and "Update Existing Records" option not ticked.
If you have exported data or are running an update to existing data in OpenCRM, you need to tick the option to Update Existing records.
If you have exported data from OpenCRM in order to update records, you will need to map the CRM ID to the appropriate ID field in order to update the corresponding OpenCRM.
You may also be interested in:
Can I set up automated Imports to automatically import data into OpenCRM?Updated : 08-01-2013 14:36
- How can I add a leading Zero (0) in Excel/ CSV? For example in phone numbers? Updated : 25-09-2012 15:15
- How can I copy values from one Excel sheet to another (VLOOKUP)? E.g. I have a file for Companies and a file for Contacts and I want to copy some data from the records on one sheet to the associated records on the other. Updated : 02-05-2013 10:27
OpenCRM::Data Import-Export Windows::Excel
How can I import my LinkedIn contacts into OpenCRM?
OpenCRM::Contacts OpenCRM::Data Import-Export
- Can I make a field mapping (within Imports) available to other people in my team? Updated : 23-03-2012 15:33
- Saving a CSV file on a Mac for import into OpenCRM Updated : 05-12-2011 10:35
OpenCRM::Contacts OpenCRM::Companies OpenCRM::Data Import-Export
- How can I convert XML data into a CSV (Comma Separated Value) format to import into OpenCRM? Updated : 27-11-2011 16:52
- How can I get Leads into OpenCRM from a contact form on my website? How do the OpenCRM contact forms work and how do I customise them? Applies to Version 3.02+ Updated : 31-10-2011 11:20
OpenCRM::Leads OpenCRM::Data Import-Export
- How can I get Leads into OpenCRM from a contact form on my website? How do the OpenCRM contact forms work and how do I customise them? Applies to All versions Updated : 31-10-2011 11:19
OpenCRM::Leads OpenCRM::Data Import-Export
A tab count shows a " * " and no value, A tab count shows " ~ ". Large tab counts seem a bit inaccurate. How does tab count caching work? Why does opening a record with a large number of linked items take a long time? Why can I only see 1000 records in linked grids?Updated : 30-03-2013 10:41
OpenCRM::Home OpenCRM::Calendar OpenCRM::Leads OpenCRM::Emails OpenCRM::SMS OpenCRM::Contacts OpenCRM::Activities OpenCRM::Reports OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Helpdesk OpenCRM::Helpdesk::FAQ OpenCRM::Documents OpenCRM::Products OpenCRM::Products::Stock Items OpenCRM::Dashboards OpenCRM::RSS OpenCRM::Contracts OpenCRM::Personnel OpenCRM::Events OpenCRM::Property OpenCRM::Campaigns OpenCRM::Interface-Display OpenCRM::Settings OpenCRM::Settings::Users OpenCRM::Settings::Templates OpenCRM::Settings::Additional OpenCRM::Settings::Custom Fields OpenCRM::Settings::Google Sync OpenCRM::Portal OpenCRM::Add-in::Outlook OpenCRM::Add-in::Pop2OpenCRM OpenCRM::Add-in::SOAP OpenCRM::Add-in::SageLink OpenCRM::Add-in::Web Form OpenCRM::Add-in::Custom Module/code OpenCRM::Editor OpenCRM::Sage Integration OpenCRM::Phone Integration OpenCRM::Data Import-Export