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.
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.
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.