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
          Synchronize the orders of your business tools with AntsRoute.

        • 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 appointments in the order bucket

17 July 2020
Categories
Basket of orders, Order scheduling
Tags

Support > Order scheduling > Import appointments in the order bucket

  Import appointments in the order bucket

It is possible to import the appointments with a due date via an Excel or CSV file into the order bucket by following these steps:

1
Go to the “Order bucket” tab of the “Schedule” module.
2
Click on the blue “Import orders into bucket” button.

Fill in the import file

Before importing your file on AntsRoute, download the import template and check the explanations on the fields to be filled in your file which are available on the right side of your screen.

3
Click on the green “Download template” button.
4
Fill in the fields below in your 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, Duration, Due-date, 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 ;

  • Due-date in YYYY-MM-DD (For example : 2020-01-01) or DD/MM/YYYY (For example : 01/01/2020) format. This date can’t be in the past.

List of optional fields :

  • Open-date, i.e. the date from which the appointment can be done in YYYY-MM-DD or DD/MM/YYYY format. For example 01/01/2018 ;

  • Id, i.e. the external identifier of the imported order. It is unique. It may correspond to the order number, batch, purchase order. For example: 20180101-1 ;

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

  • First name of 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) ;

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.

List of other optional fields when defined in settings :

  • Type of order. You must use the terms used when adding the types of order from the “First name – Last name” module (for example: pick-up or delivery) ;

  • 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: Make sure to delete empty columns in the table.

Upload the import file

5
Click on the blue “Upload your file” button.

Note: When the file has errors, you can view on the right side of the screen, the fields to be dragged into the corresponding columns. Then, click on the blue “Validate” button located below the list of optional fields.

After having imported your file, you get a summary table of customers. Make sure that your file has no errors and no duplicate appointments. 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.

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

Related articles 🔍

> Schedule a list of appointments over several days
> Schedule the appointments from the order bucket
> Add appointments to bucket
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