Tip: Extracting data for Access using Publisher in AC 10

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2006-11-05 02:35 AM
2006-11-05
02:35 AM
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
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 28 USA and earlier • macOS Sequoia 15.4, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB
Labels:
- Labels:
-
Data management
4 REPLIES 4
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2006-11-08 12:43 PM
2006-11-08
12:43 PM
Karl
Can you export 2d graphical images of parts etc to access as well ?
Just wondering...
Andrew (AJH)
Can you export 2d graphical images of parts etc to access as well ?
Just wondering...
Andrew (AJH)

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2006-11-08 06:38 PM
2006-11-08
06:38 PM
aj wrote:Did not test - but would be very surprised if so.
Can you export 2d graphical images of parts etc to access as well ?
Karl
AC 28 USA and earlier • macOS Sequoia 15.4, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2006-11-08 06:59 PM
2006-11-08
06:59 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011-03-26 12:51 AM
2011-03-26
12:51 AM
Karl wrote:I've become a Mac person since this tip was posted.
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).
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 28 USA and earlier • macOS Sequoia 15.4, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB