Help is always at hand

How do I convert existing Categories to Access Levels?

If you need to convert existing categories to access levels (to be able to set permissions on these categories) you need to run an update statement on the Asset Bank database. Please take a backup of the database before running any statements so that you can revert to it if necessary. If you wish to convert all current categories to access levels run the following statement:

UPDATE CM_Category SET CategoryTypeId=2, WorkflowName="default", IsRestrictive=1 WHERE CategoryTypeId=1;

You can also restrict this to only certain categories (for example recently added categories) by adding the category ID to the WHERE clause e.g.

UPDATE CM_Category SET CategoryTypeId=2, WorkflowName="default", IsRestrictive=1 WHERE CategoryTypeId=1 AND Id > 150;

After this has been done please perform a reindex of existing assets (from the Admin>Attributes menu). The permissions will not work correctly until the reindex has completed.

« Back

Contact Support

Before contacting us, please read contacting our support team.

Email us:
support@assetbank.co.uk

Or, call us on:
+44 (0)1273 923 150