Ditutup

Write Data Extraction Macro for Databases on 2 DVDs

THE SITUATION:

I have 2 DVDs with approximately 60,000 records of contact information, and I need to be able to extract data from them. I have the 2 DVDs 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 DVD 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.

I need to extract all 60,000 records of interest into one flat-file database, and move the email address (when available) into its own field within a record.

These DVDs also assigns each contact an ISLN number, which is a unique identifier for that person, which will not change when that person changes law firms or moves. 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 be a part of the flat-file database, if feasible/practical, to compare future versions of the database to this one to see which contacts have changed their address.

HOW I'D DO IT MANUALLY:

Open the software. It starts on the Search Page. Click on the red tab that says “Advanced Search”. Find the field for “practice groups” and click on the folder icon to the right, click on “Family Law” and “OK”. Then Click “Search.”

Click on the tab at the top for Brief View. Look in the bottom right corner and it’ll say “Listing: 0 of 61517” meaning that 61,517 records matched the criterion of Family Law.

At the top of the page click File, then Export. Give the file a name like 200.txt. At the bottom of the box specify that the records to be extracted are 1 through 200. Then click Export and the file is created.

Click File, then Export again, with a name like [url removed, login to view], specifying records 201-400. Export.

Repeat 300 times. Then, cut and paste the contents of each spreadsheet into one master spreadsheet (without duplicating the headers), so you have a flat file with 60,000 records.

Then, write a macro to search for “@”, copy the entire word containing that symbol, and pasting it in a new column to the right of the entries for that record.

(now I don’t know if the rest of this is worth the effort and expense). Go back to each record in the Detailed View. Double click on the ISLN number, paste it into an Excel spreadsheet. Double click on the last name and paste it. Double click the first name and paste it. Double-click the zip code and paste it. Wind up with a spreadsheet with 60,000 entries of ISLN, lastname, firstname, and zipcode. Write a macro to match up this info with the info in the other spreadsheet to associate the ISLN with the appropriate record and make the ISLN part of the record.

In a few months do it all over again, and run a program to compare addresses of each ISLN to identify contact who are new to the database, or who have moved since the previous database.

Where I said 'flat-file database' above, I am actually looking for an Excel spreadsheet.

Kemahiran: Pemprosesan Data

Lihat lebih lanjut: data extraction macro, write what i say, write the contents, we can write that, top data, search red, search for red, red search, processing the data, practical law, match problem, master find, make own icon, make an icon program, look like a copy write, look find and write, icon search, icon for contact, icon folder, icon find, i can copy write a word, how to write at in email address, how to write a new law, how make icon, how do you write contents

Tentang Majikan:
( 178 ulasan ) Dallas, United States

ID Projek: #354684

16 pekerja bebas membida secara purata $181 untuk pekerjaan ini

NishantBamb

Hello, please refer your PMB. Thank you.

$200 USD dalam 7 hari
(103 Ulasan)
6.7
MAnkita

Hello,Please refer your [url removed, login to view] you.

$250 USD dalam 3 hari
(65 Ulasan)
5.9
wsh2

Grretings Dallas from the land of the (Philadelphia) Eagle and the (New York) Giant.. {gentle smile} While your means of extracting the data is certainly well considered and viable, I would first want to try extract Lagi

$249.99 USD dalam 5 hari
(11 Ulasan)
4.3
NashTrump

Hi there, I can have this done vrey quickly but i will need to look at the databases first before accepting any offer. I am a vba, Access, Excel, SQL, MYSQL, PHP and Perl expert so databases arent a problem to me Lagi

$250 USD dalam sehari
(7 Ulasan)
4.0
cheungkc

Hi We trust the problem is in exporting the data from the iso file. Manipulating data from the exported files in Excel is not a problem at all. Can we review what is the contents of the DVDs to ascertain if we can a Lagi

$150 USD dalam 7 hari
(6 Ulasan)
3.1
johnsinit

Dear aceychasing! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$135 USD dalam 2 hari
(7 Ulasan)
3.4
kamosion

Ready to work!

$130 USD dalam 3 hari
(3 Ulasan)
2.9
tcpuffy

please employ me

$200 USD dalam 7 hari
(0 Ulasan)
0.0
rosebear

Hello there! Please see my PM. I do look forward to working with you on this project!

$150 USD dalam 5 hari
(0 Ulasan)
0.0
vpbothre

I am interested to do this job.

$150 USD dalam 7 hari
(0 Ulasan)
0.0
Smbogo

I will deliver it within 7 days

$180 USD dalam 7 hari
(0 Ulasan)
0.0
sandy1984

HELLO, I CAN DO IT WITH IN TWO DAYS AND GIVE ME THIS JOB

$150 USD dalam 2 hari
(0 Ulasan)
0.0
demse

*** satisfaction guaranteed ***

$150 USD dalam 3 hari
(0 Ulasan)
0.0
JMeyerATL

I can do this, I have many years of experience manipulating data and would really enjoy working on what you have described.

$225 USD dalam 5 hari
(0 Ulasan)
0.0
LastGrunger

At your service. (I'm not Bill!)

$200 USD dalam 2 hari
(0 Ulasan)
0.0
amedina79

I can help with this. I've made similar projects before. Please see PM, Thanks

$125 USD dalam 6 hari
(0 Ulasan)
0.0