[Pregunta] Reading an Excel and can't convert the coordinates to 3D points [Guardado]

Etiquetas:

I have a question.

I try to use visual scripting to read an Excel with coordinates and then convert them as 3D points. I managed to read an excel and separate the x, y and z coordinates from this, but as soon as I assign the node 3D points after this I get no output. Even when I use the multiplication node this gives no output. In the excel the numbers are values, so you would say that visual scripting should read the number as values as well.

Can someone tell me why I don't get any output when I add 3 lists of x y and z to a node of 3D points?

Adjuntos (2)

Type: image/png
Descargado 212 veces
Size: 113,27 KiB
Type: video/mp4
Descargado 514 veces
Size: 3,46 MiB

Show solution Hide solution

Maybe, it is because all values imported from an Excel file currently will be interpreted as String by the node TableToList. Please try to convert the value to Double or Length. Right now, We have 2 options to do that:

  • use the node TableColumn, which has a built-in support to convert datatypes.
  • use the node ConvertDatatype, which can convert String to Double. After that, you may still need to multiply the value with a unit length (e.g. 1m) to get the Length value

Product Owner – Visual Scripting, Allplan GmbH

Maybe, it is because all values imported from an Excel file currently will be interpreted as String by the node TableToList. Please try to convert the value to Double or Length. Right now, We have 2 options to do that:

  • use the node TableColumn, which has a built-in support to convert datatypes.
  • use the node ConvertDatatype, which can convert String to Double. After that, you may still need to multiply the value with a unit length (e.g. 1m) to get the Length value

Product Owner – Visual Scripting, Allplan GmbH

Hello,

which Allplan version do you use?

In Allplan 2022-0-7 we have the example ColumnPlacementFromFile (located in StructuralFraming\Objects), which shows a simple usage of extracting data from a table and creating 3D points.

Best regards
Horst

Cita de: Xinling
Maybe, it is because all values imported from an Excel file currently will be interpreted as String by the node TableToList. Please try to convert the value to Double or Length. Right now, We have 2 options to do that:

use the node TableColumn, which has a built-in support to convert datatypes.
use the node ConvertDatatype, which can convert String to Double. After that, you may still need to multiply the value with a unit length (e.g. 1m) to get the Length value

Thank you, it is working now!

Cita de: Horst_Hohmann
Hello,
which Allplan version do you use?
In Allplan 2022-0-7 we have the example ColumnPlacementFromFile (located in StructuralFraming\Objects), which shows a simple usage of extracting data from a table and creating 3D points.
Best regards

Horst

Thank you for your reaction. I will look at the example also!

Hi, I'm having the same issue and I solved usingthe ConvertDatatype solutione because the TableColumn is not working for me, and converts data only in "string" type


https://campus.allplan.com/ utiliza cookies  -  Aqui

Acéptalo