Provides the ability to import records from CSV files.
Note: Before version 5.4.0 Import was available only for admin users.
Administrator can access import at Administration > Import. By default regular users don't have an access. It can be granted with ACL roles. Administrator also can add the Import tab at Administration > User Interface > Tab List.
Select what type of records you need to import (Entity Type field).
Select a CSV file. A file should be formated with
What to do?. Available options: 'Create Only', 'Create & Update', 'Update Only'.
Create Only- select it if you want record be only created.
Create & Update- records will be created, but if records with matching field values will be found it will be updated. You will be able to check what fields to match by on the Step 2.
Update only- only records with matching field values will be found, it will be updated.
Once you select a csv file, you will be able to see how it should be parsed in Preview panel. When you change properties, the preview will be updated.
Header Row- whether CSV file has the first row with field names.
Execute in idle- is recommended if you have a big bunch of records to be imported. Import will be processed via cron. Status will be set to 'Complete' when import process is finished.
Skip searching for duplicates- it will decrease import runtime.
Click Next button to preceed to the Step 2.
Setup the field mapping: how fields correspond to columns of the csv file. You can skip not needed columns here. In cases of 'Create & Update' and 'Update only' you need to check fields by which records that should be updated will be found.
E.g. if you check 'update by' Name field, then records with matching name will be updated.
Add default values you want new and updated records to set with. E.g. you can specify Assigned User or Teams fields.
After the import is done you will be able to revert created records, see duplicates and updated records. Duplicate means that there was the similar record in the system. You can remove all imported duplicates at once. Note: Revert doesn't work with updated records.
Click Run Import button to proceed. It may take some time before an import process gets finished. If you want to import a large bunch of records (depends on you server configuration, usually if more than 200 records), you need to make sure that php parameter
set_time_limit is large enough.
Once the records are imported and you are sure that imported data is fine you can 'Remove import log' (by clicking the button on the import results view) to preclude accidental reverting of the import.
When you import Contacts, Leads or Accounts you can add them to some target list. On the Step 2 you need to add Target List field on
Default Values panel and select a needed target list record. You can also use
Update only or
Create & Update import to add existing targets to a target list.