News Group Posts

export netscape address book

Message-ID: <39DE6C56.E0ADD000@squonk.net> 
From: "Brian K. White" <linut@squonk.net>
Newsgroups: comp.unix.sco.misc
Subject: Re: Export filepro data to Netscape address book
References: <39de161c.24027157@news.psi.ca>
<39DE1CCF.1154A681@aplawrence.com> 
Date: Sat, 07 Oct 2000 00:08:35 GMT

Tony Lawrence wrote:
> 
> Harry Fine wrote:
> >
> > Hello all
> >
> > I am using Netscape 4.7 for SCO Unix, and filepro 4.8.  In one of our
> > filepro databases, we keep track of people who have filled out a
> > survey.  One of the fields in the survey is email address.  I'd like
> > to be able to export the names and email addresses from the filepro
> > database, into a format that Netscape can import, so that I can do a
> > group or bulk email to everyone in the adderss book.  Anyone ever done
> > that.
> 
> Why import it into Netscape?  You can very simply run a command
> line program (from within Filepro even) that will email en masse-
> and can be a lot smarter about it than Netscape would be.  Or, if
> you really want to maintain a subscription mailing list,
> Majordomo is another good choice- it's even smarter about bulk
> mail and its name lists are pure ASCII text.  And of course there
> are other similar packages.
> 
> Doing it one of those ways lets you automate the entire
> procedure, too..

if you really do want to use netscape, all you have to do is open up the
address book, select "Export" from the file menu, pick a filename (don't
bother making an extension it will just create <something>.ldif anyways)
then look at the file it creates. looks like a pretty simple format.

a little manual experimentation just showed me you only need:

mail: bogus1@localhost

mail: bogus2@localhost

mail: bogus3@localhost

and you can just include any extra fields you want, like a nicer display
name

cn: 1st bogus
mail: bogus1@localhost

cn: 2nd bogus
mail: bogus2@localhost

cn: 3rd bogus
mail: bogus3@localhost


probably the fastest (which as usual is also the crudest) way to generate
the file is with a "report" output format with a 2 or more line body
section. one blank line in the body, plus one line for each field you want
to include:


header section:

body section:
cn:<2
mail:<3

total section:

and print to file , in processing do:
PRINTER FILE "/tmp/nsbook.ldif" ;FORM "nsbook"

actually it's just as easy or easier I guess to write the file directly from
processing without a report format. certainly more flexible.


-- 
Brian K. White                   http://www.squonk.net/users/linut
+++++[>+++[>+++++>+++++++<<-]<-]>>+.>.+++++.+++++++.-.[>+<---]>++.
filePro BBx  Linux SCO  Prosper/FACTS AutoCAD  #callahans Satriani

Comments?

Jump to Comments

Many of the products and books I review are things I purchased for my own use. Some were given to me specifically for the purpose of reviewing them. I resell or can earn commissions from the sale of some of these items. Links within these pages may be affiliate links that pay me for referring you to them. That's mostly insignificant amounts of money; whenever it is not I have made my relationship plain. I also may own stock in companies mentioned here. If you have any question, please do feel free to contact me.

Specific links that take you to pages that allow you to purchase the item I reviewed are very likely to pay me a commission. Many of the books I review were given to me by the publishers specifically for the purpose of writing a review. These gifts and referral fees do not affect my opinions; I often give bad reviews anyway.

We use Google third-party advertising companies to serve ads when you visit our website. These companies may use information (not including your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you. If you would like more information about this practice and to know your choices about not having this information used by these companies, click here.