ISO Drawing BOM Export

[SpecPVF_]

Hi there,

Does anyone know of a program that will export a bill of material from a PDF ISO drawing into excel?

Thanks!

 

[dik]

can you drag a mouse over the BOM and have the individual words highlighted... if so, you may be able to just 'cut and paste'. If you highlight a part of page, then, you may be able to print the area and OCR the data and modify the text data to csv or something to convert to a table and then paste into excel.

Dik

 

[SpecPVF_]

Thanks. What I am running into, is that we are getting a packages of 100+ ISOs. So manually doing it can be very time consuming. Just hoping there is a program that can extract and export.

 

[dik]

Are they CAD files and can you just cut and paste from cad to excel? I assume you have tried it. It may be possible to write a *.lsp routine that can extract the data.

Dik

 

[SpecPVF_]

Unfortunately, they are PDF files only, we have not been able to get any of the actual CAD files.

 

[dik]

Can you post a *.pdf copy as you have received it and I'll check to see if my pdf2dwg converter can extract the *.dwg file? If the *.pdf was created from the original cad file, the data can easily be extracted.

Dik

 

[DGrayPPD]

Did the supplier not provide a final MTO? Normally, the final MTO would be extracted from the 3D model into an excel file, and be provided to the Client with the rest of the package.

 

[XL83NL]

As DGrayPPD mentioned is how we normally do it; provide ISO's on pdf, and (using an SQL query to export the Plant3D database to excel) an excel BOM export, which is the excerpt for all welded items on the ISO's.

 

[Gator]

It's important to include in the contract that the client owns the data, not just the printed deliverables.

This sounds like a case of an inherited project where the original designer kept the "source files" (or whatever you'd call them in this case) so as to encourage more work from the client.