UFAL/Import - Unexpected 'eperson to group' relationships being imported

[milanmajchrak]

# WORKFLOW_ROLE_editor groupa ma 7 lidi a to se mi nezda

dspace=# select * from epersongroup2eperson where eperson_group_id = '8b224ab3-38ba-4e75-aae1-cfdda6e13177';
           eperson_group_id           |              eperson_id
--------------------------------------+--------------------------------------
 8b224ab3-38ba-4e75-aae1-cfdda6e13177 | 2d28f76d-87c9-476e-b8de-55efc6722aa0
 8b224ab3-38ba-4e75-aae1-cfdda6e13177 | 17eed019-4e44-43ca-94df-f39dc353cf4c
 8b224ab3-38ba-4e75-aae1-cfdda6e13177 | d77c7c6b-6f79-49f8-95c0-0e8cc7e32928
 8b224ab3-38ba-4e75-aae1-cfdda6e13177 | 4b9a40ec-fa1d-4ab7-ae72-a29e292a4136
 8b224ab3-38ba-4e75-aae1-cfdda6e13177 | 8a767aa5-e7f0-4027-b754-dc9760cda132
 8b224ab3-38ba-4e75-aae1-cfdda6e13177 | ce88b298-b08f-4eb6-a189-e12bb199c4b0
 8b224ab3-38ba-4e75-aae1-cfdda6e13177 | a0f1bc60-58fc-4432-9611-6468f52e5d7b
(7 rows)


# tahle groupa mela puvodne id 19
dspace-import/src/__temp/resume$ jq '.data.id2uuid | to_entries[] | select(.value | contains(["8b224ab3-38ba-4e75-aae1-cfdda6e13177"])) | .key' epersongroup.json
"19"


# puvodne v tyhle groupe neni zadnej clovek
prod_lindat-dspace=# select * from epersongroup2eperson where eperson_group_id = 19;
 id | eperson_group_id | eperson_id
----+------------------+------------
(0 rows)

# je tam ale jina groupa
prod_lindat-dspace=# select * from group2group where parent_id = 19;
 id | parent_id | child_id
----+-----------+----------
 26 |        19 |       41
(1 row)

# v ty jsou 3 lidi

prod_lindat-dspace=# select * from epersongroup2eperson where eperson_group_id = 41;
 id  | eperson_group_id | eperson_id
-----+------------------+------------
 450 |               41 |         42
 451 |               41 |         48
 452 |               41 |        100
(3 rows)

# a dalsi groupa

prod_lindat-dspace=# select * from group2group where parent_id = 41;
 id | parent_id | child_id
----+-----------+----------
 22 |        41 |       18
(1 row)

# a v ty jsou 4 lidi
prod_lindat-dspace=# select * from epersongroup2eperson where eperson_group_id = 18;
 id  | eperson_group_id | eperson_id
-----+------------------+------------
 358 |               18 |         27
 359 |               18 |          4
 360 |               18 |          3
 361 |               18 |         31
(4 rows)

# jmena tech group

prod_lindat-dspace=# select resource_id, text_value from metadatavalue where resource_type_id = 6 and resource_id in (19, 41, 18);
 resource_id |          text_value
-------------+------------------------------
          19 | COLLECTION_2_WORKFLOW_STEP_2
          41 | COLLECTION LINDAT Editors
          18 | Guru Editors
(3 rows)

[Paurikova2]

In DSpace version 5, the tasklistitem table directly linked an EPerson (user) to a WorkspaceItem, managing access individually. However, starting from version 7, this direct mapping was removed. Instead, access to WorkspaceItems is now controlled exclusively through group memberships.

To preserve the original functionality, during migration or import, EPersons previously linked via tasklistitem are added to the appropriate access groups corresponding to those WorkspaceItems. This approach not only maintains the intended permissions but also eliminates duplicate entries that were an issue before.

The root cause was a misunderstanding of the tasklistitem table’s role in version 5. These direct relationships should not be re-imported as-is, since the access control now relies on group membership, which already reflects the correct permissions.