[api-dev] Wiki down
Your wiki is busted ass. All day. Nothing under wiki.services... is accessible. I'm new - This is the first time I have ever tried to access it. Not a good start. Trying to learn something about api and sdk This is all I've been able to get all day - Sunday, 1/4/09: Network Timeout The server at wiki.services.openoffice.org is taking too long to respond. The requested site did not respond to a connection request and the browser has stopped waiting for a reply. * Could the server be experiencing high demand or a temporary outage? Try again later. * Are you unable to browse other sites? Check the computer's network connection. * Is your computer or network protected by a firewall or proxy? Incorrect settings can interfere with Web browsing. * Still having trouble? Consult your network administrator or Internet provider for assistance. - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
Re: [api-dev] How to change the "ActiveConnection" of a already opened Form
Hello Fernand, > I trye to pass a nwe connection to a already opened form document who > contains the macro a running from. You cannot do this. ActiveConnection is only accepted when the form is being loaded, after that, any change to it is vetoed, since the assumption is that the form, living in the database document, always uses the connection which the main database window already established. Also, in the scenario you described - two forms in the same database document - there should be no need at all to change the active connection of the already-loaded form. What do you want to achieve with this? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
Re: [api-dev] How to change the "ActiveConnection" of a already opened Form
Hi Fernand, >> Also, in the scenario you described - two forms in the same database >> document - there should be no need at all to change the active >> connection of the already-loaded form. What do you want to achieve with >> this? >> > Frank, thanks for the reply, the goal is to use OO as a front end for > manupulating data in external Databases and using OO-docs for the output > . Problem is to have 1 Doc where users have only acces to the Forms or > reports and keep them as far as possible away from the Databases > tables. etc... .. A few weeks ago Drew Jensen Gives me the folowing advice > > /Actually no you don't need 2 ODB files per user. > > When a form, query definition, or report, is opened from a script > (basic, python or JavaScript macro) you pass an instance of an open > connection object. Normally this is the Active connection for the ODB > file, but it does not have to be. > > So, when the switchboard form loads it could create a second connection > object. One that is connected to the MS SQLServer. Then when it loads > the actual forms, etc., simply pass this second connection to the form. Okay, so your form is in an .odb file, but it shall work on a connection other than the one described by the database document. Hmm. Not sure I would call this a valid scenario :), since the assumption has always been that a form embedded in a database document uses the connection of this database document. The fact that the ActiveConnection of this document is/must-be passed when loading the form is more of an implementation detail, which normally should not be exposed to the API. That's the reason why the more recent XDatabaseDocumentUI.loadComponent, which is to be preferred over loadComponentFromURL, does not require the active connection, but calculates it itself. Anyway, since it seems loadComponentFromURL works (kind of), you can try proceeding with it. However, for "re-connecting" a form to a new connection, you will then need to close/re-open the form. Your other question, about the sub forms not getting the active connection, is harder. Without going into detail, I in fact think the problem is the ActiveConnection used by the master form, which does not belong to the embodying database document. I can't think of a clean solution, but you could use an ugly workaround like this: a) Remove the sub form from its parent b) change its ActiveConnection property c) re-insert the sub form into its parent. You might write an RFE requesting that the sub forms also use the ActiveConnection passed while loading - finally, it could be considered a bug that they currently don't. However, I would need more thinking about the potential side effects of running an embedded form with an alien connection. In the worst case, this could lead to the conclusion that an ActiveConnection being different from the current connection of the application window is forbidden at all ... Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
[api-dev] Re: bad link on API documentation
On 28/12/2008 11:55, Juergen Schmidt wrote: we fixed the IDL docu to use the correct notation (lower case for modules). It seems that the IDL reference is still not 100% correct because "FieldMaster" is still wrong. just in case you forgot: i fixed the FieldMaster idl files already in cws odfmetadata2 (which, alas, has been delayed to OOo 3.2...). issue: i96209 I will check it and i will fix the DevGuide and the Basic guide asap ... Juergen michael -- "Sometimes, people ask me if it is a sin in the church of Emacs to use the editor Vi. It is true that Vi-Vi-Vi is the editor of the beast. But using a free version of Vi is not a sin but a penance." -- RMS - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
Re: [api-dev] Creating docked panel with uno
Hi Carsten, Carsten Driesner escribió: wanwei...@redoffice.com wrote: I wonder where I could find example how to create (and populate with widgets) a panel like those everywhere in OO2.0beta (eg. right docked transitions pane in OO Impress) using UNO (Java prefered). Hi, Unfortunately this is not possible with Java as there is no UNO API to create docking windows (panels). We are currently working on this topic and will hopefully able to provide a solution in one of the next version of OOo 3. that sound interesting. Is development happening in a cws? if so, can you share in which cws? Regards -- Ariel Constenla-Haile La Plata, Argentina "Aus der Kriegsschule des Lebens - Was mich nicht umbringt, macht mich härter." Nietzsche Götzendämmerung, Sprüche und Pfeile, 8. - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
Re: [api-dev] Creating docked panel with uno
wanwei...@redoffice.com wrote: I wonder where I could find example how to create (and populate with widgets) a panel like those everywhere in OO2.0beta (eg. right docked transitions pane in OO Impress) using UNO (Java prefered). Hi, Unfortunately this is not possible with Java as there is no UNO API to create docking windows (panels). We are currently working on this topic and will hopefully able to provide a solution in one of the next version of OOo 3. Regards, Carsten -- Carsten Driesner (cd) - Project Lead OpenOffice.org Framework Framework wiki: http://wiki.services.openoffice.org/wiki/Framework OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
Re: [api-dev] How to change the "ActiveConnection" of a already opened Form
Frank Schönheit - Sun Microsystems Germany wrote: Hello Fernand, I trye to pass a nwe connection to a already opened form document who contains the macro a running from. You cannot do this. ActiveConnection is only accepted when the form is being loaded, after that, any change to it is vetoed, since the assumption is that the form, living in the database document, always uses the connection which the main database window already established. Also, in the scenario you described - two forms in the same database document - there should be no need at all to change the active connection of the already-loaded form. What do you want to achieve with this? Frank, thanks for the reply, the goal is to use OO as a front end for manupulating data in external Databases and using OO-docs for the output . Problem is to have 1 Doc where users have only acces to the Forms or reports and keep them as far as possible away from the Databases tables. etc... .. A few weeks ago Drew Jensen Gives me the folowing advice /Actually no you don't need 2 ODB files per user. When a form, query definition, or report, is opened from a script (basic, python or JavaScript macro) you pass an instance of an open connection object. Normally this is the Active connection for the ODB file, but it does not have to be. So, when the switchboard form loads it could create a second connection object. One that is connected to the MS SQLServer. Then when it loads the actual forms, etc., simply pass this second connection to the form. In fact this also allows you to use getIsolatedConnection (versus getConnection) to create a connection that supports AUTO_COMMIT = False if you need to - this allows you full control for committing or rolling back updates as needed, for instance: multiple table updates as a single business transaction. (This same trick works for an embedded HSQL database by the way) You will probably want to use two ODB files when you are building the application, but a final step before pushing out to your users will be a merge of the forms, query def's, reports into the single ODB file that you would distribute. Taking this one step then, you can have forms and or statements in scripts that work with local (embedded HSQL) tables in the same ODB file then - a nice way to offer user specific configuration or history data in your database. I hope that helps, Drew ps - sure looks like a ripe candidate for a sm/ all example project, doesn't it. Greetz and a Happy and Succes full New Year for you and your Familly Fernand Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
Re: [api-dev] How to change the "ActiveConnection" of a already opened Form
Hi Fernand, > OK I can follow so far, but can you see a other strategie to keep the > users away from Tables and other Datbase stuff where valid information > like Paswords etc... are been stored ? > I was thinking on > - Stroring the forms in a WritterDoc ? that would completely avoid the problem of embedding forms not being prepared for alien connections, yes. At the cost of additional administration, of course. Perhaps the easiest way here is to simply take the form, copy it to a stand-alone document, and load this one - in this case, the ActiveConnection parameter should work as you expect it. > - open a OO-base-doc in a "hidden" way ? Should work, too, though I never played with this. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
Re: [api-dev] How to change the "ActiveConnection" of a already opened Form
Frank Schönheit - Sun Microsystems Germany wrote: Hi Fernand, Also, in the scenario you described - two forms in the same database document - there should be no need at all to change the active connection of the already-loaded form. What do you want to achieve with this? Frank, thanks for the reply, the goal is to use OO as a front end for manupulating data in external Databases and using OO-docs for the output . Problem is to have 1 Doc where users have only acces to the Forms or reports and keep them as far as possible away from the Databases tables. etc... .. A few weeks ago Drew Jensen Gives me the folowing advice /Actually no you don't need 2 ODB files per user. When a form, query definition, or report, is opened from a script (basic, python or JavaScript macro) you pass an instance of an open connection object. Normally this is the Active connection for the ODB file, but it does not have to be. So, when the switchboard form loads it could create a second connection object. One that is connected to the MS SQLServer. Then when it loads the actual forms, etc., simply pass this second connection to the form. Okay, so your form is in an .odb file, but it shall work on a connection other than the one described by the database document. Hmm. Not sure I would call this a valid scenario :), since the assumption has always been that a form embedded in a database document uses the connection of this database document. The fact that the ActiveConnection of this document is/must-be passed when loading the form is more of an implementation detail, which normally should not be exposed to the API. That's the reason why the more recent XDatabaseDocumentUI.loadComponent, which is to be preferred over loadComponentFromURL, does not require the active connection, but calculates it itself. Anyway, since it seems loadComponentFromURL works (kind of), you can try proceeding with it. However, for "re-connecting" a form to a new connection, you will then need to close/re-open the form. Your other question, about the sub forms not getting the active connection, is harder. Without going into detail, I in fact think the problem is the ActiveConnection used by the master form, which does not belong to the embodying database document. I can't think of a clean solution, but you could use an ugly workaround like this: a) Remove the sub form from its parent b) change its ActiveConnection property c) re-insert the sub form into its parent. You might write an RFE requesting that the sub forms also use the ActiveConnection passed while loading - finally, it could be considered a bug that they currently don't. However, I would need more thinking about the potential side effects of running an embedded form with an alien connection. In the worst case, this could lead to the conclusion that an ActiveConnection being different from the current connection of the application window is forbidden at all ... OK I can follow so far, but can you see a other strategie to keep the users away from Tables and other Datbase stuff where valid information like Paswords etc... are been stored ? I was thinking on - Stroring the forms in a WritterDoc ? - open a OO-base-doc in a "hidden" way ? - multi-user aces to one OO-base-doc (because one of the main problems is to distribute several Docs who are needed to run 1 application) Greetz Fernand Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
Re: [api-dev] How set a Default Value to a FormControl ListBox
Hello Fernand, > but even manual entered list entries the famous "" button gives an > ugly beep as respons, is this a bug or are am i doging something wrong ? hmmm, no problem here with using this Sounds like, well, at least a oddity of your installation/environment/version. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
[api-dev] save to image?
Hi All, I've started to play around with the OO SDK. I have a question... How do I load a document and then save it as an image? e.g. load a DOCX file and then save the cover page (er... first page) to a JPG file I figured out how to load a DOCX, but I haven't figured out the second bit. I tried to do it through the print methods, but that only allows for a PS output. Currently, I'm looking into XRenderable... no luck yet. Any ideas? Thanks! - Albert - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org
[api-dev] save to an image?
Hi All, I've started to play around with the OO SDK. I have a question... How do I load a document and then save it as an image? e.g. load a DOCX file and then save the cover page (er... first page) to a JPG file I figured out how to load a DOCX, but I haven't figured out the second bit. I tried to do it through the print methods, but that only allows for a PS output. And now I'm looking into XRenderable, but I have a feeling that will be a dead end. Any ideas? Thanks! - Albert - To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org For additional commands, e-mail: dev-h...@api.openoffice.org