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

[Frage] Reports - how to Export all allplan attributes in only one xlsx file

Schlagworte:
  • Allplan 2020
  • Reports
EiPM_Xavi
EiPM_Xavi
08.06.2020 - 05:56

Hi all,

With reports export to xlsx, we are trying to export all allplan attributes from element, but it seems to be limited to around of 100 attributes as maximum.

Is it possible to export more than this value, in order to perform an export of all allplan attributes of the elements? Allplan have around 2000-3000 attributes available, and we would like to export all them.

Thanks a lot!
Xavier Coll
EiPM

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

1 - 10 (13)
Usr
Usr
08.06.2020 - 07:56

The Plugin Model-Inspector can export Attributes directly to Excel-file without limitations. You don't need to define a report for this.

Nemo
Nemo
08.06.2020 - 09:03

I could not find a limitation of the number of attributes in the Excel output. I have used the default report "General Object Attributes.rdlc" .

EiPM_Xavi
EiPM_Xavi
08.06.2020 - 09:09

Zitiert von: Usr
The Plugin Model-Inspector can export Attributes directly to Excel-file without limitations. You don't need to define a report for this.

Thanks USR for your response!

Mmmm... interesting. Report tool can export very interesting internal attributes of every element, for example: IFC_ID , Clear_height , Center_of_gravity_X and so on...

If I choose an element, for example a column with attributes by default, Report extract around 148 attributes.. some of them very useful.

Can "Model-Inspector" export all the attributes of an element, like report tool does?

Thanks a lot!
Xavier Coll
EiPM

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

EiPM_Xavi
EiPM_Xavi
08.06.2020 - 09:20 *

Zitiert von: Nemo
I could not find a limitation of the number of attributes in the Excel output. I have used the default report "General Object Attributes.rdlc" .

Hi Nemo! thanks also for your answer!

Well, I just checked it:
- A report with 99 attributes -> Report can export it.
- A Report with more than 99 attributes -> Report can not export it, and it shows a dialog box (see image 001.png)

Xavier Coll

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

Anhänge (1)

img
report_alert_limit.png
Typ: image/png
6-mal heruntergeladen
Größe: 4,17 KiB
Nemo
Nemo
08.06.2020 - 09:22 *

As I Wrote: Do not use a self defined report for this!
Use the predefined Report "Allgemeine Objektattribute.rdlc"!

You Wrote:
"...Report extract around 148 attributes..."

148 is greater than 100 I think!
Where is the Problem?

MartinSy
MartinSy
08.06.2020 - 09:44

Hi Nemo,

I think Xavier wants to have all available Attributes reported t oone Excel file.

@ Xavi: I think you need to create a dummy object, and attach all available attributes to it.
Is this what you were looking for?

Greets, Martin

i7 - Win10 - 24GB - ATI FirePro W8100 * Allplan 2023/24 (+Vorläufer) Ing./Workgroup * Allplan user seit V 5

EiPM_Xavi
EiPM_Xavi
08.06.2020 - 09:44 *

Zitiert von: Nemo
As I Wrote: Do not use a self defined report for this!
Use the predefined Report "Allgemeine Objektattribute.rdlc"!
You Wrote:
"...Report extract around 148 attributes..."
148 is greater than 100 I think!
Where is the Problem?

Hi Nemo, and thank you very much for taking time to answer me :-D

Well, "Allgemeine Objektattribute.rdlc" is a very interesting report, but it only export some attributes of the elements (I think that only export the visible attributes of the Allplan "Attributes" tool). For example, for columns, "Allgemeine Objektattribute.rdlc" only can export 14 attributes. But I just discover, that it seems that there are around 148 attributes for columns.

Well, I explain how I create an excel with more than 99 attributes:
- I created 20 rdlc files. In every file, I configurate it to export 99 atributes.
- After I ended all the process of export those 20 rdlc files, I joined all them in only one excel, in order to analyse wich attributes are more useful for our data management (we work in projects that needs a lot of data, and the data management is very important).

And then, In order to be more effective, I would like to do an agile process, for example, export from only one RDLC all attributes from Allplan elements...

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

EiPM_Xavi
EiPM_Xavi
08.06.2020 - 09:48 *

Zitiert von: MartinSy
Hi Nemo,
I think Xavier wants to have all available Attributes reported t oone Excel file.
@ Xavi: I think you need to create a dummy object, and attach all available attributes to it.
Is this what you were looking for?
Greets, Martin

Thanks MartinSy for your answer!

Yes, I would like to export all attributes of Allplan in only one excel (all, the 2000-3000 attributes), in order to review for every type of object, which attributes and values have.

In my test, It's not necessary to add attributes to any elements. Allplan elements have attributes that are not showed with "Attribute" tool, but they can be listed with Report tool.

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

Nemo
Nemo
08.06.2020 - 10:09 *

..if you want to have all attributes (unfiltered), then have a look at ModelInspector.

But caution:
Not all attributes are intended to be read by user.
Some are used internally by Allplan and are not intended for external use or modification!
So be carefull writing back modified attributes!

If you want to do it with report:
Try multiple selects...

1 - 10 (13)