topic XML list output in Collaboration with other software

XML list output

Anonymous — Fri, 23 Jan 2004 23:18:03 GMT

In my brief brush with the Object Adapter for AutoCAD I found that it could output a "list" in XML format. This list was simply a listing of parameter values but I would suspect that one could do the same with ArchiCAD with greater control and detail.

Has anyone traveled down this road?

Re: XML list output

eldhead — Thu, 26 Feb 2004 13:11:50 GMT

Connect to the database in ArchiCAD via Access, make tables and then view them with some table editor written in ASP with functionallity to export tables as XML.
Demo: http://joycad.serveftp.net/Tableeditor/index.asp

UserID: demo
Password: demo

/Johan

Re: XML list output

Karl Ottenstein — Thu, 26 Feb 2004 20:00:19 GMT

Sean wrote:
In my brief brush with the Object Adapter for AutoCAD I found that it could output a "list" in XML format. This list was simply a listing of parameter values but I would suspect that one could do the same with ArchiCAD with greater control and detail.

Has anyone traveled down this road?

Hey Sean,

Yup. Anything that you query using SQL in the Calculate menu (see
http://www.graphisoft.com/support/archicad/archiguide/SQLqueriesinAC1.html

is displayed in XML and can be further processed in other programs.

In addition, there has been an ODBC driver for Windows developers that allows you to link directly to a PLN/PLA file and query information from the model.

Finally, the Interactive Scheduler can query many things as well ... and for Windows users, can in one click transfer the results into a new Excel sheet.

I'll be talking about the I.S. at ACUWest ... and perhaps if there is time in the Tips and Tricks session, can demo the ODBC/Access connection and the SQL queries. Looking forward to meeting you there and hearing about the TrusJoist objects and whatever broader Trus Joist projects that the company allows you to talk about!

Karl

Re: XML list output

stefan — Mon, 01 Mar 2004 12:10:57 GMT

Any chance to compile this experiences into a report for non-ACUWest visitors?

Re: XML list output

Karl Ottenstein — Mon, 01 Mar 2004 17:16:20 GMT

stefan wrote:
Any chance to compile this experiences into a report for non-ACUWest visitors?

Maybe ... but not until April. Prepping for ACUWest and getting normal work done has more than filled my schedule until then! 😉