Order Manager - Audit trail

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Order Manager - Audit trail

aray
Hi All,

I have a requirement to show details of changes made to a submitted orders. Essentially audit trail of which user modified what, field by field. This would need to include change made to line items besides of course shipping details etc. In short all details linked to orderid.

Going through the Nabble archives found the thread below.

http://www.nabble.com/audit-trail-to9675210.html#a9675210

Q1: Was this implemented? While I am looking, thought would be useful if anyone can throw some pointers.

Q2: There would be an upstream system where the initial orders are posted. Till fulfillment orders would be tracked in ofbiz and sent back to the up stream system for invoicing and financials. Any suggested design approaches to achieve this? I am thinking of a cron job to dump the order data from up stream system using some standard EDI format and update Ofbiz order tables. Once fulfilled do the same other way around. That still leaves the situation where changes are made on both systems which may conflict.

Thanks in advance
- Aray
Reply | Threaded
Open this post in threaded view
|

Re: Order Manager - Audit trail

Vikas Mayur-3
This can be achieved using enable-audit-log feature - http://svn.apache.org/viewvc?view=rev&revision=652226

Example Implementation can be found at http://svn.apache.org/viewvc?view=rev&revision=778406

Vikas

On Aug 11, 2009, at 11:17 PM, ARays wrote:

>
> Hi All,
>
> I have a requirement to show details of changes made to a submitted  
> orders.
> Essentially audit trail of which user modified what, field by field.  
> This
> would need to include change made to line items besides of course  
> shipping
> details etc. In short all details linked to orderid.
>
> Going through the Nabble archives found the thread below.
>
> http://www.nabble.com/audit-trail-to9675210.html#a9675210
>
> Q1: Was this implemented? While I am looking, thought would be  
> useful if
> anyone can throw some pointers.
>
> Q2: There would be an upstream system where the initial orders are  
> posted.
> Till fulfillment orders would be tracked in ofbiz and sent back to  
> the up
> stream system for invoicing and financials. Any suggested design  
> approaches
> to achieve this? I am thinking of a cron job to dump the order data  
> from up
> stream system using some standard EDI format and update Ofbiz order  
> tables.
> Once fulfilled do the same other way around. That still leaves the  
> situation
> where changes are made on both systems which may conflict.
>
> Thanks in advance
> - Aray
> --
> View this message in context: http://www.nabble.com/Order-Manager---Audit-trail-tp24922448p24922448.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Reply | Threaded
Open this post in threaded view
|

Re: Order Manager - Audit trail

aray
Thanks Vikas. This is very close to what I was looking for.

Any suggestions towards Q2 in my previous note? I have looked at the csv file import utility under webtools, but looking for something more sophisticated. Considering couple of options including making direct jdbc calls to remote db to push and pull things realtime.

- Aray

Vikas Mayur-3 wrote
This can be achieved using enable-audit-log feature - http://svn.apache.org/viewvc?view=rev&revision=652226

Example Implementation can be found at http://svn.apache.org/viewvc?view=rev&revision=778406

Vikas

On Aug 11, 2009, at 11:17 PM, ARays wrote:

>
> Hi All,
>
> I have a requirement to show details of changes made to a submitted  
> orders.
> Essentially audit trail of which user modified what, field by field.  
> This
> would need to include change made to line items besides of course  
> shipping
> details etc. In short all details linked to orderid.
>
> Going through the Nabble archives found the thread below.
>
> http://www.nabble.com/audit-trail-to9675210.html#a9675210
>
> Q1: Was this implemented? While I am looking, thought would be  
> useful if
> anyone can throw some pointers.
>
> Q2: There would be an upstream system where the initial orders are  
> posted.
> Till fulfillment orders would be tracked in ofbiz and sent back to  
> the up
> stream system for invoicing and financials. Any suggested design  
> approaches
> to achieve this? I am thinking of a cron job to dump the order data  
> from up
> stream system using some standard EDI format and update Ofbiz order  
> tables.
> Once fulfilled do the same other way around. That still leaves the  
> situation
> where changes are made on both systems which may conflict.
>
> Thanks in advance
> - Aray
> --
> View this message in context: http://www.nabble.com/Order-Manager---Audit-trail-tp24922448p24922448.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: Order Manager - Audit trail

