Hello everyone,

I am trying to read data from an XML file to Stata. The XML file contains all changes in petrol station prices in 2020 in France. The data is provided by the French authorities (https://www.prix-carburants.gouv.fr) and can be downloaded using this link: https://donnees.roulez-eco.fr/opendata/annee/2020.

My first idea was to use xmluse for this:
Code:
xmluse "PrixCarburants_annuel_2020.xml", doctype(dta)
However, this produced the error "unrecognizable XML doctype". I changed the doctype to "doctype(excel)", but the error message stayed.


My second idea was to use usexmlex:
Code:
usexmlex using "PrixCarburants_annuel_2020.xml"
This shows the following error message:
t_horaires automate-24-24=" invalid name
st_addvar(): 3300 argument out of range
usexmlex(): - function returned error
<istmt>: - function returned error


Does anyone know, how I could solve this issue? I would only need the data for November and December 2020 as well as January and February 2021, but I do not know how to extract these two months from the XML file either. Thank you very much and please let me know, if you need further information.