Moving leads from one list to another in db

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Moving leads from one list to another in db

Postby keepers » Fri Nov 04, 2011 3:02 pm

QUESTION: Need to know if it is possible to move leads from one list to another in the database?

SCENARIO: I need to move leads that have aged 10 days from Entry Date into a separate list. I would like to keep all relevant information with it such as status, called count, etc.

Is this possible using an sql command? I will have it set to run nightly but want to make sure it wont mess anything up.

Last, would simply changing the List Id for the lead work? That seems like it would be the easiest solution but once again don't want it to mess anything else up.
keepers
 
Posts: 24
Joined: Mon Apr 25, 2011 12:20 pm

Postby mflorell » Fri Nov 04, 2011 4:11 pm

Yes, simply changing the list_id of the lead in the vicidial_list table will do it.

You could even use the AST_DB_tz_divide.pl script as a framework to write a script to do this that you can put in the crontab.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby keepers » Fri Nov 04, 2011 4:45 pm

Great thank you!
keepers
 
Posts: 24
Joined: Mon Apr 25, 2011 12:20 pm

Re: Moving leads from one list to another in db

Postby rbigger » Fri Jan 06, 2017 2:05 pm

can someone email in regards to how to do this. rcbigger@gmail.com
rbigger
 
Posts: 1
Joined: Fri Jan 06, 2017 2:02 pm


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], pimo1974 and 81 guests