Mediaocean AP import file specification

Accountability's integration with Mediaocean automates the import of client media.

Overview

Accountability’s integration with Mediaocean automates the import of client media. This document describes the file import process and specification for Mediaocean’s media AP data.

SFTP details will be provided by Accountability to your Mediaocean representative. Accountability will check and retrieve files from your SFTP folder intra-day every 15 minutes, unless otherwise specified.

File format and validation

Each file must adhere to a pre-defined file format in CSV (Comma Separated Value) or XLSX (MS Excel Open XML Spreadsheet).

File name guidelines:

Prepend AP to the file name and use the ISO date and 24-hour time format, e.g.

AP12345_20221214_135135.csv

The import process will first validate that all required master data records exist in Accountability, then check that the file format is valid.

Error messages are sent to the Default Administrator email address entered on the Mediaocean Configuration page.

Data columns

The Mediaocean AR Import File needs to have all the following columns. Each Column Header label needs to be exact for the file to pass validation.

Col	Spectra OX Column Header	Ignitia Column Header	Required?	Details \| Notes
A	Media	Media	Yes	Media Type Name Needs to have a corresponding Media Type record in Accountability
B	Sys	Sys	Yes	Media System initial, e.g., P for Print and Digital
C	Loc	Loc	Yes	Media Office Needs to be mapped to a valid Accountability Office
D	Vendor	Vendor	Yes	Media Vendor Code (Payee) Needs to be mapped to a valid Accountability Supplier record
E	Vendor Name	Vendor Name	Yes	Media Vendor Name
F	Invoice Number	Invoice Number	Yes	Media Supplier Invoice Number
G	Client	Client	Yes	Client Code Needs to have a corresponding Accountability Client
H	Inv Date	Inv Date	Yes	Invoice Date in the format MM/DD/YY
I	Est	Est	Yes	Estimate Number
J	Product	Product	Yes	Product Code Needs to have a corresponding Product within a valid Accountability Client
K	Client Name	Client Name	Conditional	Client Name Required if the option to automatically create new clients is enabled
L	Product Name	Not available	Conditional	Product Name Required if the option to automatically create new products is enabled
M	MOS	MOS	Yes	Media Month of Service in the format MM/DD/YY
N	Pub/Sta/Net	Pub/sta/net	Conditional	Station, Network, or Pub Code assigned to the buyline Media Cost Control (aka Media WIP) reporting within Accountability requires this data on both the Media AR and Media AP files
O	Sta/Net/Pub Nam	Not available	Conditional	Station, Network, or Pub Name
P	Estimate Name	Not available	Optional	Estimate Name
Q	Remit	Remit	Optional
R	Cleared	Cleared Date	Yes	Clearance date in MM/DD/YY format
S	Inv Amount	Inv Amount	Yes	Total Payable Amount
T	Inv Tax	Invoice Tax	Optional	Payable Tax if applicable
U	Inv Gross	Invoice Gross	Optional	Supplier Gross Amount
V	Inv Net	Invoice Net	Optional	Supplier Net Amount