Ferry Toth wrote: > [...] > 2) Another thing database designers are not overly concerned about is > how to get the data out, in a meaningful way. This is demonstrated by > many low cost administrative packages based MSA as well. However, the > end user doesn't collect data just to record history, they want to do > something with it. > > For instance we are developing a Time Track application that stores data > in a postgresql server, with some properties relating to project > management and billing. > > One way to retrieve the data is through Base, into Calc using the data > pilot. I'm sure it is not evident to everybody how to do this, and it's > only one of the many things you can do with Base. A lot of other stuff > would require programming. For instance who know how to display a graph > in a Base form that is updated by the selection of the form (a more or > less simple thing to do in MSA). > Additional note: Datapilots created from datasource are not accessible through the API. Macros don't see them.
> 3) Also, building this Calc sheet and the Base database we found short > comings that will probe usefull in further developing both applications. > > (for those still interested: Oh, yes. All my database reports are formatted spreadsheets and data pilots. > *Using form filters on boolean fields produce an error that an integer > can not be compared to a boolean. Funny, Base nows that the field in the > table is a boolean, because is dislays a checkbox, but when you want to > set the form filter on "Billable" it add the filter Billable = 1 Thank you for this information. This may save some hour of time since it is one of those "what-am-I-doing-wrong?" issues. > *In the datapilot you want to generate a bill for a customer (a project) > over a certain period. Whoopie, I can select the project, tasks, > billable hours and get totals for everything I need. Unfortunately, I > can only select the time frame by manually excluding each date outside > of the period. I appears the datapilot handles data field as text > (showing each and allowing them to be excluded, instead of values that > can be included between a start and end date) Select a date/time-cell in the pilot and call Data>Outline>Group (key F12). You can split up the date/time into minutes, hours, ..., years. (for those still interested): * Time stamp fields from data sources are imported as empty data pilot fields. http://www.openoffice.org/issues/show_bug.cgi?id=81848 * In Calc you can set refresh periods for imported database ranges, but not in the GUI. * You can import from data source by SQL SELECT, but not in the GUI. With a little bit of scripting you can build parameter queries from spreadsheet cells. Very quick and dirty proof of concept: http://www.mediafire.com/download.php?ft4thvzoztx --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
