Hi :) Prolly best to avoid one direction surely? Anyway didn't they split up and go different ways? Regards from Tom :)
On 29 Aug 2017 08:43, "A" <publicf...@bak.rr.com> wrote: Thank you. I may end up doing that, but I'm trying to avoid it. I picked one direction (before I knew about unoconv) and I want to see it through to the end. It's supposed to work. I may be forced to revisit this solution if all else fails. On 08/28/2017 12:28 PM, Tony Arnold wrote: > Have you looked at the 'unoconv' command? Specifically designed for > conversion of office documents from one format to another. > > (I've come to the thread late, so apologies if this has already been > suggested.) > > Regards, > Tony. > > On Mon, 2017-08-28 at 10:21 -0700, A wrote: > >> Thank you for responding. Yes it opens without issue. >> >> Yet another look at the conversion details made me notice I needed >> changes. Below are two incarnations. For one thing I had left out >> column formatting, which I guess is required? No difference in any >> event. >> >> apb@yellow:/usr/local/src/greetonix/src$ >> /usr/lib/libreoffice/program/soffice.bin >> -env:UserInstallation=file:///tmp/libreoffice-1 --headless -- >> nolockcheck >> --convert-to txt:Text \(encoded\):UTF8 --infilter=MS Excel >> 97:44,34,76,1,1/2/2/2,1033,true,false KGI_Discontinued.xlsx >> Error: source file could not be loaded >> Error: source file could not be loaded >> Error: source file could not be loaded >> convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx -> >> /usr/local/src/greetonix/src/KGI_Discontinued.txt using filter : Text >> Error: Please verify input parameters... (SfxBaseModel::impl_store >> <file:///usr/local/src/greetonix/src/KGI_Discontinued.txt> failed: >> 0xc10) >> >> Also tried: >> >> apb@yellow:/usr/local/src/greetonix/src$ >> /usr/lib/libreoffice/program/soffice.bin >> -env:UserInstallation=file:///tmp/libreoffice_1 --infilter='MS Excel >> 97:44,34,76,1,1/2/2/2,1033,true,false' --headless --nolockcheck >> --convert-to 'csv:Text - txt - csv (StarCalc):44,34,76,1' >> KGI_Discontinued.xlsx >> *Error: source file could not be loaded* >> >> apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx >> -rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx >> >> >> Which is an improvement, but not the solution. All I really did was >> rearrange the order of the parameters, change a hyphen to an >> underscore >> in the tmp file path and change double quotes to single quotes. I >> think >> I recall reading somewhere that order matters so that's what likely >> eliminated the "verify input parameters" message. You may also >> notice I >> changed output from utf8 to csv. I need *both* utf8 & csv. >> >> Maybe I need yet another rearrangement to eliminate the file load >> error? >> >> Thank you! >> >> >> >> On 08/27/2017 06:41 PM, James Knott wrote: >> >>> On 08/27/2017 08:59 PM, A wrote: >>> >>>> I'm trying to convert a file from .xlsx to CSV. After googling >>>> until >>>> my eyes were bleeding, the below is the best I could come up >>>> with. >>>> I've tried various incarnations of the below this is just the >>>> latest. >>>> Any ideas what's wrong here? The input file clearly >>>> exists. ubuntu >>>> 16.04 LibreOffice 5.1.6.2 10m0(Build:2) >>>> >>>> Thank you in advance! >>>> >>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>> >>>> apb@yellow:/usr/local/src/greetonix/src$ >>>> /usr/lib/libreoffice/program/soffice.bin >>>> -env:UserInstallation=file:///tmp/libreoffice-1 --headless >>>> --nolockcheck --convert-to csv:Text \(encoded\):UTF8 -- >>>> infilter=MS >>>> Excel 97:44,34,76,1,,1033,true,true,false,false >>>> KGI_Discontinued.xlsx >>>> Error: source file could not be loaded >>>> Error: source file could not be loaded >>>> Error: source file could not be loaded >>>> convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx -> >>>> /usr/local/src/greetonix/src/KGI_Discontinued.csv using filter : >>>> Text >>>> Error: Please verify input parameters... >>>> (SfxBaseModel::impl_store >>>> <file:///usr/local/src/greetonix/src/KGI_Discontinued.csv> >>>> failed: 0xc10) >>>> apb@yellow:/usr/local/src/greetonix/src$ >>>> >>>> apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx >>>> >>>> -rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx >>>> >>>> apb@yellow:/usr/local/src/greetonix/src$ >>>> >>> What happens if you just open the file in LibreOffice? >>> >>> >>> >>> >>> >> -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns ubscribe/ 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+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
