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 honoured 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-stream instead of to application/vnd.ms-excel . The CI is running on an old Linux system, there the mapping may be different. I don't know what the correct mapping should be, but application/octet-stream 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]] On Behalf Of David Jehoul Sent: Mittwoch, 25. Juni 2014 09:57 To: [email protected]; Habbert, Michael (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 is locally unzipped to result in a .csv file. After that, the .csv is converted to a .xls with this tool: http://www.softinterface.com/Convert-XLS/Features/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 resulting steps: <file:///C:\testScripts\testOutput\20140625_093546\001_FT8530101\WebTestRe port.xml> <step taskName="invoke" result="completed" duration="10" description="openFile(String) on screen WebPage" _line="439" _filename="c:\testScripts\tests\FT853.01-01.xml"> <parameter value="file://C:/testScripts/testOutput/testExcel.xls <file:///C:\testScripts\testOutput\testExcel.xls> " name="url"/> <resultFile name="004_response_invoke.xls"/> </step> <file:///C:\testScripts\testOutput\20140625_093546\001_FT8530101\WebTestRe port.xml> <step taskName="excelFindRow" result="failed" duration="1" _line="449" _filename="c:\testScripts\tests\FT853.01-01.xml"> <parameter value="BR" name="col"/> <parameter value="Rownr" name="property"/> <parameter value="Y" name="text"/> </step> And the result is: c:\testScripts\tests\FT853.01-01.xml:449: File does not have correct content type (not a '.xls' file?): application/octet-stream, Step: ExcelFindRow at c:\testScripts\tests\FT853.01-01.xml:449: with (taskName="excelFindRow") So I actually dont 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 because of the inability of html unit to work with the latest JQuery . Thanks! David From: [email protected] [mailto:[email protected]] On Behalf Of Habbert, Michael (Key-Work) Sent: woensdag 25 juni 2014 8:19 To: [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 and Firefox)? Greetings Michael Habbert Michael Habbert Key-Work Consulting GmbH | Kriegsstr. 100 | 76133 Karlsruhe | Germany | www.key-work.de Fon: +49-721-78203-269 | E-Mail: [email protected] | Fax: +49-721-78203-10 Key-Work Consulting GmbH, Karlsruhe, HRB 108695, HRG Mannheim Geschäftsführer: Andreas Stappert, Tobin Wotring Von: [email protected] [mailto:[email protected]] Im Auftrag von David Jehoul Gesendet: Montag, 23. Juni 2014 14:35 An: [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 with several browsers, but ended up with the same problem. I tried with build 1823 an 1825. Same problem From: [email protected] [mailto:[email protected]] On Behalf Of David Jehoul Sent: maandag 23 juni 2014 13:56 To: [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/octet-stream I read here: http://lists.canoo.com/pipermail/webtest/2008q3/010837.html that the expected format would be application/vnd.ms-excel, but when I manually create the xls file, I still get the same error message. Does anybody have experience in this matter? Thanks! David
