The job consist of extracting data and drawing from a catalog in pdf format into an excel files and jpg/png files.
First extract the drawings from the pdf into jpg or png format with software such as Adobe Acrobat Pro or Gimp (free software).
Then convert the same pdf into excel files with software such as Abbyy finereader.
Restructure the Excel files with a defined structure (see attached : "excel files conversion").
Each reference should be attach to the corresponding assembly/header and each assembly/header should have the corresponding name of drawing.
Please not that the catalog include 280 pages (images and data).