on 04-30-2013 8:22 AM
Hi All,
I have a flat file which my scenario package is picking up and after the pickup I want to read the data to a B1Object through a XSL Transformation:
This is how my processing looks...
after the unbranch my xsl transformation looks like this
<BOM xmlns=""> | |||||||
<BO> | |||||||
<AdmInfo> | |||||||
<Object>2</Object> | |||||||
<Version>2</Version> | |||||||
</AdmInfo> | |||||||
<BusinessPartners> | |||||||
<row> | |||||||
<CardCode> | |||||||
<xsl:copy-of select="$msg/io/row[0]/col[1]/text()"/> | |||||||
</CardCode> | |||||||
<CardName> | |||||||
TESTBPNAME | |||||||
</CardName> | |||||||
</row> | |||||||
</BusinessPartners> | |||||||
</BO> | |||||||
</BOM> |
But it does not seem to pull the cardcode through except when I hard code it like the card name.
Please help ...
Kind Regards, Brenden
Hi All,
This is how my final atom xsl transformation looks before the B1Object.
But it is not working.
<BOM xmlns="">
<BO>
<AdmInfo>
<Object>2</Object>
<Version>2</Version>
</AdmInfo>
<BusinessPartners>
<row>
<CardCode>
<xsl:copy-of select="$msg/io/row[0]/col[0]/text()"></xsl:copy-of>
</CardCode>
<CardName>
TESTBPNAME
</CardName>
</row>
</BusinessPartners>
</BO>
</BOM>
Please help...
Regards, Brenden
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pedro,
This is the screen shots that will give you the main idea.
Processing:
GetFile XML:
xForm XML:
B1Object:
I and I use this code in the xForm atom to pull through the data from the GetFile:
<BOM xmlns=""> | |||||||
<BO> | |||||||
<AdmInfo> | |||||||
<Object>2</Object> | |||||||
<Version>2</Version> | |||||||
</AdmInfo> | |||||||
<BusinessPartners> | |||||||
<row> | |||||||
<CardCode> | |||||||
<xsl:value-of select="$msg/io/row[0]/col[0]/text()"/> | |||||||
</CardCode> | |||||||
</row> | |||||||
</BusinessPartners> | |||||||
</BO> | |||||||
</BOM> |
It pulls through a blank for a the CardCode.
If there is anything more you need please let me know.
Thanks,
Regards, Brenden
Hi Pedro,
The answer is marked as "Currently Being Moderated" and I cannot publish it. But I have been able to copy his post here.
The problem was that the information was not in $msg directly but inside Payload id="atom6".
Hi All,
I finally found a solution....
The code to use in your XSL Transformation is supposed to look like this
<xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom6']/bfa:io/bfa:row"> |
<xsl:value-of select="./bfa:col[1]"/>
</xsl:for-each> |
atom6 is my GetFile atom.
Regards, Brenden
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.