Hi all, I found what looks like the solution to this, but its on a very old thread and i cant access the files. I have a similar issue i cannot figure out.
I have a .csv file with all of my IFC enumerations (Column A), it then lists certain project specific information for each value on that row. I have a Revit model which has all of the IFC enumerations applied to it. I would like to import the excel file, and get the relevant info from that, then get the IFC info from the Revit model, and if the IFC enumeration matches the database > populate the other parameters within Revit (taken from the excel file). Its just the mapping/matching of the two datasets im struggling with. See attached definition where i am at (along with example revit file and excel database im using). Any help would be appreciated. Its Revit 2022
Thanks for this, yes, id prefer the Excel inport also, but its not currently working for me as my Office 365 needs updated/reinstalled and our I.T are very slow at these things xD So have to stick with .csv for now. I replaced the commas with stops for testing as i hadnt noticed. However, i cant seem to get it to work as expected. It is only pushing one value into all the walls in a random order:
See attached script im using and the updated database (I had to convert back to .xlsx so i can upload it here) - Its just the same as your script but with the csv node instead of excel. Im likely done something incorrect so apologies xD IFC mapping.xlsx (10.2 KB) CombineData (1).dyn (25.3 KB)
Thanks, but unfortunately its still not behaving. My “Dictionary.ValueAtKey” does seem to be different to yours (it matches when i set lacing to shortest?). When i run it it does not add the parameter values into the model correctly. I really appreciate the help on this.
My last image was when I forced it to find a value because I was not using your model at the time. So, what you image show should be correct and looks like it is finding the value. What does the output on the SetParameter node look like?
Hi Sean, so i got it to work (or so i thought) by setting the last node to cross-product lacing and adding a couple of filters into the script. See the updated version attached. Thank you very much for your help on this so far, much appreciated!
It works if the elements all have the same values, but if i have multiple types with different values per type in the database it will just put the same value into each type. Any insight to this?
Ive attached an updated database and model (The script can be run on Roofs and Walls categories)