Dohhh again ! ---------- Forwarded message ---------- From: "Tom Davies" <[email protected]> Date: 29 Aug 2017 09:38 Subject: Re: [libreoffice-users] convert xlsx to CSV (and utf8?) To: "A" <[email protected]> Cc:
Hi :) > Sorry about the "One direction" gag. Attempting humour before my 1st > cuppa tea was unwise and I'm not hip enough to keep up with boy-bands > anyway. > > Not all email-clients have a "Reply to List" feature. I think M$ Outlook > doesn't and ones on hand-helds (such as phones, tablets etc). Microsquish > users are likely to be by far the largest percentage of new users that are > unfamiliar with our strangeness. > Regards from > a Tom :) > > On 29 Aug 2017 09:12, "A" <[email protected]> wrote: > > Would it be possible for list users to use "Reply List" and not "Reply > All"? The latter provides two identical messages; one to the list which > is of course copied to me plus another sent to me directly. Thank you for > your consideration. > > > > On 08/29/2017 12:59 AM, Tom Davies wrote: > >> Hi :) >> Prolly best to avoid one direction surely? Anyway didn't they split up >> and >> go different ways? >> Regards from >> Tom :) >> > > I have no idea. The point I'm trying to make is that I investigated one > option. unoconv was not that option. > > > > On 29 Aug 2017 08:43, "A" <[email protected]> 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: [email protected] > 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: [email protected] 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
