converting json to xml

[pasi12]

HI,
I am new to python and learning , need help converting json file to xml . I have below code ( found on web ) modified a bit but is not parsing the whole file only few lines: 
appreciate any help!
Thanks!
Output:

Output:
<Core>
<case_id>
CASE_17BC95
</case_id>
<case_id>
CASE_17D59E
</case_id>
</Core>t]
Process finished with exit code 0

here is the code:

import json

def json2xml(json_obj, Line_spacing=""):
   result_list = list()
   json_obj_type = type(json_obj)

   if json_obj_type is list:
       for sub_elem in json_obj:
           result_list.append(json2xml(sub_elem, Line_spacing))

       return "\n".join(result_list)
   if json_obj_type is dict:
       for tag_name in json_obj:
           sub_obj = json_obj[tag_name]
           result_list.append("%s<%s>" % (Line_spacing, tag_name))
           result_list.append(json2xml(sub_obj, "\t" + Line_spacing))
           result_list.append("%s</%s>" % (Line_spacing, tag_name))
           # print(result_list)
           return "\n".join(result_list)
   return "%s%s" % (Line_spacing, json_obj)

with open ("C://Users//test//Documents//json2.txt") as s:
data = json.load(s)
print(json2xml(data))

[dudeisbrendan03]

Python already allows you to convert from JSON into a native dict (using ''json'' or, in versions < 2.6, simplejson), so I found a library that converts native dicts into an XML string.
https://github.com/quandyfactory/dict2xml
It supports int, float, boolean, string (and unicode), array and dict data types and arbitrary nesting (yay recursion).

---

Another way is that you could open cmd and use pip to install:
json2xml json2xml
(^REQUIRES PIP3 AND PYTHON3)
(Use the following command:)
pip install json2xml json2xml

Then walah':
python from json2xml.json2xml

import Json2xml 
data = Json2xml.fromjsonfile('examples/example.json').data 
data_object = Json2xml(data) data_object.json2xml()

^From a JSON file to XML.

[pasi12]

Thanks for the tips I was able to install with pip but i am not sure where to put/link the python code in my code as you mentioned? what a bout a print statement?
import Json2xml

data = Json2xml.fromjsonfile('examples/example.json').data
data_object = Json2xml(data) data_object.json2xml()


Thanks!

---

I Imported the json2xml and now all of json2xml saying re declared json2xml above with no usage? can you update my code with what you are mentioning? so I can run it here and see?
Thanks!

[dudeisbrendan03]

Thanks for the tips I was able to install with pip but i am not sure where to put/link the python code in my code as you mentioned? what a bout a print statement?
import Json2xml

data = Json2xml.fromjsonfile('examples/example.json').data
data_object = Json2xml(data) data_object.json2xml()


Thanks!

---

I Imported the json2xml and now all of json2xml saying re declared json2xml above with no usage? can you update my code with what you are mentioning? so I can run it here and see?
Thanks!

Please completely scrap what I said before. PIP does not allow you to use from src
You need to use PIP3

So do thi' following:

pip3 install json2xml

^Voodoo magic A (Installs json2xml via PIP3)

python -m src.cli --file="examples/example.json"

^Voodoo magic B (Allows you to use json2xml via cmd)          OR:

from src.json2xml import Json2xml
data = Json2xml.fromjsonfile('examples/example.json').data
data_object = Json2xml(data)
data_object.json2xml() #xml output

^Voodoo magic C (json2xml via a script)
Do not try to implement this into your current script as it probally will not work. I cant see it working anyway.


MAKE A NEW SCRIPT USING THAT CODE REPLACING 'examples/example.json' with the location of your .json file.

Enjoy if this works. Good luck!

[zivoni]

Your json2xml function has wrong indentation on line 19 - return is inside for loop, so processing ends after parsing first member in dictionary. With that corrected it might work reasonably well.

import json

def json2xml(json_obj, Line_spacing=""):
   result_list = list()
   json_obj_type = type(json_obj)
 
   if json_obj_type is list:
       for sub_elem in json_obj:
           result_list.append(json2xml(sub_elem, Line_spacing))
 
       return "\n".join(result_list)
   if json_obj_type is dict:
       for tag_name in json_obj:
           sub_obj = json_obj[tag_name]
           result_list.append("%s<%s>" % (Line_spacing, tag_name))
           result_list.append(json2xml(sub_obj, "\t" + Line_spacing))
           result_list.append("%s</%s>" % (Line_spacing, tag_name))
           # print(result_list)
       return "\n".join(result_list)      # <-- this one was misindented
   return "%s%s" % (Line_spacing, json_obj)

[dudeisbrendan03]

Your json2xml function has wrong indentation on line 19 - return is inside for loop, so processing ends after parsing first member in dictionary. With that corrected it might work reasonably well.

import json


def json2xml(json_obj, Line_spacing=""):
   result_list = list()
   json_obj_type = type(json_obj)
 
   if json_obj_type is list:
       for sub_elem in json_obj:
           result_list.append(json2xml(sub_elem, Line_spacing))
 
       return "\n".join(result_list)
   if json_obj_type is dict:
       for tag_name in json_obj:
           sub_obj = json_obj[tag_name]
           result_list.append("%s<%s>" % (Line_spacing, tag_name))
           result_list.append(json2xml(sub_obj, "\t" + Line_spacing))
           result_list.append("%s</%s>" % (Line_spacing, tag_name))
           # print(result_list)
       return "\n".join(result_list)      # <-- this one was misindented
   return "%s%s" % (Line_spacing, json_obj)

Oh my, I just reread his code an realised he was using json2xml. I thought he was just using the json library and didnt finish reading it. Sorry about that. I feel stupid :P

EDIT: Although that would work, it is very extensive compared to other methods.

[pasi12]

ok.. I already installed the pip when I try to install pip3 its says you already installed all the files? how do I uninstall pip pkg?

---

Dudei.. its working now!! thanks so much the proble was as you mentioned the misindented

return "\n".join(result_list) # <-- this one was misindented

Thanks Again! I cant beleive the indentation will cause all these problems! don't like Python! :)