Creating a json file from a xml file in python with xmltodict

Question

I am trying to create a json file from an input xml file using xmltodict with the following code

import io, xmltodict, json
infile = io.open(filename_xml, 'r')
outfile = io.open(filename_json, 'w')
o = xmltodict.parse( infile.read() )
json.dump( o , outfile )

the last line get me the following error

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/__init__.py", line 182, in dump
    fp.write(chunk)
TypeError: must be unicode, not str

I guess I need to change the encoding. My initial xml file seems to be ascii. Any idea on how to make this work? Thanks

which line gives the error?

dutt
– dutt

2013-02-06 08:46:21 +00:00
Commented Feb 6, 2013 at 8:46 — dutt
– dutt, Commented Feb 6, 2013 at 8:46
the json.dump( o, outfile ) line

RockridgeKid
– RockridgeKid

2013-02-06 18:59:44 +00:00
Commented Feb 6, 2013 at 18:59 — RockridgeKid
– RockridgeKid, Commented Feb 6, 2013 at 18:59

Olaf Dietsche · Accepted Answer · 2013-02-06 08:49:05Z

5

You can open the file in binary mode

outfile = io.open(filename_json, 'wb')

This will allow str as well.

answered Feb 6, 2013 at 8:49

Olaf Dietsche

74.4k9 gold badges113 silver badges214 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

akaIDIOT · Accepted Answer · 2013-02-06 08:26:23Z

0

unicode and str are two different types of objects in Python prior to version 3. You can turn your value into a unicode object (which is basically also a string) by coercing it:

my_var = unicode(my_str)

answered Feb 6, 2013 at 8:26

akaIDIOT

9,2413 gold badges29 silver badges30 bronze badges

3 Comments

RockridgeKid Over a year ago

Thanks for your answer. Where do you think I should use the unicode call?

akaIDIOT Over a year ago

Just looking at your code I'd say as json.dump(unicode(o), outfile), but you'll have to try that yourself :)

akaIDIOT Over a year ago

I don't have your libraries installed nor run OSX, but the error gives you a precise line number that triggers the error; maybe the code surrounding that line will shed some light on your issue.

Collectives™ on Stack Overflow

Creating a json file from a xml file in python with xmltodict

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related