Previously, the process involved manually copying and pasting data from the PDF files into Excel spreadsheets, which were maintained for tracking purposes. Due to the frequent generation of these files, the team encountered difficulties in completing reports and submitting them on time. Additionally, human errors occasionally occurred during this manual process.
To address this challenge, we conducted a thorough analysis of the PDF format and developed an algorithm capable of extracting and organizing the duty and material data from these files. The extracted data is then stored in a structured manner within a database. This data serves as the foundation for generating various custom reports required by the logistics and finance departments.
Furthermore, the work cells within the organization require access to this data to monitor their material consumption. To facilitate this, we implemented a trigger that notifies them when the quantity of a material group falls below 25%, prompting them to request a bond renewal with customs. Moreover, the approved material group part quantity is automatically updated upon uploading the contracts completed with customs.