Configuring Spell Check

To create a Spell Check button

1. In the Object Explorer, double-click the Applet object type to expand it.
2. In the Applets window, select the name of the applet for which you are creating a Spell Check button.
3. In the Object Explorer, select the Control object type and add a new record.Create the new record with the following values:

   Field	Value
   Name	ButtonCheckSpelling
   Caption	Check Spelling
   Field	[field name]
   HTML Type	MiniButton
   HTML Only	True
   Method Invoked	ShowPopup

   NOTE: If the Method Invoked value does not appear in the pick list, type it in.

To set the Spell Check button User Properties

1. In the Object Explorer, double-click the Controls object type to expand it.
2. Select the Control User Properties object type.
3. Click Control User Properties.
4. In the Control User Properties window, create new records for the following user properties, with the corresponding values:

   Field	Value
   Mode	Edit
   Popup	Spell Checker Popup Applet
   Popup Dimensions	560 X 350 (recommended initial size)

To edit the Web Applet

1. In the Object Explorer, double-click the Applet object type to expand it.
2. In the Applets window, select the name of the applet for which you are creating a Spell Check button, and then right-click and choose Edit Web Layout.
3. In the Web Control toolbar, from the Mode drop-down list, select Edit.
4. In the Controls window, select the “Check Spelling” icon, and then drag it to a placeholder in the Web template.
5. In the Web template, right-click and choose Preview.You can see the Spell Check button as it will appear in the user interface.

To add the Spell Check business component to a business object

1. In the Object Explorer, click the Business Object type.
2. In the Business Objects window, select the business object to which you want to add the Spell Check business component.
3. In the Object Explorer, double-click Business Object to expand it, and then select Business Object Component.
4. In the Business Object Component (child) window, add a new record.Create the new record with the following values:

   Field	Value
   BusComp	Spell Checker Applet VBC

To create a Spell Check Menu Item

1. In the Object Explorer, click Applet, and then select the applet for which you want to create a Spell Check menu item.
2. Double-click the Applet object type to expand it, and then select Applet Method Menu Item.
3. In the Applet Method Menu Item window, add a new record.Create the new record with the following values:

   Field	Value
   Command	Check Spelling
   Menu Text	&Check Spelling
   Position	2

4. Select the Applet User Property object type.
5. In the Applet User Properties window, add a new record.Create the new record with the following values:

   Field	Value
   Name	Check Spelling
   Value	[Name of the field that will use Spell Check]

 

SSL Certificate Trust Errors for New Thawte Certificates

If you renew a Thawte SSL certificate or purchase a new one since 26th July 2010 you may encounter SSL certificate trust errors when clients connect to published websites such as Outlook Web Access.

Web browsers will return an error such as:

The security certificate issued by this website was not issued by a trusted certificate authority

On inspection of the certificate being issued by the website you may see this error:

The issuer of this certificate could not be found

This can be confusing for people who assume that any certificate issued by a commercial CA such as Thawte will be trusted by devices and web browsers that people are connecting from, especially when it occurs after renewing an existing Thawte SSL certificate.

Thawte has published the reason for this:

On June 27 2010, in the interest of better security, thawte signed all certificates with a primary and secondary intermediate that need to be installed along with the SSL certificate. Any certificate issued on or after this date requires the primary and secondary intermediate to be installed.

The new certificates are issued by an intermediate CA known as “Thawte SSL CA”.  This CA is not automatically trusted by most web browsers.  Thawte provides instructions for installing the correct certificates on the web server or ISA Server that is publishing the website.

Take note of the final steps, the change may not take effect until IIS or ISA Server are restarted.

If your site still have the chaining error, restart the IIS service. If the problem continues, the whole server needs a reboot to use the new roots.

 

Calculation Logic of RowIdToRowIdNum

RowIdToRowIdNum is a function used in calculated expressions. This function converts an alphanumeric ROW_ID to a unique, pure numeric ROW_ID.

The conversion is performed for digits and letters after or before the hyphen ‘-’. The formula used by RowIdToRowIdNum is the following:

[Last digit or letter * 36^0] + [Second to last digit or letter * 36^1] + [Third to last digit or letter * 36^2] + …+ [Second digit or letter * 36^n-1)] + [First digit or letter * 36^n]

By design, values of letter A is 10, B is 11, C is 12 … Y is 34, and Z is 35.

Example 1:

Take the example of ROW_ID = 1-5GYG0.

1. Start converting from the last digit or letter from right to left, which is 0 in this case:
0 * 36^0 = 0
2. Conversion of second to last digit or letter, which is ‘G’:
G * 36^1 = 16 * 36 = 576
3. Conversion of third to last digit or letter, which is ‘Y’:
Y * 36^2 = 34 * 36 * 36 = 44064
4. Conversion of second letter or digit, which is ‘G’:
G * 36^3 = 16 * 36 * 36 * 36 = 746496
5. Conversion of first digit or letter before the hyphen ‘-’, which is ’5′:
5*36^4 = 5 * 36 * 36 * 36 * 36 = 8398080
6. Adding all the converted values right of the ‘-’ gives 9189216:
0 + 576 + 44064 + 746496 + 8398080 = 9189216
7. The next character is a hyphen ‘-’. The letter or digit to the left of the hyphen,’1′, is converted by itself:
1 * 36^0 = 1 * 1 = 1

The final converted ROW_ID is 1-9189216.

Example 2:

ROW_ID G-5GYG0

This ROW_ID is the same as the ROW_ID in example 1 with the exception of the letter to the left of the hyphen, ‘G’. Using the same conversion, G-5GYG0 would be 16-9189216 where G, the letter to the left of the hyphen, gets converted to 16.

1. 0 * 36^0 = 0 * 1 = 0
2. G * 36^1 = 16 * 36 = 576
3. Y * 36^2 = 34 * 36 * 36 = 44064
4. G * 36^3 = 16 * 36 * 36 * 36 = 746496
5. 5 * 36^4 = 5 * 36 * 36 * 36 * 36 = 8398080
6. Adding all the converted values right of the hyphen = 9189216

The final converted ROW-ID is 16-9189216.

Example 3:

ROW_ID = 1-IB79I

Using the same conversion, 1-IB79I would be 1-30755718 where ’1′, the digit to the left of the hyphen, gets converted to 1.

 

1. I * 36^0 = 18 * 1 = 18
2. 9 * 36^1 = 9 * 36 = 324
3. 7 * 36^2 = 7 * 36 * 36 = 9072
4. B * 36^3 = 11 * 36 * 36 * 36 = 513216
5. I * 36^4 = 18 * 36 * 36 * 36 * 36 = 30233088
6. Adding all the converted values right of the hyphen = 3075571

 

The final converted ROW_ID is 1-30755718.