Update users’ ‘What’s New’ settings globally

Each ‘What’s New’ option has an associated code. Added together, these create binary values which are used to set users’ options in the DB.

The following binary values correspond to various combinations of the ‘What’s New’ settings.

• Documents only - 32
• Forums only - 64
• Publish Pages only - 2
• Books and Pages only - 12288

• Documents and Forums - 96
• Documents and Publish Pages - 34
• Forums and Publish Pages - 66
• All - 12386

Breakdown of actual codes:

• Documents - 32
• Publish Pages - 2
• Forum - 64
• Bookshelf - 4096
• Bookshelf Pages - 8192

There are 2 ways to update the settings for multiple users:

1. Using ‘bulk user update’ functionality via CSV

• Export users into a csv file using the Export functionality available in People Admin: /intranet/panels/peopleadmin_exportusers.php (you only need to select the following 2 fields: username, what’s new mask)

• Modify the CSV file as required, i.e. insert the correct binary value for users into the what’s new mask column. You can apply the same settings for all users, or different settings for specific users

• Do a bulk update of users using the ‘Add/Update from CSV file’ functionality in People Admin: /intranet/panels/peopleadmin_syncusers.php

2. Directly in the Claromentis Database (only use this method if you are an experienced DB administrator)

• Log in to the Claromentis DB

• Run the following script:

UPDATE users SET whats_new_mask = *value*;

NB: The query above would update all users with the same value