Re: [libreoffice-users] Re: Where is Base?

2015-03-09 Thread Ralf Kersanach
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-09 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-09 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-09 Thread Ralf Kersanach
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-09 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-06 Thread Ralf Kersanach
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

[libreoffice-users] Re: Where is Base?

2015-03-06 Thread Andreas Säger
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

[libreoffice-users] Re: Where is Base?

2015-03-06 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-06 Thread Jaroslaw Staniek
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

[libreoffice-users] Re: Where is Base?

2015-03-05 Thread Andreas Säger
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

[libreoffice-users] Re: Where is Base?

2015-03-05 Thread Andreas Säger
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

[libreoffice-users] Re: Where is Base?

2015-03-05 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-05 Thread HBarr
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-05 Thread Heinrich Stöllinger
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

[libreoffice-users] Re: Where is Base?

2015-03-05 Thread 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...

Re: [libreoffice-users] Re: Where is Base?

2015-03-05 Thread Ian Whitfield
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.

Re: [libreoffice-users] Re: Where is Base?

2015-03-05 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-04 Thread Tom Davies
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.

Re: [libreoffice-users] Re: Where is Base?

2015-03-04 Thread Heinrich Stöllinger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-04 Thread 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.

Re: [libreoffice-users] Re: Where is Base?

2015-03-04 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-04 Thread Heinrich Stöllinger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-04 Thread Jaroslaw Staniek
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

[libreoffice-users] Re: Where is Base?

2015-03-04 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-03 Thread 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

Re: [libreoffice-users] Re: Where is Base?

2015-03-03 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-03 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-03 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-03 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-03 Thread Heinrich Stöllinger
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

[libreoffice-users] Re: Where is Base?

2015-03-03 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-03 Thread Marion Noel Lodge
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 -

Re: [libreoffice-users] Re: Where is Base?

2015-03-03 Thread Jaroslaw Staniek
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Ian Whitfield
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.

Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Fernand Vanrie
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

[libreoffice-users] Re: Where is Base?

2015-03-02 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Ralf Kersanach
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Peter Goggin
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.

Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread 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: I have read with interest the emails on Base. 

[libreoffice-users] Re: Where is Base?

2015-03-02 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread 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. So, Postgresql has an advantage over MySql in not needing

Re: [libreoffice-users] Re: Where is Base?

2015-03-01 Thread Jay Lozier
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

[libreoffice-users] Re: Where is Base?

2015-03-01 Thread Andreas Säger
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

[libreoffice-users] Re: Where is Base?

2015-03-01 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-01 Thread Virgil Arrington
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

[libreoffice-users] Re: Where is Base?

2015-03-01 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Where is Base?

2015-03-01 Thread Jay Lozier
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

Re: [libreoffice-users] Re: Where is Base?

2015-02-19 Thread M Henri Day
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.

Re: [libreoffice-users] Re: Where is Base?

2015-02-17 Thread Brian Barker
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

Re: [libreoffice-users] Re: Where is Base?

2015-02-16 Thread Annette
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

[libreoffice-users] Re: Where is Base?

2015-02-16 Thread pranzar
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

Re: [libreoffice-users] Re: Where is Base?

2015-02-16 Thread M Henri Day
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

[libreoffice-users] Re: Where is Base?

2015-02-16 Thread pranzar
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

Re: [libreoffice-users] Re: Where is Base?

2015-02-16 Thread M Henri Day
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

Re: [libreoffice-users] Re: Where is Base?

2015-02-16 Thread M Henri Day
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

Re: [libreoffice-users] Re: Where is Base?

2015-02-16 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-02-16 Thread Tom Davies
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

Re: [libreoffice-users] Re: Where is Base?

2015-02-16 Thread M Henri Day
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

[libreoffice-users] Re: Where is Base?

2015-02-15 Thread pranzar
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

Re: [libreoffice-users] Re: Where is Base?

2015-02-15 Thread M Henri Day
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