Project data & BIM
About BIM-based management of attributes, schedules, templates, favorites, hotlinks, projects in general, quality assurance, etc.
SOLVED!

Exporting schedule data for use by other applications

Stryker
Participant

I have a schematic in Archicad 27 which I need to export so that an internal application can use it but I need to export it with a Python script or some addon. Can someone guide me? Attached is an image of what I need to export so that the idea is understood.

 

image (3).png

1 ACCEPTED SOLUTION

Accepted Solutions
Solution
Karl Ottenstein
Moderator

If you are just learning Archicad, Python is the absolutely LAST thing to learn/ask about 🙂

 

With your schedule displayed as in your screenshot, you can save it as a tab delimited data file or an Excel worksheet simply with File > Save As and selecting the desired format:

 

Screenshot 2024-07-01 at 11.46.11 AM.png

When you have many schedules that you want to export for use in external software, Publisher is more convenient as you can include in a publisher set every required schedule and one click will produce the output files.  This example has 2 schedules being published as Excel files:

 

Screenshot 2024-07-01 at 11.42.45 AM.png

One of the forum moderators
AC 28 USA and earlier   •   macOS Sonoma 14.7.1, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB

View solution in original post

5 REPLIES 5
Karl Ottenstein
Moderator

Is there a reason you cannot just use Publisher?  You can publish in a variety of formats including numeric data file.

One of the forum moderators
AC 28 USA and earlier   •   macOS Sonoma 14.7.1, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB

I'm just starting out, could you guide me with publisher?

Solution
Karl Ottenstein
Moderator

If you are just learning Archicad, Python is the absolutely LAST thing to learn/ask about 🙂

 

With your schedule displayed as in your screenshot, you can save it as a tab delimited data file or an Excel worksheet simply with File > Save As and selecting the desired format:

 

Screenshot 2024-07-01 at 11.46.11 AM.png

When you have many schedules that you want to export for use in external software, Publisher is more convenient as you can include in a publisher set every required schedule and one click will produce the output files.  This example has 2 schedules being published as Excel files:

 

Screenshot 2024-07-01 at 11.42.45 AM.png

One of the forum moderators
AC 28 USA and earlier   •   macOS Sonoma 14.7.1, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB

Let me explain, we need to extract the information created by the designers, in this case, the furniture data schema, but not with the "save as" option. The idea is that the file delivered by Archicad should not be intervened with since we need to process them so that the machines receive a cutting program based on the furniture information. Therefore, we need to extract the schema in a way that is abstract and can be used by an application. That's why I was asking; I'm trying to do something with C++, but I'm not sure what the best option is. If you could guide me, that would be great.

There is no way to extract data without launching Archicad - even if with Python or C++.  Years ago there was a way (ODBC connection etc) but today, there is no standalone method without launching the full Archicad.  As long is Archicad is running, why would it make a difference if you click an API button or click the Publish button?

One of the forum moderators
AC 28 USA and earlier   •   macOS Sonoma 14.7.1, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB