In the following video, you’ll learn all about importing data into OnContact CRM 8.
Specifically, we’ll be going over how to import a file that contains contact and company data, as well as how OnContact’s standard templates can help simplify the import process.
Hello and welcome to WorkWise OnContact CRM training. Today we’re going to learn about importing data into CRM 8. We will import a file that contains contacts and companies and related information like phone numbers, addresses and titles. We will see how CRM 8’s predefined templates can be used to simplify the import process.
Predefined Templates – Import Process
The import utility is located in the setup area under modules. Note the setup icon is only accessible if the setup and maintenance group is assigned to your CRM login. User group assignment is managed on the user edit page, also located in the setup area. Upon opening the first page of the import shows a list of templates, which are predefined mappings that match many common import files. Sample Excel spreadsheets that match those templates can be found on our install DVD in the import samples folder as well as on our website under the resources area. These files are guides that can be used to match your import file to one of our import templates and using them will help simplify the import process.
Here is a list of all supplied templates in the type of data they’re mapped to:
Note these templates are all based on Microsoft Excel version 2007 or higher and have a header row which helps when mapping columns. Data can also be imported from comma separated tab delimited or pipe delimited text files.
Importing Data into CRM 8
For this training, we will import a data file that exactly matches our contact import with company template. This will result in a very simple import, eliminating the need to map columns, which we will look into later in this video.
The steps are:
Once all of the data in the file is imported, the review page will open indicating how many records imported successfully. Total number of records should match number of records processed. There are several options available on the review page that can be used to work with the newly imported data. The create new marketing campaign option adds a new marketing campaign and assigns the imported data as targets to the campaign. Open list page and select new records opens a standard list page that shows the newly imported data in the results area. The same options on search pages are available here including mail merge, email merge, workflows and so on. The delete newly inserted rows option removes the newly imported data from the database, it will not delete any other data only what was just imported during this session. If there are any issues with your import file, you will see a message indicating what the issue is. The open file containing failed rows option will open an excel spreadsheet containing the rows that failed.
One of the most common issues is import data that is too large for the corresponding field in CRM. For example the title column and CRM can hold a title that’s up to 100 characters long. If your import file has a title longer than that, it will display a message indicating this. You can then use the open file containing failed arose feature to correct the issue and then re-import those failed rows without having to re-import the entire file. Please note these options must be used before closing the import or logging out of CRM.
Now let’s take a look at how to import a data file where the columns don’t line up exactly with one of our templates. One option is to start from scratch and build an entirely new import. This isn’t difficult, although would be fairly time consuming. A better option is to modify your data file to match one of our existing samples as closely as possible. Use the corresponding import template in CRM and then manually map any columns that don’t line up. So let’s see we have a few columns in the data file that aren’t mapped in one of our templates. The first few steps will be the same as our first example except you will see blank rows in the template field column for those fields on the mapping page. This means those columns are not mapped to a column in the database and therefore will not be imported.
To resolve this:
The remaining steps and features are the same as in our first example. At any point after this, the import can be saved or saved as a new import so that the mapping process doesn’t have to be repeated. After that the remaining steps are the same as our first example.
This concludes the on contact CRM import training video. Today we learned how to find and open the uncontacted CRM import utility, examined our predefined templates and how they can help with import mapping, cover the steps of importing a simple data file, and finally explored some useful options for working with the newly imported data.