Very much in development and incomplete. Do not use yet.
Application to read Sonus CDR files parse the data, map the fields to keys and insert in to a database. Currently only saving to MySQL other databases on the roadmap.
Can be run as daemon or as command line tool. In daemon mode will process files from directory or specific location. As CLI tool can take filename as argument and will only process that file
If you do not want to build from source in the bin dir there are binaries for OS X and Linux 64bit.
Mysql Database
Mysql CLI Client (for creating tables. This can be skipped if you wish to make them yourself)
go build environment (only if you wish to build from source)
To use the pre-built binaries
Run the install_bin.sh script and answer the questions. will create the tables for you in your MySQL database. In the bin dir there are two binaries, one for Mac OS X and one for 64bit linux. You can now copy the appropriate binary and your config file to where ever you which to run them from.
To build from source:
Run the install_src.sh script and answer the questions. This will create an exectuable for your in the bin dir and will create the tables for you in your MySQL database. You can now copy your binary and your config file to where ever you which to run them from.
Currently the binary and config file can be anywhere as long as they are in the same directory together. The application looks for the config.json file in current working directory.
####SQL Tables in the SQL dir are files to create the three required MySQL tables. You can create the manually or use the install script to create them for you.
Can be ran as a command line tool to process a single file, or ran in a daemon mode from a startup script
-h = display helps
-v = displays version
-f = path to file name to parse. Will only parse that file and exit.
-t = Number of records to commit in a single transaction to the database
Process a single file
./cdrprocessor -f SFOSBC01.20150331235500.10066FE.ACT
This will cause the program to not run in daemon mode. It will exit once this file is complete.
./cdrprocessor -t 500
This will start the program in daemon mode with a transaction commit of 500 records at a time.
Currently the configuration file is a simple json file. This may change in the future. The easiest way is to use this is to copy the shipped config.json.default to config.json and modify the entries to suit your environment.
FileDir = Directory where the Raw CDR files are stored.
DSN = The datasource name. This information is used when connecting to the database. This Will include the username and password to use when connecting to the database. The database host port and database name to connect to. See guide: "<username>:<password>@<host>:<port>/<database>"
FileExt = The file extension of the files you wish to process. The application will look in the specified Directory for files ending in this file extenstion. So if you want to process *.ACT files use ACT as the value here.
Exmaple
"FileDir" : "/nsfstore/CDR_Files",
"DSN" : "root:root@tcp(127.0.0.1:3306)/test",
"FileExt" : "ACT"
still to come.