Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Genuinely in two minds about even answering this, as it seems awfully off topic.</p> <p>Simplest way I found was to open the page in chrome, load developer tools, reload the page, and then look for the POST request that requests the data, then you could forge that request with Curl, and then extract the data from the XML file that it returns.</p> <p>Far easier than scraping it from the rendered grid.</p> <pre><code>Request URL:http://sancharsoft.bsnl.co.in/auction/vacant_nos/ch/fancy_nos_load.asp Request Method:POST Status Code:200 OK Request Headersview source Accept:application/xml, text/xml, */*; q=0.01 Accept-Charset:ISO-8859-1,utf-8;q=0.7,*;q=0.3 Accept-Encoding:gzip,deflate,sdch Accept-Language:en-US,en;q=0.8 Cache-Control:no-cache Connection:keep-alive Content-Length:65 Content-Type:application/x-www-form-urlencoded Cookie:ASPSESSIONIDSARRQQBT=EALMIDLAPLDHCEKDHIOKHHFG; PHPSESSID=88mr7i6gqis9u3ece750shjsg4 Host:sancharsoft.bsnl.co.in Origin:http://sancharsoft.bsnl.co.in Pragma:no-cache Referer:http://sancharsoft.bsnl.co.in/auction/vacant_nos/ch/gsm_no_choice.asp User-Agent:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.101 Safari/537.11 X-Requested-With:XMLHttpRequest Form Dataview URL encoded _search:false nd:1357565939966 rows:50 page:1 sidx:gsmno sord:asc Response Headersview source Cache-Control:private Content-Length:4605 Content-Type:text/xml; Charset=utf-8 Date:Mon, 07 Jan 2013 13:38:59 GMT Server:Microsoft-IIS/7.0 X-Powered-By:ASP.NET </code></pre> <p>Returning</p> <pre><code>&lt;?xml version='1.0' encoding='utf-8'?&gt;&lt;rows&gt;&lt;page&gt;1&lt;/page&gt;&lt;total&gt;48&lt;/total&gt;&lt;records&gt;2374&lt;/records&gt;&lt;row id='9444011515'&gt;&lt;cell&gt;&lt;![CDATA[9444011515]]&gt;&lt;/cell&gt;&lt;cell&gt;&lt;![CDATA[843]]&gt;&lt;/cell&gt;&lt;/row&gt;&lt;row id='9444018222'&gt;&lt;cell&gt;&lt;![CDATA[9444018222]]&gt;&lt;/cell&gt;&lt;cell&gt;&lt;![CDATA[843]]&gt;&lt;/cell&gt;&lt;/row&gt;&lt;row id='9444026222'&gt;&lt;cell&gt;&lt;![CDATA[9444026222]]&gt;&lt;/cell&gt;&lt;cell&gt;&lt;![CDATA[843]]&gt;&lt;/cell&gt;&lt;/row&gt;&lt;/rows&gt; </code></pre> <p>So.. To do this with curl.. </p> <pre><code>curl -d "_search=false&amp;nd=1357565939966&amp;rows=50&amp;page=1&amp;sidx=gsmno&amp;sord=asc" http://sancharsoft.bsnl.co.in/auction/vacant_nos/ch/fancy_nos_load.asp </code></pre> <p>As you can see, I've copied the exact browser request into the curl <code>-d " "</code> data specifier. </p> <p>It turns out, that yes, you can actually change it so that "rows=50" becomes "rows=5000", and you get the expected buttload of data. <code>&lt;rows&gt;&lt;page&gt;1&lt;/page&gt;&lt;total&gt;1&lt;/total&gt;&lt;records&gt;2368&lt;/records&gt;</code></p> <p>Actually, just over 2300 rows, but the thought works.</p>
    singulars
    1. This table or related slice is empty.
    1. POExtract data from a website Jquery Grid
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USTom O'Connor
    1. USTom O'Connor
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POExtract data from a website Jquery Grid
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you Tom. But i want all the numbers. At the bottom of the grid there is something like "View 1 - 50 of XXX XXX". Hot to retireve all XXX XXX numbers.
      singulars
      1. PO
      1. USChandru
    2. COTry posting page:2 / 3 / 4 .. .etc in the curl request..
      singulars
      1. PO
      1. USTom O'Connor
    3. COTom i am not familiar with CURL commands. Can you give me the command for the above requirement. I see "rows:50" in the HTTP POST , i think i can increase row value like "rows:5000" to get all the data instead of page navigation.What is your suggestion?.
      singulars
      1. PO
      1. USChandru
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload