Import users not recognising first column in case of excel to CSV converted file
Description
Attachments
Activity
Shawn Foster April 3, 2019 at 9:24 AM
Thanks, .
If this is an issue outside of Sakai that isn't being caused by Sakai and we won't be able to fix it from Sakai, then, yes, it can be considered a non-issue and closed respectively.
Ch Kumar April 3, 2019 at 12:06 AMEdited
Sorry, Looks like it's an issue with Excel to CSV(UTF-8) conversion. Excel appends BOM character to recognize an UTF-8 CSV file. Shall I close the issue?
Christopher Maurer March 29, 2019 at 7:27 PM
When I open your file, there appears to be some kind of special character at the beginning. See
.
Ch Kumar March 28, 2019 at 12:15 AM
Hi
I tried to upload the functionality by providing all required columns as per your suggestion.
user id,first name,last name,email,password,type
I can confirm that it's not issue with missing columns.
Please find the csv file and screenshot.
Shawn Foster March 25, 2019 at 1:19 PM
, the instructions on that page (which are also listed in your screenshot) say that all of the required headers need to exist in the file. Your file only contains "user id,first name,last name". You are missing "email,password,type" columns. Please try adding these column headers to your import file.
Importing users working absolutely fine with csv file provided in JIRA.
But it's not recognising first column from the csv file properly if we provide a csv file created using excel. For example if the first column is "user id", it's treating as user additional property rather than user id.
Tested on 11.4 and Trunk (master) on MySql
Attached sample csv file I created using excel.