Transit time calculations for Deliv 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 Work Days and 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 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

•Weekend file containing information about the days the carrier operates - Optional

When you import these files, Parcel inserts the data from these files into the Deliv carrier database.

Notes:

•Since the US Post Office (USPS) does not guarantee delivery dates or times, time in transit calculations for carriers such as Deliv 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 Deliv 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 Transmit 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 Weekend file are: "y" (without quotation marks) if the day is a weekend day and "n" (without quotation marks) if it is not a weekend day.