Periodically ingest 'trained' records from legacy system

Makespace / members-app

Simplifying operations for Cambridge MakeSpace

MIT License

1 stars 2 forks source link

Periodically ingest 'trained' records from legacy system #32

Open Lan2u opened 5 months ago

Lan2u commented 5 months ago

[x] 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.
[x] 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 commented 5 months ago

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

Lan2u commented 5 months ago

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 commented 5 months ago

Makespace-Database 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.