mjhjmtu

I have 5000 questions in txt file like this:

<quiz>
 <que>The question her</que>
 <ca>text</ca>
 <ia>text</ia>
 <ia>text</ia>
 <ia>text</ia>
 </quiz>

I want to write a script in Ubuntu to convert all questions like this:

 
 "text":"The question her",
 "answer1":"text",
 "answer2":"text",
 "answer3":"text",
 "answer4":"text"
 ,

I assume your Ubuntu has python installed

#!/usr/bin/python3
import io
import json
import xml.etree.ElementTree

d = """<quiz>
 <que>The question her</que>
 <ca>text</ca>
 <ia>text</ia>
 <ia>text</ia>
 <ia>text</ia>
 </quiz>
"""

s = io.StringIO(d)
# root = xml.etree.ElementTree.parse("filename_here").getroot()
root = xml.etree.ElementTree.parse(s).getroot()
out = 
i = 1
for child in root:
 name, value = child.tag, child.text
 if name == 'que':
 name = 'question'
 else:
 name = 'answer%s' % i
 i += 1
 out[name] = value

print(json.dumps(out))

save it and chmod to executable
you can easily modify to take a file as input instead of just text

EDIT
Okey, this is a more complete script:

#!/usr/bin/python3
import json
import sys
import xml.etree.ElementTree


def read_file(filename):
 root = xml.etree.ElementTree.parse(filename).getroot()
 return root


# assule we have a list of <quiz>, contained in some other element
def parse_quiz(quiz_element, out):
 i = 1
 tmp = 
 for child in quiz_element:

 name, value = child.tag, child.text
 if name == 'que':
 name = 'question'
 else:
 name = 'answer%s' % i
 i += 1
 tmp[name] = value
 out.append(tmp)


def parse_root(root_element, out):
 for child in root_element:
 if child.tag == 'quiz':
 parse_quiz(child, out)


def convert_xml_to_json(filename):
 root = read_file(filename)
 out = 
 parse_root(root, out)
 print(json.dumps(out))


if __name__ == '__main__':
 if len(sys.argv) > 1:
 convert_xml_to_json(sys.argv[1])
 else:
 print("Usage: script <filename_with_xml>")

I made a file with following, which I named xmltest:

<questions>
 <quiz>
 <que>The question her</que>
 <ca>text</ca>
 <ia>text</ia>
 <ia>text</ia>
 <ia>text</ia>
 </quiz>
 <quiz>
 <que>Question number 1</que>
 <ca>blabla</ca>
 <ia>stuff</ia>
 </quiz>
</questions>

So you have a list of quiz inside some other container.

Now, I launch it like this:
$ chmod u+x scratch.py, then scratch.py filenamewithxml

This gives me the answer:

$ ./scratch4.py xmltest
["answer3": "text", "answer2": "text", "question": "The question her", "answer4": "text", "answer1": "text", "answer2": "stuff", "question": "Question number 1", "answer1": "blabla"]

in fact, you could get away here even w/o Python programming, just using 2 unix utilities:

1. 
   jtm - that one allows xml <-> json lossless conversion


2. 
   jtc - that one allows manipulating JSONs

Thus, assuming your xml is in file.xml, jtm would convert it to the following json:

bash $ jtm file.xml 
[
 
 "quiz": [
 
 "que": "The question her"
 ,
 
 "ca": "text"
 ,
 
 "ia": "text"
 ,
 
 "ia": "text"
 ,
 
 "ia": "text"
 
 ]
 
]
bash $ 

and then, applying a series of JSON transformations, you can arrive to a desired result:

bash $ jtm file.xml | jtc -w'<quiz>l:[1:][-2]' -ei echo '"answer[-]"': ; -i'<quiz>l:[1:]' | jtc -w'<quiz>l:[-1][:][0]' -w'<quiz>l:[-1][:]' -s | jtc -w'<quiz>l:' -w'<quiz>l:[0]' -s | jtc -w'<quiz>l: <>v' -u'"text"'
[
 
 "answer1": "text",
 "answer2": "text",
 "answer3": "text",
 "answer4": "text",
 "text": "The question her"
 
]
bash $ 

Though, due to involved shell scripting (echo command), it'll be slower than Python's - for 5000 questions, I'd expect it would run around a minute. (In the future version of the jtc I plan to allow interpolations even in statically specified JSONs, so that for templating no external shell-scripting would be required, then the operations will be blazing fast)

if you're curious about jtc syntax, you could find a user guide here: https://github.com/ldn-softdev/jtc/blob/master/User%20Guide.md

Thank you dgan, but your code:
1- print the output in the screen not in json file, and not support encoding= utf-8, so i change it:

 ##!/usr/bin/python3
import json, codecs
import sys
import xml.etree.ElementTree


def read_file(filename):
 root = xml.etree.ElementTree.parse(filename).getroot()
 return root


# assule we have a list of <quiz>, contained in some other element
def parse_quiz(quiz_element, out):
 i = 1
 tmp = 
 for child in quiz_element:

 name, value = child.tag, child.text
 if name == 'que':
 name = 'question'
 else:
 name = 'answer%s' % i
 i += 1
 tmp[name] = value
 out.append(tmp)


def parse_root(root_element, out):
 for child in root_element:
 if child.tag == 'quiz':
 parse_quiz(child, out)


def convert_xml_to_json(filename):
 root = read_file(filename)
 out = 
 parse_root(root, out)
 with open('data.json', 'w') as outfile:
 json.dump(out, codecs.getwriter('utf-8')(outfile), sort_keys=True, ensure_ascii=False)


if __name__ == '__main__':
 if len(sys.argv) > 1:
 convert_xml_to_json(sys.argv[1])
 else:
 print("Usage: script <filename_with_xml>")

`