RE: RPG CGI

["Art Tostaine, Jr." <artjr@xxxxxxxxxxx>]

We do exactly what you are talking about, except we didn't use API's.  Every five minutes we do a DSPLNK to a spool file, read the spool file for new emails, then use CPYFRMSTMF to a database file.  We process that with an RPG program.

 

We ignore all of the email, we just look for the beginning string of our file then begin.

 

You can see users email's in /QTCPTMM/MAIL/USER/*

 

Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On Behalf Of tomh@simas.com
Sent: Wednesday, March 14, 2001 7:36 AM
To: RPG400-L@midrange.com
Subject: RE: RPG CGI

The boss was pitching an idea to the customer, the idea being that he (the customer) could send us the file in either of two ways: 1) as an attached Excel spreadsheet, and/or 2) as an email message.  

I was finally able to convince him that a better file format would be ASCII text, comma-delimited so that we could do just as you suggest - FTP the file into our databases (incidentally, this is exactly what we do for other stuff).

I have a feeling, though, that the email option will remain.  Having said that - do you have an RPGLE example or two of how to read thru an email?

"Bartell, Aaron L. (TC)" <ALBartell@taylorcorp.com> Sent by: owner-rpg400-l@midrange.com 03/13/01 05:46 PM Please respond to RPG400-L

To:        "'RPG400-L@midrange.com'" <RPG400-L@midrange.com>         cc:                 Subject:        RE: RPG CGI

If you  are going to use email, which isn't what I would call a reliable EDI method,  have them send the inventory update in an attached file and then read through  that for the particular items that you need to update.  This is just my  first thought.  I don't think one would want to parse through the  actual email including all of the header information.  Ask him if he has  the capability to FTP then you could just have him FTP to your machine and PUT a  file in the IFS that contains the inventory updates.
 
But to  answer you question in short, yes you can use the read() C API function in an  RPG pgm. 
 
Aaron  Bartell
-----Original Message-----
From: tomh@simas.com  [mailto:tomh@simas.com]
Sent: Tuesday, March 13, 2001 4:13  PM
To: rpg400-l@midrange.com
Subject: RPG  CGI



We use our 400 as an  SMTP and POP3 server. Can I use APIs to read thru the body of some emails,  extracting some information?  We have a customer who'd like to send us  inventory updates in an email.