Revision on Sheet Property

[steven.caneris]

Hi all,

I am looking to get the Current Revision property from a sheet. Not the sequence number but the revision on sheet number.

For example sequence 1 might be alphanumeric in which case the revision on sheet would be “A”.

Or, the sheet might have skipped sequence 1 but has sequence 2, in which case it would still be “A”

Does anyone know how to achieve this?

Thank you

Steve

[salvatoredragotta]

@steven.caneris

Look at this post .Does it help?

All Revisions per sheet written to Excel

Hi Salvatore, I am trying to extract all the sheets from the project and then I want to see all the revisions that are assigned to each sheet, so the output should show the sheet name and number and then list all revisions (whether they be from revision clouds or from the “Revision on Sheet” function), I want to see ALL revisions assigned to each sheet and the revisions will show their sequence number the date of the revision and the description of the revision. Something like this… Sheet Numb…

[steven.caneris]

Thanks @salvatoredragotta but i don’t think that’s what i am after.

Because we use Per Sheet revisions exclusively having the revision sequence number doesn’t really help too much as it doesn’t match the revision number on the sheet.

I have the output and list stuff all sorted its just the revision number as it is on the sheet that is stumping me.

[salvatoredragotta]

@steven.caneris Post your .dyn please

[steven.caneris]

Dont mind my inefficient and messy definition -

Revision Export.dyn (50.2 KB)

Edit - Re-uploaded. i noticed an error

[steven.caneris]

and here is the current output -

The issue is Sheet 15 for example should be revision numbers 1,2,3,4 not 2,3,4,5

[salvatoredragotta]

@steven.caneris Do you have a dummy Revit File?

[steven.caneris]

Revision Export Test.rvt (1.3 MB)

Here is a quick dummy project in Revit 2017

[salvatoredragotta]

@steven.caneris Thanks

So If I understand correctly, when you get to this part of your program you want to restart the sequence from 1?

[steven.caneris]

@salvatoredragotta Yes that is correct

or “A” if the sequence is alphanumeric.

[salvatoredragotta]

@steven.caneris You’ll need to manage that list of lists in order to achieve what you want.

What have you tried so far?

The following could be one possible way

1. Check each list; if first element is "1" or "A" get the list as it is
2. if first element is not `“1” or “A”, re-sequence the list
3. otherwise find last location of “-” and check if next index is `“1” or “A” .
   3.a if so, get the list
   3.b if not, re-sequence the list

But I think you’ll have sheets with Numeric and alphanumeric sequences which makes things a bit more complicated.

[steven.caneris]

@salvatoredragotta yeah i thought as much.

We have pretty much hit the limit of my logic skills at this point, which is why i was trying to get the Revision on Sheet parameter directly.

I also tried it with the code block but I’m not sure how if/and works. My idea was the first boolean list shows if there was that sequence on the sheet, and the next is whether it was numeric or alphanumeric. But I’m stumped. It gets complicated quickly. The bottom code/watch shows the desired output.

here is a dummy definition -
if and test.dyn (3.7 KB)

[steven.caneris]

Ok so i have it working for 1 sheet. I just have to sort out the lacing i guess for it to do all sheets (and remove the first item nodes). And then re-set up the formatting and output etc.

Ill work on it tomorrow and hopefully finish it.

The replace multiple at index workflow comes from this thread - http://dynamobim.org/forums/topic/inserting-elements-in-specific-indices/

if and test.dyn (48.9 KB)

[steven.caneris]

@salvatoredragotta Im hoping you can help me figuring out the lacing to get this to work for multiple sheets (boolean lists)

I have the green group set up for one list and the pink for two but cant figure it out. any help would be greatly appreciated

Replace multiple at index.dyn (30.8 KB)

[steven.caneris]

Ok so i figured it out. i was missing an extra transpose and list map.

Here is the finished definition if anyone is interested.

It will take all sheet revisions and export an xls file to My Documents. It works for Per Sheet revisions with the correct revision on sheet number and works for both Numeric and Alphanumeric and even switching between the two. It also skips sheets with no revision.

Its a little messy with possible redundancies, but it works Revision Export.dyn (107.1 KB)

[salvatoredragotta]

@steven.caneris Well done!.

[kscalvin]

Hi Steven,

I have followed your script, however, not really sure where to get the “List.MatchLength” custom code…

that affecting the List transpose.

any chance to point me out where can I find it?

many thanks

[steven.caneris]

Hi @kscalvin

I hope this script works out for you. the List.MatchLength node comed from the Landform package.

Let me know if you have any other dramas.

[kscalvin]

Continuing the discussion from Revision on Sheet Property:

thanks Steven,

got it, but seem also can’t find the other one called “Insert at Index sc’”.

just wondering where should I get this?

thanks again.

[steven.caneris]

Hey Calvin,

that comes from this post - http://dynamobim.org/forums/topic/inserting-elements-in-specific-indices/ from Dimitar’s great work in the second to last post. i just recreated that loop1 function there.

Good luck!

Steve