Converting Pro E Bills of Materials into Excel Files

[designguru007]

I would like to convert bills of materials from Pro E files into Excel format, but I do not have the Intralink - would anyone know of another way of doing this?

Cheers

 

[davidinindy]

Select table in Pro-E, go to table tab, save table, as csv (comma delimited).
Open in Excel, and check the box "fields seperated by commas" or something similar. Un-check the "seperated by tabs" box.
I've done this a few times, and I'm sure if you play around with it, you'll find what I'm talking about,

David

 

[score33]

I use the following method:

From an assembly file, pick 'Info/Bill of Materials.' Pro/e will ask you to set a few options and will then create your BOM.

then if you have the 'info_output_format' config option set to text, you'll see a new text file in your working dir with a text output of your complete bom.

you can also format the bom any way you wish by setting the 'bom_format' config option and editing the file that it points to.

 

[cadcamguy]

dg7
another way

http://inversionconsulting.blogspot.com/2008/04/weblink-sending-data-from-proengineer.html

but you need to

http://www.proefaq.com/?page_id=199

score.. I'd like to know more about the .fmt file

 

[marcmettes]

I was inspired by this discussion to post an example on how to send assembly BOM data directly into Excel from Pro/ENGINEER using Pro/WebLink.

You can see it here:

http://inversionconsulting.blogspot.com/2008/04/proweblink-sending-your-proengineer.html

--
Marc Mettes
Inversion Consulting

http://inversionconsulting.blogspot.com

 

[cadcamguy]

thank you Marc for putting up the example