topic Re: Formula Property Definition using Object Data in Civil 3D Customization Forum

Formula Property Definition using Object Data

dwattersAMXH5 — Wed, 27 Jun 2018 14:49:03 GMT

hello,

I am looking to pull OD into a VBA for Formula Property Definition

this is what i was trying to use - "fqn_id" being the field to pull OD records from

RESULT="--"
ON ERROR RESUME NEXT 

Dim ODrcs As ODRecords
Set amap = ThisDrawing.Application.GetInterfaceObject("AutoCADMap.Application")
Set ODrcs = amap.Projects.Item(ThisDrawing).ODTables.Item("FQN_ID").GetODRecords 

RESULT= ODrcs

but that doesn't work

i have loads of data stored in PLines from GIS Files brought in with MapImport and we need to get that data to the Property Set so we can use it with Civil3d labels and tables

any advice on this would be greatly appreciated!

Re: Formula Property Definition using Object Data

Anonymous — Mon, 27 Aug 2018 20:03:52 GMT

I am also curious about this. Is there a formula that will take object data field to a property set field? I am kind of in the same situation as the OP above.

Thanks for any insight...

Re: Formula Property Definition using Object Data

dwattersAMXH5 — Mon, 27 Aug 2018 20:07:26 GMT

this is possible, though i dont know the exact for how.
but with using C# a program can be made to do it as both sets of data are accessible by .net
you would need to know some about computer programming or find a programmer who can learn enough about CAD to do it.

i found also though that Object Data can be accessed by lisp routines and i ended up creating a few lisps to make mleaders with the data i want out of the object data tables, then another lisp to recreate the mleader if you change the info in the object data table.

Re: Formula Property Definition using Object Data

Anonymous — Mon, 27 Aug 2018 20:26:31 GMT

Interesting. So with Lisp routines are you still getting that data from the MLeader into the property set definitions that are attached back into the polylines?

Re: Formula Property Definition using Object Data

dwattersAMXH5 — Mon, 27 Aug 2018 20:29:41 GMT

no, i only wanted them in property set data to create labels with (wanted to use label templates in civil3d) but with the mleaders pulling the data and being able to set up the mleader how i want it, the lisp solves my problem. but i cant use civil3d tables this way.

Re: Formula Property Definition using Object Data

norman.yuan — Tue, 28 Aug 2018 14:07:36 GMT

Object Data and PropertySet data are 2 different mechanisms to attaching atribute data to entities, as you know. While PropertySet supports Formula property, OD does not.

I assume your interest is in situation like: entities have OD data attached; you also have PropertSet defined in the drawing, with some formula property, or properties; then you want to attach the propertyset to entities and the formula property would take data from OD data as the formula input.

I'd say this would be doable, if you know how to access PropertySet and OD. AFAIK, there is no COM API support to access PropertySet data (I am not 100% sure, though), you probably cannot do it via VBA. If you have experience with AutoCAD/Map/Civil3D .NET APIs, you should be able to do it. There are previous discussions on this top with @dwattersAMXH5 involved that may give you more information:

https://forums.autodesk.com/t5/visual-basic-customization/pulling-object-data-and-writing-property-set-data/td-p/8094815?_ga=2.202476881.1703295511.1535461835-1675936738.1531567670

https://forums.autodesk.com/t5/civil-3d-customization/property-sets-lt-gt-object-data-sonverter/m-p/8062357#M14984