[ic] using IC to send out newsletter -automatically

Stefan Hornburg racke at linuxia.de
Tue May 11 18:33:34 EDT 2004


On Tue, 11 May 2004 14:22:04 -0700
"Jeannie Stevenson" <webteam at wes-state.com> wrote:

> Hello list
> 
> My client want to use IC to send out html/text newsletter using the IC cron
> method
> 
> In catalog.cfg I have:
> Jobs base_directory etc/jobs
> Jobs log    log/cron.log
> Jobs email my-email-address
> 
> In etc/jobs/job1 I have:
> 
> #!/bin/sh
> [query list=1
>  sql="select username, password, fname, lname, email, mail_list
>   from userdb where mail_list like '%newsletter%']
> cat <<EOF | sendmail -t
> From: Wes-State Mortgage, Inc <service at wes-state.com>
> To: [loop-pos 3] [loop-pos 4] <[loop-pos 5]>
> Subject: wes-state mortgage,inc. newsletter
> extra=|
>  [tag op=mime arg=header][/tag]
>  |]
> [tag mime boundary][/tag]--
> 
> <body>
> [include include/newsletter/newsletter6]
> </body>
> 
> Best Regards,
> Wes State Mortgage, Inc. Customer Service
> 
> Note. You subscribed to this list (newsletter) when you either visited
> or placed an order with us. you can unsubscribe at any time with the
> following
> url:
> {mv_base_url}list=newsletter&what=[loop-pos 5]&who[loop-pos 0]
> 
> Thanks for your business
> 
> EOF
> [/query]
> 
> It should query the database for newsletter out of the userdb mail_list
> column, inserts the html file within the <body></body> tags and then send an
> email to those individualls but nothing seems to be happening.
> 
> I've executed the batch as user interch with:
> 
> /var/local/interchange/bin/interchange --runjobs=wes-state=job1
> 
> Any thoughts, ideas, or pointers would be helpful

Interchange Jobs are completely driven by Interchange, so shell
commands will be happily ignored. I recommend to use my [email-mime] 
usertag (check the archives) for your job. 

Bye
	Racke


-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team



More information about the interchange-users mailing list