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>.
