On or near 1/22/02 2:30 PM, Diane Ross at [EMAIL PROTECTED] observed: > On 1/21/02 12:36 PM, "Bruce Rappaport" <[EMAIL PROTECTED]> wrote: > >> Please tell me more. I have had a hell of a time trying to import into >> Entourage from my Personal Organizer (Chronosnet-Consultant) database. Help >> anyone? > > I don't know if this will work, but try dragging the contacts from > Chronosnet-Consultant address book to the desktop. Now drag them > into the Entourage address book. > Another alternative would be: Chronos probably has some kind of ability to export contacts to a tab-delimited text file. If so, do that.
Now, you need to know what order of fields Entourage is expecting when it imports a tab-delimited text file. To find out, EXPORT the contacts from Entourage (on the File menu), and then examine the file with a text editor like BBEdit (the Lite version is free) to see what order the fields are in. (Or see the convenient list I append below!) You must export <all> contacts, but it is fast. (Incidentally, this makes a good way of producing a backup of just your contacts every now and then.) Then, import the text file into a spreadsheet program such as Excel or AppleWorks. There, you can shuffle the fields (columns) around to get them into the order you want, and even delete columns, combine some, etc. You may have to add some empty columns to supply empty values for fields that exist in Erage but not in Chronos. Write the resulting "spreadsheet" back out as tab-delimited text. Finally, import the resulting file into Entourage. The program does not give you any option to select or arrange fields as you import; you have to have the fields arranged in the proper order! And if any contacts you are importing already exist in your database, they will be duplicated. To save you a little trouble, here are the 69 fields of Entourage contacts, in export order: First Name Last Name Title Suffix Nickname Company Job Title Dept Work Street Address Work City Work State Work Zip Work Country/Region Work URL Home Street Address Home City Home State Home Zip Home Country/Region Home URL Home Phone 1 Home Phone 2 Home Fax Work Phone 1 Work Phone 2 Work Fax Pager Mobile Phone Main Phone Assistant Phone Other Main Ignore Field Voice Mail Email Address 1 Email Address 2 Email Address 3 Email Address 4 Email Address 5 Email Address 6 Email Address 7 Email Address 8 Email Address 9 Email Address 10 Email Address 11 Email Address 12 Email Address 13 Custom 1 Custom 2 Custom 3 Custom 4 Custom 5 Custom 6 Custom 7 Custom 8 Custom date 1 Custom date 2 Spouse Birthday Anniversary Notes Age Astrology sign Bloodtype Furigana Company Name Furigana First Name Furigana Last Name Furigana Spouse Name Interests > > -- > Diane Ross > Microsoft MVP for Entourage/OE > Macintosh Email Resource Page <http://www.macemail.com/> > > -- Microsoft MVP for Entourage/OE/Word Allen Watson <[EMAIL PROTECTED]> XNS name: =Allen Watson Applescripts for Outlook Express and Entourage: <http://homepage.mac.com/allenwatson/> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> archives: <http://www.mail-archive.com/entourage-talk%40lists.letterrip.com/> old-archive: <http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
