Hi,
So I have some coordinates that I have placed in Excel (x, y, and z ), these coordinates will put into place a family that has been created in Revit into a project. There are loads of these parts that need to be placed hence why there is a table with information in excel. I have tried following a tutorial that was actually made for Civil 3D and later found out that those nodes are not available for Revit. My goal is to place a family instance into a project and being able to use an excel sheet to identify where each instance needs to go x , y, z coordinates wise, which would eliminate any human errors, if say I would be manually placing the family individually. So I have been on a journey trying to figure a few of these nodes out but they do not work for me. I think this is due partly because I am a beginner. If you have any advice, please let me know, would highly appreciate any input
Below is an example of one of the scripts I have tried but have failed
Also I was thinking the best way to do that is by creating a path script but either the script has error and won’t fully run like the screenshot in the original post or it won’t run at all
Is that why it doesn’t want to work ? I am currently trying to place some existing columns so I have to use an accurate World Coordinate System, which means that I can’t simplify that into a two integer number. Based on that is there a different node that I can use that would be compatible?
Really hard to know what’s going on without seeing the node outputs. Please make sure you pin all the node preview bubbles when sharing a screenshot. Otherwise we have no clue what your data actually looks like. I’m guessing your initial issue is with the list structure coming from excel. You either want to Transpose your data or set your GetItemAtIndex nodes to use the appropriate list levels.
Hi, I have done that, it still doesn’t work still, however there was a pop up that told me to change my Geometry Scaling, which I am seeing that as a step forward
Its really bhard to say…isnt that not geometry scalling ? PS be sure you clean up so only the numbers go into the point.by.coordinates…guess if you share that excel sheet, we can find a solution…or it is only guessing
Your values are strings now numbers, so you will need to convert them with a String.ToNumber node.
You need to remove the first two rows of data before attempting to create geometry as those are headers - the integer input into the List.DropItems node after the excel node needs to be a 2, not a 0.
