I managed to export my space information to excel where i inputted my space types. I am now trying to import this information back into the Revit model to populate the different space types (based on OOTB revit space types). For some reason my script doesn’t seem to work for anything but the space number and space name. Does anyone have any tips? [inputs] [List%20Creation] [Populate%20parameters]

I think I have resolved this for you. Please find the attached files for your use. The main reason your import graph wasn’t working was because you weren’t selecting the spaces to apply the Space Type too. CDL-Spaces Information Export.dyn (43.3 KB) CDL-Spaces Information Import.dyn (40.7 KB) Project1.rvt (3.6 MB)

I tried all of what you suggested except the if node. How does that work to get IDs? Sorry I’m still a real novice at Dynamo but I’m trying to learn as much as I can

Something like this should work for you. Just plug the info from excel in where I have the “Active Storage” node. [spacetype]

This worked perfectly for getting all my space type element IDs. I added these to my excel sheet and tried bringing them into my original script to populate the space type parameters in my model but i am still getting an error [error3]

It looks like it may be looking for the actual Space Type (green highlighted piece) and not JUST the integer. Take the “Element.Id” node off the end of what I posted and see if that works for you.

nope that didn’t work either. I feel like i’ve not got the correct ID for the different Space Types built into Revit. From the class material at AU they seem to have IDs of 1 or 2 digits but this small snip of the excel is my only clue to how they populated the space type parameter. I have no clue what dynamo script they wrote or how they pathed the excel into it so i’m basically flying blind on the principle that if they can do it then there must be a way to automate the process! [error4]

It looks like they figured it out here. Have you tried this way? [image] Access and Assign Custom Space Types in Revit 2018 Packages Perfect! I was really over thinking it. That’s a much cleaner solution than I was anticipating. Thanks! Just to complete the thought for anyone that may read this in the future, here’s a snip of the proof of concept. From here, it will just take some list management to turn this into a useful graph. [Space Type proof of concept]

@SeanP yep that works, it changes every space type to whichever index i type into the code block. I need to figure out how to adapt that so we can have it change to mulitple different space types depending on the rooms purpose. I will try again tomorrow i guess!

That’s good. If you go back to my Post #15, you only need to connect your Excel data (space type) to where I have the code block with "Active Storage in it. Maybe if you would share the .dyn and a test Excel / rvt file we could help you string it all together. I think you are very close.

@SeanP sure I can upload the dyn scripts tomorrow (I’ve left my laptop in the office) and the revit file is just a blank template with the sample arch file linked in. The spaces are then copied in using rushforth tools. Thanks for helping me out :slight_smile:

Ok so i’m attaching a link to the blank spreadsheet template and the completed spreadsheet from the model export. The export script and the import script which obviously needs work before it can populate the space types! Space Information.xlsx (13.7 KB) Space Information (completed).xlsx (18.6 KB)CDL-Spaces Information Export.dyn (40.4 KB) CDL-Spaces Information Import.dyn (44.4 KB) @SeanP

Importing Space Type Parameter from Excel

Revit

SeanP November 22, 2018, 7:03pm 20

It looks like they figured it out here. Have you tried this way?

Topic		Replies	Views
Storage Type is ElementID - how do i get a list of these ID's? Revit revit , excel , dynamo	7	1358	November 22, 2018
Import Excel Data ; error :The storage type of the parameter is not a number Revit revit , excel	4	771	March 2, 2022
The parameter's storage type is not a string. (Import Excel) Revit excel , dynamo	7	334	June 10, 2021
Getting space type Revit excel , energyanalysis , dynamo	4	1285	April 27, 2018
Script to Overwrite parameters of select Revit Spaces Revit revit , mep , excel , dynamo	13	1271	June 11, 2021

Importing Space Type Parameter from Excel

Related topics