Re: [libreoffice-users] Re: Where is Base?
Hi Tom, Well, I'm translating it to brazilian portuguese. I know that there is an libreoffice site available for Brazil, but since my time is really limited, I'd rather to it in my pace than on any time shedule. Anyway, thanks for the tip, I'll have a look at this international list and find out exactly what OmegaT is. At the moment I'm already through half of the introduction chapter. Anyway, as I said im my previous posting, I am very happy in finally finding a manual that really explains Base in an updated software version. At moment I'm using the the TradutorOOoText extension. It has several pitfalls in translating from german to portuguese, but it's quite a help. It sounds that OmegaT is more professional for translations, so I'll contact them and see how I can help. The reason why I'm starting the translation with Base is because I need to build an database to mine some data out of DNA sequences. I was doing it using SQL statement with mysqlworkbench. It was nice, but I wanted to do a more beautiful and user friendly layout and I am not prepared (due to lack of time) to learn an script and HTML languages just to build an GUI for this database. I searched a lot between possibilities which were similar to Filemaker (I've used it a lot before I changed to Opensource), and the two most friendly, in my opinion, where Base and Kexi. Personally, I don't use the portuguese version of LO, I use the english(UK)user interface, because of the help file which does not come with the (USA). For the locale setting I use portuguese (Brazil), well because is where I live. Well, once more thanks for the tip. On Monday 09 March 2015 11:22:55 you wrote: Hi :) The international translator's mailing list is just starting to experiment with translating the Published Guides, such as the Base Handbook, using OmegaT. OmegaT helps in many ways but just one of them is that it seems to track (or identify) what has changed in a newer release of the same guide so that only the changes need to be translated to bring your translation up-to-date. I suspect that they will probably start with the Getting Started with LibreOffice guide, then do the Writer Guide, then the one for Calc and then work through all the rest before ever getting to the Base one(s). If you are alread working on translating the Base Handbook then you would be a huge asset to the translation team of whichever language you are working on. There are a few teams that have worked on translating the guides but it is a struggle, especially until using a decent tool such as OmegaT. The international translators mailing list address is; l...@global.libreoffice.org (capital letters, upper-case and lower-case all get converted to just lower-case by emailing systems so they are only useful for human readers and it really doesn't matter if you get upper and lower case muddled up). Regards from Tom :) On 6 March 2015 at 14:21, Ralf Kersanach dmbr...@furg.br wrote: I guess Andreas is right in all his observations. I'll never expected LO or similars to be an top Databse development front end (although if it would reach filemakers level would be nice). What I expect, as a non IT person, from such kind of platform, is to help me out to delevelop relative simple to medium simple personal and sometimes professional problems without having to learn several programming languages to achive the same through web pages. I have some friends which simply gave up building such DB just because it was to cumberson to learn several different thinks to achieve one purpose only. I thing every tool is a right tool if we keep their limitation in mind and I think Base is in the absolute right direction. After starting to read the 4.4 manual, Tom pointed me out, I got over enthusiastic again, because I saw how much progress the Base team has done (good work folks). I got so enthusiastic that I started to translate it to my native language (as soon I reach some chapter translated I'll make the drafts available). I think that one of the major draw backs of Base and why people isn't using it is the lack of up to date manuals. There more up to date literature and information is available more people can understand power and limitations of base and how to employ it. I know there are some tutorials around, but there more there better so people can see what is possible to do with base. I know the develop and documentation team might be small for this herculean work but as I said before good job folks, the rest comes with time. On Friday 06 March 2015 13:15:13 Andreas Säger wrote: Am 05.03.2015 um 18:36 schrieb SOS: 1. I cannot use 2. LO Base is missing options LibreOffice Base is not a database development platform. It is hardly more than a bridge between databases and office documents. Yes, there is a limited set of form controls and
Re: [libreoffice-users] Re: Where is Base?
Hi :) The international translator's mailing list is just starting to experiment with translating the Published Guides, such as the Base Handbook, using OmegaT. OmegaT helps in many ways but just one of them is that it seems to track (or identify) what has changed in a newer release of the same guide so that only the changes need to be translated to bring your translation up-to-date. I suspect that they will probably start with the Getting Started with LibreOffice guide, then do the Writer Guide, then the one for Calc and then work through all the rest before ever getting to the Base one(s). If you are alread working on translating the Base Handbook then you would be a huge asset to the translation team of whichever language you are working on. There are a few teams that have worked on translating the guides but it is a struggle, especially until using a decent tool such as OmegaT. The international translators mailing list address is; l...@global.libreoffice.org (capital letters, upper-case and lower-case all get converted to just lower-case by emailing systems so they are only useful for human readers and it really doesn't matter if you get upper and lower case muddled up). Regards from Tom :) On 6 March 2015 at 14:21, Ralf Kersanach dmbr...@furg.br wrote: I guess Andreas is right in all his observations. I'll never expected LO or similars to be an top Databse development front end (although if it would reach filemakers level would be nice). What I expect, as a non IT person, from such kind of platform, is to help me out to delevelop relative simple to medium simple personal and sometimes professional problems without having to learn several programming languages to achive the same through web pages. I have some friends which simply gave up building such DB just because it was to cumberson to learn several different thinks to achieve one purpose only. I thing every tool is a right tool if we keep their limitation in mind and I think Base is in the absolute right direction. After starting to read the 4.4 manual, Tom pointed me out, I got over enthusiastic again, because I saw how much progress the Base team has done (good work folks). I got so enthusiastic that I started to translate it to my native language (as soon I reach some chapter translated I'll make the drafts available). I think that one of the major draw backs of Base and why people isn't using it is the lack of up to date manuals. There more up to date literature and information is available more people can understand power and limitations of base and how to employ it. I know there are some tutorials around, but there more there better so people can see what is possible to do with base. I know the develop and documentation team might be small for this herculean work but as I said before good job folks, the rest comes with time. On Friday 06 March 2015 13:15:13 Andreas Säger wrote: Am 05.03.2015 um 18:36 schrieb SOS: 1. I cannot use 2. LO Base is missing options LibreOffice Base is not a database development platform. It is hardly more than a bridge between databases and office documents. Yes, there is a limited set of form controls and yes, it comes with macro languages anyway. The core functionality is built around the ODF standard. Database connectivity is a *simple* give-away which can be used in various ways, mainly to fill ODF documents with external data. Filemaker and Access are a completely different category. -- 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: Where is Base?
Hi :) The main man to chat with about OmegaT is Milos errr, i dunno his surname! :( He has done a huge amount of work with them to set-up something for LibreOffice. It is good that you started translating by starting on the Base Handbook. It means you really can work at your own pace because i seriously doubt anyone else is working on it. As you point out it is a good thing to work on but i think people tend to be a bit scared of database programs generally (probably thanks to needless complexity that Access exposes normal users to far too early). On this mailing list we found that it was after the Faq section about Base and the first chapter of the Base Guide were both completed that there were suddenly a lot more threads discussing Base. It led to a resurgence of interest with people joining in and getting to know it and even becoming devs for it. Errr, i guess i should have mentioned that there is a more up-to-date version of the Handbook available through the Documentation Team (extremely low-traffic mailing list at the moment) - but they would have to register you at ODFauthors for you to get at the pre-released version of the 4.2.x version. Regards from Tom :) On 9 March 2015 at 13:34, Ralf Kersanach dmbr...@furg.br wrote: Hi Tom, Well, I'm translating it to brazilian portuguese. I know that there is an libreoffice site available for Brazil, but since my time is really limited, I'd rather to it in my pace than on any time shedule. Anyway, thanks for the tip, I'll have a look at this international list and find out exactly what OmegaT is. At the moment I'm already through half of the introduction chapter. Anyway, as I said im my previous posting, I am very happy in finally finding a manual that really explains Base in an updated software version. At moment I'm using the the TradutorOOoText extension. It has several pitfalls in translating from german to portuguese, but it's quite a help. It sounds that OmegaT is more professional for translations, so I'll contact them and see how I can help. The reason why I'm starting the translation with Base is because I need to build an database to mine some data out of DNA sequences. I was doing it using SQL statement with mysqlworkbench. It was nice, but I wanted to do a more beautiful and user friendly layout and I am not prepared (due to lack of time) to learn an script and HTML languages just to build an GUI for this database. I searched a lot between possibilities which were similar to Filemaker (I've used it a lot before I changed to Opensource), and the two most friendly, in my opinion, where Base and Kexi. Personally, I don't use the portuguese version of LO, I use the english(UK)user interface, because of the help file which does not come with the (USA). For the locale setting I use portuguese (Brazil), well because is where I live. Well, once more thanks for the tip. On Monday 09 March 2015 11:22:55 you wrote: Hi :) The international translator's mailing list is just starting to experiment with translating the Published Guides, such as the Base Handbook, using OmegaT. OmegaT helps in many ways but just one of them is that it seems to track (or identify) what has changed in a newer release of the same guide so that only the changes need to be translated to bring your translation up-to-date. I suspect that they will probably start with the Getting Started with LibreOffice guide, then do the Writer Guide, then the one for Calc and then work through all the rest before ever getting to the Base one(s). If you are alread working on translating the Base Handbook then you would be a huge asset to the translation team of whichever language you are working on. There are a few teams that have worked on translating the guides but it is a struggle, especially until using a decent tool such as OmegaT. The international translators mailing list address is; l...@global.libreoffice.org (capital letters, upper-case and lower-case all get converted to just lower-case by emailing systems so they are only useful for human readers and it really doesn't matter if you get upper and lower case muddled up). Regards from Tom :) On 6 March 2015 at 14:21, Ralf Kersanach dmbr...@furg.br wrote: I guess Andreas is right in all his observations. I'll never expected LO or similars to be an top Databse development front end (although if it would reach filemakers level would be nice). What I expect, as a non IT person, from such kind of platform, is to help me out to delevelop relative simple to medium simple personal and sometimes professional problems without having to learn several programming languages to achive the same through web pages. I have some friends which simply gave up building such DB just because it was to cumberson to learn several different thinks to achieve one purpose only. I thing every tool is
Re: [libreoffice-users] Re: Where is Base?
Hi Tom, just for your information, the german Base manual is for version 4.4 of LO, in other words hot new. Well at least is what is claimed on their table where they list all manuals they have for Base (from 3.5 to 4.4). And best of all it is complete (up to chapter 11 and there are also two database example versions - with and without comments). Oh, thanks for the OmegaT contact, I'll surely will contact him. I've alredy looked in the address you sent me, but haven't spent much time on it. Ralf On Monday 09 March 2015 16:46:29 Tom Davies wrote: Hi :) The main man to chat with about OmegaT is Milos errr, i dunno his surname! :( He has done a huge amount of work with them to set-up something for LibreOffice. It is good that you started translating by starting on the Base Handbook. It means you really can work at your own pace because i seriously doubt anyone else is working on it. As you point out it is a good thing to work on but i think people tend to be a bit scared of database programs generally (probably thanks to needless complexity that Access exposes normal users to far too early). On this mailing list we found that it was after the Faq section about Base and the first chapter of the Base Guide were both completed that there were suddenly a lot more threads discussing Base. It led to a resurgence of interest with people joining in and getting to know it and even becoming devs for it. Errr, i guess i should have mentioned that there is a more up-to-date version of the Handbook available through the Documentation Team (extremely low-traffic mailing list at the moment) - but they would have to register you at ODFauthors for you to get at the pre-released version of the 4.2.x version. Regards from Tom :) On 9 March 2015 at 13:34, Ralf Kersanach dmbr...@furg.br wrote: Hi Tom, Well, I'm translating it to brazilian portuguese. I know that there is an libreoffice site available for Brazil, but since my time is really limited, I'd rather to it in my pace than on any time shedule. Anyway, thanks for the tip, I'll have a look at this international list and find out exactly what OmegaT is. At the moment I'm already through half of the introduction chapter. Anyway, as I said im my previous posting, I am very happy in finally finding a manual that really explains Base in an updated software version. At moment I'm using the the TradutorOOoText extension. It has several pitfalls in translating from german to portuguese, but it's quite a help. It sounds that OmegaT is more professional for translations, so I'll contact them and see how I can help. The reason why I'm starting the translation with Base is because I need to build an database to mine some data out of DNA sequences. I was doing it using SQL statement with mysqlworkbench. It was nice, but I wanted to do a more beautiful and user friendly layout and I am not prepared (due to lack of time) to learn an script and HTML languages just to build an GUI for this database. I searched a lot between possibilities which were similar to Filemaker (I've used it a lot before I changed to Opensource), and the two most friendly, in my opinion, where Base and Kexi. Personally, I don't use the portuguese version of LO, I use the english(UK)user interface, because of the help file which does not come with the (USA). For the locale setting I use portuguese (Brazil), well because is where I live. Well, once more thanks for the tip. On Monday 09 March 2015 11:22:55 you wrote: Hi :) The international translator's mailing list is just starting to experiment with translating the Published Guides, such as the Base Handbook, using OmegaT. OmegaT helps in many ways but just one of them is that it seems to track (or identify) what has changed in a newer release of the same guide so that only the changes need to be translated to bring your translation up-to-date. I suspect that they will probably start with the Getting Started with LibreOffice guide, then do the Writer Guide, then the one for Calc and then work through all the rest before ever getting to the Base one(s). If you are alread working on translating the Base Handbook then you would be a huge asset to the translation team of whichever language you are working on. There are a few teams that have worked on translating the guides but it is a struggle, especially until using a decent tool such as OmegaT. The international translators mailing list address is; l...@global.libreoffice.org (capital letters, upper-case and lower-case all get converted to just lower-case by emailing systems so they are only useful for human readers and it really doesn't matter if you get upper and lower case muddled up). Regards from Tom :) On 6 March 2015 at 14:21,
Re: [libreoffice-users] Re: Where is Base?
Hi :) Yes, the German version is the original. There has been some very brief discussion about whether all the different example databases are really necessary or if some could be left out or if they could be consolidated or something. It might be better to have a separate document with tons of examples in rather than expecting all translators to translate several different databases just to make 1 or 2 points. If that is possible then it might unblock the English translations! Regards from Tom :) On 9 March 2015 at 19:49, Ralf Kersanach dmbr...@furg.br wrote: Hi Tom, just for your information, the german Base manual is for version 4.4 of LO, in other words hot new. Well at least is what is claimed on their table where they list all manuals they have for Base (from 3.5 to 4.4). And best of all it is complete (up to chapter 11 and there are also two database example versions - with and without comments). Oh, thanks for the OmegaT contact, I'll surely will contact him. I've alredy looked in the address you sent me, but haven't spent much time on it. Ralf On Monday 09 March 2015 16:46:29 Tom Davies wrote: Hi :) The main man to chat with about OmegaT is Milos errr, i dunno his surname! :( He has done a huge amount of work with them to set-up something for LibreOffice. It is good that you started translating by starting on the Base Handbook. It means you really can work at your own pace because i seriously doubt anyone else is working on it. As you point out it is a good thing to work on but i think people tend to be a bit scared of database programs generally (probably thanks to needless complexity that Access exposes normal users to far too early). On this mailing list we found that it was after the Faq section about Base and the first chapter of the Base Guide were both completed that there were suddenly a lot more threads discussing Base. It led to a resurgence of interest with people joining in and getting to know it and even becoming devs for it. Errr, i guess i should have mentioned that there is a more up-to-date version of the Handbook available through the Documentation Team (extremely low-traffic mailing list at the moment) - but they would have to register you at ODFauthors for you to get at the pre-released version of the 4.2.x version. Regards from Tom :) On 9 March 2015 at 13:34, Ralf Kersanach dmbr...@furg.br wrote: Hi Tom, Well, I'm translating it to brazilian portuguese. I know that there is an libreoffice site available for Brazil, but since my time is really limited, I'd rather to it in my pace than on any time shedule. Anyway, thanks for the tip, I'll have a look at this international list and find out exactly what OmegaT is. At the moment I'm already through half of the introduction chapter. Anyway, as I said im my previous posting, I am very happy in finally finding a manual that really explains Base in an updated software version. At moment I'm using the the TradutorOOoText extension. It has several pitfalls in translating from german to portuguese, but it's quite a help. It sounds that OmegaT is more professional for translations, so I'll contact them and see how I can help. The reason why I'm starting the translation with Base is because I need to build an database to mine some data out of DNA sequences. I was doing it using SQL statement with mysqlworkbench. It was nice, but I wanted to do a more beautiful and user friendly layout and I am not prepared (due to lack of time) to learn an script and HTML languages just to build an GUI for this database. I searched a lot between possibilities which were similar to Filemaker (I've used it a lot before I changed to Opensource), and the two most friendly, in my opinion, where Base and Kexi. Personally, I don't use the portuguese version of LO, I use the english(UK)user interface, because of the help file which does not come with the (USA). For the locale setting I use portuguese (Brazil), well because is where I live. Well, once more thanks for the tip. On Monday 09 March 2015 11:22:55 you wrote: Hi :) The international translator's mailing list is just starting to experiment with translating the Published Guides, such as the Base Handbook, using OmegaT. OmegaT helps in many ways but just one of them is that it seems to track (or identify) what has changed in a newer release of the same guide so that only the changes need to be translated to bring your translation up-to-date. I suspect that they will probably start with the Getting Started with LibreOffice guide, then do the Writer Guide, then the one for Calc and then work through all the rest before ever getting to the Base one(s). If you are alread working
Re: [libreoffice-users] Re: Where is Base?
I guess Andreas is right in all his observations. I'll never expected LO or similars to be an top Databse development front end (although if it would reach filemakers level would be nice). What I expect, as a non IT person, from such kind of platform, is to help me out to delevelop relative simple to medium simple personal and sometimes professional problems without having to learn several programming languages to achive the same through web pages. I have some friends which simply gave up building such DB just because it was to cumberson to learn several different thinks to achieve one purpose only. I thing every tool is a right tool if we keep their limitation in mind and I think Base is in the absolute right direction. After starting to read the 4.4 manual, Tom pointed me out, I got over enthusiastic again, because I saw how much progress the Base team has done (good work folks). I got so enthusiastic that I started to translate it to my native language (as soon I reach some chapter translated I'll make the drafts available). I think that one of the major draw backs of Base and why people isn't using it is the lack of up to date manuals. There more up to date literature and information is available more people can understand power and limitations of base and how to employ it. I know there are some tutorials around, but there more there better so people can see what is possible to do with base. I know the develop and documentation team might be small for this herculean work but as I said before good job folks, the rest comes with time. On Friday 06 March 2015 13:15:13 Andreas Säger wrote: Am 05.03.2015 um 18:36 schrieb SOS: 1. I cannot use 2. LO Base is missing options LibreOffice Base is not a database development platform. It is hardly more than a bridge between databases and office documents. Yes, there is a limited set of form controls and yes, it comes with macro languages anyway. The core functionality is built around the ODF standard. Database connectivity is a *simple* give-away which can be used in various ways, mainly to fill ODF documents with external data. Filemaker and Access are a completely different category. -- 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: Where is Base?
Am 05.03.2015 um 18:36 schrieb SOS: 1. I cannot use 2. LO Base is missing options LibreOffice Base is not a database development platform. It is hardly more than a bridge between databases and office documents. Yes, there is a limited set of form controls and yes, it comes with macro languages anyway. The core functionality is built around the ODF standard. Database connectivity is a *simple* give-away which can be used in various ways, mainly to fill ODF documents with external data. Filemaker and Access are a completely different category. -- 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: Where is Base?
Am 06.03.2015 um 16:06 schrieb Jaroslaw Staniek: 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. Because we are talking about office macros. An office macro is stored in the user profle, in the install directory or in an office document. What you have up and running on your server is a database. The office suite and the database are 2 completely separate things. The database accepts requests and returns requested record sets without knowing any of your queries, forms, reports and macros. It accepts the exact same requests from your web server returning the exact same record sets without knowing anyting about your web server, script language or the client's browser. -- 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: Where is Base?
On 6 March 2015 at 19:32, Andreas Säger ville...@t-online.de wrote: Am 06.03.2015 um 16:06 schrieb Jaroslaw Staniek: 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. Because we are talking about office macros. An office macro is stored in the user profle, in the install directory or in an office document. Thanks for sharing the perspective. I'll explain the simple logic that's a building block of data-oriented environments such as Kexi. Macro in LO is an equivalent of an MS Access module, which is stored in database, just like in Kexi. It's also an equivalent of a stored procedure, which is stored in a database, and in addition execution engine usually happens to be bundled in the same product database and can be controlled using the same channel as data, structure and triggers are controlled. (Sorry if I am writing this under the eyes of seasoned (real) db users but still I hope it will be useful to someone) I don't need to mention that sharing authentication rules and transmission channels with the database engine is beneficial for security. Compare that to storing code in home directory, enabled for free modification. What you have up and running on your server is a database. The office suite and the database are 2 completely separate things. The database accepts requests and returns requested record sets without knowing any of your queries, forms, reports and macros. It accepts the exact same requests from your web server returning the exact same record sets without knowing anyting about your web server, script language or the client's browser. True, just like the database does not know that a NAME column's semantics is person's name. It's the one or two upper layer(s) of your architecture that implement the semantics. Scripts/macros/forms/reports/query statements and everything else are strings perfectly stored. Just like your bash scripts in a file system. They are programs, stored as arrays of characters, without any knowledge what's inside. From that perspective, database is a storage medium, just like a file system, with a different feature set. For executing it you need an execution engine (javascript or python or a clone of VB, etc.) and an execution context. Execution in an environment itself calls a process call into being. Ability of handling _programs_ on the server side is irrelevant to ability of properly storing (textual, or binary) definition of _macros_ and offering them to clients for retrieval, maybe versioning, and protecting the access. -- 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
[libreoffice-users] Re: Where is Base?
Tom, It is too obvious that you never use LibreOffice Base. -- 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: Where is Base?
Am 05.03.2015 um 19:38 schrieb Andreas Säger: Am 05.03.2015 um 16:46 schrieb Stefan Geith: 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 Why not? Of course they are. You can store the code in the form document or in the global container just like any other office macro. You can check this out within a minute. Create a Bibliography form on an arbitrary Calc, Writer or Draw document. Add some control and point some control change event or some form navigation event to a MsgBox(Hello). -- 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: Where is Base?
Regarding the interface to the big irons: Base can not handle arrays field types. Base can not handle binary field types. It crashes (possibly losing the embedded database) when you load a form with many records having pictures (normal size as in typical photos). Form grids become unusable when you load some thousand records from a calculated record set. All sorts of arbitrary complicated filtering can be done by means of filter forms bound to filter tables (search the AOO forum for the term power filtering). Since many years this has been a nice but clumsy work-around for all Base users. It lets you implement a desparately missing feature on your own. It lets you enter filter criteria (contrary to table data) directly into your form. Personally, I find the built-in form based filter not too bad. Indeed, macros are not an option. Writing macros is highly unproductive. The useful ones are contained in the Access2Base extension. -- 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: Where is Base?
Just want to say this thread has been so helpful and enlightening, I have learned a lot about base, mysql and databases. Tom, thanks for all your input! Howard On 5 Mar 2015 21:29, Tom Davies tomc...@gmail.com wrote: Hi :) I have been told, off-list, that i am quite wrong about what i have been saying about Base. I'm not clear exactly which bits of what i have said are wrong. Almost all of what i said was things i had picked-up from experts on this mailing list or discussions elsewhere, rather than from my own direct experience or knowledge of the issues. It would be nice to know where i am wrong to help me be less wrong in the future! Also it would be good for such corrections to be in this thread if possible because it has been a really good thread with a lot of good feedback about different people's knowledge and experience. Finally if i have given people a wrong impression about Base then it would be nice to be able to fix that. Regards from Tom :) On 4 March 2015 at 16:40, Tom Davies tomc...@gmail.com wrote: Hi :) Yeh, in attempting to clarify i did add an extra confusion! Sorry! The HsqlDb version 1.8 is only a problem when using the internal version in Base. However Base doesn't give you much choice about what to use as the internal back-end. Just the heavily tweaked and broken version of 1.8. Regards from Tom :) On 4 March 2015 at 10:58, Andreas Säger ville...@t-online.de wrote: Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- 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 -- 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: Where is Base?
Hello again, As was mentioned in a reply to one of my remarks: Yes, there are a number of things missing in the LO-Front end to databases: Just ONE little thing eg.: When selecting tuples using the standard filter, the selection criteria (max 3 in number) are too restricted. Like -- eg. if I want to select tuples, where ((fielda = x or fielda = y) and fieldb = z) I cannot specify this (no parenthesis capability!). This kind of filter is naturally possible when accessing MySQL through phpMyAdmin. But then, it is not a big issue to quickly create a view using native SQL. So, while I would like to have this capability, it doesn't really prevent me from using LO-Base. On the other hand, trying to build a REAL application system using LO-Base and (eg.) Basic Macros and Forms is not really a choice. I suppose that M$-Access isn't fit to handle this kind of requirements either. For this kind of system I am looking at frameworks such as Symfony2 at the moment. Keep up the good work! Heinrich Ian Whitfield schrieb: .Ditto!!! +1 It has cemented the decision I took last year to move to Base+MySQL - which works very well indeed!! IanW Pretoria RSA On 03/05/2015 04:08 PM, HBarr wrote: Just want to say this thread has been so helpful and enlightening, I have learned a lot about base, mysql and databases. Tom, thanks for all your input! Howard On 5 Mar 2015 21:29, Tom Davies tomc...@gmail.com wrote: Hi :) I have been told, off-list, that i am quite wrong about what i have been saying about Base. I'm not clear exactly which bits of what i have said are wrong. Almost all of what i said was things i had picked-up from experts on this mailing list or discussions elsewhere, rather than from my own direct experience or knowledge of the issues. It would be nice to know where i am wrong to help me be less wrong in the future! Also it would be good for such corrections to be in this thread if possible because it has been a really good thread with a lot of good feedback about different people's knowledge and experience. Finally if i have given people a wrong impression about Base then it would be nice to be able to fix that. Regards from Tom :) On 4 March 2015 at 16:40, Tom Davies tomc...@gmail.com wrote: Hi :) Yeh, in attempting to clarify i did add an extra confusion! Sorry! The HsqlDb version 1.8 is only a problem when using the internal version in Base. However Base doesn't give you much choice about what to use as the internal back-end. Just the heavily tweaked and broken version of 1.8. Regards from Tom :) On 4 March 2015 at 10:58, Andreas Säger ville...@t-online.de wrote: Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- 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 -- 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: Where is Base?
Am 05.03.2015 um 16:46 schrieb Stefan Geith: 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 Why not? Of course they are. You can store the code in the form document or in the global container just like any other office macro. -- 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: Where is Base?
Ditto!!! +1 It has cemented the decision I took last year to move to Base+MySQL - which works very well indeed!! IanW Pretoria RSA On 03/05/2015 04:08 PM, HBarr wrote: Just want to say this thread has been so helpful and enlightening, I have learned a lot about base, mysql and databases. Tom, thanks for all your input! Howard On 5 Mar 2015 21:29, Tom Davies tomc...@gmail.com wrote: Hi :) I have been told, off-list, that i am quite wrong about what i have been saying about Base. I'm not clear exactly which bits of what i have said are wrong. Almost all of what i said was things i had picked-up from experts on this mailing list or discussions elsewhere, rather than from my own direct experience or knowledge of the issues. It would be nice to know where i am wrong to help me be less wrong in the future! Also it would be good for such corrections to be in this thread if possible because it has been a really good thread with a lot of good feedback about different people's knowledge and experience. Finally if i have given people a wrong impression about Base then it would be nice to be able to fix that. Regards from Tom :) On 4 March 2015 at 16:40, Tom Davies tomc...@gmail.com wrote: Hi :) Yeh, in attempting to clarify i did add an extra confusion! Sorry! The HsqlDb version 1.8 is only a problem when using the internal version in Base. However Base doesn't give you much choice about what to use as the internal back-end. Just the heavily tweaked and broken version of 1.8. Regards from Tom :) On 4 March 2015 at 10:58, Andreas Säger ville...@t-online.de wrote: Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- 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 -- -- 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: Where is Base?
Hi :) I have been told, off-list, that i am quite wrong about what i have been saying about Base. I'm not clear exactly which bits of what i have said are wrong. Almost all of what i said was things i had picked-up from experts on this mailing list or discussions elsewhere, rather than from my own direct experience or knowledge of the issues. It would be nice to know where i am wrong to help me be less wrong in the future! Also it would be good for such corrections to be in this thread if possible because it has been a really good thread with a lot of good feedback about different people's knowledge and experience. Finally if i have given people a wrong impression about Base then it would be nice to be able to fix that. Regards from Tom :) On 4 March 2015 at 16:40, Tom Davies tomc...@gmail.com wrote: Hi :) Yeh, in attempting to clarify i did add an extra confusion! Sorry! The HsqlDb version 1.8 is only a problem when using the internal version in Base. However Base doesn't give you much choice about what to use as the internal back-end. Just the heavily tweaked and broken version of 1.8. Regards from Tom :) On 4 March 2015 at 10:58, Andreas Säger ville...@t-online.de wrote: Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- 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: Where is Base?
Hi :) Yeh, in attempting to clarify i did add an extra confusion! Sorry! The HsqlDb version 1.8 is only a problem when using the internal version in Base. However Base doesn't give you much choice about what to use as the internal back-end. Just the heavily tweaked and broken version of 1.8. Regards from Tom :) On 4 March 2015 at 10:58, Andreas Säger ville...@t-online.de wrote: Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- 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: Where is Base?
Hello Noel, Interesting! I will have a look at H2. The only issue for me at the moment is that my provider has not got it installed and therefore I cannot use it. Regards from Salzburg Heinz Marion Noel Lodge schrieb: Hi Heinrich, I've been reluctant to join this discussion, but you comment about the need to have ... a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) ..., has prompted me to say that I believe one such database already exists - it is called H2. See - http://www.h2database.com/html/main.html. Some will perhaps reject it out of hand, because it is Java based. However it has a vibrant user base and from comments on the user group, some are using H2 for very large databases. A year or so ago one user was complaining that H2 was slowing down after his application passed the 1 billion record mark! In reply, he received several suggestions as to how he might over come his problem. I have migrated 6 databases from HSQL 1.8, (the largest having nearly 35,000 records - which I realise, is still quite small), but I have found that H2 works well for me. There was a bit of work involved with the migration, but H2 tables can be designed in LibreOffice and the process went pretty smoothly. Perhaps the only drawback is that once tables have been designed, they can be altered only using SQL commands. But I guess most users who want an industrial strength database, would already be literate in SQL. My 2c worth, Noel -- Noel Lodge lodg...@gmail.com On 4 March 2015 at 05:56, Heinrich Stöllinger hc.stoellin...@aon.at wrote: Hello, I am an old DB-User in the real sense of the word (I am over 70!). In the 90ies I got into DB2 as a systems engineer at IBM. Then, around the turn of the millenium, I set up a database for the administration of a 50-piece wind band, using Lotus-Approach (DBase...). It was fine but I wanted to go Open Software and - when stumbling onto StarOffice/OpenOffice and Base - it was clear to me to go for that scene. Since then I have been using MySQL as external back-end and must say I am more than happy with it. My DB consists of some 80 interconnected tables/views with record numbers up to around 40.000. This is handled perfectly fine by MySQL (maybe MariaDB in the near future!). Of course - as an old DB-guy I have no qualms about using the command-line mysql client directly for doing things like defining DBs, tables, views, foreign keys etc. Therefore, if there are any limitations in the LO-front end, it is o.k. for me. I do feel strongly though, that if we ever want LO to become a REALLY important player (especially within the business world!), a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) will have to be implemented. Internal, integrated backends are o.k. for playing around but NOT for mission-critical, large-scale operations. Regards Heinz Tom Davies schrieb: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we
Re: [libreoffice-users] Re: Where is Base?
Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. People using HsqlDb as an external back-end would have been pushed into upgrading many times in the last decade or so. Not upgrading would have been a lot like sticking with Win98. So i believe it was the move to a more modern version of a database program that gave Noel the fantastic improvements he experienced. Java-based back-ends do have a reputation for being much faster for the relatively small databases that most of us probably use. The one with 1 billion records might well find that moving to something heftier such as Postgresql or MySql/MariaDb does the trick. Although there might be some performance advantages to moving from the heftier back-ends to the smallerfaster ones there are several disadvantages around doing the move. Internet facing Servers using LAMP or WAMP and web-hosting companies tend to already have MySql/MariaDb (hence the M i think) so it'd be a bit like installing a different Office Suite for each document rather than trying to stick with just 1 or 2. Regards from Tom :) On 4 March 2015 at 08:53, Heinrich Stöllinger hc.stoellin...@aon.at wrote: Hello Noel, Interesting! I will have a look at H2. The only issue for me at the moment is that my provider has not got it installed and therefore I cannot use it. Regards from Salzburg Heinz Marion Noel Lodge schrieb: Hi Heinrich, I've been reluctant to join this discussion, but you comment about the need to have ... a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) ..., has prompted me to say that I believe one such database already exists - it is called H2. See - http://www.h2database.com/html/main.html. Some will perhaps reject it out of hand, because it is Java based. However it has a vibrant user base and from comments on the user group, some are using H2 for very large databases. A year or so ago one user was complaining that H2 was slowing down after his application passed the 1 billion record mark! In reply, he received several suggestions as to how he might over come his problem. I have migrated 6 databases from HSQL 1.8, (the largest having nearly 35,000 records - which I realise, is still quite small), but I have found that H2 works well for me. There was a bit of work involved with the migration, but H2 tables can be designed in LibreOffice and the process went pretty smoothly. Perhaps the only drawback is that once tables have been designed, they can be altered only using SQL commands. But I guess most users who want an industrial strength database, would already be literate in SQL. My 2c worth, Noel -- Noel Lodge lodg...@gmail.com On 4 March 2015 at 05:56, Heinrich Stöllinger hc.stoellin...@aon.at wrote: Hello, I am an old DB-User in the real sense of the word (I am over 70!). In the 90ies I got into DB2 as a systems engineer at IBM. Then, around the turn of the millenium, I set up a database for the administration of a 50-piece wind band, using Lotus-Approach (DBase...). It was fine but I wanted to go Open Software and - when stumbling onto StarOffice/OpenOffice and Base - it was clear to me to go for that scene. Since then I have been using MySQL as external back-end and must say I am more than happy with it. My DB consists of some 80 interconnected tables/views with record numbers up to around 40.000. This is handled perfectly fine by MySQL (maybe MariaDB in the near future!). Of course - as an old DB-guy I have no qualms about using the command-line mysql client directly for doing things like defining DBs, tables, views, foreign keys etc. Therefore, if there are any limitations in the LO-front end, it is o.k. for me. I do feel strongly though, that if we ever want LO to become a REALLY important player (especially within the business world!), a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) will have to be implemented. Internal, integrated backends are o.k. for playing around but NOT for mission-critical, large-scale operations. Regards Heinz Tom Davies schrieb: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the
Re: [libreoffice-users] Re: Where is Base?
Hi :) One point that may have become muddled in translation is that it is only the front-end that needs to be copied, or re-created on multiple machines. The stable back-end could be on a server so that everyone is using the same data. As one person adds data everyone else would be able to see that data on their various machines. So Base is a LOT more scalable much more easily than Access. On a single machine you probably keep the back-end on the same machine as the front-end. If other machines get added then they just share that same back-end. As the company grows and eventually needs it's own internal server that back-end might get moved to that server but all the front-ends on all the different machines still keep using that same back-end even though it's been moved. Hopefully Base can even connect to back-ends hosted on WANs rather than just LANs and even on remotely hosted websites and Clouds. Regards from Tom :) On 3 March 2015 at 18:28, Andreas Säger ville...@t-online.de wrote: Am 03.03.2015 um 16:06 schrieb Peter Goggin: Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin My first medium complex project with input forms to collect daily job data used the embedded DB as well. It worked flawlessly. But the most important preconditions is that you really do your backup every time after closing the connection. Nevertheless, there are far too many reports about complete data loss. Meanwhile it is very easy to split a self-contained Base document into a frontend and a stable backend which can be distributed and installed on multiple machines with a tiny little bit of extra effort. Apart from keeping your data safe and warm, HSQL 2.3 provides a lot more features than HSQL 1.8. -- 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: Where is Base?
Hello Tom... Maybe I misunderstand your remark below, but... My database has for years been on a WAN-accessed MySQL server. This is only an issue resolved through DNS or the hosts file . I haven't experienced any difficulties/problems either in defining the database, loading or backing up data to my local machine (either through phpMyAdmin or the native command-line client). The only issue I have at this time is that scrolling through tables/views under LO tends to be slow. I'll have to look at that... Regards Heinz Tom Davies schrieb: Hopefully Base can even connect to back-ends hosted on WANs rather than just LANs and even on remotely hosted websites and Clouds. -- 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: Where is Base?
On 4 March 2015 at 11:25, Tom Davies tomc...@gmail.com wrote: Hi :) One point that may have become muddled in translation is that it is only the front-end that needs to be copied, or re-created on multiple machines. The stable back-end could be on a server so that everyone is using the same data. As one person adds data everyone else would be able to see that data on their various machines. Everyone can have the same frontend too (so it's keep updated) if its definition resides on the server side. Not necessarily in the same db instance or even db type. That's the way of Kexi even if only local SQLite instances are used. All combinations possible: local data + shared frontend, shared data + local frontend, everything shared, nothing shared. This is an entry point to the cloud infra. Without this, splited database with local frontend sounds still very Access way no matter how we criticize it. Also and idea, for a higher level operation is based on 3-tier architecture where users have access to business logic and not to physical database instances. Reasons being: reliability, maintainability and security. -- 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
[libreoffice-users] Re: Where is Base?
Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- 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: Where is Base?
Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin -- 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: Where is Base?
Hi :) I don't see this thread as having been entirely negative at all! Base is pretty fantastic despite having so few devs and being the most unpopular module/program to work on out of the whole suite. The devs who are working on it are fantastic and heroic imo. The only real problems are when people try to use Base in the way they would use Access. Access does quite a lot of very dodgy things that most database programs steer well away from. For a start having the front-end and the back-end as 1 file is just asking for trouble for reasons which i am not quite clear on but has been described in previous threads. My pet hate is that normal users are presented with the unfamiliar interface. So even if they just want to browse through records they kinda need training and that training usually involves just how to design, create and build a new database rather just how to flick through records. Even with training it is all to easy for normal users to accidentally (or otherwise) make a hideous mess of things. The contacts database at my work-place was such a hideous mess that even printing address labels was practically impossible. I didn't have time to go through all the hundreds of badly named Queries to make any sense of them so i was never sure which could be deleted and which were crucial. So i had to make yet another new one in order to avoid getting bogged down for days in a fairly simple task. When i got back to the database a week later someone had renamed my Query and the Report so i had to do a bit of detective work to find them again. Nowadays no-one uses that database at all. The company has lost track of tons of contacts who may or may not have been useful. Nowadays we use a simple csv to track only the email addresses and we no longer do mail-outs at all. Base neatly avoid ALL that can be neatly avoided by using Writer or Calc to create Reports or Forms so that people who are not into building and designing databases are safely in familiar programs/modules. So normal users can still do simple edits, such as correcting spellings or changing the company letterhead and such-like but they do so in a familiar environment without having to learn tons of stuff they will probably never need. They can even create new documents based on the existing ones. At no point would they accidentally find themselves in Desgn views or accidentally creating Queries. So for me Base, Kexi and pretty much everything non-Microsoft has huge time-saving advantages! Regards from Tom :) On 3 March 2015 at 15:06, Peter Goggin petergog...@bigpond.com wrote: Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin -- 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: Where is Base?
Hi :) Oops!! Sorry for the rant! Also the tpyos in the 5th paragraph! (4th from the end!). I should have deleted some of it (or the whole email tbh) down to; Base neatly avoids ALL that nightmare by allowing database-designers to use Writer or Calc to create Reports or Forms so that people who are not into building and designing databases are safely in familiar programs/modules. Apols and regards from Tom :) On 3 March 2015 at 16:01, Tom Davies tomc...@gmail.com wrote: Hi :) I don't see this thread as having been entirely negative at all! Base is pretty fantastic despite having so few devs and being the most unpopular module/program to work on out of the whole suite. The devs who are working on it are fantastic and heroic imo. The only real problems are when people try to use Base in the way they would use Access. Access does quite a lot of very dodgy things that most database programs steer well away from. For a start having the front-end and the back-end as 1 file is just asking for trouble for reasons which i am not quite clear on but has been described in previous threads. My pet hate is that normal users are presented with the unfamiliar interface. So even if they just want to browse through records they kinda need training and that training usually involves just how to design, create and build a new database rather just how to flick through records. Even with training it is all to easy for normal users to accidentally (or otherwise) make a hideous mess of things. The contacts database at my work-place was such a hideous mess that even printing address labels was practically impossible. I didn't have time to go through all the hundreds of badly named Queries to make any sense of them so i was never sure which could be deleted and which were crucial. So i had to make yet another new one in order to avoid getting bogged down for days in a fairly simple task. When i got back to the database a week later someone had renamed my Query and the Report so i had to do a bit of detective work to find them again. Nowadays no-one uses that database at all. The company has lost track of tons of contacts who may or may not have been useful. Nowadays we use a simple csv to track only the email addresses and we no longer do mail-outs at all. Base neatly avoid ALL that can be neatly avoided by using Writer or Calc to create Reports or Forms so that people who are not into building and designing databases are safely in familiar programs/modules. So normal users can still do simple edits, such as correcting spellings or changing the company letterhead and such-like but they do so in a familiar environment without having to learn tons of stuff they will probably never need. They can even create new documents based on the existing ones. At no point would they accidentally find themselves in Desgn views or accidentally creating Queries. So for me Base, Kexi and pretty much everything non-Microsoft has huge time-saving advantages! Regards from Tom :) On 3 March 2015 at 15:06, Peter Goggin petergog...@bigpond.com wrote: Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin -- 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: Where is Base?
Hi :) I am not quite sure what level of co-operation you are asking for. There is always a potential for more, of course. At the moment, and hopefully on into the future, they are independent of each other and each has their own advantages and peculiar quirks. They gain the advantages of competition while being able to co-operate too. Both have far too few devs imo but the devs in both are pretty heroic. More devs in either or both might make things interesting. :) At the moment both can connect to a wide range of back-ends. Also both could be front-ends for the same back-end. Creating 2 different front-ends might be annoying but it seems to be very possible. Regards from Tom :) On 3 March 2015 at 14:14, Jaroslaw Staniek stan...@kde.org wrote: Hi Tom, Interesting. Given similar, huge challenges, would you see areas of cooperation with Kexi? On 3 March 2015 at 14:33, Tom Davies tomc...@gmail.com wrote: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though. Regards from Tom :) On 2 March 2015 at 21:09, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- 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/
Re: [libreoffice-users] Re: Where is Base?
Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though. Regards from Tom :) On 2 March 2015 at 21:09, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- 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: Where is Base?
Hello, I am an old DB-User in the real sense of the word (I am over 70!). In the 90ies I got into DB2 as a systems engineer at IBM. Then, around the turn of the millenium, I set up a database for the administration of a 50-piece wind band, using Lotus-Approach (DBase...). It was fine but I wanted to go Open Software and - when stumbling onto StarOffice/OpenOffice and Base - it was clear to me to go for that scene. Since then I have been using MySQL as external back-end and must say I am more than happy with it. My DB consists of some 80 interconnected tables/views with record numbers up to around 40.000. This is handled perfectly fine by MySQL (maybe MariaDB in the near future!). Of course - as an old DB-guy I have no qualms about using the command-line mysql client directly for doing things like defining DBs, tables, views, foreign keys etc. Therefore, if there are any limitations in the LO-front end, it is o.k. for me. I do feel strongly though, that if we ever want LO to become a REALLY important player (especially within the business world!), a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) will have to be implemented. Internal, integrated backends are o.k. for playing around but NOT for mission-critical, large-scale operations. Regards Heinz Tom Davies schrieb: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though. Regards from Tom :) On 2 March 2015 at 21:09, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- 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:
[libreoffice-users] Re: Where is Base?
Am 03.03.2015 um 16:06 schrieb Peter Goggin: Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin My first medium complex project with input forms to collect daily job data used the embedded DB as well. It worked flawlessly. But the most important preconditions is that you really do your backup every time after closing the connection. Nevertheless, there are far too many reports about complete data loss. Meanwhile it is very easy to split a self-contained Base document into a frontend and a stable backend which can be distributed and installed on multiple machines with a tiny little bit of extra effort. Apart from keeping your data safe and warm, HSQL 2.3 provides a lot more features than HSQL 1.8. -- 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: Where is Base?
Hi Heinrich, I've been reluctant to join this discussion, but you comment about the need to have ... a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) ..., has prompted me to say that I believe one such database already exists - it is called H2. See - http://www.h2database.com/html/main.html. Some will perhaps reject it out of hand, because it is Java based. However it has a vibrant user base and from comments on the user group, some are using H2 for very large databases. A year or so ago one user was complaining that H2 was slowing down after his application passed the 1 billion record mark! In reply, he received several suggestions as to how he might over come his problem. I have migrated 6 databases from HSQL 1.8, (the largest having nearly 35,000 records - which I realise, is still quite small), but I have found that H2 works well for me. There was a bit of work involved with the migration, but H2 tables can be designed in LibreOffice and the process went pretty smoothly. Perhaps the only drawback is that once tables have been designed, they can be altered only using SQL commands. But I guess most users who want an industrial strength database, would already be literate in SQL. My 2c worth, Noel -- Noel Lodge lodg...@gmail.com On 4 March 2015 at 05:56, Heinrich Stöllinger hc.stoellin...@aon.at wrote: Hello, I am an old DB-User in the real sense of the word (I am over 70!). In the 90ies I got into DB2 as a systems engineer at IBM. Then, around the turn of the millenium, I set up a database for the administration of a 50-piece wind band, using Lotus-Approach (DBase...). It was fine but I wanted to go Open Software and - when stumbling onto StarOffice/OpenOffice and Base - it was clear to me to go for that scene. Since then I have been using MySQL as external back-end and must say I am more than happy with it. My DB consists of some 80 interconnected tables/views with record numbers up to around 40.000. This is handled perfectly fine by MySQL (maybe MariaDB in the near future!). Of course - as an old DB-guy I have no qualms about using the command-line mysql client directly for doing things like defining DBs, tables, views, foreign keys etc. Therefore, if there are any limitations in the LO-front end, it is o.k. for me. I do feel strongly though, that if we ever want LO to become a REALLY important player (especially within the business world!), a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) will have to be implemented. Internal, integrated backends are o.k. for playing around but NOT for mission-critical, large-scale operations. Regards Heinz Tom Davies schrieb: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though.
Re: [libreoffice-users] Re: Where is Base?
Hi Tom, Interesting. Given similar, huge challenges, would you see areas of cooperation with Kexi? On 3 March 2015 at 14:33, Tom Davies tomc...@gmail.com wrote: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though. Regards from Tom :) On 2 March 2015 at 21:09, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- 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 -- 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] Re: Where is Base?
Hi Peter Noted on your comments and others I can confirm that using the embedded DB in Base is a disaster - I battled with it for a couple of years until I found out about using an external engine - I use MySQL and have had _NO_ problems, (except my own finger problems!!) since then. Regarding images in the Database I have about 2600 records with a maximum of 7 images per record. I had no problems with this under Base/MySQL except that the DB file gets very large as a copy of each image is included in the DB. I just recently came across a tutorial on 'Linking Images' rather than including them and this works like a charm and the DB stays much smaller and therefore faster. The tutotial can be found here -/_www.youtube.com/watch?v=IsHqqvn2zYg_/ https://www.youtube.com/watch?v=IsHqqvn2zYg Another nice plus is that if you control your image file names you can be sure that your DB always shows the latest image - works for me!! Hope this helps IanW Pretoria RSA. -- 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: Where is Base?
Andreas , i must strongly confirm your vision. We must see Base as a connector and a front end for any possible database server We have 100 users, using LO as a front end to a MySQL server without any problems to use the MySQL data in Writer and Calc. The front end itself is writen with LO basic mainly using Dialogs to view the data and to feed the server with new and modified data. Greetz Fernand Am 02.03.2015 um 19:33 schrieb Florian Reisinger: Just a short note: Base can connect to a MySql database using a connector. I even think, knowing not much about Base, that an external database for storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin petergog...@bigpond.com: External is the one and only way to go. The embedded HSQL 1.8 simply does not work well enough. There are far too many reports of total data losses which is inacceptable for a database product. You can connect MySQL via ODBC, JDBC and the SDBC driver built into the office suite. I prefer external HSQL 2.3 via JDBC because the office frontend is tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8 on the fly and because any connection to an external HSQLDB requires only one file hsqldb.jar anywhere on the system. In server mode it takes this file plus self made start/stop scripts and a backup script. I just opened my oldest HSQL 2 database running in server mode on a Windows machine, accessed during 12 hours a day by means of Writer forms and Calc reports from 7 client machines. The first record is of 2011-Apr-28. This database never caused lost a single byte of data. Of course we run nightly backups anyway. -- 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: Where is Base?
Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- 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: Where is Base?
Hi everbody, although I am not an data IT person, I've been a long time user of openoffice/libreoffice. I'll allways wanted to use LO as an official front end for an database; first of all because I do not know how to program html (even with all those facilities we have today) and also I don't want to start now learning how to program in an script language. So I always hoped to find an GUI front end for an database, that would feel very similar to FileMaker (Mac/win). Well those that claim, that base is already very similar probably never used FileMaker intensly. Even Kexi which is also claimed to be as good as FileMaker is mile away from it. Don't take me wrong here I don't want to make any apology to this program, but they really got it quite right. Even though still thing that LO and similar are the way to go. But I think for sometime its being a unstable GUI crashing once and a while. After lefting it to rest for some time, last week, I took courage to restart an small project I wanted to move from an Calc tables to an real DB. I started using Kexi and tested again if LO Base would connect to the MariaDB with the native mysql driver it went flawlessly. One improvement I immediately saw (or at least as far as I remember), was the hability to see tables not generated by LO and read/write data as well. The last time I used base, if I remember well, base could only read tables from an DB if it generated the tables. But other simple things like changing the order of fields (with MariaDB as backend) do not work in LO but in Kexi it works. It seems also that crashing event were eliminated or reduced to a minimum. I don't want to compare GUI and list advantages or disadvantages, I just want to point out that although big leaps happened since I last tried to use base, what makes me very happy. On the downside, to become an great and easy to use GUI for developing grahical DB interfaces, if comparing with FileMaker, there is still along way to go. I tell this because I've used FileMaker for a while. I've learned to use it in quite a short time (~ 3-4 month) and did fairly complex reports, queries, etc in graphic mode. I can not say the samething for SQL likes. Probably my problem. But I belive that base is the right way to go, because it is an multiplataform program that links to several diferent DB programs and is open, I think two key conditions for the success of an software, as Fernand Vanrie mentioned. More up to date literature and how-to's would be a nice help and also an harder development unfortunately this last one I can not help due to my limitations. Greetings -- On Monday 02 March 2015 20:23:49 Tom Davies wrote: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. So, Postgresql has an advantage over MySql in not needing a connector, apparently. I dunno how it gets updated though! Also MariaDb is a drop-in replacement for MySql and i think a few places use it but continue to claim they are using MySql. Apparently all the MySql connectors work just the same but i've only heard from a very small number of people about that and the person who makes/builds the MySql connector wasn't certain they would work. I think those are all the larger database back-ends but HSqlDb is supposedly faster and more efficient with small databases such as almost all address books. There are tons to choose from though so you might find that whatever is being used somewhere already can probably be viewed and edited through Base. I think the way Base makes it so easy to connect to external back-ends is one of the huge advantages that Base offers. Instead we try to cripple it by giving it an internal back-end to make it as broken as Access. Regards from Tom :) On 2 March 2015 at 19:04, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 19:33 schrieb Florian Reisinger: Just a short note: Base can connect to a MySql database using a connector. I even think, knowing not much about Base, that an external database for storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin petergog...@bigpond.com: External is the one and only way to go. The embedded HSQL 1.8 simply does not work well enough. There are far too many reports of total data losses which is inacceptable for a database product. You can connect MySQL via ODBC, JDBC and the SDBC driver built into the office suite. I prefer external HSQL 2.3 via JDBC because the office frontend is tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8 on the fly and because any connection to an external HSQLDB requires only one file hsqldb.jar anywhere on the system. In server mode it takes this file plus self made start/stop scripts and
Re: [libreoffice-users] Re: Where is Base?
Hi :) The way Andreas describes Base's internal back-end makes a lot of sense out of what i have always heard about the internal back-end functioning so badly. Trying to read/write into a file inside a zip-file is often tricky and i just hadn't thought about that wrt Base. However, i was under the impression that the devs move to using a different internal back-end would give them a chance to do a better job of it. Sometimes prototyping really helps identify difficult areas. Also running a system for a long time does sometimes flag up issues that may not have been noticeable at the time. So i thought the move to a different internal back-end would at least make it possible to upgrade that back-end and maybe keep it less heavily tweaked and thus more inline with their own documentation to help people with all sorts of issues. Even just a couple of things like that might be a huge improvement. Regards from Tom :) On 1 March 2015 at 23:10, Virgil Arrington arringto...@gmail.com wrote: On 03/01/2015 02:03 PM, Andreas Säger wrote: Without Base you give up the capability to print serial letters and labels from lists.The vast majority of Base users are Writer users creating a serial letter or sheet of labels. These wizards generate Base documents in the background. In 99% of all these cases the Base documents constitutes a connection to a spreadsheet. You have described my situation exactly. I use Base once a year, to print out address labels for Christmas cards. I keep the address list in a spreadsheet and link to Writer through Base. It took me forever to learn how to do it, but now that I know, it works great. Virgil -- 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: Where is Base?
I have read with interest the emails on Base. I have always regarded the data base component of Open Office, Libre office as the equivalent to the datbase component of MS Access. I have 5 data bases, originally run under windows and MS Access which I have converted to run under Libre Base. I have found the LibreBase is probable slightly easier to use than MS Access and it certainly copes very well with my data bases, all of which are small. (The biggest has about 5000 records) The only problem I have had is in a new database where I needed to store photos against each record. It quickly gave up after about 4 records. I am not certain why, but other claims on my time have prevented me for investigating what caused the problem. I was a database administrator for many years with extremely large data bases (millioms of records) using Oracle, etc. When I needed to manage a large data base (about 100,000 records, 30 to 40 users) in linux, I used MySQL with web based front end using PHP to connect to the database. My advice to people needing to use databases is to use Base for small databases (less than 1 records). For larger bases consider using Mysql with a web based front end and PHP to connect to the databse. Regards Peter Goggin -- 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: Where is Base?
Just a short note: Base can connect to a MySql database using a connector. I even think, knowing not much about Base, that an external database for storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin petergog...@bigpond.com: I have read with interest the emails on Base. I have always regarded the data base component of Open Office, Libre office as the equivalent to the datbase component of MS Access. I have 5 data bases, originally run under windows and MS Access which I have converted to run under Libre Base. I have found the LibreBase is probable slightly easier to use than MS Access and it certainly copes very well with my data bases, all of which are small. (The biggest has about 5000 records) The only problem I have had is in a new database where I needed to store photos against each record. It quickly gave up after about 4 records. I am not certain why, but other claims on my time have prevented me for investigating what caused the problem. I was a database administrator for many years with extremely large data bases (millioms of records) using Oracle, etc. When I needed to manage a large data base (about 100,000 records, 30 to 40 users) in linux, I used MySQL with web based front end using PHP to connect to the database. My advice to people needing to use databases is to use Base for small databases (less than 1 records). For larger bases consider using Mysql with a web based front end and PHP to connect to the databse. Regards Peter Goggin -- 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
[libreoffice-users] Re: Where is Base?
Am 02.03.2015 um 19:33 schrieb Florian Reisinger: Just a short note: Base can connect to a MySql database using a connector. I even think, knowing not much about Base, that an external database for storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin petergog...@bigpond.com: External is the one and only way to go. The embedded HSQL 1.8 simply does not work well enough. There are far too many reports of total data losses which is inacceptable for a database product. You can connect MySQL via ODBC, JDBC and the SDBC driver built into the office suite. I prefer external HSQL 2.3 via JDBC because the office frontend is tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8 on the fly and because any connection to an external HSQLDB requires only one file hsqldb.jar anywhere on the system. In server mode it takes this file plus self made start/stop scripts and a backup script. I just opened my oldest HSQL 2 database running in server mode on a Windows machine, accessed during 12 hours a day by means of Writer forms and Calc reports from 7 client machines. The first record is of 2011-Apr-28. This database never caused lost a single byte of data. Of course we run nightly backups anyway. -- 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: Where is Base?
Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. So, Postgresql has an advantage over MySql in not needing a connector, apparently. I dunno how it gets updated though! Also MariaDb is a drop-in replacement for MySql and i think a few places use it but continue to claim they are using MySql. Apparently all the MySql connectors work just the same but i've only heard from a very small number of people about that and the person who makes/builds the MySql connector wasn't certain they would work. I think those are all the larger database back-ends but HSqlDb is supposedly faster and more efficient with small databases such as almost all address books. There are tons to choose from though so you might find that whatever is being used somewhere already can probably be viewed and edited through Base. I think the way Base makes it so easy to connect to external back-ends is one of the huge advantages that Base offers. Instead we try to cripple it by giving it an internal back-end to make it as broken as Access. Regards from Tom :) On 2 March 2015 at 19:04, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 19:33 schrieb Florian Reisinger: Just a short note: Base can connect to a MySql database using a connector. I even think, knowing not much about Base, that an external database for storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin petergog...@bigpond.com: External is the one and only way to go. The embedded HSQL 1.8 simply does not work well enough. There are far too many reports of total data losses which is inacceptable for a database product. You can connect MySQL via ODBC, JDBC and the SDBC driver built into the office suite. I prefer external HSQL 2.3 via JDBC because the office frontend is tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8 on the fly and because any connection to an external HSQLDB requires only one file hsqldb.jar anywhere on the system. In server mode it takes this file plus self made start/stop scripts and a backup script. I just opened my oldest HSQL 2 database running in server mode on a Windows machine, accessed during 12 hours a day by means of Writer forms and Calc reports from 7 client machines. The first record is of 2011-Apr-28. This database never caused lost a single byte of data. Of course we run nightly backups anyway. -- 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: Where is Base?
On Sun, 2015-03-01 at 22:23 +0100, Andreas Säger wrote: Am 01.03.2015 um 22:01 schrieb Jay Lozier: What is the current backend for Base? I remember at one time is HSQL 1.8 but one could install a later version. Jay When you create a new database document without Java support, then you get a directory of flat dBase files handled by LibreOffice's insufficient SDBC driver for dBase. With Java support it will be an embedded HSQL 1.8 database which is more a caricature of a database because it is slow, unsafe and insecure. The problem is _not_ HSQL. The problem is the way how the backend is wrapped into the zip archive which constitutes the Base document. It is easy enough to convert an embedded HSQLDB to a normal (external) database and use it with a recent and more capable version of HSQL. Current version is 2.3. On the OpenOffice user forum you can find several tutorials, scripts and macros. But you can also use HSQL 1.8 with an external database if that version fits your needs. Just do not use a self-contained database in a single file for anything but educational stuff, demos or small projects for a single user on a local machine with a sound backup strategy. Otherwise you can connect a Base document to any database you have a driver for (ADO, ODBC, JDBC). I have not kept up with Base, I tend to use MariaDB/PostgreSQL directly; not through the Base front end. I vaguely remember some chatter about replacing HSQL with something else. -- 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: Where is Base?
Am 01.03.2015 um 22:31 schrieb Jay Lozier: I have not kept up with Base, I tend to use MariaDB/PostgreSQL directly; not through the Base front end. I vaguely remember some chatter about replacing HSQL with something else. Replacing an excellent database engine with another excellent database engine will not solve any problem because HSQL is _not_ the problem. -- 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: Where is Base?
Am 01.03.2015 um 22:01 schrieb Jay Lozier: What is the current backend for Base? I remember at one time is HSQL 1.8 but one could install a later version. Jay When you create a new database document without Java support, then you get a directory of flat dBase files handled by LibreOffice's insufficient SDBC driver for dBase. With Java support it will be an embedded HSQL 1.8 database which is more a caricature of a database because it is slow, unsafe and insecure. The problem is _not_ HSQL. The problem is the way how the backend is wrapped into the zip archive which constitutes the Base document. It is easy enough to convert an embedded HSQLDB to a normal (external) database and use it with a recent and more capable version of HSQL. Current version is 2.3. On the OpenOffice user forum you can find several tutorials, scripts and macros. But you can also use HSQL 1.8 with an external database if that version fits your needs. Just do not use a self-contained database in a single file for anything but educational stuff, demos or small projects for a single user on a local machine with a sound backup strategy. Otherwise you can connect a Base document to any database you have a driver for (ADO, ODBC, JDBC). -- 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: Where is Base?
On 03/01/2015 02:03 PM, Andreas Säger wrote: Without Base you give up the capability to print serial letters and labels from lists.The vast majority of Base users are Writer users creating a serial letter or sheet of labels. These wizards generate Base documents in the background. In 99% of all these cases the Base documents constitutes a connection to a spreadsheet. You have described my situation exactly. I use Base once a year, to print out address labels for Christmas cards. I keep the address list in a spreadsheet and link to Writer through Base. It took me forever to learn how to do it, but now that I know, it works great. Virgil -- 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: Where is Base?
Sigh! Each and every aspect of OpenOffice, LibreOffice, Java and Base in particular: https://forum.openoffice.org/en/forum/viewtopic.php?f=74t=69896 Linux distros do not install Base because most people do not understand this drunken cousin of a component anyway. Linux users can install the missing component within seconds. Without Base you give up the capability to print serial letters and labels from lists.The vast majority of Base users are Writer users creating a serial letter or sheet of labels. These wizards generate Base documents in the background. In 99% of all these cases the Base documents constitutes a connection to a spreadsheet. If you are familiar with your own database stuff, Base is almost fully functional without any Java. Without any Java being installed, you can connect to your non-Java database, query meaningful data sets, create input forms but you can _not_ create embedded reports for pretty output. Instead of embedded reports you can use Calc as a very powerful report engine and you can copy (not link) database data into stand-alone Writer documents. Hope this helps, A.S. -- 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: Where is Base?
On Sun, 2015-03-01 at 20:03 +0100, Andreas Säger wrote: Sigh! Each and every aspect of OpenOffice, LibreOffice, Java and Base in particular: https://forum.openoffice.org/en/forum/viewtopic.php?f=74t=69896 Linux distros do not install Base because most people do not understand this drunken cousin of a component anyway. Linux users can install the missing component within seconds. Without Base you give up the capability to print serial letters and labels from lists.The vast majority of Base users are Writer users creating a serial letter or sheet of labels. These wizards generate Base documents in the background. In 99% of all these cases the Base documents constitutes a connection to a spreadsheet. If you are familiar with your own database stuff, Base is almost fully functional without any Java. Without any Java being installed, you can connect to your non-Java database, query meaningful data sets, create input forms but you can _not_ create embedded reports for pretty output. Instead of embedded reports you can use Calc as a very powerful report engine and you can copy (not link) database data into stand-alone Writer documents. Hope this helps, A.S. What is the current backend for Base? I remember at one time is HSQL 1.8 but one could install a later version. Jay -- 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: Where is Base?
2015-02-17 8:58 GMT+01:00 Brian Barker b.m.bar...@btinternet.com: At 19:09 16/02/2015 -0700, Dave Kidd wrote: I do not see an option to select/unselect which components to install. Here is what the Custom Setup screen looks like for me when I run the installer. http://nabble.documentfoundation.org/file/n4140349/components.png As you will see from that panel, this says that you have none (zero) of the eleven subfeatures of Optional Components (currently hidden) selected. So there are eleven things you have chosen not to install. Either: o (recommended) Click on the down-arrow to the left of Optional Components and select the option to install all of them. Or: o Click on the plus sign to the left of Optional Components to show the menu of those eleven items and then use their down-arrows to make individual choices about what you want to install. I trust this helps. Brian Barker Thanks, Brian, concise and to the point, as always Henri -- 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: Where is Base?
At 19:09 16/02/2015 -0700, Dave Kidd wrote: I do not see an option to select/unselect which components to install. Here is what the Custom Setup screen looks like for me when I run the installer. http://nabble.documentfoundation.org/file/n4140349/components.png As you will see from that panel, this says that you have none (zero) of the eleven subfeatures of Optional Components (currently hidden) selected. So there are eleven things you have chosen not to install. Either: o (recommended) Click on the down-arrow to the left of Optional Components and select the option to install all of them. Or: o Click on the plus sign to the left of Optional Components to show the menu of those eleven items and then use their down-arrows to make individual choices about what you want to install. I trust this helps. Brian Barker -- 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: Where is Base?
pranzar wrote (Tuesday, February 17, 2015, 12:19:32 AM): For those that have Base working it on Windows 7 64-bit: when you go to the LibreOffice directory in Explorer - default is C:\Program Files (x86)\LibreOffice 4\program Are you able to launch Base from an executable? I only have scalc.exe and swriter.exe. Win 7 64bit here. Yes, I find an executable sbase.exe, and I can start it as such. I haven't installed LibreOffice in the default directory, though. That is what I would do: uninstall LibreOffice (the whole shebang), download the newest version from the official (!) site, reinstall it and see what happens. Good luck! -- Cheers, Annette -- 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: Where is Base?
Hello Stefan, sorry, I missed your message. I do not see an option to select/unselect which components to install. Here is what the Custom Setup screen looks like for me when I run the installer. http://nabble.documentfoundation.org/file/n4140349/components.png -- View this message in context: http://nabble.documentfoundation.org/Where-is-Base-tp4139808p4140349.html Sent from the Users mailing list archive at Nabble.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: Where is Base?
2015-02-17 6:41 GMT+01:00 Annette aman_ml...@gmx.com: pranzar wrote (Tuesday, February 17, 2015, 12:19:32 AM): For those that have Base working it on Windows 7 64-bit: when you go to the LibreOffice directory in Explorer - default is C:\Program Files (x86)\LibreOffice 4\program Are you able to launch Base from an executable? I only have scalc.exe and swriter.exe. Win 7 64bit here. Yes, I find an executable sbase.exe, and I can start it as such. I haven't installed LibreOffice in the default directory, though. That is what I would do: uninstall LibreOffice (the whole shebang), download the newest version from the official (!) site, reinstall it and see what happens. Good luck! -- Cheers, Annette Sounds like good advice to me, Annette ; I hope that pranzar takes it and that it leads to success !... Henri -- 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: Where is Base?
Hello everyone, thanks for the help. I have both 64 and 32-bit versions of Java installed, but still nothing happens, no matter which one I select. For those that have Base working it on Windows 7 64-bit: when you go to the LibreOffice directory in Explorer - default is C:\Program Files (x86)\LibreOffice 4\program Are you able to launch Base from an executable? I only have scalc.exe and swriter.exe. -- View this message in context: http://nabble.documentfoundation.org/Where-is-Base-tp4139808p4140346.html Sent from the Users mailing list archive at Nabble.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: Where is Base?
2015-02-16 13:22 GMT+01:00 Tom Davies tomc...@gmail.com: Hi :) Congrats!! Nicely done! :) Yeh, that surprised me too. I had assumed it would work the same way as the Windows installer 'should' do. Congrats and regards from Tom :) On 16 February 2015 at 12:17, M Henri Day mhenri...@gmail.com wrote: 2015-02-16 12:48 GMT+01:00 M Henri Day mhenri...@gmail.com: 2015-02-16 11:57 GMT+01:00 Tom Davies tomc...@gmail.com: Hi :) On Ubuntu i have to install Base separately. I'm not sure what happened when i installed the official one from the LibreOffice website. Can't quite remember that far back tbh. When i use a package-manager to isntall the default one in the repos i can select all sorts of components and maybe Extensions and stuff. I thought it was the same for all Linux, especially for 'Ubuntu clones'? (although i think it's been a lng time since Mint could be claimed to be that) I thought the Windows version had pretty much everything all in one package (and the the help files in a separate bundle)? Then the Linux, Bsd and Mac version allowed a bit more finesse? I still don't know where to get Base from as i was fairly convinced it was included in the main Windows install automatically. Regards from Tom :) As you know, Tom, Linux Mint is a fork of Ubuntu, so generally speaking, that which applies to the latter applies, *ceteribus paribus*, to the former. Could you tell me just *how* you managed to install Base on Ubuntu ?... Henri Tom, I just took a chance and performed a search for LibreOffice in the Linux Mint Program Manager . To my joy, I found that it was possible to install individual LO programmes, including libreoffice-base via this service. Said and done ; I installed it and Base now launches as it should with a simple click in the LibreOffice window. Hallelujah !... Henri On 15 February 2015 at 12:03, M Henri Day mhenri...@gmail.com wrote: 2015-02-15 2:21 GMT+01:00 pranzar davek...@gmail.com: Hello, thanks for the help. I have Java 8 installed and it's being detected in Tools-Options as you indicated. I tried launching it directly (not via the startup screen) and there doesn't appear to be any executable for it - only scalc.exe and swriter.exe It seems that Base, Impress, Draw and Math are not installed with the main installer? Do I need to get them from somewhere else? In LO 4.4.0.3 on my (64-bit) Linux Mint 17.1 machine, I can open Writer, Calc, Impress, Draw, and Math with no problem, but klicking on Base does nothing at all ; the service simply doesn't launch. On my (64-bit) Windows 8.1 machine, however, Base launches just as it should. How can I get it to do so on my Linux box, which is the one I generally use ?... Henri Thanks, Tom ! Now it's incumbent upon us to attempt to help the OP, pranzar, with his problem. From what I've been able to understand, JRE is required for certain of the programmes in the LO package to be installed in Windows. Pranzar tells us that he has a version of Java 8 installed ; I wonder if the installed version is the 64 or the 32-bit version. I have seen claims to the effect that LO - and for that matter OO - require a 32-bit version of Java to function in Windows ; however, on my own Windows machine, I currently have a 64-bit Java 8 Update 31 installed and, as noted previously, all the LO programs work well there. In any event this is a parameter with which Pranzer might wish to play - if he currently has a 32-bit version installed he might wish to install a 64-bit version and *vice versa* I wish him the best of luck ! Henri -- 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: Where is Base?
2015-02-16 12:48 GMT+01:00 M Henri Day mhenri...@gmail.com: 2015-02-16 11:57 GMT+01:00 Tom Davies tomc...@gmail.com: Hi :) On Ubuntu i have to install Base separately. I'm not sure what happened when i installed the official one from the LibreOffice website. Can't quite remember that far back tbh. When i use a package-manager to isntall the default one in the repos i can select all sorts of components and maybe Extensions and stuff. I thought it was the same for all Linux, especially for 'Ubuntu clones'? (although i think it's been a lng time since Mint could be claimed to be that) I thought the Windows version had pretty much everything all in one package (and the the help files in a separate bundle)? Then the Linux, Bsd and Mac version allowed a bit more finesse? I still don't know where to get Base from as i was fairly convinced it was included in the main Windows install automatically. Regards from Tom :) As you know, Tom, Linux Mint is a fork of Ubuntu, so generally speaking, that which applies to the latter applies, *ceteribus paribus*, to the former. Could you tell me just *how* you managed to install Base on Ubuntu ?... Henri Tom, I just took a chance and performed a search for LibreOffice in the Linux Mint Program Manager . To my joy, I found that it was possible to install individual LO programmes, including libreoffice-base via this service. Said and done ; I installed it and Base now launches as it should with a simple click in the LibreOffice window. Hallelujah !... Henri On 15 February 2015 at 12:03, M Henri Day mhenri...@gmail.com wrote: 2015-02-15 2:21 GMT+01:00 pranzar davek...@gmail.com: Hello, thanks for the help. I have Java 8 installed and it's being detected in Tools-Options as you indicated. I tried launching it directly (not via the startup screen) and there doesn't appear to be any executable for it - only scalc.exe and swriter.exe It seems that Base, Impress, Draw and Math are not installed with the main installer? Do I need to get them from somewhere else? In LO 4.4.0.3 on my (64-bit) Linux Mint 17.1 machine, I can open Writer, Calc, Impress, Draw, and Math with no problem, but klicking on Base does nothing at all ; the service simply doesn't launch. On my (64-bit) Windows 8.1 machine, however, Base launches just as it should. How can I get it to do so on my Linux box, which is the one I generally use ?... Henri -- 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: Where is Base?
Hi :) Congrats!! Nicely done! :) Yeh, that surprised me too. I had assumed it would work the same way as the Windows installer 'should' do. Congrats and regards from Tom :) On 16 February 2015 at 12:17, M Henri Day mhenri...@gmail.com wrote: 2015-02-16 12:48 GMT+01:00 M Henri Day mhenri...@gmail.com: 2015-02-16 11:57 GMT+01:00 Tom Davies tomc...@gmail.com: Hi :) On Ubuntu i have to install Base separately. I'm not sure what happened when i installed the official one from the LibreOffice website. Can't quite remember that far back tbh. When i use a package-manager to isntall the default one in the repos i can select all sorts of components and maybe Extensions and stuff. I thought it was the same for all Linux, especially for 'Ubuntu clones'? (although i think it's been a lng time since Mint could be claimed to be that) I thought the Windows version had pretty much everything all in one package (and the the help files in a separate bundle)? Then the Linux, Bsd and Mac version allowed a bit more finesse? I still don't know where to get Base from as i was fairly convinced it was included in the main Windows install automatically. Regards from Tom :) As you know, Tom, Linux Mint is a fork of Ubuntu, so generally speaking, that which applies to the latter applies, *ceteribus paribus*, to the former. Could you tell me just *how* you managed to install Base on Ubuntu ?... Henri Tom, I just took a chance and performed a search for LibreOffice in the Linux Mint Program Manager . To my joy, I found that it was possible to install individual LO programmes, including libreoffice-base via this service. Said and done ; I installed it and Base now launches as it should with a simple click in the LibreOffice window. Hallelujah !... Henri On 15 February 2015 at 12:03, M Henri Day mhenri...@gmail.com wrote: 2015-02-15 2:21 GMT+01:00 pranzar davek...@gmail.com: Hello, thanks for the help. I have Java 8 installed and it's being detected in Tools-Options as you indicated. I tried launching it directly (not via the startup screen) and there doesn't appear to be any executable for it - only scalc.exe and swriter.exe It seems that Base, Impress, Draw and Math are not installed with the main installer? Do I need to get them from somewhere else? In LO 4.4.0.3 on my (64-bit) Linux Mint 17.1 machine, I can open Writer, Calc, Impress, Draw, and Math with no problem, but klicking on Base does nothing at all ; the service simply doesn't launch. On my (64-bit) Windows 8.1 machine, however, Base launches just as it should. How can I get it to do so on my Linux box, which is the one I generally use ?... Henri -- 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: Where is Base?
Hi :) On Ubuntu i have to install Base separately. I'm not sure what happened when i installed the official one from the LibreOffice website. Can't quite remember that far back tbh. When i use a package-manager to isntall the default one in the repos i can select all sorts of components and maybe Extensions and stuff. I thought it was the same for all Linux, especially for 'Ubuntu clones'? (although i think it's been a lng time since Mint could be claimed to be that) I thought the Windows version had pretty much everything all in one package (and the the help files in a separate bundle)? Then the Linux, Bsd and Mac version allowed a bit more finesse? I still don't know where to get Base from as i was fairly convinced it was included in the main Windows install automatically. Regards from Tom :) On 15 February 2015 at 12:03, M Henri Day mhenri...@gmail.com wrote: 2015-02-15 2:21 GMT+01:00 pranzar davek...@gmail.com: Hello, thanks for the help. I have Java 8 installed and it's being detected in Tools-Options as you indicated. I tried launching it directly (not via the startup screen) and there doesn't appear to be any executable for it - only scalc.exe and swriter.exe It seems that Base, Impress, Draw and Math are not installed with the main installer? Do I need to get them from somewhere else? In LO 4.4.0.3 on my (64-bit) Linux Mint 17.1 machine, I can open Writer, Calc, Impress, Draw, and Math with no problem, but klicking on Base does nothing at all ; the service simply doesn't launch. On my (64-bit) Windows 8.1 machine, however, Base launches just as it should. How can I get it to do so on my Linux box, which is the one I generally use ?... Henri -- 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: Where is Base?
2015-02-16 11:57 GMT+01:00 Tom Davies tomc...@gmail.com: Hi :) On Ubuntu i have to install Base separately. I'm not sure what happened when i installed the official one from the LibreOffice website. Can't quite remember that far back tbh. When i use a package-manager to isntall the default one in the repos i can select all sorts of components and maybe Extensions and stuff. I thought it was the same for all Linux, especially for 'Ubuntu clones'? (although i think it's been a lng time since Mint could be claimed to be that) I thought the Windows version had pretty much everything all in one package (and the the help files in a separate bundle)? Then the Linux, Bsd and Mac version allowed a bit more finesse? I still don't know where to get Base from as i was fairly convinced it was included in the main Windows install automatically. Regards from Tom :) As you know, Tom, Linux Mint is a fork of Ubuntu, so generally speaking, that which applies to the latter applies, *ceteribus paribus*, to the former. Could you tell me just *how* you managed to install Base on Ubuntu ?... Henri On 15 February 2015 at 12:03, M Henri Day mhenri...@gmail.com wrote: 2015-02-15 2:21 GMT+01:00 pranzar davek...@gmail.com: Hello, thanks for the help. I have Java 8 installed and it's being detected in Tools-Options as you indicated. I tried launching it directly (not via the startup screen) and there doesn't appear to be any executable for it - only scalc.exe and swriter.exe It seems that Base, Impress, Draw and Math are not installed with the main installer? Do I need to get them from somewhere else? In LO 4.4.0.3 on my (64-bit) Linux Mint 17.1 machine, I can open Writer, Calc, Impress, Draw, and Math with no problem, but klicking on Base does nothing at all ; the service simply doesn't launch. On my (64-bit) Windows 8.1 machine, however, Base launches just as it should. How can I get it to do so on my Linux box, which is the one I generally use ?... Henri -- 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: Where is Base?
Hello, thanks for the help. I have Java 8 installed and it's being detected in Tools-Options as you indicated. I tried launching it directly (not via the startup screen) and there doesn't appear to be any executable for it - only scalc.exe and swriter.exe It seems that Base, Impress, Draw and Math are not installed with the main installer? Do I need to get them from somewhere else? -- View this message in context: http://nabble.documentfoundation.org/Where-is-Base-tp4139808p4140129.html Sent from the Users mailing list archive at Nabble.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: Where is Base?
2015-02-15 2:21 GMT+01:00 pranzar davek...@gmail.com: Hello, thanks for the help. I have Java 8 installed and it's being detected in Tools-Options as you indicated. I tried launching it directly (not via the startup screen) and there doesn't appear to be any executable for it - only scalc.exe and swriter.exe It seems that Base, Impress, Draw and Math are not installed with the main installer? Do I need to get them from somewhere else? In LO 4.4.0.3 on my (64-bit) Linux Mint 17.1 machine, I can open Writer, Calc, Impress, Draw, and Math with no problem, but klicking on Base does nothing at all ; the service simply doesn't launch. On my (64-bit) Windows 8.1 machine, however, Base launches just as it should. How can I get it to do so on my Linux box, which is the one I generally use ?... Henri -- 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