Dynamo is like the 8th wonder of the planet but, for newbies like me, it can also be hell.
I have a table of points in Excel with 4 columns (“name”, X, Y and Z). For some of these points, Z=0 (simply because Z is, “at the moment”, unknown).
I wish to:
Place these points in C3D’s Model Space;
Create a separate list with the points for which Z is not 0 (Z<>0). From this list, I want to make Z=0 (I call these “clone points”) and also have them placed in C3D’s Model Space;
Create lines connecting the “clone points” to their counterparts (these will be vertical lines from 0 to whatever the original elevation of the points are);
Place the labels at a fixed distance from the points in C3D’s Model Space (say, X’ = X + 0.2 and Y’ = Y + 0.2, units = metres); and, finally
Change the colour of the groups of points and of the lines separatelly.
If you know a bit of Dynamo, this could be pathetic but, for me, it is a nightmare.
I already did some bits with help from @zachri.jensen but there is still some distance to cover.
Would you mind mind renaming some of your posts to be more descriptive of what problem they are trying to solve? The intent of the forum is to not only help yourself, but to also provide a resource for others in the future for others facing the same problem. Folks are likely not going to search for something called “Dynamo for Dummies”, but they might find it if it was called “Creating Lines from Points in Excel” or something like that.
I’d also check your excel file. See the one I have attached. Your numbers should be set as numbers not strings and you should add a header so a dictionary can be used and the excel import can be a bit more verbose.
@WrightEngineering, thank you again for your help - but… would you know what to do when you get an error such as “Warning: Node ‘DSOffice.Data.OpenXMLImportExcel’ cannot be resolved.” (besides sitting in a corner and crying?).
I have “standard” C3D 2021 in the machine I am using. IT could not manage to install Dynamo for C3D 2022.
Dynamo License
Those portions created by Ian are provided with the following copyright:
Copyright 2017 Ian Keough
Those portions created by Autodesk employees are provided with the following copyright:
Copyright 2019 Autodesk, Inc.
Licensed under the Apache License, Version 2.0 (the “License”); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an “AS IS” BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
LIBG, ProtoGeometry, Analytics.NET, ADP, DynamoRaaS, GRegRevitAuth, AGET are closed source files licensed by Autodesk under the license that can be found here Dynamo/Autodesk.rtf at master · DynamoDS/Dynamo · GitHub
Instrumentation
Dynamo now contains an instrumentation system. This anonymously reports usage data to the Dynamo team that will be used to enhance the usability the product. Aggregated summaries of the data will be shared back with the Dynamo community.
An example of the data communicated is:
“DateTime: 2013-08-22 19:17:21, AppIdent: Dynamo, Tag: Heartbeat-Uptime-s, Data: MTMxMjQxLjY3MzAyMDg=, Priority: Info, SessionID: 3fd39f21-1c3f-4cf3-8cdd-f46ca5dde636, UserID: 2ac95f29-a912-49a8-8fb5-e2d287683d94”
The Data is Base64 encoded. For example, the data field above (‘MTMxMjQxLjY3MzAyMDg=’) decodes to: ‘131241.6730208’ This represents the number of seconds that the instance of Dynamo has been running.
The UserID is randomly generated when the application is first run. The SessionID is randomly generated each time Dynamo is opened.
Yeah. That node isnt in your version of dynamo. Just use the other excel import node. Its just that you need excel installed to use the other original excel node so i tend to use open xml import.
