Problem Loading Vicidial_List in Vicidial Admin | GUI

[J3A-G0n3]

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]

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?

[carpenox]

Did you run the upgrade script?

[mflorell]

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.

[carpenox]

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

[kashyapking]

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.

[carpenox]

Thx for repeating what I said.... In a lot more words. And welcome to the forums bud