Case study: Workorder parsing

Our client, the company “Setup Systems” from Kragujevac, is the largest subcontractor of the leading cable company SBB, receiving workorders (approximately 15,000 per month) as individual e-mails with data contained in the attached PDF document. In order to be able to process them, it is necessary that the client data (name, address, description of works, installed equipment, scheduled intervention time …) be in tabular form, which would require several more dedicated workplaces just to retype them from received orders .

A Java application has been developed for the client, which constantly scans the inbox and downloads all received PDF workorders to a folder on the server, searches for their contents and extracts the necessary data from them, and then places them in the appropriate list on SharePoint Online.