Get value of bottom half area of a circular split balloon using ilogic/vba

[Anonymous]

I am working to create an excel comparison report of all balloons and their split quantities and compare them to the total qty in the parts list for each item. Does anyone know how to pull the value of the split bottom area of a split circular balloon using ilogic or vba? I am able to do everything except get the split bottom area value.

[johnsonshiue]

Hi! The number of the bottom half of a balloon should be a property. It can be retrieved like any iProperty. What is the property you there. If you cannot figure it out, please share an example here so forum experts can help take a look.

Many thanks!

[Anonymous]

We use a "custom property" which was add using "New Property" in the Property Chooser in the Balloon style library. The QTY property was added there and then displayed in the Balloon Formatting\Property Display window as shown in the screen clip, below:

Taking that this is considered a "Property" value, how would I use a syntax like the one for iproperties in ilogic to pull the QTY value from the split balloon bottom half after I identify the balloon?

MyValue= iProperties.Value("Project", "Part Number")

[Anonymous]

Just to make sure that you understand that the QTY property value we use in the bottom of split balloons is  NOT the QTY in the parts list or the model BOM. This QTY property is manually entered. Thus the need to create  a report of them and compare their totals to the parts list total for each component.

[Anonymous]

Attached is a zip file containing Packngo of a sample. Unzip, add TEST1.ipj as the project and open "WORKSPACE\TEST.zip\TEST\Workspaces\Workspace\workspace\TEST1.dwg"

[torbjorn_heglum1]

I have tried to get access to the bottom half of the balloon in VBA without success. 

The picture below shows what is accessible in a split balloon with one value in the upper half and another in the lower half. There is only one item in the BalloonValueSets, the item number.

So I suppose there are no direct access to the lower value, at least not in IV 2019 as I am using. 

Torbjørn

[johnsonshiue]

Hi Raj,

I see what you are trying to do now. You try to capture the overridden item number, right? The overridden numbers are stored in the drawing, not yet back to the assembly.

Is there a reason why you don't want to save the overrides back to the assembly?

Many thanks!

[Anonymous]

You are correct. I am trying to get over ridden values. To explain: If item #1 has total quantity of 20 in the parts list and assembly, we may mount these items in 4 different locations in our product which can be 60 feet long. We then create 4 detail views of the four separate areas and then add split balloons to each detail view and tag the balloon to item #1 in each view. Then we over ride the split balloon QTY value. If equally distributed in the 4 views, we would over ride the QTY to show 5 in each split balloon for item #1.

Now do this over and over again for 20 items and it becomes a mistake prone process. Later when drawings are reviewed, it take hours to review the balloons. Our drawings are never 100% correct. I want to go to 100% correct balloons using automated reporting for items whose totals in the split balloons do not match the part list total or assembly total.

We cannot push these over rides back to the assembly for this reason.

[Anonymous]

Hi Johnson,

After further review, I discovered that the Split Balloon bottom half value is tied to the Parts List QTY property. However, when we override the QTY value and manually enter another value, we do not push this value back to the parts list. In the parts list, we show the actual assembly total value for each part. 

So, where is the override value of the QTY stored? Especially if we have more than one balloon for each item. It must be stored somewhere within the balloon structure and retained. There must be a way to access each balloon and the stored value of QTY override. Meaning that each balloon occurrence in the drawing sheet must have a unique identifying signature and the value for the QTY field must be stored within that identifying signature. 

Somewhere within the Autodesk design team, they must have this answer. They have definitely and intentionally allowed this functionality so there must be a way to get to it.

Raj

[Anonymous]

Digging further, I found this link which talks about how to check to see where the Properties and Style object is set to. Apparently for the Parts List's QTY value in the split balloon, it is set to "PartsListProperty='45572').

https://adndevblog.typepad.com/manufacturing/2014/03/change-balloon-property-display.html

Now perhaps someone can help me finding the code to read the stored value of the "PartsListProperty='45572'".

Raj