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