Data Scrape Project - Create Data Extraction Macro for Database on CD
$100-500 USD
Closed
Posted about 15 years ago
$100-500 USD
Paid on delivery
THE SITUATION:
I have 2 CDs with approximately 60,000 records of contact information, and I need to be able to extract data from them. I have the 2 CDs as .ISO files, but I could not tell you what kind of database is on them. I will describe the situation below, but I will need to share the ISOs with you (624 MB and 293 MB) before we can get started on the project.
DATA EXTRACTION PROBLEM:
This directory on CD only allows export of 200 records at a time, of approximately 60,000 records of interest. Also, the email address is not available in every case, and is buried within another field. And, the Postal Code (ZIP code) is shown as a numeric rather than text value, where leading zeros are omitted and we don’t always have a 5-digit (or 5 digit plus 4 digit with hyphen) ZIP code. We receive 2 new CDs every quarter, so we would want this extraction module to be some kind of automated process that we would run whenever we receive the new CDs.
I need to extract all 60,000 records of interest into an Excel file, and move the email address (when available) into its own field within a record.
These CDs also assign each contact an ISLN number, a unique identifier for that person. That data is not currently part of the data that is exported with the export function, but can be obtained on a record-by-record labor-intensive operation of looking at the Detailed View of each contact. I would like to have that ISLN number in the Excel file to compare future versions of the database to this one to see which contacts have changed their address.
I will provide an account of how I would do this manually and I will provide a .ISO of one of the CDs so that you will be able to determine if this is possible for you.
## Deliverables
* * *This broadcast message was sent to all bidders on Thursday Feb 5, 2009 7:11:48 PM:
We are having problems with the size of the download. I will send out a new link and password shortly. Sorry for the inconvienence.
* * *This broadcast message was sent to all bidders on Thursday Feb 5, 2009 10:12:44 PM:
I apologize for the confusion. We have uploaded the file to this address. [login to view URL] I believe you have to cut and paste. It should immediately give you the option to save. Thank you.