Search the Knowledge Base Report a bug
Post new topic   Reply to topic   printer-friendly view   .    ArchiCAD-Talk Forum Index >>> Schedules >>> Tip: Extracting data for Access using Publisher in AC 10
View previous topic :: View next topic
Author Message
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7770
Location: Bozeman, Montana USA

PostPosted: Sun Nov 05, 2006 2:35 am    Post subject: Tip: Extracting data for Access using Publisher in AC 10 Reply with quote

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

_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
aj
New member
New member

Joined: 12 Oct 2005
Posts: 30
Location: Sunshine Coast, QLD, Australia

PostPosted: Wed Nov 08, 2006 12:43 pm    Post subject: Re: Tip: Extracting data for Access using Publisher in AC 10 Reply with quote

Karl
Can you export 2d graphical images of parts etc to access as well ?
Just wondering...
Andrew (AJH)

_________________
AC10 WinXP Pro AMD 64bit 4000
4 Gb Ram 512mb Dual DVI 2 x 22" LCD
Back to top
View user's profile Send private message    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7770
Location: Bozeman, Montana USA

PostPosted: Wed Nov 08, 2006 6:38 pm    Post subject: Re: Tip: Extracting data for Access using Publisher in AC 10 Reply with quote

aj wrote:
Can you export 2d graphical images of parts etc to access as well ?


Did not test - but would be very surprised if so.

Karl

_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
TomWaltz
Senior member
Senior member

Joined: 27 Oct 2003
Posts: 4546
Location: Philadelphia, PA

PostPosted: Wed Nov 08, 2006 6:59 pm    Post subject: Re: Tip: Extracting data for Access using Publisher in AC 10 Reply with quote

I'm just learning FileMaker now. It will definitely OPEN the exported file but I have not had a chance to see if it can LINK to the file.
_________________
Tom Waltz
Back to top
View user's profile Send private message    LinkedIn Profile Link (Full URL, please)
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7770
Location: Bozeman, Montana USA

PostPosted: Sat Mar 26, 2011 12:51 am    Post subject: Re: Tip: Extracting data for Access using Publisher in AC 10 Reply with quote

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. Wink

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

_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Display posts from previous:   
View previous topic :: View next topic
Post new topic   Reply to topic   printer-friendly view       ArchiCAD-Talk Forum Index >>> Schedules >>> Tip: Extracting data for Access using Publisher in AC 10 All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum


Powered by phpBB 2001, 2005 phpBB Group
Copyright 2012 - Graphisoft SE. All rights reserved worldwide. Terms of Use | Privacy Policy