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

2016-01-30 Thread 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

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

2016-01-26 Thread 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

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

2016-01-26 Thread 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

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-26 Thread 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

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-26 Thread 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

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

2016-01-24 Thread 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

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-21 Thread 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

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

2016-01-21 Thread 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

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

2016-01-21 Thread 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 >

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-20 Thread 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

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-20 Thread 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

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-20 Thread 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

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-20 Thread 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