topic Re: Exporting Material properties to Excel - Python Script in Archicad Python API

Exporting Material properties to Excel - Python Script

Ssc_97 — Mon, 27 Dec 2021 14:36:58 GMT

Hello!

I just started couple of months ago finding my way with python in Archicad 24. I have some experience in python but definitely not enough as I keep having different problems with the export script (the one provided by Graphisoft).

With the basic script you can export Element properties very easily to an excel sheet. But as soon as I change the script to get a random material property, the script gives an error. The material property is randomly chosen after getting the full list with python as well. The last line has been added to get the 'Material Property'.

propertyUserIds = [ act.BuiltInPropertyUserId("General_ElementID"), act.BuiltInPropertyUserId("General_Height"), act.BuiltInPropertyUserId("General_Width"), act.BuiltInPropertyUserId("General_Thickness"), act.UserDefinedPropertyUserId([ "COMBUSTION (Materials)", "CO2 Content"]) ]

By running this in Archicad we get a lot of errors with the following errorcode as the last: "propertyId cannot be initialized with <class 'Archicad.releases.ac24.b3000types.ErrorItem'> "

Am I doing something wrong when changing the script or is export with python on the level of 'materials' not supported yet?

Re: Exporting Material properties to Excel - Python Script

Patrick M — Tue, 28 Dec 2021 22:52:35 GMT

IME, python is just a longhand work-around to make basic functions less effective... I'm sure the tool is useful, as I read enough people saying they use it for scripting template management, file migration, file maintenance functions. But it's beyond me why I should bother with python TBH

Re: Exporting Material properties to Excel - Python Script

Ssc_97 — Thu, 30 Dec 2021 16:17:00 GMT

I do follow your opinion but in this case, exporting properties through python would be just one step of a whole proces. A proces to sustainability that could be automated. And that's why here, there's no other way than to use python.