Page 1 of 1

Moving leads from one list to another in db

PostPosted: Fri Nov 04, 2011 3:02 pm
by keepers
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.

PostPosted: Fri Nov 04, 2011 4:11 pm
by mflorell
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.

PostPosted: Fri Nov 04, 2011 4:45 pm
by keepers
Great thank you!

Re: Moving leads from one list to another in db

PostPosted: Fri Jan 06, 2017 2:05 pm
by rbigger
can someone email in regards to how to do this. rcbigger@gmail.com