popeye
21st January 2005, 01:53
Hi,
We are sending out POs via email to our suppliers.
These are sent from one common email account say
purchasing@company.com

To acknowledge the PO, the Suppliers just press the "reply" button.

Then the buyers access this email and update the PO acknoledment
details (PO#, Supplier, Date).

Now they want this update (to Baan) happen automatically.
So basically I'll have to read the email message to extract the info
(which is present in the subject).

I was thinking of someway to read the email and create a text file
which can be read by a Baan session.

How do I create this txt file from the email message?
Thanks,
Popeye

norwim
21st January 2005, 10:17
Hi there,

some info on your OS would indeed have been useful here.
If you have a local mailhost that is a unix machine, the solution is very simple.
In most unix-flavours the mail for user XYZ will be put to a file /var/spool/mail/XYZ. Nothing keeps you from creating a script, that sleeps some seconds, then compares this file with the latest image from it, processes the new lines (scans for the signalling subject lines or whatever), creates a textfile if necessary, creates a new image and goes to sleep again.
If your mailhost runs at your providers site or on a Microsoft-box, you can still have the account for XYZ on a unix (linux?) box and poll the mailhost with fetchmail ... rest see above.

There will be possibilities to solve this on M$-systems too, but who cares....

hth

Norbert

~Vamsi
21st January 2005, 19:06
Popeye,

If I remember correctly you use Streamserve. There is a connector in Streamserve to read and process email. In the documentation it is referred to as "mail input connector".