% include( '/elements/header.html', 'Developer Documentation' ) %> <& /elements/menubar.html, 'Freeside Perl Modules' => $fsurl.'docs/library/FS.html', 'Complete Index' => $fsurl.'docs/library/index.html', &>
freeside-cdr-asterisk_sql - Import CDRs from an Asterisk SQL database
freeside-cdr-asterisk_sql -e mysql|Pg|... [ -H host ] -D database [ -T table ][ -V asterisk_version ] -U user -P password freesideuser
Imports CDR records from an Asterisk SQL database.
-H: hostname
-e: Database engine (default mysql)
-D: database name
-T: table name (default cdr)
-U: username
-P: password
-V: Asterisk version. Values of 12 or higher have a new database schema which no longer includes calldate. Currently defaults to 11, but may default to 12+ or be required in a future, so best to always specify the version.
-Q: Use uniqueid field instead of id (Asterisk v12 only). Less efficient, but useful if the field is missing.