antsrouteantsrouteantsrouteantsroute
  • Solutions
      • DELIVERIES

          • parcel-delivery-antsroute-softwareParcel Delivery
            Make last mile deliveries management easier and enhance customer relations.

          • meal-delivery-antsroute-softwareFood and Fresh Produce Delivery
            Smartly manage meal, fresh and frozen produce deliveries.

          • merchandise-delivery-antsroute-softwareMerchandise Pick-up and Delivery
            Build optimized merchandise delivery routes and track your drivers in real-time.

          • fuel-delivery-antsroute-softwareFuel and Gas Delivery
            Build the best fuel and gas delivery routes increasing cubic meters delivered per km.

      • OPERATIONS

          • equipment-delivery-antsroute-softwareEquipment Installation
            Ensure the most efficient equipment installations and boost the productivity.

          • maintenance-antsroute-softwareRepair and Maintenance
            Track your field technicians and improve the quality of service provided.

          • cleaning-service-antsroute-softwareCleaning Service
            Build the most efficient cleaning services routes and boost the productivity of cleaners.

          • healthcare-antsroute-softwareHome Healthcare
            Create the best daily schedules for your healthcare workers to ensure quality home care.

    • Working in other industries? Contact us ➝
  • Features
      • FEATURES

          • smart-scheduling-antsroute-softwareSchedule appointments
            Efficient scheduling of deliveries and operations integrating logistics constraints.

          • live-tracking-antsroute-softwareTrack drivers
            Real-time updates sent to drivers and field workers via the mobile application.

          • analyse-route-data-antsroute-softwareAnalyze performance
            Data of routes and performance indicators analysis.
          • determine-route-antsroute-softwareOptimize routes
            Automated routes optimization cutting down travel time and costs.

          • update-customer-delivery-antsroute-softwareUpdate Customers
            Sending of SMS and email push notifications to customers.

          • digitize-route-antsroute-softwareDigitize processes
            Generate work and delivery orders and service reports.

      • PROCESS

          • Scheduling of deliveries and operations on date defined
            Import or schedule appointments on defined date.

          • Scheduling of deliveries and operations on incoming calls
            Guide customers to the best date and time slot in a few seconds.

          • Scheduling of deliveries and operations with customer confirmation
            Receive confirmation from customers or let them reschedule orders.
  • Resources
      • LEARN

        • Support
          Learn to use the software with our online guides and videos.

        • Integrations
          Connect AntsRoute with your favorite apps to boost productivity.

        • API
          The API allows you to synchronize your data with AntsRoute.

        • Customer testimonials
          Find out why companies have chosen the AntsRoute software to grow.

      • ABOUT

        • Blog
          All the solutions, tips and news about the AntsRoute software.

        • Contact us
          AntsRoute team is here to help with any questions.


    • Book a demo ➝
  • Pricing
  • Log in
  • Free trial
  • English
    • Français
    • Español
    • Deutsch
    •       

    • Enterprise

      • Privacy Policy
      • Terms of service
    • Product

      • Appointment scheduling
      • Route optimization
      • Field workers tracking
      • Push notifications
      • Service reports
      • Route reporting
      • Online booking site New

      • Pricing
    • Integrations
      • WooCommerce

      • Prestashop

      • Zapier New

      • Google Calendar

    • Solutions

      • Parcel delivery
      • Fresh produce delivery
      • Merchandise delivery
      • Fuel and gas delivery
      • Equipment installation
      • Repair and maintenance
      • Cleaning service
      • Home healthcare
    • Definitions

      • Route optimisation
      • Route optimisation software
      • Route optimization benefits
      • Route planner
      • Transport software
      • Field service management
    • Resources

      • Blog
      • Testimonials
      • Help center
      • API Rest
      • Contact us

> Import existing routes to re-optimize them

27 July 2020
Categories
Reoptimize routes, Route optimization
Tags

