[libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Kamil Jońca]

kjo...@o2.pl (Kamil Jońca) writes:

> Drew Jensen  writes:
>
[...]
>
>
> https://bugs.documentfoundation.org/show_bug.cgi?id=120245
>
>

Today I upgraded my debian packages and in:

Version: 1:6.1.3~rc1-1

there is no mentioned bug.

Thank you!
KJ

-- 
http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
Jak ktoś ma pecha, to złamie ząb podczas seksu oralnego (S.Sokół)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Kamil Jońca]

Drew Jensen  writes:


> Best way, IMO, since you noticed it first here would be to go ahead and do
> that yourself.
> This URL assumes you have an account in the bug tracking system.
> https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice;component=Base
> If you don't have one and register then submit it you will get
> notifications as it is worked.
>
> Otherwise, if you really would rather not than one of us in the QA group
> can do it.
>


https://bugs.documentfoundation.org/show_bug.cgi?id=120245


KJ

-- 
http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
I brought my BOWLING BALL -- and some DRUGS!!

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Drew Jensen]

Hi,

I would not be surprised if a change in behavior happened recently, there
was some reworking of the sdbc drivers recently which I think had the
chance to touch basically all of them. NOTE: I'm not a developer of that
code but I try to follow along with the generalities through the QA group.

Given two folks seeing the same problem with the latest 6.1.2 build then
whether the postgreSQL driver should be updated for that option or needs
fixing I can't say, but the step right now is to open an issue and get it
started whichever way.

Best way, IMO, since you noticed it first here would be to go ahead and do
that yourself.
This URL assumes you have an account in the bug tracking system.
https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice;component=Base
If you don't have one and register then submit it you will get
notifications as it is worked.

Otherwise, if you really would rather not than one of us in the QA group
can do it.

Let us know.

Thanks

Drew

On Mon, Oct 1, 2018 at 12:57 PM Kamil Jońca  wrote:

> Drew Jensen  writes:
>
> > Hi,
> >
> > You would want to open an issue in the LibreOffice bug tracker and the
> > module would be Base.
> > postgreSQL should be in the summary of course.
> >
> > I know you said this form works with LibreOffice 6.1.1 rc, but I'm
> curious
> > how long it was working in your production environment. Was it working in
> > 6.0 for instance?
>
> I never have registered such probolem, and I use my "application" for
> years.
>
> KJ
>
>
> --
> http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
> "I never let my schooling get in the way of my education."
> -- Mark Twain
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Kamil Jońca]

Drew Jensen  writes:

> Hi,
>
> You would want to open an issue in the LibreOffice bug tracker and the
> module would be Base.
> postgreSQL should be in the summary of course.
>
> I know you said this form works with LibreOffice 6.1.1 rc, but I'm curious
> how long it was working in your production environment. Was it working in
> 6.0 for instance?

I never have registered such probolem, and I use my "application" for
years.

KJ


-- 
http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
"I never let my schooling get in the way of my education."
-- Mark Twain

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Kamil Jońca]

Drew Jensen  writes:

> Also,
>
> In the issue be sure to show which version of PostgreSQL you are using?
>
> Thanks

--8<---cut here---start->8---
$psql
Pager usage is off.
Border style is 0.
psql (10.5 (Debian 10.5-1))
Type "help" for help.

kjonca=> select  version();
   version  
   
--
PostgreSQL 10.5 (Debian 10.5-1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 
8.2.0-3) 8.2.0, 64-bit
(1 row)

kjonca=> 

--8<---cut here---end--->8---

KJ


-- 
http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
I never take work home with me; I always leave it in some bar along the way.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Drew Jensen]

BTW

Currently the native MySQL ( MariaDB) sdbc has a setting '
FormsCheckrequiredFields' which can turn that function on or off.
Checking just now the PostgreSQL sdbc code does not currently have that
option.
Yeah, that needs to go into the issue tracker for sure.

Drew

On Mon, Oct 1, 2018 at 10:50 AM Alexander Thurgood 
wrote:

> Le 01/10/2018 à 12:08, Kamil Jońca a écrit :
>
> Hi Kamil,
>
>
> >
> > I  use libreoffice with libreoffice-sdbc-postgresql driver. I do not
> > know where the bug is.
> >
> > I have simple form based on postgresql table.
> > In this table there is a column
> >
> > nametype  nullable
> default value
> > utw timestamp without time zone   not null now()
> >
> > This column does not have its field in form.
> > With package:
> >
>
> I can reproduce this with :
>
> MacOS 10.13.6
> postgres 9.5
> LibreOffice 6.1.2.1
> sdbc built-in postgres driver
>
> If I enter the data in Table data edit mode, then the date is added
> automatically.
>
> However, like you, filling in a simple form including the timestamp
> field and leaving the timestamp field blank always throws an error when
> I try to move to either a new record, or back to a previous record. What
> should happen is that the timestamp value should be generated and the
> record validated (as in Table data edit mode).
>
>
> Alex
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Alexander Thurgood]

Le 01/10/2018 à 12:08, Kamil Jońca a écrit :

Hi Kamil,


> 
> I  use libreoffice with libreoffice-sdbc-postgresql driver. I do not
> know where the bug is.
> 
> I have simple form based on postgresql table.
> In this table there is a column
> 
> nametype  nullable default 
> value
> utw timestamp without time zone   not null now()
> 
> This column does not have its field in form.
> With package:
> 

I can reproduce this with :

MacOS 10.13.6
postgres 9.5
LibreOffice 6.1.2.1
sdbc built-in postgres driver

If I enter the data in Table data edit mode, then the date is added
automatically.

However, like you, filling in a simple form including the timestamp
field and leaving the timestamp field blank always throws an error when
I try to move to either a new record, or back to a previous record. What
should happen is that the timestamp value should be generated and the
record validated (as in Table data edit mode).


Alex


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: LibreOffice base: fix form dialogue size

[Alexander Thurgood]

Le 28/03/2018 à 18:57, Albrecht Dreß a écrit :

Hi Albrecht,


> However, when I resize one form the a convenient size, all other forms
> open with the same (typically wrong) size.  Needless to mention that
> this is a really annoying behaviour…

Yes, this is known buggy behaviour, cf:

https://bugs.documentfoundation.org/show_bug.cgi?id=115619


Alex


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LibreOffice Base crashes unexpected

[Girvin Herr]

On 07/21/2017 08:36 AM, Alexander Thurgood wrote:

Le 21/07/2017 à 16:55, Lumaja a écrit :


Check your kernel version and the Ubuntu Launchpad bug report :

https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772

and also:

https://bugs.documentfoundation.org/show_bug.cgi?id=108619



Alex





Greetings,
I got this link from a responder to my LinuxQuestions.org posting about 
this matter:

https://lkml.org/lkml/2017/7/3/1010
It appears even Linus Torvalds is not aware of the LO problems with this 
bug, at least not as of July 3rd. It may be a good thing for people at 
LO to "enlighten" him.


I've heard that another solution, other than to back up to a previous 
kernel as I have done, is to switch to 64-bit. This problem allegedly 
does not affect 64-bit Linux. I am running 32-bit and have no intention 
of changing at this time.

Girvin Herr



--
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: LibreOffice Base crashes unexpected

[Girvin Herr]

On 07/21/2017 08:36 AM, Alexander Thurgood wrote:

Le 21/07/2017 à 16:55, Lumaja a écrit :


Check your kernel version and the Ubuntu Launchpad bug report :

https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772

and also:

https://bugs.documentfoundation.org/show_bug.cgi?id=108619



Alex





Greetings,
I can confirm this bug on Slackware too, with the 4.4.75 kernel security 
update. I had a thread going here a few weeks ago asking for help on 
this problem. My solution was to back out the 4.4.75 kernel upgrade and 
go back to the 4.4.38 kernel. That fixed my problem.


Girvin



--
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: LibreOffice Base crashes unexpected

[Alexander Thurgood]

Le 21/07/2017 à 16:55, Lumaja a écrit :


Check your kernel version and the Ubuntu Launchpad bug report :

https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772

and also:

https://bugs.documentfoundation.org/show_bug.cgi?id=108619



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: Libreoffice Base

[toki]

On 04/24/2017 02:40 PM, Robert Großkopf wrote:

> I won't change to Firebird with any version of LO at this moment.

I haven't been following the FireBird migration.  (I'd rather use
SQLite. But SQLite is only for those who like to live dangerously.)

> There is no problem to use the internal HSQLDB. It will work much
> better than the internal Firebird-database at this moment. 

My concern is/was HSqlDb gets dropped from LibO. OTOH, even after being
dropped, it can be used as an external database. And, on the gripping
hand, it looks like in LibO 5.3.2.1 dBase 3 support is still alive. So
maybe a decade from now, both HSqlDB and FireBird support will be built
into LibO.

jonathon

-- 
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: Libreoffice Base

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi John,

> Thank you for your reply. I am using Libreoffice on Microsoft
> Windows 10 and always update Libreoffice when one becomes
> available. I have seen comments that say Java can be a problem, if
> you moved over to Firebird does this remove Java. These are
> questions being raised by someone who loves to experiment but does
> not have a clue when it comes to programming, I leave that to the
> experts. If I continue to develop my database(s) and a change from
> HSQLdb to Firebird takes place what effect might that have?

I won't change to Firebird with any version of LO at this moment.
Firebird is experimental since LO 4.2. Internal Firebird-DB has been
changed with LO 5.3 to a new version and those people, who have used
the experimental version for all LO-versions before have problems to
get the data from the old FB 2.5 to the new FB 3.0.

There is no problem to use the internal HSQLDB. It will work much
better than the internal Firebird-database at this moment. Many
databases have been designed with the internal HSQLDB. So it wouldn't
be moved away suddenly. There is no problem to switch from the
internal HSQLDB to a external HSQLDB.

I you need a more stable database: Switch to a external database. If
you need a database with more functions than the old HSQLDB you could
use MySQL/MariaDB or PostgreSQL or something else.

