- Design the database so that you can store order communications with
NULL-able orderid (AKA orphans). Then build admin workflows to notify
admins of order communications in this state and allow them to de-orphanize
them. (You might want to include auto-purge orphans after X days logic.
Further, you may want to look into spam-protecting this email box
"upstream" of CF so that you can reduce the amount of garbage inserted into
your DB.)
- Develop the scheduled task so that, when order communications arrive in
this state, auto-reply to end-user with helpful "missing order number"
email. Make it so that end-user can reply to *that* message with
corrected order number to de-orphanize original order communication.
On Thu, Apr 28, 2011 at 8:19 PM, Pete Ruckelshaus <[email protected]>wrote:
>
> Well, what I'm thinking is to have a specific email address that would get
> checked by the app via a scheduled task using cfpop. Order number would be
> in the subject, grab the body of the email and dump it into the order
> communications table with the timestamp coming from the email.
>
> The point for potential problems is if the wrong order number is put in the
> subject field. I'm sure there are more, but that's the one that worries
> me.
>
> On Thu, Apr 28, 2011 at 8:45 PM, John M Bliss <[email protected]>
> wrote:
>
> >
> > I have. Having trouble thinking of generalities/gotchas to share with
> you.
> > Can you think of any more specific questions?
> >
> > On Thu, Apr 28, 2011 at 7:41 PM, Pete Ruckelshaus <
> [email protected]
> > >wrote:
> >
> > >
> > > I'm in the planning stages of building an industry-specific (think
> along
> > > the
> > > lines of limited production and custom bicycle frames) customer service
> > > application. Much of the communication between customer and crafstman
> is
> > > meant to be via a web interface, but I'd also like to allow
> communication
> > > via email, but have the contents of those emails be culled from a
> > specific
> > > email address and added to the customer record.
> > >
> > > What I'm wondering is if anyone here has done this sort of content
> update
> > > via email, and what suggestions you would have for approach and
> > > architecture?
> > >
> > > Thanks
> > >
> > > Pete
> > >
> > >
> > >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344044
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
