Don Panek

I have a requirement for a nightly job consuming a flat file of data. The file cannot and does not contain any timestamp or flag indicating changes. Does anyone know of a way to determine if anything changed without just processing the entire file each time Can I generate a HASH on the entire row

Wow I did not know that so thanks a bunch! That will come in handy :)

I think it would be a great addition if we could add the ability to add notes to field level mappings. This would be very handy for documenting why a field was mapped or what a particular formula is doing for that field mapping. This is not always apparent especially when reviewing somone elses code and designs.

Hi All. A client is having a very odd problem with fetch block in a map. Here is scenario - the connection is D365 Fetch appointments where owner = x and actualclosedate > yesterday -1day and actualclosedate < yesterday +1 day (trying to generate a report that pulls all appointments closed on yesterday. When I look at debug, the queries all look right, yet the fetch only returns 1 record when there are actually 4 in D365 An advanced find in D365 for appointments where owner = x and actualclosedate = yesterday yields 4 records as it should. Anyone have any similar issues Apparently using the formula of actualclosedate = yesterday doesnt work, hence the greater than and less than Seems like no matter what formula we use the result of the fetch is not accurate. Any help would be appreciated. Thanks Don