Support > Route optimization > Import existing routes to re-optimize them

  Import existing routes to re-optimize them

You can import existing routes, e.g. with third-party software, in order to re-optimize them. Just follow the steps below:

Enable the import of routes

1
Go to the “Sites” tab of the “First name – Last name” module.
2
Click on “…” and “Configure” from the table.

3
Click on “Settings”.
4
In the “General settings”, check the box “Enable route import”.
5
Click on the blue “Save” button.

Import established routes

1
Go to the “Import of established routes” tab of the “Schedule” module.
2
Select the date on which the routes are to be imported via the date picker in the upper right-hand corner.

3
Click on the green “Download a template” button to know the fields to fill in.
4
Check the presence of the fields below in the file.

Note: The names of columns (or headers) in the Excel or CSV table must be the same as the bold fields defined below (for example: Name, Address, etc.).

List of mandatory fields:

  • Name of the customer or possibly the company name ;

  • Address (For example: Earlham St, West End, London WC2H 9HU) ;

  • Duration in minutes. For example 120 ;

  • Registration number corresponding to the number defined from the “Vehicles” tab (for example: TS07 PBS).

Note: In the column “Registration number”, you must fill in the cells with the registration numbers defined from the “Vehicles” tab of the “Resources” module.

List of optional fields:

  • External client identifier, i.e. the customer code of your ERP (if you have one) (For example: C00013434) ;

  • First name or the company name ;

  • Phone number in international format (For example: +447111111111
) ;

  • E-mail (For example: marie@antsroute.com) ;

  • Postal code (For example: WC2H 9HU) ;

  • City (For example: London) ;

  • Latitude (For example : 48.731612) ;

  • Longitude (For example : 5.978622) ;

  • Comments (For example : Ask the guard for the key) ;

  • Time slot which is one of the time slots defined in “First Name – Last name” > “Sites” > ” … ” > “Configure” > “Time slot management”. The format must be HH:MM-HH:MM (e.g. 08:00-10:00) ;

  • Comp_XXX with XXX which is one of the skills defined in the settings. Just indicate whether the constraint applies or not (YES or NO) ;

  • Cap_XXX with XXX which is one of the capabilities defined in the settings. Just indicate the quantity to be transported. This number is an integer. For example 18.

Note: The phone numbers must be in international format. For example, +447111111111 for British phone numbers. To display the “+” mark in the table, format the cells as text.

Note: Make sure to delete empty columns in the table.

5
Click on the blue “Import your routes” button.
6
Select your .csv file.

After having imported your file, you get a summary table. Make sure that your file has no errors. Each row in the summary table should have a green background when the client wasn’t registered on AntsRoute and a white background when the client was already registered. When you make changes from this summary table, it is necessary to click on the blue “Validate” button below the table.

7
Click on the “Import” button located below the table.

Note: You can then find the imported routes in the “Agenda” tab of the “Organize” module. Just select the date on which the routes were imported using the date picker located in the top left-hand corner of the screen.

Related articles 🔍

> Partially re-optimize routes
> Keep the order of my routes when reoptimizing
Share
    •       

    • Enterprise

      • Privacy Policy
      • Terms of service
    • Product

      • Appointment scheduling
      • Route optimization
      • Field workers tracking
      • Push notifications
      • Service reports
      • Route reporting
      • Online booking site New

      • Pricing
    • Integrations
      • WooCommerce

      • Prestashop

      • Zapier New

      • Google Calendar

    • Solutions

      • Parcel delivery
      • Fresh produce delivery
      • Merchandise delivery
      • Fuel and gas delivery
      • Equipment installation
      • Repair and maintenance
      • Cleaning service
      • Home healthcare
    • Definitions

      • Route optimisation
      • Route optimisation software
      • Route optimization benefits
      • Route planner
      • Transport software
      • Field service management
    • Resources

      • Blog
      • Testimonials
      • Help center
      • API Rest
      • Contact us