The easiest way to make changes to large numbers of user accounts is through the process of CSV export and import. This process can be used to alter many fields including usernames, passwords, network folders and user groups.
For the import to work to modify existing users, the CSV file must contain the UniqueID of the user. It is recommended that modifications are done based on a CSV file exported from Frog.
If the UniqueID is not contained in the CSV file or is incorrect, new users will be created or users could be updated incorrectly.
From the Toolkit, click the admin tab then the users button. When the search dialogue window appears, please ensure that UID is ticked along with any of the other fields that you wish to change. You may wish to narrow down the results to a particular login profile or MIS year group in order to make the CSV file easier to work with.
Once you are happy with your selections, (making sure that UID is included), click OK.
When the search has finished you will be presented with a list of users matching your criteria. You should click on the Export List button.
Export List will take the results that are currently displayed and export them as a CSV, Export List will only appear immediately after the results of a search. If a user is selected from the search results, the Export List option will disappear. If this is the case a new search will have to be carried out in order to export the results.
The user import takes the first row from the CSV file as a description of what is in each column, so the first row should be a header row containing the name of what is within the column. As we have exported this CSV from Frog, the header row shows headers to match fields in Frog.
This CSV file can be edited in Excel. Please ensure that the UID column is not changed. Once the csv file has been updated with the changes required, it can be imported back into Frog.
From the User list, click Import Users. Follow the steps in the wizard taking care to upload and select the correct CSV file. When asked to map the fields in the database to the csv please make sure that UID is mapped against Unique ID. The only other fields that require mapping are those containing updated data.
The same process can be used for manually creating users if an MIS import is not being used. If you are unsure of any of the above steps or would like us to check the CSV file prior to importing, please let us know.