The OLX SMDR Call Data Import allows for loading call data from a 3rd party phone dialing systems into the OrderLogix application for reporting purposes. File Format: ASCII text. The file must contain one line per addition, with each field enclosed in double quotes and comma separated, ending with a Carriage Return (↵) <CR>. All unused fields will be left blank and remain separated by a single comma. File Naming: <Organization Identifier><YYYYMMDD>.csv Import Definitions: # | Field Name | Req. | Type | Max | Field Description | 1 | EXTENSION | YES | Alpha | 50 | Extension or "***" for dropped calls. | 2 | CALL_DATE | YES | Date | 10 | MM/DD/YYYY format. | 3 | CALL_TIME | YES | Date | 8 | HH:MM:SS format (military time). | 4 | TRUNK | YES | Alpha | 50 | Line or Sip Channel. | 5 | CALL_DURATION | NO | Alpha | 50 | MM:SS format. NOTE: Calls can be over 99 minutes, HH:MM:SS. | 6 | CALL_TYPE | YES | Alpha | 50 | "IN" for inbound, "OUT" for outbound | 7 | DNIS | YES | Alpha | 50 | The DNIS, or DID identifying the number dialed. For outbound, a project identifier or account code for the given campaign can be passed. | 8 | ANI | YES | Alpha | 50 | The Caller ID of the caller, or Number Dialed for outbound calls. | 9 | ANSWERED_AT_EXTENSION | NO | Alpha | 50 | Extension that answered the call. | 10 | RING_DURATION | YES | Alpha | 50 | MM:SS format. NOTE: Calls can ring for over 99 minutes, HH:MM:SS. | 11 | LOCATION_CODE | NO | Alpha | 50 | Location Code where call occurred. Please leave blank or use provided location codes (see the ‘Options’ section of this documentation). Codes must be valid, and pre-existing in application. | 12 | UNIQUE_ID | YES | Alpha | 255 | Unique Identifier of the call. |
The attached documentation includes the SMDR Call Data Import Spec, Template, and Example. |