Java will also be nedded when using the internal Firebir-Database. It
isn't only the connection to the internal HSQLDB, which will need Java.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJY/g5FAAoJELDKYwaoS9AISI8P/1WE/MlIX7zcAn5Ww/bE7R+4
5G4lSr26i7Frt4IoT2w2tj1Q5YGb/XFUnBQmtNFaMEb+InkSOX1pV4SiyVeG0Qqg
Xiv3xH3tHh5bWGqSymN4ni+xNXkqFDcTm9XtcBp39L1zHEcVpGmiIeEadMZj0dcw
uzSwwKWe06vHynAEX43LAuNjYu1NLLbxejtbSz7OR5/5nS/LYXMBjleRIib7rv8F
qcC/HAWfWd6cupYeZkUt0aHW9kyEFvXIoNm4A3gwAmsKyLOsHfjFAsSBBBZ4h+US
J+lzdNqwyZ7F1r7q5dmHEzfiRPMlA4MHmOfpcodc8H/qgY5uJfpRYO6u/w0ClTFz
8BvX5PRZaHK08f3dMWfCx0ZtnFGsg7SKBz9UCtuJ299xpZ3TfitWHXiS00NAZ3Ch
wXJyo9sEdLGYHBQEBlY/bq37jOhkGYW6dtnZiQkO3Sh07RkRVoWBmgx0ES11vw66
IorgP0ydzSYVDm/AqR+A+9OyVa1x9zo4awM72M/M06hn+8IKpl4aJg93DrMJDUqo
tYalR+PuYzSxccVsZiPxa04+j/nFGPriDanG7OJl8SPQD4/mPBsT2EH+GxlEIwsJ
OzSXtOaiD6NTT6gZgf4BhEF1JymA+NUplWvP62bbAFrUSkZtsT+JK4dSyx8MH3ib
UFtlS0dDLTOh4nY/7CK2
=VZrY
-END PGP SIGNATURE-

-- 
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: Libreoffice Base

[lismurn]

Hi Jonathan,
Thank you for your reply. I am using Libreoffice on Microsoft Windows 10
and always update Libreoffice when one becomes available. I have seen
comments that say Java can be a problem, if you moved over to Firebird does
this remove Java. These are questions being raised by someone who loves to
experiment but does not have a clue when it comes to programming, I leave
that to the experts.
If I continue to develop my database(s) and a change from HSQLdb to
Firebird takes place what effect might that have?

John

On 22 April 2017 at 06:50, toki [via Document Foundation Mail Archive] <
ml-node+s969070n4213006...@n3.nabble.com> wrote:

> On 04/21/2017 07:00 AM, lismurn wrote:
>
> > 1.  Is Base being supported or is it dead in the water.
>
> Base is, and will continue to be supported.
>
> The embedded database engine is in the process of changing from HSQLdb
> to FireBird. This change has caused some users to be confused, and think
> that the Base component is going away.
>
> > I am trying to assemble a small database but wonder should I continue if
> it is not being supported.
>
> Spend some time thinking about which database engine you want to use.
>
> Base can be used both as a database front end, or as combined front
> end/database engine.
>
> I don't know Base well enough to answer the rest of your questions. :(
>
> jonathon
>
> --
> To unsubscribe e-mail to: [hidden email]
> 
> 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
>
>
>
> --
> If you reply to this email, your message will be added to the discussion
> below:
> http://nabble.documentfoundation.org/Libreoffice-Base-
> tp4212918p4213006.html
> To unsubscribe from Libreoffice Base, click here
> 
> .
> NAML
> 
>




--
View this message in context: 
http://nabble.documentfoundation.org/Libreoffice-Base-tp4212918p4213010.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

Re: [libreoffice-users] Re: LibreOffice Base and SQLite

[Michael Manning]

Many thanks to Alex for putting me on the right track.

I have also found the information at:
https://crcok.wordpress.com/2014/10/24/using-sqlite-database-with-openoffice-org/


I seemed to have got into a twist with the installation of ODBC and
multiple odbcinst.ini and odbc.ini files in my system.

The possible use of Kexi as a possible simple database system has also been
hightlighted.

cheers

Mike

On 22 September 2016 at 20:05, Alexander Thurgood 
wrote:

> Le 22/09/2016 à 06:41, Michael Manning a écrit :
>
> Hi Michael,
>
> > After installing the various packages, I am not able to run
> >
> >> sudo ODBCConfig
> >
>
>
> Try installing ODBCManageDataSourcesQ4 and its co-application
> ODBCCreateDataSourceQ4. These are QT4 apps, but they worked for me on
> LinuxMint 18.
>
> Alternatively, you can configure the odbcinst.ini and odbc.ini files by
> hand and put them in the appropriate places.
>
> You might also want to bear in mind that not all datatypes available in
> sqlite are correctly supported/interpreted by LibreOffice, even over
> ODBC. This stems from the weak typing of sqlite, which LibreOffice
> doesn't necessarily know how to interpret correctly.
>
>
> 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] Re: LibreOffice Base and SQLite

[Alexander Thurgood]

Le 22/09/2016 à 06:41, Michael Manning a écrit :

Hi Michael,

> After installing the various packages, I am not able to run
> 
>> sudo ODBCConfig
> 


Try installing ODBCManageDataSourcesQ4 and its co-application
ODBCCreateDataSourceQ4. These are QT4 apps, but they worked for me on
LinuxMint 18.

Alternatively, you can configure the odbcinst.ini and odbc.ini files by
hand and put them in the appropriate places.

You might also want to bear in mind that not all datatypes available in
sqlite are correctly supported/interpreted by LibreOffice, even over
ODBC. This stems from the weak typing of sqlite, which LibreOffice
doesn't necessarily know how to interpret correctly.


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: LibreOffice Base and MySQL

[Hank Alper]

Hi Ian,
If you are importing a spreadsheet into your MySql Database, you should be
able to do this without using Base.
Alexander feels it may be that we are using different versions of
phpMyAdmin. He may be right..
Two years ago I imported my Base database tables to a MySQL Database
running on a remote, headless Centos 6 VPS server. I installed phpMyAdmin
on that server and it is visible
via my browser.  Here are the versions of the software I'm running on the
*remote* Centos 6 server:

Database server
Server: Localhost via UNIX socket
Software: MySQL
Software version: 5.1.69 - Source distribution
Protocol version: 10
User: MyUserName@localhost
Server charset: UTF-8 Unicode (utf8)
phpMyAdmin
Version information: 3.5.8.2, latest stable version: 4.5.4.1
Note:
 Because my server software is on a remote Linux machine, I view phpMyAdmin
via my home computer's
 browser. Here is the Web server on that same remote machine:
Web server
Apache/2.2.15 (CentOS)
Database client version: libmysql - 5.1.69
PHP extension: mysqli Documentation
Spreadsheet
   On my home computer, I'm running Libre Office 5
I suggest you check the versions of your software against mine.

*Have you established a named database in MySQL into which you are
importing this spreadsheet ?* You know of course, you must do this before
you import anything into it.
I would suggest you prepare a small spreadsheet in Calc with perhaps 3 rows
and three named columns with test data..Keep the data simple, Use integers,
decimals and  short strings.
Save the file as a standard Calc file. *Forget CSV.* Open phpMyAdmin and
select the named database you're working on. Click on the Import tab. Enter
the path to the Calc file.or browse to its location.
Select 'Open Document Spreadsheet' from the drop down box.
The input screen will show a check box asking if you want the first row as
headers.Check that box.
Everything should be ready for you to press* GO.*

Hope this helps.
Hank





On Tue, Jan 26, 2016 at 6:42 AM, Ian "Witty" Whitfield <
edi...@federalsaints.net> wrote:

> On 01/24/2016 10:04 AM, Hank Alper wrote:
>
>> Hi Ian,
>> I frequently import Calc Spreadsheets into my MySQL database using
>> phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
>> import.Specifically, it offers a Browse option. Locate the Calc file you
>> wish to import.by browsing to it in your file system.
>> It also asks for the type of file you wish to import. One of the options
>> is
>> ODF spreadsheet.That's the format of Calc, isn't it ?
>> No need to convert to CSV File.
>> Hank
>>
>> Thanks Hank
>
> But no luck!! I tried to import my ODS Spreadsheet file from LibraOffice
> and got the following error...
>
> /"You attempted to load file with unsupported compression
> (application/zip).
> Either support for it is not implemented or disabled by your
> configuration"./
>
> The file is NOT compressed or Zipped and opens perfectly in LO Calc!!
>
> So still a problem - but I appreciate the pointer.
>
> Best regards
>
> IanW
> Pretoria RSA
>
>
> --
> 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: LibreOffice Base and MySQL

[Ian "Witty" Whitfield]

On 01/24/2016 10:04 AM, Hank Alper wrote:

Hi Ian,
I frequently import Calc Spreadsheets into my MySQL database using
phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
import.Specifically, it offers a Browse option. Locate the Calc file you
wish to import.by browsing to it in your file system.
It also asks for the type of file you wish to import. One of the options is
ODF spreadsheet.That's the format of Calc, isn't it ?
No need to convert to CSV File.
Hank


Thanks Hank

But no luck!! I tried to import my ODS Spreadsheet file from LibraOffice 
and got the following error...


/"You attempted to load file with unsupported compression 
(application/zip).
Either support for it is not implemented or disabled by your 
configuration"./


The file is NOT compressed or Zipped and opens perfectly in LO Calc!!

So still a problem - but I appreciate the pointer.

Best regards

IanW
Pretoria RSA

--
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: LibreOffice Base and MySQL

[Jaroslaw Staniek]

On 26 January 2016 at 12:42, Ian "Witty" Whitfield  wrote:

> On 01/24/2016 10:04 AM, Hank Alper wrote:
>
>> Hi Ian,
>> I frequently import Calc Spreadsheets into my MySQL database using
>> phpMyAdmin.. My version of
>> ​​
>> phpMyAdmin asks to locate the File you wish to
>> import.Specifically, it offers a Browse option. Locate the Calc file you
>> wish to import.by browsing to it in your file system.
>> It also asks for the type of file you wish to import. One of the options
>> is
>> ODF spreadsheet.That's the format of Calc, isn't it ?
>> No need to convert to CSV File.
>> Hank
>>
>> Thanks Hank
>
> But no luck!! I tried to import my ODS Spreadsheet file from LibraOffice
> and got the following error...
>
> /"You attempted to load file with unsupported compression
> (application/zip).
> Either support for it is not implemented or disabled by your
> configuration"./
>
> The file is NOT compressed or Zipped and opens perfectly in LO Calc!!
>
> So still a problem - but I appreciate the pointer.
>

​ODF files are compressed archives of XML files (that's why they, like
MSOOXML, are not the best containers for larger data, but this is off
topic)​. I guess you're getting the error because the web server handling
the Admin isn't fully set up. The devil is in the detail...

Hank's suggestion looks good -- apps supporting ODS would be much better
than underspecified CSV, so such
​
phpMyAdmin's import may work. However there's possible issue that such
tools need to be supplied with _range information_ of data that has to be
imported from ODS.
In absence of such, the only is guessing or heuristics, like we have in
Kexi's ODS->Table importer, by the way. If there are more possible ranges,
manual intervention may be needed, such as moving data to a simpler,
separate sheet, and that would degrade the whole automation. Sure, for
one-time import this isn't a big deal.

