Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,368,870
Community Members
 
Community Events
168
Community Groups

User Import with attributes

Edited

I want to import approximately 350 users into crowd with CSV files.

The problem is, I also have a custom attribute associated with each user.

Originally, I had intended to just use the CSV import process, and then add the attribute using SQL.

HOWEVER, I have no idea how to generate the ID because it is NOT a SQL Sequence, it is a Hibernate value generated by com.atlassian.hibernate.extras.ResettableTableHiLoGenerator.

Any recommendations? seq_userimport perhaps?

1 answer

2 votes

Hi Robert,

I usually try to avoid messing with the database as much as possible as this could screw things up pretty bad. When I'm doing bulk stuff in Crowd, I often use the REST api in combination with Postman runners.

For adding an attribute you could use a POST call to /rest/usermanagement/1/user/attribute?username={username} and add the attribute info to the body of that request:

{ "attributes": [ { "name": "invalidPasswordAttempts", "values": [ "0" ] }, { "name": "requiresPasswordChange", "values": [ "false" ] } ] }

Using Postman Runner you can use a csv as input and easily add attributes for hunderds of users.

Hope this helps.

Best,

Maarten

Regrettably, the way our environment is configured prevents me from using the Crowd REST API. I do not control the configuration, InfoSec does.

Hey Robert,

Maarten's suggestion is definitely the approach I'd take, however if infosec have blocked REST API, then this isn't an option.

I doubt infosec would be very happy with direct DB changes if they don't even like you using the API. Maybe worth discussing with infosec if you can get a temporary exemption while you setup the accounts?

Otherwise, you might be able to automate the attribute population via a record/playback tool - something like Microsoft Power Automate Desktop or Selenium and automate the steps you'd be doing manually


CCM

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
4.0.2
TAGS

Atlassian Community Events