Find Jobs
Hire Freelancers

Web Data Mining and Storage

$100-500 USD

Complété
Publié il y a plus de 22 ans

$100-500 USD

Payé lors de la livraison
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 [login to view URL]?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 [login to view URL] - This link contains one charge [login to view URL] - This link contains two charges [login to view URL] - 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 [login to view URL]?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
N° de projet : 2828145

Concernant le projet

4 propositions
Projet à distance
Actif à il y a 23 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
See private message.
$170 USD en 14 jours
5,0 (9 commentaires)
3,9
3,9
4 freelances proposent en moyenne $213 USD pour ce travail
Avatar de l'utilisateur
See private message.
$85 USD en 14 jours
4,7 (18 commentaires)
5,0
5,0
Avatar de l'utilisateur
See private message.
$170 USD en 14 jours
4,6 (60 commentaires)
4,5
4,5
Avatar de l'utilisateur
See private message.
$425 USD en 14 jours
4,8 (3 commentaires)
3,2
3,2

À propos du client

Drapeau de UNITED STATES
United States
5,0
1
Membre depuis sept. 28, 2001

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.