XML Parser Issue

venkatvelpula · Post by **venkatvelpula** » Tue Jan 17, 2012 10:03 am

Hi,

I am trying to use new XML parser stage to parse the XML file and write that into a dataset. Part of the configuration, How do we input the document root?

eostic · Post by **eostic** » Tue Jan 17, 2012 12:17 pm

You first have to "import" your xml schema defintion (xsd) via the "Library Manager" (you'll see this tab inside the stage assembly, or at the DS Designer main canvas when you do Import....Table Definitions)....

Once you have the xsd properly imported, you will be able to select the docuement root. Open a sample document and look at the very first element...that is generally your root.

Ernie

venkatvelpula · Post by **venkatvelpula** » Tue Jan 17, 2012 1:13 pm

eostic wrote:You first have to "import" your xml schema defintion (xsd) via the "Library Manager" (you'll see this tab inside the stage assembly, or at the DS Designer main canvas when you do Import....Table Defin ...

I couldn't see full message..could you allow me to look at the full message?

eostic · Post by **eostic** » Tue Jan 17, 2012 1:26 pm

...the answer is in the content that you can see.

venkatvelpula · Post by **venkatvelpula** » Tue Jan 17, 2012 1:36 pm

I have imported XML table definitions but trying to provide document root to configure XML stage to parse the input file.

How import table definitions related to the document root?

satisht · Post by **satisht** » Tue Jan 17, 2012 2:25 pm

The document root should be the top level element that you are parsing. Lets say if there is a envelope, header and body in the message. If you want to parse the Envelope you should select Envelope in the root and in the next parse step if you want to parse the header then you shiould choose Header as the root and so on...The root can be selected by using the Browse option...

eostic · Post by **eostic** » Tue Jan 17, 2012 2:41 pm

...import the xsd to a Library (not via xml table definitions).

venkatvelpula · Post by **venkatvelpula** » Tue Jan 17, 2012 3:50 pm

can you tell me how to create the xsd to a library whican can be later accessed from xml stage?

eostic · Post by **eostic** » Tue Jan 17, 2012 7:12 pm

if you don't have one, you'll need to create one. One way is to look for "trang". ...or use the old xml Stages. If you don't have an excessive amount of volume, or you don't have an xsd or the detailed requirements (like deep validation) that would demand one, then use xmlInput.

That has its own learning curve, but it's probably simpler than trying to tackle xsd's for the first time while also learning a new Stage.

Ernie

venkatvelpula · Post by **venkatvelpula** » Wed Jan 18, 2012 10:33 am

Finally, I have created XSD and pointing that for document root. I am fine with this. When I am running the job, I am encountering no issues but not getting anything on the ouput.

Try to use test data funtion to see assembly editor configuration works. Could you provide how can we test the parser settings inside the stage? How to provide test data and see the results with in the stage?

eostic · Post by **eostic** » Wed Jan 18, 2012 12:17 pm

Change your validation setting...it's probably on minimal. That may help find the problem.

Ernie

venkatvelpula · Post by **venkatvelpula** » Thu Jan 19, 2012 9:52 am

I figured out the issue. Everything working fine. Thanks for your help.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 19, 2012 3:03 pm

Please share the resolution. That's what DSXchange is about. If someone else gets the same problem in the future, your solution will be there for the searching!