Sheet Information Mismatch


#1

<span style=“color: #2e2e2e;”>Kia Ora,</span><br style=“color: #2e2e2e;” /><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>So I’m a complete Dynamo newbie but am testing the waters and have a problem I believe can be solved with Dynamo.</span><br style=“color: #2e2e2e;” /><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>Here’s the issue:</span><br style=“color: #2e2e2e;” /><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>1) We have a whole series of sheets that we’re imported from an Excel sheet.</span><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>2) The information from said sheet has subsequently changed - so the Model has to follow suit (Too dangerous to reuse our importer… don’t ask it’s painful)</span><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>3) We’ve been prescribed by the client a Template that doesn’t link the Project Browser information to our Sheet information (</span><b style=“color: #2e2e2e;”>Sheet Number</b><span style=“color: #2e2e2e;”> to the Drawing number nor the </span><b style=“color: #2e2e2e;”>Sheet Name</b><span style=“color: #2e2e2e;”> to our Sheet Name). We have a mismatch now. </span><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>4) Fixing said issue from a template point of view is a no-go contractually.</span><br style=“color: #2e2e2e;” /><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>As such, I want to do the following in Dynamo but my knowledge of what to search for and node names is very limited.</span><br style=“color: #2e2e2e;” /><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>a) Query all of the OOTB Revit </span><b style=“color: #2e2e2e;”>Sheet Name </b><span style=“color: #2e2e2e;”>and </span><b style=“color: #2e2e2e;”>Sheet Number </b><span style=“color: #2e2e2e;”>​parameter information present in model project browser.</span><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>b) Query all of our </span><b style=“color: #2e2e2e;”>Actual Sheet Name</b><span style=“color: #2e2e2e;”> and </span><b style=“color: #2e2e2e;”>Actual Sheet Number</b><span style=“color: #2e2e2e;”> information on our sheets.</span><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>c) List where there is a mismatch.</span><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>d) Apply</span><b style=“color: #2e2e2e;”> Actual</b><span style=“color: #2e2e2e;”> information into the OOTB parameters where there is said mismatch.</span><br style=“color: #2e2e2e;” /><br style=“color: #2e2e2e;” /><span style=“color: #2e2e2e;”>Sounds simple in my head but I need a little help with finding the right nodes to use…</span>

This is how far I have got at present:

My problem being that t<span style=“color: #2e2e2e;”>he </span><b style=“color: #2e2e2e;”><span style=“color: #ffa500;”>Orange </span></b><span style=“color: #2e2e2e;”>box shows the available drop-down parameter values from </span><b style=“color: #2e2e2e;”>Get Family Parameter</b><span style=“color: #2e2e2e;”> - which returns a null value.</span>

<span style=“color: #2e2e2e;”>The </span><span style=“color: #0000ff;”><b>Blue</b></span><span style=“color: #2e2e2e;”> box shows my </span><b style=“color: #2e2e2e;”>Element.Parameters</b><span style=“color: #2e2e2e;”> which is only picking up on the Type parameters of the family rather than the nested lables that make up the Titlesheet’s name, number etc. #</span>

<span style=“color: #2e2e2e;”>Effectively I need a way to pull out my nested, Shared Parameters from the Titlesheet family. Any thoughts?</span>

Dynamo_Script_Progression_01

<br style=“color: #2e2e2e;” />
 

 

 

 

 

I’ve just been following my nose and the odd bit of tutorial magic that I’ve found.

Any thoughts?

Sol


#2

NOTE: I’ve somehow broken my post, here it is again in full. I can’t seem to be able to edit it.

Kia Ora,

So I’m a complete Dynamo newbie but am testing the waters and have a problem I believe can be solved (with relative ease) in Dyanmo.

