Skip to main content

Importing and Exporting with RoadNet

Distributor steps for exporting RoadNet order, Territory Planner, location and other files from the Delivery Optimizer Import/Export screen in Encompass, with file layouts. Needs RoadNet setup and v23.12+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 23.12

Pre-Conditions

Steps

Exporting and Downloading Files out of Encompass
​
​Files can be exported by clicking on the Import/Export button located on the Delivery Optimizer dashboard.
​
​Order Files
​
​Creating the RoadNet Orders text file as follows:

  1. Select the Date, Location, and Routes you want to export.
    ​
    ​

  2. Click the RoadNet Orders button to create the RoadNet Orders text file NOTE: The order files MUST be manually downloaded unless a Mailbox has been set up as mentioned in the RoadNet Integration Setup.
    ​
    ​

  3. Manually download the RoadNet Orders file by right-clicking on the Orders.txt link and select Save Link As.
    ​
    ​

  4. Name the file and select the location you want to save the file to.
    ​
    ​

Territory Planner Files

  1. Select the number of sales months.
    ​
    ​

  2. Click on the Territory Planner Stops Button to create the TP Upload text file.
    ​
    ​

Other Files
​
​

Brands, Employees, Drivers, Products (Items.txt), Customer Locations,and Packages can be exported by clicking the Other Files button.

  1. Click on the RoadNet Customer Locations button to export the Locations text file.
    ​
    ​

  2. A new tab will open when the files are ready to download. Download the files by right-clicking on the filename link and select the Save Link As option

Fields And Definitions

File Specifications
​
​

  • Orders.txt: The Roadnet Orders file default configuration is stored in the RoadNet Exchange Map. See RoadNet Integration Setup.

Other Export Files
​
​
​Vehicles.txt
​
​

  • Vehicle ID (StartOffset=0 Len=15)

  • Vehicle Name (StartOffset=15 Len=35)
    ​
    ​

  • Vehicle Trailer (StartOffset=50 Len=35

  • Need to add vehicle type
    ​
    ​

Brands.txt
​
​

  • Brand ID (StartOffset=0 Len=15)
    ​
    ​

  • Description (StartOffset=15 Len=30)

Employees.txt
​
​

  • Employee ID (StartOffset=0 Len=15)

  • First Name (StartOffset=15 Len=35)
    ​
    ​

  • Last Name (StartOffset=50 Len=35)

  • Employee Type (StartOffset=85 Len=3)
    ​
    ​

Drivers.txt
​
​

  • Driver ID (StartOffset=1 Len=15)

Items.txt
​
​

  • SKU (StartOffset=0 Len=15)

  • Description (StartOffset=15 Len=45)
    ​
    ​

  • Package Type ID (StartOffset=60 Len=15)

  • Brand ID (StartOffset=75 Len=15)
    ​
    ​

Packages.txt
​
​

  • Package Type ID (StartOffset=0 Len=15)
    ​
    ​

  • Description (StartOffset=15 Len=30)
    ​
    ​

Locations.txt
​
​

  • Field Name Start Offset Length

  • Customer Location ID 0 15
    ​
    ​

  • Customer Location Name 15 60
    ​
    ​

  • Address Line 1 75 50
    ​
    ​

  • City 125 30
    ​
    ​

  • State 155 20
    ​
    ​

  • Zip Code 175 10
    ​
    ​

  • Phone Number 185 20
    ​
    ​

  • Address Line 2 205 20
    ​
    ​

  • County 225 30
    ​
    ​

  • Fax 255 20
    ​
    ​

  • Store Number 275 15
    ​
    ​

  • Delivery Days MTWRFSU 290 7
    ​
    ​

  • Latitude 297 11
    ​
    ​

  • Longitude 308 12
    ​
    ​

  • Standard Delivery Instructions 320 255
    ​
    ​

  • Contact 575 255
    ​
    ​

  • Avg CaseEquivs Per Stop 830 15
    ​
    ​

  • Open Time AS HH:MM 845 5
    ​
    ​

  • Close Time AS HH:MM 850 5
    ​
    ​

  • Time Window 1 Start AS HH:MM 855 5
    ​
    ​

  • Time Window 1 Stop AS HH:MM 860 5
    ​
    ​

  • Time Window 2 Start AS HH:MM 865 5
    ​
    ​

  • Time Window 2 Stop AS HH:MM 870 5

  • Phase Active Weeks AS XXXX 875 4

Did this answer your question?