How to copy metadata from one field into another on a collection

[Iddeuh]

I have quite a lot of resources grouped into a collection. In each of these resources I would like to copy the content of one specific metadata field into another metadata field of the same resource. Same task in each file. Is there a way to do this in one step on the whole collection without having to edit each resource separately by hand? 

One idea would be:

- Download the whole collection with all the metadata written into the files

- Use the right Exiftool command to change the metadata inside these files

- Reupload the files to Resourcespace again to replace the old resources

However, somehow this workflow seems too whacky to me. Isn't there a more simple solution?

[Frederick Yocum]

@Iddeuh If I am reading your problem correctly, you want to be able to copy distinct information from one metadata field to another metadata field of the same resource using the mechanism of a collection.

Edit All in the Collections Options won’t work because you are not putting the same value into all of the resources.

The Advanced Metadata Field configuration of Sync with field won’t work because you want to only act on resources specific to a collection not resources of a specific type. 

You could do this with a plugin using PHP and MySQL, but I don’t think that particular action is available in ResourceSpace by default.

[Iddeuh]

You read my problem absolutely correct, Frederik.

What I am going to try now, is to log into phpmyadmin and to fiddle out a mysql command which does the copying process on all resources, where the neccessary metadata field is empty.