Is there a way to update all listings without purging them first?

Comments

camidoo’s picture

camidoo commented

kinda, it's a bit of a manual task.

first run this statement on your database

UPDATE drealty_listing SET hash = '0'

Then run your import, that will force all listings to update.

webavant’s picture

webavant commented
Title: Update All Without Images? » Update All Listings Without Flushing
Category: support » feature

I realized the title was weird, and that this was more of a feature request. Will this be a feature controllable from UI or a drush command at some point?

kevinquillen’s picture

kevinquillen commented

I think we should add a button in the UI to do this, too. Not everyone will have direct database access.

stockliasteroid’s picture

stockliasteroid commented

Yes, it would be nice to flag all listings from a certain connection/class for update. So if you wanted to refresh all Residential listings, you could do that... At minimum it would be cool to have a drush task to just automate the above SQL query, though...

j9’s picture

j9 commented

Does this

UPDATE drealty_listing SET hash = '0'

have to be set back to whatever it was after the refresh-without-purge to resume normal updates via cron and rets-import?

Thanks!

camidoo’s picture

camidoo commented
Status: Active » Fixed

no, once it updates the listing on the next import it will recalculate the hash.

Additionally, there is a new drush command that will do this for you:

drush rets-force-update

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Exploratus’s picture

Exploratus commented

Does drush rets-force-update also force downloading of photos again? I want to just flush the hash and reimport the data without having to reimport all the pics.

Would love to know.

ncswi’s picture

ncswi commented

Love the module and camidoo's support video. One issue I'm seeing is on images. I'm in control of my own Linux web servers and have the module working. While the drush -u username rets-import works bringing in the textual information, it is not importing the images. If I click on the "Update RETS Data" tab on the note listing itself, it will import the images. But that's a pain for 7,500 listings. I've tried the steps outlined by other to set the hash to 0, and perform a drush import several times, but the images do not display unless I do an "Update RETS Data" from the node property itself.

Any help is vastly appreciated.

bloomt’s picture

bloomt commented
Issue summary: View changes

Does anyone know how I could script the drush rets-force-update command. I have regular updates running on a crontab every hour using (drush -u admin -d rets-import) command. But the drush rets-force-update command expects a user input before it runs through. Is there a way of doing something like (drush rets-force-update all) I would like to be able to run this command at night just to be sure that all properties are updated.

bloomt’s picture

bloomt commented
Status: Closed (fixed) » Active
shauntyndall’s picture

shauntyndall commented
Status: Active » Closed (outdated)

This seems like an outdated issue. If a solution was formulated please share it.