Set all DSpace items that do not have an associated file (bitstream) as private

[Javi Rojo Díaz]

Good morning, 

I wanted to ask if there is any way to set all DSpace items that do not have an associated file as private.

 

I know it's a bit of a stretch and I can't find information about it, but I would appreciate any help. Otherwise, I understand that I will have to do it manually, and there are about 700 items... 

Thank you for your assistance. Best regards."

[Matthias Letsch]

Hello Javi,

Do you mean to make them only accessible to administrator? And do you already have a list of the uuids of your items you want to make private? (the long hash value which also appears in the url of an item).

If so, and if you are somewhat familiar with SQL and the DSpace database, I'd suggest you could make the changes directly via sql update in the resourcepolicy table in your database.

Disclaimer: Please take this approach with a grain of salt and test it on a single item first, preferably in your test environment / test database. I don't know if there is a solution via the user interface, so this is what I would do, but if someone knows a more simple and secure solution via the user interface, I would also prefer the latter!

update resourcepolicy

set rpname = 'administrator', rptype = 'TYPE_CUSTOM', epersongroup_id = 'uuid of your administrator group' 

where resource_type_id = 2 and action_id = 0 and dspace_object in (comma separated list of your uuids)

this changes the existing access policies of your items to your administrator group only (you have to know the uuid of your administrator group, too).

If you are not yet able to identify your items exactly by uuid, it will be a little more difficult, as you will then have to work across several tables (item2bundle, bundle2bitstream) to find out which items do not have bistreams. I can't go into this in detail at this point.

Kind regards,

Matthias

[Javi Rojo Díaz]

Hello, 

Thank you very much for the help. I've tried running a SELECT on your query for an item, first while it's public and then while it's private, but I see no change in values when switching between states. I believe the query may not be what I'm looking for.

After some investigation, I managed to set a test item as private from SQL using the following query:

update item set discoverable = true where uuid = 'c017ed8c-cbe7-4323-80cb-48a831453a39';

 However, the item still appears as public (although labeled as "private") when searched for without being logged in. If I change the item's status to private from the user interface, it works correctly; meaning, when I search for it without being logged in, 

I cannot find it since it's private. There must be another SQL table I need to modify for the behavior I'm seeking. 

Thank you very much.

[Javi Rojo Díaz]

Sorry, the query is incorrect. To set the item as private, I have executed: 

update item set discoverable = false where uuid = 'c017ed8c-cbe7-4323-80cb-48a831453a39';

and to set it as public:

update item set discoverable = true where uuid = 'c017ed8c-cbe7-4323-80cb-48a831453a39';

Thanks.