XML OUTPUT
Moderators: chulett, rschirm, roy
XML OUTPUT
Hi Friends,
My source is a flat file and output is xml output stage.
targeted output is :
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1086734.10251.0.Z" sum="3574437120">
<store ncpdp="1086734"></store>
</file>
<file preReqFile="" id="1614608.10250.0.Z" sum="879672064">
<store ncpdp="1614608"></store>
</file>
</fileList>
</fileUpdate>
My output:
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1086734.10251.0.Z" sum="3574437120">
<store ncpdp="1086734"></store>
</file>
</fileList>
</fileUpdate>
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1614608.10250.0.Z" sum="879672064">
<store ncpdp="1614608"></store>
</file>
</fileList>
</fileUpdate>
Can any one help me how to acheive this.
Just to make it easy my targetted output is writing one header and one footer for whole lot of records.
But when I run my ds job my output is writing one header and one footer for each and every record.
Thanks
My source is a flat file and output is xml output stage.
targeted output is :
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1086734.10251.0.Z" sum="3574437120">
<store ncpdp="1086734"></store>
</file>
<file preReqFile="" id="1614608.10250.0.Z" sum="879672064">
<store ncpdp="1614608"></store>
</file>
</fileList>
</fileUpdate>
My output:
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1086734.10251.0.Z" sum="3574437120">
<store ncpdp="1086734"></store>
</file>
</fileList>
</fileUpdate>
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1614608.10250.0.Z" sum="879672064">
<store ncpdp="1614608"></store>
</file>
</fileList>
</fileUpdate>
Can any one help me how to acheive this.
Just to make it easy my targetted output is writing one header and one footer for whole lot of records.
But when I run my ds job my output is writing one header and one footer for each and every record.
Thanks
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: XML OUTPUT
Hi Friends,
Im getting this message on top of my xml file,
<?xml version="1.0" encoding="ISO-8859-1"?>
Can anyone help me/suggest how to remove this message from the file
regards
goutam
Im getting this message on top of my xml file,
<?xml version="1.0" encoding="ISO-8859-1"?>
Can anyone help me/suggest how to remove this message from the file
regards
goutam
-
- Participant
- Posts: 10
- Joined: Mon Feb 22, 2010 1:58 am
- Location: Chennai
Re: XML OUTPUT
In XML Output Stage Go to
1).Output tab
2).Click on Comment Tab
3).check in the Include Check box.
This will remove the header
-Vignesh
1).Output tab
2).Click on Comment Tab
3).check in the Include Check box.
This will remove the header
-Vignesh
Re: XML OUTPUT
Hi Vignesh,
I have tried this , This is xml output stage , i have checked comment in stage tab --->document settings tab but doesnt remove the header
can you please suggest if there is any other way.
Thanks
I have tried this , This is xml output stage , i have checked comment in stage tab --->document settings tab but doesnt remove the header
can you please suggest if there is any other way.
Thanks
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: XML OUTPUT
How many XML Output stages do you have.
You have unchek the Include comment in all the XML output stages.
You have unchek the Include comment in all the XML output stages.
Re: XML OUTPUT
Hi krishna,
I have only one output stage, I have unchecked and checked doesnt may any difference. Still showing the header
Any other options to do please help
Thanks
Goutam
I have only one output stage, I have unchecked and checked doesnt may any difference. Still showing the header
Any other options to do please help
Thanks
Goutam
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: XML OUTPUT
Can you post the xml here. I would like to have a look.
Re: XML OUTPUT
Hi Krishna,
<?xml version="1.0" encoding="ISO-8859-1"?>
<fileUpdate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1" program="XXXX" vendor="XXXXX" createDate="2010-12-10 01:50:11" serviceType="2">
<fileList>
<file sum="3574437120" preReqFile="" id="100000.00000.0.Z">
<store ncpdp="000000"/>
</file>
</fileList>
</fileUpdate>
The one in bold I want to remove that and I want to add the below as header.
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
Can you please suggest how can I achieve this.
<?xml version="1.0" encoding="ISO-8859-1"?>
<fileUpdate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1" program="XXXX" vendor="XXXXX" createDate="2010-12-10 01:50:11" serviceType="2">
<fileList>
<file sum="3574437120" preReqFile="" id="100000.00000.0.Z">
<store ncpdp="000000"/>
</file>
</fileList>
</fileUpdate>
The one in bold I want to remove that and I want to add the below as header.
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
Can you please suggest how can I achieve this.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,
This is no the input column this header is generated in xml oupt stage which is my target as
<?xml version="1.0" encoding="ISO-8859-1"?> where as I want it to be as
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
which I can add in the header tab if I can remove the default header
<?xml version="1.0" encoding="ISO-8859-1"?>
thanks
This is no the input column this header is generated in xml oupt stage which is my target as
<?xml version="1.0" encoding="ISO-8859-1"?> where as I want it to be as
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
which I can add in the header tab if I can remove the default header
<?xml version="1.0" encoding="ISO-8859-1"?>
thanks
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto