Transit time calculations for a US Post Office carrier require user-maintained transit time data. You can import this data into the Parcel carrier database using the Import Time in Transit Files screen.  This feature also includes the capability for the user optionally to import and maintain carrier Holidays at the destination level for the Time in Transit calculation to include when calculating an expected delivery date.

You must create and maintain the following Time in Transit files for data import:

•Geographical information (origin/destination cities, postal codes, etc.) - Required for first import.

•Time in transit data based on carrier service and destination - Always required.

•Holiday file containing information about destination holidays - Optional

When you import these files, Parcel inserts the data from these files into the US Post Office carrier database. If you have Time in Transit enabled, when you perform a Rate or Ship, Parcel displays the transit time for the shipment.

Notes:

•Time in transit calculations for a US Post Office carrier are based on user estimate of typical delivery times for specific services and routes.

•All files that you import must be located on a local drive of the DIServer. The absolute path that you specify according to the following table represents the file location on the DIServer.

•This data does not come from the US Post Office and must be specified by the customer.

Import Time in Transit Files

Use the Import Time in Transit screen to import the following data files for transit times and locations (origins and destination (required files are in bold).

To import Time in Transit files:

1.Create the Time in Transit files (see the following section for file format information), and then copy these files to a directory local to the Parcel DIServer.

2.Use the Import Time in Transit screen in the Parcel Configuration (Web Admin) tool to specify the path names and filenames for these files according to the following table:

Format for Time in Transit Files

The time in transit files that you import (see previous section) must be comma-delimited CSV files of which the first row consists of the column (field) names listed in the following table. Subsequent rows contain comma-delimited data corresponding to the column names.

Notes:

•You can copy and paste the following column name strings directly into the CSV file.

•The values in the Geo Code fields can be arbitrarily defined, but since this column serves as the primary key, they must follow the same convention in all the files.

•The Origin and Destination address data for a shipment must be identical to the corresponding data in the Geographic Data file (Address <n>, City, State).

•The values for Transit Days and Transit Time are those estimated for the route defined by the Origin Geo Code and Destination Geo Core.

•The values for the day columns in the Work Days file are: "y" (without quotation marks) if the day is a working day and "n" (without quotation marks) if it is not a working day.