Re: [libreoffice-users] Re: Problems importing an OO database into LO
On Mon, 2012-04-23 at 11:31 +0200, Ian Whitfield wrote: > On 21/04/2012 16:58, Ian Whitfield wrote: > > > > So what can be causing the problem?? > > > I'm a little despondent - over a week since I started this exercise and > I'm still nowhere. Also 3 days since my last post and no suggestions. > > Can anyone help me out?? > > I stand at the point of having HSQLDB2.2.8 on my computer but when I try > to create a new DB I get a "cannot load driver error" (see previous > posts). Is it that you CAN'T CREATE a new Database this way?? )I can't > believe this). Or what am I doing wrong?? > > I _HAVE_ to crack this urgently and need some more help from some of you > experts out there. > > What I need to do - Set-up HSQLDB2 (Done); Link to it (fail); Create a > new table layout (pending); import my data via .csv (pending). START > WORK AGAIN (urgent)!!! > > Thanks a lot. > > -- > Ian Sig > */_Ian Whitfield_/* What is the name of your database? Answer: What folder are you going to use to hold the data? Answer: What is the path to this folder? Answer: Do you have the problems corrected the data in the database already? Answer: Is is this still the path to hsqldb? Tools >Options > LibreOffice > Java > Class Path Answer: With this information, I think someone will be able to help you since these are the things you need to know to use hsqldb 2.2.8 as the backend and Base as the front end. --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 21/04/2012 16:58, Ian Whitfield wrote: So what can be causing the problem?? I'm a little despondent - over a week since I started this exercise and I'm still nowhere. Also 3 days since my last post and no suggestions. Can anyone help me out?? I stand at the point of having HSQLDB2.2.8 on my computer but when I try to create a new DB I get a "cannot load driver error" (see previous posts). Is it that you CAN'T CREATE a new Database this way?? )I can't believe this). Or what am I doing wrong?? I _HAVE_ to crack this urgently and need some more help from some of you experts out there. What I need to do - Set-up HSQLDB2 (Done); Link to it (fail); Create a new table layout (pending); import my data via .csv (pending). START WORK AGAIN (urgent)!!! Thanks a lot. -- Ian Sig */_Ian Whitfield_/* ZS6CDX *Pretoria, South Afric*a *Tel* - +27 (0)12 817 2001 *Cell* -+27 (0)82 573 9142 *FAX* - +27 (0)86 651 4844 *Skype* - ianzs6cdx, also on Facebook *SnailMail* - Box 72226, Lynnwood Ridge 0040, South Africa / (No trees were harmed in the production of this message, however a large number of re-cycled electrons were temporarily inconvenienced) / -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 21.04.2012 18:58, Mark Stanton wrote: Copying the structure and data in one go, as offered by the import wizard, never creates any auto-ID fields. Would this be a sensible improvement to make? Mark Stanton One small step for mankind... Hello Mark, Yes, it would be useful to have more import options that actually work when importing a pseudo-database (mostly spreadsheet lists) into a true database or into HSQLDB at least: [X] Use first column as column name [X] Create primary key [Name Box] [ ] Create primary key as auto-ID And another exclusive option: [o] Use existing column as auto-ID [ ] Use existing column(s) as primary key When importing from a true database into another true database, these options should be preset according to the situation in the source table but still modifyable. Sometimes you want to import with no constraints at all. My above statement ... never creates any auto-ID fields. is not entirely correct. At least a copy&paste between 2 HSQLDBs creates the integer PK as auto-ID. It creates an exact copy of the table. Some level of detection seems to be implemented already. Copying from HSQLDB to H2 (a similar Java DB) does creates an integer PK but not as an auto-ID field. I think it can be very hard to implement for all types of connectable database engines. There are UNO interfaces to detect the capabilities and idiosyncrasies of some database driver. May be this can be utilized, may be not. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) I almost hate to say it this late in the process but wouldn't a non-java back-end be better? Java just seems to be a bit of a disaster these days, since Oracle took over. Kexi uses Sqllite and there are surely other light back-ends that might be good to try? Regards from Tom :) --- On Sat, 21/4/12, Ian Whitfield wrote: From: Ian Whitfield Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Saturday, 21 April, 2012, 14:46 In addition to what I wrote a couple of hours back - I have just tried a couple of other things... I linked the class path to the two files mentioned in the Error Box. LO accepted both of them OK AND popped-up a box warning me to re-start LO and then worked fine. BUT both are linked to the embedded engine!! I tried again with the 2.2.8 version and noticed I DO NOT get the warning box to re-start LO. And it gives me the error box as reported. I then moved a copy of the .jre file to the same location as the first two and tried again - no change!! This leaves me wondering if the .jre file is at fault. It's new, (I downloaded it yesterday), and is 1.4Mb in size?? Does this sound like a problem?? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 21/04/2012 16:08, Andreas Säger wrote: Am 21.04.2012 15:46, Ian Whitfield wrote: This leaves me wondering if the .jre file is at fault. It's new, (I downloaded it yesterday), and is 1.4Mb in size?? This is the md5sum of my working hsqldb-2.2.8.zip: $ md5sum ~/download/hsqldb-2.2.8.zip 8b7668689cd208867c77f2f4d77922de /home/andreas/download/hsqldb-2.2.8.zip My copy gives me the same Check-Sum!! So what can be causing the problem?? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 21.04.2012 15:46, Ian Whitfield wrote: This leaves me wondering if the .jre file is at fault. It's new, (I downloaded it yesterday), and is 1.4Mb in size?? This is the md5sum of my working hsqldb-2.2.8.zip: $ md5sum ~/download/hsqldb-2.2.8.zip 8b7668689cd208867c77f2f4d77922de /home/andreas/download/hsqldb-2.2.8.zip -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
In addition to what I wrote a couple of hours back - I have just tried a couple of other things... I linked the class path to the two files mentioned in the Error Box. LO accepted both of them OK AND popped-up a box warning me to re-start LO and then worked fine. BUT both are linked to the embedded engine!! I tried again with the 2.2.8 version and noticed I DO NOT get the warning box to re-start LO. And it gives me the error box as reported. I then moved a copy of the .jre file to the same location as the first two and tried again - no change!! This leaves me wondering if the .jre file is at fault. It's new, (I downloaded it yesterday), and is 1.4Mb in size?? Does this sound like a problem?? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 21/04/2012 10:48, Alexander Thurgood wrote: 1) Remove the links that you added to the Classpath parameter to : /opt/libreoffice3.5/programs/classes/hsqldb.jar /opt/libreoffice3.5/programs/classes/sdbc_hsqldb.jar LO already knows where to find them. From what you describe as your actions, you added them again to the classpath, and that is possibly/probably what is causing LO to moan. 2) After removing the links to those files, restart LO. 3) Do not open your old ODB file in LO Base yet, i.e. the one you want to migrate over to using the hsqldb2 engine. 4) Follow Andreas' instructions from point (3) onwards : Thanks Alex. but 'No Go' I'm afraid!!! I ONLY added the ONE path to the class like you say but I removed it and re-started LO and did it again. After another re-start I STILL get the same error message when I try to start a new Database. I'm working this way because Base screwed-up my original DB so badly (which is why I decided to make a change). The original .odb file is such a mess. In looking for an alternative I've been working with Kexi and spent days correcting and editing my table in this program. It's very good but I have discovered a few flaws - the main one being a TOTAL LACK of support So my plan is to get Base working with the external HSQLDB2 engine, recreate my Table layout and then export my corrected table from Kexi in .csv format and import it into the new Base layout. Hope you follow me. Thanks for the kind help. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 21/04/12 10:28, Ian Whitfield a écrit : Hi Ian, > On 20/04/2012 18:51, Alexander Thurgood wrote: >> Check the permissions on your /software folder and also the permissions >> on the hsqldb folder and any files in it. The jar file at least, needs >> to have the executable bit set. You only needed to check/change the permissions on this : /home/ian/software/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar not the others ! Those other jar files you listed are the ones that come with LO, and you shouldn't really be fiddling around with those. > > As I now want to try the external-linked way of running Base I selected > to "Create a New Database'. Base opens but says . > > a) I'm still using the embedded Database. > b) And I get an error box that says ... "The connection to the data > source could not be established. > The driver class 'org.hsqldb.jdbcDriver' coud not be loaded. The > additional driver class path is > 'vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/hsqldb.jar > vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/sdbc_hsqldb.jar'. > 1) Remove the links that you added to the Classpath parameter to : /opt/libreoffice3.5/programs/classes/hsqldb.jar /opt/libreoffice3.5/programs/classes/sdbc_hsqldb.jar LO already knows where to find them. From what you describe as your actions, you added them again to the classpath, and that is possibly/probably what is causing LO to moan. 2) After removing the links to those files, restart LO. 3) Do not open your old ODB file in LO Base yet, i.e. the one you want to migrate over to using the hsqldb2 engine. 4) Follow Andreas' instructions from point (3) onwards : > 3) Extract the database folder out of your embedded .odb. What Andreas means here is that you should make a copy of your existing ODB database file, then unzip the copy. Although one can work directly on the original ODB file if you know what you are doing, it would be better I think in this case to work on a copy of that file. > 4) Rename the files: > properties, script, backup, data > to: > foo.properties, foo.script, foo.backup, foo.data > where "foo" is just an arbitrary name. This instruction should be clear, if not, please state what you don't understand > 5) Connect a new Base document to a JDBC data source with an URL like: > jdbc:hsqldb:file:/path/to/extracted/database/foo;default_schema=true > (the "foo" refers to the same database name I used as file name prefix) This too, seems clear to me, but if you have a question, please ask. > 6) Copy queries, forms and reports from the old embedded .odb to the new one. This too, seems clear to me, but again, if uncertain, please ask. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 20/04/2012 18:51, Alexander Thurgood wrote: Check the permissions on your /software folder and also the permissions on the hsqldb folder and any files in it. The jar file at least, needs to have the executable bit set. OK - one step at a time I guess I checked the permissions on the three .jar files and found that the 'x' setting was not checked so I made them all wide-open. Now when I go to 'Class Path' I can "see" them and select one. (BTW - except for the one I put in in my 'software' folder the other two must have been put there by LO). I selected the one in 'software' (ver 2.2.8 - hsqldb.jar) As I now want to try the external-linked way of running Base I selected to "Create a New Database'. Base opens but says . a) I'm still using the embedded Database. b) And I get an error box that says ... "The connection to the data source could not be established. The driver class 'org.hsqldb.jdbcDriver' coud not be loaded. The additional driver class path is 'vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/hsqldb.jar vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/sdbc_hsqldb.jar'. Some more assistance please!!! -- Ian Sig */_Ian Whitfield_/* ZS6CDX *Pretoria, South Afric*a *Tel* - +27 (0)12 817 2001 *Cell* -+27 (0)82 573 9142 *FAX* - +27 (0)86 651 4844 *Skype* - ianzs6cdx, also on Facebook *SnailMail* - Box 72226, Lynnwood Ridge 0040, South Africa / (No trees were harmed in the production of this message, however a large number of re-cycled electrons were temporarily inconvenienced) / -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 04/20/2012 12:27 PM, Jean-Francois Nifenecker wrote: Le 20/04/2012 18:17, Nino Novak a écrit : Pertti, the problem is, that software usability today in most cases is still far from being intuitive. I fully share this. Though some (eyes looking to Redmond) claim computing is "intuitive", I'm seeing everyday that it is *not* and that using a computer *requires* training. +1 - The only reason computers seem intuitive is that most OS's and programs use the ideas developed at PARC and first implemented in the 80's. Some of the command groupings are not necessarily intuitive. MSO ribbon to me is not very intuitive, I can spend more hunting down a command than with older interfaces. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 20.04.2012 16:48, Ian Whitfield wrote: /home/ian/software/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar menu:Tools>Options>Java Button "Class Path" Button "Add Archive" and point to the above one. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 20.04.2012 14:08, Mark Stanton wrote: Hi Ian, The easy version is :- 1) Open your database with the HSQLDB embedded data. 2) In a separate window, create a new database with any other kind of data engine. 3) Drag the tables from the embedded database to the new database, one by one. 4) Drag any other objects from the old database to the new one, too. I'm guessing that the important bit that you need there is missed out, the "how to create and link up to A.N.Other database". Indeed, this is the easy version to copy anything (spreadsheet, csv, mail address, embedded HSQL, ...) into some writable target database. This can not convert an embedded HSQLDB to an external one because once you point the office to the external HSQL the embedded won't be accessible anymore. I described how to extract the whole embedded thing out of the database.odb and use it directly with the external database. For the above outlined copy&paste method I use to recommend that you should have prepared the target database. Copying the structure and data in one go, as offered by the import wizard, never creates any auto-ID fields. The wizard can automatically add some integer key, but it is not the automatically incrementing one you need in most cases. Once the tables are filled with data it is difficult (impossible?) to change the primary key to be auto-incrementing. However, if the auto-id is predefined you can import arbitrary integer data that fit to the related integers in other tables. First create all the tables with default values, indices, primary keys, constraints and foreign keys (relations). Then copy over the raw data into the prepared structure and in the right order. Detail tables first, then the dependent data tables where the foreign keys refer to the detail tables. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 20/04/12 16:48, Ian Whitfield a écrit : Hi Ian, > OK > Step 1. Done (I downloaded and extracted hsqldb 2.2.8 to my 'software' > folder) > Step 2. The lib folder is under root and all files are grey-ed out in > Class Path?? Why are you trying to put the jar in your root's lib folder, or are you logged into the GUI as root ? > I then looked at my 'software' folder and found it there. > Tried to set 'Class Path' to this but again all files are > grey-ed out. Did you change the permissions on that folder after downloading so that it was accessible ? From what you describe, it sounds like you didn't. Some systems do not automatically enable the execute bit attribute on files that you download from the internet or is it perhaps your Software folder that has write/execute limitations ? LO needs to be able to access the jar file in a folder which it can read from. > > Did a search across my whole drive and found the following 3 > files > /home/ian/software/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar Check the permissions on your /software folder and also the permissions on the hsqldb folder and any files in it. The jar file at least, needs to have the executable bit set. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) +1 I can definitely agree with this! Well said! :) Regards from Tom :) --- On Fri, 20/4/12, Jean-Francois Nifenecker wrote: From: Jean-Francois Nifenecker Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Friday, 20 April, 2012, 17:27 Le 20/04/2012 18:17, Nino Novak a écrit : > > Pertti, the problem is, that software usability today in most cases is still > far from being intuitive. I fully share this. Though some (eyes looking to Redmond) claim computing is "intuitive", I'm seeing everyday that it is *not* and that using a computer *requires* training. -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Le 20/04/2012 18:30, Tom Davies a écrit : Hi :) I think that's a tad unfair. People have grown-up learning MS's ways of doing things and so "intuitive" means doing things MS's way, ie the ways that encourages a proliferation of viruses and causes slowdowns and encourages bad-habits. Intuitive? Hu. From Wikipedia: "Intuition is the ability to acquire knowledge without inference or the use of reason." I do not know of *any* computer or computer program that can be run without inference or the use of reason. Any time I hear "intuitive" within the IT context, I jump to a gun. A blank page in a Writer document looks like it's going to be fairly easy to write in and it is as long as people can avoid the bad habits they have picked up and perhaps even quickly skim through some of the official documentation or look things up in it if their first few tries are not instantly successful To do that, they need training. Much training. First to forget that a computer is no typewriter, then to change their (bad) habits. -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Le 20/04/2012 16:48, Ian Whitfield a écrit : On 20/04/2012 14:57, Andreas Säger wrote: 1) Download and extract the latest HSQLDB to some place. No installation required. 2) Point the "Class Path" setting in the LibreOffice Java options to hsqldb.jar in your subdirectory "lib". Thanks Andreas OK Step 1. Done (I downloaded and extracted hsqldb 2.2.8 to my 'software' folder) Step 2. The lib folder is under root and all files are grey-ed out in Class Path?? Try "Add File" (freely translated from my FR interface) first (point to the directory where your .jar lies) then, when back to the Class Path window, use "Add Archive". You should be set now. -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) I think that's a tad unfair. People have grown-up learning MS's ways of doing things and so "intuitive" means doing things MS's way, ie the ways that encourages a proliferation of viruses and causes slowdowns and encourages bad-habits. A blank page in a Writer document looks like it's going to be fairly easy to write in and it is as long as people can avoid the bad habits they have picked up and perhaps even quickly skim through some of the official documentation or look things up in it if their first few tries are not instantly successful Regards from Tom :) --- On Fri, 20/4/12, Nino Novak wrote: From: Nino Novak Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Friday, 20 April, 2012, 17:17 On Friday 20 April 2012, 16:54:54 Pertti Rönnberg wrote: > On 20.4.2012 11:00, MiguelAngel wrote: > > One for you. > > > > Much users even don't read the program's help... > May I correct you, you do not need a license for driving a car... Pertti, the problem is, that software usability today in most cases is still far from being intuitive. So the analogy with the car does not seem appropriate. Better take a Jumbo Jet's cockpit. Even if you don't want to fly it, but just to roll across the airport, you need to know awfully lots of things to move the plane. The challenge is to use LibreOffice despite of its shortcomings ;-) Nino -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Le 20/04/2012 18:17, Nino Novak a écrit : Pertti, the problem is, that software usability today in most cases is still far from being intuitive. I fully share this. Though some (eyes looking to Redmond) claim computing is "intuitive", I'm seeing everyday that it is *not* and that using a computer *requires* training. -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On Friday 20 April 2012, 16:54:54 Pertti Rönnberg wrote: > On 20.4.2012 11:00, MiguelAngel wrote: > > One for you. > > > > Much users even don't read the program's help... > May I correct you, you do not need a license for driving a car... Pertti, the problem is, that software usability today in most cases is still far from being intuitive. So the analogy with the car does not seem appropriate. Better take a Jumbo Jet's cockpit. Even if you don't want to fly it, but just to roll across the airport, you need to know awfully lots of things to move the plane. The challenge is to use LibreOffice despite of its shortcomings ;-) Nino -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) The in-built help is a bit rubbish and out-dated but the official documentation is fairly excellent. http://wiki.documentfoundation.org/Documentation/Publications http://www.libreoffice.org/get-help/documentation/ The guides on the official page are the same as the ones on the wiki but the wiki has more guides and links to 3rd party documentation too. The official website only has the guides for 3.3.x branch but the wiki has a load of things that have only recently been added for the 3.4.x branch. The problem with the in-built help is that 2 teams each thought it was the other team's job to update. The docs team doesn't seem to have permissions or access to the in-built help but even if they did then they are a tiny group and are a bit swamped so they have focused on the guides for now. Anyone that wants to join the docs team is very welcome! Regards from Tom :) --- On Fri, 20/4/12, Pertti Rönnberg wrote: From: Pertti Rönnberg Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Friday, 20 April, 2012, 14:54 On 20.4.2012 11:00, MiguelAngel wrote: > > One for you. > > Much users even don't read the program's help. > A light read over all the help, shows very well what the program can do and > how, many samples there, and also can solve the majority of the cuestions on > daily use. > To drive a car is needed a license, in other words known the rules. Nobody > was born learned. > > Miguel Ángel. > Miguel, May I correct you, you do not need a license for driving a car! When my son was 10 he had no license but I let him test driving my car! But if you do not know the features of it, e.g. how to handle the gears, then you may study the Instruction Book, the User's Manual or whatever it is called. Just to avoid misunderstanding: I am talking about LibreOffice and it's LibreOffice Help -- not OpenOffice's. When I was new to LibO(-Base) I spent hours on trying to learn the logic of LibreOffice Help. Try your self: Let us say that you need to create a form (Base) in Design View based on a query , because you need fields from two tables in one of which you have a 'birthday' field that you want to be calculated as 'age' and want that age field visible on the form. You know how to do in MSAccess but not in LibO-Base. Start by pushing the LibreOffice Help button (lifebuoy) Good luck! Pertti Rönnberg -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 20/04/2012 14:57, Andreas Säger wrote: 1) Download and extract the latest HSQLDB to some place. No installation required. 2) Point the "Class Path" setting in the LibreOffice Java options to hsqldb.jar in your subdirectory "lib". Thanks Andreas OK Step 1. Done (I downloaded and extracted hsqldb 2.2.8 to my 'software' folder) Step 2. The lib folder is under root and all files are grey-ed out in Class Path?? I then looked at my 'software' folder and found it there. Tried to set 'Class Path' to this but again all files are grey-ed out. Did a search across my whole drive and found the following 3 files /home/ian/software/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar /opt/libreoffice3.5/programs/classes/hsqldb.jar /opt/libreoffice3.5/programs/classes/sdbc_hsqldb.jar Where to now? Thanks for the help!! IanW -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 20.4.2012 11:00, MiguelAngel wrote: One for you. Much users even don't read the program's help. A light read over all the help, shows very well what the program can do and how, many samples there, and also can solve the majority of the cuestions on daily use. To drive a car is needed a license, in other words known the rules. Nobody was born learned. Miguel Ángel. Miguel, May I correct you, you do not need a license for driving a car! When my son was 10 he had no license but I let him test driving my car! But if you do not know the features of it, e.g. how to handle the gears, then you may study the Instruction Book, the User's Manual or whatever it is called. Just to avoid misunderstanding: I am talking about LibreOffice and it's LibreOffice Help -- not OpenOffice's. When I was new to LibO(-Base) I spent hours on trying to learn the logic of LibreOffice Help. Try your self: Let us say that you need to create a form (Base) in Design View based on a query , because you need fields from two tables in one of which you have a 'birthday' field that you want to be calculated as 'age' and want that age field visible on the form. You know how to do in MSAccess but not in LibO-Base. Start by pushing the LibreOffice Help button (lifebuoy) Good luck! Pertti Rönnberg -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 20.04.2012 10:48, Ian Whitfield wrote: On 20/04/2012 01:18, Andreas Säger wrote: There are not many users who suffer from the limited capabilities of HSQL 1.8. A high risk of total data loss is the main reason why one must not use the embedded database. Getting an embedded database out of the jail is easy enough. OK Andreas (or anyone else) - for those of us not so good at this how about a detailed Tutorial on doing this?? Right here 1) Download and extract the latest HSQLDB to some place. No installation required. 2) Point the "Class Path" setting in the LibreOffice Java options to hsqldb.jar in your subdirectory "lib". 3) Extract the database folder out of your embedded .odb. 4) Rename the files: properties, script, backup, data to: foo.properties, foo.script, foo.backup, foo.data where "foo" is just an arbitrary name. 5) Connect a new Base document to a JDBC data source with an URL like: jdbc:hsqldb:file:/path/to/extracted/database/foo;default_schema=true (the "foo" refers to the same database name I used as file name prefix) 6) Copy queries, forms and reports from the old embedded .odb to the new one. Slightly more details and links in: http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=46324&p=214069&hilit=hsqldb#p214049 For multi-user access you can start the hsqldb.jar in server mode and connect the .odb clients with something like jdbc:hsqldb:hsql://192.168.0.2/foo;default_schema=true -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 20/04/2012 01:18, Andreas Säger wrote: There are not many users who suffer from the limited capabilities of HSQL 1.8. A high risk of total data loss is the main reason why one must not use the embedded database. Getting an embedded database out of the jail is easy enough. OK Andreas (or anyone else) - for those of us not so good at this how about a detailed Tutorial on doing this?? Right here Step 1 Step 2 Step 3 etc (??) Best regards IanW -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
El 20/04/12 1:18, Andreas Säger escribió: Am 19.04.2012 20:45, Pertti Rönnberg wrote: LibO-folks, From this long and very interesting thread and some other discussions on this mailing list too, together with my own recent experiences, there is only one main conclusion to draw: There is no real future forLibO's Base module, perhaps not for the whole LibO suite. From a non-expert user's perspective there are in fact two versions of LibO-Base A >a "Light-LibO-Base" => a package consisting of LibO-Base as a front-end GUI and an embedded db-engine HSQKDBv1.8. This package is (could be) suitable for up to medium complex databases and be used by 'ordinary' people (like me) who does not have own skills in programming or developing or in SQL or other languages (PHP, HTML, etc.) -- who plainly want to create a database following instructions mechanically B > an "Advanced-LibO-Base => the LibO-Base module to be used as a front-end GUI connected to an external db-engine and that can be used by people with own knowledge in programming anddb-theories and SQL and who have a good knowledge of the whole LibO's build-up,preferable in the linux environment I can hardly see any difference between A and B. The embedded HSQLDB behaves exactly like an external DB. When you "open the embedded database document" you actually _install_ an external HSQLDB and connect the office suite to that _external_ database in cached mode (single user on local machine) until you "close the database document" which re-packages the external database. IMHO, nobody needs to know anything about macro programming in order to build useful database applications with Base. The vast majority of Base macros are due to bad database design, save one or two clicks or they are made to impress the boss. There are plenty of macros for generic tasks. All the most desperately wanted macros have been written already (clone records, refresh this and that, open forms and reports, open text as hyperlink). What I would describe as "Base light" is the ability to use spreadsheets, csv files, dBase files, LDAP and popular mail client address books as read-only data sources for office documents, mostly mail merge. This is the most important feature and the concept is superior to MS Office if there is a computer knowledgable administrator able to work with templates, spreadsheets, plain text and some SQL in a creative manner. For the end user who writes a serial letter the type of data source makes no difference at all. It is always used in the same (slightly clumsy) way, no matter if the addresses come from Oracle server or plain text file. The "Light-LibO-Base" will fail because it is like a car without a gear box: you can open it and start it but not use it as intended Øthe installing procedure of Lib-O causes problems because of unclear instructions Øthe LibO-Base module as a program is half done;even basic features does not work Base is not a stand-alone program and all the _basic_ features do work well. The database backend is a mature database program, most of the rest belongs to the Writer component. There is just too much dysfunctional junk on top of the basic database functionality which does not add any additional functionality. Everything that the wizards are supposed to do can be done without the wizard. Today's users are do not accept any _basic_ features in a highly sophisticated office suite, no matter how well the basic features use to work. Instead they complain about the dysfunctional rubbish. Øthere is no documentation explicit for LibO-Base -- and will obviouslynot be; There is excellent documentation for OOo Base which is identical to LibO Base. Main problem with documentation is that today's computer users overestimate their skills and do not understand the difference between end user applications and development tools. This type of office suite suggest that each component should be as easy to use as the text processor. Users have to rely on OpenO documentation why there is no logical reason to install LibO (ordinary new users does not know about any differences between LibO and OO -- and do not know why to seek) Øthe LibreOffice Help is a disaster -- a user new to LibO does not get any (direct) help LibO documentation on Base is plain wrong and misleading. Simply point to the existing OOo docs or copy and paste that stuff. Øthe embedded HSQLv1.8 is out-of-date and causes frustration and waste of time because the lack of easy to get and sufficient support There are not many users who suffer from the limited capabilities of HSQL1.8. A high risk of total data loss is the main reason why one must not use the embedded database. Getting an embedded database out of the jail is easy enough. Øthe reports is a important part of the data output; there is no Report Builder explicit for LibO-Base or one that works properly Calc is a very good sorrogate for a report engine even if you are not very familiar with spreadsheets. I
[libreoffice-users] Re: Problems importing an OO database into LO
Am 19.04.2012 20:45, Pertti Rönnberg wrote: LibO-folks, From this long and very interesting thread and some other discussions on this mailing list too, together with my own recent experiences, there is only one main conclusion to draw: There is no real future forLibO's Base module, perhaps not for the whole LibO suite. From a non-expert user's perspective there are in fact two versions of LibO-Base A >a "Light-LibO-Base" => a package consisting of LibO-Base as a front-end GUI and an embedded db-engine HSQKDBv1.8. This package is (could be) suitable for up to medium complex databases and be used by 'ordinary' people (like me) who does not have own skills in programming or developing or in SQL or other languages (PHP, HTML, etc.) -- who plainly want to create a database following instructions mechanically B > an "Advanced-LibO-Base => the LibO-Base module to be used as a front-end GUI connected to an external db-engine and that can be used by people with own knowledge in programming anddb-theories and SQL and who have a good knowledge of the whole LibO's build-up,preferable in the linux environment I can hardly see any difference between A and B. The embedded HSQLDB behaves exactly like an external DB. When you "open the embedded database document" you actually _install_ an external HSQLDB and connect the office suite to that _external_ database in cached mode (single user on local machine) until you "close the database document" which re-packages the external database. IMHO, nobody needs to know anything about macro programming in order to build useful database applications with Base. The vast majority of Base macros are due to bad database design, save one or two clicks or they are made to impress the boss. There are plenty of macros for generic tasks. All the most desperately wanted macros have been written already (clone records, refresh this and that, open forms and reports, open text as hyperlink). What I would describe as "Base light" is the ability to use spreadsheets, csv files, dBase files, LDAP and popular mail client address books as read-only data sources for office documents, mostly mail merge. This is the most important feature and the concept is superior to MS Office if there is a computer knowledgable administrator able to work with templates, spreadsheets, plain text and some SQL in a creative manner. For the end user who writes a serial letter the type of data source makes no difference at all. It is always used in the same (slightly clumsy) way, no matter if the addresses come from Oracle server or plain text file. The "Light-LibO-Base" will fail because it is like a car without a gear box: you can open it and start it but not use it as intended Øthe installing procedure of Lib-O causes problems because of unclear instructions Øthe LibO-Base module as a program is half done;even basic features does not work Base is not a stand-alone program and all the _basic_ features do work well. The database backend is a mature database program, most of the rest belongs to the Writer component. There is just too much dysfunctional junk on top of the basic database functionality which does not add any additional functionality. Everything that the wizards are supposed to do can be done without the wizard. Today's users are do not accept any _basic_ features in a highly sophisticated office suite, no matter how well the basic features use to work. Instead they complain about the dysfunctional rubbish. Øthere is no documentation explicit for LibO-Base -- and will obviouslynot be; There is excellent documentation for OOo Base which is identical to LibO Base. Main problem with documentation is that today's computer users overestimate their skills and do not understand the difference between end user applications and development tools. This type of office suite suggest that each component should be as easy to use as the text processor. Users have to rely on OpenO documentation why there is no logical reason to install LibO (ordinary new users does not know about any differences between LibO and OO -- and do not know why to seek) Øthe LibreOffice Help is a disaster -- a user new to LibO does not get any (direct) help LibO documentation on Base is plain wrong and misleading. Simply point to the existing OOo docs or copy and paste that stuff. Øthe embedded HSQLv1.8 is out-of-date and causes frustration and waste of time because the lack of easy to get and sufficient support There are not many users who suffer from the limited capabilities of HSQL1.8. A high risk of total data loss is the main reason why one must not use the embedded database. Getting an embedded database out of the jail is easy enough. Øthe reports is a important part of the data output; there is no Report Builder explicit for LibO-Base or one that works properly Calc is a very good sorrogate for a report engine even if you are not very familiar with spreadsheets. It s
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 18.4.2012 13:23, Tom Davies wrote: Hi :) That is exactly why i wondered if Andreas' points could be worked on while leaving the existing package, Base, as it stands. That way the database functionality could be moved forwards while leaving the kludgy mess (ok, it might not be a kludge from a coders pov) to get sorted 'later'. The trees outside my window have been severely pruned back but i know that by the summer the leaves will be out in full force. The trees look a lot healthier already as they are not groaning under their own weight. Regards from Tom :) --- On Wed, 18/4/12, Alexander Thurgood wrote: From: Alexander Thurgood Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:05 Le 17/04/12 18:14, Andreas Säger a écrit : Hi all, The easiest improvements in my honest opinion: - Wipe out the .odb container all together and get back to the configuration of database access in OOo 1. Back to external databases with configuration data in configuration files, forms and reports in stand-alone office documents. More speed more safety, security, accessibility and transparency. People who do not understand how to connect separated software tools do not understand the .odb container neither (as we can read in all the mail merge topics). - Remove all the half done wizards. Do not improve them. Remove! No database developer nor interface designer needs all this stinky rubbish. There are graphical tools to compose forms and reports within office documents. There is SQL for all the rest, including all the things we can not do in the current graphical interface. There are plenty of SQL editors to produce valid SQL for various databases. SQL text can be pasted into any database configuration. - Add native database queries, so the current "direct SQL mode" returns editable row sets and the (useless or even harmful) graphical query designer can be removed as well. - Having removed all the wizards (they are Java components) without losing any functionality at all, extensions could substitute .odb packages. When you open the extension, the database gets installed _permanently_ (rather than _temporarily_ like the .odb) into the configuration tree together with the forms and reports documents. The database will be registered and all the tables, queries, forms and reports are accessible form the data source window, hyperlinks and desktop links just like it used to be in OOo 1. Ah, nostalgia those were halcyon days ;-) +1 (not that that means anything in our "user land". Unfortunately, as I was told quite a while ago either on the dev-list or IRC dev channel, or bugzilla, "no-one wants to go back to 10 year old technology", i.e. the LO devs are not interested in undoing what Sun it its infinite wisdom thought would be a good idea when it "re-invented OOo-Base", so we are stuck with what we have until someone steps up and decides to either unravel it all or improve it - a mammoth task by anyone's standards. Alex LibO-folks, From this long and very interesting thread and some other discussions on this mailing list too, together with my own recent experiences, there is only one main conclusion to draw: There is no real future forLibO's Base module, perhaps not for the whole LibO suite. From a non-expert user's perspective there are in fact two versions of LibO-Base A >a "Light-LibO-Base" => a package consisting of LibO-Base as a front-end GUI and an embedded db-engine HSQKDBv1.8. This package is (could be) suitable for up to medium complex databases and be used by 'ordinary' people (like me) who does not have own skills in programming or developing or in SQL or other languages (PHP, HTML, etc.) -- who plainly want to create a database following instructions mechanically B > an "Advanced-LibO-Base => the LibO-Base module to be used as a front-end GUI connected to an external db-engine and that can be used by people with own knowledge in programming anddb-theories and SQL and who have a good knowledge of the whole LibO's build-up,preferable in the linux environment The "Light-LibO-Base" will fail because it is like a car without a gear box: you can open it and start it but not use it as intended Øthe installing procedure of Lib-O causes problems because of unclear instructions Øthe LibO-Base module as a program is half done;even basic features does not work Øthere is no documentation explicit for LibO-Base -- and will obviouslynot be; Users have to rely on OpenO documentation why there is no logical reason to install LibO (ordinary new users does not know about any differences between LibO and OO -- and do not know why to seek) Øthe LibreOffice Help is a disaster -- a user new to LibO does not get any (direct) help Øthe embedded HSQLv1.8 is out-of
[libreoffice-users] Re: Problems importing an OO database into LO
Andreas Säger wrote > > Am 19.04.2012 13:00, ptoye wrote: > >> I think I'm being misunderstood here. I've never mentioned trying to link >> Base and Word - that's not something I want to do. > > You do it all the time. All of your input forms are attached to Writer > documents. > > All I originally asked >> about was an incorrect display of a query in a form. > > and you received at least two viable solutions although nobody was able > to reproduce the problem. > One of the solutions was my own: to continue using OO (which at the moment I am, but is not exactly a solution to the technical problem). The other was your workaround. No-one here said they couldn't reproduce it as far as I can see, though of course it may be true. I'd be willing to upload the database here if anyone would like to try it out on their system. It might be a configuration issue, though I can't quite see how. After the short discussion about the technical problem I had, this thread turned into a discussion of the relationship between LO and OO, and of the shortcomings (or otherwise) of Base, about which I am not qualified to comment. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3923242.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 19.04.2012 13:00, ptoye wrote: Mark Stanton wrote I think I'm being misunderstood here. I've never mentioned trying to link Base and Word - that's not something I want to do. You do it all the time. All of your input forms are attached to Writer documents. All I originally asked about was an incorrect display of a query in a form. and you received at least two viable solutions although nobody was able to reproduce the problem. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Mark Stanton wrote > >> > I'm almost thinking of installing something like MySQL and writing my >> own >> > front-end in Java. > > I'm sorry if I'm being slow, or not following the conversation properly > (lots going > on here at the moment), but, if you're thinking like that, what's wrong > with Base? > The things you'd need to do, Base does. > The things that approach won't get you, something to present your data, > you'd > use Writer/Calc for. > > The two problems I've registered (which have a multitude of subsidiaries, > I know, > I'm not trying to say Base is great yet, it's clearly not), is that the > whole thing > crashes, the answer is use a back end not the embedded system, and the > wizards > are cr*p, building your own front end to (eg) MySQL won't help you there. > > Andreas' approach of writing queries and setting up Writer documents to > use them > does what you want, doesn't it? > > Writing documentation for this approach would be a good idea to broadcase > these > ideas. > > Mark Stanton > > I think I'm being misunderstood here. I've never mentioned trying to link Base and Word - that's not something I want to do. All I originally asked about was an incorrect display of a query in a form. This has been ignored in the general discussion on the suitability or Base as a general-purpose user-oriented database front-end and in its future development. I've said my two pen'orth on that subject, as I'm certainly not competent to discuss the politics involved. So will shut up here. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3922702.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) That is exactly why i wondered if Andreas' points could be worked on while leaving the existing package, Base, as it stands. That way the database functionality could be moved forwards while leaving the kludgy mess (ok, it might not be a kludge from a coders pov) to get sorted 'later'. The trees outside my window have been severely pruned back but i know that by the summer the leaves will be out in full force. The trees look a lot healthier already as they are not groaning under their own weight. Regards from Tom :) --- On Wed, 18/4/12, Alexander Thurgood wrote: From: Alexander Thurgood Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:05 Le 17/04/12 18:14, Andreas Säger a écrit : Hi all, > > The easiest improvements in my honest opinion: > - Wipe out the .odb container all together and get back to the > configuration of database access in OOo 1. Back to external databases > with configuration data in configuration files, forms and reports in > stand-alone office documents. More speed more safety, security, > accessibility and transparency. People who do not understand how to > connect separated software tools do not understand the .odb container > neither (as we can read in all the mail merge topics). > - Remove all the half done wizards. Do not improve them. Remove! No > database developer nor interface designer needs all this stinky rubbish. > There are graphical tools to compose forms and reports within office > documents. There is SQL for all the rest, including all the things we > can not do in the current graphical interface. There are plenty of SQL > editors to produce valid SQL for various databases. SQL text can be > pasted into any database configuration. > - Add native database queries, so the current "direct SQL mode" returns > editable row sets and the (useless or even harmful) graphical query > designer can be removed as well. > - Having removed all the wizards (they are Java components) without > losing any functionality at all, extensions could substitute .odb > packages. When you open the extension, the database gets installed > _permanently_ (rather than _temporarily_ like the .odb) into the > configuration tree together with the forms and reports documents. The > database will be registered and all the tables, queries, forms and > reports are accessible form the data source window, hyperlinks and > desktop links just like it used to be in OOo 1. > > Ah, nostalgia those were halcyon days ;-) +1 (not that that means anything in our "user land". Unfortunately, as I was told quite a while ago either on the dev-list or IRC dev channel, or bugzilla, "no-one wants to go back to 10 year old technology", i.e. the LO devs are not interested in undoing what Sun it its infinite wisdom thought would be a good idea when it "re-invented OOo-Base", so we are stuck with what we have until someone steps up and decides to either unravel it all or improve it - a mammoth task by anyone's standards. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) That sounds much easier for data-input and normal look-up use for normal users that are barely familiar with Word/Writer and Calc/Excel. Most normal office workers seem scared of using databases for even low level tasks. This style of use takes away the scary front-end and gives them something more familiar. It sounds like a slightly tougher challenge for the designers in some ways but saves them endless time fiddling around lining up boxes on Forms and Reports. If normal office workers can be allowed to do the fiddling then i think that suits everyone much better. Regards from Tom :) --- On Wed, 18/4/12, Fernand Vanrie wrote: From: Fernand Vanrie Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:55 On 17/04/2012 23:58, Andreas Säger wrote: > Am 17.04.2012 19:23, Tom Davies wrote: >> Hi :) >> It looks like most of this can be done without touching Base itself? Is LO >> able to use databases in this way already? Is it something that could be >> passed to the devs list an/or the BoD discussion list? Something like this >> could be phrased to capture the imagination, Saying it's the old way might >> put them off. >> Regards from >> Tom :) >> > > I use to use Base like this. I connect a Base document to HSQL 2.8 databases > with forms and reports on the desktop (spreadsheet reports are sufficient for > us). The Base container is nothing but a configuration file storing the > connection URL, SQL query strings and the default log-in (and I left some > rarely used admin forms in it). > My users do not know anything about the database document. > The content of the database document could be some XML and query strings in > the configuration tree (just like it used to be in OOo 1). > > We are using OO-LO as a front end to connect to MySQL, we no longer use the LO-forms etc , but we usesDialogs and their controls (also Drids and the DataSourceBrowser)who are fed with the MySQL-data. Reporting is done by feeding WriterDocs with the data, or Calc-spreadsheets for data oriented reports. Exporting to a spreadsheet is very slow when feeding the sheet cell by cell. But using the "doimport" on a cell range is lightning fast. For Connecting, we use the NativeConnector. We try to avoid using a OO-LO dbase doc(for safety reasons) and connect directly using the DriverManager. This method has a important drawback, The DataSourceBrowser is not working without connecting with dbaseDoc. when low volume selections (100 lines)using the GridControls is very use full but becomes to slow for big selections, here is the DataSource browser a possible workaround. GridControls however have the advantage that we can "color" every line, that makes it far more user friendly. This system is used by 100 users , who can do all their tasks with only using OO-LO Greetz Fernand -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 17/04/2012 23:58, Andreas Säger wrote: Am 17.04.2012 19:23, Tom Davies wrote: Hi :) It looks like most of this can be done without touching Base itself? Is LO able to use databases in this way already? Is it something that could be passed to the devs list an/or the BoD discussion list? Something like this could be phrased to capture the imagination, Saying it's the old way might put them off. Regards from Tom :) I use to use Base like this. I connect a Base document to HSQL 2.8 databases with forms and reports on the desktop (spreadsheet reports are sufficient for us). The Base container is nothing but a configuration file storing the connection URL, SQL query strings and the default log-in (and I left some rarely used admin forms in it). My users do not know anything about the database document. The content of the database document could be some XML and query strings in the configuration tree (just like it used to be in OOo 1). We are using OO-LO as a front end to connect to MySQL, we no longer use the LO-forms etc , but we usesDialogs and their controls (also Drids and the DataSourceBrowser)who are feeded with the MySQL-data. Reporting is done by feeding WriterDocs with the data, or Calc-spreadsheets for data oriented reports. Exporting to a spreadsheet is very slow when feeding the sheet cell by cell. But using the "doimport" on a cell range is lightning fast. For Connecting, we use the NativeConnector. We trie to avoid using a OO-LO dbase doc(fro safty reasons) and connect directly using the DriverManager. This method has a important drawback, The DataSourceBrowser is not working without connecting with dbaseDoc. when low volume selections (100 lines)using the GridControls is very use full but becomes to slow for big selections, here is the DataSource browser a possible workaround. GridControls however have the advantage that we can "color" every line, whats make it far more user friendly. This system is used by 100 users , who can do all their tasks with only using OO-LO Greetz Fernand -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) The divergence has resulted in at least a doubling of the numbers of people working on the project(s). The projects do have a lot of overlap and share a lot. People that were colleagues working alongside each other may find themselves split into different projects but still chatting and helping each other. Taking just LibreOffice alone, it has famously already had a vast amount of devs join in. The "Easy hacks" initiative has made it far easier to get devs that are familiar with other projects familiarised with programming for LibreOffice. It's helped draw in students and other people that have never really done any programming before or left programming years ago and "Google's Summer of Code" has helped draw people into programming for LO too. Under Sun the infrastructure had all grown quite tangled so it was good to get a fresh start under TDF maximising the usefulness of modern technology that simply wasn't around when Sun's infrastructure was originally planned. The Apache Foundation is quite large and IBM can support their developments but would fidn it difficult to support a truly and fully OpenSource project such as LibreOffice. Apparently Apache Licensing allows a mix of some fairly proprietary chunks of code alongside OpenSource ones. If OOo had just carried on under Sun then it wouldn't have had the resources of either Apache nor TDF let alone both!! Plus about half the community would have been unhappy about not being fully OpenSource and therefore never gaining the backing of the "Free Software Foundation" which has led to a greater range of distros being comfortable using LO. The other half might have wanted to pull us more in the direction of corporate secrecy such as IBM seem to want. This way both sides are happier and growing faster. Regards from Tom :) --- On Wed, 18/4/12, Alexander Thurgood wrote: From: Alexander Thurgood Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:17 Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements with regard to the integrated use of HSQLDB, I would differ with regard to hooking up Base to various server backends, which in my experience do work rather well on the whole, albeit with tweaking, and are multi-OS compatible. > LONG story short I have now moved my (re-built) Database on to > Kexi - and what a difference It's like getting out of an old > broken-down VW (or other make) of car and getting into a brand new > Jaguar and driving down the highway at 100mph!! And I know what that > feels like as I did just that last year in the UK!! Yes there is a lot > to learn and work out but the overall effect is like Chalk and Cheese!! > > For anyone interested I can recommend this DB - some of the more fancy > options are only due out in future releases but for a basic DB job it > "just works"!! > Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a Windows, Mac or Solaris user and then have that work ? If not, then it is no better than Access, or Lotus Approach. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 18/04/2012 11:17, Alexander Thurgood wrote: Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements with regard to the integrated use of HSQLDB, I would differ with regard to hooking up Base to various server backends, which in my experience do work rather well on the whole, albeit with tweaking, and are multi-OS compatible. Hi Alex - Yes I wanted to try this and everybody said it was easy but NOBODY gave me any instructions!! I did "mess about" with it a few times but got nowhere - so I never was able to try this out!! Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a Windows, Mac or Solaris user and then have that work ? If not, then it is no better than Access, or Lotus Approach. Kexi is a standard SQLlight format so the files should be movable between OpSys-es. I also see that Calligra 2.4 has just been released that includes the latest Kexi and this is available on Window$ and they are asking for Mac OS Devs also!! But non of this was a major concern of mine. I run my own DB and used it EVERY day. I don't have to pass it on to others so as long as it works for me (well) in Linux - that's what I need!!! And so far Kexi is delivering, (for me anyway!!). All the best Ian W Pretoria -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) I think Kexi and the rest of Calligra/KOffice has a Windows version just as LibreOffice does. Calligra/KOffice uses ODF natively and presumably can use MS formats although i'm not sure quite how well. Regards from Tom :) --- On Wed, 18/4/12, Alexander Thurgood wrote: From: Alexander Thurgood Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:17 Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements with regard to the integrated use of HSQLDB, I would differ with regard to hooking up Base to various server backends, which in my experience do work rather well on the whole, albeit with tweaking, and are multi-OS compatible. > LONG story short I have now moved my (re-built) Database on to > Kexi - and what a difference It's like getting out of an old > broken-down VW (or other make) of car and getting into a brand new > Jaguar and driving down the highway at 100mph!! And I know what that > feels like as I did just that last year in the UK!! Yes there is a lot > to learn and work out but the overall effect is like Chalk and Cheese!! > > For anyone interested I can recommend this DB - some of the more fancy > options are only due out in future releases but for a basic DB job it > "just works"!! > Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a Windows, Mac or Solaris user and then have that work ? If not, then it is no better than Access, or Lotus Approach. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements with regard to the integrated use of HSQLDB, I would differ with regard to hooking up Base to various server backends, which in my experience do work rather well on the whole, albeit with tweaking, and are multi-OS compatible. > LONG story short I have now moved my (re-built) Database on to > Kexi - and what a difference It's like getting out of an old > broken-down VW (or other make) of car and getting into a brand new > Jaguar and driving down the highway at 100mph!! And I know what that > feels like as I did just that last year in the UK!! Yes there is a lot > to learn and work out but the overall effect is like Chalk and Cheese!! > > For anyone interested I can recommend this DB - some of the more fancy > options are only due out in future releases but for a basic DB job it > "just works"!! > Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a Windows, Mac or Solaris user and then have that work ? If not, then it is no better than Access, or Lotus Approach. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 17/04/12 20:13, ptoye a écrit : > > Is there any point in suggesting that LibO and OO should continue to > diverge? I'd have thought convergence would be more productive, both in > terms of the development which seems too thinly spread, and for users who > might even see a serious contender emerging. > To my knowledge (which granted, may be limited), there is not a single Base developer on the AOOo team. The integration of hsqldb2 had already been prepared during Oracle's tenure, it was thereafter a matter of integrating the child workspace of the relevant code. Moreover, AOOo have dropped future bundling of the Oracle ReportBuilder extension because of licensing problems with some of the Pentaho libraries, as with the mysql native connector. In other words, the Base module in AOOo is effectively at best stalled, at worst crippled with regard to OOo 3.3.x Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 17/04/12 18:14, Andreas Säger a écrit : Hi all, > > The easiest improvements in my honest opinion: > - Wipe out the .odb container all together and get back to the > configuration of database access in OOo 1. Back to external databases > with configuration data in configuration files, forms and reports in > stand-alone office documents. More speed more safety, security, > accessibility and transparency. People who do not understand how to > connect separated software tools do not understand the .odb container > neither (as we can read in all the mail merge topics). > - Remove all the half done wizards. Do not improve them. Remove! No > database developer nor interface designer needs all this stinky rubbish. > There are graphical tools to compose forms and reports within office > documents. There is SQL for all the rest, including all the things we > can not do in the current graphical interface. There are plenty of SQL > editors to produce valid SQL for various databases. SQL text can be > pasted into any database configuration. > - Add native database queries, so the current "direct SQL mode" returns > editable row sets and the (useless or even harmful) graphical query > designer can be removed as well. > - Having removed all the wizards (they are Java components) without > losing any functionality at all, extensions could substitute .odb > packages. When you open the extension, the database gets installed > _permanently_ (rather than _temporarily_ like the .odb) into the > configuration tree together with the forms and reports documents. The > database will be registered and all the tables, queries, forms and > reports are accessible form the data source window, hyperlinks and > desktop links just like it used to be in OOo 1. > > Ah, nostalgia those were halcyon days ;-) +1 (not that that means anything in our "user land". Unfortunately, as I was told quite a while ago either on the dev-list or IRC dev channel, or bugzilla, "no-one wants to go back to 10 year old technology", i.e. the LO devs are not interested in undoing what Sun it its infinite wisdom thought would be a good idea when it "re-invented OOo-Base", so we are stuck with what we have until someone steps up and decides to either unravel it all or improve it - a mammoth task by anyone's standards. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 17.04.2012 19:23, Tom Davies wrote: Hi :) It looks like most of this can be done without touching Base itself? Is LO able to use databases in this way already? Is it something that could be passed to the devs list an/or the BoD discussion list? Something like this could be phrased to capture the imagination, Saying it's the old way might put them off. Regards from Tom :) I use to use Base like this. I connect a Base document to HSQL 2.8 databases with forms and reports on the desktop (spreadsheet reports are sufficient for us). The Base container is nothing but a configuration file storing the connection URL, SQL query strings and the default log-in (and I left some rarely used admin forms in it). My users do not know anything about the database document. The content of the database document could be some XML and query strings in the configuration tree (just like it used to be in OOo 1). -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 04/17/2012 02:13 PM, ptoye wrote: Pertti Rönnberg wrote Well said Peter! I totally and completely agree with you and Ian Whitfield. Well, someone likes me! My point is that I'm really a hacker when it comes to databases, not a professional coder, and life really needs to be made easier. I'm almost thinking of installing something like MySQL and writing my own front-end in Java. Try MySQL Workbench as MySQL/MariaDB front-end. It has a nice GUI interface and is FOSS. There is Ubuntu ppa for Natty and Oneiric if the version found on Oracle does not work. There is a browser/php based GUI front-end phpMyAdmin I believe is the name. Another front end is HeidiSQL, it is included with the Windows version of MariaDB. There is no Linux version of this front-end. Is there any point in suggesting that LibO and OO should continue to diverge? I'd have thought convergence would be more productive, both in terms of the development which seems too thinly spread, and for users who might even see a serious contender emerging. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3918036.html Sent from the Users mailing list archive at Nabble.com. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 2012-04-18 06:13, ptoye wrote: Pertti Rönnberg wrote Well said Peter! I totally and completely agree with you and Ian Whitfield. Well, someone likes me! My point is that I'm really a hacker when it comes to databases, not a professional coder, and life really needs to be made easier. I'm almost thinking of installing something like MySQL and writing my own front-end in Java. That's what I did, but front end in Apache/PHP. Take it anywhere, easily migrate, update. Data security (from fall over and future proofing. Divergence not an issue.) Steve Is there any point in suggesting that LibO and OO should continue to diverge? I'd have thought convergence would be more productive, both in terms of the development which seems too thinly spread, and for users who might even see a serious contender emerging. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3918036.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Pertti Rönnberg wrote > > > Well said Peter! > > I totally and completely agree with you and Ian Whitfield. > > Well, someone likes me! My point is that I'm really a hacker when it comes to databases, not a professional coder, and life really needs to be made easier. I'm almost thinking of installing something like MySQL and writing my own front-end in Java. Is there any point in suggesting that LibO and OO should continue to diverge? I'd have thought convergence would be more productive, both in terms of the development which seems too thinly spread, and for users who might even see a serious contender emerging. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3918036.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 17/04/2012 18:14, Andreas Säger wrote: Am 17.04.2012 17:38, Tom Davies wrote: Hi :) Would it be easy to upgrade the HSqlDb embedded in Base or would all the tweaks need to be applied? Are the tweaks vital or could they left out? Regards from Tom :) The easiest improvements in my honest opinion: - Wipe out the .odb container all together and get back to the configuration of database access in OOo 1. Back to external databases with configuration data in configuration files, forms and reports in stand-alone office documents. More speed more safety, security, accessibility and transparency. People who do not understand how to connect separated software tools do not understand the .odb container neither (as we can read in all the mail merge topics). - Remove all the half done wizards. Do not improve them. Remove! No database developer nor interface designer needs all this stinky rubbish. There are graphical tools to compose forms and reports within office documents. There is SQL for all the rest, including all the things we can not do in the current graphical interface. There are plenty of SQL editors to produce valid SQL for various databases. SQL text can be pasted into any database configuration. - Add native database queries, so the current "direct SQL mode" returns editable row sets and the (useless or even harmful) graphical query designer can be removed as well. - Having removed all the wizards (they are Java components) without losing any functionality at all, extensions could substitute .odb packages. When you open the extension, the database gets installed _permanently_ (rather than _temporarily_ like the .odb) into the configuration tree together with the forms and reports documents. The database will be registered and all the tables, queries, forms and reports are accessible form the data source window, hyperlinks and desktop links just like it used to be in OOo 1. + 1000 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) It looks like most of this can be done without touching Base itself? Is LO able to use databases in this way already? Is it something that could be passed to the devs list an/or the BoD discussion list? Something like this could be phrased to capture the imagination, Saying it's the old way might put them off. Regards from Tom :) --- On Tue, 17/4/12, Andreas Säger wrote: From: Andreas Säger Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 17:14 Am 17.04.2012 17:38, Tom Davies wrote: > Hi :) > Would it be easy to upgrade the HSqlDb embedded in Base or would all the > tweaks need to be applied? Are the tweaks vital or could they left out? > Regards from > Tom :) > > The easiest improvements in my honest opinion: - Wipe out the .odb container all together and get back to the configuration of database access in OOo 1. Back to external databases with configuration data in configuration files, forms and reports in stand-alone office documents. More speed more safety, security, accessibility and transparency. People who do not understand how to connect separated software tools do not understand the .odb container neither (as we can read in all the mail merge topics). - Remove all the half done wizards. Do not improve them. Remove! No database developer nor interface designer needs all this stinky rubbish. There are graphical tools to compose forms and reports within office documents. There is SQL for all the rest, including all the things we can not do in the current graphical interface. There are plenty of SQL editors to produce valid SQL for various databases. SQL text can be pasted into any database configuration. - Add native database queries, so the current "direct SQL mode" returns editable row sets and the (useless or even harmful) graphical query designer can be removed as well. - Having removed all the wizards (they are Java components) without losing any functionality at all, extensions could substitute .odb packages. When you open the extension, the database gets installed _permanently_ (rather than _temporarily_ like the .odb) into the configuration tree together with the forms and reports documents. The database will be registered and all the tables, queries, forms and reports are accessible form the data source window, hyperlinks and desktop links just like it used to be in OOo 1. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 17.04.2012 17:38, Tom Davies wrote: Hi :) Would it be easy to upgrade the HSqlDb embedded in Base or would all the tweaks need to be applied? Are the tweaks vital or could they left out? Regards from Tom :) The easiest improvements in my honest opinion: - Wipe out the .odb container all together and get back to the configuration of database access in OOo 1. Back to external databases with configuration data in configuration files, forms and reports in stand-alone office documents. More speed more safety, security, accessibility and transparency. People who do not understand how to connect separated software tools do not understand the .odb container neither (as we can read in all the mail merge topics). - Remove all the half done wizards. Do not improve them. Remove! No database developer nor interface designer needs all this stinky rubbish. There are graphical tools to compose forms and reports within office documents. There is SQL for all the rest, including all the things we can not do in the current graphical interface. There are plenty of SQL editors to produce valid SQL for various databases. SQL text can be pasted into any database configuration. - Add native database queries, so the current "direct SQL mode" returns editable row sets and the (useless or even harmful) graphical query designer can be removed as well. - Having removed all the wizards (they are Java components) without losing any functionality at all, extensions could substitute .odb packages. When you open the extension, the database gets installed _permanently_ (rather than _temporarily_ like the .odb) into the configuration tree together with the forms and reports documents. The database will be registered and all the tables, queries, forms and reports are accessible form the data source window, hyperlinks and desktop links just like it used to be in OOo 1. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) Would it be easy to upgrade the HSqlDb embedded in Base or would all the tweaks need to be applied? Are the tweaks vital or could they left out? Regards from Tom :) --- On Tue, 17/4/12, Andreas Säger wrote: From: Andreas Säger Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 16:28 Am 17.04.2012 16:03, Pertti Rönnberg wrote: > To the LibO-folks and developers I repeat: > > Stop developing LibO-Base;go back to the latest stable version and start > to complete it and repair all discrepancies in the program and between > the program and it’s documentation! > > There is so much good done in LibO-Base so why not get the rest OK? So > it at least should meet the promises in advertising.! Without problems! > As far as I can see, the Base component of LibO 3.5 is identical to the one in OOo 3.3. > And: > What (in @!?*@!??) can be the clever idea with having in LibO-base a > embedded HSQL v.1.8 that is not supported any more when the latest > version is 2.2.x? What about e.g. SQLite? > Within a few minutes you can export your embedded HSQL 1.8 to an external HSQL 2.8. This is really a piece of cake. SQLite would not solve a single problem with Base, even if somebody would manage to "integrate" this thing. It would be rather different from all the other supported databases. HSQL is a "vanilla database". There is nothing special with its features and data types. Being a very well done Java application it is platform independent byte by byte. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 17.04.2012 16:03, Pertti Rönnberg wrote: To the LibO-folks and developers I repeat: Stop developing LibO-Base;go back to the latest stable version and start to complete it and repair all discrepancies in the program and between the program and it’s documentation! There is so much good done in LibO-Base so why not get the rest OK? So it at least should meet the promises in advertising.! Without problems! As far as I can see, the Base component of LibO 3.5 is identical to the one in OOo 3.3. And: What (in @!?*@!??) can be the clever idea with having in LibO-base a embedded HSQL v.1.8 that is not supported any more when the latest version is 2.2.x? What about e.g. SQLite? Within a few minutes you can export your embedded HSQL 1.8 to an external HSQL 2.8. This is really a piece of cake. SQLite would not solve a single problem with Base, even if somebody would manage to "integrate" this thing. It would be rather different from all the other supported databases. HSQL is a "vanilla database". There is nothing special with its features and data types. Being a very well done Java application it is platform independent byte by byte. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) Almost no-one is developing Base or at least developments are not reaching the releases. So LO Base is almost no different from OOo's Base except that it might have some regressions from the developments of other components of LO. I get the impression that there is no official guide for OOo's Base and so i am hoping that the documentation being written for LO/OOo Base will help the devs work out what needs to be worked on or at least how Base should be working. The BoD are against the idea of pulling in expertise from the various back-ends that could work well with Base. Someone did approach Postgresql and they seemed positive but they need to break through the reluctance of the BoD. I figured that we might get some feedback if people here started using MariaDb. Obviously people from MySql are unlikely to help as MySql is owned by Oracle. However the database experts here would rather promote MySql which is only ever going to be a one-way street. I had hoped that other people would approach other projects such as (crucially) HSqlDb. Collaborating about Base is difficult because the experts and required skills are scattered across several different mailing list and none are willing to join another high-traffic list that hardly ever deals with Base. The BoD say they have more important issues to deal with and can't spare the resources of setting up a mailing list dedicated to Base. - After all the other apps/modules of LO don't have their own mailing lists and don't need them so why treat Base any different? The BoD's big plan for getting Base up to scratch is to sit&wait to see if someone gets annoyed enough with it to start working at it but the problems are more extensive than 1 or 2 people could handle so every-time someone starts they get demoralised and leave. Ian is just one more example of this. Dan is a star for making such a good start on the documentation. Regards from Tom :) --- On Tue, 17/4/12, Pertti Rönnberg wrote: From: Pertti Rönnberg Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 15:03 On 17.4.2012 12:34, ptoye wrote: > Andreas Säger wrote >> Why can't you run SQL update queries? This is trivial to do in SQL. The >> SQL is trivial to execute by macro. >> If you desparately want a graphical query designer for >> update/insert/delete queries, then you should write one and store your >> queries somewhere in the .odb container. >> >> > Of course I can. If I can find out how to do it. > > But this isn't the point, is it? The real point is that database front-ends > and macro languages are meant to make life easy, not difficult. You seem to > dislike "sugar" - worried about your diameter? The computer was made for > man, not man for the computer. Why not program in assembler - gives you much > more control and isn't really that hard (I speak from years of assembler > experience and with my tongue firmly in my cheek)? > > - > Peter > -- > View this message in context: > http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.html > Sent from the Users mailing list archive at Nabble.com. > Well said Peter! I totally and completely agree with you and Ian Whitfield. And thanks to Ian for the tips about Kexi – I am almost ready for anything but LibO-Base. Since the beginning of this year I have been trying to create a similar member register about a boy scout organization’s senior leaders also collecting memorable info from gone days – before these leaders are gone. The most I got from the efforts is waste of time and frustration. A week ago Dan Lewis kindly sent to me drafts on documentation about creating a Base-db. It is very well written, clear, logic, easy to follow – but it is a draft, written in 2010 for OpenO. As far as I could see, there are nothing similar for LibO-Base yet. Regarding LibO-Base’s situation today, very much should be helped if that Dan’s documentation should be completed and finished and included in the LibO’s (Base) introduction. (When following Dan’s documentation I also noticed that in LibO-Base you can create a form /_based on a query_/ only using the Form Wizard – Design View allows you to create a form /_only based on a table = one table!_/) To the LibO-folks and developers I repeat: Stop developing LibO-Base;go back to the latest stable version and start to complete it and repair all discrepancies in the program and between the program and it’s documentation! There is so much good done in LibO-Base so why not get the rest OK? So it at least should meet the promises in advertising.! Without problems! And: What (in @!?*@!??) can be the clever idea with having in LibO-base a embedded HSQL v.1.8 th
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 17.4.2012 12:34, ptoye wrote: Andreas Säger wrote Why can't you run SQL update queries? This is trivial to do in SQL. The SQL is trivial to execute by macro. If you desparately want a graphical query designer for update/insert/delete queries, then you should write one and store your queries somewhere in the .odb container. Of course I can. If I can find out how to do it. But this isn't the point, is it? The real point is that database front-ends and macro languages are meant to make life easy, not difficult. You seem to dislike "sugar" - worried about your diameter? The computer was made for man, not man for the computer. Why not program in assembler - gives you much more control and isn't really that hard (I speak from years of assembler experience and with my tongue firmly in my cheek)? - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.html Sent from the Users mailing list archive at Nabble.com. Well said Peter! I totally and completely agree with you and Ian Whitfield. And thanks to Ian for the tips about Kexi – I am almost ready for anything but LibO-Base. Since the beginning of this year I have been trying to create a similar member register about a boy scout organization’s senior leaders also collecting memorable info from gone days – before these leaders are gone. The most I got from the efforts is waste of time and frustration. A week ago Dan Lewis kindly sent to me drafts on documentation about creating a Base-db. It is very well written, clear, logic, easy to follow – but it is a draft, written in 2010 for OpenO. As far as I could see, there are nothing similar for LibO-Base yet. Regarding LibO-Base’s situation today, very much should be helped if that Dan’s documentation should be completed and finished and included in the LibO’s (Base) introduction. (When following Dan’s documentation I also noticed that in LibO-Base you can create a form /_based on a query_/ only using the Form Wizard – Design View allows you to create a form /_only based on a table = one table!_/) To the LibO-folks and developers I repeat: Stop developing LibO-Base;go back to the latest stable version and start to complete it and repair all discrepancies in the program and between the program and it’s documentation! There is so much good done in LibO-Base so why not get the rest OK? So it at least should meet the promises in advertising.! Without problems! And: What (in @!?*@!??) can be the clever idea with having in LibO-base a embedded HSQL v.1.8 that is not supported any more when the latest version is 2.2.x? What about e.g. SQLite? As Peter said:thus making the life easier -- and if not easier but not more difficult! Regards Pertti Rönnberg -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) Not really a troll. The chap has worked harder than most to try to get Base more widely accepted both within TDF and outside and has tried to be positive about it. However it's good to hear he has found success with a different OpenSource program. It's also good to hear that Kexi appears to be better than it was. Regards from Tom :) --- On Tue, 17/4/12, Andreas Säger wrote: From: Andreas Säger Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 12:58 Am 17.04.2012 11:28, Ian Whitfield wrote: >> On 04/15/2012 08:58 AM, David wrote: > ... >>>> >> >> What database doe you think works better than OpenOffice or >>>> LibreOffice? >>>> >> >> I don't have any views on this matter. > After using OO/LO Base for over 5 years now I gave up last month after > the latest "crash". It has been an ongoing battle to keep my DB > operational and I was really fed-up with all the crashes, loss of data > and time spent fixing the DB etc etc over the years. > Beware of the troll! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 17.04.2012 11:28, Ian Whitfield wrote: On 04/15/2012 08:58 AM, David wrote: > ... >> >> What database doe you think works better than OpenOffice or LibreOffice? >> I don't have any views on this matter. After using OO/LO Base for over 5 years now I gave up last month after the latest "crash". It has been an ongoing battle to keep my DB operational and I was really fed-up with all the crashes, loss of data and time spent fixing the DB etc etc over the years. Beware of the troll! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 17.04.2012 11:34, ptoye wrote: Andreas Säger wrote Why can't you run SQL update queries? This is trivial to do in SQL. The SQL is trivial to execute by macro. If you desparately want a graphical query designer for update/insert/delete queries, then you should write one and store your queries somewhere in the .odb container. Of course I can. If I can find out how to do it. But this isn't the point, is it? The real point is that database front-ends and macro languages are meant to make life easy, not difficult. You seem to dislike "sugar" - worried about your diameter? The computer was made for man, not man for the computer. Why not program in assembler - gives you much more control and isn't really that hard (I speak from years of assembler experience and with my tongue firmly in my cheek)? - You get what you pay for. The rest is about community. Unfortunately, this office suite has more consumers and complainers than contributors. Regarding your remark on assembler code: A very high software stack imposes a new quality of problems that would be unknown on hardware level. Fortunately, there is still the OpenOffice.org community: http://extensions.services.openoffice.org/en/project/access2base (which could be even more useful if someone would rewrite these Basic routines as a true extension of UNO-components) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) Dohhh, that last post was meant to be off-list!! Regards from Tom :) --- On Tue, 17/4/12, Ian Whitfield wrote: From: Ian Whitfield Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 10:28 > On 04/15/2012 08:58 AM, David wrote: > ... >>> >> >> What database doe you think works better than OpenOffice or >>> >>LibreOffice? >>> >> > I don't have any views on this matter. After using OO/LO Base for over 5 years now I gave up last month after the latest "crash". It has been an ongoing battle to keep my DB operational and I was really fed-up with all the crashes, loss of data and time spent fixing the DB etc etc over the years. I'm NOT running a fancy DB here - just a Membership List with about 2500 records, each record with three photos and approx 70 fields. A bunch of Queries and a few Reports so it's not exactly "Rocket Science"!! I came to the very sad conclusion, (after my last "crash" when Base managed to randomly drop about a quarter of my Data (not complete records but fields in the records), and scramble about another third!!! AND it would no longer even run my 'User Form'!!), that Base is NOT fit for purpose. This is MY opinion - and I think 5 years is a long enough time to get a good "feel" for it - but no doubt I will get "flamed" for this comment. LONG story short I have now moved my (re-built) Database on to Kexi - and what a difference It's like getting out of an old broken-down VW (or other make) of car and getting into a brand new Jaguar and driving down the highway at 100mph!! And I know what that feels like as I did just that last year in the UK!! Yes there is a lot to learn and work out but the overall effect is like Chalk and Cheese!! For anyone interested I can recommend this DB - some of the more fancy options are only due out in future releases but for a basic DB job it "just works"!! I'm NOT missing Base!! Ian Whitfield Pretoria -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
off-list Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) I guess you tried using various external back-ends? Did you consider using one of the back-ends without having Base as the front-end? People have already suggested that Kexi is not even as 'advanced' as Base but that was about a year ago so it's quite possible they were wrong or that things have changed. It's good to have something i can recommend to people that are unhappy with Base because Base is clearly not ready and doesn't have enough devs working on it. Regards from Tom :) --- On Tue, 17/4/12, Ian Whitfield wrote: From: Ian Whitfield Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 10:28 > On 04/15/2012 08:58 AM, David wrote: > ... >>> >> >> What database doe you think works better than OpenOffice or >>> >>LibreOffice? >>> >> > I don't have any views on this matter. After using OO/LO Base for over 5 years now I gave up last month after the latest "crash". It has been an ongoing battle to keep my DB operational and I was really fed-up with all the crashes, loss of data and time spent fixing the DB etc etc over the years. I'm NOT running a fancy DB here - just a Membership List with about 2500 records, each record with three photos and approx 70 fields. A bunch of Queries and a few Reports so it's not exactly "Rocket Science"!! I came to the very sad conclusion, (after my last "crash" when Base managed to randomly drop about a quarter of my Data (not complete records but fields in the records), and scramble about another third!!! AND it would no longer even run my 'User Form'!!), that Base is NOT fit for purpose. This is MY opinion - and I think 5 years is a long enough time to get a good "feel" for it - but no doubt I will get "flamed" for this comment. LONG story short I have now moved my (re-built) Database on to Kexi - and what a difference It's like getting out of an old broken-down VW (or other make) of car and getting into a brand new Jaguar and driving down the highway at 100mph!! And I know what that feels like as I did just that last year in the UK!! Yes there is a lot to learn and work out but the overall effect is like Chalk and Cheese!! For anyone interested I can recommend this DB - some of the more fancy options are only due out in future releases but for a basic DB job it "just works"!! I'm NOT missing Base!! Ian Whitfield Pretoria -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Andreas Säger wrote > > Why can't you run SQL update queries? This is trivial to do in SQL. The > SQL is trivial to execute by macro. > If you desparately want a graphical query designer for > update/insert/delete queries, then you should write one and store your > queries somewhere in the .odb container. > > Of course I can. If I can find out how to do it. But this isn't the point, is it? The real point is that database front-ends and macro languages are meant to make life easy, not difficult. You seem to dislike "sugar" - worried about your diameter? The computer was made for man, not man for the computer. Why not program in assembler - gives you much more control and isn't really that hard (I speak from years of assembler experience and with my tongue firmly in my cheek)? - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 04/15/2012 08:58 AM, David wrote: > ... >> >> What database doe you think works better than OpenOffice or LibreOffice? >> I don't have any views on this matter. After using OO/LO Base for over 5 years now I gave up last month after the latest "crash". It has been an ongoing battle to keep my DB operational and I was really fed-up with all the crashes, loss of data and time spent fixing the DB etc etc over the years. I'm NOT running a fancy DB here - just a Membership List with about 2500 records, each record with three photos and approx 70 fields. A bunch of Queries and a few Reports so it's not exactly "Rocket Science"!! I came to the very sad conclusion, (after my last "crash" when Base managed to randomly drop about a quarter of my Data (not complete records but fields in the records), and scramble about another third!!! AND it would no longer even run my 'User Form'!!), that Base is NOT fit for purpose. This is MY opinion - and I think 5 years is a long enough time to get a good "feel" for it - but no doubt I will get "flamed" for this comment. LONG story short I have now moved my (re-built) Database on to Kexi - and what a difference It's like getting out of an old broken-down VW (or other make) of car and getting into a brand new Jaguar and driving down the highway at 100mph!! And I know what that feels like as I did just that last year in the UK!! Yes there is a lot to learn and work out but the overall effect is like Chalk and Cheese!! For anyone interested I can recommend this DB - some of the more fancy options are only due out in future releases but for a basic DB job it "just works"!! I'm NOT missing Base!! Ian Whitfield Pretoria -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 17.04.2012 10:52, ptoye wrote: Access allows update queries, which are sadly missing from LO/OO. Why can't you run SQL update queries? This is trivial to do in SQL. The SQL is trivial to execute by macro. If you desparately want a graphical query designer for update/insert/delete queries, then you should write one and store your queries somewhere in the .odb container. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
NoOp wrote > > On 04/15/2012 08:58 AM, David wrote: > ... >> >> What database doe you think works better than OpenOffice or LibreOffice? >> >> > > Pick. > I don't have any views on this matter. I vaguely remember that Lotus Approach allowed far more flexibility in allowing updates to multiple tables, but that was a long time ago and is no longer available (AFAIK). Access allows update queries, which are sadly missing from LO/OO. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916631.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
On 04/15/2012 08:58 AM, David wrote: ... > > What database doe you think works better than OpenOffice or LibreOffice? > > Pick. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 15.04.2012 17:48, ptoye wrote: Well, I seem to have started off quite a discussion. It's interesting that Andreas seems to agree with me that OO isn't really for programming. And the use of ODF is extremely important for intercommunicability, a point which isn't taken by many MS addicts. But I'm not trying to use a database to write a form letter - I'm not even a fully-fledged business, just a freelance pianist. But I do like to play with applications, and occasionally write my own where I can't find a suitable share- or free-ware one. And Base just doesn't work well enough - too many bugs and I suspect not enough will to drive proper develop,emt - hence Andrea's comments on "Potemkin". The Potemkin village mimics a full featured rural community but it is no more than a scenery. When you click through the items of a database window, it looks as if you could find everything you need. As soon as you kicked all tires you will notice that it does only a small portion of what it pretends to do. Once you downloaded and studied some example databases, you will find a true village behind the pretty scenes. It provides everything you need to settle down: plain SQL, form design tools, various options to produce reports without builders nor wizards. The results not perfect but fairly well usable. Once you fully understand this extremely simplified tool set you may write some macros or extensions. Tom's comment on 4 languages being available is fine, but as the API's so impenetrable I feel it would have been better idea concentrate on getting one language right rather than four languages wrong! Others are at liberty to disagree. As far as spreadsheets and text documents are concerned, I can find most of the objects within a minute. The languages are all right. Python, Java, JavaScript are not developed by the LibreOffice team. The office API is completely independent from the language. There is an office API, a mature programming language and a few lines of glue code (bridge). - You need to know a certain API basement right from the start (frame, controller, model, services, interfaces, structs). - Of course you need to know the application on the GUI level very well. - The language you are using should be familiar to you. - You should know how to analyse the self-documenting UNO objects. There are powerful tools for this. I use to recommend the MRI extension. Even this development helper wants to be explored patiently. As a developer you have to adjust yourself to the application before you can adjust the application to your needs. On API level this office is radically different from MS Office. This is because "economy" has a different meaning in open source context. Starting with a concrete task imposing a deadline will certainly lead to frustration. That's what I learned with VBA 17 years ago. Once I really studied a well written VBA book, everything was quick and easy even though Office 95 had no code completion. This API is just like any other complex API. This implies that it is by far more abstract (closer to the source code) than VBA which is a thick abstraction layer tailored around the respective office application within one particular OS. Porting VBA to the MAC succeeded after years of hard work because it was never intended to work on a system other than WIndows. This office suite does not have any such problems because it is not covered by thick sugar coating. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Mark Stanton wrote > > > Multi-table update support is an SQL limitation, isn't it? > > Mark Stanton > > I don't think so. As I understand it it all depends on the database engine at the back of it all. Some allow it when it's not ambiguous, others don't. HDBC doesn't. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3914969.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 16/04/12 14:49, Mark Stanton a écrit : Hi Mark, >> - multiple table query/update support > > Multi-tabe query is available, surely? Where it's not available is in > file mode when there's no backing database engine. Or having I missed > somthing? > > Multi-table update support is an SQL limitation, isn't it? Sorry, I should have been more precise : Lotus Approach allowed a user to create a form based on a query of a collection of DBF tables and then be able to update them via the form (or an update statement) - of course, relationships/foreign keys needed to be involved, but it did work. This was a particular plus point over the single flatfile driver that we have always had with OOo and now LO. In other words, it allowed for updates/writes to cross-table flatfiles as far as I can recall. You can not do this with the flatfile driver of LO - only a single DBF file can be updated/written to at one time, and as for Calc or Excel, well they are just read only datasources within the framework of Base. I don't know how Lotus/IBM did this, but it was a very, very, neat feature. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Am 16.04.2012 14:49, Mark Stanton wrote: - multiple table query/update support Multi-table update support is an SQL limitation, isn't it? At least it requires that a foreign key is linked to another table's unique (primary) key, otherwise it is uncertain which one of the related rows you are going to update. This has improved in OOo 3.3. with embedded HSQLDB: SELECT "A".*, "B".* FROM "A" JOIN "B" ON "A"."ID"="B"."AID" selects an editable row set from 2 related tables (A.PrimaryKey=B.ForeignKey). For anything else there are subforms and list boxes. These two elements let you edit related tables in any case. Comparing this supplementary tool set with a full featured database suite is not fair. Many people can not accept anything less sophisticated than MS Access. The difference amounts to a full decade with a multi-million dollar budget. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 16/04/12 10:09, Mark Stanton a écrit : Hi Mark, > What was it you liked about Approach (I used that too)? > > I'm asking for feature ideas. > As a former Lotus Approach user, off the cuff : - multiple table query/update support - add/delete/modify/clone data button objects that worked (similar to Access and FileMaker Pro) ; - errm, I seem to recall that it had a good relationships manager ; - Lotus Smartscript (in other words a competent script recorder, script programming API) ? - BLOB/CLOB support - LO's is incomplete to say the least, and by default only lets you play with images - getting a binary stream to function (e.g. video, or music) into and out of a db is more or less mission impossible - the current best (only?) practice is to use VARCHAR for the file name, store the binary data independently and then use cURL from Basic in an attempt to read the binary stream and turn it into something useful - heaven forbid that you might wish to actually write something new into the stream... - reliable date type conversions !! (cf. the differences in Date types within LO as a whole, I believe there are/were 3 different types (Calc, Base and Basic !!) - oh and I forgot the Java date/time spec too ! - it just worked !! sorry, that was not a suggestion, but an opinion ;-) Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 2012-04-16 03:58, David wrote: On 4/15/2012 11:48 AM, ptoye wrote: Well, I seem to have started off quite a discussion. It's interesting that Andreas seems to agree with me that OO isn't really for programming. And the use of ODF is extremely important for intercommunicability, a point which isn't taken by many MS addicts. But I'm not trying to use a database to write a form letter - I'm not even a fully-fledged business, just a freelance pianist. But I do like to play with applications, and occasionally write my own where I can't find a suitable share- or free-ware one. And Base just doesn't work well enough - too many bugs and I suspect not enough will to drive proper develop,emt - hence Andrea's comments on "Potemkin". Tom's comment on 4 languages being available is fine, but as the API's so impenetrable I feel it would have been better idea concentrate on getting one language right rather than four languages wrong! Others are at liberty to disagree. What database doe you think works better than OpenOffice or LibreOffice? I liked the old Lotus Approach database. I moved from that to Apache/MySQL/PHP. If Base was as good as lotus was I would do my next project in Base, but I think I will stick with a [LW]AMP solution because I am confident of the results for at least the next 5 years. steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Tom wrote (15-04-12 13:34) Well, in many ways it's really only 1 product but in other ways it allows each to focus on slightly different niches in the market. Well, LibreOffice came from the same code base. But seeing all that has been done for LibreOffice the last year, it's hard to say any longer that it's one product (in many ways). Much still is shared, yes that's true. Cheers, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
ptoye wrote (13-04-12 16:30) Manual refresh doesn't help. I'm afraid. And the workaround is even simpler - keep using Open Office! Looking at how little had been done there the last years with Base and how much in LibreOffice, I hardly can imagine you'll become happy there ;-) Cheers, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) Lol, i was expecting you to say Postgresql. There are other much lighter-weight ones more suitable for small databases but we almost never hear about them. Perhaps SqLite or something? I guess this is a topic for a different thread. Regards from Tom :) --- On Sun, 15/4/12, Jay Lozier wrote: I prefer to use MariaDB/MySQL and use Base as a front end. There are other FOSS rdms available that might be more suitable to your needs. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 04/15/2012 11:58 AM, David wrote: On 4/15/2012 11:48 AM, ptoye wrote: Well, I seem to have started off quite a discussion. It's interesting that Andreas seems to agree with me that OO isn't really for programming. And the use of ODF is extremely important for intercommunicability, a point which isn't taken by many MS addicts. But I'm not trying to use a database to write a form letter - I'm not even a fully-fledged business, just a freelance pianist. But I do like to play with applications, and occasionally write my own where I can't find a suitable share- or free-ware one. And Base just doesn't work well enough - too many bugs and I suspect not enough will to drive proper develop,emt - hence Andrea's comments on "Potemkin". Tom's comment on 4 languages being available is fine, but as the API's so impenetrable I feel it would have been better idea concentrate on getting one language right rather than four languages wrong! Others are at liberty to disagree. What database doe you think works better than OpenOffice or LibreOffice? I prefer to use MariaDB/MySQL and use Base as a front end. There are other FOSS rdms available that might be more suitable to your needs. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) True. I was hoping it was 2 separate questions; 1 about Base and the other about macros. Both together is likely to be tricky. Regards from Tom :) --- On Sun, 15/4/12, ptoye wrote: From: ptoye Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Sunday, 15 April, 2012, 17:39 Tom wrote > > Hi :) >>From what Andreas and others say i think that is most of the problem with Base. Too many great ideas that only got half done. I guess it might be the same with macros. > > Apparently Andrew Pitonyak's guide is one of the best ways to get into > macro programming > https://wiki.documentfoundation.org/Documentation/Publications#Programmers > Regards from > Tom :) > > > Yes, I've downloaded it and really will read it when I have a spare month It seems very good, but omits Base entirely AFAICS. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3912274.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Tom wrote > > Hi :) >>From what Andreas and others say i think that is most of the problem with Base. Too many great ideas that only got half done. I guess it might be the same with macros. > > Apparently Andrew Pitonyak's guide is one of the best ways to get into > macro programming > https://wiki.documentfoundation.org/Documentation/Publications#Programmers > Regards from > Tom :) > > > Yes, I've downloaded it and really will read it when I have a spare month It seems very good, but omits Base entirely AFAICS. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3912274.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) >From what Andreas and others say i think that is most of the problem with >Base. Too many great ideas that only got half done. I guess it might be the >same with macros. Apparently Andrew Pitonyak's guide is one of the best ways to get into macro programming https://wiki.documentfoundation.org/Documentation/Publications#Programmers Regards from Tom :) --- On Sun, 15/4/12, David wrote: From: David Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Sunday, 15 April, 2012, 16:58 On 4/15/2012 11:48 AM, ptoye wrote: > Well, I seem to have started off quite a discussion. It's interesting that > Andreas seems to agree with me that OO isn't really for programming. And the > use of ODF is extremely important for intercommunicability, a point which > isn't taken by many MS addicts. > > But I'm not trying to use a database to write a form letter - I'm not even a > fully-fledged business, just a freelance pianist. But I do like to play with > applications, and occasionally write my own where I can't find a suitable > share- or free-ware one. And Base just doesn't work well enough - too many > bugs and I suspect not enough will to drive proper development - hence > Andrea's comments on "Potemkin". > > Tom's comment on 4 languages being available is fine, but as the API's so > impenetrable I feel it would have been better idea concentrate on getting one > language right rather than four languages wrong! Others are at liberty to > disagree. What database doe you think works better than OpenOffice or LibreOffice? David -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
David-4 wrote > > What database doe you think works better than OpenOffice or LibreOffice? > I don't. I found MS Access as easy to use and with a better-developed macro language. But I was not doing anything too complicated with it. The over-complex API (or is it just the way the documentation works?) for OO/LO and the lack of a decent IDE are real turn-offs for anyone trying to do anything but the simplest task. For example, events aren't called when the documentation implies that they should be (see http://user.services.openoffice.org/en/forum/viewtopic.php?f=45&t=49924&start=30). Bug? Feature? I don't know. But comments on that forum are as discouraging are those here. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3912228.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 4/15/2012 11:48 AM, ptoye wrote: > Well, I seem to have started off quite a discussion. It's interesting that > Andreas seems to agree with me that OO isn't really for programming. And the > use of ODF is extremely important for intercommunicability, a point which > isn't taken by many MS addicts. > > But I'm not trying to use a database to write a form letter - I'm not even a > fully-fledged business, just a freelance pianist. But I do like to play with > applications, and occasionally write my own where I can't find a suitable > share- or free-ware one. And Base just doesn't work well enough - too many > bugs and I suspect not enough will to drive proper develop,emt - hence > Andrea's comments on "Potemkin". > > Tom's comment on 4 languages being available is fine, but as the API's so > impenetrable I feel it would have been better idea concentrate on getting > one language right rather than four languages wrong! Others are at liberty > to disagree. What database doe you think works better than OpenOffice or LibreOffice? -- David -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Well, I seem to have started off quite a discussion. It's interesting that Andreas seems to agree with me that OO isn't really for programming. And the use of ODF is extremely important for intercommunicability, a point which isn't taken by many MS addicts. But I'm not trying to use a database to write a form letter - I'm not even a fully-fledged business, just a freelance pianist. But I do like to play with applications, and occasionally write my own where I can't find a suitable share- or free-ware one. And Base just doesn't work well enough - too many bugs and I suspect not enough will to drive proper develop,emt - hence Andrea's comments on "Potemkin". Tom's comment on 4 languages being available is fine, but as the API's so impenetrable I feel it would have been better idea concentrate on getting one language right rather than four languages wrong! Others are at liberty to disagree. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3912142.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
ptoye wrote > > Glad to hear it. But IMHO Base is just nowhere compared to Access (which > itself isn't much to shout about). And OO Basic compared to VBA similarly. > As an ex-programmer I'm always keen to automate any process, but the OO > Basic learning curve turns many people off (as far as I can see from > bulletin board comments - even this one) before they even start. > > Agreed that MS have problems in forwards compatibility. But that's an > impossible dream. Can OO version 1 open OO version 3 documents? > > Unfortunately I'm too short of time to contribute to OO/LO development - I > suspect there's another 2-year learning curve. > The whole office suite is about the ODF document standard. The database connectivity is just a tiny extra. It lets you import arbitrary tabular data into ODF documents for serial letters, labels and for calculation models. Additionally you may attach very simple and very generic form controls (like HTML forms) to ODF documents in order to write some data from your keyboard or clipboard back into some editable database via ODBC or JDBC. That's all. No more, no less. The "database application" called "Base" exists only as a http://en.wikipedia.org/wiki/Potemkin_village. Nevertheless, this part of the office suite is extremely productive and helpful as is. In our small business we have almost no spreadsheet nor Writer document which does not rely on some type of data source one way or the other. Writer's mail merge feature is far from perfect but if you have at least one fairly computer literate person able to write very simple SQL queries, all you need is the information: "Write your serial letter into template X and connect the document with data source Y and query Z". The editor does not need to care if data source Y is a database, a spreadsheet, a csv file or something else. With a few clicks the new letter is connected to the right table. In addition I implemented a small inventory database which is not offered as a component of our proprietary business software. Everybody is happy with it even though it is not as pretty and streamlined as it could be. With a few lines of very simple macro code my database outperforms any "Excel solution", let alone paper records. The first version was almost as good with zero lines of macro code. If you want to earn money with perfectly streamlined database solutions based on the Base component you surely would have to overstretch the whole thing. Even if you'd learn everything about that API it would not help much because the thing behind the API is not ready for business and propably never will be because that would take hundreds of thousands of code lines far beyond the scope of the ODF document standard. -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3912112.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) +1 re: Base. It's potential is awesome and even as it is now it can do some pretty amazing things easily that Access makes difficult but even so Access seems to be easier for most normal uses. I'm not sure about the Macro languages but LO/OOo seems to offer a choice of 4 languages, none of which have been successfully used for malware out in the wild even at the low percentage you would expect given market share but maybe that might change in the future, i'm not sure. Hmm, my point about compatibility was badly made. Forwards compatibility is always likely to be a problem but MSO seems to have problems with sideways (different version of Windows) and backwards compatibility, at least according to their installer's notes for MSO 2010. Regards from Tom :) --- On Sun, 15/4/12, ptoye wrote: From: ptoye Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Sunday, 15 April, 2012, 14:34 Glad to hear it. But IMHO Base is just nowhere compared to Access (which itself isn't much to shout about). And OO Basic compared to VBA similarly. As an ex-programmer I'm always keen to automate any process, but the OO Basic learning curve turns many people off (as far as I can see from bulletin board comments - even this one) before they even start. Agreed that MS have problems in forwards compatibility. But that's an impossible dream. Can OO version 1 open OO version 3 documents? Unfortunately I'm too short of time to contribute to OO/LO development - I suspect there's another 2-year learning curve. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3911931.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Glad to hear it. But IMHO Base is just nowhere compared to Access (which itself isn't much to shout about). And OO Basic compared to VBA similarly. As an ex-programmer I'm always keen to automate any process, but the OO Basic learning curve turns many people off (as far as I can see from bulletin board comments - even this one) before they even start. Agreed that MS have problems in forwards compatibility. But that's an impossible dream. Can OO version 1 open OO version 3 documents? Unfortunately I'm too short of time to contribute to OO/LO development - I suspect there's another 2-year learning curve. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3911931.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Hi :) We are not all single users here! Far from it! There are a lot of companies invested in LibreOffice/OpenOffice and even more if you include other products that use the OpenDocument Format. Mostly they are not names well recognised by "Windows desktop users" but some may ring a bell; Google, IBM, Redhat, Canonical, Oracle, Novell http://www.documentfoundation.org/supporters/ We used to keep a page on articles in the press including articles about massive migrations to LO https://wiki.documentfoundation.org/LibreOffice_In_The_Press and OpenOffice.org used to keep a page showing some of the larger corporates that used LO/OOo but it all became untenable as there are so many articles and migrations out there http://www.computerworld.dk/art/118467/koebenhavnske-hospitaler-dropper-microsoft-office http://www.muktware.com/hacksheet/2306 "Copenhagen hospitals ... move to using LibreOffice ... to save around 5.3 million euros" http://www.pcworld.com/businesscenter/article/220739/libreoffice_software_is_here_to_stay.html http://www.version2.dk/artikel/ministerium-faar-milliongevinst-med-skift-til-virtuelle-desktoppe-og-libreoffice-44101 In some non-English-speaking countries use of OOo/LO is widespread. For some it's a political decision, ie would US companies all be happy paying millions to a non-American company for a product that has American-English only as a 2nd and barely supported language? In most of Europe LO/OOo has around 20% of the market, in England it seems to be creeping up to around 1 or 2%. Why buy a product from a rival and pay hundreds of thousands to them in licensing fees when for a fraction of the price you can pay a few of your own devs to join in with something that removes the need? That way companies can target some developments to suit specific needs they might have from time-to-time while benefiting from the development work done by other devs working for different companies Unfortunately while MS dominates the market, documents produced using MSO 2010 do not always display properly in MSO 2007 and only work at all in earlier versions if you get the extra plugin. So, people are being pushed into buying their latest product just before the newer MSO 2013 (or whatever they are going to call it) gets released and then they will soon have to re-purchase to keep up. There even appears to be a note from MS that users need to upgrade to the latest MS OS as documents produced in the same version of MSO will look different on Xp from Win7 and different again on Vista. I am not in the development team but i get the impression the LO devs work through OOo bugs as well as the LO ones. LibreOffice has absorbed other projects that had originally forked from OOo due to Sun not incorporating all the required bug-fixes and developments from other companies or individuals. If MS are not careful then the interoperability argument is going to increasingly favour non-MS products as we all use the OpenDocument Format as a native format while also trying to support the various MS formats that are all called the same name as each other but operate differently. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3911888.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
So how does development happen? There seem to be two bug lists, and as I've demonstrated, they give different results on the same data (yuk). MS win by persuading industry (who are by far the dominant buyers - we single users are very much a minority and ignored by MS) that intercommunicability is a major issue - which it is. I'm old enough to remember when there were half a dozen different word processing programs, and exchanging data with a colleague in a different company was a major issue. So instead of the industry settling on a single document format, MS jumped into the breach with a very indifferent WP progam called "Word". Far inferior to Word Perfect, but it sold on the back of the OS (DOS in those days). One has to admire Gates for his commercial and marketing acumen, however much one dislikes his philosophy and the products. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3911797.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Hi :) Well, in many ways it's really only 1 product but in other ways it allows each to focus on slightly different niches in the market. MS Office tries to be relevant to all markets by being heavily bloated and "able to do everything" so it's far heavier, more bloated and slower than anyone would really want if they had free choice. Microsoft win by ensuring they remain dominant and by convincing people that choice, diversity and fair competition are bad for consumers. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3911791.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
I've not been keeping up with the OO/LO saga. It strikes me as a bit mad to have two different products, each being developed with minimal resources, trying to compete with the MS juggernaut. United we stand, divided we fall. But that's a bit off-topic. Anyway, I've reported this as a bug to Bugzilla and will see what happens. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3909982.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) There is no harm in using OpenOffice. It's a good product and not really a competitor anymore. It's more like we are 1 extended community with 2 legs and 2 products. Regards from Tom :) --- On Fri, 13/4/12, ptoye wrote: From: ptoye Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Friday, 13 April, 2012, 15:30 Manual refresh doesn't help. I'm afraid. And the workaround is even simpler - keep using Open Office! - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3908170.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Manual refresh doesn't help. I'm afraid. And the workaround is even simpler - keep using Open Office! - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3908170.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Try if a manual refresh helps. Use the button in the middle of the navigation toolbar. Work-around: Use the ID numbers together with a list box. So the actual field value is the ID masked by the list box text. In addition you can have an editable record set. -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3905231.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Not heard anything recently about my main problem (the fonts issue is a sideline). Anyone got any ideas? - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3905090.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Ubuntu. I think it's a fonts issue. But the formatting isn't exactly the problem. I'm far more worried about the problems in Windows, which is my normal desktop environment. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3896548.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) Which disto? Ubuntu? Hmm, more to the point which Desktop Environment? Unity, Gnome, KDE, LxDE or something unusual? Usually you can change the appearance through System/Utilities, Preferences or there might be a control-box Often a right-click on the desktop can get you into some of the preferences. Alternatively maybe it's just the fonts playing up? Have you installed the mstcorefonts (or whatever the package is called now) to get the MS fonts that are probably being used. Perhaps 'just' change the fonts of the forms and reports? (But then you would have to install those same fonts on Windows if you wanted to use the front-end on Windows again) Regards from Tom :) --- On Mon, 9/4/12, ptoye wrote: From: ptoye Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Monday, 9 April, 2012, 11:08 More developments - I copied the database to a Linux system and it opens correctly. So it seems to be a Windows-only issue. But the formatting on the Linux system was terrible! - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3896408.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
More developments - I copied the database to a Linux system and it opens correctly. So it seems to be a Windows-only issue. But the formatting on the Linux system was terrible! - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3896408.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Thanks for the interest, Dan. The answers are: LO: LibreOffice 3.5.2.2 Build ID: 281b639-6baa1d3-ef66a77-d866f25-f36d45f OO: 3.3.0 build 9567 OS: Windows 7 64-bit Home Premium Table contents: They look the same. At least, there aren't any obvious oddities. (I've not exported them and done a comparison!). Query: The SQL looks the same (by eyeballing, again). And running the query directly displays correctly. It's only in the form that it doesn't. Form design: they look the same (eyeballing again). If there are any differences in some of the drill-down properties I don't know. Is there any way to get a textual version of the form definition to do a comparison on? All the best, - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3892485.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Good idea, but the relationships haven't changed from OO. The fields in the grid which have relationships are "supplier" and "Region" (both links into other tables by an identifier field). The former is displayed incorrectly in the grid, the latter correctly. "Name" and "comments" are both displayed incorrectly in the grid but are simple text fields in the underlying table. These are both VARCHAR type, but so is "style" which is displayed correctly. The fields are displayed correctly in the subform fields: if you look at the "Wine Name" and "supplier" boxes there's an entry there. There would be one in the "comment"box, but that particular wine on show didn't have a comment. So there's no consistency in terms of relationships and linked tables or field types as to what's displayed correctly and what isn't. I know the theory reasonably well (though OO/LO might have a different view of relationships to, say, MS Access). - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3892472.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted