topic Re: Get SS Custom Property in VBA Forum

Get SS Custom Property

lee_pellegrin5UBS5 — Wed, 06 Dec 2023 16:42:38 GMT

Good morning Mr. Ed,

I would like to know if there is any possibility that I could pull in a custom property from a sheet set that is comma delimited through a diesel expression? I figured out how to do it through $(getvar), but the value does not change when I update the property.

Re: Get SS Custom Property

Ed__Jobe — Wed, 06 Dec 2023 16:46:01 GMT

When you change the subject, please start a new thread. I moved this to a new thread for you.

What do you mean 'pull in'? What do you want the end result to be? A field?

Re: Get SS Custom Property

lee_pellegrin5UBS5 — Wed, 06 Dec 2023 16:54:42 GMT

Yes sir,

I was digging into Diesel expressions yesterday (I have no experience) and I would like to be able to use fields to reference values within a property.

I am thinking about test 1,test 2,test 3.test 4 and being able to enter 4 separate cells within a table. My end goal is to have a dynamic block across multiple drawings that I could pull info into that coordinates with our BOM.

Re: Get SS Custom Property

Ed__Jobe — Wed, 06 Dec 2023 17:05:58 GMT

You can enter fields into a table. You don't need any code for that. I'm still not certain I understand your 'system'. Where is the BOM, part of the sheet set? Is it a table? Describe all the parts you need and how they interact. Fields in a dynamic block may not update well.

Re: Get SS Custom Property

lee_pellegrin5UBS5 — Wed, 06 Dec 2023 17:09:25 GMT

This is what I trying to achieve.

Re: Get SS Custom Property

Ed__Jobe — Wed, 06 Dec 2023 17:17:47 GMT

That's a nice picture, but it still leaves a lot of questions. I don't see how that relates to a bill of materials. You can use code to extract the values, but it won't update like a field. You will have to re-extract the data again. You could do it on some event, like when the dwg loads. Some AutoCAD toolsets have built in BOM handling, e.g. acad mech. Why don't you use that?

Re: Get SS Custom Property

lee_pellegrin5UBS5 — Wed, 06 Dec 2023 17:24:06 GMT

This is one of 4 schedules that we use: They are also referenced via manually typing in each sheet within the titleblock. I am trying to find a solution to place all of this in the sheet set manager for everything to be automatic.

Re: Get SS Custom Property

lee_pellegrin5UBS5 — Wed, 06 Dec 2023 17:27:25 GMT

Could I use Index and Getvar in a diesel expression to pull and separate the data?

Re: Get SS Custom Property

Ed__Jobe — Wed, 06 Dec 2023 17:28:06 GMT

That functionality is built into aec software like Revit and AutoCAD Architecture. Are you using one of those or plain AutoCAD? If the latter, you can use data extraction to count blocks.

Re: Get SS Custom Property

Ed__Jobe — Wed, 06 Dec 2023 17:34:27 GMT

@lee_pellegrin5UBS5 wrote:

Could I use Index and Getvar in a diesel expression to pull and separate the data?

Before you start working on details, its best to plan a strategy first. I rarely use diesel. Programming is so much more powerful. Ideally, you should just be able to place a BOM and have it be complete and updateable.

Re: Get SS Custom Property

lee_pellegrin5UBS5 — Wed, 06 Dec 2023 17:51:54 GMT

Mr. Ed,

Here is my concept, our job are large and they span across several dwg's. On our cover series, which is one dwg, we list out 4 separate schedules: Hardware, Appliances, Finishes, and Tops that contain all of the details. On the other documents we reference to the cover series for those details:

At this point everything is manually typed in and a very error prone way of doing this. We are using sheet sets and custom sheet set properties. I would like to have one SSM custom property that I could pull pieces of data from in order to use a dynamic block per page that will only pull in what is needed and enter in only in the sheet set manager.

To add, I am going to have all of my values display in the area that is on the side of the page so that all drafters will be able to select what is needed.

Re: Get SS Custom Property

lee_pellegrin5UBS5 — Wed, 06 Dec 2023 18:00:58 GMT

I did not add that we are not using a AEC version of software. We are using Microvellum which does not have VBA or Autolisp capabilities.

Re: Get SS Custom Property

Ed__Jobe — Wed, 06 Dec 2023 18:18:44 GMT

Is Microvellum an addin for AutoCAD or a standalone program?

Re: Get SS Custom Property

lee_pellegrin5UBS5 — Wed, 06 Dec 2023 20:46:34 GMT

There is OEM Microvellum and the add on. We have the OEM version.

Re: Get SS Custom Property

lee_pellegrin5UBS5 — Thu, 07 Dec 2023 15:08:27 GMT

Standalone

Re: Get SS Custom Property

pendean — Fri, 08 Dec 2023 21:08:41 GMT

@lee_pellegrin5UBS5 wrote:

...We are using Microvellum which does not have VBA or Autolisp capabilities....

...Standalone

OEM software support need to come from the OEM developer that sold you their variant: an OEM variant can be hobbled, crippled, and tools added or taken away in any way shape or form that the OEM developer chooses. You'll almost never find a solution outside of that OEM Developer's support.

These Autodesk forums are not ever going to be of assistance with your chosen software.

Seek out what you need for help over there

https://community.microvellum.com/portal/en/community/

https://www.microvellum.com/contact

https://community.microvellum.com/portal/en/home