Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-07 Thread Ariel Constenla-Haile
Hi Marc, Marc Santhoff escribió: Am Freitag, den 07.12.2007, 04:21 -0300 schrieb Ariel Constenla-Haile: ach... du Träumer...! you MUST implement it yourself, you dream too much if you think you can achieve it with OOo Basic. I know that, but what I was trying is to get the the implmentation

Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-07 Thread Frank Schönheit - Sun Microsystems Germ any
Hi Ariel, Concerning your OOo Basic dream, reading http://extensions.openoffice.org/servlets/ReadMsg?list=devmsgNo=1062 it seems that is impossible but just because core developers, when adding new features are not very concerned to make them accessible from starbasic. IMHO it's

Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-06 Thread Ariel Constenla-Haile
Hi Marc Marc Santhoff escribió: Am Donnerstag, den 06.12.2007, 10:28 -0300 schrieb Ariel Constenla-Haile: Frank Schönheit - Sun Microsystems Germany escribió: Hi Marc, Isn't css.ui.doalogs.FilterOptionsDialog the service to call in front of importing? (Frank?) Uh, never heard of this one.

Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-06 Thread Marc Santhoff
Am Freitag, den 07.12.2007, 04:21 -0300 schrieb Ariel Constenla-Haile: ach... du Träumer...! you MUST implement it yourself, you dream too much if you think you can achieve it with OOo Basic. I know that, but what I was trying is to get the the implmentation from calc, to see if something

Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-05 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Ariel, 2. * ConnectionResource = sdbc:flat:file:///home/ariel/myfile.csv * CommandType = com.sun.star.sdb.CommandType.TABLE * Command = myfile == the file name without extension, as it is used in SELECT SQL statements to execute queries against the

Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-05 Thread Ariel Constenla-Haile
Hi Frank Frank Schönheit - Sun Microsystems Germany escribió: Hi Ariel, RESULT: the constructor returns an XCopyTableWizard reference, but XExecutableDialog.execute() makes OOo crash (without crash report -- at least here in Linux) It does here, too :( That'd be fixed. In some sense, it

Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-05 Thread Ariel Constenla-Haile
Frank Schönheit - Sun Microsystems Germany escribió: Hi Ariel, By the way, a doubt: should we dispose() the dialog after execute() returns? You won't find a dispose at this particular dialog implementation :) I always do it with other XExecutableDialog's (as the GUI chap. says to always

Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-05 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Ariel, By the way, a doubt: should we dispose() the dialog after execute() returns? You won't find a dispose at this particular dialog implementation :) I always do it with other XExecutableDialog's (as the GUI chap. says to always dispose() the FilePicker). dispose has a good and a

Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-05 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Ariel, RESULT: the constructor returns an XCopyTableWizard reference, but XExecutableDialog.execute() makes OOo crash (without crash report -- at least here in Linux) It does here, too :( That'd be fixed. In some sense, it *was* the wizard: It used the file driver in a way it had never

Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-05 Thread Marc Santhoff
Am Mittwoch, den 05.12.2007, 19:13 + schrieb Drew: -Original Message- From: Jim Callahan [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 5, 2007 12:11 PM To: dev@dba.openoffice.org Subject: Re: [dba-dev] UNOized Copy Table Wizard: FLAT SOURCE So I see no other option than

[dba-dev] UNOized Copy Table Wizard: FLAT SOURCE

2007-12-03 Thread Ariel Constenla-Haile
Hello Frank, hello people, I've been a good boy ;-) , and I've been testing on Sunday. These are the results trying to copy *FROM* a flat file (comma separated values) *TO* an HSQLDB embedded / MySQL database [obviously the other way around is not possible], in Linux with Java UNO bridge. 1.