[libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic
Le 19/06/13 20:12, Adam Tauno Williams a écrit : Hi Adam, One thing I haven't found is a good example of presenting / driving some UI from within the scope of LOo from Python. I don't even know that it is possible. But I've been lurking the developer list[s] and see talk about LOo glade... that would be really nice. The best that I can think of currently in the 4.0/1 branch of LO would be the wizards, these are now written in Python and manage UI elements to present something more palatable to the user. Have a look at, for example, AgendaWizardDialog.py, which can be found in the source code at : core/wizards/com/sun/star/wizards/agenda/AgendaWizardDialog.py The Glade UI stuff takes a Glade UI template and converts it to a LO AWT UI with a bit of under the hood magic. Check out the UI rework effort on the wiki to see whether there is anything remotely useful that you could throw into a python module. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic
Tom Davies wrote: Hi :) I think Base can either use an SQL-based back-end or LO Calc spreadsheets. Just not both at the same time. Most distressing that LO Base must use LO Calc spreadsheet files as non SQL DB store. (head shaking) :-( -- Michael Lueck Lueck Data Systems http://www.lueckdatasystems.com/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic
On Thu, 2013-05-02 at 21:48 -0400, Andrew Douglas Pitonyak wrote: On 05/02/2013 12:47 PM, Alexander Thurgood wrote: Look at UNO, look at the language bindings, decide which is the most appropriate for what you want to do : http://api.libreoffice.org/ http://api.libreoffice.org/docs/common/ref/com/sun/star/sdb/module-ix.htm http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbc/module-ix.html http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbcx/module-ix.html http://www.openoffice.org/udk/ I usually check the online API docs (as shown above), inspecting the objects, and I have even bothered to dive into the source code when I was totally befuddled. One thing I haven't found is a good example of presenting / driving some UI from within the scope of LOo from Python. I don't even know that it is possible. But I've been lurking the developer list[s] and see talk about LOo glade... that would be really nice. -- Adam Tauno Williams mailto:awill...@whitemice.org GPG D95ED383 Systems Administrator, Python Developer, LPI / NCLA -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic
Greetings All, I successfully warped up the application development project I described. Final end-of-project stats were as follows: Total 123,576 LOC's, 413 Modules (Classes/Modules/Forms/Reports), 264 Stored Procedures, and fin! It has a Front-End (FE) which is the bulk of that code, an automated replication application transferring data from the production JDE ERP system for use by the application I built, and finally I developed for them an application server architecture to asynchronously process requests without tying up the FE application. The legacy application this new one replaced had the following stats: 1,366 LOC's in 12 module(s) So, getting finally back and replying... Mark LaPierre wrote: Your post was requesting some guidance for Serious application development with LibreOffice and LibreOffice Basic. My reply was intended to communicate the fact that LO Base is very limited when it comes to serious uses. I guess I can now see what you were communicating. LO Base is not capable of connecting to an SQL based back end, and linking to a LO Calc spreadsheet at the same time. snip Is LO Calc spreadsheets really the preferable file format for LO Base data? That one restriction was enough to disqualify LO Base from consideration for what I consider to be a very simple application. That is unfortunate. Wolfgang Keller wrote: At first I would like to use MySQL as the BE DB for use with LibreOffice. That's a B-A-D idea if you want to get your data back in a consistent state with a certain reliability. Use PostgreSQL instead. MySQL is trusted by this client organization to handle their production website... LAMP software stack. Why would it suddenly not be reliable for back office Client/Server use? I guess for the moment I will leave the DB requirements in Access, and later port them to Free Pascal / Lazarus when I have the time to get up-to-speed with that cross platform serious development tool. Thank you all for your helpful responses. Actually last week I came across a link referring to StarOffice... I had forgotten that origin in the LibreOffice history timeline! Sincerely, -- Michael Lueck Lueck Data Systems http://www.lueckdatasystems.com/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic
Hi :) I think Base can either use an SQL-based back-end or LO Calc spreadsheets. Just not both at the same time. Errr, the rest of it was a bit over my head! Hopefully someone else will be around soon Regards from tom :) From: Michael Lueck mlu...@lueckdatasystems.com To: users@global.libreoffice.org Sent: Tuesday, 18 June 2013, 22:05 Subject: [libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic Greetings All, I successfully warped up the application development project I described. Final end-of-project stats were as follows: Total 123,576 LOC's, 413 Modules (Classes/Modules/Forms/Reports), 264 Stored Procedures, and fin! It has a Front-End (FE) which is the bulk of that code, an automated replication application transferring data from the production JDE ERP system for use by the application I built, and finally I developed for them an application server architecture to asynchronously process requests without tying up the FE application. The legacy application this new one replaced had the following stats: 1,366 LOC's in 12 module(s) So, getting finally back and replying... Mark LaPierre wrote: Your post was requesting some guidance for Serious application development with LibreOffice and LibreOffice Basic. My reply was intended to communicate the fact that LO Base is very limited when it comes to serious uses. I guess I can now see what you were communicating. LO Base is not capable of connecting to an SQL based back end, and linking to a LO Calc spreadsheet at the same time. snip Is LO Calc spreadsheets really the preferable file format for LO Base data? That one restriction was enough to disqualify LO Base from consideration for what I consider to be a very simple application. That is unfortunate. Wolfgang Keller wrote: At first I would like to use MySQL as the BE DB for use with LibreOffice. That's a B-A-D idea if you want to get your data back in a consistent state with a certain reliability. Use PostgreSQL instead. MySQL is trusted by this client organization to handle their production website... LAMP software stack. Why would it suddenly not be reliable for back office Client/Server use? I guess for the moment I will leave the DB requirements in Access, and later port them to Free Pascal / Lazarus when I have the time to get up-to-speed with that cross platform serious development tool. Thank you all for your helpful responses. Actually last week I came across a link referring to StarOffice... I had forgotten that origin in the LibreOffice history timeline! Sincerely, -- Michael Lueck Lueck Data Systems http://www.lueckdatasystems.com/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic
On 04/29/2013 05:54 PM, Michael Lueck wrote: Greetings Mark, I am puzzled at what you posted in reply to my original message... I was talking about a desktop database as the front-end in a Client/Server application. It appears your question was with using spreadsheets as a database table. Did I not understand something that was intended? Sincerely, Mark LaPierre wrote: Oops! I meant to send this to the list. This is what I was told when I asked about the capabilities of Base: Le 17/02/2013 02:38, Mark LaPierre a écrit : Hi Mark, Now how do I create non-linked tables inside the same DB? How do I link to another external spreadsheet using the same DB? You would be better off using an external HSQLDB instance to link directly to text tables (note that these would not be Excel files). See the HSQLDB manual for how to do this. http://hsqldb.sourceforge.net/doc/guide/guide.html#texttables-chapter Can I link to only one spreadsheet at a time? In a single ODB file with the embedded hsqldb engine, AFAIK yes. From your email I gather that all tables must be tabs on the one spreadsheet that is linked. Is that a true statement? Seems pretty inconvenient. It is, fairly. But LO Base is not Access, nor FMPro. If you need to work comfortably with and edit multiple separate data sources, using the embedded hsqldb is probably not the best choice. Alex YMMV Your post was requesting some guidance for Serious application development with LibreOffice and LibreOffice Basic. My reply was intended to communicate the fact that LO Base is very limited when it comes to serious uses. LO Base is not capable of connecting to an SQL based back end, and linking to a LO Calc spreadsheet at the same time. If you link to a spreadsheet all tables used in your LO Base application must exist as worksheets inside that same LO Calc spreadsheet. That one restriction was enough to disqualify LO Base from consideration for what I consider to be a very simple application. I have four different LO Calc spreadsheets that contain related information. I wanted to link to all four of those spreadsheets and extract the appropriate data from each to build a report combining information from each. The data contained in the LO Calc spreadsheets change on a weekly basis. I need to combine all that weekly data into a large database containing combined data for many years. Can't get there from here. Something like this would be trivial for MS Access. What I'm trying to tell you is that you should consider LO Base as a front end for a single LO Calc spreadsheet and not much else. You can not import data from a spreadsheet into a LO Base application. Another issue is the lack of documentation. I've searched and asked but found only the barest of guidance. A computer program without documentation is what they call a video game. Now, if anyone on this list knows better, please feel free to post your illustrative prose in reply. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic
Le 28/04/13 02:53, Michael Lueck a écrit : Hi Michael, I am interested in the capabilities of LibreOffice Basic along the same lines. I seriously doubt that using LO Basic, you would be able to attain a similar goal in any meaningful timeframe and with decent performance. However, using another language via one of the UNO bindings might be a more viable (if somewhat daunting) project. The documentation for LibreOffice Basic seems very space compared to MS VBA. That's because it is. Documentation on UNO and Basic comes down to the built-in help and anything you can find with regard to the OpenOffice.org project, the current API documentation produced by the LO project, and old Sun StarOffice documents (if they are still around). VBA has a whole ecosystem and 20-odd years worth of product pushing around it by people paid to push the platform forward. Although UNO has been around since the days of StarOffice, it has never had that commercial acceptance. Look at UNO, look at the language bindings, decide which is the most appropriate for what you want to do : http://api.libreoffice.org/ http://api.libreoffice.org/docs/common/ref/com/sun/star/sdb/module-ix.html http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbc/module-ix.html http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbcx/module-ix.html http://www.openoffice.org/udk/ Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic
On 05/02/2013 12:47 PM, Alexander Thurgood wrote: I seriously doubt that using LO Basic, you would be able to attain a similar goal in any meaningful timeframe and with decent performance. However, using another language via one of the UNO bindings might be a more viable (if somewhat daunting) project. If you use another language, then you have full access to everything that it offers. The documentation for LibreOffice Basic seems very space compared to MS VBA. That's because it is. Documentation on UNO and Basic comes down to the built-in help and anything you can find with regard to the OpenOffice.org project, the current API documentation produced by the LO project, and old Sun StarOffice documents (if they are still around). VBA has a whole ecosystem and 20-odd years worth of product pushing around it by people paid to push the platform forward. Although UNO has been around since the days of StarOffice, it has never had that commercial acceptance. Look at UNO, look at the language bindings, decide which is the most appropriate for what you want to do : http://api.libreoffice.org/ http://api.libreoffice.org/docs/common/ref/com/sun/star/sdb/module-ix.html http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbc/module-ix.html http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbcx/module-ix.html http://www.openoffice.org/udk/ I usually check the online API docs (as shown above), inspecting the objects, and I have even bothered to dive into the source code when I was totally befuddled. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic
Greetings Mark, I am puzzled at what you posted in reply to my original message... I was talking about a desktop database as the front-end in a Client/Server application. It appears your question was with using spreadsheets as a database table. Did I not understand something that was intended? Sincerely, -- Michael Lueck Lueck Data Systems http://www.lueckdatasystems.com/ Mark LaPierre wrote: Oops! I meant to send this to the list. This is what I was told when I asked about the capabilities of Base: Le 17/02/2013 02:38, Mark LaPierre a écrit : Hi Mark, Now how do I create non-linked tables inside the same DB? How do I link to another external spreadsheet using the same DB? You would be better off using an external HSQLDB instance to link directly to text tables (note that these would not be Excel files). See the HSQLDB manual for how to do this. http://hsqldb.sourceforge.net/doc/guide/guide.html#texttables-chapter Can I link to only one spreadsheet at a time? In a single ODB file with the embedded hsqldb engine, AFAIK yes. From your email I gather that all tables must be tabs on the one spreadsheet that is linked. Is that a true statement? Seems pretty inconvenient. It is, fairly. But LO Base is not Access, nor FMPro. If you need to work comfortably with and edit multiple separate data sources, using the embedded hsqldb is probably not the best choice. Alex YMMV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted