[opensuse] opensuse paste / how to open such a file correct
Hi, i was trying to use suse paste to ask here a question for a specific file, but i did not managed to upload it. is opensuse paste working? susepaste -e 10080 test.xls Pasted as: http://susepaste.org/22888346 http://paste.opensuse.org/22888346 Link is also in your clipboard. if i use that links, i get a http://susepaste.org/view//22888346 404 page not found. did anybody get this page? whats wrong? i tried also to bz2 this file and upload it, same problem: susepaste -e 10080 test.xls.bz2 Pasted as: http://susepaste.org/58851927 http://paste.opensuse.org/58851927 Link is also in your clipboard. ===== the original question to this file would be: how to open it? it will not be correct opened with libreoffice. if i change the .xls to .html it will be opened in firefox, and shown "partly" correct. "file" will show: test.xls: MIME entity, ISO-8859 text, with CRLF line terminators ================================= the file starts with: MIME-Version: 1.0^M X-Document-Type: Workbook^M Content-Type: multipart/related; boundary="----=_NextPart_01C3B8B1.6DB8B6D0"^M ^M Dieses Dokument wurde f.r die Anzeige in Microsoft Excel 2002 oder h.her formatiert. Sie verwenden eine fr.here Version von Excel.^M ^M ------=_NextPart_01C3B8B1.6DB8B6D0^M Content-Location: file:///C:/CE594991/xls.htm^M Content-Transfer-Encoding: quoted-printable^M Content-Type: text/html; charset="us-ascii"^M ^M <html xmlns:v=3D"urn:schemas-microsoft-com:vml"^M xmlns:o=3D"urn:schemas-microsoft-com:office:office"^M xmlns:x=3D"urn:schemas-microsoft-com:office:excel"^M xmlns=3D"http://www.w3.org/TR/REC-html40">^M ^M <head>^M <meta name=3D"Excel Workbook Frameset">^M <link rel=3DFile-List href=3D"xls_files/filelist.xml">^M <meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-12=^M 52">^M <meta name=3DGenerator content=3D"Microsoft Excel 9">^M <!--[if gte mso 9]><xml>^M <o:DocumentProperties>^M <o:Version>9.3821</o:Version>^M </o:DocumentProperties>^M <o:OfficeDocumentSettings>^M <o:DownloadComponents/>^M <o:LocationOfComponents HRef=3D"file:///\\msowc.cab"/>^M </o:OfficeDocumentSettings>^M </xml><![endif]-->^M <style>^M <!--table^M <------>{mso-displayed-decimal-separator:"\.";^M <------>mso-displayed-thousand-separator:"\,";}^M tr^M <------>{mso-height-source:userset;}^M col^M <------>{mso-width-source:userset;}^M br^M <------>{mso-data-placement:same-cell;}^M .style0^M <------>{mso-number-format:General;^M <------>text-align:general;^M <------>vertical-align:bottom;^M <------>white-space:normal;^M ================================================= simoN -- www.becherer.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Op vrijdag 29 maart 2019 19:38:54 CET schreef Simon Becherer:
Hi,
i was trying to use suse paste to ask here a question for a specific file, but i did not managed to upload it. is opensuse paste working?
susepaste -e 10080 test.xls
Pasted as: http://susepaste.org/22888346 http://paste.opensuse.org/22888346 Link is also in your clipboard.
if i use that links, i get a http://susepaste.org/view//22888346 404 page not found.
did anybody get this page?
whats wrong?
i tried also to bz2 this file and upload it, same problem: susepaste -e 10080 test.xls.bz2 Pasted as: http://susepaste.org/58851927 http://paste.opensuse.org/58851927 Link is also in your clipboard.
===== the original question to this file would be: how to open it? it will not be correct opened with libreoffice. if i change the .xls to .html it will be opened in firefox, and shown "partly" correct.
"file" will show: test.xls: MIME entity, ISO-8859 text, with CRLF line terminators
================================= the file starts with:
MIME-Version: 1.0^M X-Document-Type: Workbook^M Content-Type: multipart/related; boundary="----=_NextPart_01C3B8B1.6DB8B6D0"^M ^M Dieses Dokument wurde f.r die Anzeige in Microsoft Excel 2002 oder h.her formatiert. Sie verwenden eine fr.here Version von Excel.^M ^M ------=_NextPart_01C3B8B1.6DB8B6D0^M Content-Location: file:///C:/CE594991/xls.htm^M Content-Transfer-Encoding: quoted-printable^M Content-Type: text/html; charset="us-ascii"^M ^M <html xmlns:v=3D"urn:schemas-microsoft-com:vml"^M xmlns:o=3D"urn:schemas-microsoft-com:office:office"^M xmlns:x=3D"urn:schemas-microsoft-com:office:excel"^M xmlns=3D"http://www.w3.org/TR/REC-html40">^M ^M <head>^M <meta name=3D"Excel Workbook Frameset">^M <link rel=3DFile-List href=3D"xls_files/filelist.xml">^M <meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-12=^M 52">^M <meta name=3DGenerator content=3D"Microsoft Excel 9">^M <!--[if gte mso 9]><xml>^M <o:DocumentProperties>^M <o:Version>9.3821</o:Version>^M </o:DocumentProperties>^M <o:OfficeDocumentSettings>^M <o:DownloadComponents/>^M <o:LocationOfComponents HRef=3D"file:///\\msowc.cab"/>^M </o:OfficeDocumentSettings>^M </xml><![endif]-->^M <style>^M <!--table^M <------>{mso-displayed-decimal-separator:"\.";^M <------>mso-displayed-thousand-separator:"\,";}^M tr^M <------>{mso-height-source:userset;}^M col^M <------>{mso-width-source:userset;}^M br^M <------>{mso-data-placement:same-cell;}^M .style0^M <------>{mso-number-format:General;^M <------>text-align:general;^M <------>vertical-align:bottom;^M <------>white-space:normal;^M
=================================================
simoN Paste is for plain text files ....
-- Gertjan Lettink a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 29/03/2019 19.38, Simon Becherer wrote:
Hi,
i was trying to use suse paste to ask here a question for a specific file, but i did not managed to upload it. is opensuse paste working?
susepaste -e 10080 test.xls
I use more options. -n NICK nickname of the author of the paste -t TITLE name of the paste cer@Telcontar:~> susepaste -n "Carlos E.R." -t "Test" -e 10080 p.jpg Pasted as: http://susepaste.org/56727441 http://paste.opensuse.org/56727441 Link is also in your clipboard. cer@Telcontar:~> And it worked. Perhaps it doesn't like your file.
===== the original question to this file would be: how to open it?
I don't know.
it will not be correct opened with libreoffice. if i change the .xls to .html it will be opened in firefox, and shown "partly" correct.
"file" will show: test.xls: MIME entity, ISO-8859 text, with CRLF line terminators
It has windows carriage returns. It seems an email. -- Cheers / Saludos, Carlos E. R. (from 15.0 x86_64 at Telcontar)
http://paste.opensuse.org/view//76635089 Am 29.03.19 um 19:55 schrieb Carlos E. R.:
It has windows carriage returns. It seems an email.
yes, i get this files per mail. simoN -- www.becherer.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Hi, i used now the web-interface, there i was copying the contend of the file in. http://paste.opensuse.org/view//76635089 now its there. still the questions: a) why did my susepaste command not work. and b) what file is this, how to open it correct (linux only), because i have a customer who always send me such files and is not able to change format. simoN -- www.becherer.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 29/03/2019 19.56, Simon Becherer wrote:
Hi,
i used now the web-interface, there i was copying the contend of the file in.
Instead, "browse" to the file - but I only see "browse" when the file is an image. Weird.
http://paste.opensuse.org/view//76635089
now its there.
Yes, but with new line breaks.
still the questions:
a) why did my susepaste command not work.
I do not know, but I think it does not recognize the format.
and b) what file is this, how to open it correct (linux only), because i have a customer who always send me such files and is not able to change format.
I think his mail program altered it. The file was generated by "Microsoft Excel 9", but it has been saved as email, not as an attached file. You need to extract the file first from the email. (!). Maybe the correct extension is ".eml". I would suggest your correspondent to first zip the excel file, then attach the zip instead. If mail programs think this is text, they can alter it. For instance, text attachments in email, like this one: Content-Type: text/html; charset="us-ascii" can change the line end marking and charset when going from windows to Linux or reverse. This is perfectly legal per the RFCS! -- Cheers / Saludos, Carlos E. R. (from 15.0 x86_64 at Telcontar)
Am 29.03.19 um 20:25 schrieb Carlos E. R.:
I think his mail program altered it. The file was generated by "Microsoft Excel 9", but it has been saved as email, not as an attached
maybe, but the sender is not able to change anything...... :-(((((((
file. You need to extract the file first from the email. (!). Maybe the correct extension is ".eml". i do not think, if i change to .eml and try to open with thunderbrid, i get a empty window.
I would suggest your correspondent to first zip the excel file, then attach the zip instead. If mail programs think this is text, they can alter it. For instance, text attachments in email, like this one:
Content-Type: text/html; charset="us-ascii"
as i said above, sender is not able to change.
can change the line end marking and charset when going from windows to Linux or reverse. This is perfectly legal per the RFCS!
sorry this i do not understand, but i do not think charset and or linemarkings are my problem. simoN -- www.becherer.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 29/03/2019 20.32, Simon Becherer wrote:
Am 29.03.19 um 20:25 schrieb Carlos E. R.:
I think his mail program altered it. The file was generated by "Microsoft Excel 9", but it has been saved as email, not as an attached
maybe, but the sender is not able to change anything...... :-(((((((
file. You need to extract the file first from the email. (!). Maybe the correct extension is ".eml". i do not think, if i change to .eml and try to open with thunderbrid, i get a empty window.
I would suggest your correspondent to first zip the excel file, then attach the zip instead. If mail programs think this is text, they can alter it. For instance, text attachments in email, like this one:
Content-Type: text/html; charset="us-ascii"
as i said above, sender is not able to change.
can change the line end marking and charset when going from windows to Linux or reverse. This is perfectly legal per the RFCS!
sorry this i do not understand, but i do not think charset and or linemarkings are my problem.
I can not say it is for certain, depends on the sending and receiving apps. But it is true, both can alter the files that are declared as "text" in transit. It has happened to me, and then the only solution is to zip the file prior to sending it by email so that it is treated as binary. Try to email the file directly to me, not to the list, but zip it first. Then I can have a go at it with an idea I have. I'm not sure, but I can try. -- Cheers / Saludos, Carlos E. R. (from 15.0 x86_64 at Telcontar)
Am 29.03.19 um 20:39 schrieb Carlos E. R.:
Try to email the file directly to me, not to the list, but zip it first. Then I can have a go at it with an idea I have. I'm not sure, but I can try.
have mailed direct. simoN -- www.becherer.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 29/03/2019 20.54, Simon Becherer wrote:
Am 29.03.19 um 20:39 schrieb Carlos E. R.:
Try to email the file directly to me, not to the list, but zip it first. Then I can have a go at it with an idea I have. I'm not sure, but I can try.
have mailed direct.
Seen it. Yes, the trick is to remove "mail parts". It starts like this: MIME-Version: 1.0^M X-Document-Type: Workbook^M Content-Type: multipart/related; boundary="----=_NextPart_01C3B8B1.6DB8B6D0"^M ^M Dieses Dokument wurde f.r die Anzeige in Microsoft Excel 2002 oder h.her formatiert. Sie verwenden eine fr.here Version von Excel.^M ^M ------=_NextPart_01C3B8B1.6DB8B6D0^M Content-Location: file:///C:/CE594991/xls.htm^M Content-Transfer-Encoding: quoted-printable^M Content-Type: text/html; charset="us-ascii"^M ^M <html xmlns:v=3D"urn:schemas-microsoft-com:vml"^M The new file has to start at the last line above, ie: <html xmlns:v=3D"urn:schemas-microsoft-com:vml"^M and it has to end just before the "next part". The probably correct name is given there, "xls.htm". I just used "one.xls" and libre office accepted to open it, but it is empty. The second file I do the same, and this time LO populates. It is a table, but I don't know if it is correct. There is another file below, declared as style sheet, and another as filelist: Content-Location: file:///C:/CE594991/xls_files/filelist.xml^M Content-Transfer-Encoding: quoted-printable^M Content-Type: text/xml; charset="us-ascii"^M ^M <xml xmlns:o=3D"urn:schemas-microsoft-com:office:office">^M <o:MainFile HRef=3D"../xls.htm"/>^M <o:File HRef=3D"stylesheet.css"/>^M <o:File HRef=3D"sheet001.htm"/>^M <o:File HRef=3D"filelist.xml"/>^M </xml>^M So, maybe sheet001.htm is the sheet and stylesheet.css the formatting. Possibly in Windows and with the correct mail program that would be assembled into the correct excel sheet. I'd guess that your correspondent is using some functionality in excel to "send via email" which only works correctly with Outlook or Exchange. Terrible. -- Cheers / Saludos, Carlos E. R. (from 15.0 x86_64 at Telcontar)
Hello, On Fri, 29 Mar 2019, Carlos E. R. wrote:
On 29/03/2019 20.54, Simon Becherer wrote:
Am 29.03.19 um 20:39 schrieb Carlos E. R.:
Try to email the file directly to me, not to the list, but zip it first. Then I can have a go at it with an idea I have. I'm not sure, but I can try. have mailed direct.
Seen it. Yes, the trick is to remove "mail parts".
No need to! Just run: $ metamail -y -w foo.mail on the saved mail. HTH, -dnh -- Linux only became possible because 20 years of OS research was carefully studied, analyzed, discussed and thrown away. Ingo Molnar on linux-kernel -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Hi david, Am 30.03.19 um 01:07 schrieb David Haller:
Hello,
On Fri, 29 Mar 2019, Carlos E. R. wrote:
On 29/03/2019 20.54, Simon Becherer wrote:
Am 29.03.19 um 20:39 schrieb Carlos E. R.:
Try to email the file directly to me, not to the list, but zip it first. Then I can have a go at it with an idea I have. I'm not sure, but I can try. have mailed direct.
Seen it. Yes, the trick is to remove "mail parts".
No need to!
Just run:
$ metamail -y -w foo.mail
on the saved mail.
HTH, -dnh
metamail -y -w test.xls metamail: Could not extract a MIME message from the body :-(( simoN -- www.becherer.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Hello, On Mon, 01 Apr 2019, Simon Becherer wrote:
Am 30.03.19 um 01:07 schrieb David Haller:
On Fri, 29 Mar 2019, Carlos E. R. wrote:
On 29/03/2019 20.54, Simon Becherer wrote:
Am 29.03.19 um 20:39 schrieb Carlos E. R.:
Try to email the file directly to me, not to the list, but zip it first. Then I can have a go at it with an idea I have. I'm not sure, but I can try. have mailed direct.
Seen it. Yes, the trick is to remove "mail parts".
No need to!
Just run:
$ metamail -y -w foo.mail
on the saved mail.
metamail -y -w test.xls ^^^^ metamail: Could not extract a MIME message from the body
Had you already removed the Mail-Headers? metamail needs those, i.e. the stuff with "MIME-Version: 1.0" etc. Just save the _complete_ mail to a file and try again ;) -dnh --
From a syslog: ISAKMP (0:16): deleting SA reason "He's expired! He's lost his perch! He's an ex-parrot!" state (R) QM_IDLE
-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Am 29.03.19 um 21:11 schrieb Carlos E. R.:
I'd guess that your correspondent is using some functionality in excel to "send via email" which only works correctly with Outlook or Exchange. Terrible.
hi carlos, thanks, yes, i will write some shell script to extract that. (2.xls you send me back) did you remember how to change encoding in shellscript? i have done this before but i do not remember at the moment.... .. and i don't remember where the script is.. :-((( getting old... simoN -- www.becherer.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Am 30.03.19 um 08:05 schrieb Simon Becherer:
Am 29.03.19 um 21:11 schrieb Carlos E. R.:
I'd guess that your correspondent is using some functionality in excel to "send via email" which only works correctly with Outlook or Exchange. Terrible.
hi carlos, thanks, yes, i will write some shell script to extract that. (2.xls you send me back) did you remember how to change encoding in shellscript? i have done this before but i do not remember at the moment.... .. and i don't remember where the script is.. :-((( getting old...
ah, its back in the brain ;-)) iconv .... simoN -- www.becherer.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 30/03/2019 08.21, Simon Becherer wrote:
Am 30.03.19 um 08:05 schrieb Simon Becherer:
Am 29.03.19 um 21:11 schrieb Carlos E. R.:
I'd guess that your correspondent is using some functionality in excel to "send via email" which only works correctly with Outlook or Exchange. Terrible.
hi carlos, thanks, yes, i will write some shell script to extract that. (2.xls you send me back)
Yes, and a third one I omitted, the stylesheet.
did you remember how to change encoding in shellscript? i have done this before but i do not remember at the moment.... .. and i don't remember where the script is.. :-((( getting old...
ah, its back in the brain ;-)) iconv ....
Ah, yes, I was trying to remember. -- Cheers / Saludos, Carlos E. R. (from 15.0 x86_64 at Telcontar)
On 03/29/2019 01:38 PM, Simon Becherer wrote:
Hi,
i was trying to use suse paste to ask here a question for a specific file, but i did not managed to upload it. is opensuse paste working?
susepaste -e 10080 test.xls
susepaste has no clue what an MS Excel file is... -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (5)
-
Carlos E. R. -
David C. Rankin -
David Haller -
Knurpht-openSUSE -
Simon Becherer