CODEWITHSUNDEEP
pythonxml
Jarratt Perkins
Jarratt Perkins

Reputation: 303

Python error "not well-formed (invalid token)"

I have some software that outputs an XML file that I am trying to read with python, so I can get the results and add them into my database.

import xml.etree.ElementTree as etree
with open('E:/uk_bets_history.xml', 'r') as xml_file:
    xml_tree = etree.parse(xml_file)

I am getting the error xml.etree.ElementTree.ParseError: not well-formed (invalid token): line 1, column 1 but I am unsure why it is not formatted correctly.

I am not in control of how the file is created as this is done by some other software I own.

The example xml is here: http://jarrattperkins.com/uk_bets_history

Upvotes: 1

Views: 10431

Answers (2)

Onur E.A
Onur E.A

Reputation: 1

with open(file=file_path, mode='r', encoding='utf-8-sig') as xml_txt:                 
  root = ET.fromstring((xml_txt.read().encode('utf-8')), ET.XMLParser(encoding='utf-8'))

This works for me. Thanks Jules_96

Upvotes: 0

Olvin Roght
Olvin Roght

Reputation: 7812

File you've provided as example use UTF-8 with BOM encoding, so you need to use open() with encoding argument:

open("FILE_PATH", encoding="utf-8-sig")

Upvotes: 3

Related Questions