The client is a well-established oleoresin extraction company and a renowned producer of value-added spices.

The client set up a lab to conduct quality checks at various intervals and stages of the production process. The test results had to be stored in their ERP system against the corresponding batch or serial numbers of various products. Given that the test results are to be provided on demand to customers as reports, they wanted to do away with the manual inputting of results from the enterprise content management (ECM) software to their ERP. The client hence wanted an application that would digitally extract data from the ECM software and place it in a folder in a predefined format to be picked up by the ERP system.

CCS helped the client automate the extraction of the Quality Management (QM) reports from the ECM software with an application built on .NET. The app uses an API to communicate with the ECM software and extract data. The extracted data will be moved to the target folder as a spreadsheet/CSV in specific formats, readable by the ERP system. The application will ensure that there is no duplication in the extraction of data. It will log the extraction process for review purposes and to spot exceptions.