[libreoffice-users] Running two LibreOffice Processes
Hi, we are embedding LibreOffice into an Application using UNO. In order to do that, we start LibreOffice in headless mode. However, this results in a user not being able to use LibreOffice outside of our application. If he tries to open a document, nothing visible happens, because the headless process is handling it. Trying to start LibreOffice directly also has no visible effect, because the new process immediately exits, as it finds the already running process. Is there a way, in which we can start our headless process, so that user-started LibreOffice process do not recognize it? It would be no problem, if a solution required two separate installations. Cheers, Philipp -- 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] Compatibility of LO Base with Access databases
On Wed, 2016-08-03 at 10:02 +1200, tonybsa wrote: > In defence of LibreOffice Base. > Unlike Ian I have had very good results with Base. > > Over the last 8 years I have used Base as a a "front end" to a MySQL > database in 5 different countries for different projects. > > One database was for the New Ireland (PNG) Provincial Government Old > Age & Disabled Pension fund. 170,000 records updated and maintained > by two dedicated data entry people, but accessed by approximately 35 > other users. LibreOffice Base on Windows 10, 8 and XP PC, on Ubuntu > 12.04 PC, on Macintosh OS X laptop. All connecting via ethernet and > wireless to a Ubuntu 12.04 Server. > > Another similar situation with Ministry of Tourism, Tonga collecting > data on visitors to Tonga and also used for tourism venture's > licensing and administration and conventions. 25 users connecting > LibreOffice Base to MySQL on FreeBSD server, with Windows and Ubuntu > PCs. > > Full administration for 5 divisions in Sanma Provincial Council, > Santo, Vanuatu. Including HR, Accounts, Youth, Disabilities, > Planning, etc. 75 staff members, plus external users, with > LibreOffice Base connecting to MySQL on Ubuntu 14.04 server from > Windows (10, 8.1, XP), Ubuntu 12.04 and Macintosh PCs. > > Now I used Access (Base not available) at Kokopo Business College for > student records. Created a database for College Library with Base on > Ubuntu PCs connecting to central MySQL database via Fibre Optics. > > Had real trouble trying to set this up with Access for multiple users > (25 teachers, 10 admin staff). > When I got LibreOffice Base I had similar problems with using the > HSQLDB engine. > > I found that connecting Base to MySQL was very easy and I had real > problems trying to connect Access. > I could also use Base on Linux machines and update all my colleagues > to a consistent operating system. > > You can not export Access forms, reports, macros, etc to use with > Base but you can export all the data from Access and import it into > Base very easily. > > Sorry to keep on!!! I have had good results with LibreOffice Base > connecting to an external database. I also make extensive use of > Macros with Base. > > Just in case you are wondering -- I am retired and about to have my > 75th birthday so not just straight out of Uni.!!! > > Thanks for listening > > Tony Bray > tony...@mac.com > MacBook Pro 15 inch Mid 2009 > 2.8 GHz Intel Core 2 Duo, 4 GB RAM, > Mac OS X 10.11.6 > LibreOffice 5.0.6 > Scribus 1.4.4 > Libre Project 1.5.19 > Parallels Desktop 11.02 > Ubuntu 14.04 > LibreOffice 4.4.4 > MySQL, PHP, Apache > Just to be clear, I also support these eulogies to LOBase, and look forward to a time when the Base's user comfort improves. I, too am running Base (on OpenSuse Linux 42.1) with a Mariadb backend but only with a very small (one table!) database. Years ago MSAccess spoiled me for features and user comfort, AS LONG I WAS THE ONLY USER!. But the databases I created with it were quite large and complex (one of them had 10 records in one table and 40 tables, for a demanding engineering project). At that time I also created a simple LOBase application (on windows 2000) and MySQL (on OpenSuse Linux) for storing and retrieving scanned papers. That db worked quite well, but speed was not its best feature. Now, (in retirement, approaching 70!) I am still on the lookout for applications that would benefit from good database support whereby LOBase/mariadb would always (still) be my configuration of choice. Cheers Harvey -- 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] Running two LibreOffice Processes
Hi Philipp, I don't know, how embedding and headless work, but I can tell you, how to get two running processes in normal cases on Windows: When a soffice.bin process is started it writes the ~.lock file in the folder which contains the 'user' folder, which contains all the personal LibreOffice settings. The place of the 'user' folder is given in the line "User Installation" in the file bootstrap.ini in the 'program' folder, e.g. "UserInstallation=$SYSUSERCONFIG/LibreOffice/4". If soffice.exe is started a second time and finds the ~.lock file, it uses the already running process. If I want two processes, I uses these tweaks: A) I have two different program-folders and change their bootstrap.ini, so that it points to different UserInstallation paths. For all my testing, I set "UserInstallation=$ORIGIN/..". That generates the 'user' folder into the same place as the program folder. That way I test daily builds. B) I have different users. You can call soffice.exe with parameter -env. I use e.g. "C:\Program Files\LibreOffice 4\program\soffice.exe" -env:UserInstallation=file:///f:/SoftwareLO/user_DE I use that method, if I test different UI languages for one installed LibreOffice. Perhaps something similar is also possible for embedding and headless, but I don't know. You might use the developer chat at irc://chat.freenode.net/libreoffice-dev to get competent answers. Kind regards Regina Schäfer, Philipp schrieb: Hi, we are embedding LibreOffice into an Application using UNO. In order to do that, we start LibreOffice in headless mode. However, this results in a user not being able to use LibreOffice outside of our application. If he tries to open a document, nothing visible happens, because the headless process is handling it. Trying to start LibreOffice directly also has no visible effect, because the new process immediately exits, as it finds the already running process. Is there a way, in which we can start our headless process, so that user-started LibreOffice process do not recognize it? It would be no problem, if a solution required two separate installations. Cheers, Philipp -- 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: Compatibility of LO Base with Access databases
Le 02/08/2016 à 00:23, Ian Whitfield a écrit : Hi Ian, > > *Re: The LO Base discussion* - just my "Penny's Worth"!!! > > The only way I got any (sort of results) was by using MySQL as the > backend but it took a couple of months to get it working and after a few > months even that crashed on me. I recently had to re-build my computer > after a hardware failure and my OpSys upgraded to 64bit and since then I > can not even get the MySQL linking in LO Base to even start!! > It it is fairly rare for people to suffer from catastrophic failures and data loss using mysql - most of the time, it is usually possible to salvage most, if not all of one's data providing one takes an interest in the manuals on how to administer such a database server (and there are a plethora of them, not least Oracle's own documentation). > So if you are happy to keep lots and lots of backups, and spend lots and > lots of time re-building everything at almost monthly intervals - and by > re-building I mean the Database Tables, redesign all your Forms and > set-up all your Queries and Reports from scratch - then go with it, > otherwise give it a miss. > It is also not strictly necessary to keep backups of the mysql database, although it is indeed a recommended practice. Again, the documentation is replete on how to do this safely. From the interaction I've had with you on and off the list, I would say that you have been unfortunate with regard to some of your expectations, in that you did not wish to, or failed to, understand what it meant to have a database server, and didn't wish to spend time understanding how it worked in case things did go pear-shaped. I can understand this from a user perspective, and in that case, choosing mysql as your backend database engine was probably not a good idea, but as you found out for yourself, neither was the embedded hsqldb. My own experience with mysql databases has been rock solid in terms of data integrity now for more than 10 years, including various different types, from stock management, IP rights management, accounting, etc, although I will admit that interaction with StarOffice, OpenOffice.org and LibreOffice has caused some issues, but this mostly lies with limitations or bugs within those programs and not mysql itself (barring a few connector driver problems). Fact of the matter is that databases when used with LO, embedded or not, probably require more work than most "Access-users" are willing to put in. There is no "simple", "out-of-the-box" solution for such users when attempting to switch to LO, everything will be a compromise of sorts, be it form design, reporting, stability, multi-user access, etc. LOBase was always designed with the eye of a database administrator in mind, and the attempted switch to a user-centric orientation just didn't quite happen (for various reasons within Sun, and then Oracle). However, what we have got is not bad as things go, providing that one can accept its limitations (or alter one's work flow to work around them). 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: Compatibility of LO Base with Access databases
Base and some of its limitations (including enbedded HSQLDB) are well described here: https://wiki.openoffice.org/wiki/FAQ_(Base) The last two times I needed a multi user database accessible over the web I went with a LAMP approach. The *upfront* set up and learning curve was higher but *less* time is required over the life of the project (development & maintenance) as these tools have exceptional stability and performance, have very few bugs, excellent documentation and require no client side maintenance. AND, it's far more rewarding developing the application versus fighting the bugs and limitations of your tools ... as often happens when using Access, Base and their like (been there, done doing that). On Wed, Aug 3, 2016 at 6:15 AM, Alexander Thurgood wrote: > Le 02/08/2016 à 00:23, Ian Whitfield a écrit : > > Hi Ian, > > > > > > *Re: The LO Base discussion* - just my "Penny's Worth"!!! > > > > > The only way I got any (sort of results) was by using MySQL as the > > backend but it took a couple of months to get it working and after a few > > months even that crashed on me. I recently had to re-build my computer > > after a hardware failure and my OpSys upgraded to 64bit and since then I > > can not even get the MySQL linking in LO Base to even start!! > > > > It it is fairly rare for people to suffer from catastrophic failures and > data loss using mysql - most of the time, it is usually possible to > salvage most, if not all of one's data providing one takes an interest > in the manuals on how to administer such a database server (and there > are a plethora of them, not least Oracle's own documentation). > > > > So if you are happy to keep lots and lots of backups, and spend lots and > > lots of time re-building everything at almost monthly intervals - and by > > re-building I mean the Database Tables, redesign all your Forms and > > set-up all your Queries and Reports from scratch - then go with it, > > otherwise give it a miss. > > > > It is also not strictly necessary to keep backups of the mysql database, > although it is indeed a recommended practice. Again, the documentation > is replete on how to do this safely. > > From the interaction I've had with you on and off the list, I would say > that you have been unfortunate with regard to some of your expectations, > in that you did not wish to, or failed to, understand what it meant to > have a database server, and didn't wish to spend time understanding how > it worked in case things did go pear-shaped. I can understand this from > a user perspective, and in that case, choosing mysql as your backend > database engine was probably not a good idea, but as you found out for > yourself, neither was the embedded hsqldb. > > My own experience with mysql databases has been rock solid in terms of > data integrity now for more than 10 years, including various different > types, from stock management, IP rights management, accounting, etc, > although I will admit that interaction with StarOffice, OpenOffice.org > and LibreOffice has caused some issues, but this mostly lies with > limitations or bugs within those programs and not mysql itself (barring > a few connector driver problems). > > Fact of the matter is that databases when used with LO, embedded or not, > probably require more work than most "Access-users" are willing to put > in. There is no "simple", "out-of-the-box" solution for such users when > attempting to switch to LO, everything will be a compromise of sorts, be > it form design, reporting, stability, multi-user access, etc. > > LOBase was always designed with the eye of a database administrator in > mind, and the attempted switch to a user-centric orientation just didn't > quite happen (for various reasons within Sun, and then Oracle). However, > what we have got is not bad as things go, providing that one can accept > its limitations (or alter one's work flow to work around them). > > > 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
Re: [libreoffice-users] Re: Compatibility of LO Base with Access databases
Hello, I agree full-heartedly with Alex, but then I have been working with relational DBs ever since my days at IBM (DB2), where I specialised on databases for a while. In fact I happened to get to know one of the fathers of that technology - Chris Date. I have been using OO and LO with a MySQL-backend for at least 10 years since switching from Lotus (Dbase-based). Except for a couple of snags with the MySQL-connectors (native, Java and ODBC) I have never had any problems worth mentioning, and - of course - I do back up my DB. But then, I probably am not the average "end-user"-oriented bloke, even though I would not call myself a DB-specialist any more. I use LO and MySQL for the administrative side of a wind band, working "natively" with the underlying tables and using a number of views based on joined tables for reporting. Using Drupal as the framework for the homepage of the band (www.rainermusik.at) I also have integrated some of those MySQL-views with Drupal. I never really went into using LO-forms or Basic macros because I feel that one should take the effort to use a framework such as Symfony for building more involved applications, using an object-oriented approach, with something like Doctrine as a link between the objects/methods of the application and the MySQL DB. Regards from sunny Salzburg Heinz On Wed, 03 Aug 2016 12:15:19 +0200, Alexander Thurgood wrote: Le 02/08/2016 à 00:23, Ian Whitfield a écrit : Hi Ian, *Re: The LO Base discussion* - just my "Penny's Worth"!!! The only way I got any (sort of results) was by using MySQL as the backend but it took a couple of months to get it working and after a few months even that crashed on me. I recently had to re-build my computer after a hardware failure and my OpSys upgraded to 64bit and since then I can not even get the MySQL linking in LO Base to even start!! It it is fairly rare for people to suffer from catastrophic failures and data loss using mysql - most of the time, it is usually possible to salvage most, if not all of one's data providing one takes an interest in the manuals on how to administer such a database server (and there are a plethora of them, not least Oracle's own documentation). So if you are happy to keep lots and lots of backups, and spend lots and lots of time re-building everything at almost monthly intervals - and by re-building I mean the Database Tables, redesign all your Forms and set-up all your Queries and Reports from scratch - then go with it, otherwise give it a miss. It is also not strictly necessary to keep backups of the mysql database, although it is indeed a recommended practice. Again, the documentation is replete on how to do this safely. From the interaction I've had with you on and off the list, I would say that you have been unfortunate with regard to some of your expectations, in that you did not wish to, or failed to, understand what it meant to have a database server, and didn't wish to spend time understanding how it worked in case things did go pear-shaped. I can understand this from a user perspective, and in that case, choosing mysql as your backend database engine was probably not a good idea, but as you found out for yourself, neither was the embedded hsqldb. My own experience with mysql databases has been rock solid in terms of data integrity now for more than 10 years, including various different types, from stock management, IP rights management, accounting, etc, although I will admit that interaction with StarOffice, OpenOffice.org and LibreOffice has caused some issues, but this mostly lies with limitations or bugs within those programs and not mysql itself (barring a few connector driver problems). Fact of the matter is that databases when used with LO, embedded or not, probably require more work than most "Access-users" are willing to put in. There is no "simple", "out-of-the-box" solution for such users when attempting to switch to LO, everything will be a compromise of sorts, be it form design, reporting, stability, multi-user access, etc. LOBase was always designed with the eye of a database administrator in mind, and the attempted switch to a user-centric orientation just didn't quite happen (for various reasons within Sun, and then Oracle). However, what we have got is not bad as things go, providing that one can accept its limitations (or alter one's work flow to work around them). Alex -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] Seamonkey users - using browser to reach this list
Hi Folks, I wondered if anyone uses Seamonky to reach this list? If so, do you use the Portable Seamonkey from here... http://portableapps.com/apps/internet/seamonkey_portable I'm trying to use a portable browser on a flash drive to reach this list and thought Seamoneky might be a worthy candidate...unless others have found a better portable browser to use on a flash drive? Thanks so much for your thoughts and suggestions. Charles. -- 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] where does LO 5.x config files?
I just installed the DEB 64-bit 5.2.0.x version I had the 5.1.x version installed before it. In the .config folder, I see libreoffice folder containing version 4, but I cannot find ver 5.x.x config files. Where do they now reside in the Ubuntu/DEB system folders? I was checking on some config files for 5.x versions and could not find them. -- 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] where does LO 5.x config files?
On Wed, 3 Aug 2016 12:59:28 -0400 Tim---Kracked_P_P---webmaster wrote: > In the .config folder, I see libreoffice folder containing version 4, > but I cannot find ver 5.x.x config files. LibreOffice 5.x uses configuration files of 4.x version. On Unix systems, they are stored in ~/.config/libreoffice/4/. This is because 4.x -> 5.x change is done for marketing purposes, not due to technical reasons. I read it on some mailing list back before 5.x was released, but I gave up searching for source of this claim. It is there, somewhere. -- Best regards Mirosław Zalewski -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: where does LO 5.x config files?
No, the /4 path was retained because there was no real reason to change the path, and some good technical reasons for compatibility with exiting user profile and extensions. There were quite a few issues affecting UX during migration from LibreOffice 3.x to 4.x and the impact on extensions. The ESC simply elected not to repeat at the 4.x -> 5.x transition. =-ref-= https://bugs.documentfoundation.org/show_bug.cgi?id=57061 https://bugs.documentfoundation.org/show_bug.cgi?id=90747 http://nabble.documentfoundation.org/Minutes-of-ESC-call-2015-04-02-tt4145334.html http://nabble.documentfoundation.org/minutes-of-ESC-call-tt4145792.html -- View this message in context: http://nabble.documentfoundation.org/where-does-LO-5-x-config-files-tp4190051p4190059.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: where does LO 5.x config files?
germane notes from one more earlier ESC meeting... http://nabble.documentfoundation.org/minutes-of-ESC-call-td4142383.html -- View this message in context: http://nabble.documentfoundation.org/where-does-LO-5-x-config-files-tp4190051p4190061.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted