L_UpdateDate is triggered when images added/deleted

URL: https://ranwmls-rets.paragonrels.com/... 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.

Tony

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

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

Sort by

oldest

newest

most voted

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.

bwolven

answered 2017-06-07 18:57:24 -0500, updated 2017-06-29 17:59:46 -0500

edit flag offensive 0 remove flag delete link

Comments

Thank you Bruce

Tony (2017-06-07 19:06:28 -0500) edit

add a comment see more comments

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.

bscdata

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

edit flag offensive 0 remove flag delete link

Comments

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 (2017-07-10 08:40:51 -0500) edit

add a comment see more comments

L_UpdateDate is triggered when images added/deleted edit

Comments

2 Answers

Comments

Comments