Last updated on May 24, 2024
When importing a CSV file in the Users tab of the Rublon Admin Console, you may encounter one or more issues. This article will help you fix these issues.
Some Users Failed to Import
If you receive a success import message, but some of the users failed to import:
- Ensure all usernames and email addresses in the CSV file are unique.
Fix Issues Detected by Rublon
When Rublon detects one or more fields in your CSV file contain invalid values, it will inform you about that. For example, if the file contains an invalid phone number for one of the users, Rublon will display a warning pointing to the exact line.
Line 4: The phone number format is invalid
Only the correctness of the username and status fields is mandatory. If the rest of the data is incorrect, Rublon will display a warning but the rest of the data will still be imported.
No Luck? Try This.
If you fixed all username and status-related errors that Rublon detected but still cannot import your users or the error you are getting is less specific, then:
- Make sure you have closely followed the instructions in How to prepare my CSV file for import.
- Ensure the file has the CSV extension.
- Make sure the delimiter in your CSV file is either a comma (,) or a semicolon (;).
- Ensure that your file’s encoding is UTF-8 without BOM.
- Make sure all column names are properly spelled (e.g., usrname will not work).
- Ensure the username field is not blank for any of the users.
- Make sure every status field contains one of these values: active, denied, bypass.
- Open your CSV file with a text editor and make sure there are no empty lines at the beginning or end of the file.
- Some spreadsheet software may remove the plus (+) sign from phone numbers due to cell type formatting. Ensure that the cell type in your spreadsheet application is set to “text”.
- Try fixing the warnings concerning non-mandatory fields.
If you tried all the preceding and you still cannot import your CSV file, contact Rublon Support. Do not forget to attach the file you are trying to import and a screenshot of the error/warning message you are getting.
Related Posts
How to import users from CSV – Rublon Admin Console
How to prepare a CSV file for import into the Rublon Admin Console
