Thanks for your help Dan and others, I?ll try QuicKeys. Frank On 4/4/03 10:12 AM, "Dan Crutcher" <dcrutcher at loumag.com> wrote:
> 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>. > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://www.math.louisville.edu/pipermail/macgroup/attachments/20030404/ad5a8d51/attachment.html
