invoso.com Report post Posted 06/29/2011 07:42 AM Hi, 1. how to put own data (our "session_id") into CDR file? 2. can i insert CDR data direct to database? Maciej Share this post Link to post
SupportTeam Report post Posted 06/29/2011 08:10 AM Quote 1. how to put own data (our "session_id") into CDR file? From http://www.voiceguide.com/vghelp/source/html/log_cdrs.htm : Quote The Result Variables defined during the call can be optionally saved in the lastdata field. To enable this add this entry to the [Log] section of the VG.INI file: CDR_LastData_SaveRv=1 Contents of $RV[CDR_amaflags] will be placed in the 16th CDR field. Contents of $RV[CDR_user] will be placed in the 17th CDR field. Quote 2. can i insert CDR data direct to database? Yes. CDR tables are created by default in VoiceGuide's database (same that is used for the dialer tables). See the SQL in the \VoiceGuide\System\setup\ directory to see the table structure. All CDRs are saved in the database as well as in text files. Share this post Link to post
invoso.com Report post Posted 06/29/2011 08:31 AM Thanks, when i create database how to setup VG to store data into DB? Share this post Link to post
SupportTeam Report post Posted 06/29/2011 09:25 AM CDR entries are saved in the CDR tables automatically if the tables exist. Share this post Link to post
invoso.com Report post Posted 06/29/2011 10:17 AM Sorry I don't understand. I'm using postgres database, how will VG know that i created database with table for vg? Share this post Link to post
invoso.com Report post Posted 06/29/2011 10:54 AM I created postgres database "vg" on my server (different as VG server), how to connect VG to this database? Share this post Link to post
SupportTeam Report post Posted 06/29/2011 11:50 AM Please see: http://www.voiceguide.com/vghelp/source/html/dial_vgdb_external_config.htm You need to edit Config.xml to let VG connect to your database. Then either set up the tables yourself, or let VG create them for you. For Postgres its best to create these yourself. See Db_Create.sql file in Voiceguide's \system\setup\ subdirectory to see what is the required table schema/structure, and create tables accordingly. VG will then use these tables. Share this post Link to post
invoso.com Report post Posted 06/29/2011 01:13 PM one more question: I need timestamp of connection moment in Transfer Call module to calculate transfered call length. Which variable include this value? where can i found a list of $RV? Share this post Link to post
SupportTeam Report post Posted 06/29/2011 01:35 PM You may need to create this RV yourself. Can you have a path that triggers on Connection event and point that path to an "Evaluate Expression" module which creates the $RV. You may need to then have the script sit in another module until transfer finishes. If you can post your script and traces capturing call and transfer etc then we can comment better. Please start a new thread for this as this is unrelated to CDR questions. Share this post Link to post