3CX Phone System

flex.bi can use 3CX Phone System’s log files for importing data. To set up the import:

1. Set up 3CX Phone System logging in a file

2. Automate file uploading to flex.bi. Please contact support@flex.bi for the file transfer process.

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

4. Click on “Add new source application”

5. Select “3CX” application

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

7. Select preferred import options and press “Import”