Drivers are one of the key objects to manage with the PayByPhone Business Account.
With the roles of Primary Fleet Manager, or Fleet Manager, you have the ability to create Driver Profiles in two ways:
- Singular creation using the driver add modal.
- Bulk Driver Profile creation using file upload.
Table of Contents:
Uploading Driver information into your PayByPhone Business Account.
Step 1 - Navigate to the Drivers menu.
Step 2 - Click on the Upload Button
Step 3 - Follow the steps on the upload dialog
Step 4 - Confirmation
FAQ - Driver Upload Error List by email
Details about common file upload errors.
E164 phone number error
The process requires a few steps to complete:
Step 1 - Navigate to the Driver menu.
Select Drivers from the menu to the left
Step 2 - Click on the Upload Button
Click the Upload button at the top of the screen.
This will open the upload dialogue box
Important Note - important
Step 3 - Follow the steps on the upload dialog
- Download the template.
- Add your driver details (check that the data format is correct).
- Driver names: Text string.
- Driver email: testaddress@email.com
- Country code
- Phone numbers: E.164 format.
- Save the template as a *.csv file.
- Click on “Upload” to upload the CSV file that you have saved.
Step 4 - Confirmation
Time will be required to validate and upload the Driver Profiles before they are shown in the Drivers section of the PayByPhone Business Portal.
If there are any errors with the data upload process, an email will be sent to the email address of the user who uploaded the file.
FAQ - Driver Upload Error List by email
If a row has an error in any field, that row will not be uploaded and no driver profile will be created for that row of data.
If the file that you have uploaded has errors. You will receive an error email message that describes the row with the errors and error type.
Once the errors are corrected, that row of data can be uploaded, or the Driver Profile can be created using the “Add Driver” Button
If a row of data includes the email address of an existing Driver Profile, the uploaded data will overwrite the data in the existing Driver Profile.
Details about common file upload errors.
E164 phone number error
E164 is an international standard for phone numbers. All phone numbers entered in the sheet need to be in the E164 standard for the data to be uploaded correctly into the system.
E.164 is the international telephone numbering plan that ensures each number in the PayByPhone Business system has a globally unique number.
This number allows phone calls and text messages can be correctly routed to individual phones in different countries by the PayByPhone for Business system.
E.164 numbers are formatted:
[+] [country code] [subscriber number including area code]
E.164 numbers can have a maximum of fifteen digits.
Examples of E.164 Numbers
E.164 Format |
Country Code |
Country |
Subscriber Number |
+14155552671 |
1 |
US |
4155552671 |
+442071838750 |
44 |
GB |
2071838750 |
+551155256325 |
55 |
BR |
1155256325 |
E.164 Country codes: (from https://en.wikipedia.org/wiki/List_of_country_calling_codes)
- +1 – Canada
- +1 – United States,
- +30 – Greece
- +31 – Netherlands
- +32 – Belgium
- +33 – France
- +34 – Spain
- +350 – Gibraltar
- +351 – Portugal
- +352 – Luxembourg
- +353 – Ireland
- +354 – Iceland
- +358 – Finland
- +376 – Andorra (formerly +33 628)
- +377 – Monaco (formerly +33 93)
- +39 – Italy
- +41 – Switzerland
- +420 – Czech Republic
- +421 – Slovakia
- +423 – Liechtenstein (formerly +41 75)
- +43 – Austria
- +44 – United Kingdom
- +45 – Denmark
- +46 – Sweden
- +47 – Norway
- +48 – Poland
- +49 – Germany
ISO Country Code:
ISO 3166 alpha-2 is the international standard used to define the 2-letter abbreviations for all of the countries of the world. This system ensures that the data is stored accurately and can be used by all systems in a consistent manner. The specific codes are listed below.
AT, Austria
BE, Belgium
BG, Bulgaria
HR, Croatia
CH, Switzerland
CY, Cyprus
CZ, Czech Republic
DK, Denmark
EE, Estonia
FI, Finland
FR, France
DE, Germany
GR, Greece
HU, Hungary
IE, Ireland, Republic of (EIRE)
IT, Italy
LV, Latvia
LT, Lithuania
LU, Luxembourg
MT, Malta
NL, Netherlands
PL, Poland
PT, Portugal
RO, Romania
SK, Slovakia
SI, Slovenia
ES, Spain
SE, Sweden
GB, United Kingdom (Great Britain)
US-United States of America
CA-Canada
FAQ
Details of an acceptable uploaded file name
- permitted filename characters: “a-z A-Z 0-9. _ -”
- A filename cannot include space characters
- Max Filename length: 250 CHAR
- File format: CSV (DOS, not MAC)
- File extension: CSV
The bulk upload solution supports the following use cases of data in columns:
First Name: Permitted characters: permitted filename characters: “a-z A-Z -” (update: any string)
Last Name: Permitted filename characters: “a-z A-Z -”(update: any string)
Country Code:
Match any valid ISO-3166 alpha-2 country code (upper case, lower case, or a combination)
or
Match any valid E.164 prefix (with ‘+' or without '+’)
or - If no country code provided the error to the user will be: “for each driver, a valid ISO-3155 alpha-2 country code or valid E.164 prefix is required in-country data field”
Phone number:
- Any non-numeric numbers will not be stored.
- the required country code in the country column will guide the system to check for the correct phone number format in the adjacent phone number column to be sure that it is valid for the country specified by the user.
Below are some details on the combination of phone numbers and country codes that should be acceptable to accommodate the data that the business manager has available to copy and paste into their upload sheet.
Phone Number country code (required) (ISO-3166 alpha-2 [US CA UK FR etc] or E164 country prefix [1 44 33 etc]) |
Phone Number (required) |
Will entry result in an error during upload? |
|
|
|
CA |
(603)222-5555 |
OK |
1 |
(603)222-5555 |
OK |
+1 |
(603)222-5555 |
OK |
+1 |
16032225555 |
OK |
1 |
16032225555 |
OK |
CA |
16032225555 |
OK |
NULL |
16032225555 |
ERROR |
NULL |
(603)222-5555 |
ERROR |
44 |
(07222) 555555 |
OK |
UK |
(07222) 555555 |
OK |
NULL |
+44 7222 555 555 |
ERROR |
+44 |
+44 7222 555 555 |
OK |
44 |
+44 7222 555 555 |
OK |
44 |
44 7222 555 555 |
OK |