Administrative and Deployment Enhancements
 
• In aPriori 2019 R2 SP1, aPriori passwords can be wrapped in double-quotes when passed to command line utilities. This avoids issues with passwords that contain characters with special meaning to the Windows command line, e.g. ampersand (&), greater than (>), space, etc.
One such instance where passwords should be enclosed in double-quotes is when running the compatibility script updateCompatibleVersions.cmd, as part of upgrading to a new release of aPriori. (This script ensures that the aPriori client installed on an end user’s machine can interoperate with the updated aPriori database.) The script requires you to provide the user’s aPriori username and password as arguments; in the example below the username is admin and the password includes six non-alphanumeric characters { } < > & and the space character:
 
.\updateCompatibleVersions.cmd admin "{red} & <green>"
 
If these commands are run from Windows PowerShell it may be necessary to wrap the double quotes in single quotes as well, for example:
 
.\updateCompatibleVersions.cmd admin '"123+456=579"'
 
As a best practice, always wrap passwords with quotes when you run aPriori command line utilities.
 
Note: The following characters may still cause issues and should not be used in passwords: percent (%), caret (^), double-quote ("), single-quote (').The following characters may still cause issues and should not be used in passwords or usernames:
% ^ " '
 
• aPriori Professional allows System Administrators to update (add, delete, change) User-Group Associations by importing a spreadsheet of replacement user-group mappings. Prior to release 2019 R2 SP1, System Administrators could import the replacement spreadsheet only from the System Admin Toolset interface. Now, System Administrators can import a replacement spreadsheet by using the command line interface.
• The syntax for importing a User-Group Association spreadsheet from the command line interface is
loadUserGroupAssociations.cmd <path_to_xls_file_with_associations> <user_name> <user_password>
• The structure for a User-Group Associations spreadsheet that you import from command line interface is the same as the format for the spreadsheet that you export or import by using the System Admin Toolset interface. For more information, see Using Import/Export for Access Control.