Track data modifications

Answers

• Options

  PerJuhl Member Posts: 55

  2016-02-16 Answer ✓

  I a standard NAV solution how many jobs modify master data ?
  
  So I would say change log is your best option.

  5
• Options

  PConijn Member Posts: 31

  2016-04-06

  The change log is indeed flawed, as it does not detect e.g. MODIFY(FALSE). I have been pondering the same issue. In an older version of NAV (2009), I solved it by calculating and storing the MD5 hash value of the text value of the records using a .NET automation I had created and stored it in a Delta table. It looked a bit like this (the code below is improvised, so please forgive any missing semi-colons):
  

  REPEAT
    lrrTable.GETRECORD(lrecMyRecord);
    lridRecord := lrrTable.RECORDID;
    ltxtHashValue := lautHash.CalcMD5(FORMAT(lrecMyRecord));
    
    IF NOT lrecHashTable.GET(lridRecord) THEN BEGIN
      lrecHasTable.INIT;
      lrecHashTable."Record ID" := lridRecord;
      lrecHashTable."Table No." := lrrTable.TABLENO;
      lrecHashTable."Record Hash Value" := ltxtHashValue;
      lrecHashTable."Record Modified" := TRUE;
      lrecHashTable.INSERT; 
    END ELSE BEGIN
      IF lrecHashTable."Record Hash Value"  <> ltxtHasValue THEN BEGIN
        lrecHashTable."Record Modified" := TRUE;
        lrecHashTable."Record Hash Value" := ltxtHashValue;
        lrecHashTable.MODIFY;
      END;
    END;
  UNTIL lrecMyRecord.NEXT = 0;
  

  
  The web service then retrieves all the records that have been flagged as modified, stores them in a temporary table and sends those records over; the "Record Modified" flag in the hash table is set to FALSE once successful receipt has been confirmed by the recipient.
  
  The method works well (though not perfectly) in principle, but it takes up a sizeable bit of processing power and, in NAV2009, the risk of running into the maximum length of the string buffer.
  
  
  I am now looking to build the interface into a NAV2015 environment and, like Fommo, I am wondering if there is perhaps a better and more efficient way to detect all changes in a record, regardless of whether the Modify trigger fired.
  
  Any ideas would be more than welcome.
  
  
  Fommo, can you enlighten me a bit on your TimeStamp method?

  Kind Regards,
  
  Peter Conijn
  
  -The Learning Network-
  
  

  0
• Options

  PConijn Member Posts: 31

  2016-04-06 edited 2016-04-06

  I have read and verified that the SQL Timestamp field is easily exposable in NAV2016 (https://msdn.microsoft.com/en-us/library/dn951475(v=nav.90).aspx) - unfortunately, that won't help me in NAV2015

  Kind Regards,
  
  Peter Conijn
  
  -The Learning Network-
  
  

  0