BJ Freeman
In reply to this post by aray
Your best bet is get familiar with ofbiz entities and how they work.
I will give a response but it will not make much sense with out that
knowledge.
there are entities that have last modified by.
you can use SECA to intercept a transaction and do something with it for
you audit trail.

To your second question:
By setting up an external DB through the entityengine.xml then assign a
delegator to it you can then communicate with DB's that are not part of
ofbiz.
You will have to generate the Entities for the new DB first.

Then going back to the SECA you can have them send your audit info to
the external db.

that are docs that cover all this, just not in a way that shows you step
by step how to accomplish it.


My joke is
it is anything a 5yr can do with 20 years experience.

ARays sent the following on 8/11/2009 10:47 AM:

> Hi All,
>
> I have a requirement to show details of changes made to a submitted orders.
> Essentially audit trail of which user modified what, field by field. This
> would need to include change made to line items besides of course shipping
> details etc. In short all details linked to orderid.
>
> Going through the Nabble archives found the thread below.
>
> http://www.nabble.com/audit-trail-to9675210.html#a9675210
>
> Q1: Was this implemented? While I am looking, thought would be useful if
> anyone can throw some pointers.
>
> Q2: There would be an upstream system where the initial orders are posted.
> Till fulfillment orders would be tracked in ofbiz and sent back to the up
> stream system for invoicing and financials. Any suggested design approaches
> to achieve this? I am thinking of a cron job to dump the order data from up
> stream system using some standard EDI format and update Ofbiz order tables.
> Once fulfilled do the same other way around. That still leaves the situation
> where changes are made on both systems which may conflict.
>
> Thanks in advance
> - Aray

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.

Reply | Threaded
Open this post in threaded view
|

Re: Order Manager - Audit trail

aray
Thanks.. Yes, realize there is lot of catching up to do on the framework before all of these make sense. Nevertheless these are very valuable inputs. Atleast now I know what to look out for and which way to head ;-)

- Aray

BJ Freeman wrote
Your best bet is get familiar with ofbiz entities and how they work.
I will give a response but it will not make much sense with out that
knowledge.
there are entities that have last modified by.
you can use SECA to intercept a transaction and do something with it for
you audit trail.

To your second question:
By setting up an external DB through the entityengine.xml then assign a
delegator to it you can then communicate with DB's that are not part of
ofbiz.
You will have to generate the Entities for the new DB first.

Then going back to the SECA you can have them send your audit info to
the external db.

that are docs that cover all this, just not in a way that shows you step
by step how to accomplish it.


My joke is
it is anything a 5yr can do with 20 years experience.

ARays sent the following on 8/11/2009 10:47 AM:
> Hi All,
>
> I have a requirement to show details of changes made to a submitted orders.
> Essentially audit trail of which user modified what, field by field. This
> would need to include change made to line items besides of course shipping
> details etc. In short all details linked to orderid.
>
> Going through the Nabble archives found the thread below.
>
> http://www.nabble.com/audit-trail-to9675210.html#a9675210
>
> Q1: Was this implemented? While I am looking, thought would be useful if
> anyone can throw some pointers.
>
> Q2: There would be an upstream system where the initial orders are posted.
> Till fulfillment orders would be tracked in ofbiz and sent back to the up
> stream system for invoicing and financials. Any suggested design approaches
> to achieve this? I am thinking of a cron job to dump the order data from up
> stream system using some standard EDI format and update Ofbiz order tables.
> Once fulfilled do the same other way around. That still leaves the situation
> where changes are made on both systems which may conflict.
>
> Thanks in advance
> - Aray

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.
Reply | Threaded
Open this post in threaded view
|

Re: Order Manager - Audit trail

Vikas Mayur-3
In reply to this post by aray
Look at the specialpurpose/oagis component to see how information is  
shared/sync using B2B integration.

Vikas

On Aug 16, 2009, at 10:29 PM, ARays wrote:

