--- title: "Bulk User Account Administration" slug: "bulk-user-account-administration-1" updated: 2026-06-11T15:02:33Z published: 2026-06-11T15:02:33Z canonical: "help.idibilling.com/bulk-user-account-administration-1" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.idibilling.com/llms.txt > Use this file to discover all available pages before exploring further. # Bulk User Account Administration The User File Import process in Security allows administrators to make changes to user accounts in bulk including adding new users or updating existing ones. In situations where you need to add or make changes to a large amount of user records at the same time this can significantly reduce the time needed versus managing users directly through the User screens. ## Import File --- ### File Format The User File Import uses a comma delimited file format with the following layout: | **Position** | **Column Name** | **Required** | **Default** | **Character Limit** | | --- | --- | --- | --- | --- | | 1 | UserName | Yes | – | 32 | | 2 | Domain | New Only | – | – | | 3 | FirstName | New Only | – | 50 | | 4 | LastName | New Only | – | 50 | | 5 | Password | New Only | – | – | | 6 | Email | No | – | 100 | | 7 | Description | No | – | 255 | | 8 | ActivationDate | No | Today | – | | 9 | ExpirationDate | No | – | – | | 10 | IsAvailable | No | False | – | | 11 | IsDisabled | No | True | – | | 12 | CanChangePassword | No | True | – | | 13 | MustChangePasswordAtLogOn | No | True | – | | 14 | PasswordDoesNotExpire | No | False | – | ### File Format Notes: File can only contain up to 2000 records. Additional files will need to be created if more than 2000 records need to be processed. First row must be the header row. ### Sample File Sample files are demonstrated below. ## Importing a File --- The User File Import can be started for the Users screen in the Security application. Administrators will need the **Manage Users** permission to see the link. ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image(9).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) Browse to the file on your local system, select it and click the Continue button. ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-1(5).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) You will be shown a preview of the file contents. You can confirm the changes you are about to make here. ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-2(1).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) Click the Import button to begin the process. You will see the results for each record. ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-3(10).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) **Results:** **Added:** A new user record was created **Updated:** An existing user record had at least one property updated **Skipped:** A record matched an existing user but no property changes were found in the file > [!CAUTION] > **Error:** > > User record could not be created/updated. You can hover over the error indicator to see the specific issue. ## Updating Existing User Accounts --- The easiest way to update existing user accounts is to search for them in the User Search and then export the results to a CSV file. The CSV file created by the User Export can be used for the Import. ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-4(9).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) Edit the file using a CSV editor (e.g. notepad or Excel) and edit the accounts you need to update. Accounts in the file you do not want to change can be removed. If they are left with no changes the system will simply skip the rows. Export File: ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-5(9).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) Edited Import File: ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-6(9).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) > [!NOTE] > **Please Note:** > > Be sure to save your file as a CSV. Some spreadsheet applications will attempt to automatically convert a file to their native format. In this example, you would see 1 record that was updated and 3 that were skipped. The 3 skipped records would be because the system did not detect any differences between the records in the file and what is already configured on the accounts. ## Bulk Adding Roles and Environment Access --- The User File Import allows you to bulk add Role assignments and Environment access to user accounts as well. On the file preview screen, you have the ability to select Environments and Roles that you want to assign to the user records. ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-7(11).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) Roles can be assigned to accounts without any other changes in the user record. Changes in only role assignment for a record will yield an **Updated** result when the file is imported. ## Step by Step: Adding a New User Record --- ### Step 1: Download the sample file from this article A sample file can be downloaded [here](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/sample-user-import-file.csv?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D). ### Step 2: Open the file in Notepad or Excel ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-8(3).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) ### Step 3: Enter your user record information and save changes ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-9(4).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) ### Step 4: Select the file for import ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-10(3).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) ### Step 5: Select Roles to assign ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-11(2).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) ### Step 6: Preview Changes ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-12(3).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D) ### Step 7: Import file and review results ![](https://cdn.us.document360.io/3f7f8ade-bcb1-4ec8-af25-0c0ad8601afb/Images/Documentation/word-image-13(3).png?sv=2026-02-06&spr=https&st=2026-11-14T11%3A11%3A59Z&se=2026-11-14T12%3A11%3A59Z&sr=c&sp=r&sig=s3UKqlZ5KgiIcdzxM1mX7Qxjlfh1hT7B4cQme5b2gLM%3D)