Prepare a driver file

When you create a CSV file for importing historical data for your driver, you must follow a file structure. This ensures that your forecasting data is accurate. Follow the format in this section when creating your CSV file.
  • Action Column: Specify these actions:
    • insert : Add drivers.
    • delete : Remove drivers.
    • update : Update existing records.
  • Team Name: Specify the team name.
  • Driver Column (Column C): Specify the name of the driver.
  • Date Column (Column D): Specify the date for the driver. Use the YYYY-MM-DD HHmm format.
  • Values: Specify relevant metrics for your driver such as sales volume, overtime hours, or time offs.
It is important that you take note of these points when creating a driver file:
  • Create the driver before you import the CSV file.

    See Creating a driver.

  • Follow the correct format and do not modify the date or time structure.
  • Do not include extra spaces within or at the end of team or driver names.
  • You can split multiple drivers and teams across multiple files or include them in one file.