Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Automated Archiving

Each morning, as part of the preparation of the main ConnTools/Backend Processes unit lookup table, all

  • CO_ (Class/Delivery Offerings)

  • CLO_ (Clustered Offerings)

  • CH_ (Course Hubs)

...

General Google Sheet usage info

One thing to be mindful of is that when a sheet is being checked/processed by one of our scripts, you need to be really careful If the above automated process is not enough, there are several sheets that can be used to archive units as well.
It is very important to not to delete an entire row in the sheet. This is because the scripts effectively copy the sheets into memory, process them as required, and write back. So any changes made to the sheet during the processing stage will be overwritten, or, in the case of rows being moved or deleted, cause the wrong data to be loaded back to the wrong rows.

Instructions

Browse to the appropriate sheet (listed below), and enter:

...

The image below highlights the status changes for archived offerings in ConnTools and CCT.Archiving Status in ConnTools and CCT.pngImage Removed

...

Archiving Regional Masters

You can view the sheet for RMs here: https://docs.google.com/spreadsheets/d/1UFNV_LqPROL61-66HcbdKvUnLMD0IWnzDNvF-RD4TEU/edit#gid=1225771478
Regional admins cannot add rows to this sheet. Forward a TAP request to Learning Systems Support if you want to archive RMs.

Thissheet updates each evening to reflect the status of all regional master in Connect, with the first two tabs showing info about existing RMs.
The third AutomatedArchiveProcess tab is used for archiving, and runs once per day at 2pm.