Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 6 of 6

Thread: Tracking changes to a product

  1. #1
    jeffm is offline Junior Member
    Join Date
    Aug 2012
    Posts
    2

    Default Tracking changes to a product

    hey guys. Want to see if you have figured out, or know of a way to see who has made the change to a product. Is this in the DB or on DNSF? We are able to see when the change was made, but not who made the change. Has anyone ever come across this issue?

  2. #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    There is not any built-in auditing on any of the tables for ASPDNSF. Also, I think you can only see when a record was originally created and not when it was last modified.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!

  3. #3
    donato is offline Senior Member
    Join Date
    Jun 2009
    Posts
    215

    Default

    I would like to know this as well...

  4. #4
    mmcgeachy is offline Senior Member
    Join Date
    Sep 2008
    Posts
    174

    Default

    Quote Originally Posted by donato View Post
    I would like to know this as well...
    know what exactly? If you mean getting the last update date that can be done through the triggers in the database. If you are wanting to audit who changed a product that is easier done in the code. Which is at least three places to track in the code. The product edit page, the import spreadsheets/xml, and changes done through WSI. The latter two require the source code to impalement properly.

  5. #5
    John Morrison is offline Junior Member
    Join Date
    Sep 2008
    Posts
    20

    Default

    9.3.1 adds an updatedon column and trigger to set it on a majority of the tables. Products included.

  6. #6
    rayhan16 is offline Junior Member
    Join Date
    Feb 2013
    Posts
    1

    Default Tracking changes to a product

    Thanks for your thread because i have a same question in my mind.