Re: SQL for Subscriber Lists?

There is a unix utility for Post.Office that is accessible under the shell
that allows you to get a whole user's profile. You would have to run this
and do some shell scripting but I think you could do it and then punch it
into a database.

I attached an email that was on a similar topic some time ago. Hopefully it
helps.

J

On 12/19/02 11:26p, "aasun eble" <eble@xxxxxxxxx> wrote:

> I would be extremely interested in this or similar functionality!
>
> aasun
>
> On 12/19/02 8:42 PM, "Mark R. Bell" <mbell@xxxxxxxx> wrote:
>
>> I'm evaluating Post.Office, and I really need to maintain my
>> subscriber lists on a MySQL database. Can Post.Office hook into a
>> database and grab a mailing list subscription?
>>
>> Thanks in advance,
>>
>> -- Mark
>> ---------
>> Tenon Intersystems' Post.Office Mailing
>> List
>> To unsubscribe: send mail to
>> post_office-request@xxxxxxxxx
>> with the subject: unsubscribe
>> Find the searchable mailing list archives
>> at:
>> http://postoffice.computeroil.com/
>

--------------------------------------------------
"If you're not living on the edge, you're taking
up too much space." - unknown

John Sievert
Customer 1st, Inc.
2950 Metro Drive, #101
Mpls, MN 55425
952.851.7901 office
952.851.7907 fax
mailto:john.pager@xxxxxxxxxxxxxxx (150 chars, text pager)

Return-Path: <post_office-request@xxxxxxxxxxxxxxx>
Received: from mail.tenon.com ([192.83.246.58]) by mail.customer1st.com
          (Post.Office MTA v3.5.3 release 709 ID# 1001-56150U100L10S0V35)
          with ESMTP id com for <john@xxxxxxxxxxxxxxx>;
          Fri, 23 Aug 2002 13:36:16 -0500
Received: from powerbook.tenon.com ([64.166.157.21]) by mail.tenon.com
          (Post.Office MTA v3.5.3 release 223 ID# 1001-1000U100L20S0V35)
          with ESMTP id com for <post_office@xxxxxxxxxxxxxxx>;
          Fri, 23 Aug 2002 11:35:58 -0700
Date: Fri, 23 Aug 2002 11:35:57 -0700
Subject: Re: How can I read the email addresses?
Content-Type: multipart/alternative; boundary=Apple-Mail-2-280950222
Mime-Version: 1.0 (Apple Message framework v543)
From: eyang@xxxxxxxxxxxxxx (Eric Yang)
To: post_office@xxxxxxxxxxxxxxx
In-Reply-To: <B98BE576.5021%john@xxxxxxxxxxxxxxx>
Message-Id: <2A3E8FC2-B6C7-11D6-B813-000393129B2A@xxxxxxxxx>
X-Mailer: Apple Mail (2.543)
reply-to: post_office@xxxxxxxxxxxxxxx

John,

There are some command line utility to help you accomplish this.

/usr/local/post.office/cmdutils/listacct (Use for list all the account names)

/usr/local/post.office/cmdutils/getacct (Use for getting email address from individual account)

getacct will generate a file base on the username that you input with .acct extension.

The text file will contain all the email addresses associated with individual user.

I help this helps.

regards,

Eric

On Friday, August 23, 2002, at 11:13 AM, John Sievert wrote:

Tenon - how do I do this?

Is there a file I can read with a unix shell script that has a list of the email addresses in it?

J

--

'What if the Hokey Pokey is what it's all about?'

-Jimmy Buffett, 2002

John Sievert

Customer 1st, Inc.

2950 Metro Drive, #101

Mpls, MN 55425

952.851.7901 office

952.851.7907 fax

mailto:john.pager@xxxxxxxxxxxxxxx (150 chars, text pager)