Re: [libreoffice-users] LibreOffice Base and MySQL

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

I did something similar recently. You might succeed if you change the
CSV options: line separator LF, enclose strings in ", field separator ;

If I remember rightly, it did not cope well with field separator ,

Cheers
Harvey


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