Global find and replace for metadata values

Squiz Matrix Support
1

Can anybody advise whether or not there's some way to perform a global find-and-replace on specific metadata values?


I've just tried the Global Search and Replace tool on a bunch of Data Records, but the tool was unable to even find the particular metadata values I was hoping for, let alone replace them.



So any alternative solution would be greatly appreciated.



Otherwise I have about 70 Data Records to go through and manually update one particular metadata field on - a task, oddly enough, that I'd like to avoid if at all possible…



(We're using Matrix 3.22.)



Thanks.

Steve

2

How are the data record assets being presented? Via paintlayout or asset listing? You can use keyword modifier "^replace" for an interim solution.

3

[quote]
How are the data record assets being presented? Via paintlayout or asset listing? You can use keyword modifier "^replace" for an interim solution.

[/quote]



Hi Robin,



Thanks for the quick response!



Each Data Record is nested into a corresponding page for the Library Service, with a Paint Layout applied to it.



Unfortunately I fear your suggested interim solution won't work for us because keyword modifiers aren't available for use in our version of Matrix, 3.22 - I'm pretty sure they didn't become available until a later version.



It's yet another good incentive to upgrade, but for now I guess I'll keep looking for another solution.



Thanks anyway.



Cheers,

Steve

4

Since you are using paintlayout, it's doable. Check this out. http://manuals.matrix.squizsuite.net/paint-layouts/chapters/conditional-keywords-screen/

5

[quote]
Since you are using paintlayout, it's doable. Check this out. http://manuals.matrix.squizsuite.net/paint-layouts/chapters/conditional-keywords-screen/

[/quote]



Ah, but of course! The old Conditional Keyword in the Paint Layout trick - I really should have thought of that one myself.



Many thanks for this, Robin. That should do the job, until such time as I can find someone (probably myself, sadly) to update the metadata in the Data Records.



Cheers,

Steve

6

Glad it helps :lol:

7

I should imagine setting up a trigger for replacing the data would work. Investigated this for ourselves once, but since we only wanted partial content of the metadata field changed, we couldn't use it.


But you can set a trigger to find assets with a specific metadata value and update the metadata value to something else specific, and then fire it off.

8

[quote]
I should imagine setting up a trigger for replacing the data would work. Investigated this for ourselves once, but since we only wanted partial content of the metadata field changed, we couldn't use it.



But you can set a trigger to find assets with a specific metadata value and update the metadata value to something else specific, and then fire it off.

[/quote]



I like it! This sounds like a great long term solution that should work splendidly, once I figure out what Trigger to use.



Thanks very much, SDC_Support. I'll go and have a play and report back on how I went.



Cheers,

Steve

9

'Welcome.


I think the difficulty is in figuring out how to set the trigger to go off when you want it to. Looking at a trigger settings screen right now, I can't quite work that out.



Deb