Re: [libreoffice-users] Installing MySQL Connect

2012-02-07 Thread Fernand Vanrie
Tom, Dan The Windows Native MySQL connector 1.01 is working on LO 3.4 and LO 3.5 Hi :) There is not one for Windows yet. It would need to be built. The ones for Mac and GnuLInux are here http://extensions.libreoffice.org/extension-center/mysql-native-connector-for-mac-osx No-one with

Re: [libreoffice-users] Installing MySQL Connect

2012-02-07 Thread Heinrich Stoellinger
Hi, I am also among the crowd hankering after a native MySQL/MariaDB- connector in LO. I run LO both under Windows/Vista, Debian-Wheezy (testing!) and Linux-Mint-12 (Lisa). Debian: LO 3.5-rc3 Mint: LO 3.5-rc3 Vista: LO 3.3.3 The native connector works ONLY on Windows-Vista (quite flawlessly,

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread e-letter
On 06/02/2012, Dan Lewis elderdanle...@gmail.com wrote: Or maybe the failure is the refusal to understand the purpose for each part of a database. Tables and forms are for adding, modifying, and deleting data. Queries and reports are for data output. If you want to enter data, you use a

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread e-letter
On 06/02/2012, Gordon Burgess-Parker gbpli...@gmail.com wrote: You are talking about me. I and many many others have used the same methods of categorising and storing data in Excel, Lotus 123, Multiplan and various other spreadsheet applications for a great many years. It's nothing whatsoever

Re: [libreoffice-users] Re: database or spreadsheet

2012-02-07 Thread e-letter
On 06/02/2012, Dan Lewis elderdanle...@gmail.com wrote: And it appears that you just explained why people will use spreadsheets (incorrectly perhaps) instead of a database. You just raised the bar too high for the average person. Why would anyone want to learn something as abstract as a

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Gordon Burgess-Parker
On 07/02/2012 12:47, e-letter wrote: On 06/02/2012, Gordon Burgess-Parkergbpli...@gmail.com wrote: You are talking about me. I and many many others have used the same methods of categorising and storing data in Excel, Lotus 123, Multiplan and various other spreadsheet applications for a great

Re: [libreoffice-users] Re: database or spreadsheet

2012-02-07 Thread Gordon Burgess-Parker
On 07/02/2012 13:03, e-letter wrote: It is not known from the original poster _why_ the sheets needed to be changed. Jeeze. DOES IT MATTER? No of course it doesn't MATTER. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-07 Thread Mark Stanton
Thanks Fernand, I'll go look. Regards Mark -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive:

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Jay Lozier
On 02/07/2012 07:24 AM, e-letter wrote: On 06/02/2012, Dan Lewiselderdanle...@gmail.com wrote: Or maybe the failure is the refusal to understand the purpose for each part of a database. Tables and forms are for adding, modifying, and deleting data. Queries and reports are for data

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Nino Novak
On Tuesday 07 February 2012, Jay Lozier wrote: Two related issues are a problem: spreadsheets are relatively easy to set up and enter data with some inflexibility while databases harder to set up and without the right front end tools some tricky to properly enter data but are much more

Re: [libreoffice-users] Installing MySQL Connect

2012-02-07 Thread Tony Sumner
Thanks to everyone for advice on this. I'll try out your suggestions and report back soon. Tony -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

[libreoffice-users] LO Base questions

2012-02-07 Thread Ian Whitfield
Hi All Two questions to throw into the pot today 1) I'm running OO Base (3.3.0) as I can not get LO to open my Database of several years standing!! I use Java 1.6.21 and this speeded-up the use of the DB very well. I still however have one major problem. When I shut-down at night it

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Pertti Rönnberg
Hello everybody – and especially Dan Lewis. I happened to read this thread about a database vs. spreadsheet. First of all I will thank Dan for him mentioning the “Getting Started Guide/Getting Started with Base/chapter 8! I cannot understand how I could have missed it when I for some time have

Re: [libreoffice-users] LO Base questions

2012-02-07 Thread drew
On Tue, 2012-02-07 at 18:22 +0200, Ian Whitfield wrote: Hi All Two questions to throw into the pot today 1) I'm running OO Base (3.3.0) as I can not get LO to open my Database of several years standing!! I use Java 1.6.21 and this speeded-up the use of the DB very well. I still

Re: [libreoffice-users] Avoid destop window

2012-02-07 Thread Tom Davies
Hi :) Which OS;  Windows, Ubuntu, another GnuLinux, Bsd or Mac? I think for most of them you can just click on the Start menu (or equivalent) and then something like All Programs - LibreOffice - Writer When you see Writer in that menu you can right-click on it and choose send to panel or

