Formats for Checking Values

You can customize predefined default column formats and create your own additional formats. The default configuration is moved to a configuration buffer during handling. You can retrieve changes from the configuration buffer and restore the default configuration in this way.

You can also use predefined formatting scripts along side formatting types to check values in a column.

Detailed information about this topic

• Formatting Types
• Formatting Scripts

Related Topics

• Templates
• Permitted Column Values
• Column Dependencies for Setting Values

Formatting Types

You can specify column formats based on predefined formatting types. By combining formatting types with each other, you can obtain the formatting you required.

To specify formatting types

1. Select the category One Identity Manager Schema in the Designer.
2. Select the table and start the Schema Editor with the task Show table definition.
3. Select the column and specify the formatting types in Column format on the Value calculation tab.

   Table 103: Permitted Formatting Types

   Value	Format Type	Permitted values
   0	None	No special formatting = default
   1	IP address	IP address [0-9]³.[0-9]³. [0-9]³.[0-9]³
   2	MAC-ID	MACID [0-9,A-F]12
   4	Drive letter	Drive letter [A-Z]1:
   8	Digit	[0-9]+
   16	Capital letters	Capital letters
   32	Server dependent capital letters	(Only included for compatibility)
   64	NT name	All characters permitted except "!@/\:,“[];|=+*?<>"
   128	Telephone number	Telephone number [0123456789#/-+*]n
   256	Exchange name	All characters permitted except "ÄÖÜäöüß“!§$%&\|/<>#*{}[] ²³~^,"
   512	ASCII letters and numbers	All characters of the character set 7-bit
   2048	URI	Uniform resource identifier
   4096	Email address	Valid email address

Related Topics

• Formatting Scripts
• Compiling a One Identity Manager Database
• Table Properties

Formatting Scripts

Formatting Scripts

You can use a formatting script to verify column values. Formatting scripts, as opposed to value templates, are only executed when a value is assigned to the column.

To create a formatting script

1. Select the category One Identity Manager Schema in the Designer.
2. Select the table and start the Schema Editor with the task Show table definition.
3. Select the column and enter the formatting script for the column in Formatting script on the Value calculation tab.

   Write the script in VB.Net syntax which allows all VB.Net script functions to be used.

Example formatting script

The value in the column Mail in the ADSAccount table should correspond to SMPT format. If this is not the case, an error message is sent. The formatting script for the column ADSAccount.Mail can be formulated as follows:

Dim str as String = Convert.ToString(Value)

If str.Length > 0 Then

End If

Related Topics

• Formatting Types
• Using Scripts
• Compiling a One Identity Manager Database

Permitted Column Values

You can define a list of permitted values in order to limit a column to specific values. Once the column display name has been created, the list of permitted values is no longer valid. Permitted values are supplied for certain data model columns through schema installation.

To specify a list of permitted values

1. Select the category One Identity Manager Schema in the Designer.
2. Select the table and start the Schema Editor with the task Show table definition.
3. Select the column and set the option Defined list of values on the Column tab.
4. Enter the List of permitted values.
   1. Open the dialog box with the [...] button next to the list.

      Table 104: Used Icons

      Icon	Meaning
      	Insert value.
      	Delete value.
      	Change value.
      	Change sort order.

   2. Enter a value and display text.
   3. Specify the display order.
   4. (Optional) Specify a translation.
   5. Save the changes.

Example

Only the values "internal" and "external" should be valid in the input field "Spare field no. 1". The list of permitted values is defined as followed:

1=internal 2=external

The string "intern" is therefore displayed on forms in the program "Manager" for an employee with the value "1".

Displaying Columns with Permitted Values in the Manager

There is a special control element used in the program "Manager" for displaying columns is defined a list of permitted values. The control element is displayed as a simple input field if no list is defined. If a list is defined the control element is shown as a menu.

Figure 20: Input Field for List of Defined Values (with and without defined entries)

The control element is only available for columns on default predefined forms as well as custom columns (usually CustomProperty01-CustomProperty10).

Related Topics

• Templates
• Formats for Checking Values
• Compiling a One Identity Manager Database