Sheet Information Mismatch

solamour · January 22, 2015, 11:03am

Kia Ora, So I’m a complete Dynamo newbie but am testing the waters and have a problem I believe can be solved with Dynamo. Here’s the issue: 1) We have a whole series of sheets that we’re imported from an Excel sheet. 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) 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 of view is a no-go contractually. As such, I want to do the following in Dynamo but my knowledge of what to search for and node names is very limited. a) Query all of the OOTB Revit Sheet Name and Sheet Number parameter information present in model project browser. b) Query all of our Actual Sheet Name and Actual Sheet Number information on our sheets. c) List where there is a mismatch. d) Apply Actual information into the OOTB parameters where there is said mismatch. Sounds simple in my head but I need a little help with finding the right nodes to use…

This is how far I have got at present:

My problem being that the Orange box shows the available drop-down parameter values from Get Family Parameter - which returns a null value.

The Blue box shows my Element.Parameters 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. #

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

Dynamo_Script_Progression_01

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

Any thoughts?

Sol

solamour · January 22, 2015, 11:12am

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:

We have a whole series of sheets that we’ve imported from an Excel sheet.
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)
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.
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.

Query all of the OOTB Revit Sheet Name and Sheet Number parameter information present in the model browser (DONE!)
Query all of our Actual Sheet Name and Actual Sheet Number information on our sheets (They are Shared Parameters nested into the Titlesheet family)
List where there is a mismatch
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

Peter_Kompolschek · January 22, 2015, 11:53am

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

Konrad_K_Sobon · January 22, 2015, 12:30pm

Have you seen this:

http://archi-lab.net/?p=249

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.

solamour · January 23, 2015, 2:18am

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

Peter_Kompolschek · January 23, 2015, 5:47am

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

solamour · January 23, 2015, 8:50am

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.

Peter_Kompolschek · January 23, 2015, 9:27am

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

solamour · January 23, 2015, 6:02pm

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

solamour · January 24, 2015, 5:33am

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

Dynamo_Success_2

Dynamo_Success_3

Peter_Kompolschek · January 24, 2015, 6:03am

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

i just updated my GetTypeParameter.FrmFamilyInstance

it works now for strings too.

viewparmas

Chris_LEGIADRE · April 29, 2015, 2:42pm

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?

Mark_Thorley · April 30, 2015, 4:07am

SheetFilter Chris this should do as you wish.

Chris_LEGIADRE · May 22, 2015, 2:16pm

Mark,

What node is that after element.getparametervaluebyname?

Thanks,

solamour · May 25, 2015, 2:46am

It’s the == node, found under Operators

Topic		Replies	Views
Cutting solids created in Dynamo Packages	0	465	April 13, 2015
Wall Export to Spreadsheet Packages	2	321	September 30, 2015
Help! Sheets creation_Excel to Revit Packages	8	865	June 7, 2015
Export Information from conceptual mass to excel Packages	0	293	July 26, 2015
How to modify using excel the length of an structural beam? Packages	0	190	May 10, 2015

Sheet Information Mismatch

Related topics