Re: [libreoffice-users] LO Base questions

2012-02-07 Thread Tom Davies
Hi :) 1.  Close Base long before you want to shut-down the machine ;)  Sorry, that's not very helpful but hopefully Drew's answer solves the problem and i couldn't help a little cheekiness again. 2.  If you are not happy with the owners of MySql then why not give MariaDb a try?

Re: [libreoffice-users] Avoid destop window

2012-02-07 Thread Eduardo Maldonado
Hi, Tom. First, I speak about Windows 7 and Windows 2008 Server, both 64 bits, LOffice 3.4. Second, I have not trouble for access directly to one application. My trouble is only for the window we see when we have only one document opened and we close the document, not the application. Is the

[libreoffice-users] Re: Avoid destop window

2012-02-07 Thread Pedro
Hi Eduardo This mailing list does not allow attachments but we know what window you are referring to. It's this one, right? http://www.libreoffice.org/features/screenshot/ The problem is that LibreOffice includes all programs in one single file. So if you un-select some programs when you are

Re: [libreoffice-users] Avoid destop window

2012-02-07 Thread Mirosław Zalewski
On 07/02/2012 at 19:21, Eduardo Maldonado eduardo.manio...@gmail.com wrote: I see the window for desktop of LO (the attached file). I am afraid I don't see any file attached. Mailing list server strips all mails of attachments, so if you have added this image as attachment in your mail

Re: [libreoffice-users] Re: Avoid destop window

2012-02-07 Thread Eduardo Maldonado
Hi all. Yes, Pedro, is this screen. I know this is not a bug. But it will has any way for avoid... (some xml file for modify, may be...) I we unselect some program in installation, this program is not refered in open or new menu. But there are reference here. For me, it can be... don't know,

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Dan Lewis
On Tue, 2012-02-07 at 12:39 -0500, Jay Lozier wrote: On 02/07/2012 11:51 AM, Nino Novak wrote: On Tuesday 07 February 2012, Jay Lozier wrote: Two related issues are a problem: spreadsheets are relatively easy to set up and enter data with some inflexibility while databases harder to set

[libreoffice-users] Re: database or spreadsheet

2012-02-07 Thread Andreas Säger
Am 07.02.2012 16:52, Jay Lozier wrote: Most people are scared off by having to develop queries, particularly if they must use SQL. It is too much like programming to them and that tends to scare them; seemingly arcane rules and syntax that does not appear very flexible or easy to use. Some

Re: [libreoffice-users] LO Base questions

2012-02-07 Thread Jay Lozier
On 02/07/2012 01:36 PM, Tom Davies wrote: Hi :) 1. Close Base long before you want to shut-down the machine ;) Sorry, that's not very helpful but hopefully Drew's answer solves the problem and i couldn't help a little cheekiness again. 2. If you are not happy with the owners of MySql then

Re: [libreoffice-users] Re: database or spreadsheet

2012-02-07 Thread Jay Lozier
On 02/07/2012 03:06 PM, Andreas Säger wrote: Am 07.02.2012 16:52, Jay Lozier wrote: Most people are scared off by having to develop queries, particularly if they must use SQL. It is too much like programming to them and that tends to scare them; seemingly arcane rules and syntax that does not

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Paul D. Mirowsky
I hope to to condense and reply to all. A person has spent arduous hours of entering/linking/formula-ing etc... on spreadsheets. It is not the optimum of data entry, as would be a database form. But it does do every thing they want it to. Now, if a translation Calc (spreadsheet) to Base

[libreoffice-users] Re: database or spreadsheet

2012-02-07 Thread Andreas Säger
Am 07.02.2012 21:57, Jay Lozier wrote: The irony is that most SQL queries are easier to understand because they reference tables and columns by name (out of necessity) and usually have a selection criteria that is makes contextual sense, such as vendor name. The above is not easy to follow or

[libreoffice-users] Re: database or spreadsheet

2012-02-07 Thread Andreas Säger
Am 07.02.2012 21:58, Paul D. Mirowsky wrote: I hope to to condense and reply to all. A person has spent arduous hours of entering/linking/formula-ing etc... on spreadsheets. It is not the optimum of data entry, as would be a database form. But it does do every thing they want it to. The

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread e-letter
On 07/02/2012, Pertti Rönnberg p...@elisanet.fi wrote: After reading Dan’s “Chapter 8” I realized that LO-Base is The solution when a database of medium size/complexity is needed, either using the embedded HSQLDB or connecting to an external “real” database engine (e.g. MySQL or SQLite). Very

