Attribute Management > Execute the Load Host Attribute Utility
  
Version 10.0.01
Execute the Load Host Attribute Utility
Note: This utility can be used to load new data as well as to update previously loaded data. To revise existing data, simply run the utility with an updated CSV file.
To assign attributes to hosts
 
1. Create a table in a spreadsheet, as shown in Create a CSV File of Hosts, Attributes, and Values.
2. Save the table as a comma-separated file (for example, HostAttributes.csv).
3. Log in to the Portal server.
4. At the command line:
su - aptare
5. At the command line, launch sqlplus:
sqlplus <pwd>/<pwd>
Example: sqlplus portal/portal
6. Execute the following at the SQL prompt:
SQL> Execute load_package.loadServerAttributeFile('pathname_and_filename', 'domain_name',host_name_column_num,'log_path_name','log_file_name','check_valid_value');
Where:
'pathname_and_filename'
Full path + filename (enclosed in single straight quotes) of the CSV file that you created.
'domain_name'
Name (enclosed in single straight quotes) of the Storage Viewer domain in which the host groups and hosts reside. See Finding the Domain Name.
host_name_column_num
Column number in the csv file where the host names are listed. These hosts must already exist in the Storage Viewer database. Typically, this would be column 1.
'log_path_name'
Full path (enclosed in single straight quotes) where the log file will be created/updated. Verify that you have write access to this directory.
Example: 'C:\tmp'
Optional: If you do not specify a path and log file name, only error messages will be written to the scon.err file. To omit this parameter, enter: ''
'log_file_name'
Filename of the log where execution status and errors messages are written.
Example: 'HostAttributeLoad.log'
Optional: If you do not specify a path and log file name, only error messages will be written to the scon.err file. To omit this parameter, enter: ''
'check_valid_value'
'Y' or 'N' Indicates if you want the utility to check if the values provided in this file are among the existing possible values for the attributes. Y or N must be enclosed in single straight quotes.
Example:
Execute load_package.loadServerAttributeFile('C:\myfiles\HostAttributes.csv',
'QA_Portal',1,'C:\tmp','HostAttributeLoad.log','Y');
7. Restart the Portal services so that the newly added attributes become available in the Dynamic Template Designer.