Sample data file

This text is an example of one record in the Shift Pattern Import CSV data file:

"Emp1","20030105",,,,"19000101",,,,,,,,"FLAGS",,"1~1","0800~1700","1000,
1030,LUN,REG,30","JOB_NAME=X","2~1","0800~1700",,,"3~1","OFF",,,"4~1","OFF",,,
"5~1","0800~1700","1000,1030,LUN,REG,30","JOB_NAME=X",
"6~1","0800~1700","1000,1030,LUN,REG,30","JOB_NAME=Y",
"7~1","0800~1700","1000,1030,LUN,REG,30","JOB_NAME=Y",

This text is an example with Team and Activity included in the Shift Pattern Import CSV data file:

REPORT-01,20241031,,ALL DAYS,ALL DAYS DESC 1,19000101,,TSSHIFTGROUP,,,,,,FLAGS,,1~1,0800~1700,"1000,1030,BRK,REG,30",ACT_NAME=REPORT ACT 1,2~1,0800~1700,,,3~1,OFF,,,4~1,OFF,,,5~1,0800~1700,"1000,1030,BRK,REG,30",WBT_NAME=REPORT STORE,6~1,0800~1700,"1000,1030,BRK,REG,30",JOB_NAME=REPORT Job 1,7~1,0800~1700,"1000,1030,BRK,REG,30",JOB_NAME=REPORT Job 1

This text is an example of importing more than 22 shifts per Shift Pattern. Split the shifts into rows with each row having 13 shifts (or less). Use the * in column 15/O.

,,,Parham Shift
Pattern4,description,,,,,,,,,,*,1~1,0900~1700,,,2~1,0800~1600,,,3~1,0800~1700,,,4~1,0900~1600,,,5~1,1000~1600,,,6~1,
1000~1500,,,7~1,1000~1700,,,8~1,1000~1800,,,9~1,0800~1800,,,10~1,0800~1900,,,11~1,0900~1500,,,12~1,0900~1800,
,,13~1,0700~1600

,,,Parham Shift 
Pattern4,description,,,,,,,,,,,14~1,0700~1500,,,15~1,0700~1700,,,16~1,0700~1800,,,17~1,0700~1900,,,18~1,0600~1400,
,,19~1,0600~1500,,,20~1,0600~1600,,,21~1,0600~1700,,,22~1,0600~1800,,,23~1,1100~1600,,,24~1,1100~1700