Re: [libreoffice-users] Where is Base?
On 5 March 2015 at 17:32, SOS s...@pmg.be wrote: Stefan , Macro's can live in any document so also in a Standalone form , better is to place your macro's in the LO application, who makes is fast more easy to Update and distribute for several users as a extension. Just curious, per a good practice, why the macros wouldn't be stored on the server as other db objects (data)? Why in the networked era, user needs to update their clients? We're in post-networked era even. Because Kexi does that by design. But here local file (reliable sqlite3 that -based on reports- almost never crashes for users) is handled in the same way as any server so there are no special cases. Asking because of an intent to harmonize behaviours and approaches. -- regards, Jaroslaw Staniek KDE: : A world-wide network of software engineers, artists, writers, translators : and facilitators committed to Free Software development - http://kde.org Calligra Suite: : A graphic art and office suite - http://calligra.org Kexi: : A visual database apps builder - http://calligra.org/kexi Qt Certified Specialist: : http://www.linkedin.com/in/jstaniek -- 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] Where is Base?
Hi :) Thanks for your support chaps! :) I think the main problem was about HSqlDb being fairly fantastic as a back-end when used as an external back-end, preferably as their latest version from their official website (or your distro's repos or whatever) but any of their versions will do apparently; http://hsqldb.org/ Their 2.3.2 does full multi-threading. The latest version 2.3.2 improves on access and management of very large data sets. It supports up to 270 billion rows of data in a single database and a hot backup capability. Ok, so it seem my thoughts about it being mainly for small, light and very fast databases was a bit off too! I'm not sure how that compares with MySql/MariaDb or Postgresql but it sounds like, as almost always ime, the simplest explanation to cover all available information is not always the truth! HSqlDb seems good for rather large databases after all. Also it sounds as though it is reasonably easy to export a .jar file (or something) from Base, if you are currently using the internal back-end and then just use that in an external version of HSqlDb then that works quite well too apparently. This is something i wish had been clear many years ago!! So the only problem is with continued current usage of the internal back-end but having easy migration routes into external back-ends might help us deal with people's problems MUCH more easily in the future. Does anyone here have a database that does still use the internal back-end? If so is there any chance of experimenting with exporting as some sort of java file with maybe a little help from some of the experts on this mailing list? I would be interested to see how it plays out and whether it really is as easy as has been suggested. Right now my feeling right now is that moving to MySql/MariaDb still has advantages, such as possibly being more widely used and therefore maybe easier to get advice, guidance and maybe even training in. Regards from Tom :) On 5 March 2015 at 17:36, SOS s...@pmg.be wrote: On 5/03/2015 16:04, Stefan Geith wrote: Hi :) I'm working with FilemakerPro since it was available for Windows (1995) for Standalone-Databases. I'm working with PHP and mySql since 1998 and with Typo3 (using PHP and MySql) since 2002. I always used FilemakePro for all kinds of single-user databases, e.g. Address_lists, Invoices, etc. and later (beginning with FileMaker Pro 7.0) I used it as a Frontend for MySql. But unfortunately Filemaker ist not available for Linux, only for Mac+Windows, so some days ago I gave LibreOffice Base (4.4) a try, did some tutorials and now I'm very exited about its possibilites - especially the use of direct mysql-queries (thats not possible with FileMaker). But in LibreOffice Base there are some (in my opinion very important) things missing: 1. I cannot use the internal LibreOffice Database together with an other external (e.g. Mysql-) Database. With Filemaker I often created local (Filemaker-) Databases, containing search-filters (or settings) for the local user that filter the lists of the mySql-Data-Forms. This seems not possible with LO Base. 2. LO Base is missing options to create apps for 'simple' users. Using a LibreOffice Base file is too complicate for many users who simply have to add/edit data. I know, there are standalone-forms, but there are too few possibilities with that (e.g. no Macros). For a 'simple' user, I'd like to have - *one* Window and buttons to switch the content of the window to different forms/reports etc. - a tab-controller element (switching through subforms with tabs) - a script-engine easier to use than macros (see FileMaker how this can be made perfectly) - Security-Settings/User-Rights, so that users cannot destroy their app by mistake This year, I have to create a frontend for a really big MySql-Database (100+ Tables). There is a web-app to browse this data, but for adding/editing data there is no perfect solution yet (This customer uses a php-import-script for his Access-Databses atm...) I would really like to implement this frontent with LO-Base, but I'm afraid I will end up with Filemaker because I can create a more robust tool with it (and also, because I'm used to it since years...) LibreOffice base will bring not real new stuff due to lack of developer interest, but you can perfectly build yourseff a frontend using the API and basic. Keep away from forms and use Dialogs instead. Greetz Fernand I'm curious to see what will be new in the next versions of LibreOffice Base. Regards Stefan P.S.: Maybe I'm wrong with the results of my test and all/some of these options already are possible - if so, please let me know ;) -- 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:
Re: [libreoffice-users] Where is Base?
Stefan , Macro's can live in any document so also in a Standalone form , better is to place your macro's in the LO application, who makes is fast more easy to Update and distribute for several users as a extension. Greetz Fernand Am 05.03.2015 um 16:21 schrieb Peter Goggin: Macros are available from within LibreBase forms. I use them for switching between forms etc, Are Macros also available, if the form is saved as a *standalone form* ? I've heard, that not... Regards, Stefan -- 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] Where is Base?
On 5/03/2015 16:04, Stefan Geith wrote: Hi :) I'm working with FilemakerPro since it was available for Windows (1995) for Standalone-Databases. I'm working with PHP and mySql since 1998 and with Typo3 (using PHP and MySql) since 2002. I always used FilemakePro for all kinds of single-user databases, e.g. Address_lists, Invoices, etc. and later (beginning with FileMaker Pro 7.0) I used it as a Frontend for MySql. But unfortunately Filemaker ist not available for Linux, only for Mac+Windows, so some days ago I gave LibreOffice Base (4.4) a try, did some tutorials and now I'm very exited about its possibilites - especially the use of direct mysql-queries (thats not possible with FileMaker). But in LibreOffice Base there are some (in my opinion very important) things missing: 1. I cannot use the internal LibreOffice Database together with an other external (e.g. Mysql-) Database. With Filemaker I often created local (Filemaker-) Databases, containing search-filters (or settings) for the local user that filter the lists of the mySql-Data-Forms. This seems not possible with LO Base. 2. LO Base is missing options to create apps for 'simple' users. Using a LibreOffice Base file is too complicate for many users who simply have to add/edit data. I know, there are standalone-forms, but there are too few possibilities with that (e.g. no Macros). For a 'simple' user, I'd like to have - *one* Window and buttons to switch the content of the window to different forms/reports etc. - a tab-controller element (switching through subforms with tabs) - a script-engine easier to use than macros (see FileMaker how this can be made perfectly) - Security-Settings/User-Rights, so that users cannot destroy their app by mistake This year, I have to create a frontend for a really big MySql-Database (100+ Tables). There is a web-app to browse this data, but for adding/editing data there is no perfect solution yet (This customer uses a php-import-script for his Access-Databses atm...) I would really like to implement this frontent with LO-Base, but I'm afraid I will end up with Filemaker because I can create a more robust tool with it (and also, because I'm used to it since years...) LibreOffice base will bring not real new stuff due to lack of developer interest, but you can perfectly build yourseff a frontend using the API and basic. Keep away from forms and use Dialogs instead. Greetz Fernand I'm curious to see what will be new in the next versions of LibreOffice Base. Regards Stefan P.S.: Maybe I'm wrong with the results of my test and all/some of these options already are possible - if so, please let me know ;) -- 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] Where is Base?
Am 05.03.2015 um 16:21 schrieb Peter Goggin: Macros are available from within LibreBase forms. I use them for switching between forms etc, Are Macros also available, if the form is saved as a *standalone form* ? I've heard, that not... Regards, Stefan -- 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] Where is Base?
Hi :) I'm working with FilemakerPro since it was available for Windows (1995) for Standalone-Databases. I'm working with PHP and mySql since 1998 and with Typo3 (using PHP and MySql) since 2002. I always used FilemakePro for all kinds of single-user databases, e.g. Address_lists, Invoices, etc. and later (beginning with FileMaker Pro 7.0) I used it as a Frontend for MySql. But unfortunately Filemaker ist not available for Linux, only for Mac+Windows, so some days ago I gave LibreOffice Base (4.4) a try, did some tutorials and now I'm very exited about its possibilites - especially the use of direct mysql-queries (thats not possible with FileMaker). But in LibreOffice Base there are some (in my opinion very important) things missing: 1. I cannot use the internal LibreOffice Database together with an other external (e.g. Mysql-) Database. With Filemaker I often created local (Filemaker-) Databases, containing search-filters (or settings) for the local user that filter the lists of the mySql-Data-Forms. This seems not possible with LO Base. 2. LO Base is missing options to create apps for 'simple' users. Using a LibreOffice Base file is too complicate for many users who simply have to add/edit data. I know, there are standalone-forms, but there are too few possibilities with that (e.g. no Macros). For a 'simple' user, I'd like to have - *one* Window and buttons to switch the content of the window to different forms/reports etc. - a tab-controller element (switching through subforms with tabs) - a script-engine easier to use than macros (see FileMaker how this can be made perfectly) - Security-Settings/User-Rights, so that users cannot destroy their app by mistake This year, I have to create a frontend for a really big MySql-Database (100+ Tables). There is a web-app to browse this data, but for adding/editing data there is no perfect solution yet (This customer uses a php-import-script for his Access-Databses atm...) I would really like to implement this frontent with LO-Base, but I'm afraid I will end up with Filemaker because I can create a more robust tool with it (and also, because I'm used to it since years...) I'm curious to see what will be new in the next versions of LibreOffice Base. Regards Stefan P.S.: Maybe I'm wrong with the results of my test and all/some of these options already are possible - if so, please let me know ;) -- 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] Where is Base?
Hi :) Ahh, i thought it wasn't possible to deselect any of the components in a Windows install. I still doubt that much space is saved so i don't see any particular advantage - except that it makes it more like MS Office bundles that each have different things missing. Regards from Tom :) On 16 February 2015 at 11:21, Stefan Weigel stefan.wei...@bildungskreis.org wrote: Hi, Am 12.02.2015 um 08:55 schrieb pranzar: I just installed 4.4.03 on Windows 7. So did I. I'd like to use Base. I am using Base. When I click on the LibreOffice icon on my desktop, I see a screen with list of buttons on the left under Create. I select Base Database but nothing happens. The only buttons that work are Writer and Calc. What am I doing wrong? Did you unselect some components during installation? http://global.libreoffice.org/assets/Uploads/EN-Project_images/Installation/Windows/435customsetup.png Hav you tried rerunning the installation and selecting all? Greetings, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Where is Base?
Hi, Am 12.02.2015 um 08:55 schrieb pranzar: I just installed 4.4.03 on Windows 7. So did I. I'd like to use Base. I am using Base. When I click on the LibreOffice icon on my desktop, I see a screen with list of buttons on the left under Create. I select Base Database but nothing happens. The only buttons that work are Writer and Calc. What am I doing wrong? Did you unselect some components during installation? http://global.libreoffice.org/assets/Uploads/EN-Project_images/Installation/Windows/435customsetup.png Hav you tried rerunning the installation and selecting all? Greetings, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Where is Base?
Hi all: Would you please open Calc as you can did ? Then in the Menu select please Tools-Options. There select Advance (Option No. 13), there automatic appear JAVA Environment that you have installed in your PC System. Is there nothing appear ... I think is necesary to install JRE 7 or 8 (JAVA Environment) in windows 7 to run BASE of LibreOffice. I hope this help you, Regards, Jorge Rodríguez El jue, 12-02-2015 a las 00:55 -0700, pranzar escribió: Hello. I just installed 4.4.03 on Windows 7. I'd like to use Base. When I click on the LibreOffice icon on my desktop, I see a screen with list of buttons on the left under Create. I select Base Database but nothing happens. The only buttons that work are Writer and Calc. What am I doing wrong? Thanks -- View this message in context: http://nabble.documentfoundation.org/Where-is-Base-tp4139808.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- 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
