You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by ARays <ar...@kenfuse.com> on 2009/08/11 19:47:11 UTC
Order Manager - Audit trail
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.
Re: Order Manager - Audit trail
Posted by ARays <ar...@kenfuse.com>.
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.
>>
>
>
>
--
View this message in context: http://www.nabble.com/Order-Manager---Audit-trail-tp24922448p25005258.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Order Manager - Audit trail
Posted by Vikas Mayur <vi...@hotwaxmedia.com>.
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.
>
Re: Order Manager - Audit trail
Posted by ARays <ar...@kenfuse.com>.
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.
Re: Order Manager - Audit trail
Posted by Vikas Mayur <vi...@hotwaxmedia.com>.
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.
>
Re: Order Manager - Audit trail
Posted by ARays <ar...@kenfuse.com>.
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.
>
>
>
--
View this message in context: http://www.nabble.com/Order-Manager---Audit-trail-tp24922448p24996314.html
Sent from the OFBiz - User mailing list archive at Nabble.com.