Automated Order Fulfillment integration via mail-exchange - any experience out there?

[c.schinzer]

Hello,


I am asked to integrate with a mailing mechanism for order fulfillment, ie.
Supplier wants mails sent when orders are being confirmed with OBFiz. At the
same time I will be getting a nightly confirmation and status information
from Supplier over all pending orders by mail as an attachment.

While I have ideas for full automation about the former (define ECA, write
service, send mail) I am not so sure about the latter.
In principle I would follow the same logic, ie. define ECA, store file
attachment, process it and update the orders. The questions I would have are
as follows::

- I would use a OFBiz-managed mail account to receive mail; how do I
integrate OFBiz with my mailing architecture for mail reception ? Probably
some config somewhere in the framework?
- How can I use the mail-received event and translate to an ECA ?
- How do I detach the file attachment, store it and process it ? Are all
required tools on board with OFBiz?

If anyone has made relevant experience or has done the same thing already, I
would appreciate some hints.
Thanks & regards


Carsten

[Jacques Le Roux]

Hi Carsten,

I have not implemented it yet, but I had to think about it once.

You need to use the MCA (for Mail Condition Action) mechanism. Look in smcas_test.xml for a simple example.
BJ who uses MCA, recommend to put Apache James in front and I also think it's a good idea to have more filter power (spam, etc.)

Jacques

From: "Carsten Schinzer" <[hidden email]>

> Hello,
>
>
> I am asked to integrate with a mailing mechanism for order fulfillment, ie.
> Supplier wants mails sent when orders are being confirmed with OBFiz. At the
> same time I will be getting a nightly confirmation and status information
> from Supplier over all pending orders by mail as an attachment.
>
> While I have ideas for full automation about the former (define ECA, write
> service, send mail) I am not so sure about the latter.
> In principle I would follow the same logic, ie. define ECA, store file
> attachment, process it and update the orders. The questions I would have are
> as follows::
>
> - I would use a OFBiz-managed mail account to receive mail; how do I
> integrate OFBiz with my mailing architecture for mail reception ? Probably
> some config somewhere in the framework?
> - How can I use the mail-received event and translate to an ECA ?
> - How do I detach the file attachment, store it and process it ? Are all
> required tools on board with OFBiz?
>
> If anyone has made relevant experience or has done the same thing already, I
> would appreciate some hints.
> Thanks & regards
>
>
> Carsten
>

[BJ Freeman]

I do a lot of Supply chain and Edi.
I make components per supplier since they do not use the same systems.
the component has the custom  email sent to the supplier.
I opt to use a xml file that uses a xsl to translate to the format they
use. the XML is a custom one I developed.
There is one MCA that reads emails from suppliers and directs them based
on the contact mech. It looks for a to address setup just for suppliers.

I put up some Jira way back on this, not complete but you can get the idea.
https://issues.apache.org/jira/browse/OFBIZ-1286
https://issues.apache.org/jira/browse/OFBIZ-121
https://issues.apache.org/jira/browse/OFBIZ-143

I also integrated OpenAS2 for EDI and work with a van that supplies the
mailboxes necessary.


I have examples of the supplier components of which I have some 70
suppliers, on my demo site.

I am tranfering my Forum over to my site you can read some info
http://www.businessesnetwork.com/control/forum?forumId=SUPPLYCHAIN


Carsten Schinzer sent the following on 6/22/2011 1:33 AM:

> Hello,
>
>
> I am asked to integrate with a mailing mechanism for order fulfillment, ie.
> Supplier wants mails sent when orders are being confirmed with OBFiz. At the
> same time I will be getting a nightly confirmation and status information
> from Supplier over all pending orders by mail as an attachment.
>
> While I have ideas for full automation about the former (define ECA, write
> service, send mail) I am not so sure about the latter.
> In principle I would follow the same logic, ie. define ECA, store file
> attachment, process it and update the orders. The questions I would have are
> as follows::
>
> - I would use a OFBiz-managed mail account to receive mail; how do I
> integrate OFBiz with my mailing architecture for mail reception ? Probably
> some config somewhere in the framework?
> - How can I use the mail-received event and translate to an ECA ?
> - How do I detach the file attachment, store it and process it ? Are all
> required tools on board with OFBiz?
>
> If anyone has made relevant experience or has done the same thing already, I
> would appreciate some hints.
> Thanks & regards
>
>
> Carsten
>

