Show Bid Request
Web Info to Excel Document
Bid Request Id: 55647
|
|
|
|
Posted by: |
sfrancom (1 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Above Average - 33.33%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Mar 31, 2003
11:24:50 PM EDT
|
|
Bidding Closes: |
Apr 2, 2003
7:17:18 PM EDT
|
|
Viewed (by coders): |
90 times
|
|
Deadline: |
4/3/2003
TIME EXPIRED
|
|
|
|
|
Description:
I need a program that can porgammatically visit a secured web site (https://),
post form data to a page, download the response, take the data from the
response, and make it into an Excel spreadsheet row. There are two parts to
this program. Part one must simply make "requests" to the page. Part two
actually has to go back and get the results. When done by hand, both parts
originate from the same web page, however, requests made in part one are not
made available for results viewing for 24 hours.
This sounds easy, but as another coder and I have come to discover, there
are a number of hurdles. I do have an assortment of source code fragments
from the previous user, which might be of some help. Two main problems:
1) Because of legal stipulations, I cannot give you login information
for the web site, but rather the program must ask for the login info. I can
give you sample results, however, with the actual data replaced by X's.
2) It seems as though the first attempt to download the results is almost
always successful. However, subsequest attempts (without restarting the
program) inevitably result in a "this request cannot be processed right now,
please try again later" error. This is where the previous coder could not
find a workaround.
I welcome any and all bids, or other input you might be willing to offer
about how to accomplish this task.
Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
Platform:
Windows XP
Internet Explorer 6.0+
Microsoft Excel
Must be 100% finished and received by buyer on:
Apr 3, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
This bid was accepted by the buyer!
|
$100 (USD)
|
Mar 31, 2003
11:47:14 PM EDT
|
8.46
(Very Good)
|
|
|
I've done a great number of http data extraction using web request and posting data to the web server. I'll start with $100. I'd also want to give the site a try. The parsing of sample web pages are generally trivia matter. The real problem as you've mentioned is actually going and grabbing data. I have code to post data, but there are cases (which i have discovered in the past) where the client need to send cookies that are embedded in the response of the first request, for any subsequent request. Many of these 'request spoofing' is eased by using sniffer, which picks up the request from the browser. By investigating the content of the http request from the browser, faking a similar request to the server (giving it what it needs) can be more effective.
So all and all, i'd really like to take this challenge. Look forward to hearing more about it,
Kenneth
|
|
|
|
|
|
|
N/A
|
Apr 1, 2003
12:04:43 AM EDT
|
8.46
(Very Good)
|
|
|
After reviewing your doc, I have the same conclusion that the program can start with the url where you fill in the form. From what i've seen from the doc, i really can't see any problem getting the response. Your idea is increment the number and query the number to see if it's valid right ? if it's valid, then parse the table. I really think i can do this.
As for the second 'hurdle' you mentioned, i think you can't send request too frequently. My usual practice is putting random pause in between requests.
Kenneth
|
|
|
|
|
|
|