Import .XML files using .XSD files as schemas

arsmatilde

Forums

Hi,
I've been trying to import a .XML file to IDEA using the import wizard tool, but I don't get the expected outcome, instead of 59 fields I get more than 300. The issue might be that IDEA is not taking into account the schema files when importing the .XML file.
Is there a way of import one XML file to IDEA and apply 5 different schemas (in 5 diferente .XSD files)?
Thanks in advance.

Brian Element Wed, 04/19/2017 - 16:17

Hi arsmatilde,

Yes, you should be able to do that.  What you should probably do is select your file in the Import Assistant and click on the next.  You then have a list of all the fields in the xml file, something like this:

You can select the fields you want to import.  When you import the first time it will create the definition for future imports.  You can also break it up into several layers if you want.

Hope this helps out a bit.

Brian

arsmatilde Thu, 04/20/2017 - 05:50

Hi  Brian,
Thanks for your reply, although it isn't exactly what I'm looking for.
When we export a table from IDEA in a XML format, we get two files: the XML file and the XSD file.  What I want to do is the other way around, I want to import a XML file and be able to import also the XSD (in order to validate the fields). Because it's possible to export XSD files, I believe that it's also possible to import them.
In this case I want to import a XML file and validate the fields (formats and inputs) through 5 different XSD files.
Hope this is clear.
Thanks in advance,
Ana

Brian Element Thu, 04/20/2017 - 09:51

Hi Ana,

Thanks for the clarrification.  What you will have to do is rename the XSD to XML and then you will be able to import it into IDEA using the XML import feature.  It looks like IDEA only looks for XML file extenstions so that is why you will have to make the change.

Brian

arsmatilde Thu, 04/20/2017 - 14:25

Hi Brian,
Thanks for your quick reply.
I understand that I must convert the XSD file to XML in order to make the file readable by IDEA, but then after having imported both files, I will get 2 different tables in IDEA. How can I apply the validation of the XSD file to the XML file?
Could you please clarify the steps that I need to take in order to import the XML file and apply the validitions defined in the 5 XSD files?
Thanks a lot!
Ana
 

svanzon Tue, 09/11/2018 - 08:08

I am having the same problem. From Exact Online (Netherlands) you get aan XML with the transaction and an XSD file with the scheme/schedule. But I can't seem to import the XML according to the XSD.

Brian Element Tue, 09/11/2018 - 08:42

Hi svanzon,

This one I would recommend you contact the IDEA support desk with this question as I don't work much with XML files and I am not in a position to give you any advice.

Thanks

Brian