Ask Your Question

L_UpdateDate is triggered when images added/deleted

asked 2017-06-07 14:09:42 -0600

URL: User iCheck

Description: RANW MLS would like iCheck to send email notifications to members anytime a listing has been modified, but only when data in the listing has changed, not when only a photo was added or deleted.

Issue: It appears when a photo is added or deleted by the a member or BNFS process it triggers both the Listings Modified Time Stamp (L_UpdateDate) and the Image Modified Time Stamp (L_Last_Photo_updt). Additionally when a photo is added or deleted, the Listing’s Image Count (L_PictureCount) is changed which may be why Listings Modified Time Stamp (L_UpdateDate) is updated.

The problem: iCheck is using the Listings Modified Time Stamp (L_UpdateDate) to detect when the listing (data) has been modified in order to send the email notifications. Resulting in emails being sent when only a photo has been modified by a member or BNFS.

Possible Remedies/work-around: 1. BNFS advise iCheck if there is a different RETS timestamp field to use to detect when only listing’s data has changed (excluding L_ PictureCount)? 2. When a photo is added or deleted BNFS stop triggering a Listings Modified Time Stamp (L_UpdateDate) and only trigger an Image Modified Time Stamp (L_Last_Photo_updt).

Side note: In RANW MLS’s metadata Table the ModTimeStamp column is set to false for all fields, it should be set to true for any field that triggers the ModfiedTime Stamp Change.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-06-07 18:57:24 -0600

updated 2017-06-29 17:59:46 -0600

Looking into the issue.

2017-06-29 Update: It does appear that the L_UpdateDate value is updated when photo counts change. Not sure about a solution to your particular issue where you need to know when data changes but not photos or photo count.

edit flag offensive delete link more


Thank you Bruce

Tony gravatar imageTony ( 2017-06-07 19:06:28 -0600 )edit

answered 2017-07-07 10:27:38 -0600

i feel your pain. what i do is use i filter my list to find

$new ="and (createtime >= '$date_today' or DatePriceChange >= '$date_today')"; the createtime is the L_ListingDate received from paragon. and DatePriceChange is all ready there.

i then update my email table with the current time in a field that i use to find only the ones that have not been updated since last email sent and the time of day is later than that time-stamp. so i can send multiple times per day without duplicates.

the DatePriceChange and L_ListingDate do not give a time. only the date. so i need the double check.

edit flag offensive delete link more


Thank you for the update. DatePriceChange would not be part of the logic we use. While sending of an email is the final process, the logic we are looking for is to exclude selecting the listing before an email is sent when only an image was added or deleted.

Tony gravatar imageTony ( 2017-07-10 08:40:51 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-07 14:09:42 -0600

Seen: 2,903 times

Last updated: Jul 07 '17