Formstorm

Description

Formstorm is the OCR software used to scan Surveys and convert them to a csv format for import into the ukrdc. The software is server based and hosted on a windows survey rr-OCR-live. Development of the scanning template is usually done by our supplier Richard Oldershaw (richard.oldershaw@cmssoft.co.uk) at CMS Software Ltd. More details for the configuration can be found in the Infrastructure space /wiki/spaces/INFRA/pages/948306129.

The current configuration tries to ensure we correctly create the demographics by looking for the NHS number in the renalreg database during validation of the scan. If there is a match then the data from the match is used and verified with the written scan. This helps to prevent incorrect NHS numbers being associated. Not all survey people are on our database in which case the operator needs to take more care to ensure the key demographics (NHS Number, Name, DOB, Postcode, Hospital code) are correctly ocr-ed. The output from formstorm creates a csv file and pdf (of the scan) in the R:\PROMS\Scans folder on rr-storage-live and inaddition saves a copy of the data to rr-sql-live in YHS2018 database. 

The csv files are uploaded to the UKRDC to /data/surveys/in where they are converted to RDA and loaded. If the patient is on Patientview the survey is sent through to Patientview. If the file fails to load and throws an error a desktop (64bit) error correction app has been developed which queries the mirth server for the error details. The data is then corrected (in the sql database) ad a new csv created with the correct data and reloaded to mirth. 

A separate report program is used to generate report spreadsheets for the different units.