Read information from a spreadsheet and assign Revit parameter value to the correct object

[Andrew_Hannell]

The use of dictionaries is covered in various posts, but in a round-about way. The below explains it as simply as possible:
Notes:

• elementID used to match up objects, not GUID
• the spreadsheet contains a record without a matching model element & vice versa

The database option is covered here:

Using SQLite instead of Excel

I have been experimenting with SQLite with Dynamo recently & thought I would share with the group. SQLite is a pretty good & simple option compared to MSSQL or MSAccess. The main benefit as I see it is the data can be well structured & also allows simultaneous reads & writes (plus simple in a standalone file) A significant number of posts on this forum relate to Excel & I think many could be overcome. But I have to admit that the main benefit of Excel is that everyone knows how to use it…! …

Organize an excel register and input into specific parameter fields in model (excel order and parameter order not consistent)

this is how you would do it with the database lookup ~600 records with 38 parameters should not be a problem [image] [20180727%20sqlite%20lookup%20write%20parameter] [image] Mechanical Equipment.sqlite.txt (138 KB)