All cases
Quality & compliancePharma
RPA

Every batch report is read, sorted and renamed consistently – without anyone having to open it

How a pharmaceutical manufacturer automatically classifies, renames and files batch reports – without anyone searching through up to 100 pages to find two key identifiers.

Customer anonymised
Starting point

Batch reports arrive in a shared folder as dense, multi-page PDFs. To file one, a person had to open it, read through up to 100 pages of tables and structured fields, and find two identifiers – a batch ID and a batch number – that appear nowhere in the file name. Only then could the document be classified into one of two categories, renamed and moved. The problem was not complexity, but volume and repetition.

Solution

A robot monitors the folder and starts automatically whenever a new PDF arrives. It reads the content, determines the category based on specific fields and the original file name, extracts the batch ID through pattern recognition as well as the batch number, renames the file according to a standardized convention and stores it in the correct target folder. The original document is archived. At the end of each run the robot sends an email summary listing every processed document and its file paths.

Result
RobotHumanAI-assisted
Batch report uploaded to the folderCathegory agreedIndicators extractedFile renamed and filed in the target folderOriginal document archivedSummary email sent
Result
100
pages per report at most, read automatically
2
extracted identificators pro document
Automatic
classification, renaming and filing
Complete
traceability via the email summary

Do you have a similar process?

Tell us about your workflow, we’ll tell you honestly what can be automated.

Book an intro call