2014年12月30日 星期二

2014年12月17日 星期三

Crawl TMall or Taobao Sales Record

1. Use QTP as crawler
    1.1 grab a specific TABLE tag
    1.2 do necessary pagination then perform 1.1 again
    1.3 export stream as a local text file

2. Have a parser by using C#
    2.1 parser text file
    2.2 create data in staging data in database
    2.3 only import latest records


2014年12月7日 星期日

Request format is unrecognized

[ Issue ]

After .Net web service deployment, the web service returns "System.InvalidOperationException Request format is unrecognized" (System.InvalidOperationException 無法辨認要求格式) whatever browse to [xxx].asmx or [xxx].asmx?wsdl .

[ Solution ]

1. Check IIS protocols in management console
     Make sure HttpSoap, HttpGet, HttpPost are list



2. Investigate web.config in [IIS Root]/web.config, e.q. c:\inetpub\wwwroot\web.config
    Check if there any "<clear />" in system.web->webService->protocols


3. Manual remove "<clear />" from web.config then apply the change