The final project at my last role involved extracting seven years of learner data for 80,000 learners from an LMS that was being decommissioned. The shock of our vendor’s £150,000 quote to both extract and host 3TB of learner data led me to explore a robotic process automation (RPA) solution using a low cost browser plugin, UIVision. This article explores how I crafted and fine-tuned a suite of RPA scripts to automate the data extraction and reflects on the challenges faced and lessons learned.
