Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

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)
    Version information:, latest stable version:
 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
   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.

On Tue, Jan 26, 2016 at 6:42 AM, 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 to
import.Specifically, it offers a Browse option. Locate the Calc file you
wish to browsing to it in your file system.
It also asks for the type of file you wish to import. One of the options
ODF spreadsheet.That's the format of Calc, isn't it ?
No need to convert to CSV File.

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
Either support for it is not implemented or disabled by your

The file is NOT compressed or Zipped and opens perfectly in LO Calc!!

So still a problem - but I appreciate the pointer.

Best regards

Pretoria RSA

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.