XSLT::Field mapping through an additional XML

Sometime we need to introduce a way to create an association in the process. In doing so, introducing a map file provides a simple way to do such.
Here’s an example:

I add a mapper.xml that holds two mapping categories (grup id and user type).

<!-- // mapper.xml // -->
<?xml version="1.0" encoding="UTF-8"?>
<mapper>
    <group_id>
        <value id="1">2</value>
        <value id="2">3</value>
    </group_id>
    <user_type>
        <value type="Test User">Real User</value>
        <value type="Public">Private</value>
    </user_type>
</mapper>

Here’s an example file.

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:strip-space elements="*"/>

<!-- declare XSL variables -->
<xsl:variable name="groupId" select="document('mapper.xml')/mapper/group_id"/>
<xsl:variable name="userType" select="document('mapper.xml')/mapper/user_type"/>

<xsl:template match="field">
    <xsl:choose>
        <xsl:when test="@name='gid'">
            <xsl:call-template name="getGrpId">
                <xsl:with-param name="gid" select="."/>
            </xsl:call-template>
        </xsl:when>
        <xsl:when test="@name='usertype'">
	    <!-- if usertype tag get the value and get the mapping value -->
            <xsl:call-template name="getUserType">
                <xsl:with-param name="utype" select="."/>
            </xsl:call-template>
        </xsl:when>
        <xsl:otherwise>
            <xsl:copy-of select="."/>
        </xsl:otherwise>
    </xsl:choose>
</xsl:template>
<xsl:template name="getGrpId">
    <xsl:param name="gid"/>
    <field name="gid">
	<!-- You can simply refer the mapper by variable and compare to get the results -->
        <xsl:value-of select="$groupId/value[@id=$gid]"/>
    </field>
</xsl:template>

<xsl:template name="getUserType">
    <xsl:param name="utype"/>
    <field name="usertype">
        <xsl:value-of select="$userType/value[@type=$utype]"/>
    </field>
</xsl:template>

XSLT::Removing unwanted empty space

For example,

<entries>
    <Item>iGood</Item>
    <!-- unwanted empty space -->

    <Manufacturer>Apple</Manufacturer>
    <Date>01-Jul-2011 11:35:18 UTC</Date>
</entries>

Declare this. Note: Visualize removed space but not actually remove it.

<xsl:strip-space elements="*"/>

XSLT::Template example

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:template match="/">
    <users>
    <xsl:for-each select="users/user">
        <user><xsl:apply-templates /></user>
    </xsl:for-each>
    </users>
</xsl:template>

<xsl:template match="field">
    <xsl:choose>
        <xsl:when test="@name='name'">
            <xsl:call-template name="getname">
                <xsl:with-param name="fname" select="." />
                <xsl:with-param name="lname" select="following-sibling::field[position()=1]" />
            </xsl:call-template>
        </xsl:when>
        <xsl:otherwise>
            <xsl:copy-of select="." />
        </xsl:otherwise>
    </xsl:choose>
</xsl:template>

<xsl:template name="getname">
    <xsl:param name="fname" />
    <xsl:param name="lname" />
    <xsl:if test="string-length($lname) > 0">
        <field name="name">
            <xsl:value-of select="concat($fname, ' ', $lname)"/>
        </field>
    </xsl:if>
    <xsl:if test="string-length($lname) = 0">
        <field name="name">
            <xsl:value-of select="$fname"/>
        </field>
    </xsl:if>
</xsl:template>

</xsl:stylesheet>

PHP::XML character conversion

