Re: [sqr-users] Run PS Query in SQR

["Jamie Harris" <JHarris@frederick.edu>]

Hi.  I think I can help you.

I have a utility written in Perl that will send email to people in a
tab-delimited text file and replace fields from the file in the email
body.

Here's what you'd do:
1. The user runs their query to Excel and saves the file as a
tab-delimited text file.
2. Someone defines the body of the email, and if they want a field from
the query to be inserted they simply place it in brackets like this:
{FIELDNAME}.
3. Run my Perl program to actually send out the emails.

If you're interested, I can send you this program as a Windows
executable.  I have the Perl Dev Kit from www.activestate.com which has
a utility that "compiles" Perl programs into stand-alone executables.  

I use this here when our President wants to email all of our faculty
and staff without using the "everyone" email list.  We save the
Groupwise address book as a tab-delimited file and she sends an email to
everyone individually.  She wants that "personal touch" that you can't
get from the "All fac/Staff" email list. :)

Just let me know.  :)

-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> AGacevic@scu.edu 3/5/2003 1:33:33 PM >>>
Hi,

I'm planning to use SQR to send email to every student whose emplid
shows up in the query (from PS Query) provided by user. Even if I manage
to build sql from Query tool tables (it will be tricky, anyone did it?),
I will have totally dynamic sql to run in SQR. It will be select query,
and will have variable number of columns (with unknown types) and tables
involved. 

Do you think it's doable? Any suggestions would be appreciated...



Aleksandra Gacevic
Programmer/Analyst
Santa Clara University
408 551 7124


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Harris, Jamie
TEL;WORK:2668
ORG:;Division of Information Technology
EMAIL;WORK;PREF;NGW:JHarris@frederick.edu
N:Harris;Jamie
TITLE:Systems Analyst, PeopleSoft
ADR;DOM;WORK;PARCEL;POSTAL:;L-205
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Harris, Jamie=0A=
L-205
END:VCARD