[c.schinzer]

Hi both,


thanks for the hints. I am receiving mails now.
Is there anything special to be said about shared OFBiz system, viz,
Tenant-based mail distribution ?
I see mails being registered as CommunicationEvents with the common
database, but not with the tenant's.

I though maybe there is a quick hint ... before I dig deep in mail services
;-)

Thanks again
Regards


Carsten


2011/6/22 BJ Freeman <[hidden email]>

> I do a lot of Supply chain and Edi.
> I make components per supplier since they do not use the same systems.
> the component has the custom  email sent to the supplier.
> I opt to use a xml file that uses a xsl to translate to the format they
> use. the XML is a custom one I developed.
> There is one MCA that reads emails from suppliers and directs them based
> on the contact mech. It looks for a to address setup just for suppliers.
>
> I put up some Jira way back on this, not complete but you can get the idea.
> https://issues.apache.org/jira/browse/OFBIZ-1286
> https://issues.apache.org/jira/browse/OFBIZ-121
> https://issues.apache.org/jira/browse/OFBIZ-143
>
> I also integrated OpenAS2 for EDI and work with a van that supplies the
> mailboxes necessary.
>
>
> I have examples of the supplier components of which I have some 70
> suppliers, on my demo site.
>
> I am tranfering my Forum over to my site you can read some info
> http://www.businessesnetwork.com/control/forum?forumId=SUPPLYCHAIN
>
>
> Carsten Schinzer sent the following on 6/22/2011 1:33 AM:
> > Hello,
> >
> >
> > I am asked to integrate with a mailing mechanism for order fulfillment,
> ie.
> > Supplier wants mails sent when orders are being confirmed with OBFiz. At
> the
> > same time I will be getting a nightly confirmation and status information
> > from Supplier over all pending orders by mail as an attachment.
> >
> > While I have ideas for full automation about the former (define ECA,
> write
> > service, send mail) I am not so sure about the latter.
> > In principle I would follow the same logic, ie. define ECA, store file
> > attachment, process it and update the orders. The questions I would have
> are
> > as follows::
> >
> > - I would use a OFBiz-managed mail account to receive mail; how do I
> > integrate OFBiz with my mailing architecture for mail reception ?
> Probably
> > some config somewhere in the framework?
> > - How can I use the mail-received event and translate to an ECA ?
> > - How do I detach the file attachment, store it and process it ? Are all
> > required tools on board with OFBiz?
> >
> > If anyone has made relevant experience or has done the same thing
> already, I
> > would appreciate some hints.
> > Thanks & regards
> >
> >
> > Carsten
> >
>

--

Best

Carsten Schinzer

Waisenhausstr. 53a
80637 München
Germany

[Jacques Le Roux]

No ideas sorry, I guess it's not handled yet

Jacques

Carsten Schinzer wrote:

> Hi both,
>
>
> thanks for the hints. I am receiving mails now.
> Is there anything special to be said about shared OFBiz system, viz,
> Tenant-based mail distribution ?
> I see mails being registered as CommunicationEvents with the common
> database, but not with the tenant's.
>
> I though maybe there is a quick hint ... before I dig deep in mail services
> ;-)
>
> Thanks again
> Regards
>
>
> Carsten
>
>
> 2011/6/22 BJ Freeman <[hidden email]>
>
>> I do a lot of Supply chain and Edi.
>> I make components per supplier since they do not use the same systems.
>> the component has the custom  email sent to the supplier.
>> I opt to use a xml file that uses a xsl to translate to the format they
>> use. the XML is a custom one I developed.
>> There is one MCA that reads emails from suppliers and directs them based
>> on the contact mech. It looks for a to address setup just for suppliers.
>>
>> I put up some Jira way back on this, not complete but you can get the idea.
>> https://issues.apache.org/jira/browse/OFBIZ-1286
>> https://issues.apache.org/jira/browse/OFBIZ-121
>> https://issues.apache.org/jira/browse/OFBIZ-143
>>
>> I also integrated OpenAS2 for EDI and work with a van that supplies the
>> mailboxes necessary.
>>
>>
>> I have examples of the supplier components of which I have some 70
>> suppliers, on my demo site.
>>
>> I am tranfering my Forum over to my site you can read some info
>> http://www.businessesnetwork.com/control/forum?forumId=SUPPLYCHAIN
>>
>>
>> Carsten Schinzer sent the following on 6/22/2011 1:33 AM:
>>> Hello,
>>>
>>>
>>> I am asked to integrate with a mailing mechanism for order fulfillment, ie.
>>> Supplier wants mails sent when orders are being confirmed with OBFiz. At the
>>> same time I will be getting a nightly confirmation and status information
>>> from Supplier over all pending orders by mail as an attachment.
>>>
>>> While I have ideas for full automation about the former (define ECA, write
>>> service, send mail) I am not so sure about the latter.
>>> In principle I would follow the same logic, ie. define ECA, store file
>>> attachment, process it and update the orders. The questions I would have are
>>> as follows::
>>>
>>> - I would use a OFBiz-managed mail account to receive mail; how do I
>>> integrate OFBiz with my mailing architecture for mail reception ? Probably
>>> some config somewhere in the framework?
>>> - How can I use the mail-received event and translate to an ECA ?
>>> - How do I detach the file attachment, store it and process it ? Are all
>>> required tools on board with OFBiz?
>>>
>>> If anyone has made relevant experience or has done the same thing already, I
>>> would appreciate some hints.
>>> Thanks & regards
>>>
>>>
>>> Carsten

