The Global ARCHICAD Community

Stay informed. Get help. Share your knowledge.

View only topic: Collection of Best Practices edited by the moderator. (Please post your tips into one of the topics under section II.)

Moderators: Barry Kelly, Karl Ottenstein, LaszloNagy, ejrolon, gkmethy

#75058
A relatively easy way to extract data from ArchiCAD 10 for sophisticated manipulation and reporting in Microsoft Access is to use Publisher.

Now that Schedules are publishable items in 10, we can create a data publishing set that contains as many schedules as we need to generate all of the data required for whatever analysis and reporting we're doing (limited by the restrictions on what data can be extracted with Interactive Schedules, of course). Any/all object parameters can be obtained, but not necessarily all parameters of all elements. No access to attribute information, etc... only SQL (non-publishable) and ODBC (not available for 10 as of this writing) provide that.

Once you have created your schedules and dragged them into a new publisher set - and set up the 'save as' folder for the set - select all of the items, and change their 'save as' type to be Excel/XLS. Click Publish.

In Microsoft Access, create links to each of these XLS files (Excel can also create links to text csv files). Note: do not import the xls (or text) files. It is essential that you create links so that updates will be dynamic. Create all of the queries, forms, reports that you need for your data solution.

Subsequently, simply click 'Publish' in ArchiCAD to update the on-disk xls files - which are dynamically linked to your Access database...and see the updated information there.

Note: 'list schemes' can also be published and linked.

For Mac people, I'm not sure that there is as good a solution as provided by Access. The last version of FileMaker that I have (7) can only link to another FIleMaker file - not to text or excel files, making this tip/trick unusable there. Perhaps the current version of FM is more flexible (although in my opinion, Access is still vastly more powerful).

Cheers,
Karl
#186398
Karl Ottenstein wrote:For Mac people, I'm not sure that there is as good a solution as provided by Access. The last version of FileMaker that I have (7) can only link to another FIleMaker file - not to text or excel files, making this tip/trick unusable there. Perhaps the current version of FM is more flexible (although in my opinion, Access is still vastly more powerful).


I've become a Mac person since this tip was posted. ;-)

Wanted to update this thread to note that FileMaker Pro 11 now supports what they call "recurring imports" in which an Excel sheet or CSV (etc) can be set to import every time the database is opened. This now gives Mac users the same ability mentioned below for MS Access users. Linking seems smarter to me, but automatic re-import gives the same result.

Cheers,
Karl