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.