Writing values to parameter from Excel-file

Revit
1

Hello I am trying to write information from an Excel-file to specifick elements. I have tried to use both GUID and BatID as identifier. I think the problem is in the ElementById-node or in the Element:SetParameterByName. The unconected nodes laying around are ones I have tried without sucsess. Anybody who can see a solution?

Pasted image1379×885 321 KB

This script is a critical part of my exam which has to be finished before monday afternoon, any help will be much appreciated!

This is a link to a Dropboxfoleder where you can find a test model, the script, and the Excel-files needed:

Thanks

Leif

2

This is the error Im getting:

3

Have you updated the Archi-lab package? The Id to element-node seems to be working on my end:

4

And also, the link provided is for another folder completely I guess. (Altså Cv’n din+ prosjektoppgave. :wink: )

1 Like
5

Hei Leif!

It’s most likely the id to element that’s your problem, if Josteins suggestion doesn’t work you can try this:

Pasted image731×567 53.2 KB 

import clr
clr.AddReference('RevitAPI')
from Autodesk.Revit.DB import *

clr.AddReference('RevitNodes')
import Revit
clr.ImportExtensions(Revit.Elements)

clr.AddReference('RevitServices')
import RevitServices
from RevitServices.Persistence import DocumentManager

doc = DocumentManager.Instance.CurrentDBDocument
items = IN[0]

elementlist = list()
for item in items:
	elid = ElementId(item)
	elementlist.append(doc.GetElement(elid).ToDSType(True))

OUT = elementlist
6

Thanx, i have changed the content in the folder. Will try your solution in a minute

7

I have tried Josteisn fix, updated the package. At least I get somthing out of the node:

Pasted image721×503 90.4 KB

Einars solution:

I dont know what I have done wrong, I copy/pasted the code and added "at the start and end of the code

Thanx for trying. I will get back to the problem tomorrow, maybe a good nights sleep will help :slight_smile:

8

You need to add a ; (semicolon) after the last " in the code block. Also make sure your ids are integers.

Pasted image1080×728 127 KB

1 Like
9

The String.ToNumber node solved the problem. Thanx a lot!

Leif