Importing Data using XML

17 posts / 0 new
Last post
sf9912
Offline
Joined: 11/04/2014 - 19:49

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's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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
Offline
Joined: 11/04/2014 - 19:49

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).

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi sf9912,

I will message you with another version to try out.

Brian

sf9912
Offline
Joined: 11/04/2014 - 19:49

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?

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

That sounds like a great idea, glad you found something that worked for yo.

Pages