Problem Loading Vicidial_List in Vicidial Admin | GUI

All installation and configuration problems and questions

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

Problem Loading Vicidial_List in Vicidial Admin | GUI

Postby J3A-G0n3 » Fri Dec 30, 2022 2:43 pm

Version: 2.14b0.5
SVN Version: 3638
DB Schema Version: 1666
Asterisk PBX 13.38.2-vici

No digium hardware, this is essentially VPS/ Virtual Machine... Not a Cluster is a simple installation with asterisk, opensuse and mariadb on same VM (I install via vicidial-express iso).

So I upgraded from old VM with ViciDial 8 to new VM with Vicidial 10 iso... I ran the IP update script, and I manually imported the tables into the new asterisk database. After finalizing all of the tables everything seems to work like the previous version / I check that no new fields were added in the tables I uploaded into the new schema YET it seems that the leads are not showing in the admin/backend/GUI or populating on the campaigns. The vicidial_list table on the database asterisk shows all of the leads with the correct list_id = campaign id but leads not showing in the admin GUI. I am not sure if there is a script I need to run to show in the front, I search the forum but not seeing a similar issue with anyone. On the Audio Store I had to run /usr/share/astguiclient/ADMIN_audio_store_sync.pl --upload for it to sync and show the audio in the GUI, having said that the audio was accessible and working on the IVR without running the perl script. Is there a similar script I must run for the leads to sync from DB to Vicidial GUI?

In other words, I am updating the leads from database -> front, and while I read in the forum about uploading leads via /usr/share/astguiclient/LEADS_IN &&\ VICIDIAL_IN_new_leads_file.pl in my case the leads are already in the DB so uploading via this method simply will create duplicates.
J3A-G0n3
 
Posts: 2
Joined: Thu Dec 29, 2022 4:33 pm

Re: Problem Loading Vicidial_List in Vicidial Admin | GUI

Postby J3A-G0n3 » Thu Aug 17, 2023 3:03 pm

Bump...

Anyone has any idea how to update the leads in db table so it shows in the GUI/Admin backend? Is there a perl script I need to run?
J3A-G0n3
 
Posts: 2
Joined: Thu Dec 29, 2022 4:33 pm

Re: Problem Loading Vicidial_List in Vicidial Admin | GUI

Postby carpenox » Fri Aug 18, 2023 9:37 pm

Did you run the upgrade script?
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

Re: Problem Loading Vicidial_List in Vicidial Admin | GUI

Postby mflorell » Sat Aug 19, 2023 6:32 am

There is an old script "VICIDIAL_UPDATE_leads_status_file.pl" that was designed to take a flat file with lead_ids and statuses and bulk update leads that way. But other than that, must clients just use the Non-Agent API to update leads.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Problem Loading Vicidial_List in Vicidial Admin | GUI

Postby carpenox » Sat Aug 19, 2023 10:11 pm

From the looks of his post, he doesn't mention running the upgrade_214.sql file which I believe might be his problem but then again other areas would be showing blank fields so maybe not
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

Re: Problem Loading Vicidial_List in Vicidial Admin | GUI

Postby kashyapking » Sun Aug 20, 2023 9:31 am

J3A-G0n3 wrote:Bump...

Anyone has any idea how to update the leads in db table so it shows in the GUI/Admin backend? Is there a perl script I need to run?


Hi,
First of all as you have upgraded vicibox 8 to 10, then there are lots of mysql changes happened in versions, so you can import your old database as you have mentioned and then you have to check mysql scripts from vicidial source and upgrade complete database first, so your gui and all other setup works normal as new gui and script will support to upgraded db.

And after that you can check leads as it will work on gui as well and you can manage from there too.
Vicibox10 | Version: 2.14b0.5 | SVN Version: 3743 | DB Schema Version: 1690 | Asterisk Version: 13.38.2-vici
visit us @ https://www.kingasterisk.com | skype: kingasterisk | wa @ +17864142610
kashyapking
 
Posts: 20
Joined: Fri Aug 18, 2023 11:32 am

Re: Problem Loading Vicidial_List in Vicidial Admin | GUI

Postby carpenox » Sun Aug 20, 2023 10:24 pm

Thx for repeating what I said.... In a lot more words. And welcome to the forums bud ;)
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 Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 94 guests

cron