I am writing this to note that we sometimes lack specialized but popular
standards for exchanging data or schema.


> Best regards
>
> IanW
> Pretoria RSA
>
>
> --
> 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
>



-- 
regards, Jaroslaw Staniek

KDE:
: A world-wide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development - http://kde.org
Calligra Suite:
: A graphic art and office suite - http://calligra.org
Kexi:
: A visual database apps builder - http://calligra.org/kexi
Qt Certified Specialist:
: http://www.linkedin.com/in/jstaniek

-- 
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: LibreOffice Base and MySQL

[Alexander Thurgood]

Le 24/01/2016 09:04, Hank Alper a écrit :

Hi Hank,


> Hi Ian,
> I frequently import Calc Spreadsheets into my MySQL database using
> phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
> import.Specifically, it offers a Browse option. Locate the Calc file you
> wish to import.by browsing to it in your file system.
> It also asks for the type of file you wish to import. One of the options is
> ODF spreadsheet.That's the format of Calc, isn't it ?
> No need to convert to CSV File.

The "rub" in this useful solution is that it does indeed depend on the
version of phpmyadmin supplied with your distro.

Ian is using PCLinuxOS or PCLOS, and judging from his reply to you, it
would appear that the version supplied with that distro doesn't have the
import from ODS functionality.


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: LibreOffice Base and MySQL

[Andreas Säger]

Am 24.01.2016 um 09:04 schrieb Hank Alper:
> Hi Ian,
> I frequently import Calc Spreadsheets into my MySQL database using
> phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
> import.Specifically, it offers a Browse option. Locate the Calc file you
> wish to import.by browsing to it in your file system.
> It also asks for the type of file you wish to import. One of the options is
> ODF spreadsheet.That's the format of Calc, isn't it ?
> No need to convert to CSV File.
> Hank
> 

Open the spreadsheet document. Ensure that your data are organized as a
normalized list where numbers are numbers, dates are dates and times are
times. Quite often and for no reason, Excel sheets are poisoned with
text data which makes them rather useless. If you can not distinguish
the data types in a spreadsheet, there is no hope anyway.

Copy the normalized list of valid data including any header row.
In the Base document which is connected to your MySQLDB click the _icon_
of a target table where you want to append the spreadsheet data and paste.
A wizard pops up where you can map the fields of the clipboard data to
the fields of your database table.

This may raise 3 types of errors:
-- referencial integrity errors
-- not nullable errors
-- wrong data type errors
Each of these error types can be answered with "Cancel" or "Ignore". The
ignore option will try to import as much as possible without raising the
same error again.

Some helpful spreadsheet formulas to test spreadsheet data for consisteency:

> =MAX(LEN(column))[Ctrl+Shift+Enter] returns the max. length of a text column.
> =COUNTBLANK(column) counts blanks.
> =COUNTA(column) counts any values
> =COUNT(column) counts numbers
> =COUNTA(column)=COUNT(column) TRUE if there are only numbers.
> =AND(ROWS(COLUMN)=COUNT(column);COUNTA(column)=COUNT(column) TRUE if there 
> are only numbers and now blanks.
> =MIN/MAX(column) min and max values of a column
> =N(MATCH(value;column;0)) returns 0 if value does not occur in some other 
> table's column (test referencial integrity).
> =COUNTIF(value;same_column)>1 returns TRUE if there are duplicates in the 
> same column.

=MATCH(value ; other_list ; 0) tests referencial integrity against
another table.


-- 
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: LibreOffice Base and MySQL

[Hank Alper]

Hi Ian,
I frequently import Calc Spreadsheets into my MySQL database using
phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
import.Specifically, it offers a Browse option. Locate the Calc file you
wish to import.by browsing to it in your file system.
It also asks for the type of file you wish to import. One of the options is
ODF spreadsheet.That's the format of Calc, isn't it ?
No need to convert to CSV File.
Hank

On Thu, Jan 21, 2016 at 7:43 AM, Andreas Säger  wrote:

> Am 21.01.2016 um 13:20 schrieb Heinrich Stoellinger:
> > Of course these are valid values as for as CSV is concerned, but not ALL
> > are
> > valid as far as MySQL goes. I have no problem restoring MySQL-DATE COLUMN
> > values, but represent them as "2014-12-22", the same as character
> strings.
> > Forget Base at the moment and deal with the stipulations of SQL, in
> > particular
> > MySQL.
> >
> > On Thu, 21 Jan 2016 11:37:51 +0100, Jaroslaw Staniek 
> > wrote:
> >
>
> Of course, ISO dates are the one and only unambiguous standard for date
> strings. It is not too difficult to convert other date strings with 3
> numbers and 2 separators into ISO strings which can be converted to real
> date values.
>
>
> --
> 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] re: LibreOffice Base - music cataloging

[charles meyer]

That data ended up in that fashion because I was trying to create a
simple list of file names of files located on a flash drive and the
only way I recall doing that in Windows XP - now 7 - is to use the DOS
command which then generates that info as I shared.

I was just trying to generate a list of file names alphabetically by
artist/file name for each .mp3 but Windows doesn't seem to do that
easily.


LibreOffice Base - music cataloging
-   48039 - Dries Feys 
-

-- 
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: LibreOffice Base - music cataloging

[charles meyer]

Hi Dries,

Thank you for sharing that it could be imported to iTunes.

I’d prefer not to do this online but I do appreciate you sharing that.

That data ended up in that fashion because I was trying to create a
simple list of file names of files located on a flash drive and the
only way I recall doing that in Windows XP - now 7 - is to use the DOS
command which then generates that info as I shared.

I was just trying to generate a list of file names alphabetically by
artist/file name for each .mp3 but Windows doesn't seem to do that
easily.

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] Re: LibreOffice Base and MySQL

[Andreas Säger]

Am 21.01.2016 um 13:20 schrieb Heinrich Stoellinger:
> Of course these are valid values as for as CSV is concerned, but not ALL
> are
> valid as far as MySQL goes. I have no problem restoring MySQL-DATE COLUMN
> values, but represent them as "2014-12-22", the same as character strings.
> Forget Base at the moment and deal with the stipulations of SQL, in
> particular
> MySQL.
> 
> On Thu, 21 Jan 2016 11:37:51 +0100, Jaroslaw Staniek 
> wrote:
> 

Of course, ISO dates are the one and only unambiguous standard for date
strings. It is not too difficult to convert other date strings with 3
numbers and 2 separators into ISO strings which can be converted to real
date values.


-- 
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: LibreOffice Base and MySQL

[Heinrich Stoellinger]

Of course these are valid values as for as CSV is concerned, but not ALL are
valid as far as MySQL goes. I have no problem restoring MySQL-DATE COLUMN
values, but represent them as "2014-12-22", the same as character strings.
Forget Base at the moment and deal with the stipulations of SQL, in particular
MySQL.

On Thu, 21 Jan 2016 11:37:51 +0100, Jaroslaw Staniek  wrote:


On 20 January 2016 at 21:34, Andreas Säger  wrote:


How can anybody solve any csv related problem without knowing anything
about
the actual content?

4 different lines of perfectly valid and commonly used csv data:

1234.98;2014-12-22
1.234,98;22 Dez 2014
1234.98;12/22/14
1234.98;22/12/14

Each line carries the exact same information. I could add a thousand more
different lines with the exact same values without leaving the conventions
of valid csv.



​Exactly, this is why I have invested in pretty a intelligent
auto-detection of data types​
​ and representation of values in Kexi​

​CSV importer.​ Yes, dates values are the most tricky.

Sure, the auto-detection has limits, importing has to be _interactive_ at
times, at least until we "know" all the options user wants to use, then the
user would be able to save and re-use an 'import specification'.
For complicated import cases it's not a matter of a custom SQL statement,
it's sometimes a trial-and-error process.

The only thing I would regret is that we have no organized FOSS effort to
share such routines and every app has own. Not yet at least.

(Ian has sent me a rich feedback off the list, work in progress)





--
View this message in context:
http://nabble.documentfoundation.org/LibreOffice-Base-and-MySQL-tp4172396p4172475.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








--
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

Re: [libreoffice-users] Re: LibreOffice Base and MySQL

[Jaroslaw Staniek]

On 20 January 2016 at 21:34, Andreas Säger  wrote:

> How can anybody solve any csv related problem without knowing anything
> about
> the actual content?
>
> 4 different lines of perfectly valid and commonly used csv data:
>
> 1234.98;2014-12-22
> 1.234,98;22 Dez 2014
> 1234.98;12/22/14
> 1234.98;22/12/14
>
> Each line carries the exact same information. I could add a thousand more
> different lines with the exact same values without leaving the conventions
> of valid csv.
>

​Exactly, this is why I have invested in pretty a intelligent
auto-detection of data types​
​ and representation of values in Kexi​

​CSV importer.​ Yes, dates values are the most tricky.

Sure, the auto-detection has limits, importing has to be _interactive_ at
times, at least until we "know" all the options user wants to use, then the
user would be able to save and re-use an 'import specification'.
For complicated import cases it's not a matter of a custom SQL statement,
it's sometimes a trial-and-error process.

The only thing I would regret is that we have no organized FOSS effort to
share such routines and every app has own. Not yet at least.

(Ian has sent me a rich feedback off the list, work in progress)


>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/LibreOffice-Base-and-MySQL-tp4172396p4172475.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
>
>


-- 
regards, Jaroslaw Staniek

KDE:
: A world-wide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development - http://kde.org
Calligra Suite:
: A graphic art and office suite - http://calligra.org
Kexi:
: A visual database apps builder - http://calligra.org/kexi
Qt Certified Specialist:
: http://www.linkedin.com/in/jstaniek

-- 
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: LibreOffice Base and MySQL

[Andreas Säger]

When using HSQL (which is less powerful than MySQL) command CREATE TEXT
TABLE "Foo"(...) prepares a table "Foo" with fields and indices just
like a regular data table. A second command SET TABLE "Foo"... links the
text table "Foo" to a particular text file.
If the linked text table and the underlying csv and the target table
share the same structure with same data types in same order of columns,
I can simply drag the text table icon over the icon of the regular data
table and confirmt the import dialog without further adjustments.
If this precondition is not met or when data type conversions are needed
(e.g. text with German comma decimals and D.M.Y dates) then I create a
view to return all fields with the right types in right order and drag
the view over the data table. HSQL only accepts text data with point
decimals and ISO date/times.
With the right setup it is just a simple drag operation with no
spreadsheet involved. The setup is development work because it requires
understanding simple data types. Same problem with csv to spreadsheet
imports which will fail in most cases when you ignore the import options
because you don't understand 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

