On list is cool - I don't mind sharing some things with the others.
I have an order entry system I have created for a customer, it's a very
active little system. Access 97 on the front-end, SQL 7 on the back-end.
The system has been in place for over a year, and work perfect. Recently
(as you know), we installed iMS and it's running as their 1 and only
internal mail server - they are happy with it (I need to speed up the pop
mail retrieval process though).
An order goes through multiple processes - from NEW ORDER, to IN PROCESSING,
to BUILDING, to COMPLETED. There are a few other order status' too, but I
won't bore you with this info.
The plan for this com object in SQL is this (which will work perfectly now).
When an order is placed into IN PROCESSING (meaning it was accepted with
good CC information), a Thank You email will be automatically sent to the
user - this will happen as a result of a trigger being fired. The trigger
will call the stored procedure.
Then, another trigger will fire when the status is updated to COMPLETED -
this email would tell the user Thanks again, and that their order is being
shipped.
Furthermore, the emails will have a special reply-to address. If they reply
to the message for help, a customer service record will be automatically
generated and placed in the "Customer Service" system - this way management
can track how timely the customer service people are handling email support.
Of course, the triggers compare the previous order status, to the current
order status - and it also evaluates some key dates in the record, so the
user can get over burdened with emails - max of 2 per order (for now, hehe).
Now, that's the process - but why do it all via the database?
There is only 1 database for everything (like a good system should have).
The order entry app, the web order entry, the processing software, and a few
other misc. apps - and all of these apps can modify and update the orders.
The processing application was written in C, I don't *C*, however, the
processing system makes the orders COMPLETE - so really, I just added cool
email confirmation to the processing system, without touching 1 line of code
in the other persons app.
General steps involved in this whole email confirmation system:
- Create stored procedure to send email
- Create trigger on Orders table, on UPDATE only (don't care about insert or
delete records)
I'll be sending a new stored procedure later today to the list, it'll be
jsut the one for sending email, my trigger no one can see :-P
Any questions - fire away.
Tom
----- Original Message -----
From: Howie Hamlin <[EMAIL PROTECTED]>
To: inFusion Support List <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 12:03 AM
Subject: Re: [iMS] ODSMIME COM Object
> Great. Could you maybe give me a better idea of the system you're
building
> (off-list if you prefer).
>
> Regards,
>
> Howie
>
> ----- Original Message -----
> From: "Tom Langer" <[EMAIL PROTECTED]>
> To: "inFusion Support List" <[EMAIL PROTECTED]>
> Sent: Friday, January 12, 2001 12:22 AM
> Subject: Re: [iMS] ODSMIME COM Object
>
>
> > works jsut perfect..
> >
> > thanks
> >
> > Tom
> >
>
>
>
> ========================================================================
> This list server is Powered by iMS
> 'The Swiss Army Knife of Mail Servers'
> --------------------------------------
> To leave this list please complete the form at
> http://www.coolfusion.com/iMSSupport.cfm
> Need an iMS Developer license? Sign up for a free license here:
> http://www.coolfusion.com/iMSDevelopers.cfm
> List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> ========================================================================
>
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
