Web Admin Tool Guide

Add Multiple Mappings

You can add more than one mapping in a Custom Import Mapping. An instance where you can use this is if the Excel file has multiple tabs, and you want to import data from each of them

You add each mapping by clicking the Add button in the Entity Mapping window.

Example

The Data.xlsx file has two tabs with data, Employee and Popup1.

When you import this file, you must import the Popup1 entries before the Employee entries.

To do this, complete the following steps:

  1. Create a Custom Import Mapping.
  2. Click the Add button to add a mapping.
  3. In the Source Tab Name - Excel field, select the Popup1 tab.

    The resulting mapping should show the ExternalID and the Name columns being mapped.

  4. In the Destination Entity Name field, select Resources > Parameters > Resource Popups > ResourcePopup1 from the drop-down list.
  5. Click Save.

    You have now created the first mapping. To add a second mapping, you must continue with the following steps.

  6. Click the Add button again.
  7. In the Destination Entity Name field, select Resources > Resource.
  8. In the Source Tab Name - Excel field, select the Employee tab.
  9. Click Save.

You have now created a second mapping.

The order of the mappings is important. When you run the Custom Import Mapping, the individual mappings are run in the order in which they appear.

The result of this custom import mapping is that you have imported rows into the Popup1: Views > Resources > Parameters > Resource Popup > Popup 1.

Similarly, rows have been added in the Views > Resources > Resources view, and if you add the Popup 1 column, the popups are seen as well.

Note: If you define multiple mappings, you cannot use the Import multiple files option.

The preceding example is with an Excel file, but the multiple mappings can be used for the other types of import as well; for example, you can select multiple CSV files in the CSV Files(s) field and then create a mapping for each of them.