acpnlsload utility

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

Before beginning

Complete the following steps.

1. If we create customized XML files, copy the files into a directory in the Utility Docker container, for example, (Linux) 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

   (Developer) WCDE_installdir\xml\policies\xml directory.

2. 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 using the Data Load utility.

3. Update the target database information in the (Linux) utilities_root/dataload/acpload/wc-dataload-env.xml or

   (Developer) 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. See Generate encrypted data (wcs_encrypt).

   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 we 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.

4. 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

1. To run the utility: (Linux)

   ./acpnlsload.sh input_data_file_absolute_path/input_data.xml

   or
   

   (Developer)

   .\acpnlsload.sh input_data_file_absolute_path\input_data.xml

2. Check for errors in the wc-acTransform.log and wc-acLoad.log log files, which can be found in the (Linux) utilities_root/logs or

   (Developer) WCDE_installdir\logs directory. Errors might not appear on the command line.

Related tasks
Running utilities from the Utility server Docker container