ILO Import Wizard: File Mappings Tab

Version 3

    Import Wizard: Map File tab

    The Map File tab of the Import Wizard is a common step in many data source configuration or editing processes; this tab allows the user to map data to target fields in License Optimizer for one or more files that are to be imported using the data source.

    Some data source types do not include a Map File stage, because License Optimizer already has pre-set mapping for the data source type. One example of this is the ADDM data source type; the user will not need to map data files for a data source with an ADDM data source type, because the data mapping has been built into the License Optimizer platform.

    The Import Wizard will display a Map File tab for each file type that the user has identified for import as part of the data source. In the screenshot below, the data source has been configured to import software inventory data using the License Optimizer Generic data source type and so the Import Wizard displays one Map File tab – the Map Software File tab.

    Irrespective of the number of Map File tabs displayed, the user will find that the functionality on each Map File tab is the same; for each Target Match Column entry listed in the right pane, the user should select the relevant Input File Column (from the import files) using the associated drop-down list in the left pane. In this way, the user is able to map input data to target fields in License Optimizer.

    Any fields shown in the Target Match Column pane with a red asterisk are mandatory; the user must select a Input File Column to map to these columns.


    If a Target Match Column field does not have a suitable match in the Input File data (and a red asterisk is not displayed alongside the Target Match Column field), the user may leave the Input File Column drop-down blank (the Do Not Map Any Input to… option).

    The user may also use the following functionality:

    • Edit Columns button
      Clicking the Edit Columns button will display the Calculated Columns Editor pop-up screen allowing the user to edit any calculated columns. For more information on Calculated Columns, see Calculated Columns.
    • Row button
      Clicking the Row button allows the user to view data in subsequent rows of the import file; this can be useful when mapping the file.
    • Preview Data button
      Clicking the Preview Data button will display the Preview Data page in a new window allowing the user to see the data in the selected import file mapped against the Target Match Columns using the mappings specified by the user. This functionality is similar to the Row button functionality (in that it can be useful in helping the user to map the file) but shows all data from the selected input file in a data grid; the data grid may be navigated in the usual way and the user may specify rows that should be ignored in the import by checking the Ignore Row checkbox for the associated data grid entry.
    • Reset Mappings button
      Clicking this button will discard any mappings previously set by the user.