Support Forum

[Frage] Scripting - Export CSV of Attributes and values from elements


Hi all,

How to do a visual scripting in order to perform an export to CSV of all attributes and values of elements?

Thanks a lot!
Xavier Coll
EiPM

Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/

Hilfreichste Antwort anzeigen Hilfreichste Antwort verbergen

@Horst:
Starting the above example scripts from the library palette fails!
The export to xml don't contain the types of values (csv cannot transport this information)
So at further processing you have to guess the values, like excel do it at reading a cvs! (see example_xml.png)
That' the reason why the direct xls-export in Allplan was years overdue!

Some general comments:
I would like to see the visual scripting in Allplan more oriented to the "original", e.g. Grashopper or Dynamo.
One very important point is that each node usually has only one output, because exactly one output data stream is generated from the input data streams. The Allplan approach with looped-through outputs unnecessarily complicates the visual graphics! The input capability at the outputs(!) is also not really meaningful! All this unfortunately makes working with VisualScripting not really intuitive! (see workspace.png)

A display node would be helpful for "debugging" the data streams.
For the "playful form-finding" slider-controls are also important in the palette! (see slider.png)

You can have a look at the complete source code of Dynamo at Github to search for meaningful nodes. In particular, Allplan still lacks important geometry nodes for facade design and DGM-modelling:
-subdivide planar and nurbs-surfaces
-projecting a point or curve onto a surface
-place elements along a curve or onto surface
-triangulation of surfaces
-meshing of points (voroni , delaunay with break lines)
-straight skeleton creation (Link) for roofs

The focus should be more on geometry creation!
Other functions, like reading or writing attributes, should be left in the Python API!
Something like this becomes very complicated in Visual-Scripting, because you have to handle with input states in the GUI!
A good example for this is PAUSE-Node used in the above described export-nodes! (without inserting this node, Allplan crashes!)
This node isn't existing in Grasshopper or Dynamo! The paradigma of visual scripting is evaluation of a data flow schema!
No states, no inputs and no loops during the flow! Only data flow, nothing else...!

The same applies to the try of create reinforcement with visual scripting!

Anhänge (3)

img
Workspace.png
Typ: image/png
28-mal heruntergeladen
Größe: 103,30 KiB
img
example_xml.png
Typ: image/png
18-mal heruntergeladen
Größe: 159,03 KiB
img
slider.png
Typ: image/png
21-mal heruntergeladen
Größe: 243,03 KiB
1 - 8 (8)
  • 1

For example, I would like to do a csv export like the image attached with this image.

Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/

Anhänge (1)

img
Snap2.png
Typ: image/png
21-mal heruntergeladen
Größe: 10,02 KiB

By now, I've only got some geometrical attributes...

Someone knows how to export attributes to CSV? maybe visual scripting still doesn't have enough nodes about attributes.

I upload my progression.

Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/

Anhänge (2)

img
Sample.png
Typ: image/png
34-mal heruntergeladen
Größe: 210,64 KiB
Typ: text/xml
73-mal heruntergeladen
Größe: 3,41 KiB

Hi Xavier,

are you able to Export from Excel to CSV?
In this case, you could firs Export from Allplan to Excel...

Anhänge (1)

img
001.JPG
Typ: image/jpeg
22-mal heruntergeladen
Größe: 39,19 KiB

Good morning minisci_kuk, and thanks for your answer!

We know "Export Attributes" tool, but we want to do some special processes in order to be more efficient,:
- Try to export several attributes
- Create new attributes, and add values from formulas (concatenate, or other)
- Export / Import attributes involves too much manual processes, and "visual scripting" can do them more automatically and efficient, we think.

The final scope for those processes is create a enriched IFC with data stored in Psets from client requirements.

Best regards,
Xavier Coll
EiPM

Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/

Hi Xavier,

in 2020-1-3 we have added VisualScripting nodes for the attribute export to cvs and xml files. Please have a look at the examples ExportAttributesToCSV and ExportAttributesToXML.

