How to parse Excel info into Revit's schedule project parameters

FAQ
1

Hi, I have 3 custom sheet index schedule project parameters. They are “discipline, phase and series parameters.” These are essential when it comes to sorting sheets and I would like to be able to control the info in excel and push the data to Revit’s schedule.

I’ve got the sheet index and sheet name working but can’t seem to find a way to push the data to “schedule project parameters.”

I don’t think those have element IDs to begin with…
Any ideas? Please help.

2

You need to export the sheets Guid and the parameter you mentioned to excel. Then import them in Revit with another graph.

Please post what you have so far so we can have a look.

3

5.JPG1178×928 307 KB

Hi, this is my ultimate goal. I want to control sheet index order by 3 custom project parameters.
I would like to control the order in Excel but no matter what, I can’t make it happen.

I know BIMlink can do it so there got to be a way in Dynamo…

4

1.JPG772×613 58.6 KB

So, as a start, I got it set up like above as step #1.

5

2.JPG783×619 76.4 KB

My excel has 5 columns, so I divided them up with code block.

Fed sheet number and name to “readymade” node. Here, I’ve tried to define my custom project parameter insdie the “create.placeholder.sheet” node but no success.

6

3.JPG937×605 68 KB

So, I took the alternative route. Searched the category in Revit and made sure;

  1. parametername matches
  2. the value from a[0] is pulled into "element.set.parameterbyname,

What am I missing?!?

Please help.

7

@robertkang26

If you want to create placeholder sheets, refer to the below post.

Once the placeholder sheets are created, push the data back with Element.SetParameterByName.

I’m having problems uploading images.

Download the images from the link below:

https://1drv.ms/u/s!AjD2jKUSZk_2gkLWIoveq4kv29VI

8

Oh wow! Thank you so much! Seems high-tech to me. This is going to take a little bit of research on my end to catch up to your solution.

Thank you again!
-Robert.

9

OK. I followed what you did. 1 more quick question please although may sound dumb. (I’m a noob.)

How do I control “A - J” via Excel? Currently, A-J are controlled by the code block, not by the values from the same spread sheet. Is that correct?

Thanks much.
Regards,

Robert.

10

@robertkang26

I think you have already covered that part.

Read the excel spreadsheet and separate the data as you did (x[0], x[1],…etc.).

Be sure you feed the correct data type (string).

11

OK. Thank you again. Very glad to know the guru is around!

12

@robertkang26

Not a problem :slight_smile:

I wish I was the guru! :grin:

Download the image below if you want to create the placeholder sheets and push the data to Revit in one go:

https://1drv.ms/u/s!AjD2jKUSZk_2gkN8zbMlouL7ymLC