Hi everyone,
I would like to bulk-add some user memberships in Crowd. It appears the easiest way to do that would be to just add records into the cwd_membership table with the appropriate columns. However, it looks like all the records in Crowd require a unique ID. How do I determine the next in that sequence? It doesn't appear that the ID field is auto-increment.
Thanks in advance,
Graham.
Community moderators have prevented the ability to post new answers.
I guess I'll go that route. Was hoping to be able to do it directly in the DB, as I'm migrating group memberships from a Crowd 1.6.x instance in a separate schema.
Thanks, Justin.
g.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, sorry about this Graham. All Atlassian apps use the same approach for their sequencing. The reason why we do this is because we want to be able to have a database neutral way of controling sequence numbers, and to also have a way of controlling sequences after you export the data from your Atlassian product to XML, and re-import it elsewhere.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Makes sense. Thanks.
g.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Graham,
I think the next id should be stored on this table
You might want to double check that. Hope it helps.
Cheers,
Septa Cahyadiputra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In my instance, the value of the next_hi column in hibernate_unique_key is only 49, whereas the highest ID I can find is 1474667, so I don't think that's doing it. :/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As describe here :
Crowd use ResettableTableHiLoGenerator to generate the next unique key.
Hope it helps.
Cheers,
Septa Cahyadiputra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So I'm assuming there is no way to properly add rows to the database manually. It has to be done inside the application.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.