Local User account import file template
I'm trying to import a file to create around 600 usernames. To get the template, I just exported the users that I already have and filled in the columns on a spreadsheet, then saved it as a .csv and tried to import it. It gave me an error saying it is either the wrong file format or the contents are wrong. I tried it in a .xlsx as well, just to see if my CSV was wrong, but that didn't work either.
I noticed that when importing, it gives you a drop down for what portals you want the accounts tied to, while that is also a column on the spreadsheet. I'm assuming that means there's several columns on the export for data mining that can't be included on the import file, but I couldn't find any documentation as to what those fields are. The Omada SDN User Manual doesn't give any details as to the format required. It just points you to the paragraph above for required fields, but that includes the portal it's tied to so that doesn't make sense to me.
Does anyone have a template for local user account importing that they've successfully used in the past, or know where it's documented what fields and in what order are required?