Sam Export Formats

Note: The Sam export requires a separate license fee. Contact the Naviga Support Center for details.

File type: Pipe delimited. Character fields will not be padded with spaces and integer fields will not be padded with zeros. Two files, a draw file and a global file, are exported.

Location: /dti/exchange/cm. The draw file name is specified at runtime. The global file will have the same name but have a suffix of “GLBL.txt”.

Draw File

Record: Header

Field	Format	What is exported by Circulation	What is exported for mail
Record Type	x(1)	“H”	“H”
File Type	x(10)	“Circ”	“Circ”
Version	99.99	“2.2”	“2.2”
Circulation Group	x(10)	Circ Group entered at runtime	Circ Group
Blank (bundle size)	—

Record: Detail (one record per route or, if mail is exported, label group)

Field	Format	What is exported by Circulation	What is exported for mail
Record Type	x(1)	“D”	“D”
Plant	x(10)	Plant code from the Business Rules, or, if blank, the Circ Group entered at runtime	Plant code
Issue Date	mm/dd/yyyy	Draw date entered at runtime	Draw date
Account Code	x(20)	Route ID	Label group ID
Account Group	x(20)	Route’s ad zone, ZIP, truck, parent truck, district, zone, or carrier ID, based on the Account Group Type field	Label group ID
Account Type	x(5)	The GMA account type mapped to route’s route type in Account Type setup	“MAIL”
Content Code	x(8)	Product ID, edition, edition + demographic, or depot, based on Business Rules	Product ID, edition, edition + demographic, or depot
Zone	x(10)	Route’s ad zone, ZIP, truck, district or distribution zone, based on the Zone Type field entered at runtime	Label group ID
Zone Group	x(5)	Route’s SAM account type, time zone ZIP Code, or route ID, based on the Business Rules	“MAIL”
Quantity	9999999	Total draw for route	Total draw of label group
Pad Disable Flag	y/n	For single copy routes, “Y” or “N”, if the route has an answer to the Pad Disable single copy demographic identified in the Business Rules. Otherwise, blank	Blank
Parent Truck	x(10)	Truck leaving the dock (if not a relay truck, this is also the truck dropping the route)	“MAIL,” or the truck ID if the label group has a mail truck
End Truck	x(10)	Truck dropping route. If the truck dropping the route also leaves the dock (i.e. there is no relay truck) this field will be blank and the truck ID will be exported in the Parent Truck field	“MAIL,” or the truck ID if the label group has a mail truck
Drop Name	x(10)	Route ID or truck ID, based on Business Rules	Label group ID
Drop Sequence	99999 or 9999999999.99999	If Drop Name is route ID, route’s drop order on truck.Relay truck’s drop sequence parent truck may be included, based on Business Rules. If Drop Name is truck ID, the truck’s drop order on the relay parent or (if truck leaves dock), “1.”	Record number (increments for each record exported)
Package	—	Blank	Blank
Shift	—	Blank	Blank
Address flag	y/n	N	N
Saturation level	—	Blank	Blank
Endorsement line	—	Blank	Blank
ZIP Code	—	Blank	Blank
Postal carrier route	—	Blank	Blank

Record: Message Records (exported if Export Messages is checked)

Field	Format	What is exported by Circulation
Record Type (record 1)	x(2)	“CM”
Message	x(180)	Subscriber address
	x(14)	Subscriber phone number
Record Type (record 2)	x(2)	“CM”
Message	x(100)	Delivery directions
	x(100)	Delivery instructions
Record Type (record 3)	x(2)	“CM”
Message	x(16)	“ACCT:” + Subscriber account ID
	x(11)	“COPIES:” + Number of subscriber copies
	x(26)	“BILL METH:” + Subscriber billing method
	x(19)	“DEL SCHED:” + Subscriber delivery schedule
	x(23)	“TRAN TYPE:” + Tran type for message
	x(38)	“REASON:” + Transaction reason code
	x(30)	“MESSAGE START DATE:” + Start date for message
Record Type (record 4)	x(2)	“CM”
Message	x(18)	“EXPIRE:” + Subscriber’s expire date
	x(24)	“RESTART DATE:” + Subscriber’s restart date, if Business Rules are set to print restart date on bundle tops
	x(23)	“NEW DEL SCHED:” + Subscriber’s new delivery schedule
	x(24)	“PREV DEL SCHED:” + Subscriber’s previous delivery schedule
	x(20)	“DAYS DONATED:” + Number of days donated by transaction
	x(25)	“PREV DEL DATE:” + Date of previous delivery paper
Record Type (record 5)	x(2)	“CM”
Message	x(200)	Transaction remarks
Record Type (record 6)	x(2)	“CM”
Message	x(200)	Message text

Record: Summary

Field	Format	What is exported by Circulation
Record Type	x(1)	“S”
Create Date	mm/dd/yyyy	Export create date
Create Time	hh:mm:ss	Export create time
No. Records	9999999999	Number of records exported
Total Draw	9999999999	Total draw exported

Global File

Note: If mail numbers are exported, one record is exported to the Global File per label group for mail, with the label group ID exported as the drop name, “MAIL” exported as the drop description, and all other fields blank.

Record	SAM Field	Field Exported	Format
Header	Start of header record	“H”	x(1)
	File type	“GLOBAL”	x(10)
	Version	“1.1”	99.99
Detail (one record per route)	Start of drop name record	“DN”	x(2)
	Drop Name	Route ID	x(20)
	Drop Description	Route Name	x(30)
	Drop Region	blank	x(30)
	Address 1	Address line 1 of carrier address, route’s default drop location, or drop location entered with truck sequence, as determined by Drop Where field in truck sequence. Single copy routes may have a demographic answer export to the Address 1 and Address 2 fields, as defined by the Business Rules.	x(30)
	Address 2	Address line 2 of carrier address (if carrier address is exported in Address 1) or second part of drop location (if over 30 characters)	x(30)
	City	Carrier city (if carrier address is exported in Address 1). Otherwise cityentered for route	x(30)
	State	Carrier state (if carrier address is exported in Address 1). Otherwise state entered for route	x(2)
	ZIP Code	Carrier ZIP Code (if carrier address is exported in Address 1). Otherwise blank	x(10)
	Delivery comments	Drop instructions entered with truck sequence	x(60)
Summary	Beginning of Summary record	“S”	x(1)
	Create date	Export create date	mm/dd/yyyy
	Create time	Export create time	hh:mm:ss
	Number of records	Number of records exported	9999999999