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

On 26 January 2016 at 12:42, Ian "Witty" Whitfield <

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.

​ODF files are compressed archives of XML files (that's why they, like
MSOOXML, are not the best containers for larger data, but this is off
topic)​. I guess you're getting the error because the web server handling
the Admin isn't fully set up. The devil is in the detail...

Hank's suggestion looks good -- apps supporting ODS would be much better
than underspecified CSV, so such
phpMyAdmin's import may work. However there's possible issue that such
tools need to be supplied with _range information_ of data that has to be
imported from ODS.
In absence of such, the only is guessing or heuristics, like we have in
Kexi's ODS->Table importer, by the way. If there are more possible ranges,
manual intervention may be needed, such as moving data to a simpler,
separate sheet, and that would degrade the whole automation. Sure, for
one-time import this isn't a big deal.

I am writing this to note that we sometimes lack specialized but popular
standards for exchanging data or schema.

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

regards, Jaroslaw Staniek

: A world-wide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development -
Calligra Suite:
: A graphic art and office suite -
: A visual database apps builder -
Qt Certified Specialist:

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.