[libreoffice-users] Re: LibreOffice Base and MySQL

[Andreas Säger]

How can anybody solve any csv related problem without knowing anything about
the actual content?

4 different lines of perfectly valid and commonly used csv data:

1234.98;2014-12-22
1.234,98;22 Dez 2014
1234.98;12/22/14
1234.98;22/12/14

Each line carries the exact same information. I could add a thousand more
different lines with the exact same values without leaving the conventions
of valid csv.



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-Base-and-MySQL-tp4172396p4172475.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: LibreOffice Base and MySQL

[Andreas Säger]

Am 20.01.2016 um 11:05 schrieb Ian Whitfield:
> Hi All
> 
> I have been trying to import a CSV file from Calc into MySQL to run with
> Base for over a week now and can not believe this is so difficult to do
> so I'm hoping some other Base users might have cracked this one!!
> 
> My OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is
> running on localhost.
> 

Database admins don't use spreadsheets. MySQL can do this very well. Of
course, csv is not a file format. It is mere convention with millions of
different flavours.



-- 
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: LibreOffice Base and MySQL

[Alexander Thurgood]

Le 20/01/2016 11:05, Ian Whitfield a écrit :

Ian,

I would suggest opening up your Calc created CSV in a normal text
editor, to see what it "really" looks like. Only in this way will you be
able to choose the right options to import the data into mysql.

As Andreas has rightly said, you don't actually need a graphical tool to
import CSV files into mysql - the official mysql technical
documentation, if you care to read it, is really quite good in this
respect :

http://dev.mysql.com/doc/refman/5.7/en/load-data.html

Also, this tutorial gives some very handy examples of how to import CSV
files into mysql :

http://www.mysqltutorial.org/import-csv-file-mysql-table/


The error messages you are seeing seem to indicate that the data you are
trying to input doesn't correspond to the definition of that data which
is set in the database.


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: LibreOffice Base and Java conflict

[Mark LaPierre]

On 05/27/15 09:47, Tom Davies wrote:
 Hi :)
 If possible it is a good idea to export your database tables to a different
 program such as Postgresql or MariaDb/MySql or any other non-Java external
 back-end.  Then hopefully Base can connect to your external back-end
 without having to edit your Queries, Forms or Reports much.
 
 This is a good start to up-scaling your database so that the data can be
 used in other ways and/or by other programs and maybe even on other
 machines.
 
 Base's internal back-end is not great and is worth moving away from.  It
 was only plugged in to make Base behave more like MS's very limiting
 Access program instead of using Base the much more powerful way it was
 initially designed to be used.
 Regards from
 Tom :)
 
 
 
 On 27 May 2015 at 01:13, Andreas Säger ville...@t-online.de wrote:
 
 Am 26.05.2015 um 17:56 schrieb Алексей Антипов:
 Dear sirs!

 I have a problem with using of LibreOffice Base because of message about
 non-working Java in my system.
 Although Java is installed in my system.
 My OS is Windows XP SP3 32-bit on my netbook Asus Aspire One D270k, and
 i tried versions JRE-7u79 and JRE-6u45, and also latest Java 8 (although
 officially Java 8 is not support Windows XP), and in all cases when i work
 with LibreOffice Base document and try to open sheet, i have a message that
 JRE is corrupted. Reinstalling of Java and LibreOffice does not give any
 positive effect.
 I also tried to install Java in directory with installed LibreOffice, it
 also didn't give positive effect.
 I use latest LibreOffice_4.4.3_Win_x86 version.



 Troubleshooting Open/LibreOffice and Java
 https://forum.openoffice.org/en/forum/viewtopic.php?f=74t=69896




 --
 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

 
On 05/27/15 09:47, Tom Davies wrote: Hi :)
 If possible it is a good idea to export your database tables to a
different
 program such as Postgresql or MariaDb/MySql or any other non-Java external
 back-end.  Then hopefully Base can connect to your external back-end
 without having to edit your Queries, Forms or Reports much.

 This is a good start to up-scaling your database so that the data can be
 used in other ways and/or by other programs and maybe even on other
 machines.

 Base's internal back-end is not great and is worth moving away from.  It
 was only plugged in to make Base behave more like MS's very limiting
 Access program instead of using Base the much more powerful way it was
 initially designed to be used.
 Regards from
 Tom :)




Hey Tom,

It is possible to place your data in MySQL, MariaDB, or other database
backends.  Base can link to tables in MySQL.  I've done it, but not very
well, a couple of times.  Seems I've got a lot to learn.

You can also link to tables maintained by a stand alone version of the
same built in database that Base uses.  I've done that too, but not very
well.  It's called HSQLDB.  You can set up an instance on a server and
connect to it over your network, or you can set up an instance on the
same computer and connect to it directly.

-- 
_
   °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] Re: LibreOffice Base and Java conflict

[Tom Davies]

Hi :)
If possible it is a good idea to export your database tables to a different
program such as Postgresql or MariaDb/MySql or any other non-Java external
back-end.  Then hopefully Base can connect to your external back-end
without having to edit your Queries, Forms or Reports much.

This is a good start to up-scaling your database so that the data can be
used in other ways and/or by other programs and maybe even on other
machines.

Base's internal back-end is not great and is worth moving away from.  It
was only plugged in to make Base behave more like MS's very limiting
Access program instead of using Base the much more powerful way it was
initially designed to be used.
Regards from
Tom :)



On 27 May 2015 at 01:13, Andreas Säger ville...@t-online.de wrote:

 Am 26.05.2015 um 17:56 schrieb Алексей Антипов:
  Dear sirs!
 
  I have a problem with using of LibreOffice Base because of message about
 non-working Java in my system.
  Although Java is installed in my system.
  My OS is Windows XP SP3 32-bit on my netbook Asus Aspire One D270k, and
 i tried versions JRE-7u79 and JRE-6u45, and also latest Java 8 (although
 officially Java 8 is not support Windows XP), and in all cases when i work
 with LibreOffice Base document and try to open sheet, i have a message that
 JRE is corrupted. Reinstalling of Java and LibreOffice does not give any
 positive effect.
  I also tried to install Java in directory with installed LibreOffice, it
 also didn't give positive effect.
  I use latest LibreOffice_4.4.3_Win_x86 version.
 


 Troubleshooting Open/LibreOffice and Java
  https://forum.openoffice.org/en/forum/viewtopic.php?f=74t=69896




 --
 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] Re: LibreOffice Base and Java conflict

[Andreas Säger]

Am 26.05.2015 um 17:56 schrieb Алексей Антипов:
 Dear sirs!
 
 I have a problem with using of LibreOffice Base because of message about 
 non-working Java in my system.
 Although Java is installed in my system.
 My OS is Windows XP SP3 32-bit on my netbook Asus Aspire One D270k, and i 
 tried versions JRE-7u79 and JRE-6u45, and also latest Java 8 (although 
 officially Java 8 is not support Windows XP), and in all cases when i work 
 with LibreOffice Base document and try to open sheet, i have a message that 
 JRE is corrupted. Reinstalling of Java and LibreOffice does not give any 
 positive effect.
 I also tried to install Java in directory with installed LibreOffice, it also 
 didn't give positive effect.
 I use latest LibreOffice_4.4.3_Win_x86 version.
 


Troubleshooting Open/LibreOffice and Java
 https://forum.openoffice.org/en/forum/viewtopic.php?f=74t=69896




-- 
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: LibreOffice - Base...

[NoOp]

On 08/05/2014 11:08 PM, David Love wrote:
 Using LinuxMint v17.0 Qiana qith the MATE DE.
 
 Have followed with interest the recent discussins on Base and have decided
 to try and learn how to use it, using PostGreSQL as the backend.  But -
 and there is always one of those :-) - how many of the multitude of
 postgrsql files in Synaptic do I need to install, please.
 
 David
 

These might be of help:

https://help.ubuntu.com/community/PostgreSQL
http://ask.libreoffice.org/en/question/18554/how-to-connect-base-to-to-postgresql/
https://answers.launchpad.net/ubuntu/+faq/2155






-- 
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: LibreOffice - Base...

[Alex Thurgood]

Le 06/08/2014 08:08, David Love a écrit :
 Using LinuxMint v17.0 Qiana qith the MATE DE.

I have Mint 17 Cinnamon


 
 Have followed with interest the recent discussins on Base and have decided
 to try and learn how to use it, using PostGreSQL as the backend.  But -
 and there is always one of those :-) - how many of the multitude of
 postgrsql files in Synaptic do I need to install, please.
 

postgresql-9.3
postgresql-client-9.3
postgresql-contrib-9.3
postgresql-doc-9.3
libpq5
libreoffice-base-drivers
libreoffice-sdbc-postgresql

That should probably do it.

Note that the documentation is optional, but nonetheless useful ;-)
It can be read in your browser by entering the following into the URL
field

file:///usr/share/doc/postgresql-doc-9.3/html/


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: LibreOffice Base Runtime File

[Alexander Thurgood]

Le 27/04/14 03:07, tb a écrit :


 
 Does LibreOffice Base have a runtime file that would enable me to distribute 
 an application to users who do not have the full version of Base installed on 
 their computers?
 

No. You need a complete LO installation.

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: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Tom Davies]

Hi :)
Ahah, thanks Jay.  I was hoping that HSql only dipped into using java for a few 
things.  So, Don needs to have that java box ticked all the time he uses Base 
and can only avoid it when not using Base at all.

Is it possible to edit short-cuts and stuff so that opening Base will enable 
java but opening java wont?  I think it might be possible in GnuLinux by 
having 2 different short-cuts on the desktop or in the taskbar/panel.

regards from
Tom :)


--- On Sun, 18/9/11, planas jsloz...@gmail.com wrote:

From: planas jsloz...@gmail.com
Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org
Date: Sunday, 18 September, 2011, 6:58

Hi,
On Sat, 2011-09-17 at 23:30 +0100, Tom Davies wrote: 

 Hi :)
 Thanks Don.  I think you might be able to convert/export/migrate your 
 back-end to a different one.  I don't think you have to stick with HSql.  I'm 
 not sure if it's possible to remove java dependence when using HSql, i 
 thought it was but i could be wrong.
 Regards from
 Tom :)
 
 
 --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote:
 
 From: Don Myers donmy...@myersfarm.com
 Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
 To: users@global.libreoffice.org
 Date: Saturday, 17 September, 2011, 23:13
 
 Hi All,
 
 I set up base shortly after it was added to Open Office. Apparently I am 
 using the embedded database - HSQL database engine. If I turn off Java 
 (I just tried it.), I get the following error message:
 The connection to the data source RE Database could not be 
 established. No SDBC driver was found for the given URL.
 
 I cannot open my database without Java enabled. So using the database 
 included with base will not work without Java.
 
 Don

