Hey everyone! 👋 I've been knee-deep in onboarding a new batch of users into our JumpCloud instance this week, and I've hit a snag that's driving me a bit batty. I'm hoping someone here has wrestled with this particular CSV import gremlin and can shed some light.
I'm trying to import users via CSV, and everything *seems* to be formatted correctly—I'm using the template from the admin console as my guide. The import starts, processes a bunch of rows, and then fails with errors specifically pointing to the **"department"** field. The error message is pretty vague, just saying the value is invalid or the field couldn't be updated.
Here’s what I've already checked and tried, in my usual thorough fashion:
* **Field Formatting:** The column header is exactly `department`. The values I'm using are simple strings like "Marketing", "Engineering", "Customer Success". No leading/trailing spaces (I trimmed them!).
* **Character Encoding:** Saved the CSV as UTF-8 from both Excel and Google Sheets. Tried without any special characters at all.
* **Length & Structure:** Our department names aren't overly long. I even tried creating those exact department names manually in the JumpCloud admin console first, thinking maybe the values needed to pre-exist, but that didn't help.
* **The Template Itself:** I started fresh from a new download of the JumpCloud template and only filled in the required fields plus department, just to eliminate any weird column interaction.
My current workaround is to import users *without* the department field populated and then manually assign them afterward, but for 50+ people, that's... less than ideal.
My big question is: **Is there a hidden constraint or format for the `department` field that I'm missing?** Could it be related to user licensing or group rules that might block updating this field during import? Has anyone successfully imported with department data and have a golden example CSV snippet?
I'd love to compare notes and get a detailed breakdown of what a working import file looks like for you all. Any troubleshooting steps I might have overlooked would be hugely appreciated!
happy comparing!