The Generic Importer recognises the following column headings when processing assignment history data.

  • Fields are grouped by functional area (meeting, teaching, student items, and weekend programme).
  • Where patterns repeat, numeric suffixes are used (e.g. StudentItem1–4, Class1–3).

Core Fields

Column Heading

Possible Values

Notes

Week

dd/MM/yyyy

Monday of the week

MidweekMeeting

Y | N

Legacy field (ignored)

WeekendMeeting

Y | N

Legacy field (ignored)

NumClasses

0 | 1 | 2 | 3

May be ignored if out of range

Midweek Meeting Roles

Column

Values

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

PrayerClose

Name or empty

Teaching / Programme Items

Column

Values

Notes

Treasures_Name

Name or empty

Treasures_Theme

Treasures_Method

T | TV | TVS

See Methods topic

Gems_Name

Name or empty

Teaching

Y | N

Student Items (Pattern-Based Fields)

Student item fields follow a repeating structure:

  • StudentItem{1–4}_Study (0–20)
  • StudentItem{1–4}_Description
  • StudentItem{1–4}_Class{1–3}_Name
  • StudentItem{1–4}_Class{1–3}_Assistant

Descriptions use method codes (IC, RV, BS, T, etc.).
Study values represent a study number (0–20).

Living Parts

Column

Values

Notes

LivingX_Name

Name or empty

X = 1–3

LivingX_Theme

LivingX_Method

V | T | TVS | TV | TD | TI | TDI | QA | QAD | QAI | QADI | D | DD | DI | DDI | DV | DVS

See Methods topic

Weekend Meeting

Column

Values

Notes

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

Integer

Public Talk 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

Free text

Optional

Related Topics

Navigation