snip

The HSQL engine is Java based. It may be possible to use Base as a
front-end for something like MySQL or PostgreSQL, which do not use Java.


 On 09/17/2011 08:29 AM, Tom Davies wrote:
  Hi :)
  I think you can completely un-install all instances of java but i think 
  that might create problems.  Your web-browser might not be very happy 
  without java.  Generally i try to keep escape routes and back-up plans 
  available = so i would just switch off java in LO so that i could switch it 
  on again quite easily if i needed it.
 
  Tools - Options - LibreOffice/General - Java
  then UNtick the box at the very top Use a java runtime environment.  I 
  have only unticked this a few days ago and LO seems to start-up a lot 
  faster.
  Regards from
  Tom :)
 
  --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at  wrote:
 
  From: Heinrich Stoellingerhc.stoellin...@aon.at
  Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
  To: users@global.libreoffice.orgusers@global.libreoffice.org
  Date: Saturday, 17 September, 2011, 11:55
 
  Hello again,
  Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
  to MySQL on Linux (and a very well working native MySQL-connection under
  Windows). Like I posted in another message, ODBC also has problems (such
  as not showing default values for columns correctly on data entry, but -
  since the database is actually updated correctly - this doesn't really
  worry me much.
  So, like Tom suggests: can I get completely rid of Java if I don't
  conciously use it in any way that an end-user or programmer could cause?
  That would be more than alright for me...
  Regards
  H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
  P.S.: I have used the Java-connector in the past but don't do so anymore.
 
 
  --- Forwarded message ---
  From: Andreas Sägerville...@t-online.de
  To: users@global.libreoffice.org
  Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
  Date: Sat, 17 Sep 2011 11:35:28 +0200
 
  Since you are not running MySQL through ODBC you can turn off all Java
  support for the entire office suite and simply work with the raw
  database connectivity and input forms.
  All the Java wizards are close to useless anyway. You don't need them
  and get much better results faster if you know what you're doing.
 
 
 
  Am 16.09.2011 20:44, Heinrich Stoellinger wrote:
  Hello again,
  On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
  connetcion
  to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
  then save
  LO-Base, CPU-usage is normal again (for a while!). I don't really know
  what causes
  this behaviour, could it have to to with backup copy creation? I find an
  aweful
  lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
  All of them have a filename something like rmodbc.odb_9777.odb and are
  of 0 (zero)
  size. I wonder what's wrong.
  Regards
  H. Stoellinger
 
 
  --Erstellt mit Operas revolutionärem E-Mail-Modul: 
  http://www.opera.com/mail/
 
  --For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
  Problems? 
  http://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Ian Whitfield]

On 17/09/2011 04:03, Don Myers wrote:


This solved my problem totally. 1.6.0_21 works very fast with Base.


After LOTS of problems with Base I also went this way and it works for 
me too!!!


I can recommend it to everyone using Base Almost perfect again!!!

Ian Whitfield

--
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: LibreOffice-Base CPU usage

[Tom Davies]

Hi :)
Were you using OpenJdk before?  Could you test-drive the _20 and _22 to see if 
they are as good as the _21?  A few people say that the _20 or _22 are a huge 
improvement on things like the _24 or onwards.  I am trying to convince someone 
to try the _21 but he is happy enough with the _20 and thinks there wont be 
much better than that.

Don't worry if you don't have time!  I am just really glad to hear it works 
well for you :)
Regards from
Tom :)


--- On Sat, 17/9/11, Ian Whitfield whitfi...@telkomsa.net wrote:

From: Ian Whitfield whitfi...@telkomsa.net
Subject: Re: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 8:39



On 17/09/2011 04:03, Don Myers wrote:
 
 This solved my problem totally. 1.6.0_21 works very fast with Base.

After LOTS of problems with Base I also went this way and it works for me too!!!

I can recommend it to everyone using Base Almost perfect again!!!

Ian Whitfield

-- 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: LibreOffice-Base CPU usage

[Tom Davies]

Hi :)
Java is an unusual problem for LibreOffice.  Most of the apps have either 
already moved away from it or are moving away fast.  Java and OpenJdk are owned 
by Oracle.  Do we have any confidence in
them fixing things so that their products work better for LibreOffice?  
Currently the newer the release of Java the more problems there seems to be in 
using it in LibreOffice.  

I don't think there was a bug-report.  There are almost no devs working on Base 
so posting a bug-report is not likely to yield any positive results for months, 
maybe years.  Also if devs do start working on Base it would be good to follow 
the rest of the project away from java.  Inevitably devs are going to have to 
start by fixing bugs but any work they do to fix problems with java will have 
been a bit of a waste of time after java is written out.  

It's NOT ideal for LO but we have to deal with things as they are rather than 
how we would like them to be.  We can temporarily work-around problems by using 
the _21 (or _20 or _22) and by trying to encourage people to develop Base's 
code.  

The SC wants to sitwait to see if anyone happens to notice that working on 
Base might be a rewarding challenge.  When pushed they thought it might be nice 
to make a questionnaire to send to people who don't need a database program to 
ask them what they want from a database.  
Regards from
Tom :)


--- On Sat, 17/9/11, NoOp gl...@sbcglobal.net wrote:

From: NoOp gl...@sbcglobal.net
Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 3:59

On 09/16/2011 07:03 PM, Don Myers wrote:
 
 
 On 09/16/2011 08:31 PM, NoOp wrote:
 On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote:
 Hello again,
 On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC 
 connetcion
 to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I 
 then save
 LO-Base, CPU-usage is normal again (for a while!). I don't really know what 
 causes
 this behaviour, could it have to to with backup copy creation? I find an 
 aweful
 lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
 All of them have a filename something like rmodbc.odb_9777.odb and are of 
 0 (zero)
 size. I wonder what's wrong.
 Regards
 H. Stoellinger

 And what happens if you turn off auto backup?



   
 Hi All,
 
 Base worked well for me in Windows since it was created while I was 
 running Windows, and for two years in Ubuntu until the Java for Linux 
 was updated from 1.6.0_22 to 1.6.0_24 last spring. At that point Base 
 became almost unusable. In a database with 2500 records, instead of 
 going from the first record to the last record in about 1 second, the 
 time became 25 to 30 seconds. When I looked at CPU usage. 1 core would 
 be running at 100% during this time. Java 1.6.0_26 then came out, and 
 the same problem existed. About 5 weeks ago someone started a thread 
 titled something like Base runs unacceptably slowly. One person left a 
 post stating that in Linux you can have more than one version of Java 
 installed at the same time and left the following instructions:

Please provide a link to your bug reports (for both LO and Java). Thanks.
...


-- 
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: LibreOffice-Base CPU usage

[Andreas Säger]

Since you are not running MySQL through ODBC you can turn off all Java 
support for the entire office suite and simply work with the raw 
database connectivity and input forms.
All the Java wizards are close to useless anyway. You don't need them 
and get much better results faster if you know what you're doing.




Am 16.09.2011 20:44, Heinrich Stoellinger wrote:

Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
then save
LO-Base, CPU-usage is normal again (for a while!). I don't really know
what causes
this behaviour, could it have to to with backup copy creation? I find an
aweful
lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
All of them have a filename something like rmodbc.odb_9777.odb and are
of 0 (zero)
size. I wonder what's wrong.
Regards
H. Stoellinger





--
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

Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Heinrich Stoellinger]

Hello again,
Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
to MySQL on Linux (and a very well working native MySQL-connection under
Windows). Like I posted in another message, ODBC also has problems (such
as not showing default values for columns correctly on data entry, but -
since the database is actually updated correctly - this doesn't really
worry me much.
So, like Tom suggests: can I get completely rid of Java if I don't
conciously use it in any way that an end-user or programmer could cause?
That would be more than alright for me...
Regards
H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
P.S.: I have used the Java-connector in the past but don't do so anymore.


--- Forwarded message ---
From: Andreas Säger ville...@t-online.de
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
Date: Sat, 17 Sep 2011 11:35:28 +0200

Since you are not running MySQL through ODBC you can turn off all Java
support for the entire office suite and simply work with the raw
database connectivity and input forms.
All the Java wizards are close to useless anyway. You don't need them
and get much better results faster if you know what you're doing.



Am 16.09.2011 20:44, Heinrich Stoellinger wrote:

Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
then save
LO-Base, CPU-usage is normal again (for a while!). I don't really know
what causes
this behaviour, could it have to to with backup copy creation? I find an
aweful
lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
All of them have a filename something like rmodbc.odb_9777.odb and are
of 0 (zero)
size. I wonder what's wrong.
Regards
H. Stoellinger




--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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: LibreOffice-Base CPU usage

[Don Myers]

GREAT! It is a day/night difference!

On 09/17/2011 03:39 AM, Ian Whitfield wrote:



On 17/09/2011 04:03, Don Myers wrote:


This solved my problem totally. 1.6.0_21 works very fast with Base.


After LOTS of problems with Base I also went this way and it works for 
me too!!!


I can recommend it to everyone using Base Almost perfect again!!!

Ian Whitfield



--

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Phone: 814-237-6543 Fax: 814-237-6502
Visit the Farm and Rural Property Division Website at 
www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_

_View Don's farm website: www.myersfarm.com http://www.myersfarm.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: LibreOffice-Base CPU usage

[Don Myers]

On 09/16/2011 10:59 PM, NoOp wrote:

On 09/16/2011 07:03 PM, Don Myers wrote:


On 09/16/2011 08:31 PM, NoOp wrote:

On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote:

Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC 
connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then 
save
LO-Base, CPU-usage is normal again (for a while!). I don't really know what 
causes
this behaviour, could it have to to with backup copy creation? I find an aweful
lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
All of them have a filename something like rmodbc.odb_9777.odb and are of 0 
(zero)
size. I wonder what's wrong.
Regards
H. Stoellinger


And what happens if you turn off auto backup?





Hi All,

Base worked well for me in Windows since it was created while I was
running Windows, and for two years in Ubuntu until the Java for Linux
was updated from 1.6.0_22 to 1.6.0_24 last spring. At that point Base
became almost unusable. In a database with 2500 records, instead of
going from the first record to the last record in about 1 second, the
time became 25 to 30 seconds. When I looked at CPU usage. 1 core would
be running at 100% during this time. Java 1.6.0_26 then came out, and
the same problem existed. About 5 weeks ago someone started a thread
titled something like Base runs unacceptably slowly. One person left a
post stating that in Linux you can have more than one version of Java
installed at the same time and left the following instructions:

Please provide a link to your bug reports (for both LO and Java). Thanks.
...


I think the LibreOfice bug report was closed when the workaround was 
discovered. I think a notice was sent out to that effect. I don't know 
what had been filed with Java. One would have thought when OpenOffice 
and Java were both owned by Oracle that there would have been some 
communication between them. The problems stated before Oracle disposed 
of Open Office.

--

***
*


--
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: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Tom Davies]

