%BRM_IMPORT_FOLDER

Imports the folder definitions that are in the specified CSV file into the rules database.

Restrictions: This macro must be run on the server tier.
The same user can run any of import macros at the same time. However, different users cannot run the same import macro simultaneously.

Syntax

%BRM_IMPORT_FOLDER (CSV=input_filename.CSV,
REJECT=reject_filename.CSV<, BRM_USER=user_ID>);

Required Arguments

CSV=input_filename

specifies the full pathname to the CSV file where you want to import the data from.

REJECT=reject_filename

specifies the full pathname to the CSV file where you want the macro to write any records that were not imported to the rules database. See Using the %BRM_IMPORT_FOLDER Macro for more information.

Optional Argument

BRM_USER=user_ID

specifies the user ID that you want to be associated with the data that is imported. This user ID is associated with the imported objects in the rules database and is displayed in the SAS Decision Manager interface.

Default User ID of the user that is running the macro

Details

Using the %BRM_IMPORT_FOLDER Macro

The %BRM_IMPORT_FOLDER macro enables you to create new folders. You cannot update the content in existing folders with this macro. The macro uses the pathname to determine whether a folder already exists. If the pathname already exists, then the folder is rejected.
The %BRM_IMPORT_FOLDER macro runs several validation checks as it imports the folders. For example, it checks whether each folder path begins with a top-level folder and verifies that individual folder names are not longer than 100 characters. If the macro finds an invalid folder definition in the CSV file, it writes a message to the SAS log, and the folder is rejected. The macro writes the input records for the rejected folder to the CSV file that was specified in the REJECT= option.

Format of the Folder CSV Input File

Each row of the CSV input file identifies a folder. The CSV file must contain all of the columns listed in the following table, in the order listed. You must specify values for all columns, except as noted in the following table. To create a blank column in the CSV file, specify two comma separators without any content between them. For example, to import data to a folder named Applications and to specify a blank column for the folder description and default folder flag, specify the following in the CSV file:
Applications,,Y,,Loans/Retail
Format of the Folder CSV Input File
Column
Description
Can Column Be Blank
FOLDER_NM
The name of the folder where you want to import the contents of the CSV file.
No
FOLDER_DESC
The description of the folder.
Yes
TOP_LEVEL_FOLDER_FLG
Specifies whether the folder is a top-level folder. Specify Y or N.
No
DEFAULT_FOLDER_FLG
Specifies whether the folder is the default folder. Specify Y or N.
Yes
FOLDER_PATH
The pathname to the business rules folder where you want to import the contents of the CSV file. This path must exist. Separate folder names with forward slashes.
No