XLS Import

XLS Import Manual · Chapter 6

Additional features – XLS Import for Vtiger CRM

Vtiger 7.x / 8.x
Product page

6.1 Import of records failed, what to do?

Sometimes can happen that some of the records will not be imported properly and you don’t know why.
That’s why we have feature to check why the upload failed.

  1. Go to XLS Import module list view and click on the Import you recently created
    (or the one which failed to upload some records)
  2. In the detail view of record click on the button: XLS import download log file button – Import of records failed, what to do?

    Vtiger XLS Import
    XLS Import – Import error check

After Log file is downloaded, you can open it and check:

  • which record failed (line of the record),
  • error message (why upload failed).

6.2 Duplicates handling

With our XLS Import extension you have option to handle duplicates, this can be useful if the records in the system already exist, you can simply overwrite them or perform other methods.

There is need to select for which fields this method will be used.

Duplicates handling methods are:

Xls import duplicates handling for vtiger
XLS Import – Duplicates handling

6.2.1 Skip method

After import, duplicate records are identified based on fields criteria. If your Vtiger CRM and .xls file has records in common, to avoid redundant data, the records in .xls file are imported and will replace the records in Vtiger CRM.

You need to also define “Fields to be matched on”, we suggest selecting the all fields if you want to prevent any duplicated or selects the fields based on the module for which you are creating import.

When you selected the Skip method, in the last step of import process, you should see the following results:

  • Records total – 4
  • Records created – 0
  • Records skipped – 4 “Details”
    By clicking on the “Details” the list of skipped records will appear:

    XLS import skip method
    XLS Import – Duplicates handling, skip method

  • Records failed – 0

Check which records were skipped

(Click on the image to enlarge)

XLS Import for Vtiger crm skip method
XLS Import – Duplicates handling, skip method

6.2.2 Overwrite method

After import, duplicate records are identified based on fields criteria. If your Vtiger CRM and .xls file has records in common, to avoid redundant data, the records in .xls file are imported and will replace the records in Vtiger CRM.

When you selected the Overwrite method, in the last step of import process, you should see the following results:

  • Records total – 4
  • Records created – 0
  • Records overwritten – 4
  • Records failed – 0
XLS import overwrite method
XLS Import – Duplicates handling, overwrite

6.2.3 Merge method

After import, duplicate records are identified based on field’s criteria. Merge, unlike overwrite and skip, checks for duplicate records first and then captures only useful information from your .xls file and updates it in your Vtiger CRM.

What if your records on either ends (csv file and Vtiger) have duplicates, but also have important information on those duplicates? That’s exactly when the merge comes really helpful.

Merge feature finds out duplicates and converge information in .xls file and Vtiger CRM. That makes it only one record with complete information.

See an example:

We have Contact record in .xlsx file

Vtiger XLS Import Merge method
XLS Import – Duplicates handling, merge method

Then we have Contact record in Vtiger CRM before Import

Vtiger XLS Import Merge method
XLS Import – Duplicates handling, merge method

Next, we will create an import via our extension XLS Import and use following duplicate handling method with fields to be matched:

Vtiger XLS Import Merge method
XLS Import – Duplicates handling, merge method

Result: Contact record updated in Vtiger CRM after import

*in the green you can see the fields which were updated

Vtiger XLS Import Merge method
XLS Import – Duplicates handling, merge method

6.3 Trigger workflow

The XLS Import have also Workflow Trigger feature, which work the same way as Workflow Trigger.

By default, this feature is turned off for XLS Import, however you can turn it on while you are creating an import by marking the checkbox.

XLS Import Workflow Trigger for Vtiger CRM
XLS Import – Workflow Trigger settings

How does this works?

  • Lets say you have created workflow for Contacts module, so every time Contact is created you send the welcome e-mail to that Contact.
    So your settings for workflow are: Trigger Workflow On – Contact creation.
  • When you import the .xls file via XLS Import, you are basically creating new records when the import is finished.
  • All you need to do is check the box in XLS Import Trigger workflow feature, so when you import the contacts, records are created = workflow is triggered = newly created contact will receive welcome e-mail

6.4 Create picklist values

Create picklist values is very useful feature of XLS Import if you have already created a picklist in your Vtiger CRM system with pre-defined values but you need to add additional value/s to it.

Example:

  • We have already created picklist for the Contacts module called “Picklist Preview” with values: Pick 1, Pick 2, Pick 3.

    XLS Import - Create picklist value
    XLS Import – Create picklist value

  • But, we want to add additional values to the picklist “Picklist Preview” when importing new records.

How to add new values to the Picklist?

Lets say we want to add new value for picklist “Picklist Preview”: New value 1.

We need to add the picklist field and values to the .xls file, see below:

XLS Import - Create picklist value
XLS Import – Create picklist value

Next, open XLS Import and load the file, then under 4. Additional settings check box Create picklist values.

XLS Import - Create picklist value
XLS Import – Create picklist value

Finish the import process, after import go to the Contact you imported and see that the new Picklist value was set:

XLS Import - Create picklist value
XLS Import – Create picklist value

And also added as a new value for the picklist “Picklist preview”:

XLS Import - Create picklist value
XLS Import – Create picklist value

6.5 Updating prices for the Price Books

Since version 4.10 released in October 2022, users have option to update prices of Products and Services in Prices Book via More button in the detail view of the Price Book record.

Please follow the steps to update prices in Price books:

  1. Go to your Price book detail view for which you want updated prices of the Products
    Price books price book – Updating prices for the Price Books
  2. Next, click on the button Updating prices for the Price Books and select XLS Import Products
    Price books price book – Updating prices for the Price Books
  3. When importing the .xls file, the 1. Select module is automatically filled with Price Book module, then you need just select your .xls file with Product Numbers and the Price/List price, in our case we will use only Product Number and Price as identifier:
    Our .xls file table below:

    Updating prices for the Price BooksXLS import – Updating prices for the Price Books
  4. Next step is important, here you select Identifier for already existing products in your Price Book:
    /A/ – Select the identifier, in our case it’s a Product Number/Product No for Products from our .xls file
    /B/ – From the table, select under CRM Field Identifier (*) for Header/Product Number and Price (*) for prices
    XLS import – Updating prices for the Price Books
  5. In third step of importResults, you can preview if import was successful and see overall preview, proceed via Finish button – Updating prices for the Price Books button.

XLS import – Updating prices for the Price Books

Below you can see how our Selling Prices in Price Book were updated:

From:

Updating prices for the Price Books

To:

Updating prices for the Price Books

Need help with XLS Import?

Our support team answers questions about installation, templates and settings.