OLX Media Schedule Import Spec

Campaign > Media > Ad Copy setting for Max Station Dist is required for this import to work successfully

The OLX Media Schedule Import allows for loading and connecting media buys to locations and sources in 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	PAYTYPE	YES	Alpha	255	Pay type name (ex. Prepaid)
2	ADCOPY	YES	Alpha	255	Valid ad copy name in OLX
3	STATION	YES	Alpha	255	Valid station in OLX
4	MEDIA FORMAT	YES	Alpha	255	Valid media format in OLX
5	STARTDATETIME	YES	Date	22	Media schedule start date and time (format MM/DD/YYYY HH:mm:SS TT)
6	ENDDATETIME	YES	Date	22	Media schedule end date and time (format MM/DD/YYYY HH:mm:SS TT)
7	SPENDAMT	YES	Numeric	6	Amount spent (decimal, ex. 0000.00)
8	RUNS	YES	Numeric	6	Number of runs (ex 000001)
9	DNIS	YES	Alpha	50	Valid DNIS in OLX
10	ISDNR	YES	Boolean	6	Is do *not* run? 1 = do *not* run, 0 = run

The attached documentation includes the OLX Media Schedule Import Spec, Template, and Example.