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

2016-01-20 Thread Heinrich Stoellinger
Maybe this a really stupid question: but - have you defined the table before trying to upload the csv-file ? The LOAD DATA procedure I mentioned before assumes that a correctly defined table (CREATE TABLE tablename (col1,col2,...)) with the correct data types of your columns exists in the DB.

Re: [libreoffice-users] LibreOffice Base and MySQL

2016-01-20 Thread Jaroslaw Staniek
On Wednesday, 20 January 2016, Ian "Witty" Whitfield < edi...@federalsaints.net> wrote: > 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

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

2016-01-20 Thread Heinrich Stoellinger
Hello, Maybe I don't understand your problem, but... LO lets you store your calc-spreadsheet as a csv-file. I have just tried that out. The format is just fine for then loading into a table as I described earlier. Regards H.S. On Wed, 20 Jan 2016 17:38:12 +0100, Heinrich Stoellinger

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

2016-01-20 Thread Heinrich Stoellinger
Hello again, Ian, FIELDS ENCLOSED BY '"' does of course only apply to character type fields (CHAR, DATE,...), not to numeric values. mysql command client should read mysql command line client... Regards H.S. -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- To

Re: [libreoffice-users] LibreOffice Base and MySQL

2016-01-20 Thread Heinrich Stoellinger
Hello again, Can you use the LOAD DATA command under the mysql command client? You should be able to fire this command also under phpmyadmin. like so... - LOAD DATA INFILE "/directory/.../filename.csv" REPLACE INTO TABLE table1 FIELDS ENCLOSED BY

Re: [libreoffice-users] LibreOffice Base and MySQL

2016-01-20 Thread Paul D. Mirowsky
Hello It doesn't really look like you are importing into Base as much as MySQL. Have you tried this... In phpMyAdmin, click the table, and then click the Import tab at the top of the page. Browse and open the csv file. Leave the charset as-is. Uncheck partial import unless you have a HUGE

Re: [libreoffice-users] LibreOffice Base and MySQL

2016-01-20 Thread Harvey Nimmo
On Wed, 2016-01-20 at 12:05 +0200, Ian Whitfield wrote: > 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

Re: [libreoffice-users] LibreOffice Base and MySQL

2016-01-20 Thread Heinrich Stoellinger
Hello Ian, I am somewhat puzzled by the error message you get: It seems to me that you are defining multiple columns with the name `NULL`. To MY knowledge column names should be unique withing one table. Also NULL is used to specify whether the value of a column may be NULL (i.e. "unknown") or

[libreoffice-users] LibreOffice Base and MySQL

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

[libreoffice-users] LibreOffice Base and MySQL

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