Find Jobs
Hire Freelancers

399149 web database extraction

N/A

In Progress
Posted about 14 years ago

N/A

Paid on delivery
I need a program to automate the search of the following web database and to extract the records Ideally every record [login to view URL] The Last name inputs will be read from a dbf file (or perhaps an SQL or some other database would be best what do you recommend?) In the end I will be using Alpha5 to organize the data so I am familiar with dbf files The goal is NOT to search for SPECIFIC PERSONS but to capture as many entries from the site as possible. I assume given the sparse search Options of the site the approach is limited to inputing as many last names and their variations as possible I am assuming this the appropriate approach to extract as much of the data as possible? If there is some other way to communicate with the website such that each record can be extractred that is really what I want As an example the first entires in the last name dbf file would look like this: Aaron,Aarons,Ahrens, Arrand, Arend, Arends, Aron Abberly,Abberley Abbot,Abbott,Abbat,Abot,Abott,Ebbott Abel,Abele, Abell, Able Abercrombie,Abercromby Abernathy,Abernath, Abernethy Abraham,Abram,Abrams Each last name would be input into the search box surrounded by quotes so that it would locate only that exact name and only the search returns with the name in the first position (meaning its a last name and not a first name) would be extracted For instance, submitting the last name "Aaron" returns a number of Aarons but none of them appear first so they are all first names and therefore none of these records would be captured at this time (they will be just later on when their last names are searched) However, submitting "Abbott" returns 63 records all with abbott in the last name field so they would all be captured For each appropriate last name record all the data field: name, payee, savings account etc need to be captured Each of these bank of canada records must be placed in database file such as dbf file such that they can be imported into my alpha5 database.
Project ID: 2145006

About the project

Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of
toronto,
0.0
0
Member since Mar 16, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.