CDRTool version 6.8.0
CDRTool version 6.8.0 has been released. The software contains bug fixes and new features related to partitioning of data for multiple resellers.
You must read and apply the change log carefully to migrate from an older version, in particular the changes from setup/mysql/alter_tables.mysql
Changelog
cdrtool (6.8.0) unstable; urgency=low
Added reseller fields to all database tables to allow different login accounts to access their own data based on the account impersonate field
Allow import of CSV files from subdirectories (read updated 'Data partitioning for multiple resellers' section from RATING.txt)
Added prepaid_history table to rating table web management
Added increment and min_duration for each rate entry
Removed gateway, domain and subscriber columns from billing_profiles table
Removed gateway, domain and subscriber columns from billing_rates table
Removed gateway, domain and subscriber columns from billing_rates_history table
Updated CSV format for all rating tables to support the above changes, see setup/csv for updated examples of CSV files or export your live data from CDRTool rating tables page to see the new fields
Removed obsolete prepaid.call_lock and prepaid.call_in_progress columns
Removed obsolete customers.country_code column
Removed obsolete tables ratesNGN and profilesNGN
Renamed colummn prepaid_history.number with prepaid_history.description
Show SIP trace also in text only format
Do not log zero priced calls in prepaid_history table
Improved SIP prepaid provisioning screens
Skip math calculation for some rating tables
Added export balance history from SIP prepaid page
Updated ngnpro client to work with server version 4.1.1
Make stronger random passwords for SIP accounts
Improved NGNPro LCR functionality
Added scripts/OpenSIPS/notifyLastSessions.php to send email notifications containing the last sessions recived in the last 24 hours. You must set notifyLastSessions per data source to tru to enable this feature and put the susbcriber into missed_calls group
You must apply the changes from setup/mysql/alter_tables.mysql
You must add an integer `reseller_id` column to opensips.trusted and opensips.domain tables
Changed column prepaid_cards.value to decimal
Droped unused columns from prepaid table
Added a script to test the speed of the rating engine
For more information visit http://cdrtool.ag-projects.com/