Periodically ingest 'trained' records from legacy system

[Lan2u]

• As a trainer for a piece of equipment I want to be able to mark people who have finished the training quiz and attended a training as trained on a piece of equipment.

• As an admin I want to be able to mark anyone as trained on a piece of equipment even if they aren't registered as doing the quiz so I can resolve issues with the system and mark people who were previously traiined.

• As a director of makerspace I want to be able to see the quiz -> training -> signoff chain for when a member was trained on a piece of equipment so that I can quickly provide this information to insurers if required.

[erkannt]

As an admin I also need to be able to ingest training records from the old database

[Lan2u]

As an admin I also need to be able to ingest training records from the old database

Are you able to post an example of the data format

[erkannt]

This is the DB schema (no guarantee that it is up to date). So we should be able to get a mapping of int -- Equipment_Name and a dump of rows with MemberNumberOfTrainee, MemberNumberOfTrainer, EquipmentInt and DateTrained. When I dump the TrainingRecord table I am currently getting odd looking numbers for the member numbers:

"Lasercutter",1,106179,"",106226,""

I think @wardhills written some python scripts to dump out this kind of information. Might be best to get together remote or in person to do the data import.