Skip to main content

Importing Data using XML

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.

Brian Element Wed, 02/18/2015 - 19:09

Hi, do you have an example of an xml file that you could share?  I don't have any good examples of xml files.

sf9912 Wed, 02/18/2015 - 20:56

I have, but it's confidencial work from companies that I audited (sigilous). If you send me your personal email or if I can send in private, I could take 5 files as a exemple. Waiting your answer,
Thx.

sf9912 Wed, 02/18/2015 - 21:28

Ok,
but to attach XML I can't. The site allows only formats png, gif, jpg, jpeg and iss, xls, xlsx, rdf, csv, txt, ideafunc, imd could you help me to attach XML files?

Brian Element Thu, 02/19/2015 - 07:26

So in IDEA would this be the same as bringing in each xml file and then doing an append to create one file from the several imported xml files?  I just want to make sure I am understanding this rigth.  From the Excel import you import each xml file but you can import it underneath the previous one, is that what you are doing?

sf9912 Thu, 02/19/2015 - 07:47

In EXCEL I can import so many files in the same time, that is for exemple 1.000 files XML  --> 01 spread sheet (EXCEL), but IDEA I only get ONE by ONE,that is 01 XML FILE --> 01 DATABASE.IMD (IDEA).