Assignment History

Use the Assignment History importer to import historical meeting assignments from a CSV file.

Select Assignment History from the Import fly-out menu on the Database menu in the Publishers Database window.

Figure 54. Selecting Assignment History from the Import menu

[!NOTE] Read the Getting Started topic before you proceed.

Data Integrity

The Assignment History importer performs only limited validation on your CSV data. For example:

• Public talk numbers and themes are not validated.
• Publisher names are not checked against whether they have those assignments recorded in the database.

This keeps the importer flexible, but it also means the accuracy of your CSV data is essential.

Import Rules

The importer applies several rules to ensure that only meaningful and usable history entries are added:

• Week must be in the format dd/MM/yyyy (e.g., 31/03/2022).
• Week must be a Monday.
• Weeks more than 2 old are ignored.
• Weeks already present in the history database are ignored.
• Method must be valid.
• Study numbers must be between 0–20.
• Names (when specified) must already exist in the Publishers Database
  (excluding Public Talk Speaker / Concluding Prayer).

Warnings are written to an English-language log file, which you will be prompted to view. Exceptions are also recorded in the log.

[!NOTE] If you are unsure what the log is telling you, please get in touch or ask in the Support Forum.

Related Topics

• Column Headings
  Reference guide to all column headings and valid values used by the Generic Importer.
• Method Abbreviations
  Reference guide to all student and talk method abbreviations used during generic importing.

Navigation

• Parent topic: Generic Importing
• Previous topic: Getting Started