OLX SMDR Call Data Import Spec

OLX SMDR Call Data Import Spec

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.


    • Related Articles

    • OLX Telemarketing Import Spec

      The OLX Telemarketing Import Spec is a 121 column order import used to bring outside calls and orders into the OrderLogix application. This is accomplished by creating a CSV (a file with information fields, each separated by a single comma) with all ...

    • OLX Telemarketing Import Spec

      The OLX Telemarketing Import Spec is a 121 column order import used to bring outside calls and orders into the OrderLogix application. This is accomplished by creating a CSV (a file with information fields, each separated by a single comma) with all ...

    • OLX Campaign Setup Import Spec

      Module: Import Path: Processing > Import/Export > Import Topic: OLX Campaign Setup Import Version(s): 5.1 & up Editions: All What Is OLX Campaign Setup Import The OLX Campaign Setup Import is a powerful and robust import that can create and update ...

    • OLX Order Import/Export Spec

      The OLX Order Import/Export is compatible with OrderLogix versions 3.5 & up. It is the original (or legacy) 107 column order import used to bring outside orders into the OrderLogix application. This is accomplished by creating a CSV (a file with ...

    • OLX Lead Import Spec

      The OLX Lead Import allows for loading contact information from an internal dataset or 3rd party source, into existing call notification queues in the OrderLogix application. File Format: ASCII text. The file must contain one line per addition, with ...