vicidial_log

[cff_moiseszaragoza]

Hi every one

I am was ask to change the vicidial_log table by adding a new field but i need to populate that field but i cant seem to find the insert to that table.

Does any one know where the INSERT Query is?

Thanks

I looked in

agc/vdc_db_query.php

[mflorell]

All over the place. That table gets inserted into and updated in at least 8 scripts.

[cff_moiseszaragoza]

would you know where the one for automated dialing is?

[williamconley]

i have a better idea: what information are you trying to capture?

also:

when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system.

Similar to This:
Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation

[cff_moiseszaragoza]

Vicibox Redux 3.1.9 64Bit
VERSION: 2.4-319c
BUILD: 110310-1627
Asterisk 1.4.39.1-vici
Single Server For Testing Dual Proc 2.8Ghz 2Gig Ram

All of it is in 1 box for development


What i am trying to get is the data from vicidial_list.vendor_lead_code into vicidial_log.vendor_lead_code

the vendor_lead_code in the vicidial_log is a new field added

[williamconley]

wouldn't it be simpler to use a query when reporting and just leave the data where it is?

Code: Select all

select * from vicidial_log inner join vicidial_list on vicidial_log.lead_id=vicidial_list.lead_id where vicidial_list.lead_id >= 'XXXX'


[cff_moiseszaragoza]

there are a lot of things that would have been easer

a cron job that populates the data after the fact

or to make it happen on a update statement

i do appreciate your help but i still need to find out at least what file is responsible for that insert statement

[williamconley]

happy hunting, but remember that modifying the vicidial code now means modifying it again when you update/upgrade. a custom report, however, need not be overwritten and will still work.

[cff_moiseszaragoza]

i agree i am not the fan of doing things this way but i don't allays make all the decisions

Thanks williamconley but i have not mention any reports, we need the data in the log field for other reasons

if you want i can explain to you the full process of what i am trying to get accomplish but i did not think that was necessary for what it should be the hunt of a insert query

[williamconley]

"necessary" vs perhaps there is another way to accomplish the task.

you'll have to find ALL situations that write data to the log (and possibly those that read data from it) ... and ensure the data you want to put in the log is available and that your changes do not break any other functionality ... AND that you can duplicate this feat when next you upgrade vs a quick reason why this information needs to be duplicated in the log and in the lead record could be helpful.

[cff_moiseszaragoza]

Thanks for your help i know what a insert statement is and i that i have to find all the places where it happens my questions is where are they at. if you can give me a file name like agc/vdc_db_query.php would be of great help that is all i am looking for

i looked in that file and a grep the server for all instances of INSERT INTO vicidial_log

now i am asking is. In what file can i find a insert to the vicidial_log ?

Thanks

[williamconley]

Code: Select all

grep vicidial_log * -R -n --exclude='*txt' | grep INSERT


[cff_moiseszaragoza]

Thanks for the help i truly appreciate your help

but that did not return anything what so ever.

Code: Select all

VICIDEV:~ # grep vicidial_log * -R -n --exclude='*txt' | grep INSERT
VICIDEV:~ #


[williamconley]

you should try that in your web root (somewhere below where you expect to find the files, which is NOT the ~ folder)8)

welcome to linux

[cff_moiseszaragoza]

i just tried it again grep vicidial_log * -R -n --exclude='*txt' | grep INSERT first thing when i log in to the box and the only things that return are the SQL log files







VICIDEV:~ # grep vicidial_log * -R -n --exclude='*txt' | grep INSERT

vd_dev.sql:3306:INSERT INTO `vicidial_log`
vd_dev.sql:3374:INSERT INTO `vicidial_log_extended`

VICIDEV:~ #

[williamconley]

you should try that in your web root (somewhere below where you expect to find the files, which is NOT the ~ folder)

i just tried it again grep vicidial_log * -R -n --exclude='*txt' | grep INSERT first thing when i log in to the box ...

VICIDEV:~ # grep vicidial_log * -R -n --exclude='*txt' | grep INSERT

vd_dev.sql:3306:INSERT INTO `vicidial_log`
vd_dev.sql:3374:INSERT INTO `vicidial_log_extended`

VICIDEV:~ #

I specifically mentioned to run the command in the web root (which is different for each distro of this software, old versions /var/www or new Vicibox /srv/www/htdocs ... or ...) but most certainly NOT "~" your home and not "first thing when I log in" (which is ~, BTW and not the web root). Keep trying.