Importing Data using XML

sf9912

Forums

Dear Brian,
Comparing IDEA x EXCEL when we are importing XML files, EXCEL can import many files and create a table with so many record, however IDEA import only one file and create one database. Can we make IDEA work as EXCEL when importing so many files and create only one database?
Thanks at all.

sf9912 Thu, 02/19/2015 - 11:16

Which extention is the definition file asked when it's running this script. Could you try use my sent files as a example?

Brian Element Thu, 02/19/2015 - 12:10

You have to import one of the xml files into IDEA, that will automatically create a definition file that will be stored in Import Definitions.ILB folder.  When running the script you would select all the xml files you wish to import and then select the definition files which is an xrdf file.  All the xml files need to be in the same format for this to work.

sf9912 Tue, 03/03/2015 - 20:14

Sorry cos my insistence. I still didn't solve my demand. EXCEL solve so easy but IDEA require so much (complicate to not say impossible solution).
The defination file (xrdf) don't accept any change between xml files in the structures.
What do you sugest? We can assert that EXCEL (about this topic) is better than IDEA?
By the way thanks for script sent.
P.S.- Only small change in the xml file, cause ERROR when import xml files using primary xrdf file (it's too strict).

sf9912 Sun, 05/29/2016 - 14:22

Hi Brian, I solve my problem, adding all xml files. I put the first with a tag <New> and to the last xml file, I put a tag <\New> (closing TAG). I used a DOS COMMAND "copy *.xml ALL.xml". After collecting all xml files, import ALL.xml by IDEA. The PARSER IDEA will show the elements from the xml file. Mark or Unmark they and finish the proccess.
What do you think about?