Overview of Visual Indicator Column configuration

Overview of Visual Indicator Column configuration

Image of SharePoint list with one visual progress bar indicators and color status indicatorsBamboo Visual Indicator Column gives you the ability to visually display incremental progress or status in a SharePoint list.

When using Visual Indicator, keep in mind:

  • A Visual Indicator Column will be displayed in the SharePoint list view and on the display form. When creating new items, or editing existing items, the column will be hidden.

  • Visual Indicator Column is not supported in Datasheet view, on InfoPath forms, or on the Document Information Panel in desktop MS Office products.

  • Visual Indicator Column does not support Choice columns in Check box mode, or Lookup columns with multiple selections.

  • The referenced column does not have to appear in the view displaying the Visual Indicator Column.

VisualIndicator_Config.png
Function

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


2. Select the Bamboo Visual Indicator radio button. The screen will refresh.


3. From the Show List Column As selectors, choose the desired option.


4. When Percent Bar is selected, the List Column drop down is filtered to display Number columns in the list.

Keep in Mind:
If the selected number column does not represent content as a Percentage, the values must be entered in .xx to be read correctly.


5. When the Color Indicator is selected, the List Column drop down is filtered to display Choice or Lookup columns.

Keep in Mind:
Visual Indicator does not support Choice columns in Check box mode, or Lookup columns with multiple selections.


6.
Assign colors to the unique column values using the following options:

  • Auto Fill Colors

  • Drop down color selector

  • Manually-defined hex number

The color associated with a manually entered hex number will not display in the configuration tool pane, but will be displayed in the list. Image of User defined text in color display field

Localize Bamboo Applications or Custom Columns

Localize Bamboo Applications or Custom Columns

Overview of the localization process for Bamboo Products

Bamboo applications and custom columns are slightly different than web parts when it comes to localizing/translating. The user interface isn’t confined to a web part, but can exist as site definitions or other custom pages. For example, the configuration of a Bamboo custom column is within the SharePoint list settings area.
The text strings that require translation are located in different files than the strings that appear in a web part.

Changing the language or text for an application or custom column is a multi-step process:

Top

About the Language Files

Text displayed in a Bamboo application may be included in one or both of the following locations:

  • Provisioning Resources. These resources are located in the 12, 14, or 15 “Hive”, in the Resources folder. The number of the Hive depends on the version of SharePoint you are using (e.g., SP2007 has a 12 Hive, SP2010 has a 14 Hive, and SP2013 has a 15 Hive). 14Hiveresources.jpg

    The Bamboo.*.resx files include text used in site features, site definitions, list definitions, and other provisioning resource elements. Any changes you make in these files will apply to new product instances only.

  • Application/Runtime Resources. These are also located in the 12, 14, or 15 Hive, but in the CONFIGResources folder.The Bamboo.*.resx file in the CONFIG folder is different than the one included in the Resource folder.14HiveCONFIGResources.jpg This one includes text used in application pages, custom site menu actions, navigation elements, and other runtime resources. Any changes you make will apply to new and existing product instances only.

In each location, there may be multiple versions of Bamboo.*.resx files with identical content. The different files are provided for English (en-US), German (de-DE), French (fr-FR), and Spanish (es-ES). The content of all files is in English until you translate it to your language. If your site is configured to use a language that does not have a corresponding Bamboo product .resx file, copy an existing file and rename it to include the culture name for that language pack. For example, create a file for Italian by saving the default file as Bamboo.[Product].it-IT.resx. Make your changes to this new file. If your site is configured to use a specific language but you do not have a culture-specific file, the product will use the default Bamboo.[Product].resx file instead.

Icon-WarningIMPORTANT: If you customize one of the default resource files provided with the product, your changes will be overwritten when you upgrade.

To avoid losing customizations, copy the customized file to a different location (not the same folder) before upgrading. After the upgrade is finished, compare the new file with your customized file to incorporate any new entries. Then copy the merged file to the Resources folder. Culture-specific files created for languages that are not provided with the product will not be overwritten during an upgrade, but you still need to incorporate new resource entries.

Top

Editing text in resource files

Icon-WarningIMPORTANT: Before making any changes, back up your original file to a different folder.

To change text in a resource file, open it in a text editor and locate the text you want to change. Editable text is usually found between the <value></value> tags, as shown in the screen shot below. Do not modify the data tag. If you want to remove text completely, delete only the text; do not delete the <data> or <value> entries from the file, or the server will display an error message. In the example below, the editable text is highlighted in gray.

Common_resxEdit.jpg

When you are finished with your changes, save the file and copy it to the appropriate Resources *folder on *all Web front-end servers in your SharePoint farm. Follow the instructions below to make your changes take effect.

Top

Applying Language File Updates

To apply changes to Provisioning Resource Files:

If you modified the provisioning resources file, apply your changes by restarting Web services with the following command on all Web front-end servers.

iisreset

NOTE: changes to provisioning resources affect new instances of the Bamboo product only; existing instances of the product are not updated.

To apply changes to Application/Runtime Resource Files:

If you modified the application/runtime resources file, apply your changes by executing the following stsadm command on all Web front-end servers. This command copies the updated resource file to the App_GlobalResources folder of each Web application. Changes apply to existing product instances and any new instances you create.

stsadm -o CopyAppBinContent

NOTE: Changes apply to EXISTING product instances AND any new instances you create.

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.

Overview of the Validator Column configuration screen

Overview of the Validator Column configuration screen

Image of SharePoint list with one visual progress bar indicators and color status indicatorsThe Bamboo Validator Column lets you validate column data, and ensures that it matches predefined or custom formats, ranges, and structures.

The Validator Column checks data as it is entered, preventing invalid data from being added to a list.

Image of the Validator Column configuration screenThe above image has been edited to better represent the configuration options.
Function

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


2. Select the Bamboo Validator radio button. The screen will refresh.


3. Choose the type of data to be entered into the column from the Column Data Type drop down menu.
The available choices are:

  • Single Line of Text

  • Number

  • Currency

  • Date and Time

NOTE: Additional formatting options may appear in the configuration screen based on your selection.


4. Check Input Required if this is a required field.


5. Identify how the column contents will be validated by selecting the appropriate validator mode check box:

  • Pattern Comparison: allows the Bamboo Validator to compare the user-entered value with a pre-defined pattern or custom expression.

  • Range Comparison: allows the Bamboo Validator to compare a user-entered value to a specific range of Administrator-defined values.

    NOTE: This option will NOT be available if Single Line of Text is selected as the column data type.

  • Column and Value Comparison: lets Bamboo Validator compare the user-entered value with a pre-defined value, or a value found in another column in the current list.

    Icon-Tip Multiple Validator Modes can be selected when configuring a single column.


6.
To include custom tool tip text for the column, enter it in the Tool Tip Text field. Users will see this text when they mouse over the column in the New or Edit forms.

NOTE: This field will only be available in the configuration screen when a validator mode is selected.