Subject: Pine adressbook question ?

From: "maurice.steyvers" <[email-masked]>
Date: Tue, 13 May 1997 08:37:42 +0200

Hi,

Is it possible to use or transform a large text file (in some
arbitrary format with about 2000 mail-adresses) as your personal
adressbook. Are there any tools to do this conversion ? The idea
is to offer a campus-wide adressbook to our university.

Maurice Steyvers
Universiteit Maastricht
NL.

---

From: "Robert J. Wilshe" <[email-masked]>
Date: Tue, 13 May 1997 13:23:04 -0500 (CDT)

Maurice:

There is software (or a script) that will do this for you, but I've been
able to do it using Microsoft Excel, actually!

If you can import your data into Excel (on Windows, probably), the import
wizard will help you parse your text into columns.  Your column order
needs to be: Nickname, Fullname, Address, Fcc, Comment

Save the parsed data without any header in "Text (Tab delimited)" format
in Excel.  Then FTP this file up to where you want the global addressbook. 
The .addressbook.lu should be rebuilt when it's accessed. 

This did work for me.  Hopefully it'll work for you.  I've seen tools that
will do this, but I can't remember where I saw them / heard of them.

Good luck, 

\\//\\//\\//\\//\\//\\//\\//\\//\\
robert		 chicago  illinois
joseph		 u       s       a
wilshe		 rwilshe @ ais.net
//\\//\\//\\//\\//\\//\\//\\//\\//

---

From: [email-masked] (Christian Mondrup)
Date: 13 May 1997 09:42:00 GMT

maurice.steyvers ([email-masked]) wrote:
: Hi,

: Is it possible to use or transform a large text file (in some
: arbitrary format with about 2000 mail-adresses) as your personal
: adressbook. Are there any tools to do this conversion ? The idea
: is to offer a campus-wide adressbook to our university.

I do something similar in a cron job reading a list of users from an Oracle
table and writing each column to a file in Pine address book format:

nickname \t surname, first name \t email address

: Maurice Steyvers
: Universiteit Maastricht
: NL.

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+   Christian Mondrup                                                     +
+   Computer Programmer                                                   +
+   Scandiatransplant, Skejby Hospital, University Hospital of Aarhus     +
+   Brendstrupgaardsvej                                                   +
+   DK 8200 Aarhus N                                                      +
+   Denmark                                                               +
+                                                                         +
+   Phone:   +49 89 49 53 01                                              +
+   Telefax: +45 89 49 60 07                                              +
+   E-Mail:  [email-masked]                                            +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++