Full Change Log

nav_nav
nav_nav Member Posts: 33
edited 2006-12-19 in NAV/Navision Classic Client
Hi,

Is there any way (customisation probably) to have the system logg ALL changes ?
A datawarehouse application is looking for an incremental upload. The timestamp on SQL is not a valid option since they want to be able to select all changed lines since the last upload.
Standard change log only logs user changes. Is there any way to assure you log ALL changes (system changes included) ?

Thanks

Comments

  • garak
    garak Member Posts: 3,263
    If you need the informations about modifications create through reports or Codeunits, you must develop it self. Take a look into cu 1 an changelog. You must call the functions from your codeunits or reports.

    An other way is, if you use sql Server, to create an function on sql server which shows you all changes to an date / time.

    Regards
    Do you make it right, it works too!
  • nav_nav
    nav_nav Member Posts: 33
    - I know you could create some functions in codeunit 1, but that only triggers user changes. If you would use the developers toolkit to check where the modify is called without true...
    - a function on sql server is interesting. Can you do that without loosing your code each time you compile your object or install a new fob ?
  • garak
    garak Member Posts: 3,263
    To the second. Yes you can do this.

    I'fe create that in sql. But i doesn't need all navision tables. So i've specific which tables the function should search trough. And the search job is at night (after Maintenance jobs).

    For Reporting you can use navision or sql features (like Report Services in 2005)

    Regards
    Do you make it right, it works too!
  • nav_nav
    nav_nav Member Posts: 33
    Could you please post exactly what you did ? According to MBS this is not possible.

Categories