Uploading Driver information into your PayByPhone Business Account

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.

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
- +44 1481 – Guernsey
- +44 1534 – Jersey
- +44 1624 – Isle of Man
+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)

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

Articles in this section

Table of Contents: