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:
   
   

   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.
   
   

   Open

   

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.
   
   

   Open

   

   
   The predefined 3CX cube structure uses the following fields:

7. 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.