Last updated on February 20, 2024
Before importing a CSV file into the Users tab of the Rublon Admin Console, you need to prepare the file according to the following requirements.
CSV File Column Names
The first line of the CSV file specifies the names of columns to import.
The CSV file must include the following column names:
- username
- status
The CSV file can (but does not have to) include one or more of the following column names:
- name
- phone
- alias[1-9]
All other columns with names that do not equal the preceding names will be ignored. The columns can be arranged in any order.
Refer to the following table to learn more about each column name and the acceptable values for each.
| username | Required. Corresponds to the Username column in the Users tab. Every username in the CSV file must be unique. |
| status | Required. Corresponds to the Status column in the Users tab. Must be one of the following: active, bypass, denied |
| Optional. Corresponds to the Email column in the Users tab. The email must be a valid email address in a proper format (e.g., example@rublon.com). Every email address in the CSV file must be unique. Otherwise, Rublon will only import the first user with that email address and fail to import every other user with that email address. | |
| name | Optional. Corresponds to the Full Name column in the Users tab. May contain numbers, spaces, and special characters except for the delimiter character. |
| phone | Optional. A phone number of the user. Cannot contain characters other than the plus (+) sign and numbers. Must begin with the plus (+) sign followed by the country code and the actual number, e.g., +18004444444. |
| alias[1-9] | Optional. Up to nine Username Aliases for each user denoted as alias1, alias2,…,alias9. May include spaces, numbers, and punctuation. |
CSV File Structure
- The size of the CSV file cannot exceed 1 MB. If your file is bigger than that, consider splitting it into smaller files and importing them one after another.
- Allowed delimiters are ‘;’ (semicolon) and ‘,’ (comma).
- Make sure to set your file’s encoding to UTF-8 without BOM.
- To do that in Notepad:
1. Open your CSV file in Notepad.
2. Select File → Save As…
3. In Encoding, select UTF-8 and click Save. - To do that in Notepad++:
1. Open your CSV file in Notepad++.
2. Select Encoding → Convert to UTF-8.
3. Save the file.
- To do that in Notepad:
CSV File Example
Refer to the following example of a simple CSV file prepared for the Users tab of the Rublon Admin Console.
username,email,name,status,phone,alias1,alias2 test,test@example.com,,active, test2,test2@example.com,,bypass, test3,test3@example.com,,denied,+917503907302 test4,test4@example.com,,active,testfour test5,test5@example.com,,active,testfour,test4four
Notice how we did not specify any values in the name column and only specified a phone number for one user. This is acceptable because the name and phone columns are optional.
