Need Help reagrding External source stage

DSDexter · Post by **DSDexter** » Wed Apr 02, 2008 5:11 am

Hi Gurus,

I am using XML input for the first time

. I searched the forum, All of them suggested to use a external source stage with ls command. But can anyone tell me what I need to specify in the Columns and format tab of external source stage?

BugFree · Post by **BugFree** » Wed Apr 02, 2008 6:04 am

Any reason for not using XML source stage? You can import the metadata for the XML file from the stage. What have you searched on? ls command will give a list of files in a folder. what are you trying to do?

DSDexter · Post by **DSDexter** » Wed Apr 02, 2008 6:11 am

BugFree wrote:Any reason for not using XML source stage? You can import the metadata for the XML file from the stage. What have you searched on? ls command will give a list of files in a folder. what are you trying to do?

External Source Stage ----->XML Input Stage------>Further processing.

This is what I am doing.

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed Apr 02, 2008 6:31 am

Hi i am Amey

In the Source Program you specify the name of the file along with the path name.
example:
find PathName -name "Xml File Name " -print

Set the format to default values.
In the columns you specify any name to the column since it conatins only the file name along with the path.

DSDexter · Post by **DSDexter** » Wed Apr 02, 2008 7:31 am

I have used the above command, At the output of external source stage I can see the filename along with the path being passed sucessfully, But at the XML Input stage count stays at 0. What could be wrong?

chulett · Post by **chulett** » Wed Apr 02, 2008 7:37 am

When XML goes into an XML Input stage but doesn't come back out, it usually means your XPath Expressions are incorrect.

DSDexter · Post by **DSDexter** » Thu Apr 03, 2008 2:07 am

I have created a Server job for the same, I have used source as a folder stage, I was able to extract the data from the xml file. Now I am using the same xpaths in the parallel jobs, But still the problem persists.

In folder stage I have two columns viz. Filename (Varchar 25) and record (LongVarchar 999999). And in XML input stage I am using the records column to fetch the xml data.

But in PX I am mentioning only Filename. So does the XML Input Stage extract the data from the filename/filepath it gets from the external source stage???

DSDexter · Post by **DSDexter** » Thu Apr 03, 2008 3:24 am

Hi All,

I have resolved the issue, I was specfying the XMLdocument, rather than a URl path.

Thanks all for the inputs