USER_NOT_IN_FILE_ACTION=NOACTION
FILENAME=users
DELIMITER=,
#SKIP_NUMBER_OF_LINES=1
#ZERODAYPROVISIONING=TRUE
#userReconcillationField=UserName
GENERATESYSTEMUSERNAME=TRUE
GENERATEEMAIL=TRUE
EMAILTEMPLATE="Email Template Name"
CHECKRULES=TRUE
#MODIFYUSERDATAJSON={"ADDITIONALTABLES":{"USERS":"SELECT USERNAME, ORGUNITID FROM USERS","ACTIVEIDENTITIES":"SELECT DISTINCT USERNAME FROM USERS WHERE COUNTRY = 'SWITZERLAND'"},"COMPUTEDCOLUMNS":["CUSTOMPROPERTY7","STATUSKEY"],"PREPROCESSQUERIES":["UPDATE NEWUSERDATA set CUSTOMPROPERTY7 = '1'","UPDATE NEWUSERDATA N1 LEFT JOIN CURRENTACTIVEIDENTITIES AI ON N1.USERNAME = AI.USERNAME SET N1.STATUSKEY = CASE WHEN AI.USERNAME IS NOT NULL THEN '1' ELSE '0' END"]}
USERNAME,FIRSTNAME,LASTNAME,COUNTRY