Share this page

# How to Import AUT Host Data from Excel

This task describes how to import a list of AUT hosts from an Excel file (.xls or .csv) into ALM.

1. Prerequisites

   The Excel file must be set up so that the columns can be recognized and mapped by the Import feature.

   - The first row of the Excel file must contain the field names, or corresponding logical names, that appear in the table below. (Logical names are not case sensitive.)

     Some fields are mandatory, others are required or optional.

     - Mandatory indicates a field that must appear in the Excel file. If you omit this field, the import fails. If you omit a value in one of the rows of this field's column, the import of that specific row fails.
     - Required indicates a field that should appear in the Excel file. If you omit this field, the code adds the field with the default value for all rows. If you include the field, but omit a value in one of the rows of this column, the code adds the default value for that row.
     - Optional indicates a field does not have to appear in the Excel file. Omitting this field has no effect on the import procedure.

   - Fields representing virtual, reference, and invalid fields are ignored.

   - Empty columns are allowed.

   Set up the columns and values in the file as follows:

   Field name | Logical name | Value | Field for
   --- | --- | --- | ---
   AUTHOST_NAME Required | Logical Name | Any string | AUT host logical name Note: If this value is empty, this will be given the same value as AUTHOST_MACHINE_NAME
   AUTHOST_MACHINE_NAME Mandatory | Machine Name / IP | The machine name/IP | AUT host physical machine name
   AUTHOST_USERNAME Mandatory | Username | The user name of the machine | User name for logging on to the AUT host machine
   AUTHOST_PASSWORD Mandatory | Password | The password of the user name | Password for logging on to the AUT host machine
   AUTHOST_OS Required for UNIX platforms only | OS Type | SUNOS (default) Sun Solaris MacOSX Linux Red Hat Enterprise Linux AIX FreeBSD HP-UX HP/UX HP/UX 64-bit NonStopOS OPENSERVER SCO SGI Irix Tru64 5.x Tru64 pre 4.x (Digital) | AUT host machine operating system (For UNIX platform only)
   AUTHOST_PLATFORM Required | Platform | Windows (default) UNIX | AUT host platform
   AUTHOST_PROTOCOL Required | Protocol | Windows: NetBIOS (default) SSH WMI UNIX: rlogin Telnet (default) SSH | AUT host protocol
   AUTHOST_UNIX_PROMPT Required for UNIX platforms only | UNIX Prompt | # (default) | UNIX prompt on the AUT host machine
   AUTHOST_DESCRIPTION Optional | Description | Any string | AUT host description

   Example:

   The following image illustrates an Excel file set up with the following AUT hosts: 1.2.3.4, 5.6.7.8, and a third machine whose name was not provided.

2. Import the AUT hosts (only for LoadRunner Enterprise users)

   1. Open the AUT Hosts module:

   - In ALM: On the ALM sidebar, under LoadRunner Enterprise AUT, select AUT Hosts.

   - In Lab Management: On the Lab Management sidebar, under LoadRunner Enterprise, select AUT Hosts.

   2. Select AUT Hosts > Import.

   3. Browse to the Excel file containing the AUT hosts, and click Open.

3. Results

   The progress of the import process is displayed. At the end of the process, a report displays the import results. The imported AUT hosts are listed in the AUT Hosts module. AUT hosts that are not imported successfully, must be added manually.

   Example:

   The results from importing the Excel file in step 1 above are illustrated in the following image:

   Note:

   - No logical name was provided in the Excel file for machine 1.2.3.4. Therefore, the logical name given is equivalent to the machine name/IP.

   - Machine 1's operating system was specified as SUNOS, whereas the platform was specified as Windows. These values are inconsistent as SUNOS is relevant only for a UNIX platform. The value SUNOS was replaced with NT.

   - No machine name was specified for the third machine listed in the Excel file. This machine was not imported. It should be added manually.

   - Required but non-mandatory values were automatically provided by the system during the import process.

   - Columns representing virtual, reference, non-valid fields were ignored.

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 16.00-16.0.1 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: