BULK Leads/List download

Any and all non-support discussions

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

BULK Leads/List download

Postby Farzvoip » Mon Aug 15, 2022 5:24 pm

Hello,



Can anybody let me know how to download bulk leads anyhow now how i am doing it but clicking in list id and scroll down and click in download list id. I am doing it one by one wo it taking to much of time





Cloud Server no virtual server
single server
no extra software installation apart from zypper up
VERSION: 2.14-830a
BUILD: 210920-2159
© 2021 ViciDial Group
Asteris version 11.25.1-vici, tried in vicibox 7.0.4,
server Intel(R) Xeon(R) CPU E3-1230 v3 @ 3.30GHz


Thanks
Farzvoip
 
Posts: 19
Joined: Wed Dec 22, 2021 5:59 pm

Re: BULK Leads/List download

Postby carpenox » Tue Aug 16, 2022 2:25 am

Try the code below and you cn change the query up as needed, i put a few list id's which obviously need to be changed or if you want to do all the lists(which may take a very long time depending on the amount of leads you can leave the end part off of the query "where list_id=123,124,125" and you can add more fields which ill show whats available at the bottom

Code: Select all
select phone_number,first_name,last_name,address1,city,state,postal_code,comments from vicidial_list where list_id=123,124,125 INTO OUTFILE '/var/lib/mysql-files/leads.csv'
FIELDS ENCLOSED BY '"'
TERMINATED BY ';'
ESCAPED BY '"'
LINES TERMINATED BY '\r\n';;



Image


I hope this helps

Chris aka carpenox
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL


Return to General Discussion

Who is online

Users browsing this forum: Google [Bot] and 35 guests