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

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 <
editor@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+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

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