Excel Question #46

Kevy Baby · 04-02-2009, 04:05 PM

Quote:

Originally Posted by Moonliner

If I read this correctly, It sounds like an issue with the export. Does the daily log you receive include these records that were updated, or just ones that were created since the last log was created?

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).

Moonliner · 04-02-2009, 04:43 PM

Quote:

Originally Posted by Kevy Baby

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.

Drince88 · 04-04-2009, 10:46 AM

WAY outside the box and cludgy, but maybe it will trigger your creative juices for a better fix.

Have two versions of the formatted worksheet in a workbook. Put the new data in 'sheet 2' and have it conditionally formatted to turn red (or whatever) when the data does not equal the same data in sheet 1, which was the previous version of the data.

04-04-2009, 10:46 AM	#3
Drince88 Senior Member Join Date: May 2005 Posts: 481	WAY outside the box and cludgy, but maybe it will trigger your creative juices for a better fix. Have two versions of the formatted worksheet in a workbook. Put the new data in 'sheet 2' and have it conditionally formatted to turn red (or whatever) when the data does not equal the same data in sheet 1, which was the previous version of the data.
	Submit to Quotes