Stacker Interface
Note: All of the stacker interfaces require a separate license fee to use. Contact the Naviga Support Center for more information.
File type: Fixed Length. The format used depends upon the brand of stacker machine, and is controlled by Business Rules. Note that not all versions of each stacker brand is supported—please verify the file format with the format required by your stacker version.
Location: /dti/exchange/cm
iDAB
Header record
L
The route If there are inserts, the final mix name is appended to the L record with a period (.) separator.
E
The edition; will be blank if the publication is not started by edition. If started by edition, one file will be created for each edition selected. The edition ID will be appended to the filename.
Detail record
I
The date (8 characters)
F
Paper type; always “1” for broadsheet
P
Number of pages from Enter Bundle Info
M
Minimum size from Enter Bundle Info
A
Maximum bundle size from Enter Bundle Info
S
Standard bundle size from Enter Bundle Info
Note: If multiple bundle sizes are entered, the M, A, and S records will be taken from the first bundle size record found.
B
Batches in a bundle (CUTS from Enter Bundle Info)
K
Key sequence. Always “4”.
For each truck:
T
Truck ID (8 characters)
X
Key bundle size (3 digits)
N
Number of standard bundles (4 digits)
KANSA
One record is read for each bundle on each route.
Truck ID
8
character
The truck for this route
Route ID
8
character
The route
Bundle Size
3
integer
The size for this bundle
Bundle Size
3
integer
The bundle size divided by 2 and rounded up
QUIP
One record is read for each bundle on each route.
Truck ID
8
character
The truck for this route
Bundle Size
3
integer
The size for this bundle
Record Counter
4
integer
This starts at 1 and increases by 1 for every record created
Edition
4
character
The edition for this route
Route ID
8
character
The route
HALL
One record is created for each truck, one for each route’s standard bundles, and one for each routes’s key bundle (two if split key).
TI
2
“TI” marks the beginning of the truck record
Truck ID
7
character
The truck
?
1
“?” marks the end of the truck record
RN
2
“RN” marks the beginning of the route record
Route ID
8
character
The route
?BQ
3
“?BQ” marks the start of bundle information
# of Bundles
3
integer
The number of bundles contained in this record
?SS
3
“?SS” marks the beginning of bundle size information
Bundle Size
3
integer
The size of the bundles in this record
?SC01
5
“?SC01” marks the end of the route record.
WinLincs
Note: To use the WinLincs format, your trucks must be set up in one of the ways shown below.
If you need WinLincs data by ad zone, you must have your trucks set up as follows:
Parent Truck A (a physical truck that contains only relay trucks but no routes). The relay trucks represent ad zones of this physical truck.
Truck A1 (contains relay trucks and routes for ad zone “123”, for example)
Truck A2 (contains relay trucks and routes for ad zone “246”, for example)
etc.
Parent Truck B (same as above)
Truck B1 (contains relay trucks and routes for ad zone “369”, for example)
Truck B2 (contains relay trucks and routes for ad zone “456”, for example)
etc.
If you do not need WinLincs data by ad zone, you must have one parent truck, and all trucks must be defined as relay trucks on the parent truck. For example:
Parent Truck A
Truck A1
Truck A2
Truck A3
etc.
The WinLincs interface creates the following records:
A header record
Truck data, which contains a record for each relay truck
Route data
Header Record
This record is fixed length, and each value is separated by a space. A carriage feed and line feed terminates each line.
VER
3
character
“VER”
DATE
6
date
Publishing date
NUMBER
6
character
“NUMBER”
ZONE_DESC
10
character
“ZONE_DESC”
PACKET
6
character
“PACKET”
COUNT
5
character
“COUNT”
DONE
4
character
“DONE”
PRE-HALT
8
character
“PRE-HALT”
POST-HALT
9
character
“POST-HALT”
STATUS
6
character
“STATUS”
STACK_SIZE
10
character
“STACK_SIZE”
COMP
4
character
“SIZE”
BATCH
5
character
“BATCH”
PRINT_DATA
10
character
“PRINT_DATA”
DELIVERY
8
character
“DELIVERY”
Truck Data
This record is fixed length, and each value is separated by a space. A carriage feed and line feed terminates each line.
Zone Sequence Number
9
integer
Sequence number, starting with 000000001
Zone Description
19
character
Truck ID
Packet ID
10
character
Truck ID
Required Count
9
integer
Draw count for the truck (including relay draw)
Done Count
9
integer
Value=”0”
Pre-Halt Flag
1
Y/N
Value=”N”
Post-Halt Flag
1
Y/N
Value=”N”
Status
1
character
Value=”N”
Stack Size
4
integer
Bundle size for the truck
Bundle Compensation Size
4
integer
Bundle size for the truck, divided by 2 (rounded up, if necessary)
Batch Quantity
4
integer
Not used
Print Data
30
character
Not used
Delivery Point
1
character
Value=”A”
Route Data
This record is variable length, and each value is separated by a pipe symbol, “|”. A carriage feed and line feed terminates each line. A route record is created for every route on the truck, even if the truck is defined as “bulk” loaded. Illegal bundles are exported at the beginning of the truck. They can be exported individually or combined into one line, based on Business Rules.
Route
9
character
Value=”**ROUTE**”
Route ID
8
character
Route ID
Draw Count
6
integer
Draw count for the route
Truck Information
14
character
Value= “Truck=”TruckID. For example, “Truck=Dock”.
Zip Information
9
character
Value= “Zip=”Zip Code. For example, “Zip=73533”.
Drop Information
13
character
Value= “Drop=”Drop Order. For example, “Drop=1400”.
Muller Martini
Note: When no Stacker File Name is specified in Enter Bundle Info, the file name will be:
“MULLER” + <2-digit day of the month> + <3-character day of the week> + <product ID> + <Edition>. If the Edition is less than four characters, zeroes will be added to the front.
Header Record
Date
DDMMYY
Publishing date
Page Count
99
Page count
Format change indicator
X(1)
Value=”F”; must be upper case
Format Number
99
Value=”00”
Filler
x(77)
Space filled
Detail Record
Truck Number
X(3)
Last two positions of the truck ID, prefaced with a 0 (zero)
Sequence Number
999
Always starts at 000 and increases without regard to changes in trucks
Account Number
X(6)
Account ID assigned to the route
Name
X(30)
First and last name assigned to the account
Drop Information
X(30)
Drop location assigned to the drop
Bundle Type
N
Value=”0” for key label only; 1-9 if all bundles require a label
Draw Quantity
NNNNN
Draw total (includes all draw types)
Standards
NNN
Value=”000”
Odd Count
NNN
Value=”000”
Number of Bill Posters
N
Value=”0”
Box-out Draw Quantity
X(3)
Draw quantity for the Business Rules-defined single copy type. Last value uses an over-punch. For example, zero would be presented as “00{“, and two would be presented as “00B”.
Ferag
This file is fixed length. The file format is shown below.
Note: When no Stacker File Name is specified in Enter Bundle Info, the file name will be:
“FERAG” + <2-digit day of the month> + <product ID> + <3-character day of the week> + <Edition>.
Title Record
Start Title Record
X(5)
Value=”%2440”
No
Title Name Indicator
X(3)
Value=”+40”
No
Title Name
X(8)
Value=<weekday name><first two characters of ProductID> or Value=<weekday name><first two characters of ProductID><first three characters of EditionID> Note: EditionID is included when the product is processed by Edition in the Publishing Run.
No
Publication Date Indicator
X(3)
Value=”+95”
No
Publication Date
DDMMYY
Publishing Date, formatted DDMMYY
No
Production Date Indicator
X(3)
Value=”+98”
No
Production Date
DDMMYY
Production Date, formatted DDMMYY
No
Additional Title Indicator
X(3)
Value=”+08”
No
Additional Title Info
X(50)
<Publication Name> + “ “ + <Edition Name>
No
End Title Record
X(1)
Value=”!”
No
Truck List Record
Start Truck List Record
X(5)
Value=”%2401”
No
Truck ID Indicator
X(3)
Value=”+11”
No
Truck Name
X(13)
Value=”RT” + Truck ID + <A> or <B>. Value “A” for processing bundles equal or under minimum. Value “B” for processing bundles above the minimum.
No
End of Truck List Record
X(1)
Value=”!”
No
Truck Detail Record
Start Truck Detail Record
X(5)
Value=”%2402”
No
Truck ID Indicator
X(3)
Value=”+11”
No
Truck Name
X(13)
Value=”RT” + Truck ID + <A> or <B>. Value “A” for processing bundles equal or under the minimum. Value “B” for processing bundles above the minimum.
No
Limit Bundle Indicator
X(3)
Value=”+30”
No
Limit Bundle Size
9999
Minimum bundle size defined within distribution info (left fill with zeros)
No
Max Stack Bundle Indicator
X(3)
Value=”+31”
No
Max Stack Bundle Size
9999
Maximum stack bundle size defined within distribution info (left fill with zeros)
No
Standard Bundle Indicator
X(3)
Value=”+32”
No
Standard Bundle Size
9999
Standard bundle size defined within distribution info (left fill with zeros)
No
N Bundle Indicator
X(3)
Value=”+33”
No
N Bundle Parameter
9999
The number of stacks per bundle defined within distribution info (left fill with zeros)
No
Max Bundle Indicator
X(3)
Value=”+34”
No
Max Bundle Size
9999
Maximum bundle size defined within distribution info (left fill with zeros)
No
SZ Bundle Indicator
X(3)
Value=”+35”
No
SZ Bundle Size
9999
Value=”0000”
No
DB Flag Indicator
X(3)
Value=”+59”
No
DB Flag
9
Value=”3”
No
EA Flag Indicator
X(3)
Value=”+69”
No
EA Flag
9
Value=”0”
No
Edition Name Indicator
X(3)
Value=”+20”
No
Edition Name
X(30)
Edition Name
No
End of Truck Detail Record
X(1)
Value=”!”
No
Route Start Record
Route Start Record
X(5)
Value=”%2403”
No
Route Start Indicator
X(3)
Value=”+12”
No
Account ID
X(10)
Delivery carrier’s account ID
No
Copies Indicator
X(3)
Value=”+13”
No
Number of Copies
99999
Total Draw for this route
No
End of Route Start Record
X(1)
Value=”!”
No
Bundle Characteristics Record
This record is created only for the first route on the truck.
Start Bundle Characteristics Record
X(5)
Value=”%2404”
No
Bundle Characteristics Record Indicator
X(3)
Value=”+52”
No
Create Indicator
X(23)
Value=”0313^CREATE;<ProductID>;576”
Yes
????
X(5)
Value=”ALPHA”
Yes
Bundle Characteristics (1)
X(38)
Value=”35;3;3;3;” KEY=08 STD=14 TOTAL=06””
Yes
Bundle Characteristics (2)
X(14)
Value=”6;68;2;2;”=24””
Yes
Bundle Characteristics (3)
X(17)
Value=”6;3;3;3;”A/C No-””
Yes
Bundle Characteristics (4)
X(15)
Value=”44;96;3;3;”=07””
Yes
Bundle Characteristics (5)
X(14)
Value=”8;68;2;2;”=25””
Yes
AF1 Characteristics
X(14)
Value=”AF1;8;6;30;3;3”
Yes
AF2 Characteristics
X(15)
Value=”AF2;13;2;68;3;3”
Yes
AF3 Characteristics
X(15)
Value=”AF3;30;23;3;3;3”
Yes
AF4 Characteristics
X(15)
Value=”AF4;30;20;3;3;3”
Yes
AF5 Characteristics
X(15)
Value=”AF5;30;15;3;3;3”
Yes
AF6 Characteristics
X(14)
Value=”AF6;8;6;95;3;3”
Yes
AF7 Characteristics
X(15)
Value=”AF7;30;26;3;3;3”
Yes
AF8 Characteristics
X(15.3)
Value=”AF8;30;31;45;3;3”
Yes
AF9 Characteristics
X(13)
Value=”AF9;8;2;3;3;3”
Yes
AF10 Characteristics
X(16)
Value=”AF10;30;2;20;3;3”
Yes
AF11 Characteristics
X(15)
Value=”AF11;8;2;10;3;3”
Yes
Stop Indicator
X(4)
Value=”STOP”
Yes
End Indicator
X(3)
Value=”END”
Yes
End of Bundle Characteristics Record
X(1)
Value=”!”
No
Route Detail Record
Route Detail Record
X(5)
Value=”%2404”
No
Route Detail Indicator
X(3)
Value=”+58”
No
???
9999
Value=”0314”
No
Execute Command
X(15)
Value=”^EXECUTE;<ProductID>”
Yes
AF1 Data
X(15)
Value=”^AF1;”<Account ID>”” Note: Account ID is the delivery carrier.
Yes
AF2 Data
X(20)
Value=”^AF2;”<Truck ID><\><Sequence Number>”” (Sequence Number always starts at 0000 and increases without regard to changes in trucks)
Yes
AF3 Data
X(37)
Value=”^AF3;”<Drop Location Line 1>””
Yes
AF4 Data
X(37)
Value=”^AF4;”<Drop Location Line 2>””
Yes
AF5 Data
X(37)
Value=”^AF5;”<Drop Location Line 3>””
Yes
AF6 Data
X(15)
Value=”^AF6;BO “<draw quantity for draw class defined in Business Rules> Note: Draw quantity is optional.
Yes
AF7 Data
X(21)
Value=”^AF7;” ““
Yes
AF8 Data
X(21)
Value=”^AF8;” ““
Yes
AF9 Data
X(15)
Value=”^AF9;”<Product ID>
Yes
AF10 Data
X(38)
Value=”^AF10;”<Edition Description>
Yes
AF11 Data
X(16)
Value=”^AF11;”<Edition ID>
Yes
<Blank>
<Blank>
<Blank>
Yes
Normal Indicator
X(7)
Value=”^NORMAL”
Yes
End of Route Detail Record
X(1)
Value=”!”
No
End of Truck Record
Start Truck Detail Record
X(5)
Value=”%2406”
No
Truck ID Indicator
X(3)
Value=”+11”
No
Truck Name
X(13)
Value=”RT” + Truck ID + <A> or <B>. Value “A” for processing bundles equal or under the minimum. Value “B” for processing bundles above the minimum.
No
End of Truck Record
X(1)
Value=”!”
No
End of Title Record
End Title Record
X(5)
Value=”%2411”
No
Title Name Indicator
X(3)
Value=”+40”
No
Title Name
X(8)
Value=<weekday><weeknumber>
No
End of End Title Record
X(1)
Value=”!”
No
Last updated
