Hello again. Just thought I would pass on a few items to you.
First - the CSV export utility I am working on is moving to http://oobasestation.sourceforge.net/csv-export Second - a release via the Forum garnered some testing and feed back ( that means bug reports... ) Third - have added wiki pages to talk about this export and two companion pieces of work I am starting at http://wiki.services.openoffice.org/wiki/CSV_export Fourth - I will be releasing a new copy of the library and an updated users guide this afternoon. The sourcefoge page will be updated at the time. Here are a few of the highlites from this, I am calling it the Alpha3 release : ' Release 0.5 9/18/06 ' Fixed - ' removed Erroneous load of Xray ' ' Added / Changed - ' ' included a new startup procedure Mod1.Main_debug. This procedure adds a ' few extra pieces of information to the error message and loads the xray library ' ' Another round of refactoring on the export functions. ' ' ExportData now takes as an input parameter an object for the export source ' instead of a table name. This input parameter must support one of these three ' services: ' "com.sun.star.sdbcx.Table" ' "com.sun.star.sdb.QueryDefinition" ' "com.sun.star.sdb.RowSet" [for this releae simply prints a message ' that this is not implemented yet ] ' ' Changed the flow for the query export functions: ' exportQuery is now control block calling either of ' exportSimpleQuery ' exportParamQuery ( which ends up calling exportSimpleQuery ) ' ' Added a dialog box to solicite parameter values form the user ' ' Bugs - ' ' If a query is used that has multiple uses of the same column name ' this is not recognized and the export fails. ' ' The parameter replacement function is not handling different data types ' therefore date and time values are not being updated correctly ' this causes an export failure ' ' **** Full table exports and non-parameterized queries with date, time ' **** and datetime columns work as expected ' ' the whole parameter dialog is just barely running ' ' Finally, I am hoping that this becomes a user community project - not just my project. Please take the time to go to the wiki and read about the other project ideas - Export Manager and XML Export. In both cases there is already some working scripts, stuff I have accumulated over the past year and will now be redoing for this particular project. If you have ideas about how this shoud look, or work I want to hear about it. If you think I am wasting your time making you read this message...well, keep that to yourself..*chucke*.. Thanks again, Andrew 'Drew' Jensen PS in the future I will use the wiki and sourceforge pages, not this mail list so much
