View Single Post
Old 04-02-2009, 04:43 PM   #35
Moonliner
8/30/14 - Disneyland -10k or Bust.
 
Moonliner's Avatar
 
Join Date: Jan 2005
Posts: 9,022
Moonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of cool
Send a message via AIM to Moonliner Send a message via MSN to Moonliner Send a message via Yahoo to Moonliner
Quote:
Originally Posted by Kevy Baby View Post
It is not an issue with the data: I need to be able to see when the data has changed after being entered. Note that I cannot control the data (I export it from a legacy system into an Excel file to download).

The recent issues was when the Delivery Appointment date was originally set for 3/26/09 and was entered as such. Due to weather delays, the Delivery Appointment was delayed until 3/30/09. Unfortunately, since I only look for new data, I did not see that they had changed the date (which, as you might guess, is a problem).
So my question is, do the log files as currently created include these edited records?

If No: Then you need to re-write the log file generator. Hopefully, in addition to the date_created field (I assume that's what you are looking at the create the log file) there is also some type of date_changed or date_updated field.

If Yes: Then you need to rewrite your import routine to allow for these new records.
__________________
- Taking it one step at a time.
Moonliner is offline   Submit to Quotes Reply With Quote