adding an attribute to xml tags before exporting the file from excel 2010 to use with mantis -



adding an attribute to xml tags before exporting the file from excel 2010 to use with mantis -

i'm using mantis , need import bugs written on excel spreadsheet mantis,so created schema(file.xsd) , mapped info schema , exported bugs xml file compatible mantis.the problem need add together attribute(id) tags in produced xml file, there way step (e.g add together column in excel instance) during file preparation, mean before exporting file? here illustration of info exported , info want like:

the exported data:

<?xml version="1.0" encoding="utf-8"?> <mantis version="1.2.12" urlbase="http:xxx/mantis/" issuelink="#" notelink="~" format="1"> <issue> <id>29</id> <project>project 1</project> <reporter>engy</reporter> <priority>urgent</priority> <severity>block</severity> <reproducibility>always</reproducibility> <status>new</status> <resolution>open</resolution> <projectio>none</projection> </issue> </mantis>

i need add together id attribute <project> , <priority> , <severity>:

<project id="1">project 1</project> . .

xml excel xsd mantis

Comments

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

Accessing MATLAB's unicode strings from C -

javascript - mongodb won't find my schema method in nested container -