msa import gen assign hist cols - ajtruckle/meeting-schedule-assistant-support GitHub Wiki

Column Headings

Here is a complete list of the column headings along with any required values:

Column Heading Possible Values Additional Remarks
Week Date in format dd/MM/yyyy. This is the Monday for the Week.
MidweekMeeting Y | N Not currently used.
WeekendMeeting Y | N Not currently used.
NumClasses 0 | 1 | 2 | 3 We don’t validate this field.
Host Name or empty
Cohost Name or empty
ZoomAttendant Name or empty
Chairman Name or empty
AuxCounsellor1 Name or empty
AuxCounsellor2 Name or empty
PrayerOpen Name or empty
Treasures_Name Name or empty
Treasures_Theme
Treasures_Method T | TV | TVS Read the Methods help topic for an explanation of the Method abbreviations.
Gems_Name Name or empty
Teaching Y | N
Teaching_Class1_Name Name or empty
Teaching_Class2_Name Name or empty
Teaching_Class3_Name Name or empty
BibleReading_Study 0 to 20
StudentItem1_Study 0 to 20
StudentItem2_Study 0 to 20
StudentItem3_Study 0 to 20
StudentItem4_Study 0 to 20
StudentItem1_Description IC_Video | RV_Video IC | RV | BS | T | "Anything else" Read the Methods help topic for an explanation of the Method abbreviations.
StudentItem2_Description IC | RV | BS | T | "Anything else" Read the Methods help topic for an explanation of the Method abbreviations.
StudentItem3_Description IC | RV | BS | T | "Anything else" Read the Methods help topic for an explanation of the Method abbreviations.
StudentItem4_Description IC | RV | BS | T | "Anything else" Read the Methods help topic for an explanation of the Method abbreviations.
BibleReading_Class1_Name Name or empty
BibleReading_Class2_Name Name or empty
BibleReading_Class3_Name Name or empty
StudentItem1_Class1_Name Name or empty
StudentItem1_Class1_Assistant Name or empty
StudentItem2_Class1_Name Name or empty
StudentItem2_Class1_Assistant Name or empty
StudentItem3_Class1_Name Name or empty
StudentItem3_Class1_Assistant Name or empty
StudentItem4_Class1_Name Name or empty
StudentItem4_Class1_Assistant Name or empty
StudentItem1_Class2_Name Name or empty
StudentItem1_Class2_Assistant Name or empty
StudentItem2_Class2_Name Name or empty
StudentItem2_Class2_Assistant Name or empty
StudentItem3_Class2_Name Name or empty
StudentItem3_Class2_Assistant Name or empty
StudentItem4_Class2_Name Name or empty
StudentItem4_Class2_Assistant Name or empty
StudentItem1_Class3_Name Name or empty
StudentItem1_Class3_Assistant Name or empty
StudentItem2_Class3_Name Name or empty
StudentItem2_Class3_Assistant Name or empty
StudentItem3_Class3_Name Name or empty
StudentItem3_Class3_Assistant Name or empty
StudentItem4_Class3_Name Name or empty
StudentItem4_Class3_Assistant Name or empty
Living1_Name Name or empty
Living1_Theme
Living1_Method V | T | TVS | TV | TD | TI | TDI |  QA |QAD | QAI | QADI |  D | DD | DI | DDI | DV | DVS Read the Methods help topic for an explanation of the Method abbreviations.
Living2_Name Name or empty
Living2_Theme
Living2_Method V | T | TVS | TV | TD | TI | TDI |  QA |QAD | QAI | QADI |  D | DD | DI | DDI | DV | DVS Read the Methods help topic for an explanation of the Method abbreviations.
Living3_Name Name or empty
Living3_Theme
Living3_Method V | T | TVS | TV | TD | TI | TDI |  QA |QAD | QAI | QADI |  D | DD | DI | DDI | DV | DVS Read the Methods help topic for an explanation of the Method abbreviations.
CBS_Conductor Name or empty
CBS_Reader Name or empty
PrayerClose Name or empty
Weekend_Host Name or empty
Weekend_Cohost Name or empty
Weekend_ZoomAttendant Name or empty
Weekend_Chairman Name or empty
Weekend_PrayerOpen Name or empty
Weekend_PT_Speaker Name or empty
Weekend_PT_Theme
Weekend_PT_Number
Weekend_PT_Hospitality Name or empty
Weekend_PT_Interpreter Name or empty
Weekend_AT1_Name Name or empty
Weekend_AT2_Name Name or empty
Weekend_WT_Conductor Name or empty
Weekend_WT_Reader Name or empty
Weekend_WT_BibleVersesReader Name or empty
Weekend_PrayerClose Name or empty
Weekend_Misc