Attribute Management > Execute the Load Array Attribute Utility
  
Version 10.0.01
Execute the Load Array Attribute Utility
Before You Begin
Bulk Load utilities must be run in SQLPLUS as user APTARE. The load_package utility is located in:
/opt/aptare/database/stored_procedures (Linux)
\opt\oracle\database\stored_procedures (Windows)
To assign attributes to arrays
Note: This utility only assigns attributes to active arrays. If an array exists in the system, but it is inactive, the log will indicate that no attribute was assigned.
1. Create a table in a spreadsheet, as shown in Create a CSV File of Arrays, Attributes, and Values.
2. Save the table as a comma-separated file (for example, ArrayAttributes.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.loadArrayAttributeFile('pathname_and_filename', 'domain_name',array_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 you created.
'domain_name'
Name (enclosed in single straight quotes) of the Storage Viewer domain in which the arrays reside. See Finding the Domain Name.
array_name_column_num
Column number in the csv file where the array names are listed. These arrays 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: 'ArrayAttributeLoad.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.loadArrayAttributeFile('C:\myfiles\ArrayAttributes.csv',
'QA_Portal',1,'C:\tmp','ArrayAttributeLoad.log','Y');
7. Restart the Portal services so that the newly added attributes become available in the Dynamic Template Designer.