Need to create custom report using mysql database.

[un_knownguy]

Hello this is my first post,

I'm a developer and I need to create a custom report based on vicidial data, the thing is that I don't know where to find or know information about dabase structure, what I found barely says anything.

What is a lead_id?

Why is lead_id repeated on vididial_log?

What's the difference between vicidial_log, vicidial_agent_log and vicidial_closer_log?

Should all the leads in vicidial_log be in vicidial_agent_log and vicidial_closer_log?

[williamconley]

Hello this is my first post,

I'm a developer and I need to create a custom report based on vicidial data, the thing is that I don't know where to find or know information about dabase structure, what I found barely says anything.

What is a lead_id?

Why is lead_id repeated on vididial_log?

What's the difference between vicidial_log, vicidial_agent_log and vicidial_closer_log?

Should all the leads in vicidial_log be in vicidial_agent_log and vicidial_closer_log?

The Vicidial system uses a table named "vicidial_list" to store all leads which will be dialed. The primary key for this table is "lead_id" and is used to connect any and all activity in the vicidial system with that lead. The various tables that end in _log are all associated with different activities which may or may not overlap depending on the situation. Your best method to accomplish a field mapping would be to modify the existing report .php files and see which ones use which table and where they put their data. Another method we like to use is to perform a data dump, make ONE call of the type you wish to track, and then perform another data dump and see what entries are made as a result of the call you just made.