Alberta’s Capital Health was a big user of Expedition from the 1990’s through to 2010. They had hundreds of projects that were sitting on a Sybase SQL-Anywhere server that needed to be retired but they needed to have easy access to the documents related to these health care projects.
Emerald solved their problem using the PCM-Archiver. This PCM add-on tool automates the extraction process of all projects and documents, and in this case, ultimately saved the client approximately 140 hours of computing work. For a more in-depth understanding of this project and its results please refer to Part 1 of Saying Goodbye to Expedition 8.5 and Hello to Unifier. In Part 2 we are going to explore a more technical perspective including some of the bumps we experienced along the way of extracting 1,213,318 documents, generating 1,123,318 Excel files, generating links for 39,384 attachments and generating 91,236 PDF files!