Page Comparison

Image Removed

...

Specify a file format

Image Removed

...

Specify column delimiter

Image Removed

...

Specify column mapping

Image RemovedThe Contract Stop Import Wizard allows you to import contract route stops directly to an X Route contract, set the schedule for the stops, and specify the assigned route.

How to Use the Contract Stop Import Wizard

Go to X Route > Contracts.
Image Added
Double-click the customer contract you would like to import the contract stops to.
In the top left of the Edit Contract form go to File > Import Stops.
Choose the .csv file you would like to import.
Image Added
If you have an import specifications file (.def file) you would like to use click the Load Import Specifications button.
If your file has a header row, make sure that the box is checked and click the Next button. By default, the Text Qualifier is set to "Double Quote" which should work for most imports, but you can change this accordingly to match your document.
Image Added
Select the delimiter. This is usually a comma.
Image Added
Check that the data that will be imported looks correct and click the Next button.
Set default data and check that the columns are mapped correctly then click next.
Image Added
See Specify Column Mappings below for TargetField descriptions.
If you would like to save your default specifications to use in future imports (step 5) click the Save Import Specifications button.
Image Added
Click the Finish button.

Specify Column Mapping

...

Field Name	Description
Billing Group

Here you can enter the

The billing group from the customer form

(this can be left blank)

.

GroupID

Here you can specify the

The group folder ID the stop should go to in route planning.

This must be the group folder ID number and not the group folder name (this can be left blank)

RouteID

This is the

Route ID

that

to assign the

imported

stop

will go

to

, if

. If left blank the stop will go to unassigned

(this can be left blank)(Required) This is the

.

Sequence

This is the stops sequence number (this can be left blank)OverRideCommissions(Required) Enter a monetary valueName(Required) Enter an Address NameAddressHere is where you enter the address for the route stop (this can be left blank)CityHere is where you enter the city for the route stop (this can be left blank)StateHere is where you enter the State of the route stop (this can be left blank)ZipHere is where you enter the zip code for the route stop (this can be left blank)Plus4Here is where you enter the Plus for of the zip code for the route stop (this can be left blank)PhoneHere you can enter a contact phone number for the route stop (this can be left blank)AttnHere you can enter any text if applicable (this can be left blank)LongRemarksHere you can enter any text if applicable (this can be left blank)ShortRemarksHere you can enter any text if applicable (this can be left blank)StopTypeHere you can specify the stop type when you import the contract stop (this can be left blank)Pieces(Required) This is the number of pieces on the stopWeight

The order in which the stop will show up on the route. This value can be between 0 and 2,147,483,647.
OverRideCommissions	Whether or not to override commissions. If left blank, this will default to 0 (No). 0 - No 1 - Yes
Name	Address Name. 50 character limit.
Address	The address for the stop. 50 character limit.
City	The city for the stop. 50 character limit.
State	The state of the stop. 3 character limit
Zip	The zip code for the stop. 5 character limit.
Plus4	The plus for of the zip code. 4 character limit.
Phone	The contact phone number for the stop has a 50 character limit.
Attn	The Attn field has a 50 character limit.
LongRemarks	Long remarks for the stop. There is a 200 character limit.
ShortRemarks	Short remarks for the stop. There is a 200 character limit.
StopType	Specified stop type for the stop. This cannot have a NULL value. 0 - Pickup 1 - Delivery 2 - Exchange 3 - Meet 4 - Flight 5 - Start 6 - End
Pieces	The number of pieces on the stop. This cannot have a NULL value.
Weight	The total weight of pieces on the stop. If left blank it will default to 1. This cannot have a NULL value.
ParcelType

Here you can set the

The parcel type

for the the route stop enter parcel ID from (X Dispatch Maintenance -> Parcel types) (this can be left blank)Reference1(Required) Enter text if applicable, can leave blank.Reference2(Required) Enter text if applicable, can leave blankRatePerOccurrence(Required) Enter numeric dollar amount, or enter 0SettlementPerOccurranceHere you enter the driver settlement amount per occurrence (this can be left blank)NotesEnter text if applicable (this can be left blank)StopTimeMin(Required) Stop

ID.
Reference1	References for the stop. There is a 50 character limit. It cannot have a NULL value but can be left blank.
Reference2
RatePerOccurrence	The dollar amount to charge the customer for this stop.
SettlementPerOccurrance	The dollar amount to pay the driver for this stop if using a per stop pay method.
Notes	Notes for the stop. There is a 2000 character limit. It cannot have a NULL value but can be left blank.
StopTimeMin	Min stop time entered in military time (XX:XX)

ex.

. If left blank, it will default to 22:00.

Example

Enter 16:00

=

for 4:00PM.

StopTimeMax

(Required) Stop

Max stop time entered in military time (XX:XX)

ex.

. If left blank, it will default to 22:00.

Example

Enter 16:00

=

for 4:00PM.

StopTimePreferred

(Required) Stop

Preferred stop time entered in military time (XX:XX)

ex.

. If left blank, it will default to 22:00.

Example

Enter 16:00

= Description(Required) Enter in description text.RateMultiplierHere you can enter the rate multiplier for the stop, if applicable (this can be left blank)DepotHere you can specify the Depot for the stop (this can be left blank)LatHere you can enter the Latitudinal point for the address (this can be left blank)LonHere you can enter the Longitudinal point for the address (this can be left blank)RouteSurchargeAdjustment(Required) Enter numeric dollar amount, or enter 0CreatedByHere you can enter the userID performing the import (this can be left blank)CreatedWhenHere you can enter the date and time of the import (this can be left blank)UpdatedByHere you can enter the User ID

for 4:00PM.

ChildOf

here you can specify if this is a child stop of another route stop (this can be left blank)

The Load To Stop ID if using Stop Chaining. (Downstream)
Description	Description for the stop. There is a 250 character limit. It cannot have a NULL value but can be left blank.
RateMultiplier	Amount of times to multiply the per stop charge for this stop. This can be a decimal number.
Depot	The ID for the depot for the stop.
Lat	Latitudinal point for the address.
Lon	Longitudinal point for the address.
RouteSurchargeAdjustment	The numeric dollar amount of the route surcharge adjustment, or enter 0 for no adjustments. This will default to 0.00 if left blank.
CreatedBy	The User ID of the person performing the import.
CreatedWhen	The date and time of the import.
UpdatedBy	The User ID of the person performing the import if updating contract stops that already exist

(this can be left blank)

.

UpdatedWhen

Here you can enter the date

The date and time if updating contract stops that already exist

(this can be left blank)

.

UserField1