Show Bid Request
Java query on patent website
Bid Request Id: 51774
|
|
|
|
Posted by: |
cmhsieh54 (6 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Above Average - 36.36%
|
Buyer Security Verifications: |
Excellent
|
|
Approved on: |
Mar 8, 2003
9:17:12 AM EDT
|
|
Bidding Closes: |
Mar 11, 2003
1:30:22 AM EDT
|
|
Viewed (by coders): |
106 times
|
|
Deadline: |
3/13/2003
TIME EXPIRED
|
|
|
|
|
Description:
The basic idea of my dilemma is that I need a 3-column text file. The first column is comprised of all U.S. utility patent numbers granted between 1/1/1976 and 1/1/2000. In the second column I need the grant date. In the third column I need the application date.
Take a look at this website:
http://patft.uspto.gov/netahtml/srchnum.htm
At this website, anybody can input a patent number and receive all information about it. For example, I input "3930271" and it tells me that this patent was granted on 1/6/1976 and that it was filed on 12/16/1974.
I need this 3-column text file to cover ALL PATENTS from #3930271 to #6009554 [i.e. granted between 1/1/1976 and 12/31/1999]. I need the dates to be in the form of integers, counted as the days elapsed since 1/1/1960. So therefore, 1/2/1960 would get the integer value "1", 1/3/1960 would get the integer value "2", etc.
Please see the deliverables below.
Deliverables:
Here are the deliverables:
1) I need this file in comma delimited form.
2) I only need utility patents, so this means all values in the first column of the text file will be 7-digit integer values.
3) In the 2nd column of the text file I need the grant date in terms of days elapsed since 1/1/1960.
4) In the 3rd column of the text file I need the application date in terms of days elapsed since 1/1/1960.
5) I need the text file on a CD (readable in any CD-ROM drive) shipped to me via PRIORITY MAIL to a non-PO-box address that I will supply to the winning bidder. When you bid, please go ahead and add in the extra $3 or so.
Platform:
I have mentioned JAVA as a possible choice. However, I understand that other platforms might work (?).
***** Bidders should let me know in their bid what platform that they plan on using (and if not JAVA, why not). *****
Must be 100% finished and received by buyer on:
Mar 13, 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.
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!
|
$35 (USD)
|
Mar 10, 2003
3:19:47 AM EDT
|
10
(Excellent)
|
|
|
Dear cmhsieh54,
Here is some example data that I believe meets your formatting requirements.
3930271, 5849, 5463
3930272, 5849, 5366
3930273, 5849, 5488
3930274, 5849, 5397
3930275, 5849, 5568
3930276, 5849, 4602
3930277, 5849, 5346
I can write a Java program to request this information from the website you provided: http://patft.uspto.gov/netahtml/srchnum.htm
A problem is that I can only retrieve about 3 records per second. Since you have requested 2,079,284 records that will take over 8 days full time processing with no problems with the website (such as maintenance) or any links between. This would definitely not meet your timeline of March 13th.
So, do you need all the records or will a selected subset work? If you figure out a selected subset, say 20,000 or so then I can probably help you.
Otherwise, I am willing to provide you the program for the bid and you can generate as much data as you wish at your leisure.
Thank you for your consideration.
Jim Williams |
|
|
|
|
|
|