Update existing list

All installation and configuration problems and questions

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

Update existing list

Postby donegalguy2 » Tue Nov 27, 2018 4:51 pm

Hi there.

I have a question with regards to updating a list that is preloaded with additional info.

I have loaded a substatianal list 7k and have a client in their wisdom who has decided to add an additional security question. Half the numbers have already been called on the list (ok be positive I can fix half of them handy enough in a two step process but would prefer one). So now we have to append 7k records with additional information. Can we append this by using lead_id or something I think I vaguely remember. I had the manual but I think it is on an old broke laptop that I need to whip the hard drive out off.

I also considered downloading the list and amending in excel and reuploading but I think I will lose callbacks and notes. Is this the case

Any help gratefully accepted.

Thanks
Rick

VERSION: 2.12-575a
BUILD: 161113-0900
donegalguy2
 
Posts: 6
Joined: Fri Jun 08, 2018 10:39 am

Re: Update existing list

Postby blackbird2306 » Tue Nov 27, 2018 5:19 pm

Are these additional informations in custom fields section? Is this additional security question always the same in every lead? Be more precise
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: Update existing list

Postby williamconley » Tue Nov 27, 2018 5:37 pm

http://www.vicidial.org/VICIDIALforum/v ... =4&t=27130

Directly making the changes is also possible via phpMyAdmin or at the CLI if you are in any way comfortable with MySQL.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Update existing list

Postby blackbird2306 » Tue Nov 27, 2018 5:58 pm

The non agent api or MySQL are possible, but we are talking about 7000 leads
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: Update existing list

Postby williamconley » Tue Nov 27, 2018 6:46 pm

blackbird2306 wrote:The non agent api or MySQL are possible, but we are talking about 7000 leads

True. I wouldn't recommend trying to hand-code it. 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Update existing list

Postby donegalguy2 » Sun Dec 02, 2018 5:00 pm

Hi Guys

Thanks for the advice. I will post an update of how I completed this.

I had to give remote access to the mysql database - this is pretty standard across all myql servers - I created a new user for this other then root. SO log into mysql on the server and create user ie.

select user, host, password from mysql.user;
use mysql;
update user set password=PASSWORD("NEWPASSWORD") where User='root';
flush privileges;

I restart my vicidial server every night as it can sometimes give a few issues.

Now that the mysql database can be connected remotely - I still have to open the opensuse firewall:
rcSuSEfirewall2 stop (if I forget to restart the firewall the system restart will mean that it will be reset at night)

I than use NAVICAT for mysql to access the mysql databases and voila they are all there and I can update anything by copying and pasting from excel.

Hope this helps somebody else.
donegalguy2
 
Posts: 6
Joined: Fri Jun 08, 2018 10:39 am

Re: Update existing list

Postby donegalguy2 » Sun Dec 02, 2018 5:06 pm

Sorry guys the wrong mysql user create script

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
Then

GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';

and importantly you need to change the my.cnf

my.cnf (my.ini on windows)

#Replace xxx with your IP Address
bind-address = xxx.xxx.xxx.xxx
donegalguy2
 
Posts: 6
Joined: Fri Jun 08, 2018 10:39 am


Return to Support

Who is online

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