topic tFileInputMSXML Question? in Talend Studio

tFileInputMSXML Question?

Anonymous — Sat, 16 Nov 2024 13:44:20 GMT

Hi there,
I have 3 questions relating to the use of the tInputMSXML component.

1. Does it parse a file only once or does it do a pass to retrieve each of the schemas defined in the component.
e.g. In the screenshot attached, would the file be parsed once or is it parsed 3 times.
2. Is it possible to validate our xpath query against an XSD file? At the moment, if there is an error typed in to the xpath query no error will be thrown when we run the job.
3. In general is it adviseable to use this on very large xml documents that potentially contain hundreds and hundreds of values to parse.
See screenshot attached: msxml-screenshot.JPG
For a working example of the job you can retrieve it from the following link: 9405

Thanks

Re: tFileInputMSXML Question?

Anonymous — Thu, 08 Oct 2009 16:00:55 GMT

Bump

Re: tFileInputMSXML Question?

Anonymous — Thu, 08 Oct 2009 16:20:04 GMT

Yes, there is a way is you create each Schema with the XML metadata wizard and if you pass the XSD as file input of this wizard.

Re: tFileInputMSXML Question?

Anonymous — Tue, 13 Oct 2009 14:16:08 GMT

If I can add to that:
A)Are there any examples of how to do this?

B) Also in relation to point 1 in my original post, does the xml file only get parsed once?

Thanks for the help

Re: tFileInputMSXML Question?

Anonymous — Wed, 14 Oct 2009 06:48:07 GMT

Hello guy

A)Are there any examples of how to do this?

Here is an example 7779.

B) Also in relation to point 1 in my original post, does the xml file only get parsed once?

The file will be parsed only one time.
Best regards

shong