Appendix G: IEP User Upload File Format The following file format will be used to auto-generate MD Online IEP Users. The sync/auto-generation engine is being developed to run as often as nightly after July 1, 2007. A flat file matching the format defined below will uploaded by an LSS to an IEP-specific account on the MSDE Secure Transport site, , as often as nightly. Layout and field definitions are specified in detail on the following pages. Some guidelines to follow when creating the file are: The file should be named iepusers.txt each time that it is generated. The sync engine will look for that file name each night. The iepusers.txt file should be uploaded to the root LSS directory on the MSDE Secure Transport Site associated accessed via the IEPxx logon that is provided to data managers. No column headers should be appended. Only teachers and school level users can be auto-generated. County level users cannot be auto-generated. The combination of LEA # and School # fields will place an IEP user at his/her primary school only. The 4 positions will accept blank values. This may be helpful if LSS wishes to create on active teachers with edit access and no admin access. Each record in the file must have a length of 145 characters even if LSS chooses to leave final position(s) blank. POSITION ITEM TYPE LENGTH CODES 1-25 Name CHAR 25 26-60 Last Name CHAR 35 61-62 LEA # NUM 2 63-66 School # NUM 4 67-141 Email Address CHAR 75 0= Teacher (default if blank), 142-142 User Group NUM 1 1=School Admin 0= Not Granted, 143-143 Edit Access NUM 1 1= Granted (default if blank) 0= Not Granted (default if blank), 144-144 Access NUM 1 1= Granted 0=Active (default if 145-145 Active/Inactive NUM 1 1=Inactive Name (25 position alpha) Description: The IEP user’s first name. Last Name (35 position alpha) Description: The IEP user’s last name.
Appendix G: IEP User Upload File Format The following file format will be used to auto-generate MD Online IEP Users. The sync/auto-generation engine is being developed to run as often as nightly after July 1, 2007. A flat file matching the format defined below will uploaded by an LSS to an IEP-specific account on the MSDE Secure Transport site, , as often as nightly. Layout and field definitions are specified in detail on the following pages. Some guidelines to follow when creating the file are: The file should be named iepusers.txt each time that it is generated. The sync engine will look for that file name each night. The iepusers.txt file should be uploaded to the root LSS directory on the MSDE Secure Transport Site associated accessed via the IEPxx logon that is provided to data managers. No column headers should be appended. Only teachers and school level users can be auto-generated. County level users cannot be auto-generated. The combination of LEA # and School # fields will place an IEP user at his/her primary school only. The 4 positions will accept blank values. This may be helpful if LSS wishes to create on active teachers with edit access and no admin access. Each record in the file must have a length of 145 characters even if LSS chooses to leave final position(s) blank. POSITION ITEM TYPE LENGTH CODES 1-25 Name CHAR 25 26-60 Last Name CHAR 35 61-62 LEA # NUM 2 63-66 School # NUM 4 67-141 Email Address CHAR 75 142-142 User Group NUM 1 0= Teacher (default if blank), 1=School Admin 143-143 Edit Access NUM 1 0= Not Granted, 1= Granted (default if blank) 144-144 Access NUM 1 0= Not Granted (default if blank), 1= Granted 145-145 Active/Inactive NUM 1 0=Active (default if 1=Inactive Name (25 position alpha) Description: The IEP user’s first name. Last Name (35 position alpha) Description: The IEP user’s last name.