OLX Station Import Spec

OLX Station Import Spec

The OLX Station Import allows for loading media stations for media buy assignments and distance based sourcing 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

NAME

YES

Alpha

255

Station name (provided or generated)

2

COMPANY

NO

Alpha

255

Company name

3

FIRST NAME

NO

Alpha

100

Contact first name

4

LAST NAME

NO

Alpha

100

Contact last name

5

ADDRESS 1

NO

Alpha

255

Address 1

6

ADDRESS 2

NO

Alpha

255

Address 2

7

CITY

NO

Alpha

255

City

8

STATE

NO

Alpha

50

State

9

ZIP

NO

Alpha

50

Zip code

10

PHONE

NO

Alpha

10

Phone number

11

FAX

NO

Alpha

10

Fax number

12

BC AREA CODE

YES

Alpha

50

Broadcast area code (format 000)

13

BC ZIP CODE

YES

Alpha

50

Broadcast zip code
(format US: 00000, CA: A1A 0A0)

14

DMA

NO

Alpha

50

Designated market area

15

IS EXCL

NO

Boolean

1

Is the station exclusive? 0 = No, 1 = Yes

16

EMAIL

NO

Alpha

255

Email address

17

WEBSITE

NO

Alpha

255

Website

18

NOTES

NO

Alpha

2000

Station notes

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


    • Related Articles

    • OLX Media Schedule Import Spec

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

    • OLX Ad Copy Import Spec

      The OLX Ad Copy Import allows for loading the connected projected revenue and call statistics for a given group of media buys into the OrderLogix application for reporting purposes. File Format: ASCII text. The file must contain one line per ...

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

    • OLX Campaign Import Spec

      The OLX Campaign Import allows for loading campaign information and projected performance details into the OrderLogix application for connection to media buys and reporting purposes. File Format: ASCII text. The file must contain one line per ...

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