Jump to content
  • 0
rowbear97

Worksheet Automation

Question

I'm working on a worksheet that has to pull data from existing parametric objects and various records attached to smart objects like borders and site models. I've been able to create a cells that pull information such as project name and project address from the Titleblock Manager yet I can't seem to crack the code on pulling the "Site Model" Cut, Fill, Net C&F Volumes. Any help in this matter would be greatly appreciated.

 

Thanks in advance for your time and consideration!

Share this post


Link to post

2 answers to this question

Recommended Posts

  • 0
Parameter Fields for PIO: DTM6		
		
Display Name			Field Type	
__version				'DTM6'.'__version'						Integer
__UUID					'DTM6'.'__UUID'							Text
__messageID				'DTM6'.'__messageID'					Integer
2D Display				'DTM6'.'2D Display'						Text - Popup Menu Item
2D Style				'DTM6'.'2D Style'						Text - Popup Menu Item
3D Display				'DTM6'.'3D Display'						Text - Popup Menu Item
3D Style				'DTM6'.'3D Style'						Text - Popup Menu Item
Area Display Type		'DTM6'.'Area Display Type'				Text - Popup Menu Item
Projected Area			'DTM6'.'Projected Area (Existing)'		Static Text
Surface Area (Existing)	'DTM6'.'Surface Area (Existing)'		Static Text
Surface Area (Proposed)	'DTM6'.'Surface Area (Proposed)'		Static Text
Volume Display Type		'DTM6'.'Volume Display Type'			Text - Popup Menu Item
Volume (Existing)		'DTM6'.'Volume (Existing)'				Static Text
Volume (Proposed)		'DTM6'.'Volume (Proposed)'				Static Text
Cut Volume				'DTM6'.'Cut Volume'						Static Text
Fill Volume				'DTM6'.'Fill Volume'					Static Text
Net C&&F Volume			'DTM6'.'Net C&F Volume'					Static Text
Total C&&F Volume		'DTM6'.'Total C&F Volume'				Static Text
Total C&&F Volume		'DTM6'.'dontShowErrors'					Boolean
Total C&&F Volume		'DTM6'.'Site Model Name'				Static Text
Modifier Conflict Count	'DTM6'.'Error Count'					Static Text
Show Modifier Conflicts	'DTM6'.'Show Errors'					Boolean
Geometry Lowest Z		'DTM6'.'Geometry Zref'					Real - Coordinate Displacement

Note that all of the field are static text (probably with the unit marks included) so you will not be able to use them for calculation directly. You will need to strip the units and convert to a number to do calculations.

 

Sorry for the bad formatting.

 

 

  • Like 2

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×