Page 1 of 1
Batch change owner for multiple files
Posted: 23 Jun 2016, 17:23
by briandirl
Hi, am I right in saying only the owner of files can search for them and delete then I'm the upload section?
If this is the case I need to change the ownership of 100s of files to a new owner so that this new owner can delete as required. Files are in multiple sub categories also.
Is there a batch process for changing ownership?
Joomla: 3.5.1
Download: 3.0.6
Thanks in advance
Re: Batch change owner for multiple files
Posted: 23 Jun 2016, 19:12
by Jan
Hi, the one who have delete rights can delete the file. Delete rights can be set for the category not for file, so only for category this needs to be changed.
Jan
Re: Batch change owner for multiple files
Posted: 24 Jun 2016, 10:27
by briandirl
Hi Jan, thanks for the reply.
I must be doing something wrong so. Firstly our uploaders have only got access to the front end. upload and delete rights have been set on the categories for each uploader, all registered users have access rights. It however seems that only the uploader/owner of the file can search for and delete the required files on the front end.
Thanks again for your help.
Re: Batch change owner for multiple files
Posted: 28 Jun 2016, 13:52
by briandirl
Can I just confirm that an uploader is unable to search for and delete a file on the frontend unless they are the owner of that file. As I said the uploaders have been give delete rights to the categories required.
Re: Batch change owner for multiple files
Posted: 29 Jun 2016, 00:39
by Jan
Hi, yes, only if the uploader uploaded the file, he/she can delete it. (if he/she does not have delete rights, he/she is even not able to do even he/she uploaded the file)
Jan
Re: Batch change owner for multiple files
Posted: 29 Jun 2016, 11:24
by briandirl
Thanks for the confirmation Jan.
Can I ask if an uploader is no longer with us, what is the best process to transfer the ownership of 100s of files to another uploader?
Thanks again for your help on this matter.
Re: Batch change owner for multiple files
Posted: 29 Jun 2016, 16:26
by Jan
Hi, then you need to set it for every file in file edit. Or fastest way is to create sql query to change the "owner" or "uploaded by" column for all files at once.
Jan
Re: Batch change owner for multiple files
Posted: 30 Jun 2016, 13:16
by briandirl
Thanks Jan, I'll see what I can do.
Re: Batch change owner for multiple files
Posted: 30 Jun 2016, 13:52
by briandirl
The following worked a treat:
UPDATE my_site_db.jos_phocadownload
SET owner_id=' '
WHERE catid=' ';
Re: Batch change owner for multiple files
Posted: 05 Jul 2016, 01:28
by Jan
Ok