If your spreadsheet has duplicate data rows for a reference column, such as two rows with the same driver ID, the spreadsheet upload will only import one record using the last row of data.Īvailable columns for driver import include: Driver Full Name OR Last Name OR Reference ID, Reference ID Update, First Name, Timezone, Email Address, Phone Number, Alert Preferences, Driver ID, Driver Group.ĭriver ID refers to the identifier on a DriverID keyfob (if used). Replace Row 2+ with your own data.įields in the Reference column on the Update/Export page are required. Within the spreadsheet, column names appear in Row 1 and an example record appears in Row 2.Download one of the CSV Example templates ( 1, 2, or 3) next to the Create New users spreadsheet action.From the portal, hover over the Account menu, click Manage Drivers, and click Update/Export items using a spreadsheet.To add new drivers by importing from a spreadsheet: If your spreadsheet has more than this number it is recommended to break it up and perform multiple uploads for each group of 1,500 until it is complete. The maximum number of rows spreadsheet upload accepts is 1,500. If you already have data in the portal, it’s a good practice to first export the data for safe-keeping so that you can restore if you later make a mistake in your import.
You can use the import option for registering a large batch of drivers. The portal provides several options for importing and exporting data to and from a spreadsheet. Filter the Driver List grid using the new driver group to see the new driver.(Click the group name from the Driver Group List grid if you want to rename it.) A new driver group, “Drivers for ,” was also automatically created. Timezone is used to accurately timestamp alerts received by the driver.Ī message appears to indicate the driver was successfully saved. If you use Hours of Service, the Reference ID must match the driver’s HOS ID. Reference ID allows you to optionally identify drivers by an ID that’s understood at your company (e.g., employee ID). In the Add New Driver window, enter the driver details: First Name, Last Name, Reference ID, Timezone, Country, Email Address, Phone Number, and Alert Preference.At the bottom of the Driver List grid, click Driver next to Create New.The Manage Drivers and Groups page opens in a new browser tab. From the portal, hover over the Account menu, click Manage Drivers, and click Open.Enter Driver InformationĮntering drivers information manually is often used when you have a small number of drivers (1-5) to register at a time. You can create or update drivers by entering information into the web portal one at a time, or you can manage drivers in a batch process by importing data from a spreadsheet.
0 kommentar(er)
