Is it possible to export Ideas parts list data to excel?
Is it possible to export Ideas parts list data to excel?
(OP)
Greetings:
I have a dozen Idea drawing with a parts list on it and have been asked to create a new part list using excel instead. Is there a way to export Idea parts list data to a format that can be read by or import to Excel?
Any help is greatly appreciated.
Frank.
I have a dozen Idea drawing with a parts list on it and have been asked to create a new part list using excel instead. Is there a way to export Idea parts list data to a format that can be read by or import to Excel?
Any help is greatly appreciated.
Frank.





RE: Is it possible to export Ideas parts list data to excel?
If you are wanting all of your parts and sub assemblies in an excel list please follow.
Go to Master Assembly Click on BILL of Materials first set of boxes first row third box down.
Set all of your preference of what you want in this box. Play with this. This will give you different results if want suppressed parts or what have ya. Then hit ok here
Then you see the list of your parts in the assembly. You can modify this box if you go to format. There is all kinds of options there. For example sorting and different attribute you can add to the colums and or remove.
Once you are happy hit the Print button
Then print to file clicked on
File type delimited
Then in options put > in for the delimiter
This will export out a RPT file
Then open the RPT file in Excel
Excel will walk you through the import. While going through the Excel import please use > for the delimiter so you get everything in correct colums.
Thanks Please ask if this is not clear.
RE: Is it possible to export Ideas parts list data to excel?
Anway, I will request access to these Idea's master file to find out more. Since I don't have any experience in Idea's (I am Pro/E, Solidwork, SolidEdge, Unigraphics, AutoCAD user), is there a way to know if the parts list is auto bom or 2D text? Judging from the provided PDF files, the parts list looks like 2D text (I hope that I am wrong). If this is the case, I am thinking of exporting Idea's drawings to Autocad dwg then convert the table from AutoCAD to Excel. What do you think of this approach?
Your time and help is greatly appreciated.
RE: Is it possible to export Ideas parts list data to excel?
The way you know if it is auto generated if you go to modify it and it brings up the modify bom options then you will know.
RE: Is it possible to export Ideas parts list data to excel?
I would really appreciate if you can send me the LSP file along with the example to mcad.jgfrank@gmail.com.
RE: Is it possible to export Ideas parts list data to excel?