Viewing data encrypted with Column Level Security

Viewing data encrypted with Column Level Security

When a list contains a Column Level Security column, the contents of that column will be encrypted for all users in both the SharePoint List and Datasheet View formats. Encryption appears as a series of asterisks within the field as shown in the images below.

ColumnLevelSecurity_Views.png

When an individual item is accessed within the secured list, the permissions specified when configuring Column Level Security will determine how users are able to interact with the contents of column.

Users given permission to Edit the column…
will be able to Read and Edit the contents of the secured column

Image of Secure Column in SharePoint View form.  User can read contents Image of Secure Column in SharePoint Edit form.  User can change contents

Users given permissions to Read the column…
will be able to Read the secured column, but will not be able to Edit its contents

Image of Secure Column in SharePoint View form.  User can read contents Image of Secure Column in SharePoint Edit form.  User can read contents. Field is greyed for editing

Users who were not given permissions to the column ..
will not be able to read or edit the contents of the secured column

Image of Secure Column in SharePoint View form.  Users sees dots instead of the fields contents Image of Secure Column in SharePoint Edit form.  Users sees dots instead of the fields contents

Use Column Level Security on existing data

Use Column Level Security on existing data

Overview of Column Level Security configuration screen

In addition to storing data, the
Column Level Security column can also import existing data from another column. This allows you to encrypt existing data without re-entering it into a new column.

Step Action Result
1. From the desired list, click Create Column. You will be taken to the Create Column configuration tool pane.
2. Name the column and select the Bamboo Column Level Security radio button. Image of the SharePoint Create Column screen
The page will refresh to display the Column Level Security configuration fields.
3.

Select the column Type that matches the data you want to map, keeping in mind that the only supported column types are:

  • Text
  • Number
  • Currency
Image of data type drop downThe screen will refresh to show additional fields if Number or Currency are selected.
4. Select the source column from the Copy old data from drop down. Only the columns that match the selected data type will be displayed.
Image of Copy of Data drop down
5. If you selected Number or Currency as the data Type, match Number of decimal places and Currency format to the original column.
Image of min and max value fields, and the  decimal place and currency drop down selectors
6.

Grant users access to the column contents:

  • Identify users who will be granted permission to Edit the column contents,

  • Identity users who will be able to Read the column contents.

NOTE: The column contents are only available in form displays.

Image of the Edit and Read people pickers
7. Click OK.

Image of original column next to the newly secured content.  Secured content is displayed as a series of dots in the SharePoint list view

The old data will be migrated to the new column.

NOTE: The original column may be deleted without losing the values in the new column.

Release Notes for Column Level Security

Release Notes for Column Level Security

NOTE: Release Notes will open in a new browser tab

WSSv3/MOSS SharePoint 2010 SharePoint 2013 SharePoint 2016
Release Notes Release Notes Release Notes Release Notes
Microsoft ended mainstream support for SharePoint 2007 in October 2012. See Microsoft’s Lifecycle Support Policy.
At that time, Bamboo stopped enhancements to our SharePoint 2007 product line, but continues to provide support and bug fixes to customers with active support contracts until October 2017. Previously purchased licenses will continue to function after October 2017, but support for these products will end, and no additional bug fixes will be provided beyond that time. Bamboo plans to cease selling new licenses and annual support contacts for its SharePoint 2007 products in October 2016 to ensure customers will be eligible to receive support for at least one year after purchase.
Microsoft plans to end mainstream support for SharePoint 2010 in October 2015. See Microsoft’s Lifecycle Support Policy. At that time, we will stop any enhancements for our SharePoint 2010 product line but will continue to provide support and bug fixes for our SharePoint 2010 products to customers with active support contracts until October 2020. Previously purchased licenses will continue to function after October 2020, but support for these products will end, and no additional bug fixes will be provided beyond that time. Bamboo plans to cease selling new licenses and annual support contacts for its SharePoint 2010 products in October 2019 to ensure customers will be eligible to receive support for at least one year after purchase.

Visit our website where you can get the latest info about each of our products for SharePoint 2013.

A separate installation package and license key is required for SharePoint 2013 deployment. For additional details, review the following knowledge base articles:

Bamboo Solutions has also begun releasing products for SharePoint 2016. For additional details, check the product release notes in the link above, or contact us.

For details on migration, see the Knowledge Base Article “Migrate Bamboo Products from SharePoint 2013 to SharePoint 2016”

Understanding Bamboo Releases:

  • Bamboo offers Trial, Basic and Premium support.
    • Free Trial support expires after 30 days.
    • For more information about Basic and Premium support, please see the Support Plans page.
    • There may be a fee to upgrade from a major version to another.

See Also:

Overview of the Custom Identifier Column configuration screen

Overview of the Custom Identifier Column configuration screen

Image of SharePoint list with a Auto generated custom identifier generated by the Custom Identifier columnThe Bamboo Custom Identifier is a custom column that allows you to automatically or manually generate a unique ID for a list item within a site or site collection.

When using Column Level Security keep in mind:

  • Custom Identifier Column does not work with Document or Picture Libraries.
  • In Data Sheet mode, values in the Bamboo Custom Identifier column are read only and cannot be updated in this mode.

  • Custom Identifier Column does not support New Document button functionality for Document Libraries, or Document Information Panel in Microsoft Office files.

Image of the Custom Identifier configuration toolpane
Function