Hi :)
I think you can completely un-install all instances of java but i think that 
might create problems.  Your web-browser might not be very happy without java.  
Generally i try to keep escape routes and back-up plans available = so i would 
just switch off java in LO so that i could switch it on again quite easily if i 
needed it.

Tools - Options - LibreOffice/General - Java
then UNtick the box at the very top Use a java runtime environment.  I have 
only unticked this a few days ago and LO seems to start-up a lot faster.
Regards from
Tom :)

--- On Sat, 17/9/11, Heinrich Stoellinger hc.stoellin...@aon.at wrote:

From: Heinrich Stoellinger hc.stoellin...@aon.at
Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 11:55

Hello again,
Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
to MySQL on Linux (and a very well working native MySQL-connection under
Windows). Like I posted in another message, ODBC also has problems (such
as not showing default values for columns correctly on data entry, but -
since the database is actually updated correctly - this doesn't really
worry me much.
So, like Tom suggests: can I get completely rid of Java if I don't
conciously use it in any way that an end-user or programmer could cause?
That would be more than alright for me...
Regards
H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
P.S.: I have used the Java-connector in the past but don't do so anymore.


--- Forwarded message ---
From: Andreas Säger ville...@t-online.de
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
Date: Sat, 17 Sep 2011 11:35:28 +0200

Since you are not running MySQL through ODBC you can turn off all Java
support for the entire office suite and simply work with the raw
database connectivity and input forms.
All the Java wizards are close to useless anyway. You don't need them
and get much better results faster if you know what you're doing.



Am 16.09.2011 20:44, Heinrich Stoellinger wrote:
 Hello again,
 On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
 connetcion
 to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
 then save
 LO-Base, CPU-usage is normal again (for a while!). I don't really know
 what causes
 this behaviour, could it have to to with backup copy creation? I find an
 aweful
 lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
 All of them have a filename something like rmodbc.odb_9777.odb and are
 of 0 (zero)
 size. I wonder what's wrong.
 Regards
 H. Stoellinger
 


--Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--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

Fwd: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Heinrich Stoellinger]

Hello Tom,
Thanks for your suggestion. I unticked the box at the very top Use a java runtime 
environment
and LO still works fine. It also starts up very fast.
As I need Java for purposes outside of LO, I will keep it for the time being.
Regards
Heinrich

--- Forwarded message ---
From: Tom Davies tomdavie...@yahoo.co.uk
To: users@global.libreoffice.org
Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Date: Sat, 17 Sep 2011 14:29:10 +0200

Hi :)
I think you can completely un-install all instances of java but i think that 
might create problems.  Your web-browser might not be very happy without java.  
Generally i try to keep escape routes and back-up plans available = so i would 
just switch off java in LO so that i could switch it on again quite easily if i 
needed it.

Tools - Options - LibreOffice/General - Java
then UNtick the box at the very top Use a java runtime environment.  I have 
only unticked this a few days ago and LO seems to start-up a lot faster.
Regards from
Tom :)

--- On Sat, 17/9/11, Heinrich Stoellinger hc.stoellin...@aon.at wrote:

From: Heinrich Stoellinger hc.stoellin...@aon.at
Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 11:55

Hello again,
Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
to MySQL on Linux (and a very well working native MySQL-connection under
Windows). Like I posted in another message, ODBC also has problems (such
as not showing default values for columns correctly on data entry, but -
since the database is actually updated correctly - this doesn't really
worry me much.
So, like Tom suggests: can I get completely rid of Java if I don't
conciously use it in any way that an end-user or programmer could cause?
That would be more than alright for me...
Regards
H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
P.S.: I have used the Java-connector in the past but don't do so anymore.


--- Forwarded message ---
From: Andreas Säger ville...@t-online.de
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
Date: Sat, 17 Sep 2011 11:35:28 +0200

Since you are not running MySQL through ODBC you can turn off all Java
support for the entire office suite and simply work with the raw
database connectivity and input forms.
All the Java wizards are close to useless anyway. You don't need them
and get much better results faster if you know what you're doing.



Am 16.09.2011 20:44, Heinrich Stoellinger wrote:

Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
then save
LO-Base, CPU-usage is normal again (for a while!). I don't really know
what causes
this behaviour, could it have to to with backup copy creation? I find an
aweful
lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
All of them have a filename something like rmodbc.odb_9777.odb and are
of 0 (zero)
size. I wonder what's wrong.
Regards
H. Stoellinger




--Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--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


--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Don Myers]

Hi All,

I set up base shortly after it was added to Open Office. Apparently I am 
using the embedded database - HSQL database engine. If I turn off Java 
(I just tried it.), I get the following error message:
The connection to the data source RE Database could not be 
established. No SDBC driver was found for the given URL.


I cannot open my database without Java enabled. So using the database 
included with base will not work without Java.


Don

On 09/17/2011 08:29 AM, Tom Davies wrote:

Hi :)
I think you can completely un-install all instances of java but i think that 
might create problems.  Your web-browser might not be very happy without java.  
Generally i try to keep escape routes and back-up plans available = so i would 
just switch off java in LO so that i could switch it on again quite easily if i 
needed it.

Tools - Options - LibreOffice/General - Java
then UNtick the box at the very top Use a java runtime environment.  I have 
only unticked this a few days ago and LO seems to start-up a lot faster.
Regards from
Tom :)

--- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at  wrote:

From: Heinrich Stoellingerhc.stoellin...@aon.at
Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.orgusers@global.libreoffice.org
Date: Saturday, 17 September, 2011, 11:55

Hello again,
Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
to MySQL on Linux (and a very well working native MySQL-connection under
Windows). Like I posted in another message, ODBC also has problems (such
as not showing default values for columns correctly on data entry, but -
since the database is actually updated correctly - this doesn't really
worry me much.
So, like Tom suggests: can I get completely rid of Java if I don't
conciously use it in any way that an end-user or programmer could cause?
That would be more than alright for me...
Regards
H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
P.S.: I have used the Java-connector in the past but don't do so anymore.


--- Forwarded message ---
From: Andreas Sägerville...@t-online.de
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
Date: Sat, 17 Sep 2011 11:35:28 +0200

Since you are not running MySQL through ODBC you can turn off all Java
support for the entire office suite and simply work with the raw
database connectivity and input forms.
All the Java wizards are close to useless anyway. You don't need them
and get much better results faster if you know what you're doing.



Am 16.09.2011 20:44, Heinrich Stoellinger wrote:

Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
then save
LO-Base, CPU-usage is normal again (for a while!). I don't really know
what causes
this behaviour, could it have to to with backup copy creation? I find an
aweful
lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
All of them have a filename something like rmodbc.odb_9777.odb and are
of 0 (zero)
size. I wonder what's wrong.
Regards
H. Stoellinger



--Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--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




--

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Phone: 814-237-6543 Fax: 814-237-6502
Visit the Farm and Rural Property Division Website at 
www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_

_View Don's farm website: www.myersfarm.com http://www.myersfarm.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: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Tom Davies]

Hi :)
Thanks Don.  I think you might be able to convert/export/migrate your back-end 
to a different one.  I don't think you have to stick with HSql.  I'm not sure 
if it's possible to remove java dependence when using HSql, i thought it was 
but i could be wrong.
Regards from
Tom :)


--- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote:

From: Don Myers donmy...@myersfarm.com
Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 23:13

Hi All,

I set up base shortly after it was added to Open Office. Apparently I am 
using the embedded database - HSQL database engine. If I turn off Java 
(I just tried it.), I get the following error message:
The connection to the data source RE Database could not be 
established. No SDBC driver was found for the given URL.

I cannot open my database without Java enabled. So using the database 
included with base will not work without Java.

Don

On 09/17/2011 08:29 AM, Tom Davies wrote:
 Hi :)
 I think you can completely un-install all instances of java but i think that 
 might create problems.  Your web-browser might not be very happy without 
 java.  Generally i try to keep escape routes and back-up plans available = so 
 i would just switch off java in LO so that i could switch it on again quite 
 easily if i needed it.

 Tools - Options - LibreOffice/General - Java
 then UNtick the box at the very top Use a java runtime environment.  I have 
 only unticked this a few days ago and LO seems to start-up a lot faster.
 Regards from
 Tom :)

 --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at  wrote:

 From: Heinrich Stoellingerhc.stoellin...@aon.at
 Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
 To: users@global.libreoffice.orgusers@global.libreoffice.org
 Date: Saturday, 17 September, 2011, 11:55

 Hello again,
 Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
 to MySQL on Linux (and a very well working native MySQL-connection under
 Windows). Like I posted in another message, ODBC also has problems (such
 as not showing default values for columns correctly on data entry, but -
 since the database is actually updated correctly - this doesn't really
 worry me much.
 So, like Tom suggests: can I get completely rid of Java if I don't
 conciously use it in any way that an end-user or programmer could cause?
 That would be more than alright for me...
 Regards
 H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
 P.S.: I have used the Java-connector in the past but don't do so anymore.


 --- Forwarded message ---
 From: Andreas Sägerville...@t-online.de
 To: users@global.libreoffice.org
 Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
 Date: Sat, 17 Sep 2011 11:35:28 +0200

 Since you are not running MySQL through ODBC you can turn off all Java
 support for the entire office suite and simply work with the raw
 database connectivity and input forms.
 All the Java wizards are close to useless anyway. You don't need them
 and get much better results faster if you know what you're doing.



 Am 16.09.2011 20:44, Heinrich Stoellinger wrote:
 Hello again,
 On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
 connetcion
 to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
 then save
 LO-Base, CPU-usage is normal again (for a while!). I don't really know
 what causes
 this behaviour, could it have to to with backup copy creation? I find an
 aweful
 lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
 All of them have a filename something like rmodbc.odb_9777.odb and are
 of 0 (zero)
 size. I wonder what's wrong.
 Regards
 H. Stoellinger


 --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

 --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



-- 

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Phone: 814-237-6543 Fax: 814-237-6502
Visit the Farm and Rural Property Division Website at 
www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_
_View Don's farm website: www.myersfarm.com http://www.myersfarm.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

Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Don Myers]

Hi Tom,

