Prcessing XML files
Moderators: chulett, rschirm, roy
Prcessing XML files
Hi
I am very new to " XML stages " in data stage.I have a requirement to convert an XML data file to a text file .i have to create the job in server and parrelel jobs
In server job:I have done the design as follows
folder stage----->XML input-------->Flatfile
But while running it is giving an error that Derivations are missing in XML input..Plaese Help
How i can impliment the same in PX
Thanks in advance..
I am very new to " XML stages " in data stage.I have a requirement to convert an XML data file to a text file .i have to create the job in server and parrelel jobs
In server job:I have done the design as follows
folder stage----->XML input-------->Flatfile
But while running it is giving an error that Derivations are missing in XML input..Plaese Help
How i can impliment the same in PX
Thanks in advance..
Thanks..Could you explain the things in detail:How the whole processvinbhate wrote:Hi
please check the output tab in XML input stage..there metadata of file is missing with grammer .Incase any more help need just let me know
My EMP.XML file will look like as follows.
<EMP>
<EMPNO>23</EMPNO>
<NAME>ABC</NAME>
<DEPTNO>123</DEPTNO>
</EMP>
I dont have any documents related to the xml stages..
Thanks..Could you explain the things in detail:How the whole processvinbhate wrote:Hi
please check the output tab in XML input stage..there metadata of file is missing with grammer .Incase any more help need just let me know
My EMP.XML file will look like as follows.
<EMP>
<EMPNO>23</EMPNO>
<NAME>ABC</NAME>
<DEPTNO>123</DEPTNO>
</EMP>
I dont have any documents related to the xml stages..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Exactly. Look for the 'XML PACK' pdf documentation in your Docs directory. Also go to Kim Duke's website and download the XML Best Practices document that is in his Tips section.
Sounds like what you are missing are the XPath Expressions that drive the XML parsing. Read the docs.
Sounds like what you are missing are the XPath Expressions that drive the XML parsing. Read the docs.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
The XML stages are fairly well documented, and the Best Practices is a DO NOT MISS document.
In addition, many of us also frequent the IBM DeveloperWorks site....I recently put an entry there that also might help you...check out the XBRL thread at http://www.ibm.com/developerworks/forum ... orumID=825
Ernie
In addition, many of us also frequent the IBM DeveloperWorks site....I recently put an entry there that also might help you...check out the XBRL thread at http://www.ibm.com/developerworks/forum ... orumID=825
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Hi Thanks for your help.I have gone through the link mentioned below and did exatlt wht they mentioned
but still I am facing some more issues realted to xml stages.
Following is my job design ,to convert XML Doc to SEQUNCILAL file,
Folder stage------XML input-----SEQfile stage.
Folder stage properties which i a have set as follows
Folder path name c:\xml\*.xml
and column defenisions as follows
FileName Varchar 255
Record Longvarchar 999999
XML input stage where i have set the properties as below
In out put tab transformation sttings i have enabled " repetation Required " and also loaded the name space declaration
Then i tried to run the job it is giving the following error
waring:unable to open the folder c:\xml_data\*.xml
fatel xml_input_1:/new_xml_job.folder.DSLiknk3.DSD.UVOpen Unable to open the folder c:\xml_data\*.xml.l
Please help me out
but still I am facing some more issues realted to xml stages.
Following is my job design ,to convert XML Doc to SEQUNCILAL file,
Folder stage------XML input-----SEQfile stage.
Folder stage properties which i a have set as follows
Folder path name c:\xml\*.xml
and column defenisions as follows
FileName Varchar 255
Record Longvarchar 999999
XML input stage where i have set the properties as below
In out put tab transformation sttings i have enabled " repetation Required " and also loaded the name space declaration
Then i tried to run the job it is giving the following error
waring:unable to open the folder c:\xml_data\*.xml
fatel xml_input_1:/new_xml_job.folder.DSLiknk3.DSD.UVOpen Unable to open the folder c:\xml_data\*.xml.l
Please help me out
Thanks.I didnt get your comment exatly.chulett wrote:Ok, it can't find your files because you've entered the values wrong. The Folder pathname should just be "C:\xml" and then your Wildcard pattern should be "*.xml".
Give that a shot. ...
Actually all my XML files are keeping at the loction C:\xml_data\
So that i given C:\xml_data\*.xml [Folder path ]\[wild card to fetch the xml file]Any thing wrong with this path.Please help me out.