3CX Phone System

To set up data import from 3CX Phone System, using a log file:

1. Set up log file generation in 3CX Phone System.
   For maximum compatibility with our default 3CX data cube, set up logging of the following fields:
   

   CODE

   historyid, callid, duration, time_start, time_answered, time_end, 
   reason_terminated, from_no, to_no, dial_no, reason_changed, 
   final_number, bill_code, bill_rate, bill_cost, bill_name, chain,  
   from_dispname, to_dispname, final_dispname

2. Contact support@flex.bi, to arrange automated log file transfer to flex.bi server.

3. In your flex.bi account, open “Source data” section.

4. Click on the “Add new source application” button.

5. Select the “3CX” application.
   

   

6. In the “Cdr export field list” field, adjust the list if fields exported to the log file, according to the settings made in 3CX Phone system and in the correct order.
   

   

   
   The predefined 3CX cube structure uses the following fields:

7. CODE

   historyid, callid, duration, time_start, time_answered, time_end, 
   reason_terminated, from_no, to_no, dial_no, reason_changed, 
   final_number, bill_code, bill_rate, bill_cost, bill_name, chain,  
   from_dispname, to_dispname, final_dispname

   If you’r log file contains different fields or you want to analyze additional data, adjust the custom fields definition in the “Advanced Settings” section according to the log file structure you are using.
   contact support@flex.bi for assistance.

8. Select preferred import options and click on “Import” button.