Articles in this section
Importing Data into Vtiger CRM
Table of Contents
Introduction
If you have a file on your local computer and want to transfer the data in the file to the CRM, Import is the way. With Vtiger CRM, you can import files in .csv, .vcf, and .ics formats.
Why do you Import data into Vtiger CRM?
Let us see some examples.
- You were at a trade show and managed to grab positive leads. You also saved this information on your laptop. To ease the process of managing and to convert these leads, you can import them into Vtiger.
- During the bi-annual audit, you found that your sales rep has stored updated information of all your contacts on your local computer. You now want to replicate the information in the CRM. You can easily use Vtiger’s import feature to import this updated information into the CRM.
Key Terminology
|
|
|
|
|
|
|
|
|
|
Prerequisites for Importing
Before you start importing files, make sure you have checked for these prerequisites:
- Mandatory fields: Your local file in .csv, .vcf, or .ics format must have all the data to fill the mandatory fields of the CRM. Non-mandatory fields can remain empty. For example, the Lifecycle Stage field in the Contacts module is mandatory. If a value is not specified in your CSV or VCF file being imported, then the field takes the default layout value, which is Lead.
- File size: The size of the local file that you are importing must not exceed 50 MB. You will not be able to import files of size greater than 50 MB.
- Access permissions: You need access rights to import files. Make sure to have access before you start looking for Import. You can disable import access to non-admin users if you are an Admin user.
|
Importing Records into a Module
You can import files by going to the Users Settings page. You will be directed to the Users Settings page by clicking on the User Profile and Settings. The Import tab is beside the Add User and Export tabs here.
The Import field is available:
- In the Users List View on the Users Settings page.
- In the Detailed View of a User record on the Settings page.
You will be directed to the Import module by clicking the Import tab on the User Settings page. You will land on a New Import window, where you have to select the module as Users to import Users’ records.
Based on your chosen module, the records will be imported in the CSV, VCF, or ICS format.
You can import data for the following types of users on the Settings page:
- Standard
- Light
- Single App
- Admin
Here you can import users. You can also import records from other modules like Contacts from the Users Settings page. Once imported, you can find the record in the List View of the Import module.
When you select the imported records from the List View, the Summary View of the record opens.
The Summary View of the record will display the following information:
- Records Imported
- Records Created
- Records Updated
- Records Merged
- Records Skipped and
- Records Failed
You can also import duplicate records by checking the option in the Duplicate Handling tab.
Importing Data
Data can be imported into Vtiger CRM using the Import tool. You can access the Import tool from the Main Menu > Tools > Import or the module into which data has to be imported.
The following are three significant steps while importing data into the CRM:
- Step 1: Select a data file.
- Step 2: Mapping the columns of the data file to the CRM fields.
- Step 3: Handling duplicate data.
Follow these steps to import data into vtiger CRM:
- Log in to your CRM account.
- Click the Main Menu.
- Go to Tools.
- Select Import. Import tool opens.
- Click +New Import on the top right corner of the screen. The New Import window opens.
- Step 1: Select a data file. Enter or select information for the following fields:
- Title: Enter a title for the new import.
- Select Module: Select a module from the drop-down into which data is to be imported.
- Import File Format: Select the data file format by clicking the corresponding Radio button.
- Has Header: Click the Checkbox if the data file has a header.
- Character Encoding: Select the Character Encoding by clicking the corresponding Radio button.
- Delimiter: Select the Delimiter of the data file by clicking the corresponding Radio button.
- Choose file: Select a data file from your local drive.
- Click Next.
|
- Step 2: Mapping the columns of the data file to the CRM fields. Enter or select information for the following fields:
- CRM Fields: Map Column Name in your data file to a CRM field from the drop-down.
- Default Value: Provide a Default Value for the fields from the drop-down.
- Click Save Mapping to save the custom mapping. (Optional)
- Click Next.
|
- Step 3: Handling duplicate data. Enter or select information for the following fields:
- Check Duplicates: Click the Radio button if you want to check for duplicate records while importing.
- Duplicate Check Fields: Select the field from the drop-down that will be checked to verify whether a record is a duplicate.
- Add New Records: Click the Radio button if you want to create new or unique records in the CRM. If there are duplicate records in your data file, they will not be imported.
- Add New Records and Update Existing Records: Click the Radio button if you want to create new or unique records in the CRM. If there are duplicate records in your data file, then the CRM records will be updated or new records will be created.
- Overwrite fields with any incoming blank values: The old value is replaced with duplicate values even if it is blank.
- Don’t Check Duplicates: Click the Radio button if you want to create new records in the CRM without checking for duplicates.
- Click Next.
- Review the field mapping by looking at the Preview Import window. The preview shows only a maximum of three records.
- Click Start Import.
|
Import Summary: Results of importing
- Click Finish if you have no more records to import.
- Click Import More to import other records.
- Click Undo to remove the imported records from the CRM.
When an import is complete, you must click Undo or Finish to start importing new data.
- If you click Undo, the current import status is set to Reversed. You must go to the import record and click Undo or Finish to start a new import process. You will see the error shown above when you try to import new records.
- If you click Finish, it means the import was successful and you can start importing new records.
|
Import History
You can view the List View of import history by going to Main Menu > Tools > Import. You will see the import history when you land on the Import module. Details such as who imported records, which module the records were imported into, etc., are grouped into columns in the history.
Refer to the following table for the details available in the import history:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Import Records
Vtiger CRM creates import records every time you perform an import action. You can view the List View of import records by going to Main Menu > Tools > Import. Click the required record.
An import record provides the list of records that were imported along with the following details:
- The name of the user who imported the file.
- The module into which records were imported.
- The name of the imported file.
- The type or format of the imported file.
- The status of the import process.
The summary of the import process and details of field mapping are displayed on the right.
|
|
Notes on Importing
- Assigned To field
- Assigned To fields in your local file must have the First Name and Last Name or the Username of the users to whom the records must be assigned. If Assigned To is empty, the records get assigned to the user who imports them.
- To learn more about CRM fields, click here.
- Time fields
- If there is a field of type ‘Time’ in your local file and no value is specified to the field, then the CRM displays the value ‘12:00 AM’.
- Date fields
- The format of the Date fields in your local file must match the format specified under My Preferences in the CRM. Otherwise, the fields are left blank in the CRM on importing.
- If there is a field of type ‘Date’ in the CRM and it is a mandatory field, then your local file must specify a value for the date field in the format specified in the CRM. Otherwise, the import process will fail.
- Multi-Select Combo Box fields
- To import a field of type ‘Multi-Select Combo Box,’ you must specify values in your local file in the format: value1 |##| value2 |##| value, and so on. This field is case-sensitive.
- Reference fields
- If your local file provides a value for a Reference field and there is no record in the CRM with the same value, then a new record is created in the CRM.
- For instance, if you are importing a contact record and a reference field in Contacts is Organization Name, a new organization record is created if the value specified in Organization Name does not exist in the CRM. All mandatory fields in the Reference record are set to ‘????’.
- Also, the import process fails if a Reference field is mandatory and does not have a value specified in the local file.
- Decimal numbers
- Fields of type ‘Decimal’ take the decimal value that is configured in My Preferences.
- For instance, if a Decimal field in your local file has the value 110.8856 and the number of decimals is set to ‘2’ in My Preference, then the value is rounded off to 110.89.
- Picklist values
- If a field of type ‘Picklist’ has a value that is present in the CRM’s picklist, then the new value is added to the CRM record and the value is stored in the CRM’s picklist field.
- A picklist field in a CSV file can have a maximum of 250 values. Also, special characters like <, >, ", {, }, [, ], \n, etc. are not allowed in picklist fields. Import throws an error if there are more than 250 values or special characters in a picklist.
- Pipelines and sales stages
- When importing records, you must ensure that your CSV file's pipeline and sales stage values match the CRM values. Otherwise, Import will throw an error.
- Other notes
- You cannot import records into two separate modules at the same time. Also, you and another user cannot import records into the same module simultaneously.
- If you have more than 250 records in your local file, your import will be scheduled immediately and an email notification will be sent to you after the import is successful.
Notes on Fields in the Inventory Module
- Line Items
- Line item names in your local file (file being imported) must be the same as the names used in Products or Services.
- While mapping, line item names are searched in the Products list first and then in the Services list by default. To make your work easy, prefix line item names with ‘Products’ or ‘Services’ in the following format:
- Products::::Product_Name
- Services::::Service_Name
- The Line item fields – Quantity and Selling Price – must be mapped correctly from your local file. Otherwise, the import will fail.
- If two records with different line items have the same Subject, then only one record is imported. The other record is skipped.
- Specifying the Items Total, Pre-Tax Total, Received, Balance, and Grand Total in the CSV file will not be considered, as these fields depend on the Item total, discount, and taxes added to it. Other fields like Quantity, Selling Price, Discount, and Tax are added to it.
- Taxes
- Tax values must be in Percentage format only.
- Tax Mode must be mapped and specified (Group or Individual) correctly. If not specified, the CRM takes the default Tax Mode.
- Discounts
- Discounts can be applied to individual line items or a group of line items (Overall Discount). Specify values only for the type of discount that you want to apply.
|
Common Import Errors
- Data Corruption
- Vtiger CRM throws this error when the import is interrupted because of reasons such as crashing or cancellation by a user.
- The error indicates that the import table still has pending records but information related to the import process, such as field mapping, default values, and duplicate checks, is lost.
- These records will not be imported further. The user needs to clear the import data before starting another import.
- Import Locked (in cases of a large number of records, say 250)
- Vtiger CRM throws this error when an import has already started on the same module by another user.
- Details such as the module, user, and the time at which the Import was locked are displayed by the error message.
- Import Interrupted (in cases of a large number of records, say 250)
- Case 1: Admin user is importing
- If a standard user attempts to import records when an admin user has an import process running in the same module, then the standard user can see details of the import and gets the Import Locked error.
- Case 2: Standard user is importing
- If an admin user attempts to import records when a standard user has an import process running in the same module, the admin user can see details of the current import. He also possesses the privilege of canceling the import.
- Consequently, the Import Interrupted error will be displayed to the standard user.
- Case 1: Admin user is importing