BOM and Drawing Dimensions Data Extraction

Problem:

Manually extracting and processing data from PDFs containing Bill of Materials (BOM) tables and drawing dimensions is labor-intensive and prone to errors. An automated solution is required to streamline this process, allowing users to efficiently extract and search data.

Solutions:

We developed a Gradio app with five tabs that streamline the extraction and management of BOM and drawing dimensions data. The "Table Extraction'' tab allows users to upload PDFs containing table data, which the app processes and displays as dataframes. The "Drawing Data Extraction" tab enables users to upload PDFs with drawings, extracting and returning maximum length, maximum diameter, and minimum diameter of the drawings. The "Combine" tab merges the functionalities of both table and drawing data extraction, processing and displaying both types of data from uploaded PDFs. The "Table Data Search" tab fetches and displays all table data from the database upon loading, allowing users to search for specific data using PDF file names. Similarly, the "Drawing Data Search" tab fetches and displays all drawing data from the database and provides search functionality by PDF file name. This comprehensive approach ensures efficient, accurate, and user-friendly extraction and management of BOM and drawing dimensions data, significantly reducing manual effort and improving productivity.