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.