Hi, I have created a list of points in excel and brought them into dynamo and am trying to create a series of points from them. I have gotten them chopped up into three lists of x coordinates, y coordinates, and z coordinates. However, I can not figure out how to convert these lists into points. I tried to use them as the inputs to a point by coordinate node but that did not work. I need dynamo to somehow recognize them as coordinates. I am very new to dynamo so sorry if this is something simple.
You will find a few other posts on a similar topic- such as http://dynamobim.org/forums/topic/huge-tree-table-in-excel-how-can-i-get-this-into-revit/
Vikram (aka ‘Lord of the Lists’) transpose & code block nodes are a more elegant way of splitting up the data columns than the example in that post
Andrew
This might be a “very old” post but I was wondering why when I try exactly the same script I don’t get a list of points after Point.ByCoordinates… Any help, please? Is it because Dynamo changed?
I have a table with 4 columns in Excel. The first, I would like to become annotations in C3D and the others are X,Y and Z.
I would like to import them from Excel and place them in C3D.
Vary basic, but I am crawling in Dynamo…
Many thank sin advance for any help!
PS1: I am tagging you @Vikram_Subbaiah because you seem to know what to do. Apologies for disturbing…
PS2: @Andrew_Hannell, the link does not exist… (Error 404 - Page not found / Oops! That page can’t be found.)
the forum was upgraded (or migrated to a new platform?) ages ago & old post were transferred across
I thought the old links still worked but maybe not.
If you search you will find the post, with a different URL
Huge tree table in Excel, how can I get this into Revit - Packages - Dynamo (dynamobim.com)
Refer to the second to last post from me- someone else had the same problem with attachments dropping off
Do you get the exact same list structure until then?
You’ll need to share your files/screenshots for us to provide a solution to your problem.
Thank you, @Vikram_Subbaiah!
There you go:
Block not available:
.
.
Replaced by:
.
.
Error:
.
.
.
The only way out for me was to use COGO Points - which leads to other problems so not really a solution…
Many thanks again!
PS:
Strangely, this “change” worked today, although I cannot see the points in C3D’s Model Space yet.
Dynamo Test - Import Points from Excel - Vikram’s version.dyn (18.7 KB)