msa import gen assign hist cols

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