Day 31 - History Log

Well, here is my first blog entry post 30-day challenge deadline. I had a look at the statistics for yesterday and there was a spike to the number of visitors. I take it as an indicator to the number of people following the progress of the 30 day challenge.

One thing I can say though is that suddenly the pressure has lessened considerably, although the next deadline is set for the end of this month (July 2008). I envision that by the end of this month I shall be able to release version 1.0 of misvCRM.

One feature that I implemented is the history log. This is a table where the entries are the changes in the values of the different fields of the other tables. From this table you can follow the values that a specific field has assumed e.g. email address. Using the history log, you can track the changes in email address that a client may have had which you can then use to retrieve previous communication records.

In order to be able to establish the chronological order of the changes, each record has its own timestamp.  From the image above you can see that the email address has been changes twice as well as the address details.

This log can also come in handy when looking at the pricing history for a product. In the network version the userid of the person who did the update will also be shown so that if there are issues you know the person to go to.

If you have any other idea on how to improve the history logging feel free to tell me. Till next time.