On 26 January 2016 at 12:42, Ian "Witty" Whitfield <edi...@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+unsubscr...@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+unsubscr...@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