1. From the List Settings menu click Create column, then enter the Column Name


2. Select the Bamboo Custom Identifier radio button. The screen will refresh.


3. Determine how the Custom Identifier will be generated:

  • Force User Entered ID to be Unique
    If requiring users to enter a unique ID, such as a drivers license or SSN, skip to #7 to complete the column configuration.

  • Auto-Generate Unique ID
    The Bamboo Custom Identifier column will generate the unique ID based on the Custom Identifier Format specified

    Icon-WarningImportant

    You cannot switch between Custom Identifier Models once you have stared capturing IDs. You must delete the column and create a new one to change the ID generation method.


4. Select the format Custom Identifier Format for automatically generated IDs:

  • Automatically incremented number – Using the drop down selector specify the minimum number of digits (1-5) to be generated.

  • Select the Allow deleted values to be reused check box to reuse deleted identifiers for new items.

  • Specify the Starting Number for the number generator (must be 1 or greater).

  • Text string – Enter text that you want included in each identifier.

  • Include the Current date and time in each identifier and select the Date & time format from the available options.

  • Include Columns from Current Item will insert the values associated with other columns in the current list, as part of the identifier for that item. Move the column names to the box on the right to include them in the identifier.
    The following column types are supported: Single text, Choice (drop-down and radio), Multi text (multi line, but not rich text), Number, Currency, Date time, and Lookup (not Multi-value Lookup).

  • Include the current List Name in each identifier.

  • Include the current Site Name in each identifier.


5.
Use the up and down arrows to the right of the Order of Selected Variables list box to specify the order in which each variable will be arranged in the Unique ID format.

Delimitation of Variables configures what is displayed between variables, and Identifier Case configures if and how variables will be capitalized.


6. Under Check Uniqueness In , select from one of the following options:

  • Current List – Checks the uniqueness of this column against other columns in the list with the same name.
  • Current Site – Checks the uniqueness of this column against other lists of the same type with the same column name within the current site. Must have a matching content type.
  • Current Site Collection – Checks the uniqueness of this column against other lists of the same type and name with the same column name within the site collection. Must have a matching content type.

Migrating Column Level Security from SharePoint 2007 to SharePoint 2010

Migrating Column Level Security from SharePoint 2007 to SharePoint 2010

Be sure you have at least the Minimum SharePoint 2007 Product Release (shown in the table below) installed before migrating. If not, upgrade your Bamboo product release before migrating. For more information, see Upgrading your Bamboo Web Part. Also, the target SharePoint 2010 farm requires at least the Minimum SharePoint 2010 product release shown.

Icon-Warning IMPORTANT: When migrating from SharePoint 2007 to SharePoint 2010, you MUST select the option to change existing SharePoint sites to use the new user experience. Your Bamboo products will not perform as expected with the old look and feel.

Minimum SharePoint 2007 Product Release 1.3.4 Minimum SharePoint 2010 Product Release 10.3.7
In-Place Upgrade
Issues Column Level Security migrates without any errors or additional steps required.

Resolution N/A
Database Attach Upgrade Method
Issues Column Level Security migrates without any errors or additional steps required.
Resolution N/A

Migrating Column Level Security from SharePoint 2010 to SharePoint 2013

Migrating Column Level Security from SharePoint 2010 to SharePoint 2013

Be sure you have at least the Minimum SharePoint 2010 Product Release (shown in the table below) installed before migrating. If not, upgrade your Bamboo product release before migrating. For more information, see Upgrading your Bamboo Web Part. Also, the target SharePoint 2013 farm requires at least the Minimum SharePoint 2013 product release shown.

Icon-WarningIMPORTANT: When migrating from SharePoint 2010 to SharePoint 2013, the Database Attach Upgrade Method is the only method supported.

Minimum SharePoint 2010 Product Release 10.3.34 Minimum SharePoint 2013 Product Release 10.3.48.2013
Database Attach Upgrade Method
Issues Column Level Security migrates without any errors or additional steps required.
Resolution N/A

How to find the version of a Bamboo Custom Column

How to find the version of a Bamboo Custom Column

NOTE: In order to find the version of a Bamboo custom column, you need to be able to access one of the Web Front End (WFE) servers in your SharePoint farm.

Icon-Tip Using SharePoint 2013? If so, check this video for specific instructions.

Step Action
1. On one of the Web front-end servers in the SharePoint Farm, browse to the %systemroot%assembly folder. This is typically in c:WindowsAssembly, but could be in a different location on your WFE server.
2.

Locate the product assembly for the product you are interested in. Right click the assembly name and choose Properties from the menu that appears. The
windows assembly.jpg
The Properties dialog will appear.

For each custom column, find the appropriate assembly name in the table below:

Product Name Assembly Name
Column Level Security Bamboo.FieldLevelSecurityColumn
Custom Identifier Bamboo.CustomIdentifierColumn
KPI Bamboo.KPIColumn
Lookup Selector Bamboo.LookupPlus
Rating Bamboo.RatingColumn
Rich Text Bamboo.RichText
Validator Bamboo.ColumnValidator
Visual Indicator Bamboo.VisualIndicator
3.

Select the Version tab to view detailed version information about the assembly. Within the listing is an attribute labeled File Version. This is the version of the current installed product.
assembly properties.png

NOTE: If you are running SharePoint 2010 or SharePoint 2013, the first digit representing the major version has an extra 0. See About Bamboo product Version Numbers for more information.