If you need more functionality, please let us know.

Best regards
Horst

Hi Horts and thanks for your answer!

Very interesting! We will check ExportAttributesToCSV and ExportAttributesToXML nodes.

Zitiert von: Horst_Hohmann
If you need more functionality, please let us know.

In our office, usually we use an other "Visual scripting" tool: Dynamo. With this tool, we have developed a lot of "visual scripts" for our projects. Our last BIM project it was develop a BIM infraestructure of 6.000 km of roads, for a local public administration, and it was developed in several complex Dynamo scripts. In this case, this project was around three keys: synthetic geometry (the roads are splitted every 10 meters), a huge of data, and we develope an interface of visualization and data management.

Then, we would like to do some similiar processes that we do in Dynamo, but with Allplan Visual Scripting. We are not interested only in modeling processes, also we are very interested around data management, and increase the quality of IFC data. In order to start to do it, we have some questions...

In Dynamo, there are two very simple nodes, but very powerful:
- Node "code block": it let to create a lot of simple things, for example, lists.
- Node "Watch": it shows a preview of the output list of a node, it's really very useful.

Are there a similar nodes in Allplan "Visual scripting"?
I upload and image of Dynamo, with those simple but super powerful nodes (and also the dyn file)

Thanks a lot!
Xavier Coll
EiPM

Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/

Anhänge (2)

img
Code_Block_and_Watch.png
Typ: image/png
25-mal heruntergeladen
Größe: 68,89 KiB
Typ: text/plain
26-mal heruntergeladen
Größe: 8,40 KiB

@Horst:
Starting the above example scripts from the library palette fails!
The export to xml don't contain the types of values (csv cannot transport this information)
So at further processing you have to guess the values, like excel do it at reading a cvs! (see example_xml.png)
That' the reason why the direct xls-export in Allplan was years overdue!

Some general comments:
I would like to see the visual scripting in Allplan more oriented to the "original", e.g. Grashopper or Dynamo.
One very important point is that each node usually has only one output, because exactly one output data stream is generated from the input data streams. The Allplan approach with looped-through outputs unnecessarily complicates the visual graphics! The input capability at the outputs(!) is also not really meaningful! All this unfortunately makes working with VisualScripting not really intuitive! (see workspace.png)

A display node would be helpful for "debugging" the data streams.
For the "playful form-finding" slider-controls are also important in the palette! (see slider.png)

You can have a look at the complete source code of Dynamo at Github to search for meaningful nodes. In particular, Allplan still lacks important geometry nodes for facade design and DGM-modelling:
-subdivide planar and nurbs-surfaces
-projecting a point or curve onto a surface
-place elements along a curve or onto surface
-triangulation of surfaces
-meshing of points (voroni , delaunay with break lines)
-straight skeleton creation (Link) for roofs

The focus should be more on geometry creation!
Other functions, like reading or writing attributes, should be left in the Python API!
Something like this becomes very complicated in Visual-Scripting, because you have to handle with input states in the GUI!
A good example for this is PAUSE-Node used in the above described export-nodes! (without inserting this node, Allplan crashes!)
This node isn't existing in Grasshopper or Dynamo! The paradigma of visual scripting is evaluation of a data flow schema!
No states, no inputs and no loops during the flow! Only data flow, nothing else...!

The same applies to the try of create reinforcement with visual scripting!

Anhänge (3)

img
Workspace.png
Typ: image/png
28-mal heruntergeladen
Größe: 103,30 KiB
img
example_xml.png
Typ: image/png
18-mal heruntergeladen
Größe: 159,03 KiB
img
slider.png
Typ: image/png
21-mal heruntergeladen
Größe: 243,03 KiB
1 - 8 (8)
  • 1

https://connect.allplan.com/ verwendet Cookies  -  Mehr Informationen

Akzeptieren