CEL DB column alias

Asterisk Asterisk Support
1

Hi!

I would like to store the CEL record in a mysql database. The odbc-mysql connection work well, but i can’t figure out how can I store the CALLERID variables.

For example:
cel_custom.conf
[mapping]
Master.csv => …,${CSV_QUOTE(${CALLERID(name)})},…

cel_odbc.conf
[cel]
connection = odbc-mysql
table = cel
alias => ??? => c_name

What have to write into the alias’s “CEL field”?

Thanks

2

You don’t need to use alias just to save a value into an RDBMS.

Entry in func_odbc.conf:

[Save_SomeValue] dsn=your_mysql_dsn prefix=CEL writesql=UPDATE some_table SET some_column=${SQL_ESC(${ARG}1)};

Then invoke in the dialplan as follows: