Re: [libreoffice-users] LibreOffice Base and MySQL

On Wednesday, 20 January 2016, Ian "Witty" Whitfield <
editor@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 cracked this one!!
>

Hi Ian,
If you send me the file or at least first few rows, I may try it with Kexi
CSV Importer, which imports directly to mysql. In worst case I would send
you a mysql sql dump file as a result.
I'm interested since this helps to develop the best importer on the planet
which is the actual goal ;)
And also to test differences/compatibility with other software such as Base.

> My OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is
running on localhost.
> My CSV file is in Calc and has 2600 rows and 78 cols. I save it as a CSV
file which is 717.8Kb in size. Field Names are in row 1.
> I have tried many times with phpMyAdmin with no luck and today I
installed MySQL Workbench - also no luck.
> In all cases I get the error ...
>
> MySQL said: Documentation
> #1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'varchar(10), `NULL` varchar(10), `NULL` varchar(10), `NULL` varchar(21),
`NULL` ' at line 1
> MyAdmin seems to stop after only 38 fields and the error does not show
the field names in the error. Also it is not MY SQL syntax it is MyAdmin's
syntax!!
> Workbench says - ERROR 1064 (42000) at line 1: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near
'RecordID,Status,StatusGraphic,Title,PrefFirstName,FirstName,LastName,Maiden/Form'
at line 1
> Operation failed with exitcode 1.
>
> Can anyone help me out please. I'm NOT a Database expert just a user and
must get this DB up and running again ASAP!!
> Many, many thanks
>
> IanW
> Pretoria RSA
>
> --
> To unsubscribe e-mail to: users+unsubscribe@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+unsubscribe@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