Guys,

I modified InputTransformSS in Delimited Text Driver, to check the
Operation Code field in csv file. If the Operation Code = 'MOD', driver
will replace all attributes in IDV.

But the problem is if field in text is null, text driver will not
replace null value into IDV.
I have reviwed trace log and found that after applying XSLT policy the
blank attributes are not applied.

Can you suggest me the clue to solve this issue?




<<<<<...... My XSLT Style Sheet ......>>>>>

<xsl:variable name="operation-code" select="'Operation Code'"/>
...
<xsl:variable name="operation" select="field[@name=$operation-code]"/>
<xsl:if test="$operation='MOD'">

<modify class-name="{$object-class}" src-dn="{$srcdn}">

<!-- generate the association -->

<association>

<xsl:value-of select="$association"/>

</association>

<!-- handle each field -->

<xsl:for-each select="field[string()]">

<xsl:variable name="fieldValue" select="normalize-space(.)"/>

<!-- generate the add-attr -->

<xsl:choose>

<xsl:when test="@name!='Personal Number'and@name!='OPCODE'">

<modify-attr attr-name="{@name}">
<remove-all-values/>
</modify-attr>
<modify-attr attr-name="{@name}">
<add-value>
<value type="string">
<xsl:value-of select="$fieldValue"/>
</value>
</add-value>
</modify-attr>
</xsl:when>

<xsltherwise/>

</xsl:choose>

</xsl:for-each>

</modify>

</xsl:if>






<<<<<......The trace log. ......>>>>>

<delimited-text>
<record>
<field name="Operation Code">MOD</field>
<field name="Personal Number">XXM0001</field>
<field name="EMPLOYEE FIRST NAME">AAOL</field>
<field name="EMPLOYEE LAST NAME">Nilsop</field>
<field name="LOCATION CODE"></field>
<field name="LOCATION DESCRIPTION"></field>
<field name="CITIZEN ID">3124503284114</field>
</record>
</delimited-text>

[08/23/07 13:39:59.750]: HR_TO_IDM-TREE_23-AUG-07 PT: Applying input
transformation policies.

[08/23/07 13:39:59.765]: HR_TO_IDM-TREE_23-AUG-07 PT: Applying XSLT
policy.

[08/23/07 13:39:59.812]: HR_TO_IDM-TREE_23-AUG-07 PT: Policy returned:

[08/23/07 13:40:00.031]: HR_TO_IDM-TREE_23-AUG-07 PT:
<nds dtdversion="1.1" ndsversion="8.6" xml:space="default">
<input>
<modify class-name="User" src-dn="XXM0001 ">
<association>XXM0001</association>
<modify-attr attr-name="Operation Code">
<remove-all-values/>
</modify-attr>
<modify-attr attr-name="Operation Code">
<add-value>
<value type="string">MOD</value>
</add-value>
</modify-attr>
<modify-attr attr-name="EMPLOYEE FIRST NAME">
<remove-all-values/>
</modify-attr>
<modify-attr attr-name="EMPLOYEE FIRST NAME">
<add-value>
<value type="string">AAOak</value>
</add-value>
</modify-attr>
<modify-attr attr-name="EMPLOYEE LAST NAME">
<remove-all-values/>
</modify-attr>
<modify-attr attr-name="EMPLOYEE LAST NAME">
<add-value>
<value type="string">Nilsopon</value>
</add-value>
</modify-attr>
<modify-attr attr-name="CITIZEN ID">
<remove-all-values/>
</modify-attr>
<modify-attr attr-name="CITIZEN ID">
<add-value>
<value type="string">3124503284114</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds>


--
coolbull