You will create a bot that will download 26-row Excel files from a website. Then you will consolidate those files. Essentially, you will need to enter a record number range on the first page, click "Build File", download the file from the second page which loads, consolidate the file into a master file, return to the first page, enter the next record number range, and so on. Complete detail is included.
1. Go to [url removed, login to view] 2. Click on the link “D&B Total U.S. Million Dollar Database - Remote Users?? 3. Use log in information that I will provide to access the database. 4. When you get to a screen that says “The Million Dollar Database?? and has a yellow box, click on “Advanced Search?? in the yellow box. 5. Click on “NAICS Code?? under “Industry Criteria?? 6. At the bottom of the page, in the box titled “Enter NAICS Code(s) for Search, enter “621111?? 7. At the top of the screen, click “Add to Criteria?? 8. Press “Build Files?? 9. Under “Selected Records?? there are two boxes. In the first box, enter the lowest record number that you have not downloaded yet. (The first time, this number will be 1. The second time, it will be 26, and so on.) In the second box, enter the number you entered in the first box plus 24. (The first time, this number will be 25. The second time, it will be 50, and so on.) 10. Click “Build File?? 11. After waiting about 5 seconds while the file is built, click “Click here to download your file?? 12. Open the file 13. Copy the 2nd through 26th row of the file immediately below the last set of 25 rows that you copied over. (The first time, create a new Excel spreadsheet and copy the 1st through 26th rows of the file you built into the 1st through 26th rows of the new spreadsheet.) If you run out of room in a spreadsheet, create a new spreadsheet like the first one. Please number the spreadsheets appropriately. 14. Click the back button in the Internet browser. 15. Go to step 9. Repeat these steps until you have downloaded the 354,522th record. This will require completing steps 9-14 14,181 times. Run the bot on your computer and deliver the results. Deliver the bot when you complete your work. Please configure the bot so that I can run it on my Windows XP PC and use it for any criteria I search for using the Advanced Search feature on the website.
* * *This broadcast message was sent to all bidders on Thursday Sep 11, 2008 2:03:11 PM:
I will be reposting this request as a new bid request. Please place bids again if you wish.