Execute the Load Utility
To load attributes and values for a domain
1. Create a table in a spreadsheet, as shown in the above example. Save the table as a comma-separated file in a temporary directory.
• Windows example: C:\temp\attributes.csv
• Linux example: /tmp/attributes.csv
2. Log in to the Portal server.
3. At the command line:
su - aptare
4. At the command line, launch sqlplus:
sqlplus <pwd>/<pwd>
• Example: sqlplus portal/portal
5. At the command line, execute the following at the SQL prompt:
SQL> Execute load_package.loadAttributeFile('pathname_and_filename', 'domain_name');
where:
'pathname_and_filename' | full path + filename (enclosed in single straight quotes) of the CSV file that you created |
'domain_name' | name of the domain in which the hosts reside (enclosed in single straight quotes). See Finding the Domain Name. |
Example:
Execute load_package.loadAttributeFile('c:\temp\attributes.csv', 'HDS');
6. Restart the Portal services so that the newly added attributes become available in the Dynamic Template Designer.
Finding the Domain Name
To identify the domain:
• In the Portal: Admin > Hosts and Domains > Domains