AutoCAD Plant 3D General DIscussion

AutoCAD Plant 3D General DIscussion

167 Posts
43 Kudos
Registered: ‎10-06-2010
Post 1 of 4

MTO from a drawing including Xref's

967 Views, 3 Replies
11-09-2012 04:41 PM

I need to extract an MTO into Excel from a piping assembly containing only xref’s.

We create area drawings containing only xref's of the pipe models in that area to be used in Navisworks.
In Cadworx I could create a MTO by opening this piping assembly and extracting the information, this included pipe sizes, lengths, weights, line numbers, drawing numbers, basically any information on the pipe could be extracted very easily. This was then brought into Excel for manipulation by the engineering and purchasing departments. This worked very well and we did not have to worry about erroneous drawings been listed in the database, as it only extracted from the current assembly file.

I know I can use the report on the project data but I want to extract only the information from the xref’s attached in the assembly file. Can this be done?


*Expert Elite*
739 Posts
143 Kudos
Registered: ‎12-04-2009
Post 2 of 4

MTO from a drawing including Xref's

11-09-2012 06:28 PM in reply to: PatrickByrne

Is there a reason you can't just select the drawings you want to include in the report creator?  You don't have to use the whole project data.  Other than the report creator and data manager, there is no export functionality.

Dave Wolfe
Isaiah 57:15

ECAD, Inc.
Tips and Tricks on our blog: Process Design, from the Outside

A P3D Authorized Reseller
Plant 3d Wish list:
167 Posts
43 Kudos
Registered: ‎10-06-2010
Post 3 of 4

Re: MTO from a drawing including Xref's

11-09-2012 07:04 PM in reply to: dave.wolfe

That's probably what I will have to do, but it was such a simple operation in CadWorx.

We will be dealing with over 400 pipe models, the piping assembly only contains current models whereas the database will probably contain everything, including different piping options and models that have been removed from the assembly but still in the project.

All I need is for all the information contained in Xref’s to be made available in the data manager, I can then do a quick export to excel.

Valued Mentor
526 Posts
65 Kudos
Registered: ‎08-19-2008
Post 4 of 4

Re: MTO from a drawing including Xref's

11-14-2012 07:29 PM in reply to: PatrickByrne

Hi Patrick,


As Dave has indicated the best way to do this would be with the report creator program, not the reports inside the data manager. Theres a bit of settup to do but once done, it should do what your talking about.

I would also like this type of functionality within the Data Manager, I dont see why the data manager could be setup to pull through the xrefed data, especially if they are attached and not overlays.

I see you have added it to the wishlist already, (Ive kudos'ed it to give it a bit more weight).

Having said that, IMO its not good practice to have files 'in the project' that are eroneous. You do not have to delete the files, just remove them from the project browser, they will still be on your hardrive and can be added very easily should those design options replace the one that you have been using. Then you may be able to run your data manager in 'Order by Area' to get the simple export options you require.





CAD Management 101:
You can do it your own way,
If its done just how I say!
[Metallica:And Justice For All:1988]
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Plant 3D Category!

The AutoCAD Plant 3D forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!