Bundle Sizes Import Format
Last updated
Last updated
File type: Fixed Length. A sample file is shown below.
Location: /dti/exchange/cm
Route
8
The single copy or home delivery route for which you are interfacing insert mix and bundle size information. You can have a record with a route of “*” to cover all other routes not included in the file.
Product
8
The publication for which you are interfacing insert mix and bundle size information.
Publish Date
8
The publishing date that you are interfacing information for, in mmddyyyy format (month, day, year).
Quantity
5
The draw quantity for this route. This quantity is used only for the mix records, and will not change the route’s actual or advance draw.
Mix Name
8
The name of the insert mix for this route. You can have a record with “*” to cover routes with no insert mix.
Mix Combination
10
The mix combination for this route. This corresponds to a certain combination of inserts being delivered by the route. This must be an integer.
Paper Section
8
The section of the paper where the preprints will be inserted. If you are interfacing sizes for a regular (rather than advanced run), leave this field blank.
Standard Size Minimum Size Maximum Size
3 3 3
In these fields, enter the bundle sizes for the route. Note: routes with the same mix combination should have the same bundle sizes. If the interface finds a route with the same combination but different sizes, it will prompt the user during runtime as to whether the sizes should be kept or updated.
Route
X(8)
01-Aug
Route ID
Ignore
Selling Product
X(8)
Sep-16
Deliverable
Circulation Product
Delivery Product
X(8)
17-24
TM Product — Deliverable to use
Ignore
Publish Date
99/99/9999
25-34
mm/dd/yyyy
Publishing Date
Quantity
9(9)
35-43
Draw Quantity
Ignore
Preprint Schedule ID
9(10)
44-53
Preprint Schedule ID
Ignore
Customer Name
X(32)
54-85
Advertiser Name
Ignore
Version Description
X(30)
86-115
Version Identifier
Ignore
Ad Line
X(20)
116-135
Ad Line for Insert
Ignore
Paper Section
X(8)
136-143
Section of the Paper
Section, or leave blank for the live run
Carrier Bonus Charge Code
X(8)
144-151
Charge Code for Bonus
Ignore
Bonus Amount
9(7.6)
152-165
Bonus Amount
Ignore
Preprint Type
X(8)
166-173
Preprint Type
Ignore
Weight
9(2.4)
174-180
Weight
Ignore
Package Name
X(8)
181-188
Mix Name
InsertPlus Mix Name
Package Sequence
9(10)
189-198
Mix Combination
InsertPlus Mix Combination
Standard Size
9(4)
199-202
Standard Bundle Size
Circulation only supports bundle sizes of 3 characters, so only the last 3 digits of each field are imported.
Minimum Size
9(4)
203-206
Minimum Bundle Size
Circulation only supports bundle sizes of 3 characters, so only the last 3 digits of each field are imported.
Maximum Size
9(4)
207-210
Maximum Bundle Size
Circulation only supports bundle sizes of 3 characters, so only the last 3 digits of each field are imported.
