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

Field	Description
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

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

Data	L	Type	Description
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.

Data	L	Type	Description
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).

Data	L	Type	Description
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.

Data	L	Type	Description
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.

Data	L	Type	Description
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.

Data	L	Type	Description
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

Field	Format	Value
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

Field	Format	Value
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

Field	Format	Value	New Line
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

Field	Format	Value	New Line
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

Field	Format	Value	New Line
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

Field	Format	Value	New Line
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.

Field	Format	Value	New Line
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

Field	Format	Value	New Line
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

Field	Format	Value	New Line
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

Field	Format	Value	New Line
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