Support Forum

[Frage] Reading an Excel and can't convert the coordinates to 3D points [Gelöst]

Schlagworte:
  • Allplan
  • Visual Script
MAppelman
MAppelman
17.03.2022 - 07:42

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?

Anhänge (2)

img
Visual scripting list to 3D points.png
Typ: image/png
222-mal heruntergeladen
Größe: 113,27 KiB
Video_list to 3D points.mp4
Typ: video/mp4
874-mal heruntergeladen
Größe: 3,46 MiB

Lösung anzeigen Lösung verbergen

Xinling
Xinling
17.03.2022 - 08:16 *

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 API, Allplan GmbH

Xinling
Xinling
17.03.2022 - 08:16 * [Lösung]

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 API, Allplan GmbH

Horst_Hohmann
Horst_Hohm…
17.03.2022 - 08:24

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

MAppelman
MAppelman
17.03.2022 - 08:44

Zitiert von: 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!

MAppelman
MAppelman
17.03.2022 - 08:45

Zitiert von: 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!

Daniele_Abramo_Pinto
Daniele_Ab…
04.08.2022 - 12:36

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