This tool is provided as an example and is available on an As-Is basis. You must assume all the risks and costs associated with the use of the sample tool, including, without limitation, any damage to any equipment, software, information or data. In addition, we are not obligated to provide any maintenance, technical or other support for the sample tool. In order to improve our products, we may at any time, and without warning, change the design, presentation, or functionality of the software.
To make things easier, we've provided you with an excel template. Please follow the input requirements outlined in the Help menu.
Keep in mind that Time Zone is a required input and if a license plate is entered, it must be unique to the database. License state is required only if a license plate is provided. You may enter a state other than those provided.
NFC and Custom NFC keys must be unique to the database; no duplicates can exist.
If you want to import any reporting groups - the user groups cannot include the "CompanyGroupId", otherwise all reporting groups wiil be ignored.
Email1,FirstName,LastName,Password,GroupName1|GroupName2|...|GroupNameN,ReportingGroupName1|ReportingGroupName2|...|ReportingGroupNameN,SecurityClearanceId,NfcKey,CustomNfcKey,EmployeeNumber,FuelEconomyMeasurement,DistanceMeasurementSystem,FeaturePreview,TimeZone,AuthorityName,AuthorityAddress,CarrierNumber,HomeTerminal,HomeTerminalAddress,DriverLicenseNumber,LicenseState,Ruleset,YardMoveAllowed,PersonalConveyanceAllowed
Email2,FirstName,LastName,Password,GroupName1|GroupName2|...|GroupNameN,ReportingGroupName1|ReportingGroupName2|...|ReportingGroupNameN,SecurityClearanceId,NfcKey,,EmployeeNumber,,,,TimeZone,AuthorityName,AuthorityAddress,CarrierNumber,HomeTerminal,HomeTerminalAddress,DriverLicenseNumber,LicenseState,Ruleset,YardMoveAllowed,PersonalConveyanceAllowed
Email3,FirstName,LastName,Password,GroupName1|GroupName2|...|GroupNameN,ReportingGroupName1|ReportingGroupName2|...|ReportingGroupNameN,SecurityClearanceId,NfcKey,,,,,,,,,,,,,,Ruleset,,
This SDK example assists with importing users to your database using comma separated values (CSV).
Use the form to add new users with optional NFC or GO driver keys. You can also use the text box to paste in users from another source.
| Value | Example | Notes |
|---|---|---|
| john.smith@geotab.com | Can be email or user name. Spaces are not allowed. | |
| First name | John | Spaces are not allowed. |
| Last name | Smith | |
| Password | Minimum of 6 characters. | |
| Groups | Drivers|West|Garmin | Names of groups separated by the | character. |
| Reporting Groups | Drivers|West|Garmin | Names of reporting groups separated by the | character. |
| Security clearance ID | b28A7 | Found in the URL when viewing a security clearance in MyGeotab. Example: my.geotab.com/DATABASE/#clearance,id:b28A7 |
| NFC key number | T1234S | Optional. Found on the NFC key fob. |
| Custom NFC key number | 12345678 | Optional. Found on the Custom NFC key fob. |
| Country Code | CA | Optional. The user two symbols country ISO code (https://www.iso.org/iso-3166-country-codes.html) |
| Phone number | +1 5555555555 | Optional. The user's phone number with space separated country phone code. |
| Phone number extension | 1234 | Optional. The user's phone number extension. |
| Designation | "" | Optional. The user's designation |
| Employee number | 63-221-44 | Optional. The user's employee number. |
| Fuel economy measurement | LitersPer100Km | Optional. Choose how to display fuel economy. There are four different measurements: liters per 100 kilometers, kilometers per liter, miles per US gallon, or miles per imperial gallon. You may need to refresh your browser for the change to take effect. |
| Distance measurement system | Metric (true) | Optional. Choose how to display speeds and distances. This can be Metric or US/Imperial. You may need to refresh your browser to see the change take effect. |
| Feature preview | On or Off (true or false) | Optional. Toggle feature preview. |
| Time zone | America/New_York | The time zone offset from UTC for your location. All data will be displayed in this time zone. |
| Authority name | National Express | Optional. The motor carrier that the driver works for. |
| Authority address | 5000 Explorer Drive | Optional. The motor carrier's main office address. |
| Carrier number | 8Z88 | Optional. In the United States, this is the motor carrier's USDOT number. In Canada, this is the Canadian Carrier code. |
| Home terminal | Stark Tower | Optional. The motor carrier's place of business where the driver ordinarily reports for work. This can include a temporary work site designated by the motor carrier. |
| Home terminal address | 200 Park Avenue | Optional. The motor carrier's address where the driver ordinarily reports for work. |
| Driver license number | YEET | Optional. Driver's license number and License state/province must be set at the same time. |
| License state/province | Ontario (ON) | Optional. Selecting North America will show a dropdown menu; selecting Other will display a text box. |
| Ruleset | California Property Intrastate (HosRuleSetCaliforniaProperty) | Optional. This is the ruleset the user will follow when using hours of service. |
| Yard move allowed | On or Off (true or false) | Optional. Toggling this setting to ON allows the driver to apply the yard move exemption. |
| Personal conveyance allowed | On of Off (true or false) | Optional. Toggling this setting to ON allows the driver to apply the personal conveyance exemption. |