Hi all,
I am working on exchange rate import from SAP Business One Integration blog by Pierre Canali exchange rate is collected from a
url : http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml . I face a problem starts at for -each loop. I get a error " parameters doesn't match existing methods "
The processing flow

Now i added the atom 7 which consists of following xsl for-each loop that calls SBObob function to insert/update exchange rates
- <xsl:template xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01" xmlns="http://www.ecb.int/vocabulary/2002-08-01/eurofxref" name="transform">
- <xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom2']//*[./@rate]">
- <xsl:variable name="currency"><xsl:value-of select="./@currency" /></xsl:variable>
- <xsl:if test="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom8_2']/jdbc:ResultSet/jdbc:Row[jdbc:CurrCode = $currency]">
- <ExchangeRate xmlns="">
- <xsl:attribute name="date">
- <xsl:call-template name="b1ilib.strgReplace">
- <xsl:with-param name="subs" select="'.'"></xsl:with-param>
- <xsl:with-param name="var" select="'-'"></xsl:with-param>
- <xsl:with-param name="wstrg" select="../@time"></xsl:with-param>
- </xsl:call-template>
- </xsl:attribute>
- <xsl:attribute name="currency">
- <xsl:value-of select="./@currency"></xsl:value-of>
- </xsl:attribute>
- <xsl:attribute name="rate">
- <xsl:choose>
- <xsl:when test="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom8_1']/jdbc:ResultSet/jdbc:DirectRate = 'Y'">
- <xsl:value-of select="./@rate"></xsl:value-of>
- </xsl:when>
- <xsl:otherwise>
- <xsl:value-of select="1 div ./@rate"></xsl:value-of>
- </xsl:otherwise>
- </xsl:choose>
- </xsl:attribute>
- </ExchangeRate>
- </xsl:if>
- </xsl:for-each>
- </xsl:template>

Regards:
Navin