Allplan Forum: Reading an Excel and can't convert the coordinates to 3D points

Das Wissen aller Anwender nutzen

Im Allplan Connect Forum tauschen sich Anwender aus, geben wertvolle Tipps oder beraten sich bei ganz konkreten Aufgabenstellungen − auch international.
Und damit wirklich keine Frage unbeantwortet bleibt, unterstützen die Mitarbeiter des Technischen Supports ebenfalls aktiv das Forum.

Es erwarten Sie:

Foren-Vielfalt aus CAD Architektur, CAD Ingenieurbau uvm.
Tipps von User für User
international: Deutsch, Englisch, Italienisch, Französisch und Tschechisch

Melden Sie sich jetzt an und diskutieren Sie mit!

Zur Registrierung

Forum
CAD Parametric Modelling
Visual Scripting

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

Schlagworte:

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)

Typ: image/png

212-mal heruntergeladen

Größe: 113,27 KiB

Video_list to 3D points.mp4

Typ: video/mp4

534-mal heruntergeladen

Größe: 3,46 MiB

Lösung anzeigen Lösung verbergen

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_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

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

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_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

« Zurück