Re: [libreoffice-users] Re: database or spreadsheet

2012-02-07 Thread Dan Lewis
On Tue, 2012-02-07 at 22:59 +0100, Andreas Säger wrote: Am 07.02.2012 21:58, Paul D. Mirowsky wrote: I hope to to condense and reply to all. A person has spent arduous hours of entering/linking/formula-ing etc... on spreadsheets. It is not the optimum of data entry, as would be a

Re: [libreoffice-users] Re: database or spreadsheet

2012-02-07 Thread Jay Lozier
On 02/07/2012 04:18 PM, Andreas Säger wrote: Am 07.02.2012 21:57, Jay Lozier wrote: The irony is that most SQL queries are easier to understand because they reference tables and columns by name (out of necessity) and usually have a selection criteria that is makes contextual sense, such as

Re: [libreoffice-users] Re: Avoid destop window

2012-02-07 Thread Tom Davies
Hi :) A, i think i see the problem.  I don't know if it is possible to avoid showing the apps that are not installed.  Sorry this email is not helpful :( It might be worth talking to the Design Team about developing an Extension to do that?  or perhaps your organisation could find some

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Jay Lozier
On 02/07/2012 05:17 PM, e-letter wrote: On 07/02/2012, Nino Novaknn.l...@kflog.org wrote: As a consequence: It would help most, if the database set up barrier could be lowered. We therefore should ask (and try to learn) what makes database creation so difficult, and how could we contribute to

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread drew
On Tue, 2012-02-07 at 22:17 +, e-letter wrote: On 07/02/2012, Nino Novak nn.l...@kflog.org wrote: As a consequence: It would help most, if the database set up barrier could be lowered. We therefore should ask (and try to learn) what makes database creation so difficult, and how

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Jay Lozier
On 02/07/2012 05:20 PM, e-letter wrote: On 07/02/2012, Jay Lozierjsloz...@gmail.com wrote: IMHO, the real problem is that good data modeling is not usually taught to users and unless they start working with databases they never learn data modeling. Most books on using databases will, if

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread drew
On Tue, 2012-02-07 at 18:32 -0500, drew wrote: On Tue, 2012-02-07 at 22:17 +, e-letter wrote: On 07/02/2012, Nino Novak nn.l...@kflog.org wrote: As a consequence: It would help most, if the database set up barrier could be lowered. We therefore should ask (and try to

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread drew
On Tue, 2012-02-07 at 19:47 -0500, Paul D. Mirowsky wrote: I think this is my bad. I apologize to all. No need - a lot of traffic happens here, and it all is generated by humans.. stuff happens - my main point is - put it behind, a good discussion came of it. //drew On 2/7/2012 7:01 PM,

[libreoffice-users] [hijacked thread] Re: Installing MySQL Connect - should be Writer - Dotted grid background

2012-02-07 Thread NoOp
On 02/06/2012 12:09 PM, Tony Sumner wrote: I hope MySQL isn't OT. ... Actually it is for the thread that you hijacked: Writer - Dotted grid background. In the future please start a new email subject rather than tagging on to another thread and simply changing the subject. You probably wouldn't

Re: [libreoffice-users] [hijacked thread] Re: Installing MySQL Connect - should be Writer - Dotted grid background

2012-02-07 Thread Dan Lewis
On Tue, 2012-02-07 at 18:53 -0800, NoOp wrote: On 02/06/2012 12:09 PM, Tony Sumner wrote: I hope MySQL isn't OT. ... Actually it is for the thread that you hijacked: Writer - Dotted grid background. In the future please start a new email subject rather than tagging on to another thread

[libreoffice-users] Re: Avoid destop window

2012-02-07 Thread Pedro
Hi Eduardo, all Eduardo Maldonado wrote But it will has any way for avoid... (some xml file for modify, may be...) I we unselect some program in installation, this program is not refered in open or new menu. But there are reference here. For me, it can be... don't know, molesto

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Stefan Weigel
Hi Drew, Am 08.02.2012 00:32, schrieb drew: The user asked how to rename sheets in Calc - end of story. But the beginning of the story is, that the user, before asking this question, first described an unfortunate way of holding data, which is the reason why he needs to rename a big number of

Re: [libreoffice-users] LO Base questions

2012-02-07 Thread Ian Whitfield
On 07/02/2012 20:36, Tom Davies wrote: The MySql connector should work exactly the same for MariaDb as the code is almost identical with perhaps a few new features and plenty of bug-patches. Thanks Tom!! Where do I get _YOUR_ connector and how do I use it?? On 07/02/2012 20:36, Drew wrote: