BULK Leads/List download

[Farzvoip]

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

[carpenox]

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';;

I hope this helps

Chris aka carpenox