> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Ian C. > Sison > Sent: Tuesday, October 01, 2002 1:46 PM > To: 'PLUG Newbie' > Cc: 'PLUG' > Subject: Re: [ph-linux-newbie] Postfix Inquiry > > > I'm assuming you are using oracle.
Yes, for all our systems and that includes our Collection and Bank Reconciliation system which will be the source for the said project. > If your dba can create a table in oracle, > for_notification, which contains: > > transaction_id, > tin, > email address, > date payment was received, > amount received, > receiving branch, > status > > and for each transaction received, insert a row with > the columns of the table filled up, it's a simple > perl script using DBI::Oracle running on a linux box > that grabs all rows with 'status = 0' (0 = pending, > 1 = sent), and create a form letter, fill in the > information from the row, and send it off via > Mail::Sender. This is a good idea! =) So in short, We'll just make a Perl script in our Red Hat Linux machine that will grab/get the info from the Oracle database. My question is, does our Oracle database which uses Solaris on Sparc Machines need to have Perl installed? If it's yes then we don't have Perl in all our existing systems. > This doesn't even need postfix, What do you mean? How can we notify the taxpayers that the BIR was able to received their tax payments? > although if you want to keep the TIN/EMAIL address > lookup db in a separate database, you can store it > on a mysql or pgsql db, and have postfix access it > directly as an alias map. Well, if your first suggestion really favors in our existing system, that Perl is not necessary to be installed in our Sparc machines which contains our Oracle database and Solaris, but only in our Red Hat Linux machine, then we'll go for your first suggestion. Thanks Ian. You're the man! =) --- MARVIN T. PASCUAL E-Mail: [EMAIL PROTECTED] Tel. #: (+63-2) 925-2053/981-7068 Mobile #: (+62-919) 314-1254 Linux User No. 247147
BEGIN:VCARD VERSION:2.1 N:Pascual;Marvin T. FN:Marvin T. Pascual ORG:Bureau of Internal Revenue;Information Systems Development Service TITLE:Information Systems Analyst 1 TEL;WORK;VOICE:9252052 TEL;WORK;VOICE:9817022 TEL;HOME;VOICE:9293952 TEL;PREF:9252052 ADR;WORK:;Systems Maintenance and Support Division;#14 Makadios Street, Sikatuna Village;Quezon City;;1101;Philippines LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Systems Maintenance and Support Division=0D=0A#14 Makadios Street, Sikatuna = Village=0D=0AQuezon City 1101=0D=0APhilippines EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20020423T181951Z END:VCARD
