acpnlsload utility

The acpnlsload utility loads the XML files that contain display names and descriptions into the appropriate databases.

Before you begin

Complete the following steps.

If you create customized XML files, copy the files into a directory in the Utility Docker container, for example, utilities_root/xml/policies/xml. The files must be in the Utility Docker container in order for them to be loaded into the database. Or, copy the files into the WCDE_installdir\xml\policies\xml directory.
The utility uses the Data Load framework to load the data. There are two steps in the load process.
1. Transform the input data file and generate a file that can be loaded. Create the file using the naming convention input_data_transformed.xml.
2. Load the data into the database by using the Data Load utility.
Update the target database information in the utilities_root/dataload/acpload/wc-dataload-env.xml or WCDE_installdir\dataload\acpload\wc-dataload-env.xml configuration file. (The target database information in wc-dataload-env.xml is shared by acugload, acpload and acpnlsload utilities.)
```
<_config:Database type="input_database_type" name="${dbName,input_database_name }" user="${dbUser,input_database_user }" 
password="${dbPassword,input_database_encrypt_password_ASCII }" server="${server,input_target_dbServer_name }" 
schema="${schemaName,input_database_schema_name}" > 
<_config:property name="port" value="${port,input_database_port}" /> 
</_config:Database>
```
Where:

input_database_type

Required: Database type accepted values are db2 or oracle.

input_database_name

Required: Name of the database in which to load the policy.

input_database_user

Required: Name of the database user who can connect to the database.

input_database_encrypt_password_ASCII

Required: The associated password for the database user. The wcs_encrypt utility is required to encrypt the password into an ASCII string. For more information, see Generating encrypted data with the wcs_encrypt utility.

input_target_dbServer_name

Required: Host name of the database server in which to load the policy.

input_database_schema_name

Optional: The name of target database schema. This name is normally the same as input_database_user.
This parameter is required if there are multiple schemas in the database into which you are loading data, for example if the database is enabled for workspaces.

input_database_port

Required: Port of the server on which the database is listening.
To load the access groups and access control policies, you need to run the following related utilities in this sequence:
1. acugload Loads the user access group definitions.
2. acpload Loads the main access control policy.
3. acpnlsload Loads the display names and descriptions.

Running the acpnlsload utility

To run the utility: Linux

./acpnlsload.sh input_data_file_absolute_path/input_data.xml

.\acpnlsload.sh input_data_file_absolute_path\input_data.xml

Check for errors in the wc-acTransform.log and wc-acLoad.log log files, which can be found in the utilities_root/logs or WCDE_installdir\logs directory. Errors might not appear on the command line.