Blog Entry

The two scripts were added to the Driver Set Library and added to the JDBC Driver's configuration.

In an input transformation policy, the following rules were added. Only two example rules have been added here for the sake of brevity. Obviously if you use them you would need to adjust the class and attribute names.

	<rule>
		<description>Capitalise SURNAME correctly</description>
		<conditions>
			<and>
				<if-class-name mode="nocase" op="equal">IDM_EMPLIST</if-class-name>
				<if-op-attr name="SURNAME" op="available"/>
			</and>
		</conditions>
		<actions>
			<do-reformat-op-attr name="SURNAME">
				<arg-value>
					<token-xpath expression="es:nameCapitalise($current-value)"/>
				</arg-value>
			</do-reformat-op-attr>
		</actions>
	</rule>
	<rule>
		<description>Capitalise POS_TITLE correctly</description>
		<conditions>
			<and>
				<if-class-name mode="nocase" op="equal">IDM_EMPLIST</if-class-name>
				<if-op-attr name="POS_TITLE" op="available"/>
			</and>
		</conditions>
		<actions>
			<do-reformat-op-attr name="POS_TITLE">
				<arg-value>
					<token-xpath expression="es:toTitleCase($current-value)"/>
				</arg-value>
			</do-reformat-op-attr>
		</actions>
	</rule>

I hope that the scripts (being in the wiki) will be contributed to over time to make them more robust and to cater for more situations.