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

On 26 January 2016 at 12:42, 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.

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