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.
Moving leads from one list to another in db
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
4 posts
• Page 1 of 1
Moving leads from one list to another in db
by keepers » Fri Nov 04, 2011 3:02 pm
- keepers
- Posts: 24
- Joined: Mon Apr 25, 2011 12:20 pm
by 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.
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: 18386
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
Re: Moving leads from one list to another in db
by 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
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 121 guests