There is an old saying - if it ain't broke, don't fix it. The thing I 
dislike most about Base is to have to open three windows to get to my 
form in the database. Some time ago I left a post on an Open Office 
forum asking if there was a way to set up a macro so I could do it in 
one click. There were never any replies. With Paradox or Access I was 
able to go to the form by just opening the program. But what I really 
like about Base is I just have 1 file to copy to keep my database 
updated on my three other computers. When I say if it ain't broken, 
don't fix it, I've never had one issue using Base. It has worked very 
well for me over a long period (7 or 8 years) of time. There are few 
programs I've ever used that have had that kind of dependability.


Don

On 09/17/2011 06:30 PM, Tom Davies wrote:

Hi :)
Thanks Don.  I think you might be able to convert/export/migrate your back-end 
to a different one.  I don't think you have to stick with HSql.  I'm not sure 
if it's possible to remove java dependence when using HSql, i thought it was 
but i could be wrong.
Regards from
Tom :)


--- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com  wrote:

From: Don Myersdonmy...@myersfarm.com
Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 23:13

Hi All,

I set up base shortly after it was added to Open Office. Apparently I am
using the embedded database - HSQL database engine. If I turn off Java
(I just tried it.), I get the following error message:
The connection to the data source RE Database could not be
established. No SDBC driver was found for the given URL.

I cannot open my database without Java enabled. So using the database
included with base will not work without Java.

Don

On 09/17/2011 08:29 AM, Tom Davies wrote:

Hi :)
I think you can completely un-install all instances of java but i think that 
might create problems.  Your web-browser might not be very happy without java.  
Generally i try to keep escape routes and back-up plans available = so i would 
just switch off java in LO so that i could switch it on again quite easily if i 
needed it.

Tools - Options - LibreOffice/General - Java
then UNtick the box at the very top Use a java runtime environment.  I have 
only unticked this a few days ago and LO seems to start-up a lot faster.
Regards from
Tom :)

--- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at   wrote:

From: Heinrich Stoellingerhc.stoellin...@aon.at
Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.orgusers@global.libreoffice.org
Date: Saturday, 17 September, 2011, 11:55

Hello again,
Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
to MySQL on Linux (and a very well working native MySQL-connection under
Windows). Like I posted in another message, ODBC also has problems (such
as not showing default values for columns correctly on data entry, but -
since the database is actually updated correctly - this doesn't really
worry me much.
So, like Tom suggests: can I get completely rid of Java if I don't
conciously use it in any way that an end-user or programmer could cause?
That would be more than alright for me...
Regards
H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
P.S.: I have used the Java-connector in the past but don't do so anymore.


--- Forwarded message ---
From: Andreas Sägerville...@t-online.de
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
Date: Sat, 17 Sep 2011 11:35:28 +0200

Since you are not running MySQL through ODBC you can turn off all Java
support for the entire office suite and simply work with the raw
database connectivity and input forms.
All the Java wizards are close to useless anyway. You don't need them
and get much better results faster if you know what you're doing.



Am 16.09.2011 20:44, Heinrich Stoellinger wrote:

Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
then save
LO-Base, CPU-usage is normal again (for a while!). I don't really know
what causes
this behaviour, could it have to to with backup copy creation? I find an
aweful
lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
All of them have a filename something like rmodbc.odb_9777.odb and are
of 0 (zero)
size. I wonder what's wrong.
Regards
H. Stoellinger


--Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--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: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Tom Davies]

Hi :)
If the different machines are on a Lan then it might be possible to share the 
back-end and then any change from any of the 3 machines would be on the other 
machines too?
Regards from
Tom :)

--- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote:

From: Don Myers donmy...@myersfarm.com
Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 23:44

Hi Tom,

There is an old saying - if it ain't broke, don't fix it. The thing I 
dislike most about Base is to have to open three windows to get to my 
form in the database. Some time ago I left a post on an Open Office 
forum asking if there was a way to set up a macro so I could do it in 
one click. There were never any replies. With Paradox or Access I was 
able to go to the form by just opening the program. But what I really 
like about Base is I just have 1 file to copy to keep my database 
updated on my three other computers. When I say if it ain't broken, 
don't fix it, I've never had one issue using Base. It has worked very 
well for me over a long period (7 or 8 years) of time. There are few 
programs I've ever used that have had that kind of dependability.

Don

On 09/17/2011 06:30 PM, Tom Davies wrote:
 Hi :)
 Thanks Don.  I think you might be able to convert/export/migrate your 
 back-end to a different one.  I don't think you have to stick with HSql.  I'm 
 not sure if it's possible to remove java dependence when using HSql, i 
 thought it was but i could be wrong.
 Regards from
 Tom :)


 --- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com  wrote:

 From: Don Myersdonmy...@myersfarm.com
 Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
 To: users@global.libreoffice.org
 Date: Saturday, 17 September, 2011, 23:13

 Hi All,

 I set up base shortly after it was added to Open Office. Apparently I am
 using the embedded database - HSQL database engine. If I turn off Java
 (I just tried it.), I get the following error message:
 The connection to the data source RE Database could not be
 established. No SDBC driver was found for the given URL.

 I cannot open my database without Java enabled. So using the database
 included with base will not work without Java.

 Don

 On 09/17/2011 08:29 AM, Tom Davies wrote:
 Hi :)
 I think you can completely un-install all instances of java but i think that 
 might create problems.  Your web-browser might not be very happy without 
 java.  Generally i try to keep escape routes and back-up plans available = 
 so i would just switch off java in LO so that i could switch it on again 
 quite easily if i needed it.

 Tools - Options - LibreOffice/General - Java
 then UNtick the box at the very top Use a java runtime environment.  I 
 have only unticked this a few days ago and LO seems to start-up a lot faster.
 Regards from
 Tom :)

 --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at   wrote:

 From: Heinrich Stoellingerhc.stoellin...@aon.at
 Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
 To: users@global.libreoffice.orgusers@global.libreoffice.org
 Date: Saturday, 17 September, 2011, 11:55

 Hello again,
 Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
 to MySQL on Linux (and a very well working native MySQL-connection under
 Windows). Like I posted in another message, ODBC also has problems (such
 as not showing default values for columns correctly on data entry, but -
 since the database is actually updated correctly - this doesn't really
 worry me much.
 So, like Tom suggests: can I get completely rid of Java if I don't
 conciously use it in any way that an end-user or programmer could cause?
 That would be more than alright for me...
 Regards
 H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
 P.S.: I have used the Java-connector in the past but don't do so anymore.


 --- Forwarded message ---
 From: Andreas Sägerville...@t-online.de
 To: users@global.libreoffice.org
 Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
 Date: Sat, 17 Sep 2011 11:35:28 +0200

 Since you are not running MySQL through ODBC you can turn off all Java
 support for the entire office suite and simply work with the raw
 database connectivity and input forms.
 All the Java wizards are close to useless anyway. You don't need them
 and get much better results faster if you know what you're doing.



 Am 16.09.2011 20:44, Heinrich Stoellinger wrote:
 Hello again,
 On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
 connetcion
 to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
 then save
 LO-Base, CPU-usage is normal again (for a while!). I don't really know
 what causes
 this behaviour, could it have to to with backup copy creation? I find an
 aweful
 lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
 All of them have a filename something like rmodbc.odb_9777.odb and are
 of 0

Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[Don Myers]

Thank you Tom,

Only one of them is on the same network. That is basically a backup 
computer. The other two are at a different location and are not 
networked with the first two.


Don

On 09/17/2011 06:58 PM, Tom Davies wrote:

Hi :)
If the different machines are on a Lan then it might be possible to share the 
back-end and then any change from any of the 3 machines would be on the other 
machines too?
Regards from
Tom :)

--- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com  wrote:

From: Don Myersdonmy...@myersfarm.com
Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 23:44

Hi Tom,

There is an old saying - if it ain't broke, don't fix it. The thing I
dislike most about Base is to have to open three windows to get to my
form in the database. Some time ago I left a post on an Open Office
forum asking if there was a way to set up a macro so I could do it in
one click. There were never any replies. With Paradox or Access I was
able to go to the form by just opening the program. But what I really
like about Base is I just have 1 file to copy to keep my database
updated on my three other computers. When I say if it ain't broken,
don't fix it, I've never had one issue using Base. It has worked very
well for me over a long period (7 or 8 years) of time. There are few
programs I've ever used that have had that kind of dependability.

Don

On 09/17/2011 06:30 PM, Tom Davies wrote:

Hi :)
Thanks Don.  I think you might be able to convert/export/migrate your back-end 
to a different one.  I don't think you have to stick with HSql.  I'm not sure 
if it's possible to remove java dependence when using HSql, i thought it was 
but i could be wrong.
Regards from
Tom :)


--- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com   wrote:

From: Don Myersdonmy...@myersfarm.com
Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 23:13

Hi All,

I set up base shortly after it was added to Open Office. Apparently I am
using the embedded database - HSQL database engine. If I turn off Java
(I just tried it.), I get the following error message:
The connection to the data source RE Database could not be
established. No SDBC driver was found for the given URL.

I cannot open my database without Java enabled. So using the database
included with base will not work without Java.

Don

On 09/17/2011 08:29 AM, Tom Davies wrote:

Hi :)
I think you can completely un-install all instances of java but i think that 
might create problems.  Your web-browser might not be very happy without java.  
Generally i try to keep escape routes and back-up plans available = so i would 
just switch off java in LO so that i could switch it on again quite easily if i 
needed it.

Tools - Options - LibreOffice/General - Java
then UNtick the box at the very top Use a java runtime environment.  I have 
only unticked this a few days ago and LO seems to start-up a lot faster.
Regards from
Tom :)

--- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.atwrote:

From: Heinrich Stoellingerhc.stoellin...@aon.at
Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.orgusers@global.libreoffice.org
Date: Saturday, 17 September, 2011, 11:55