function unicodeEntities($str) {
	$char = array(
		'Š','’','–','š',
		'"','<','>','¡','¢','£','¤','¥','¦','§',
		'¨','©','ª','«','¬','­','®','¯','°','±',
		'²','³','´','µ','¶','·','¸','¹','º','»',
		'¼','½','¾','¿','À','Á','Â','Ã','Ä','Å',
		'Æ','Ç','È','É','Ê','Ë','Ì','Í','Î','Ï',
		'Ð','Ñ','Ò','Ó','Ô','Õ','Ö','×','Ø','Ù',
		'Ú','Û','Ü','Ý','Þ','ß','à','á','â','ã',
		'ä','å','æ','ç','è','é','ê','ë','ì','í',
		'î','ï','ð','ñ','ò','ó','ô','õ','ö','÷',
		'ø','ù','ú','û','ü','ý','þ','ÿ'); 
	$xmlcode = array(
		'&sharp138;','&sharp146;','&sharp150;','&sharp154;',
		'&sharp34;', '&sharp60;', '&sharp62;', '&sharp161;','&sharp162;','&sharp163;','&sharp164;','&sharp165;','&sharp166;','&sharp167;',
		'&sharp168;','&sharp169;','&sharp170;','&sharp171;','&sharp172;','&sharp173;','&sharp174;','&sharp175;','&sharp176;','&sharp177;',
		'&sharp178;','&sharp179;','&sharp180;','&sharp181;','&sharp182;','&sharp183;','&sharp184;','&sharp185;','&sharp186;','&sharp187;',
		'&sharp188;','&sharp189;','&sharp190;','&sharp191;','&sharp192;','&sharp193;','&sharp194;','&sharp195;','&sharp196;','&sharp197;',
		'&sharp198;','&sharp199;','&sharp200;','&sharp201;','&sharp202;','&sharp203;','&sharp204;','&sharp205;','&sharp206;','&sharp207;',
		'&sharp208;','&sharp209;','&sharp210;','&sharp211;','&sharp212;','&sharp213;','&sharp214;','&sharp215;','&sharp216;','&sharp217;',
		'&sharp218;','&sharp219;','&sharp220;','&sharp221;','&sharp222;','&sharp223;','&sharp224;','&sharp225;','&sharp226;','&sharp227;',
		'&sharp228;','&sharp229;','&sharp230;','&sharp231;','&sharp232;','&sharp233;','&sharp234;','&sharp235;','&sharp236;','&sharp237;',
		'&sharp238;','&sharp239;','&sharp240;','&sharp241;','&sharp242;','&sharp243;','&sharp244;','&sharp245;','&sharp246;','&sharp247;',
		'&sharp248;','&sharp249;','&sharp250;','&sharp251;','&sharp252;','&sharp253;','&sharp254;','&sharp255;');
	$str = str_replace($char, $xmlcode, $str);
	return $str; 
}

// run this first
function xmlEntities($str) {
	$char = array("&");
	$xslt = array('&sharp38;');
	$str = str_replace($char, $xslt, $str); 

	$htmlchar = array(
	'Š','’','–','š',
	'"','&','<','>',' ','¡','¢','£','¤','¥',
	'¦','§','¨','©','ª','«','¬','­','®','¯',
	'°','±','²','³','´','µ','¶','·','¸','¹',
	'º','»','¼','½','¾','¿','À','Á','Â','Ã',
	'Ä','Å','Æ','Ç','È','É','Ê','Ë','Ì','Í',
	'Î','Ï','Ð','Ñ','Ò','Ó','Ô','Õ','Ö','×',
	'Ø','Ù','Ú','Û','Ü','Ý','Þ','ß','à','á',
	'â','ã','ä','å','æ','ç','è','é','ê','ë',
	'ì','í','î','ï','ð','ñ','ò','ó','ô','õ',
	'ö','÷','ø','ù','ú','û','ü','ý','þ','ÿ');
	$xmlcode = array(
	'&sharp138;','&sharp146;','&sharp150;','&sharp154;',
	'&sharp34;', '&sharp38;', '&sharp60;', '&sharp62;', '&sharp160;','&sharp161;','&sharp162;','&sharp163;','&sharp164;','&sharp165;',
	'&sharp166;','&sharp167;','&sharp168;','&sharp169;','&sharp170;','&sharp171;','&sharp172;','&sharp173;','&sharp174;','&sharp175;',
	'&sharp176;','&sharp177;','&sharp178;','&sharp179;','&sharp180;','&sharp181;','&sharp182;','&sharp183;','&sharp184;','&sharp185;',
	'&sharp186;','&sharp187;','&sharp188;','&sharp189;','&sharp190;','&sharp191;','&sharp192;','&sharp193;','&sharp194;','&sharp195;',
	'&sharp196;','&sharp197;','&sharp198;','&sharp199;','&sharp200;','&sharp201;','&sharp202;','&sharp203;','&sharp204;','&sharp205;',
	'&sharp206;','&sharp207;','&sharp208;','&sharp209;','&sharp210;','&sharp211;','&sharp212;','&sharp213;','&sharp214;','&sharp215;',
	'&sharp216;','&sharp217;','&sharp218;','&sharp219;','&sharp220;','&sharp221;','&sharp222;','&sharp223;','&sharp224;','&sharp225;',
	'&sharp226;','&sharp227;','&sharp228;','&sharp229;','&sharp230;','&sharp231;','&sharp232;','&sharp233;','&sharp234;','&sharp235;',
	'&sharp236;','&sharp237;','&sharp238;','&sharp239;','&sharp240;','&sharp241;','&sharp242;','&sharp243;','&sharp244;','&sharp245;',
	'&sharp246;','&sharp247;','&sharp248;','&sharp249;','&sharp250;','&sharp251;','&sharp252;','&sharp253;','&sharp254;','&sharp255;');
	$str = str_replace($htmlchar, $xmlcode, $str); 
	// $str = str_ireplace($htmlchar, $xmlcode, $str); 
	return $str; 
}

To use, replace “sharp” to “#”.

You can add more characters as you need. Reference link: http://www.alanwood.net/demos/ansi.html