Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (3)
4 Replies
Anonymous
Not applicable
Author

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 .
TalendHelpCenter0683p000009M9p6.pngetting 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
Anonymous
Not applicable
Author

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
0683p000009MEuY.png
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

Yes, I have added a comment.
Thanks !
James