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

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

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

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

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

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

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

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

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

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

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