When an email is received from REA stating that a listing has failed, the only current way to re-load the listing is to correct the reason for the failure in ClickHome first

e.g. incorrectly spelt suburb

Then, after this is done the user must contact ClickHome support, providing them with the details of the listing and asking them to re-load it.


Steps for ClickHome support:


STEP #1

Go to the Product Library

Find the listing and the related records


There is a procedure created for the below a + b called 'prcResetHouseListingUpload' 

 

a.

select * from tblHouseListing

where idHouseListing = 88

 

select * from tblInclusion

where fkidHouseListing = 88

 

select * from tblLinkedDocument

where fkidHouseListing = 88

 

select * from tblhouselistingupload

where fkidhouselisting = 88

 

b.

 

Delete the records (listing last)

 

delete from tblInclusion

where fkidHouseListing = 88

 

delete from tblLinkedDocument

where fkidHouseListing = 88

 

delete from tblhouselistingupload

where fkidhouselisting = 88

 

delete from tblHouseListing

where idHouseListing = 88

 

STEP #2

 

GO to ClickHome

Update the listing to delete the PL reference and update the upload status:

 

begin tran

update tblHouseListings

set inProductLibraryId = null, set cdUploadStatus = 'U'

where inProductLibraryId = 88

rollback

STEP #3

Wait – the next 2774 that runs (set to run on 15min interval) will pick up the listing and re-upload it