%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

Required Arguments

Optional Argument

Details

Using the %BRM_IMPORT_FOLDER Macro

Format of the Folder CSV Input File

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 Business Rules Manager interface.

Default

User ID of the user that is running the macro

Details

Using the %BRM_IMPORT_FOLDER Macro

Format of the Folder CSV Input File

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