PDA

View Full Version : Looking for Possible Web Query



stanl
02-13-2006, 02:44 PM
There is a pretty cool new site - www.zillow.com (http://www.zillow.com). A friend wanted me to test out his address in California. The main page, even if a correct address is entered from code cannot be parsed as it contains iFrames and a Flash movie. However, by examining the DIV's, you can extract a number which is more or less the property ID. You can then open a summary page with a url such as:

http://www.zillow.com/HomeDetails.z?zprop=17259379

I can place this info into a PDF (see attached jpeg) as part of the script; but it defies a decent web query. Even though the HTML contains several tables, Excel does not recognize them as distinct. They appear within jscript makers of < fieldset > < /fieldset >.

I would like to get something similar to the PDF in Excel if possible. TIA

Stan

Rembo
02-16-2006, 06:40 AM
Hello Stan,

Why not use the IE document object and print the webpage to a PDF? Or if you just want to retrieve values from a website use the XMLHTTP object. A few coding examples can be found here:

http://scriptorium.serve-it.nl/categories.php?eid=1&cid=14

Rembo

stanl
02-16-2006, 06:54 AM
Hello Stan,

Why not use the IE document object and print the webpage to a PDF? Or if you just want to retrieve values from a website use the XMLHTTP object. A few coding examples can be found here:

http://scriptorium.serve-it.nl/categories.php?eid=1&cid=14

Rembo

I guess my post was not clear and I apologize. I already did that, which is why I posted the image. The problem is that more users are likely to have Excel as opposed to full-blown acrobat [I don't think the reader can load, convert and re-save HTML - but I may be mistaken.] I am using XStandard's .responseasxml property since their control includes Tidy and therefore persists as fully-formed XML - and it allows Firefox to be used as the browser.

Since a web-query can be performed on locally saved html I posed the question as I did.

Stan