Skip to main content

Import Location

Use the Import Location option to import the physical location data for hosts and opens a customized version of the Import Hosts window. Add host locations from a CSV file or SQL Server database without creating a new host list. See the Host Inventory Data Grid topic for information on the Location column of host inventory.

To import physical location data for hosts:

Step 1 – Ensure the import source file has columns for both the host name as it is identified within Access Analyzer and the location.

note

When a host name doesn't match any existing hosts within the Host Master Table, you can add it as a new host.

Import Location option on Activities pane

Step 2 – Select the host list and click Import Location.

Import Hosts window for importing location

Step 3 – On the Import Hosts window, use the Import from dropdown to select the source as either CSV File or Database.

Step 4 – Configure the source file. The necessary fields depend on the selection in the previous step.

  • CSV File

    • File Name – Click the ellipsis (…) to open a browser window and select the CSV file. You must store this file on the Access Analyzer Console server. After you select the file, Access Analyzer shows a preview in the preview box.
    • Includes header row – Select this checkbox if the file contains a header row. Otherwise, Access Analyzer includes the header row in the import (visible within the preview box).

  • Database

    • Data source – Identify the database. Click the ellipsis (…) to open the Data Link Properties window. Provide the required information on the Connection tab of the Data Link Properties window, and then click OK. See the Import From a Database topic for additional information.

      note

      Don't modify the Provider, Advanced, and All tabs of the Data Link Properties window.

    • Table – Use the dropdown to select the table that contains the hosts to import. Access Analyzer displays a preview of the selected table in the preview box.

Step 5 – Use either the dropdown menu or click the column in the preview box to select the column containing the host names. The selected column is highlighted in the preview box.

Import Hosts window Location column selection

Step 6 – Use the Import column dropdown menu to select the column containing the location information. The selected column is highlighted a lighter color in the preview box.

Step 7 – Click OK to complete the import.

Imported Location column data in the data grid

The Location column now contains the imported information. If any of the hosts included in the import file aren't already in the Host Master Table, Access Analyzer prompts for confirmation on whether to import the host. Selecting Yes or Yes to All adds the new hosts to the Host Master Table but not to any individual host lists.

note

Access Analyzer adds any new hosts that match dynamic host list criteria to the appropriate dynamic host lists.