Happy Hump Day!
I’ve been busy creating Dynamo scripts to create and implement Key Schedules with success! However, now I need to distribute them to my team using Dynamo Player…so I’m adding user inputs to select the excel file to import into a Revit Key Schedule. The script works if you select the file from Dynamo directly but the UI input file isn’t. The dialog box comes up correctly and it seems the file is coming through but the data is not showing up in Revit.
Any advise would be most appreciated!
I’ve attached an image of my script, the way the data is supposed to look, and the revit schedule that the script creates.
Door Key Styles.pdf (57.3 KB)
Revit.pdf (587.5 KB)
Your graph is illegible. Make sure the node titles are visible when you export your workspace and include any error dialogs that you’re getting.
It looks like you’re having an issue reading the file. What does the error say?
My apologies regarding the titles not showing…
After I read your reply I went back to my scripts that do not have the UI and they aren’t working now either. You’re correct, it is having trouble reading the file…that it didn’t have yesterday.
The error reads: Data.ImportExcel operation failed
I swapped the excel node and all is well now!!!
Thank you @Nick_Boyts for your quick response.
Ah. Now you can see that the original node was asking for the filePath when you were providing a file. That’s the only issue.
I did have the file from path node in there before I swapped out the excel node. The new excel node didn’t need it. Maybe the data.import node just isn’t working. Weird because it did yesterday!
1 Like
I missed that. My bad. You can always “pull out” the contents of the custom node and test it in your graph to get any errors. Either way, glad you got it worked out.
That’s a good thought. Thanks!!
