Hi,
I have a problem with disappearing profile pictures. When I want to insert new users, using the Import from File feature, there doesn’t seem to be an option to ignore the profile picture column. I insert the pictures manually for each user after I create their profiles, because I couldn’t find a way to quickly generate the links to the profile pictures. I had to search for the links to the pictures in FileZilla and then insert them into the spreadsheet in order to restore the pictures. If I had to do it each time it’s time consuming. I believe there must be a better way of creating a bulk of new profiles. Please could you help.
Hi @Dechen The User Photo is not a required field, so when you are uploading it, you can select * skip * to not upload that column. There is a separate Upload Photos & Files option in System Admin which can be used to bulk-upload a zip archive of user photos. Hope this helps!
Is it possible to skip the Password column when I want to use Update&Insert upload? I need to create a bulk of new profiles, but if I enter some passwords only, and leave some empty, it would wipe the other passwords off. Consequently the users who had changed their passwords would have to have their passwords reset, if that makes sense?
Hi @sandra please could you let me know what to do about the above? It doesn’t seem like *skip is available for passwords. only [custom] but I worry that if I use it it might erase all passwords..
Are you creating new users using the DataStructure-usersFull.xlsx or DataStructure-usersBasic.xlsx file?
Please note that the password field is required when importing new users with any file.
For this reason, if you need to both create new users and update existing ones, I recommend using two separate files — or two separate sheets within the same workbook. When updating users, the only required field is username.
Thank you @tiekubd I am using the usersBasic spreadsheet. If I have two separate sheets within one workbook, won’t they both be uploaded when uploading the file? I tried to upload a separate spreadsheet (usersFull) with just two users, but the system spit out an error. Previously I’ve uploaded usersBasic with 153 users on it. Not sure if system defines them by row numbers?
The importer allows you to upload a workbook with multiple worksheets. It will import only the first (leftmost) worksheet and ignore the others. This means you can rearrange the worksheets to choose which one gets imported.
What error did you receive when you tried importing ‘usersFull’? Would you like to share an anonymized version of your import file so I can take a look.
the system doesn’t seem to be recognizing the roles: Teacher, Administrator etc ? it also asks for the rows which have no data to be filled out. I have filled in just the first row..
Hi @Dechen When importing, there is a dropdown to select the Mode, which enables you to select just Import, or just Update. If you choose Update only, there is an option to Skip Required Fields, which will enable skipping nearly all the fields. When you use the default Insert & Update mode, there are more required fields, since it cannot create records without a minimum of data.
It seems Gibbon is not recognizing Administrator, Teacher, Student roles? I have just changed the long role names into their abbreviations but I got the same error.
The error occurs for both the filled and empty cells. But when I go to filter, there are no Blank cells to be deleted. I don’t get this problem with the file in which I have all existing users listed (the spreadsheet I used initially to create the users). I can still use it to update their information. Yes, Update option is useful once the users are already created, but the problem occurs when I try using the Insert option to create new users. If I use the insert option, then I need to include the password field. Since I don’t know what passwords other users have created, uploading the file will reset their passwords. So I tried to follow @tiekubd advice and use a separate file. But then this error occurs.
Ok, the problem is solved. I have created a new spreadsheet and copied the data there. Not sure why it made a difference but it worked Thank you for your responses
