Page Comparison

flex.bi can use 3CX Phone System’s log files for importing data. To set up the importdata import from 3CX Phone System, using a log file:

1. Set up data logging log file generation in 3CX Phone System to a file

2. Automate file the log file upload to flex.bi. Please contact support@flex.bi for the file transfer process setup.

3. Go to your flex.bi account’s “Source data” section

4. Click on “Add new source application”

Select “3CX” application


Image Removed

5. Define “Cdr export field list” based on how your 3CX Phone System’s logger is set up and click on “Continue”. Below is a list of fields that flex.bi uses for import. The fields should be defined based on the order that they appear in the log file. If your log files do not contain any of the fields or contains more fields that you would like analyse your data by, please adjust Advanced Settings in the next step accordingly or contact support@flex.bi for assistance.

   1. historyid

   2. callid

   3. duration

   4. time_start

   5. time_answered

   6. time_end

   7. reason_terminated

   8. from_no

   9. to_no

   10. dial_no

   11. reason_changed

   12. final_number

   13. bill_code

   14. bill_rate

   15. bill_cost

   16. bill_name

   17. chain

   18. from_dispname

   19. to_dispname

   20. final_dispname

6. Select preferred import options and press “Import”.
   For maximum compatibility with our default 3CX data cube, set up logging of the following fields:
   

   Code Block
   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

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

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

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

10. Select the “3CX” application.
    

    Image Added

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

    Image Added

    
    The predefined 3CX cube structure uses the following fields:

12. Code Block
    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.

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