Attribute Management > Execute the Load MS Exchange Organization Attribute Utility
  
Version 10.0.01
Execute the Load MS Exchange Organization 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 Microsoft Exchange Organizations
1. Log in to the Portal server.
2. At the command line:
su - aptare
3. At the command line, launch sqlplus:
sqlplus <pwd>/<pwd>
Example: sqlplus portal/portal
4. Execute the following at the SQL prompt:
SQL> Execute load_package.loadExchOrgAttributeFile('pathname_and_filename', 'domain_name',exchange_org_column_num,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
Windows Example: 'c:\config\MSExchangeAttributes.csv'
Linux Example: '/config/MSExchangeAttributes.csv'
'domain_name'
Name (enclosed in single straight quotes) of the Storage Viewer Domain in which the host groups and hosts reside; Example: 'DomainEMEA'
exchange_org_column_num
Column number in the csv file where the MS Exchange Organization is listed; Example: 1
host_name_column_num
Column number in the csv file where the Host Name is listed; Example: 2
'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.
Optional: If a log path and filename are not specified, log records are written to scon.log and scon.err.
Example: 'c:\configs'
'log_file_name'
Name of the log file enclosed in single straight quotes.
Optional: If a log path and filename are not specified, entries are written to scon.log and scon.err.
Example: 'MSExchangeAttributes.log'
'check_valid_value'
'Y' or 'N' enclosed in single straight quotes.
Y - Checks if the attribute value exists. If the utility determines that the attribute value is not valid, it skips this row and does not assign the attribute value to the Exchange Organization.
N - Updates without checking that the attribute value exists. This option is seldom chosen, but is available for certain customer environments where attributes may have been created without values (with scripts that bypass the user interface).
Example:
SQL> Execute load_package.loadExchOrgAttributeFile('/config/MSExchangeAttributes.csv', 'DomainEMEA',1,2,'/config/logs','MSExchangeAttributes.log','Y');
5. Check the log file for status and errors.
6. Restart the Portal services so that the newly added attributes become available in the Dynamic Template Designer.
7. Go to Verify the MS Exchange Organization Attributes Load.