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 |
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. > |
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
|
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. |
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
|
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. > |
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
|
Free forum by Nabble | Edit this page |