Using Value Comparison as a Validator

Using Value Comparison as a Validator

Overview of Validator Column configuration screen

Value Comparison allows the Validator Column to compare a user-entered value with either a pre-defined value or a value contained in another column within the current list, via comparisons, such as greater than/less than for numeric values, and contains/begins with/ends with for text values.

Image of the Validator column configuration screen when the Column and Value Comparison check box is selected
The image has been edited to better represent the configuration options.

NOTE: The following steps require you to have accessed the New Column settings screen and selected Bamboo Validator as the column type.

Function
1.

Select 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

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

2. Check the Column and Value Comparison check box to expose the value comparison configuration options.
3.

Select the operator to be used in the value comparison:

  • contains
  • is equal to

  • is not equal to

  • begins with

  • ends with

  • is greater than

  • is greater than or equal to

  • is less than

  • is less than or equal to

NOTE:The options shown are associated with the Number column data types. The available choices will differ based on the currently assigned Column Data Type.

4.

Select either Enter value to set a specific comparison value, or Select column to use a comparison value from another column in the List.

  • If you choose Enter value, provide the value in the blank field on the right.

  • If you choose Select column, choose the column from the drop-down menu on the right.

5. Enter the required message that will be displayed when an entered value is determined to be invalid in the Validation message field.

Using Pattern Comparison as a Validator

Using Pattern Comparison as a Validator

Overview of Validator Column configuration screen

Pattern Comparison allows the Bamboo Validator Column to compare a value entered by a user with either a pre-defined pattern or a custom expression of your own. In addition, you can use and/or logic to require that an entered value matches multiple patterns, or one of several possibilities.

Image of the Validator column configuration screen when the Pattern Comparison check box is selected
The above image has been edited to better represent the configuration options.

NOTE: The following steps require you to have accessed the New Column settings screen and selected Bamboo Validator as the column type.

Function
1.

Select 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.

2. Check the Pattern Comparison check box to expose the pattern comparison configuration options.
3.

Select Pre-defined pattern to validate user entries against the following options:

  • Phone Number (German & US)

  • Postal/Zip Code (German & US)

  • US Currency

  • Email Address

  • Internet URL

  • Password (6-20 characters, 1 letter and 1 number)

  • IP Address

  • Social Security Number

  • Number

NOTE: The options above are associated with the Single Line of Text column data types. The available choices will differ based on the currently assigned Column Data Type.

OR

To create a custom pattern, select Enter regular expression and define the desired expression in the field to the right.
A detailed explanation regarding how to create an expression can be found in this MSDN article.

NOTE: Regular expression is the only Pattern Comparison available if Date and Time is selected as your column type.

4. Select the Add Another button to add second pattern using the desired logic operator (And/Or).
5. Enter a required message in the Validation message field that will be displayed when an entered value is determined to be invalid.

Using Range Comparison as a Validator

Using Range Comparison as a Validator

Overview of Validator Column configuration screen

Range Comparison allows the Validator Column to compare a value entered by a user to a specific range of values, provided by the site administrator.
Image of the Validator column configuration screen when the Range Comparison check box is selected
The image has been edited to better represent the configuration options.
The following steps require you to have accessed the New Column settings screen and selected Bamboo Validator as the column type.

Function
1.

Select 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.

2.

Check the Range Comparison check box to expose the pattern comparison configuration options.

NOTE:This option will be grayed out if Single Line of Text was selected as the Column Data Type.

3. Enter the Minimum and Maximum values into the corresponding fields.
4. Enter the required message that will be displayed when an entered value is determined to be invalid in the Validation message 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.