Changing 400 + 'Users' to 'Backend Users'

Squiz Matrix Support
1

Simple question. I have a system of 400 and a bit 'User' assets (with metadata) and files under each, and I need to turn them into 'Backend Users'.


How would I do this without manually doing this?

2

Morph (on settings screen), but the asset needs to be under construction.

3

Whoa, there is a Morph option! WOW! Thanks Aleks…

4

Well, there used to be. I remember seeing it in 3.12… or was it 3.14? I can't see this option in 3.28

5

On 3.28.6 Morphing is on Setting screen, but only for some assets (like User).

6

It seems to kill metadata on the asset, so I'm going to have to find another way. Thanks, and noted for future use.


EDIT: It's also caused some cronjob deadlock which isn't pretty and gone straight to support.

7

Sounds like some SQL magic is in order

8

MAGIC

9

A quick script would be safer and easier than learning some magic! :blink:


Process would be something like:

Backup

For each user

  • Get current metadata and save[*]Acquire Locks[*]Change status if needed.[*]Remove metadata[*]Morph[*]Apply new metadata/schema[*]Release Locks
Done