Frank: 

If it were me, I would try to import all the disparate data files into Excel or 
AppleWorks or maybe Filemaker Pro and then do the cleanup work using those 
programs' editing and formula functions. I am assuming that your various 
information management programs can export data as tab- or comma-delimited text 
files that any of the above programs can import. 

I suspect that a macro program like QuicKeys (or even better, One Click, but it 
only works in OS 9) would also be helpful in doing a lot of the repetitive work 
of standardizing the records.

Dan

>Contact Information ManagementThanks, Ward, for suggesting I
>start a new subject thread, sorry for the confusion.
>
> Currently I have several different address books from old
>applications such as five separate Act! 4.0 (for PC) databases
>(that I access through Virtual PC), two Palm address books,
>three excel spreadsheets and an old Outlook 56;98 address book.
>Collectively these total about 3800 names and each of these has
>some redundancy both within a given database and between the
>databases.
>
> Ultimately I want to move most of these names into Entourage
>and use it as my primary PIM and to synchronize with my Palm
>IIIx. Before importing into Entourage, I was trying to
>separately clean-up each database, standardize the format (some
>databases use the format title, first name, last name all in
>one line and others separate each of these labels), add
>categories (such as friends, business, family, etc.).
>
> I know I can manage the data in Entourage but my existing,
>active address book is Entourage and I don57;t want to
>co-mingle the 60;old61; data with the existing 837 names before
>correcting the 60;old61; data. Therefore:
>
>? Will Entourage allow me to create two data bases, one to use
>day-to-day and one to clean-up before merging? If so, then how
>can I create another Entourage data ?base? I could not find it in the help 
>menu.
>? If the answer to #1 is no, does anyone know of a simple,
>inexpensive PIM that will do what I want?
>? Is there another solution altogether? I am open to any
>suggestions.
>
> Thanks,
> Frank
>
> On 4/3/03 11:21 PM, "Ward Oldham" <woldham at insightbb.com>
>wrote:
>
>Hi Frank,
>
> First, you may in the future want to start a new thread. ?Your
>topic has nothing to do with the HP printer problem.
>
> Second, I57;m a little confused. ?You already have Entourage
>which will accomplish this for you. ?What exactly are you
>looking to do?
>
>Ward Oldham, MacDude
> MacTown
> 1041 Bardstown Road
> Louisville, KY ?40204
> 502-485-1243
> ward at mactown.us
> http://www.mactown.us
>
>
> On 4/3/03 10:44 PM, "Frank Hammitt" <fhammitt at msn.com> wrote:
>
>I am looking for an inexpensive (better is free) application to
>manage contact information such as names, addresses, telephone
>numbers, etc. I seem to remember a reference to such and
>application in one of the earlier e-mails. Does anyone remember
>the name of the application or can suggest an application that
>will let me import, store, manipulate the data and export to
>other applications? I use a Ti PB 667, OSX 10.1 and Office V.x
>w/Entourage. Entourage is where I ultimately want to used the data on a daily 
>basis.
> Thanks,
> Frank
>
>
>
>




| The next meeting of the Louisville Computer Society will
| be March 25. The LCS Web page is <http://www.kymac.org>.


Reply via email to