Simple XML Read

[dsdoubt]

Hi,

Iam finding difficulties in reading a simple XML data.
Let the following be the data.

Code: Select all

<?xml version="1.0" encoding="ISO-8859-1"?>
<EMP>
<Record sino="1" name="Mark" sal="100.00" />
</EMP>

The metadata got imported properly.

Job design is as follows.

Sequential file stage with Varchar 255 to read the XML.
Pass it to XML Input stage. Column content as XML_document. Output tab loaded with the requried table definiton.
And output to a sequential file with .txt format.

Any further settings to be made?
It gives out the following warning and error.

Code: Select all

XML_Input_20,0: Error: Cannot find mandatory property "xml_source_column".
XML_Input_20,0: Error occurred in call to ORPHCallActivePluginInitialize().

I found in one of previous post that, XML is tricky to use first time. Is there any one time setting as such, like we do for ODBC or other database??

[dsdoubt]

Ok, the above error is when, I try to mark of the Field (Sino) as Key. Else I get the following error.

Code: Select all

XML_Input_20,0: Error: No repetition element specified for link "DSLink22". Please make sure a column that contains the repetition path is set as key in the output link table definition.
Cannot find mandatory property "xml_source_column".

[dsdoubt]

Any inputs GentleMen?

[chulett]

Dump the Sequential stage and use an External Source stage to capture just the filename, then point the XML Input stage to that URL/File path. Ernie Ostic has a nice little write-up for this on his blog site.

[pavans]

Any inputs GentleMen?

You can have a job design like:

External Source----XML Input------Sequential File/Data set.

Pass the XML File to the File Name field in External source.

Try this.

Good luck.

[ray.wurlod]

Any inputs GentleMen?

Be patient, particularly on weekends. Remember that the rest of the world begins their weekend before those in the Americas do.

If it's any consolation, they begin their work week earlier too.

[dsdoubt]

I used External Source stage.
I passed the file name to the SourceProgram in External Source stage.
I also tried to pass ls <subdirectory>*.xml | sort as mentioned by Erine's blog, still iam getting the following warning.

Code: Select all

XML_Input_20,0: Error: No repetition element specified for link "DSLink22". Please make sure a column that contains the repetition path is set as key in the output link table definition.
Cannot find mandatory property "xml_source_column".

[chulett]

You need to specify a repetition key - what happens when you do that?

[dsdoubt]

Hello Craig,
As Iam new to XML, pls bear with me. Is that the Key option in the XML Input stage you talking about? As you could see in the input file, there is no keys as such. Still If I mark first or all the fields as key in the Stage, I get following error.

Code: Select all

XML_Input_20,0: Error: Cannot find mandatory property "xml_source_column".
XML_Input_20,0: Error occurred in call to ORPHCallActivePluginInitialize().

And by the way, is just the 'cat' that you use in ExternalSource stage to reaad the files or script?

[chulett]

You mark one field as the 'repetion key', not all - and that generally the 'deepest' so try 'sal'. And no, while you can cat the contents of the file, the suggestion was to simply use the stage to get the filename. Check Ernie's blog post on the subject:

http://dsrealtime.wordpress.com/2007/12 ... -a-source/

[eostic]

You're almost there...the repetition element issue can be confusing, but as Craig says, it' the "deepest" element that you find useful in the particular node that you are retrieving on a given link. You have all attributes that contain real data, so make the element itself the repetition element....

Here's how you might set up your meta data on the output link:


Record key=yes /EMP/Record/
sino /EMP/Record/@sino
name /EMP/Record/@name
sal /EMP/Record/@sal

later in the job you can lose the "Record" column as it probably won't be useful any longer except to get the repeats correctly retrieved.

Ernie

[dsdoubt]

Hi Craig,
I was trying with ls as mentioned in my previous post. Since it was giving out error. I tried to cat it. Any way now I dont need to keep changing that from now.

Hi Erine,
I tried that too. Still it giving out the same error.
Cannot find mandatory property "xml_source_column".

Is there any settings in XML stage that I need to look for?

Erine, Iam just curios, if have any simple Jobs with XML stages that you might have created for your testing purpose, that you can share.[/i]

[dsdoubt]

So far I never selected the SML Source column drop down in the Input stage of XML. Atlast it worked now!!!
Thanks a lot guys!!!
When I try to cat the file from ExternalSource stage and use "XML Document" option instead of "URL/File Path", I expect it to work.
Its reading all the lines from the input but doest give any output from XML stage. No warnings neither.
Is there a way to capture reject from XML? So that to check what could be the actual issue.

[chulett]

All in but nothing out = bad / improper XPath Expressions.