Hello, I am still a beginner with Dynamo and i was wondering if anyone can help me figure out what i am doing wrong to get this script to work. This Excel to Revit script was posted online by Brendan Cassidy. I have followed everything the manual says to check but it still gives me errors.
Can anybody tell me what i need to change to get the script to work please ?
Just been looking at your script here (not tried the very latest version yet) - the two things I’ve found that help resolve the errors with the sheet creation was the addition of boolean (true / false) node to the ‘readAsStrings’ input with this set to true. The other thing was to specifically set the view to be loaded onto the sheet to a drafting view - for some reason just about anything else seems to give me an error. Other than that seems to be working as expected. Just a few wee tweaks to make for my own requirements now.
Actually I still have a problem. The sheets are being created okay and the name and number are set correctly however the sheet parameters are only getting set on the first sheet created, noting of the others (see image).
The data itself seems to be fine it’s just not populating correctly - can’t for the life of me see why…
If your drawing list looks like the following then you are using the wrong dyn file because it just uses the last section of BS1192 for the sheet name and then you would get sheet name already in use. This will indicate you need the joiner version of the script.
To use the script you have highlight above then, you would need to have your register as follows.
Note: There is two scripts within the zip file to cover both situations and you will need to look at how you are implementing BS1192 prior to deciding which script to use.