>
> Thanks Vikas. This is very close to what I was looking for.
>
> Any suggestions towards Q2 in my previous note? I have looked at the  
> csv
> file import utility under webtools, but looking for something more
> sophisticated. Considering couple of options including making direct  
> jdbc
> calls to remote db to push and pull things realtime.
>
> - Aray
>
>
> Vikas Mayur-3 wrote:
>>
>> This can be achieved using enable-audit-log feature -
>> http://svn.apache.org/viewvc?view=rev&revision=652226
>>
>> Example Implementation can be found at
>> http://svn.apache.org/viewvc?view=rev&revision=778406
>>
>> Vikas
>>
>> On Aug 11, 2009, at 11:17 PM, ARays wrote:
>>
>>>
>>> Hi All,
>>>
>>> I have a requirement to show details of changes made to a submitted
>>> orders.
>>> Essentially audit trail of which user modified what, field by field.
>>> This
>>> would need to include change made to line items besides of course
>>> shipping
>>> details etc. In short all details linked to orderid.
>>>
>>> Going through the Nabble archives found the thread below.
>>>
>>> http://www.nabble.com/audit-trail-to9675210.html#a9675210
>>>
>>> Q1: Was this implemented? While I am looking, thought would be
>>> useful if
>>> anyone can throw some pointers.
>>>
>>> Q2: There would be an upstream system where the initial orders are
>>> posted.
>>> Till fulfillment orders would be tracked in ofbiz and sent back to
>>> the up
>>> stream system for invoicing and financials. Any suggested design
>>> approaches
>>> to achieve this? I am thinking of a cron job to dump the order data
>>> from up
>>> stream system using some standard EDI format and update Ofbiz order
>>> tables.
>>> Once fulfilled do the same other way around. That still leaves the
>>> situation
>>> where changes are made on both systems which may conflict.
>>>
>>> Thanks in advance
>>> - Aray
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Order-Manager---Audit-trail-tp24922448p24922448.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Order-Manager---Audit-trail-tp24922448p24995595.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Reply | Threaded
Open this post in threaded view
|

Re: Order Manager - Audit trail

aray
In reply to this post by Vikas Mayur-3
Hi Vikas,

I checked out the issue http://svn.apache.org/viewvc?view=rev&revision=778406 that you referred. Does most of what I was looking for and should be able to extend. Now looks like this is available only in the trunk while I started with 9.04 as the stable branch? So, I know this is going to be situational, but since I haven't progressed much is it better to move to trunk or move the relevant changes to 9.04. For my requirement, I just need order management and anything essential to make it work.

Also I see a feature to show  "Item Unit Price History" but changes made to unit price through order item edit does not seem to take effect. Is that a bug? If it is then I would be happy to work on it and hope to pick some ofbiz understanding.

Thanks in advance
Aray


Vikas Mayur-3 wrote
This can be achieved using enable-audit-log feature - http://svn.apache.org/viewvc?view=rev&revision=652226

Example Implementation can be found at http://svn.apache.org/viewvc?view=rev&revision=778406

Vikas

On Aug 11, 2009, at 11:17 PM, ARays wrote:

>
> Hi All,
>
> I have a requirement to show details of changes made to a submitted  
> orders.
> Essentially audit trail of which user modified what, field by field.  
> This
> would need to include change made to line items besides of course  
> shipping
> details etc. In short all details linked to orderid.
>
> Going through the Nabble archives found the thread below.
>
> http://www.nabble.com/audit-trail-to9675210.html#a9675210
>
> Q1: Was this implemented? While I am looking, thought would be  
> useful if
> anyone can throw some pointers.
>
> Q2: There would be an upstream system where the initial orders are  
> posted.
> Till fulfillment orders would be tracked in ofbiz and sent back to  
> the up
> stream system for invoicing and financials. Any suggested design  
> approaches
> to achieve this? I am thinking of a cron job to dump the order data  
> from up
> stream system using some standard EDI format and update Ofbiz order  
> tables.
> Once fulfilled do the same other way around. That still leaves the  
> situation
> where changes are made on both systems which may conflict.
>
> Thanks in advance
> - Aray
> --
> View this message in context: http://www.nabble.com/Order-Manager---Audit-trail-tp24922448p24922448.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>