Hi
I'm facing problems when mentioning path in xml output.I have to generate o/p as :
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<gsa-template>
<import-items>
<add-item item-descriptor="ensemble-product" id="140150">
<set-property name="publishFlag"><![CDATA[true]]></set-property>
<set-property name="displayName"><![CDATA[Champion Red Sac Jacket ]]></set-property>
</add-item>
I'm getting i/p from a dataset ->transformer->pivot stage->xml output.
In transformefer stage i'm hardcoding the column for publish flag as
'name="PublishFlag"><![CDATA[':DSLink100.PublishFlag:']]>'
Pivot stage i'm converting single row into multiple rows.
In the path i have mentioned for
id as /gsa-template/import-items/add-item/@id
and for name as /gsa-template/import-items/add-item/set-property
But the o/p i'm getting is
<gsa-template>
- <import-items>
- <add-item item-descriptor="ensemble-product" id="9500100">
<set-property name="publishFlag><![CDATA[1]]>" />
</add-item>
- <add-item item-descriptor="ensemble-product" id="9500100">
<set-property name="DisplayName><![CDATA[Multizone Mattress Pad]]>" />
</add-item>
Is there any other way to mention the path.
Can anyone help me to resolve my problem
Thanks!
specifying path for xml output column
Moderators: chulett, rschirm, roy
specifying path for xml output column
sravanthi
You mean XPath not simply path... it was a little confusing at first. And your output while wrong is technically correct - 1 = true, 0 = false.
You need to correct your 'DSLink100.PublishFlag' derivation to translate it into words, it would seem.
Oh, and nice link name.
You need to correct your 'DSLink100.PublishFlag' derivation to translate it into words, it would seem.
Oh, and nice link name.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
hi chulett,chulett wrote:You mean XPath not simply path... it was a little confusing at first. And your output while wrong is technically correct - 1 = true, 0 = false.
You need to correct your 'DSLink100.PublishFlag' derivation to translate it into words, it would seem.
Oh, and nice link name. :wink:
I mean to say xpath.can you please cleary tell how can i modify my derivation.I didn't get exactly what you mean to say.
Thanks!
sravanthi
Ok... what the heck *is* your derivation for that field? How are you determining if it should be 'True' or 'False'? At its most basic, I'm suggesting something like:
As the proper derivation.
Code: Select all
If (something is true) Then 'True' Else 'False'
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers