Address/ID/Recipient or business name not properly defined. | Make sure that your order address, ID, recipient or business name are specified correctly in your template. |
Some required columns are missing. | The CSV or XLSX template can not be uploaded with the missing required fields. Check the CSV and XLSX Format Guide for detailed information on which fields are required or optional. |
Need to use date/time format 'MM.DD.YY HH:mm' or 'MM.DD.YY HH:mm Z' | Make sure that the date and time format for your order are specified correctly. Check the CSV and XLSX Format Guide for detailed information. |
Provided value for (field) is too long. Limit is () characters. | Occurs when a certain field(s) exceeds the allowed length limit. Reduce the number of characters in the specified field to the allowed number and try again. |
The file contains at least one job with an ID that was imported previously. Please make sure all IDs are unique for all jobs and uploads and try again. | The IDs in your CSV file are unique and can be used only once in HERE Last Mile, so you should make sure that no ID in your .csv file matches the previously used IDs. |
The file contains the wrong format for "demand". Please make sure the value is a positive whole number and try again. | Check the Demand field - most probably the specified value is negative or not a whole number. |
Depot name needs to be the same for a single job ID. | Occurs if the depot name is different for the single job ID. Check that the specific job ID is not repeated for the different depots. |
Depot name does not match any of the known depots. Either correct or remove it. | Occurs if your file contains depot names that do not exist in your organization or the depot name was not specified correctly. |
Uploaded file has customer notes containing invalid characters. | Occurs if the uploaded file contains invalid characters in the customer notes. See CSV and XLSX Format Guide for details. |
Uploaded file has order notes containing invalid characters. | Occurs if the uploaded file contains invalid characters in the order notes. See CSV and XLSX Format Guide for details. |
Uploaded file has incorrect columns. These columns are required: ID, First name, Last name, Business name, c/o, Address line1, Address line2, Latitude, Longitude, City, Postal Code, Country code, Phone, Email, Customer notes, Order notes, Start Time, End Time, Service time [m / m:ss], Job type, Demand, Skills, Depot name. | Occurs if some of the required fields are missing. See CSV and XLSX Format Guide for details. |
Need to use service time format 'm' or 'm:ss', up to 99:59. | Occurs if the wrong time format is used. Check the time format specified in the fields like Start Time, End Time, Service Time. |
Use only permitted characters in the 'Last name' field, i.e., all characters except $ { } ; : " [ ] \ and =. Please correct and try again. | Occurs if the uploaded file contains invalid characters in the Last Name field. See CSV and XLSX Format Guide for details. |
Make sure the order record doesn't contain any Unicode characters in the range U+2000 – U+206F. | General Punctuation is a Unicode block containing punctuation, spacing, and formatting characters for use with all scripts and writing systems. Included are the defined-width spaces, joining formats, directional formats, smart quotes, archaic and novel punctuation such as the interrobang, and invisible mathematical operators. |
There are open double quotation marks (") in a string or strings. Change them to single quotation marks ('), or nest the whole string containing double quotation marks in single quotation marks (for example, change apple"pear to 'apple"pear'). | Occurs when some data in a comma-separated value database have double quote marks that are not paired. |
The file includes multiple timezones for an order. There can be only one timezone per order (pickup and delivery). | Occurs when an order has so different locations for pickup and delivery so the timezones are not equal and this order can not be processed. |
Time window start time is after the end time. | Occurs when the provided job time window start time is after the time window's end time. Check the Start Time and End Time fields and try again. |