RE: Email Logicsheet

[Donald Ball <ba...@webslingerZ.com>]

On Thu, 1 Feb 2001, Colin Britton wrote:

> yes its working great. Next question if you dont mind.......
>
> I want to do the following.
>
> 1) use an esql page to extract a lot of data from the database.
> 2) use a stylesheet to change this data into various forms - one of which is
> a sendmail XSP page
> 3) execute the output of 2
>
> is this possible in C2??

should be easy enough using this paradigm:

<esql:row-results>
  <sendmail:send-mail>
    ...
    <sendmail:body>
      The answer is <esql:get-string column="answer"/>.
    </sendmail:body>
  </sendmail:send-mail>
</esql:row-results>

i know that you cannot do 2) - xsp pages are generators in c2, i don't
think you can't transform something into an xsp page. i've sent this
message to the dev list in case a c2 xsp expert wants to chime in here.

- donald

Re: Email Logicsheet

[Colin Britton <cb...@centervilletech.com>]

I used a combination of esql and sendmail logicsheets to create a
personalized email message and send it to 2500+ addresses, This XSP page
also logged every mail sent, in case it failed halfway through, so it could
restart where it left off. The whole batch ran and sent in about 3 minutes,
about 12 emails a second.

I have since made a variant of the email logicsheet which creates multi-part
emails, however hit a problem when I wanted to put HTML into the email. This
is because the result of a <xsl:copy-of> <xsl:value-of> command is infact a
SAX ContentHandler object and HTML elements are not strings..... Therefore
this data needs serialializing into a string. If anyone has any example code
to help me out here that would help.

One of my main issues though is that the use of the sendmail logicsheet and
esql together means that the logic and style of the email is all embedded in
the XSP page. Not the kind of seperation we encourage with cocoon. It would
of been better if I could of used esql to build the mail list and gather all
the data I needed, use the XSLT transformer to add the style then a sendmail
XSP transformer to send the emails. Any ideas for this kind of approach
would be welcome......

rgds
CB

----- Original Message -----
From: "Donald Ball" <ba...@webslingerZ.com>
To: <co...@xml.apache.org>
Cc: "Colin Britton" <cb...@centervilletech.com>
Sent: Thursday, February 01, 2001 5:29 PM
Subject: RE: Email Logicsheet


> On Thu, 1 Feb 2001, Colin Britton wrote:
>
> > yes its working great. Next question if you dont mind.......
> >
> > I want to do the following.
> >
> > 1) use an esql page to extract a lot of data from the database.
> > 2) use a stylesheet to change this data into various forms - one of
which is
> > a sendmail XSP page
> > 3) execute the output of 2
> >
> > is this possible in C2??
>
> should be easy enough using this paradigm:
>
> <esql:row-results>
>   <sendmail:send-mail>
>     ...
>     <sendmail:body>
>       The answer is <esql:get-string column="answer"/>.
>     </sendmail:body>
>   </sendmail:send-mail>
> </esql:row-results>
>
> i know that you cannot do 2) - xsp pages are generators in c2, i don't
> think you can't transform something into an xsp page. i've sent this
> message to the dev list in case a c2 xsp expert wants to chime in here.
>
> - donald
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email: cocoon-dev-help@xml.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org