No ideas sorry, I guess it's not handled yet

Jacques

[BJ Freeman]

this is still doable as long as the the code the MCA calls works across
the tenants and each tenant has a different to address for each tenant.
 this is custom code, because of looking for a To address then lookiong
for contactmechics, you can use the original code and modify it.
since this is a system run code and can not be modified from users it is
safe to run across tenants.

Carsten Schinzer sent the following on 6/23/2011 7:17 AM:

> Hi both,
>
>
> thanks for the hints. I am receiving mails now.
> Is there anything special to be said about shared OFBiz system, viz,
> Tenant-based mail distribution ?
> I see mails being registered as CommunicationEvents with the common
> database, but not with the tenant's.
>
> I though maybe there is a quick hint ... before I dig deep in mail services
> ;-)
>
> Thanks again
> Regards
>
>
> Carsten
>
>
> 2011/6/22 BJ Freeman <[hidden email]>
>
>> I do a lot of Supply chain and Edi.
>> I make components per supplier since they do not use the same systems.
>> the component has the custom  email sent to the supplier.
>> I opt to use a xml file that uses a xsl to translate to the format they
>> use. the XML is a custom one I developed.
>> There is one MCA that reads emails from suppliers and directs them based
>> on the contact mech. It looks for a to address setup just for suppliers.
>>
>> I put up some Jira way back on this, not complete but you can get the idea.
>> https://issues.apache.org/jira/browse/OFBIZ-1286
>> https://issues.apache.org/jira/browse/OFBIZ-121
>> https://issues.apache.org/jira/browse/OFBIZ-143
>>
>> I also integrated OpenAS2 for EDI and work with a van that supplies the
>> mailboxes necessary.
>>
>>
>> I have examples of the supplier components of which I have some 70
>> suppliers, on my demo site.
>>
>> I am tranfering my Forum over to my site you can read some info
>> http://www.businessesnetwork.com/control/forum?forumId=SUPPLYCHAIN
>>
>>
>> Carsten Schinzer sent the following on 6/22/2011 1:33 AM:
>>> Hello,
>>>
>>>
>>> I am asked to integrate with a mailing mechanism for order fulfillment,
>> ie.
>>> Supplier wants mails sent when orders are being confirmed with OBFiz. At
>> the
>>> same time I will be getting a nightly confirmation and status information
>>> from Supplier over all pending orders by mail as an attachment.
>>>
>>> While I have ideas for full automation about the former (define ECA,
>> write
>>> service, send mail) I am not so sure about the latter.
>>> In principle I would follow the same logic, ie. define ECA, store file
>>> attachment, process it and update the orders. The questions I would have
>> are
>>> as follows::
>>>
>>> - I would use a OFBiz-managed mail account to receive mail; how do I
>>> integrate OFBiz with my mailing architecture for mail reception ?
>> Probably
>>> some config somewhere in the framework?
>>> - How can I use the mail-received event and translate to an ECA ?
>>> - How do I detach the file attachment, store it and process it ? Are all
>>> required tools on board with OFBiz?
>>>
>>> If anyone has made relevant experience or has done the same thing
>> already, I
>>> would appreciate some hints.
>>> Thanks & regards
>>>
>>>
>>> Carsten
>>>
>>
>
>
>