[libreoffice-users] Re: LO Base Error: DB Created By Newer Version
Le 11/03/2014 02:00, Mark LaPierre a écrit : Hi Mark, Do you know where LO keeps it's settings? AFAIK the user profile directory was moved to /home/user/.config/libreoffice sometime between 3.x and 4.x development If you have that folder, you will probably find a 4 and a 3 in there. Make sure LO isn't running (including the quickstarter, if you have it) and move both to somewhere else or rename them and then restart LO. I'm using the version of LO that is packaged with CentOS 6.5. It might not be cutting edge, but it's supposed to work. That's what CentOS is all about. If none of the above works, this might be a problem for the CentOS forums to help you with. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Connect Base to External HSQLDB
On Mon, Mar 10, 2014 at 9:23 PM, Mark LaPierre marklap...@aol.com wrote: snip Hey Alex, So what you are saying is that I can create a LO Base DB that references tables stored in the standalone HSQLDB database with the JDBC connector, and use that .odb file as a back end to another LO Base DB which acts as a front end? I've read, and been told on this mail list that LO Base can't do that. If I could do that I wouldn't need the standalone HSQLDB, just a plain .odb file with some tables in it. I've been trying to get this set up for months with no success. I could have done all this and more with Microsoft Access in just a few days. This really shouldn't be this hard. I think I need someone to hold my hand through the creation of just one very simple LO Base DB with just two tables in it. Mark, I think your confusion lies in equating an .odb file with an Access database. The .odb file never contains the data. It is a sort of registry that points to wherever the data is. Thus, Base is the front end, a real database is the back end, and the .odb file serves as the intermediary (to oversimplify). John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Connect Base to External HSQLDB
On 11/03/2014 13:23, jomali wrote: Hi John, I think your confusion lies in equating an .odb file with an Access database. The .odb file never contains the data. It is a sort of registry that points to wherever the data is. Thus, Base is the front end, a real database is the back end, and the .odb file serves as the intermediary (to oversimplify). I agree with everything you have written, except that, by default, if you use the wizard to create a standard (and I use that term very loosely) ODB file, LO creates an ODB file which embeds its own hsqldb-compatible data into the file and then uses the LO-shipped hsqldb.jar to be the db engine. This is where it gets confusing for people wanting to split out their data from their forms, queries, reports, etc. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Connect Base to External HSQLDB
On 11/03/2014 02:23, Mark LaPierre wrote: Hi Mark, So what you are saying is that I can create a LO Base DB that references tables stored in the standalone HSQLDB database with the JDBC connector, and use that .odb file as a back end to another LO Base DB which acts as a front end? I've read, and been told on this mail list that LO Base can't do that. If I could do that I wouldn't need the standalone HSQLDB, just a plain .odb file with some tables in it. No, you've got the wrong end of the stick, what others have said is correct. I'll try and simplify : The file extension ODB is in reality a zipped container. If you rename the extension to zip (or just right mouse button click on the file) and then open up the file with file-roller, ark, tar or whatever your favorite archiver is, then you will see it contains a number of files and folders. The actual contents vary according to how you have set up your database connection. If you are using the default, embedded hsqldb engine, then all of the data from the database is stored within the ODB container : Configurations2/ database/ forms/ META-INF/ reports/ content.xml mimetype settings.xml The database folder contains the following files : backup data properties script The forms folder contains any forms or subforms you have designed for that database. The reports folder contains xml files and Object folders defining any reports you have designed for that database. META-INF contains a file called manifest.xml. This is a required metadata file in order to have a valid (as in, ODF compliant) ODB file, so that LO will know it is trying to open an Open Document Format database file. As far as I understand it, content.xml is an xml representation of the content of the database, in other words, it references the db connection parameters, the db engine type, the different objects to be found within the rest of the ODB container, including any queries, views, forms, etc - without this file, your ODB file is just a blank canvas. As far as I understand it, settings.xml is the xml configuration file which defines how the Base window looks when you first load the ODB file. Configurations2 seems to contain spurious other configuration settings, e.g if you customise the toolbar for your Base file. If macros are present, these are also stored in a separate folder. What you are trying to achieve is to not use the embedded hsqldb engine, so in essence, your ODB container will not have a database folder because the content.xml file will refer to an outside linked hsqldb database. To give you another example, my ODB file which references my Thunderbird addressbook only contains the following : META-INF/ content.xml mimetype settings.xml Note that there is no database/ folder because the TB addressbook is an outside file, and furthermore, read only. My content.xml file contains (among others) the following xml string which references the type of db connection I have setup : db:data-sourcedb:connection-data db:connection-resource xlink:href=sdbc:address:thunderbird/db:login db:is-password-required=false/ /db:connection-data db:driver-settings db:system-driver-settings= db:base-dn= db:parameter-name-substitution=false/ db:application-connection-settings db:is-table-name-length-limited=false db:append-table-alias-name=false db:max-row-count=100 All of this is handled via the db creation wizard code, so usually there is no need to fiddle with this manually (and I would advise against it, unless you know what you're doing). I hope that hasn't confused you any more than necessary ;-) Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Connect Base to External HSQLDB
Hi :) Yes, quite. So 2 different front-ends (such as Base on different machines or for different purposes) could use the same back-end. Daisy chaining one to another seems like a really bad plan. Fairy lights on Xmas trees used to be daisy-chained which meant that if 1 bulb went out then they all did. That made it extremely difficult to find out which one (or more) was the problem. Nowadays most Xmas tree lights are done in parallel so that each bulb is independent of all the others. Now if one or more bulbs go the rest bravely shine on and it's easy to see which need replacing. Having a string of databases all depending on the all the rest to work properly sounds like a nightmare! On the other hand there is a lot of sense in a modular approach with specific discrete chunks doing specific jobs. Base and Access each have different modules within them. So that building a Form or Report straight from a Table makes it all quite inflexible and liable to problems later on. So it's generally better to build Queries, even if the Query doesn't actually do anything except pass everything straight through. Then in future years the table could change quite radically without forcing all the Forms and Reports to have to be redesigned. Just edit the Query a little so that all the Forms and Reports continue to get all get the inputs they are expecting. It's something that makes Base much more highly scalable than Access. Move the back-end tables from one program to another, either to get it smaller and lighter or to deal with a greater weight of data. perhaps move the back-end from a stand-alone machine onto a network or up onto a Cloud or some other place that might not even be envisaged possible during initial design of the database program. Even better is when Writer or Calc is used for the Forms and Reports so that those things can be viewed by wide-eyed-end-users with no training or understanding of database design. They just get usable output in a familiar setting and can edit around it themselves if they need to change font-size or formatting or write a new letter based on the old one. Regards from Tom :) On 11 March 2014 12:23, jomali jomali3...@gmail.com wrote: On Mon, Mar 10, 2014 at 9:23 PM, Mark LaPierre marklap...@aol.com wrote: snip Hey Alex, So what you are saying is that I can create a LO Base DB that references tables stored in the standalone HSQLDB database with the JDBC connector, and use that .odb file as a back end to another LO Base DB which acts as a front end? I've read, and been told on this mail list that LO Base can't do that. If I could do that I wouldn't need the standalone HSQLDB, just a plain .odb file with some tables in it. I've been trying to get this set up for months with no success. I could have done all this and more with Microsoft Access in just a few days. This really shouldn't be this hard. I think I need someone to hold my hand through the creation of just one very simple LO Base DB with just two tables in it. Mark, I think your confusion lies in equating an .odb file with an Access database. The .odb file never contains the data. It is a sort of registry that points to wherever the data is. Thus, Base is the front end, a real database is the back end, and the .odb file serves as the intermediary (to oversimplify). John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] cross references in footnotes
I made a document in Libreoffice 4.2.1 Mageia 3 with a few cross references to other footnotes in the document. When I exported the document to pdf some of these references had changed. After saving the document and reopening it the references were still wrong. I tried to correct them, but in vain. I made new cross references, but these also were changed after saving and reopening the file. So I went back to 4.1.5 but the problem remained. Then I went back to 4.0.6. In this version the wrong references were right again. I searched the internet and bug lists, but could not find anything. Does anybody know about this? Greetings, Erik. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Connect Base to External HSQLDB
Thanks, Alex, for the clarification. Since I have never used the internal hsqldb database, I was unaware that it kept its data in the .odb file. The last internal database I used was Adabas D in Staroffice. I quickly went to JDBC or ODBC connectors to other external datbase engines (e.g., MySQL). John On Tue, Mar 11, 2014 at 12:57 PM, Alex Thurgood alex.thurg...@gmail.comwrote: On 11/03/2014 13:23, jomali wrote: Hi John, I think your confusion lies in equating an .odb file with an Access database. The .odb file never contains the data. It is a sort of registry that points to wherever the data is. Thus, Base is the front end, a real database is the back end, and the .odb file serves as the intermediary (to oversimplify). I agree with everything you have written, except that, by default, if you use the wizard to create a standard (and I use that term very loosely) ODB file, LO creates an ODB file which embeds its own hsqldb-compatible data into the file and then uses the LO-shipped hsqldb.jar to be the db engine. This is where it gets confusing for people wanting to split out their data from their forms, queries, reports, etc. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc worksheet stalls when opening
All, I have a spreadsheet that stalls when I try to open it and when I try to save it. It does eventually open after a very long time. I don't know how long, I just walk away from the computer, eat breakfast, and then come back. Are there any log files that I can look at to try and determine what is wrong with this file? Is there any way to test the integrity of the file? Thanks, -Bill LO 4.2.1 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: LO Base Error: DB Created By Newer Version
On 03/11/14 04:57, Alex Thurgood wrote: Le 11/03/2014 02:00, Mark LaPierre a écrit : Hi Mark, Do you know where LO keeps it's settings? AFAIK the user profile directory was moved to /home/user/.config/libreoffice sometime between 3.x and 4.x development If you have that folder, you will probably find a 4 and a 3 in there. Make sure LO isn't running (including the quickstarter, if you have it) and move both to somewhere else or rename them and then restart LO. I'm using the version of LO that is packaged with CentOS 6.5. It might not be cutting edge, but it's supposed to work. That's what CentOS is all about. If none of the above works, this might be a problem for the CentOS forums to help you with. Hey Alex, Your a good man. I found .config/libreoffice. I moved it to .config/libreoffice.old then started LO Writer. I set the java association to Oracle Corporation 1.7.0_51 then restarted LO. I then created a new DB and created a new table inside, closed it, then restarted it. The table is now accessible. Now to get my first real DB built, but that's another thread. ;-) -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc worksheet stalls when opening
On Tue, Mar 11, 2014 at 9:21 PM, William Drago wdr...@suffolk.lib.ny.uswrote: I have a spreadsheet that stalls when I try to open it and when I try to save it. It does eventually open after a very long time. I Just looking for confirmation the issue is with only one particular spreadsheet? Calc on Ubuntu does this to me fairly often with any spreadsheet. I filed a bug report but I don't think there's active interest in it. When the report was filed I got a suggestion to upgrade, did so and the problem stopped. Now, a few Ubuntu patches later, and the stall when open behavior is back. My work around has been Apache OpenOffice. When I get tired of the stalling (and it's only Calc not Write or other programs) I start using AOO Calc. Usually after a few LO patches are part of the Ubuntu updates the stalling stops. So... if is a problem with any spreadsheet, check if there is a newer LO and install that to see if the issue is resolved. If the issue isn't resolved by upgrading LO consider installing AOO and try opening the spreadsheet with AOO Calc. If the problem persists when the spreadsheet is opened with AOO Calc it is definitely the spreadsheet. Regardless of trying AOO, if it is only one particular spreadsheet, a bit more information would be helpful trying to diagnose the problem. - did this spreadsheet always act this way? - if no, -- what changes were made to the computer between the time the spreadsheet last opened normally and first opened slowly? i.e., add/remove, upgrade, or patch software -- what changes were made to the spreadsheet between the time it last opened normally and it first opened slowly? ie, add borders to cells, create new formulas, add more data -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Connect Base to External HSQLDB
Hi :) I think it's worth avoiding using the internal back-end. Until very recently the internal one was an ancient and heavily tweaked version of Hsqldb. I think the devs have been working at replacing it with a more straight-forward Firebird and hopefully that will be updated in some sort of reasonably automatic way with an opt-out clause. The old internal Hsqldb one was a bit warped and the new Firebird one is a bit new. If you get a reasonably recent version of Hsqldb to use as an external database then apparently it's extremely good and exceedingly fast, for small databases (such as address-books) but when using the internal tweaked version people have had some fairly serious problems. It's entirely written in Java apparently but even so it's allegedly quite good. Regards from Tom :) On 11 March 2014 22:41, jomali jomali3...@gmail.com wrote: Thanks, Alex, for the clarification. Since I have never used the internal hsqldb database, I was unaware that it kept its data in the .odb file. The last internal database I used was Adabas D in Staroffice. I quickly went to JDBC or ODBC connectors to other external datbase engines (e.g., MySQL). John On Tue, Mar 11, 2014 at 12:57 PM, Alex Thurgood alex.thurg...@gmail.comwrote: On 11/03/2014 13:23, jomali wrote: Hi John, I think your confusion lies in equating an .odb file with an Access database. The .odb file never contains the data. It is a sort of registry that points to wherever the data is. Thus, Base is the front end, a real database is the back end, and the .odb file serves as the intermediary (to oversimplify). I agree with everything you have written, except that, by default, if you use the wizard to create a standard (and I use that term very loosely) ODB file, LO creates an ODB file which embeds its own hsqldb-compatible data into the file and then uses the LO-shipped hsqldb.jar to be the db engine. This is where it gets confusing for people wanting to split out their data from their forms, queries, reports, etc. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] cross references in footnotes
Hi :) Apparently there is a 3rd party tool that handles this sort of thing MUCH better than Writer or Word and works well with either or both. Have a look around for Zotero and see if that looks like it might be better at handling the cross-references Regards from Tom :) On 11 March 2014 22:31, Erik Jan ejvwaasd...@msn.com wrote: I made a document in Libreoffice 4.2.1 Mageia 3 with a few cross references to other footnotes in the document. When I exported the document to pdf some of these references had changed. After saving the document and reopening it the references were still wrong. I tried to correct them, but in vain. I made new cross references, but these also were changed after saving and reopening the file. So I went back to 4.1.5 but the problem remained. Then I went back to 4.0.6. In this version the wrong references were right again. I searched the internet and bug lists, but could not find anything. Does anybody know about this? Greetings, Erik. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
