how to create schema metadata for tFileInputMSXML ?

One Star

how to create schema metadata for tFileInputMSXML ?

Hi,
I have a schema file (.xsd) which contains a complicated multiple level schema and nested loops. In order to use it, I created a XML metadata with it. But when I process the input XML file. I have to use tFileInputXML and create multiple ones for multiple schema and loops. To avoid this multiple tFileInputXML, I am trying to use tFileInputMSXML. But this metadata can not be used as an input for tFileInputMSXML. Is there a way to solve this ?
In other words, how to apply the schema (.xsd) file to a tFileInputMSXML ?
Thanks !
James
Moderator

Re: how to create schema metadata for tFileInputMSXML ?

Hi,
So far, there is only File XML metadata for tFileInputXML and tExtractXMLField components.
In addition, we provide "generic schema" to user, once the specific metadata wizards don't match your needs .
TalendHelpCenterSmiley Frustratedetting up a Generic schema from a source xml file
If your needs is still unsatisfied , it is welcome to open a DI project of jira issue on TalendBugTracker.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: how to create schema metadata for tFileInputMSXML ?

Thanks for your reply.
I was trying to use the Generic Schema as suggested, but I kept getting the error "Access to the data failure{0}
org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the declaration of element 'tns:vaultDepositFile'."
I did some research. I found it was the bug of Talend 5.2.2 which I was using.( https://jira.talendforge.org/browse/TDI-24503?page=com.atlassian.jira.plugin.system.issuetabpanels%3... ).
Then I downloaded the fixed versions mentioned in the link, including 5.3.0 and latest one 5.3.1. But they all performed the same error.
I think my input xml is correct because I used the same in other components such as tFileinputXML, tfileinputMSXML. It worked fine with them.
Could you tell it is still a Talend bug or I used it in wrong way ? If it is not a bug, could you provide me a working sample XML with schema ?
Thanks
James
Moderator

Re: how to create schema metadata for tFileInputMSXML ?

Hi,
Would you minding add a comment in this bug with your detailed situation(upload your input source is preferred), our developer will check it.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: how to create schema metadata for tFileInputMSXML ?

Yes, I have added a comment.
Thanks !
James

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog