Show Bid Request Web Data Mining and Storage Bid Request Id: 3062 Bookmark in my 'To Do' list Posted by: Jared (1 ratings) (Software buyer rating 10) Non-action Ratio: Below Average - 50.00% Buyer Security Verifications: Unverified Approved on: Sep 27, 2001 8:49:21 PM EDT Bidding Closes: Oct 1, 2001 7:49:49 AM EDT Viewed (by coders): 560 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Small Business Project: $100 (USD) + Bidding Type: Open Auction Categories: Database, Visual Basic Enter chat room for this bid request (0 active users at Sep 23, 2003 3:10:58 PM EDT) Description: The program must store data in microsoft access / I would like the program written in visual basic, but this is not a requirement. The goal of this program can be divided into XXX sections The first goal is to find, retrieve, extract and store the data into Microsoft Access Database The second goal is to verify or add a zip code for each mailing address The third goal is to Manage users and the data they receive via our reporting feature. The fourth goal is to automate the reporting feature to create and email the report or mailing labels in microsoft word format. Deliverables: A sample of the program expectations. 1. Find new records from http://www.hcso.tampa.fl.us/pub/default.asp?/Online/dailybook3/?Date=092301 (notice the last portion is the date, this should be changible Running the above link, returns another list of all records for the specified date The program needs to follow each link and to extract all the data on each record It should be noted that some records contain more information or charges than others Here are some examples http://www.hcso.tampa.fl.us/pub/default.asp?/Online/qdisp/bn=01052002 - This link contains one charge http://www.hcso.tampa.fl.us/pub/default.asp?/Online/qdisp/bn=01052025 - This link contains two charges http://www.hcso.tampa.fl.us/pub/default.asp?/Online/qdisp/bn=01052043 - This link contains one charge multiple aliases The program should not pull down records we already have. This should be based on the booking number or bn. For example, assume todays day was 09/23/2001 and I run the program every hour. with the following link http://www.hcso.tampa.fl.us/pub/default.asp?/Online/dailybook3/?Date=092301 Everytime I run the program it would pull back all links for the day, if I already added bn=01052002 to the database, I would not want to retrieve this record again. 2. Extract Data and store in Microsoft Access The program should extract all data fields and store in access database. The program should also store the county and state in seperate fields that the records are pulled from. Example of above, Hillsborough and Florida 3. Management of Users The program should include an admin interface for adding users, selecting the data they desire, which could include, State/County/Charges. The program should include what format they desire the information in. (they could desire multiple formats, examples a word document listing names, addresses and charges, they could desire a word document for printing Avery mailing labels) The program should include the option of delivering the data multiple times throught the day (Example 8am and 2pm, or just at 3pm) The system should be able to handle multiple users of this data. Examples of multiple users and their criteria User1 Wants all charges (This users wants a word document that is formated for Avery 5160 mailing labels, the labels will print name, address,city,state,zip) User1 wants a weekly report of all persons he has received information on User2 wants all charges but seprate documents (This is the same as above, but this user requires labels for each person that had a charge of TRAF10 to be on one set of lables, and all others persons to be on label set 2) User 3 wants a word document for avery 5160 labels for all persons with charges that start with DRUG 4. Automate reporting The Program should at the specified time for each user do the following. Scan database for any charges not yet sent to userX Create word document for new charges for userX(This could be a general report or Specified Avery mailing labels in word format) Email the documents to userX Update database for userX on which records have been sent 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   CodeWarrior (9 ratings) in Harrisonville, Missouri United States Bid id: 25,287   N/A Sep 27, 2001 9:17:46 PM EDT  10 (Excellent)     Hello Jared, If you are associated with the Tampa Sheriff's department, the data can be easily obtained from them via FTP or even ODBC connection. If you are not associated with them, the extraction from the web site is quite doable, but can be a bit tedious, and $100 is a bit low. This bid was accepted by the buyer! CodeWarrior (9 ratings) in Harrisonville, Missouri United States Bid id: 25,291   $200 (USD) Sep 27, 2001 9:47:57 PM EDT  10 (Excellent)     Hi Jared, I can deliver the product fully tested within a week from acceptance of bid. To verify my qualification, please see my resume. Thank you.