Hello again,
Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
to MySQL on Linux (and a very well working native MySQL-connection under
Windows). Like I posted in another message, ODBC also has problems (such
as not showing default values for columns correctly on data entry, but -
since the database is actually updated correctly - this doesn't really
worry me much.
So, like Tom suggests: can I get completely rid of Java if I don't
conciously use it in any way that an end-user or programmer could cause?
That would be more than alright for me...
Regards
H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
P.S.: I have used the Java-connector in the past but don't do so anymore.


--- Forwarded message ---
From: Andreas Sägerville...@t-online.de
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
Date: Sat, 17 Sep 2011 11:35:28 +0200

Since you are not running MySQL through ODBC you can turn off all Java
support for the entire office suite and simply work with the raw
database connectivity and input forms.
All the Java wizards are close to useless anyway. You don't need them
and get much better results faster if you know what you're doing.



Am 16.09.2011 20:44, Heinrich Stoellinger wrote:

Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
then save
LO-Base, CPU-usage is normal again (for a while!). I don't really know
what causes
this behaviour, could it have to to with backup copy creation? I find

Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage

[planas]

Hi,
On Sat, 2011-09-17 at 23:30 +0100, Tom Davies wrote: 

 Hi :)
 Thanks Don.  I think you might be able to convert/export/migrate your 
 back-end to a different one.  I don't think you have to stick with HSql.  I'm 
 not sure if it's possible to remove java dependence when using HSql, i 
 thought it was but i could be wrong.
 Regards from
 Tom :)
 
 
 --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote:
 
 From: Don Myers donmy...@myersfarm.com
 Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
 To: users@global.libreoffice.org
 Date: Saturday, 17 September, 2011, 23:13
 
 Hi All,
 
 I set up base shortly after it was added to Open Office. Apparently I am 
 using the embedded database - HSQL database engine. If I turn off Java 
 (I just tried it.), I get the following error message:
 The connection to the data source RE Database could not be 
 established. No SDBC driver was found for the given URL.
 
 I cannot open my database without Java enabled. So using the database 
 included with base will not work without Java.
 
 Don

snip

The HSQL engine is Java based. It may be possible to use Base as a
front-end for something like MySQL or PostgreSQL, which do not use Java.


 On 09/17/2011 08:29 AM, Tom Davies wrote:
  Hi :)
  I think you can completely un-install all instances of java but i think 
  that might create problems.  Your web-browser might not be very happy 
  without java.  Generally i try to keep escape routes and back-up plans 
  available = so i would just switch off java in LO so that i could switch it 
  on again quite easily if i needed it.
 
  Tools - Options - LibreOffice/General - Java
  then UNtick the box at the very top Use a java runtime environment.  I 
  have only unticked this a few days ago and LO seems to start-up a lot 
  faster.
  Regards from
  Tom :)
 
  --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at  wrote:
 
  From: Heinrich Stoellingerhc.stoellin...@aon.at
  Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
  To: users@global.libreoffice.orgusers@global.libreoffice.org
  Date: Saturday, 17 September, 2011, 11:55
 
  Hello again,
  Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
  to MySQL on Linux (and a very well working native MySQL-connection under
  Windows). Like I posted in another message, ODBC also has problems (such
  as not showing default values for columns correctly on data entry, but -
  since the database is actually updated correctly - this doesn't really
  worry me much.
  So, like Tom suggests: can I get completely rid of Java if I don't
  conciously use it in any way that an end-user or programmer could cause?
  That would be more than alright for me...
  Regards
  H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
  P.S.: I have used the Java-connector in the past but don't do so anymore.
 
 
  --- Forwarded message ---
  From: Andreas Sägerville...@t-online.de
  To: users@global.libreoffice.org
  Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage
  Date: Sat, 17 Sep 2011 11:35:28 +0200
 
  Since you are not running MySQL through ODBC you can turn off all Java
  support for the entire office suite and simply work with the raw
  database connectivity and input forms.
  All the Java wizards are close to useless anyway. You don't need them
  and get much better results faster if you know what you're doing.
 
 
 
  Am 16.09.2011 20:44, Heinrich Stoellinger wrote:
  Hello again,
  On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
  connetcion
  to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I
  then save
  LO-Base, CPU-usage is normal again (for a while!). I don't really know
  what causes
  this behaviour, could it have to to with backup copy creation? I find an
  aweful
  lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
  All of them have a filename something like rmodbc.odb_9777.odb and are
  of 0 (zero)
  size. I wonder what's wrong.
  Regards
  H. Stoellinger
 
 
  --Erstellt mit Operas revolutionärem E-Mail-Modul: 
  http://www.opera.com/mail/
 
  --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
 
 
 
 -- 
 
 *~~*
 Don C. Myers
 e-PRO Certified by the National Association of Realtors
 Manager, Farm and Rural Property Division
 *Coldwell Banker University Realty
 *126 East Foster Avenue, State College, PA 16801
 Phone: 814-237-6543 Fax: 814-237-6502
 Visit the Farm and Rural Property Division Website at 
 www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_
 _View

[libreoffice-users] Re: LibreOffice-Base CPU usage

[NoOp]

On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote:
 Hello again,
 On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC 
 connetcion
 to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then 
 save
 LO-Base, CPU-usage is normal again (for a while!). I don't really know what 
 causes
 this behaviour, could it have to to with backup copy creation? I find an 
 aweful
 lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
 All of them have a filename something like rmodbc.odb_9777.odb and are of 0 
 (zero)
 size. I wonder what's wrong.
 Regards
 H. Stoellinger
 

And what happens if you turn off auto backup?



-- 
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: LibreOffice-Base CPU usage

[Don Myers]

On 09/16/2011 08:31 PM, NoOp wrote:

On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote:

Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC 
connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then 
save
LO-Base, CPU-usage is normal again (for a while!). I don't really know what 
causes
this behaviour, could it have to to with backup copy creation? I find an aweful
lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
All of them have a filename something like rmodbc.odb_9777.odb and are of 0 
(zero)
size. I wonder what's wrong.
Regards
H. Stoellinger


And what happens if you turn off auto backup?



  

Hi All,

Base worked well for me in Windows since it was created while I was 
running Windows, and for two years in Ubuntu until the Java for Linux 
was updated from 1.6.0_22 to 1.6.0_24 last spring. At that point Base 
became almost unusable. In a database with 2500 records, instead of 
going from the first record to the last record in about 1 second, the 
time became 25 to 30 seconds. When I looked at CPU usage. 1 core would 
be running at 100% during this time. Java 1.6.0_26 then came out, and 
the same problem existed. About 5 weeks ago someone started a thread 
titled something like Base runs unacceptably slowly. One person left a 
post stating that in Linux you can have more than one version of Java 
installed at the same time and left the following instructions:

Overview:

1. Download the JRE archive (approx. 20 mb)
2. Extract in /tmp
3. as root, copy the extracted directory to /usr/lib/jvm
4. set this JRE as the JRE of choice in LO (ToolsOptionsJava)
5. Exit LO  restart

Instructions:

1.Download jre-6u21-linux-i586.bin (for i386) or jre-6u21-linux-x64.bin for
x86_64 from
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jre-6u21-b07-oth-JPR
JRE archive at ORACLE . Save to /tmp . Open Terminal and enter cd /tmp. 
Then do the following commands:

2.run it using: sh jre-6u21-linux-i586.bin . The JRE is now extracted to
/tmp/jre1.6.0_21/
3. copy to /usr/lib/jvm sudo cp -a jre1.6.0_21/ /usr/lib/jvm
4. Exit  restart office.  In ToolsOptionsJava, choose 1.6.0_21. Exit 
restart office
5. Load you Base file  compare the speed.

If you want to remove it simply set the JRE back to the old one in
ToolsOptionsJava  sudo rm -rf /usr/lib/jvm/jre1.6.0_21/

This does not replace your current Java install in your browsers, or 
even show up in synaptic package manager. But it does  show up as being 
available for LibreOffice. This solved my problem totally. 1.6.0_21 
works very fast with Base. I haven't worried about security problems 
since the browsers are using the current versions, there isn't any 
plugin installed for 1.6.0_21 for the browsers, and also since it 
doesn't show up in synaptic. Does that mean there are not any risks? I 
don't know, but I would think any risk would be minimal.


The reason I think this might be your problem is because you have the 
same issue with CPU usage that I did.


Don




--

***
*


--
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: LibreOffice-Base CPU usage

[NoOp]

On 09/16/2011 07:03 PM, Don Myers wrote:
 
 
 On 09/16/2011 08:31 PM, NoOp wrote:
 On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote:
 Hello again,
 On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC 
 connetcion
 to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I 
 then save
 LO-Base, CPU-usage is normal again (for a while!). I don't really know what 
 causes
 this behaviour, could it have to to with backup copy creation? I find an 
 aweful
 lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
 All of them have a filename something like rmodbc.odb_9777.odb and are of 
 0 (zero)
 size. I wonder what's wrong.
 Regards
 H. Stoellinger

 And what happens if you turn off auto backup?



   
 Hi All,
 
 Base worked well for me in Windows since it was created while I was 
 running Windows, and for two years in Ubuntu until the Java for Linux 
 was updated from 1.6.0_22 to 1.6.0_24 last spring. At that point Base 
 became almost unusable. In a database with 2500 records, instead of 
 going from the first record to the last record in about 1 second, the 
 time became 25 to 30 seconds. When I looked at CPU usage. 1 core would 
 be running at 100% during this time. Java 1.6.0_26 then came out, and 
 the same problem existed. About 5 weeks ago someone started a thread 
 titled something like Base runs unacceptably slowly. One person left a 
 post stating that in Linux you can have more than one version of Java 
 installed at the same time and left the following instructions:

Please provide a link to your bug reports (for both LO and Java). Thanks.
...


-- 
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: LibreOffice base - cannot make a convenient form to add data

[3flight]

Ok I figured it out - manual setting doesn't do what it is supposed to, so I
should use SQL and write smth like
SELECT Location, ID FROM Locations - this works the way I want it to
if column is listbox. I can also type in to quickly select items. Still
couldn't find how to add a grid object if I delete it and how to use wizard
to set up its columns. Found wizard when clicked on add listbox button on
a panel - but this adds a separate listbox, not a column inside a table. And
if you add a column to a table, there is no wizard.


--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-base-cannot-make-a-convenient-form-to-add-data-tp3227878p3234774.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: LibreOffice base - cannot make a convenient form to add data

[Andreas Säger]

Am 08.08.2011 09:03, 3flight wrote:

But I do it manually (i.e. via form editor - right click on column - change
to listbox, then go open it's options and set it to take values from a
linked table's second field). Can't see where in the Form Creation Wizard
there is an option to change columns to listbox. Which wizard are you
reffering to?



Ignore all those wizards in Base. Most of them are misleading and time 
consuming.
Draw your box or choose ReplaceWithListbox from another control's 
context menu. In the latter case you have to set property Drop Down on 
the general properties tab or you have to drag it taller for a 
multi-line box.

Properties on tab Data can be as simple as this:
Data field: The foreign key to be written (ArticleID or something)
Source type: SQL
Source: SELECT Visible Field, Primary Key FROM Other Table ORDER 
BY Visible Field

Bound Field: 1 (which is the second field, 0 is th index of the visible one)
Source may be also a concatenation like:
SELECT ZIP||' '||City AS Visible Field, Primary Key
FROM Other Table
ORDER BY Visible Field

[Example] Relations reflected by list boxes in forms:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=100t=40444


--
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