How to import a file #
Special characters for SMS #
SMS are typically sent out with the GSM7 Charset, which covers most characters.
The following characters equate to two characters in a text message:
\n \ ^ ~ [ ] { } | ~ €
When you create a message with a Unicode character (basically all other characters not seen in the table below) the maximum number of characters of a single SMS will change from 160 to 70.
This means we will still send your message but at extra costs. For example; a message containing a Unicode character that has a length of 150 characters will be charged as 2 text messages.
In our Portal, we show a warning below the message preview when your message contains a Unicode character.
In the table below, you will find the standard characters that equate to one character. All characters in the table are standard, but may not show on the receiver’s phone depending on the handset’s capabilities.
| @ | Δ | S | P | K | 0 | ¡ | P | ¿ |
| p | £ | _ | ! | Ä | 1 | A | Q | a |
| q | $ | Φ | “ | k | r | b | R | B |
| R | C | æ | = | M | Ñ | m | ñ | |
| 2 | ¥ | Γ | # | ä | 3 | C | S | c |
| s | è | Λ | ¤ | ø | 4 | D | T | d |
| t | é | Ω | % | Æ | 5 | E | u | U |
| e | ù | Π | & | , | 6 | F | V | f |
| v | ì | Ψ | ‘ | < | 7 | G | W | g |
| w | ò | Σ | ( | L | 8 | H | X | h |
| x | Ç | Θ | ) | Ö | 9 | I | Y | i |
| y | L | F | Ξ | l | : | J | Z | |
| j | z | Ø | E | ö | S | C | + | ; |
| Å | ß | . | > | N | Ü | n | ü | å |
| É | / | ? | O | § | o | à |
Import validation messages #
Importing a file at our portal is divided into three steps.
| 1. Upload | 2. Validate | 3. Import |
When uploading a file we first validate if this file has not been uploaded before, by looking at the filename. After uploading your file(s) we start the validation of the file content.
The validation depends on the script the record is imported for. For example, an SMS only script with PayLinks requires valid mobile numbers and invoice information. A voice script only requires a valid phone number and a family name.
The verification step can take some time, depending on the file size. The validation column shows the current status of a file. The page will auto-refresh until all files are done.
Click on the “View validation” button to view the validation messages.
Records Overview
Click or hold your cursor at the question mark next to the WARNING or ERROR, to view the detailed information.
Statuses
The final status of a row/record.
| Status | Meaning |
|---|---|
| Skipped | Skipped validation of this row. This happens when we recognize the row as a header with colmn names. |
| Rejected | Skipped validation of this row. This happens when we recognize the row as a header with column names. |
| Created | Record imported. |
Messages
In the table below we give you some explanation of common messages.
| Message | Meaning | Result |
|---|
| Message | Meaning | Result |
|---|---|---|
| DISCARDING | The value in the column did not match the required format. | The value will be set to an empty string. This might result in a second “Empty” error. |
| DISCARDING plugin: phonenumber reason: invalid | The used phone number is listed in the call blocklist. | The value will be set to an empty string. This might result in a second “Not enough phone numbers” error. |
| INVALID DATE | The date is not in the required date range. The pop-up on the question mark shows which field it is about. | The record will be rejected. |
| NOT ENOUGH MOBILE NUMBERS | The phone number fields could be empty or do not contain mobile numbers. | The record will be rejected. |
| EMPTY | The value of a required column is missing. | The record will be rejected. |
| BLOCKED PHONE NUMBER(S) | The used phone number is listed in the call block list. | The record will be rejected. |
After you confirm the import of the file(s) we start processing the records. In this process, we do an additional set of validations. View the file status and record details on the import page.