RE: RE: Excel steps and mime type
David Jehoul <[email protected]> Thu, 26 Jun 2014 09:50:34 +0200
| Newsgroups | gmane.comp.web.canoo.webtest |
|---|---|
| Message-ID | <36E5382C105BCF4DA127E661672BCF9B061DD40DE7@br4-mail> |
--_000_36E5382C105BCF4DA127E661672BCF9B061DD40DE7br4mail_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Martin, Thanks for the idea! But the mapping in the registry is set to application/= vnd.ms-excel. David From: [email protected] [mailto:[email protected]] = On Behalf Of Martin Huber Sent: donderdag 26 juni 2014 9:45 To: [email protected] Subject: RE: [Webtest] RE: Excel steps and mime type Hi David, just an idea: the information about what file extensions belong to what mime type usually= are somewhere in the OS setup. I could imagine that these also are honoure= d by the jvm. So if you are using Windows you probably will have to check in the Windows = Registry, if there is some mapping from .xls files to application/octet-str= eam instead of to application/vnd.ms-excel . The CI is running on an old Linux system, there the mapping may be differen= t. I don't know what the correct mapping should be, but application/octet-s= tream normally is used for binary files that just should be downloaded w/o = any closer information about its type. Cheers, Martin From: [email protected]<mailto:[email protected]> [= mailto:[email protected]] On Behalf Of David Jehoul Sent: Mittwoch, 25. Juni 2014 09:57 To: [email protected]<mailto:[email protected]>; Habbert, Micha= el (Key-Work) Subject: [Webtest] RE: Excel steps and mime type Hi Michael, Actually, the file is a .gz file that is fetched from the server. Then it i= s locally unzipped to result in a .csv file. After that, the .csv is conver= ted to a .xls with this tool: http://www.softinterface.com/Convert-XLS/Feat= ures/Convert-CSV-To-XLS.htm. However, when I create a simple test and use the testExcel.xls file that is= used in the Webtest self tests, I get the same problem. Here are the resul= ting steps: <step taskName=3D"invoke" result=3D"completed" duration=3D"10" description= =3D"openFile(String) on screen WebPage" _line=3D"439" _filename=3D"c:\testS= cripts\tests\FT853.01-01.xml"><file:///C:\testScripts\testOutput\20140625_0= 93546\001_FT8530101\WebTestReport.xml> <parameter value=3D"file://C:/testScripts/testOutput/testExcel.xls<file:///= C:\testScripts\testOutput\testExcel.xls>" name=3D"url"/> <resultFile name=3D"004_response_invoke.xls"/> </step> <step taskName=3D"excelFindRow" result=3D"failed" duration=3D"1" _line=3D"4= 49" _filename=3D"c:\testScripts\tests\FT853.01-01.xml"><file:///C:\testScri= pts\testOutput\20140625_093546\001_FT8530101\WebTestReport.xml> <parameter value=3D"BR" name=3D"col"/> <parameter value=3D"Rownr" name=3D"property"/> <parameter value=3D"Y" name=3D"text"/> </step> And the result is: c:\testScripts\tests\FT853.01-01.xml:449: File does not have correct conten= t type (not a '.xls' file?): application/octet-stream, Step: ExcelFindRow a= t c:\testScripts\tests\FT853.01-01.xml:449: with (taskName=3D"excelFindRow= ") So I actually don't understand why the selftests were successful whereas on= my system, that a similar test with the same excel file does not work. I really hope you can help me because Canoo is under pressure already becau= se of the inability of html unit to work with the latest JQuery .... Thanks! David From: [email protected]<mailto:[email protected]> [= mailto:[email protected]] On Behalf Of Habbert, Michael (Key-Wo= rk) Sent: woensdag 25 juni 2014 8:19 To: [email protected]<mailto:[email protected]> Subject: [Webtest] AW: Excel steps and mime type Dear David, we do have some tests with excel-Download and analyse ... The content type changed as far as I remember with different excel-versions= . What kind of content type do you get by manual testing with a browser (IE a= nd Firefox)? Greetings Michael Habbert Michael Habbert Key-Work Consulting GmbH | Kriegsstr. 100 | 76133 Karlsruhe | Germany | www= .key-work.de<http://www.key-work.de> Fon: +49-721-78203-269 | E-Mail: [email protected]<mailto:michael= [email protected]> | Fax: +49-721-78203-10 Key-Work Consulting GmbH, Karlsruhe, HRB 108695, HRG Mannheim Gesch=E4ftsf=FChrer: Andreas Stappert, Tobin Wotring Von: [email protected]<mailto:[email protected]> [m= ailto:[email protected]] Im Auftrag von David Jehoul Gesendet: Montag, 23. Juni 2014 14:35 An: [email protected]<mailto:[email protected]>; David Jehoul Betreff: [Webtest] RE: Excel steps and mime type I even tried it with the excel file that I found in the self test report on= the Canoo webtest website. But that gives the same problem. I tried it wit= h several browsers, but ended up with the same problem. I tried with build = 1823 an 1825. Same problem ... From: [email protected]<mailto:[email protected]> [= mailto:[email protected]] On Behalf Of David Jehoul Sent: maandag 23 juni 2014 13:56 To: [email protected]<mailto:[email protected]> Subject: [Webtest] Excel steps and mime type Hi, We want to start to use some excel steps. The first problem I have is that the format of a normal excel file seems to= be not supported. This is the error message I get when I use the excelFindRow task: File does not have correct content type (not a '.xls' file?): application/o= ctet-stream I read here: http://lists.canoo.com/pipermail/webtest/2008q3/010837.html th= at the expected format would be application/vnd.ms-excel, but when I manual= ly create the xls file, I still get the same error message. Does anybody have experience in this matter? Thanks! David --_000_36E5382C105BCF4DA127E661672BCF9B061DD40DE7br4mail_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-= 1"> <html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:m=3D"http://schema= s.microsoft.com/office/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html= 40"><head><meta name=3DGenerator content=3D"Microsoft Word 14 (filtered med= ium)"><style><!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-language:EN-US;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} pre {mso-style-priority:99; mso-style-link:"HTML Preformatted Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-language:EN-US;} p.MsoAcetate, li.MsoAcetate, div.MsoAcetate {mso-style-priority:99; mso-style-link:"Balloon Text Char"; margin:0cm; margin-bottom:.0001pt; font-size:8.0pt; font-family:"Tahoma","sans-serif"; mso-fareast-language:EN-US;} span.HTMLPreformattedChar {mso-style-name:"HTML Preformatted Char"; mso-style-priority:99; mso-style-link:"HTML Preformatted"; font-family:"Courier New"; mso-fareast-language:NL-BE;} span.BalloonTextChar {mso-style-name:"Balloon Text Char"; mso-style-priority:99; mso-style-link:"Balloon Text"; font-family:"Tahoma","sans-serif"; mso-fareast-language:EN-US;} span.HTMLVorformatiertZchn {mso-style-name:"HTML Vorformatiert Zchn"; mso-style-priority:99; mso-style-link:"HTML Vorformatiert"; font-family:Consolas; mso-fareast-language:EN-US;} p.HTMLVorformatiert, li.HTMLVorformatiert, div.HTMLVorformatiert {mso-style-name:"HTML Vorformatiert"; mso-style-link:"HTML Vorformatiert Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-language:EN-US;} span.EmailStyle23 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:windowtext;} span.EmailStyle24 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:#1F497D;} span.EmailStyle25 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:#1F497D;} span.EmailStyle26 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:#1F497D;} span.block {mso-style-name:block;} span.EmailStyle28 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:#1F497D;} span.EmailStyle30 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:612.0pt 792.0pt; margin:70.85pt 70.85pt 70.85pt 70.85pt;} div.WordSection1 {page:WordSection1;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--></head><body lang=3DNL-BE link=3Dblue vli= nk=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span style=3D'c= olor:#1F497D'>Martin,<o:p></o:p></span></p><p class=3DMsoNormal><span style= =3D'color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span l= ang=3DEN-US style=3D'color:#1F497D'>Thanks for the idea! But the mapping in= the registry is set to application/vnd.ms-excel.<o:p></o:p></span></p><p c= lass=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D'><o:p> </o:= p></span></p><p class=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D= '>David<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US style= =3D'color:#1F497D'><o:p> </o:p></span></p><div><div style=3D'border:no= ne;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=3DMso= Normal><b><span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Tahoma"= ,"sans-serif";mso-fareast-language:NL-BE'>From:</span></b><span lang=3DEN-U= S style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-l= anguage:NL-BE'> [email protected] [mailto:[email protected]= anoo.com] <b>On Behalf Of </b>Martin Huber<br><b>Sent:</b> donderdag 26 jun= i 2014 9:45<br><b>To:</b> [email protected]<br><b>Subject:</b> RE: [W= ebtest] RE: Excel steps and mime type<o:p></o:p></span></p></div></div><p c= lass=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal><span lang=3DDE-= CH style=3D'font-size:12.0pt;color:#1F497D'>Hi David,<o:p></o:p></span></p>= <p class=3DMsoNormal><span lang=3DDE-CH style=3D'font-size:12.0pt;color:#1F= 497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span lang=3DDE-CH s= tyle=3D'font-size:12.0pt;color:#1F497D'>just an idea:<o:p></o:p></span></p>= <p class=3DMsoNormal><span lang=3DEN-GB style=3D'font-size:12.0pt;color:#1F= 497D'>the information about what file extensions belong to what mime type u= sually are somewhere in the OS setup. I could imagine that these also are h= onoured by the jvm.<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3D= EN-GB style=3D'font-size:12.0pt;color:#1F497D'>So if you are using Windows = you probably will have to check in the Windows Registry, if there is some m= apping from .xls files to application/octet-stream instead of to applicatio= n/vnd.ms-excel .<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-= GB style=3D'font-size:12.0pt;color:#1F497D'>The CI is running on an old Lin= ux system, there the mapping may be different. I don't know what the correc= t mapping should be, but application/octet-stream normally is used for bina= ry files that just should be downloaded w/o any closer information about it= s type. <o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-GB style= =3D'font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></p><p class=3D= MsoNormal><span lang=3DEN-GB style=3D'font-size:12.0pt;color:#1F497D'>Cheer= s,<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-GB style=3D'fo= nt-size:12.0pt;color:#1F497D'>Martin<o:p></o:p></span></p><p class=3DMsoNor= mal><span lang=3DEN-GB style=3D'font-size:12.0pt;color:#1F497D'><o:p> = </o:p></span></p><p class=3DMsoNormal><a name=3D"_MailEndCompose"></a><span= lang=3DEN-GB style=3D'font-size:12.0pt;color:#1F497D'><o:p> </o:p></s= pan></p><div><div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;paddi= ng:3.0pt 0cm 0cm 0cm'><p class=3DMsoNormal><b><span lang=3DEN-US style=3D'f= ont-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:DE-C= H'>From:</span></b><span lang=3DEN-US style=3D'font-size:10.0pt;font-family= :"Tahoma","sans-serif";mso-fareast-language:DE-CH'> <a href=3D"mailto:webte= [email protected]">[email protected]</a> [<a href=3D"mai= lto:[email protected]">mailto:[email protected]</a>= ] <b>On Behalf Of </b>David Jehoul<br><b>Sent:</b> Mittwoch, 25. Juni 2014 = 09:57<br><b>To:</b> <a href=3D"mailto:[email protected]">webtest@list= s.canoo.com</a>; Habbert, Michael (Key-Work)<br><b>Subject:</b> [Webtest] R= E: Excel steps and mime type<o:p></o:p></span></p></div></div><p class=3DMs= oNormal><span lang=3DDE-CH><o:p> </o:p></span></p><p class=3DMsoNormal= ><span style=3D'color:#1F497D'>Hi Michael,<o:p></o:p></span></p><p class=3D= MsoNormal><span style=3D'color:#1F497D'><o:p> </o:p></span></p><p clas= s=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D'>Actually, the file= is a .gz file that is fetched from the server. Then it is locally unzipped= to result in a .csv file. After that, the .csv is converted to a .xls with= this tool: <a href=3D"http://www.softinterface.com/Convert-XLS/Features/Co= nvert-CSV-To-XLS.htm">http://www.softinterface.com/Convert-XLS/Features/Con= vert-CSV-To-XLS.htm</a>.<o:p></o:p></span></p><p class=3DMsoNormal><span la= ng=3DEN-US style=3D'color:#1F497D'><o:p> </o:p></span></p><p class=3DM= soNormal><span lang=3DEN-US style=3D'color:#1F497D'>However, when I create = a simple test and use the testExcel.xls file that is used in the Webtest se= lf tests, I get the same problem. Here are the resulting steps:<o:p></o:p><= /span></p><p class=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D'><= o:p> </o:p></span></p><p class=3DMsoNormal><a href=3D"file:///C:\testS= cripts\testOutput\20140625_093546\001_FT8530101\WebTestReport.xml"><span la= ng=3DEN-US><</span><span lang=3DEN-US style=3D'color:#990000'>step</span= ><span lang=3DEN-US> </span><span lang=3DEN-US style=3D'color:#990000'>task= Name</span><span lang=3DEN-US>=3D"</span><b><span lang=3DEN-US style= =3D'color:black'>invoke</span></b><span lang=3DEN-US>" </span><span la= ng=3DEN-US style=3D'color:#990000'>result</span><span lang=3DEN-US>=3D"= ;</span><b><span lang=3DEN-US style=3D'color:black'>completed</span></b><sp= an lang=3DEN-US>" </span><span lang=3DEN-US style=3D'color:#990000'>du= ration</span><span lang=3DEN-US>=3D"</span><b><span lang=3DEN-US style= =3D'color:black'>10</span></b><span lang=3DEN-US>" </span><span lang= =3DEN-US style=3D'color:#990000'>description</span><span lang=3DEN-US>=3D&q= uot;</span><b><span lang=3DEN-US style=3D'color:black'>openFile(String) on = screen WebPage</span></b><span lang=3DEN-US>" </span><span lang=3DEN-U= S style=3D'color:#990000'>_line</span><span lang=3DEN-US>=3D"</span><b= ><span lang=3DEN-US style=3D'color:black'>439</span></b><span lang=3DEN-US>= " </span><span lang=3DEN-US style=3D'color:#990000'>_filename</span><s= pan lang=3DEN-US>=3D"</span><b><span lang=3DEN-US style=3D'color:black= '>c:\testScripts\tests\FT853.01-01.xml</span></b><span lang=3DEN-US>"&= gt;</span></a><o:p></o:p></p><p class=3DMsoNormal style=3D'text-indent:35.4= pt'><span lang=3DEN-US><<span style=3D'color:#990000'>parameter</span> <= span style=3D'color:#990000'>value</span>=3D"<b><span style=3D'color:b= lack'><a href=3D"file:///C:\testScripts\testOutput\testExcel.xls">file://C:= /testScripts/testOutput/testExcel.xls</a></span></b>" <span style=3D'c= olor:#990000'>name</span>=3D"<b><span style=3D'color:black'>url</span>= </b>"/><o:p></o:p></span></p><p class=3DMsoNormal style=3D'text-ind= ent:35.4pt'><span lang=3DEN-US><<span style=3D'color:#990000'>resultFile= </span> <span style=3D'color:#990000'>name</span>=3D"<b><span style=3D= 'color:black'>004_response_invoke.xls</span></b>"/><o:p></o:p></spa= n></p><p class=3DMsoNormal><span class=3Dblock><span lang=3DEN-US style=3D'= color:blue'></</span></span><span class=3Dblock><span lang=3DEN-US style= =3D'color:#990000'>step</span></span><span class=3Dblock><span lang=3DEN-US= style=3D'color:blue'>></span></span><span class=3Dblock><span lang=3DDE= -CH style=3D'color:blue'><o:p></o:p></span></span></p><p class=3DMsoNormal>= <a href=3D"file:///C:\testScripts\testOutput\20140625_093546\001_FT8530101\= WebTestReport.xml"><span lang=3DEN-US><</span><span lang=3DEN-US style= =3D'color:#990000'>step</span><span lang=3DEN-US> </span><span lang=3DEN-US= style=3D'color:#990000'>taskName</span><span lang=3DEN-US>=3D"</span>= <b><span lang=3DEN-US style=3D'color:black'>excelFindRow</span></b><span la= ng=3DEN-US>" </span><span lang=3DEN-US style=3D'color:#990000'>result<= /span><span lang=3DEN-US>=3D"</span><b><span lang=3DEN-US style=3D'col= or:black'>failed</span></b><span lang=3DEN-US>" </span><span lang=3DEN= -US style=3D'color:#990000'>duration</span><span lang=3DEN-US>=3D"</sp= an><b><span lang=3DEN-US style=3D'color:black'>1</span></b><span lang=3DEN-= US>" </span><span lang=3DEN-US style=3D'color:#990000'>_line</span><sp= an lang=3DEN-US>=3D"</span><b><span lang=3DEN-US style=3D'color:black'= >449</span></b><span lang=3DEN-US>" </span><span lang=3DEN-US style=3D= 'color:#990000'>_filename</span><span lang=3DEN-US>=3D"</span><b><span= lang=3DEN-US style=3D'color:black'>c:\testScripts\tests\FT853.01-01.xml</s= pan></b><span lang=3DEN-US>"></span></a><o:p></o:p></p><p class=3DM= soNormal style=3D'text-indent:35.4pt'><span lang=3DEN-US><<span style=3D= 'color:#990000'>parameter</span> <span style=3D'color:#990000'>value</span>= =3D"<b><span style=3D'color:black'>BR</span></b>" <span style=3D'= color:#990000'>name</span>=3D"<b><span style=3D'color:black'>col</span= ></b>"/><o:p></o:p></span></p><p class=3DMsoNormal style=3D'text-in= dent:35.4pt'><span lang=3DEN-US><<span style=3D'color:#990000'>parameter= </span> <span style=3D'color:#990000'>value</span>=3D"<b><span style= =3D'color:black'>Rownr</span></b>" <span style=3D'color:#990000'>name<= /span>=3D"<b><span style=3D'color:black'>property</span></b>"/>= ;<o:p></o:p></span></p><p class=3DMsoNormal style=3D'text-indent:35.4pt'><s= pan lang=3DEN-US><<span style=3D'color:#990000'>parameter</span> <span s= tyle=3D'color:#990000'>value</span>=3D"<b><span style=3D'color:black'>= Y</span></b>" <span style=3D'color:#990000'>name</span>=3D"<b><sp= an style=3D'color:black'>text</span></b>"/><o:p></o:p></span></p><p= class=3DMsoNormal><span class=3Dblock><span lang=3DEN-US style=3D'color:bl= ue'></</span></span><span class=3Dblock><span lang=3DEN-US style=3D'colo= r:#990000'>step</span></span><span class=3Dblock><span lang=3DEN-US style= =3D'color:blue'>></span></span><span class=3Dblock><span lang=3DDE-CH st= yle=3D'color:blue'><o:p></o:p></span></span></p><p class=3DMsoNormal><span = style=3D'color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><s= pan lang=3DEN-US style=3D'color:#1F497D'>And the result is:<o:p></o:p></spa= n></p><p class=3DMsoNormal><span lang=3DEN-US style=3D'font-size:10.0pt;fon= t-family:"Courier New";mso-fareast-language:NL-BE'>c:\testScripts\tests\FT8= 53.01-01.xml:449: File does not have correct content type (not a '.xls' fil= e?): application/octet-stream, Step: ExcelFindRow at c:\testScripts\tests\F= T853.01-01.xml:449: with (taskName=3D"excelFindRow")<o:p></= o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US style=3D'font-size:1= 0.0pt;font-family:"Courier New";mso-fareast-language:NL-BE'><o:p> </o:= p></span></p><p class=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D= '>So I actually don’t understand why the selftests were successful wh= ereas on my system, that a similar test with the same excel file does not w= ork.<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US style=3D'= color:#1F497D'>I really hope you can help me because Canoo is under pressur= e already because of the inability of html unit to work with the latest JQu= ery ….<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US s= tyle=3D'color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><sp= an lang=3DEN-US style=3D'color:#1F497D'>Thanks!<o:p></o:p></span></p><p cla= ss=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D'>David<o:p></o:p><= /span></p><div><div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;pad= ding:3.0pt 0cm 0cm 0cm'><p class=3DMsoNormal><b><span lang=3DEN-US style=3D= 'font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:NL= -BE'>From:</span></b><span lang=3DEN-US style=3D'font-size:10.0pt;font-fami= ly:"Tahoma","sans-serif";mso-fareast-language:NL-BE'> <a href=3D"mailto:web= [email protected]">[email protected]</a> [<a href=3D"m= ailto:[email protected]">mailto:[email protected]</= a>] <b>On Behalf Of </b>Habbert, Michael (Key-Work)<br><b>Sent:</b> woensda= g 25 juni 2014 8:19<br><b>To:</b> <a href=3D"mailto:[email protected]= ">[email protected]</a><br><b>Subject:</b> [Webtest] AW: Excel steps = and mime type<o:p></o:p></span></p></div></div><p class=3DMsoNormal><span l= ang=3DEN-US><o:p> </o:p></span></p><p class=3DMsoNormal><span lang=3DD= E style=3D'color:#1F497D'>Dear David,<o:p></o:p></span></p><p class=3DMsoNo= rmal><span lang=3DDE style=3D'color:#1F497D'><o:p> </o:p></span></p><p= class=3DMsoNormal><span lang=3DDE style=3D'color:#1F497D'>we do have some = tests with excel-Download and analyse …<o:p></o:p></span></p><p class= =3DMsoNormal><span lang=3DDE style=3D'color:#1F497D'><o:p> </o:p></spa= n></p><p class=3DMsoNormal><span lang=3DDE style=3D'color:#1F497D'>The cont= ent type changed as far as I remember with different excel-versions.<o:p></= o:p></span></p><p class=3DMsoNormal><span lang=3DDE style=3D'color:#1F497D'= >What kind of content type do you get by manual testing with a browser (IE = and Firefox)?<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DDE sty= le=3D'color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span= lang=3DDE style=3D'color:#1F497D'>Greetings<o:p></o:p></span></p><p class= =3DMsoNormal><span lang=3DDE style=3D'color:#1F497D'><o:p> </o:p></spa= n></p><p class=3DMsoNormal><span lang=3DDE style=3D'color:#1F497D'>Michael = Habbert<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DDE><o:p>&nbs= p;</o:p></span></p><div><div><p class=3DMsoNormal><span lang=3DDE style=3D'= color:navy'> <br> <br><strong><span style=3D'font-family:"Calibri= ","sans-serif"'>Michael Habbert</span></strong> <br>Key-Work Consulting Gmb= H | Kriegsstr. 100 | 76133 Karlsruhe | Germany | <a href=3D"http://www.key-= work.de" target=3D"_blank" title=3D"Key-Work Consulting GmbH">www.key-work.= de</a><br>Fon: +49-721-78203-269 | E-Mail: <a href=3D"mailto:michael.habber= [email protected]">[email protected]</a> | Fax: +49-721-78203-10 <br>= <br>Key-Work Consulting GmbH, Karlsruhe, HRB 108695, HRG Mannheim<br>= Gesch=E4ftsf=FChrer: Andreas Stappert, Tobin Wotring </span><span lang=3DDE= ><o:p></o:p></span></p></div><div style=3D'border:none;border-top:solid #E1= E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=3DMsoNormal><b><span lang=3D= DE style=3D'mso-fareast-language:DE'>Von:</span></b><span lang=3DDE style= =3D'mso-fareast-language:DE'> <a href=3D"mailto:[email protected]= om">[email protected]</a> [<a href=3D"mailto:webtest-admin@list= s.canoo.com">mailto:[email protected]</a>] <b>Im Auftrag von </= b>David Jehoul<br><b>Gesendet:</b> Montag, 23. Juni 2014 14:35<br><b>An:</b= > <a href=3D"mailto:[email protected]">[email protected]</a>; D= avid Jehoul<br><b>Betreff:</b> [Webtest] RE: Excel steps and mime type<o:p>= </o:p></span></p></div></div><p class=3DMsoNormal><span lang=3DDE><o:p>&nbs= p;</o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US style=3D'color:#= 1F497D'>I even tried it with the excel file that I found in the self test r= eport on the Canoo webtest website. But that gives the same problem. I trie= d it with several browsers, but ended up with the same problem. I tried wit= h build 1823 an 1825. Same problem …<o:p></o:p></span></p><p class=3D= MsoNormal><span lang=3DEN-US style=3D'color:#1F497D'><o:p> </o:p></spa= n></p><div><div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding= :3.0pt 0cm 0cm 0cm'><p class=3DMsoNormal><b><span lang=3DEN-US style=3D'fon= t-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:NL-BE'= >From:</span></b><span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"= Tahoma","sans-serif";mso-fareast-language:NL-BE'> <a href=3D"mailto:webtest= [email protected]">[email protected]</a> [<a href=3D"mailt= o:[email protected]">mailto:[email protected]</a>] = <b>On Behalf Of </b>David Jehoul<br><b>Sent:</b> maandag 23 juni 2014 13:56= <br><b>To:</b> <a href=3D"mailto:[email protected]">webtest-33AaDErTWvD/[email protected]= oo.com</a><br><b>Subject:</b> [Webtest] Excel steps and mime type<o:p></o:p= ></span></p></div></div><p class=3DMsoNormal><o:p> </o:p></p><p class= =3DMsoNormal>Hi,<o:p></o:p></p><p class=3DMsoNormal><o:p> </o:p></p><p= class=3DMsoNormal><span lang=3DEN-US>We want to start to use some excel st= eps.<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US>The first= problem I have is that the format of a normal excel file seems to be not s= upported.<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US>This= is the error message I get when I use the excelFindRow task:<o:p></o:p></s= pan></p><p class=3DMsoNormal><span lang=3DEN-US><o:p> </o:p></span></p= ><p class=3DMsoNormal><span lang=3DEN-US>File does not have correct content= type (not a '.xls' file?): application/octet-stream<o:p></o:p></span></p><= p class=3DMsoNormal><span lang=3DEN-US><o:p> </o:p></span></p><pre><sp= an lang=3DEN-US>I read here:</span><span lang=3DEN-US style=3D'font-size:10= .0pt;font-family:"Courier New";mso-fareast-language:NL-BE'> <a href=3D"http= ://lists.canoo.com/pipermail/webtest/2008q3/010837.html">http://lists.canoo= .com/pipermail/webtest/2008q3/010837.html</a> </span><span lang=3DEN-US>tha= t the expected format would be application/vnd.ms-excel, but when I manuall= y create the xls file, I still get the same error message.<o:p></o:p></span= ></pre><pre><span lang=3DEN-US><o:p> </o:p></span></pre><pre><span lan= g=3DEN-US>Does anybody have experience in this matter?<o:p></o:p></span></p= re><pre><span lang=3DEN-US><o:p> </o:p></span></pre><pre><span lang=3D= EN-US>Thanks!<o:p></o:p></span></pre><pre><span lang=3DEN-US>David </span><= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier New";mso-f= areast-language:NL-BE'><o:p></o:p></span></pre><p class=3DMsoNormal><span l= ang=3DEN-US><o:p> </o:p></span></p></div></body></html>= --_000_36E5382C105BCF4DA127E661672BCF9B061DD40DE7br4mail_--