Call Us Today! 877.742.2583




Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Two wiki links

...

Expand
titleClick here to expand Table of Contents
Panel
borderColorlightgray
bgColor#f7f7f7
borderWidth1
borderStyledotted

Table of Contents
maxLevel3
outlinetrue
indent1em
excludeAbout
stylenoneexcludeAbout
printablefalse

Examples

The database specified by the parameter db-name is automatically created in the same directory as the FreeSWITCH core database (specified by the -db command-line switch, or /usr/local/freeswitch/dbby default). The file extension .db is automatically appended to the db-name.

Code Block
languagexml
themeEmacslanguagexml
<param name="db-name" value="cdr"/>

The DB table name is specified by the parameter db-table (cdr by default).

Code Block
languagexml
themeEmacslanguagexml
<param name="db-table" value="cdr"/>

If the table does not exist, the mod_cdr_sqlite will create it automatically, using the following default table schema:

Code Block
languagexml
themeEmacslanguagexml
CREATE TABLE tablename (
   caller_id_name VARCHAR,
   caller_id_number VARCHAR,
   destination_number VARCHAR,
   context VARCHAR,
   start_stamp DATETIME,
   answer_stamp DATETIME,
   end_stamp DATETIME,
   duration INTEGER,
   billsec INTEGER,
   hangup_cause VARCHAR,
   uuid VARCHAR,
   bleg_uuid VARCHAR,
   account_code VARCHAR
 );

The template that is used for the default field order is defined by the following line (which uses "example" in the default installation).

Code Block
languagexml
themeEmacslanguagexml
<param name="default-template" value="example"/>

...

Variables are given in the form ${varname}. For an overview of variables, check Channel Variables. You can specify any channel variable.

Template variables can be to API calls as well, like:

Code Block
languagexml
themeEmacslanguagexml
<template name="custom_timestamp">"${expr(${end_epoch}-${my_timestamp})}"</template>

...