Asset Suite / PassPortGeek

It's important that text data being processed into PassPort be converted to upper case so that searches work (Portal/J toolbar binoculars). You'll probably end up attempting to convert everything to upper case and converting PassPort search SQLs to using the UPPER function so that case doesn't matter.



Example of converting incoming xml data to upper case in the xsl file.

<xsl:variable name="lcletters">abcdefghijklmnopqrstuvwxyz</xsl:variable>

<xsl:variable name="ucletters">ABCDEFGHIJKLMNOPQRSTUVWXYZ</xsl:variable>

<xsl:variable name="toconvert">
<xsl:value-of select="../../../VENDOR/NAME1"/>
</xsl:variable>
...
<VendorSupplyName>
<xsl:value-of select="translate($toconvert,$lcletters,$ucletters)"/>
</VendorSupplyName>