Here’s the issue:

  1. We have a whole series of sheets that we’ve imported from an Excel sheet.
  2. The infomration from said sheet has subsequently changed - so the Model has to follow suit (too dangerous to reuse our importer… Don’t ask it’s painful)
  3. We’ve been prescribed by the client a Template that doesn’t link the Project Browser information to our Sheet Information (Sheet Number to the Drawing Number nor the Sheet Name to our Sheet Name). We have a mismatch now.
  4. Fixing said issue from a template point is a no-go contractually.

As such, I want to do the following in Dynamo by my knowledge of what to search for (In particular node names and what they do) is very limited.

  1. Query all of the OOTB Revit Sheet Name and Sheet Number parameter information present in the model browser (DONE!)
  2. Query all of our Actual Sheet Name and Actual Sheet Number information on our sheets (They are Shared Parameters nested into the Titlesheet family)
  3. List where there is a mismatch
  4. Apply the Sheet based parameter information back to the OOTB Project Browser Sheet parameters.

Sounds simple in my head but I need a little help finding the right nodes to use.

Attached is an image of where I have got to at present:

The Orange Box shows the available drop-down parameter values form Get Family Parameter - which returns a null value.

Th Blue Box shows my Element.Properties which is only picking up on the Type parameters of the family rather than the nested lables that make up the Titlesheets name, number etc.

Effectively I need a way to pull out my nested, Shared Parameters from the Titlesheet family. Any thoughts?

Cheers,

Sol

 

Dynamo_Script_Progression_01


#3

use “GetTypeParameter.FrmFamilyInstance” this is a custom node.

 


#4

Have you seen this:

or this:

updating sheets from Excel is a breeze so before i would go with some elaborate parameter swapping i would give that a look.


#5

Going to check that node out Peter! I’m still getting my head around what node does what so had yet to delve into Custom nodes.

Have browsed your website Konrad but not read it in depth. I’ll have a look at the two links you posted.

Thanks for the replies gentlemen.

EDIT: Checked out the node, but as I’m running 0.7 it doesn’t appear to work unless I’m not doing it right. However, I’m still waiting on my Companies IT team to get the next release of Dynamo so that could be it.

 

 

Dynamo_Script_Progression_02

 

 

 

 

 

 

 


#6

Sol Amour

you have a type mismatch by wiring a “type” as "instance.

try like this:

The parameter has to be a type parameter!!!

type


#7

Ah, so if my ‘Shared Parameter’ is in fact an Instance rather than a Type, this node won’t work?

The simple “Categories” node doesn’t exist in my version of Dynamo - Still trying to get the next release through corporate IT.


#8

Sol Amour, as you are dealing with instances, try following:

the “categories” and “all elements of category” are core nodes and you will find them in every dynamo release.

view


#9

I’ve recreated this problem at home to play with over the weekend.

Following your advice Peter, I can reference the Titlesheet lables such as ‘Drawn By’ and ‘Checked By’ (OOTB Revit System Lables). That was a huge help so thank you kindly.

It appears I cannot, however, reference user created Shared Parameters. Example below. I’m probably missing something rather obvious though! I’ll keep hunting.

 

Dynamo_Sheet_Problem_1


#10

And I have it sorted! Turned out my problem was trying to reference a Titleblock when in fact I needed to reference the Shared Parameter in the Project associated with the ‘Sheets’ category.

Many thanks to all who have helped me write my first, functional Dynamo expression :smiley:

Dynamo_Success_1

Dynamo_Success_2

Dynamo_Success_3


#11

Sol Amour, thats good news. just got ready with an example you will not nedd any more :wink:

i just updated my GetTypeParameter.FrmFamilyInstance

it works now for strings too.

viewparmas


#12

I admit, I am still getting into Dynamo, so this may be pretty simple.

Let’ say I want to filter our certain sheets from the full list, because they were drawn by other people. How you would recommend doing this? I imagine I could use a filter of some kind correct?


#13

SheetFilterChris this should do as you wish.


#14

Mark,

What node is that after element.getparametervaluebyname?

Thanks,


#15

It’s the == node, found under Operators :slight_smile: