How to import data using mapping

In many cases, the source file which needs to be imported does not match the system configuration. Once mapping configuration is set up data can be imported from the source file without any input of the user. For example, our source file looks following:

To convert it to JMS format follow the steps below:

1. Open mapping window
2. Select configuration (1) and click Select (2).
   
   

*All configurations can be selected at the same time

3. Select source file
   

4. Excel Add-On pulls the data from the source file, maps columns and data values if there are any preconfigured value mapping
   

Now data can be imported into the system.