Hi Dave, OK, well I put together a little users guide - that covers how to run the utility in this early release. You can download it at http://www.paintedfrogceramics.com/OpenOffice/BaseExport/Base_Export_Guide.odt
You might want to grab last nights copy of the library also. You just do the same thing to install it using the package manager and it updates the library. http://www.paintedfrogceramics.com/OpenOffice/BaseExport/BaseExport.uno.pkg Drew ps - in writing the document I found out just how easy it is to update a basic library with the package manager and manged to completely lose 4 hours work. Jees, a warning message might of been nice...I think it merits a trip to the issue tracker. On 9/14/06, [email protected] <[email protected]> wrote:
Andrew Jensen wrote: > Hello Frank, et al, > > Thanks for the feed back, with yours I now have a total of...1..LOL > > Your timing however was perfect. In keeping with the XP paradigm > today was > spent refactoring - getting rid of globals, some new controls > blocks, better > error traps, literals to constants, etc - in short turning that > jumble into > production quality code - if one can call a script such a thing. > > Using the connection instead of the datasource for the table and query > information worked out quite well - thanks. > > Anyway, next sprint will be this weekend to add query support and > one more > feature. Column names as first row in export file, as an option. My > value > added feature to the SELECT INTO functionality delivered by HSQLDB. > > I'll let folks know when this has been uploaded. > > > > On 9/13/06, Frank Schönheit - Sun Microsystems Germany < > [EMAIL PROTECTED]> wrote: >> >> Hi Andrew, >> >> > I have uploaded the latest copy of the utility and you can (should) >> download >> > it at >> > >> http://www.paintedfrogceramics.com/OpenOffice/BaseExport/BaseExport.uno.pkg >> >> < >> http://www.paintedfrogceramics.com/OpenOffice/BaseExport/BaseExport.2.uno.pkg >> >> > >> > ... >> > Anyway, I think that is about it for now. Give it a try if you >> would. >> >> Quite cool. >> >> For completeness, I suggest not using the ds.Tables object, since this >> are table UI information. It might happen that this contains more >> tables >> than actually are present in the DB. Use the connection's Tables >> object >> instead, as this reflects the actual tables. >> >> > The interface dialog has been changed to allow you to choose >> UTF-8 or >> ASCII >> > as the character encoding for the text file. If you uncheck the 'use >> > default' check box the default encoding will be UTF-8. The HSQLDB >> docs >> state >> > that other encoding besides ASCII and UTF-8 are supported, but the >> utility >> > is only supporting these two for now. >> >> Would be diffifult to find other ones which are supported, since this >> depends on the JVM in which HSQL is running. See >> http://java.sun.com/j2se/1.4.2/docs/api/java/nio/charset/Charset.html >> for details. >> >> > Even if yo select "quote all" on the Field Settings page BLOB fields >> will be >> > exported without quotes. This seems to be a 'feature' of HSQLDB, >> one I >> did >> > not know. >> >> Interesting to know, thanks for the hint :) >> >> Ciao >> Frank >> >> -- >> - Frank Schönheit, Software Engineer >> [EMAIL PROTECTED] - >> - Sun Microsystems >> http://www.sun.com/staroffice - >> - OpenOffice.org Database >> http://dba.openoffice.org - >> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - >> - - >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> I'd very much like to try it out .( I did try but was not successful ) I was able to have it imported to the macros but was not sure how to use it after that. If you have a step by step complete with database name and table name I'm sure I could pull it off. Sometimes I just don't get things on the first go around but it's my persistence that pays off... Just ask my wife....lol -- Regards Dave Ashmore SOHO IT Solutions LLC 1934 S. Delaware Dr. Easton, PA 18042 610-258-7128 http://callsohoit.com We now support the Linux Desktop Disclaimer: The below quote is randomly generated and I may or may not agree with the quote. So here is your random bit of wit. ################################################################ (homer) % It could be one of these chemicals here that makes him so smart. Lisa, maybe you should try some of this. -- Homer Simpson Bart The Genius ################################################################ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
