Converting a txt file to an xml file in Python

Question

Good morning

I would like to know if there is a solution to convert a text file to an xml file directly :

This is my text file:

5g8hj;Tournevis;cm;5,10

6r9tl;Marteau;cm;8,20

5d6ft;peinture;l;50,10

7ja3t;Vis;cm;500,001

And I'd like my XML file to look like this:

<?xml version='1.0' encoding='UTF-8'?>
<Bricolage>
  <Article>
    <Code_Article>5g8hj</Code_Article>
    <Nom_Article>Tournevis</Nom_Article>
    <Unite_Article>cm</Unite_Article>
    <Nombre>5,10</Nombre>
  </Article>
  <Article>
    <Code_Article>6r9tl</Code_Article>
    <Nom_Article>Marteau</Nom_Article>
    <Unite_Article>cm</Unite_Article>
    <Nombre>8,20</Nombre>
  </Article>
  <Article>
    <Code_Article>5d6ft</Code_Article>
    <Nom_Article>peinture</Nom_Article>
    <Unite_Article>l</Unite_Article>
    <Nombre>50,10</Nombre>
  </Article>
  <Article>
    <Code_Article>7ja3t</Code_Article>
    <Nom_Article>Vis 12*12,25</Nom_Article>
    <Unite_Article>cm</Unite_Article>
    <Nombre>500,001</Nombre>
  </Article>
</Bricolage>

Please don't add the code of that XML file as an image, add it as actual text so it's easier for us to help you. Thank you. — THess, Jan 20 '20 at 08:34
See if the following answer might help: [link](https://stackoverflow.com/questions/26056316/how-to-convert-txt-file-into-xml-file-using-python) — Noah.Ehrnstrom, Jan 20 '20 at 08:40
I've already seen it but I'm missing the Code_Article, but otherwise that's what I wanted. — , Jan 20 '20 at 08:42
Does this answer your question? [How to convert .txt file into xml file using python?](https://stackoverflow.com/questions/26056316/how-to-convert-txt-file-into-xml-file-using-python) — John M, Jan 20 '20 at 08:46
Yes, but no, because I'm missing the item code, and I really need it. — , Jan 20 '20 at 09:11

score 1 · Accepted Answer · answered Feb 06 '20 at 08:43

Text files :

5g8hj;Tournevis;cm;5,10
6r9tl;Marteau;cm;8,20
5d6ft;peinture;l;50,10
7ja3t;Vis 12*12,25;cm;500,001

#!/usr/bin/python2.7
# -*-coding:Latin-1 -*

import csv
from lxml import etree as et

root = et.Element("Bricolage")

data = []
with open("Codes_articles.txt") as file:
    for row in csv.reader(file, delimiter=";"):
        article = et.SubElement(root, "Article")
        code = et.SubElement(article, "Code_Article")
        code.text = row[0]
        nom = et.SubElement(article, "Nom_Article")
        nom.text = row[1]
        unite = et.SubElement(article, "Unite_Article")
        unite.text = row[2]
        nombre = et.SubElement(article, "Nombre")
        nombre.text = row[3]
        data.append(row)

xml_datas = et.tostring(root, pretty_print=True, xml_declaration=True, encoding="utf-8")

# pour print :
print(xml_datas.decode())

# pour écrire le fichier :
with open("direct_txt_to_xml.xml", "wb") as outfile:
    outfile.write(xml_datas)

This results in :

<?xml version='1.0' encoding='utf-8'?>
<Bricolage>
  <Article>
    <Code_Article>5g8hj</Code_Article>
    <Nom_Article>Tournevis</Nom_Article>
    <Unite_Article>cm</Unite_Article>
    <Nombre>5,10</Nombre>
  </Article>
  <Article>
    <Code_Article>6r9tl</Code_Article>
    <Nom_Article>Marteau</Nom_Article>
    <Unite_Article>cm</Unite_Article>
    <Nombre>8,20</Nombre>
  </Article>
  <Article>
    <Code_Article>5d6ft</Code_Article>
    <Nom_Article>peinture</Nom_Article>
    <Unite_Article>l</Unite_Article>
    <Nombre>50,10</Nombre>
  </Article>
  <Article>
    <Code_Article>7ja3t</Code_Article>
    <Nom_Article>Vis 12*12,25</Nom_Article>
    <Unite_Article>cm</Unite_Article>
    <Nombre>500,001</Nombre>
  </Article>
</Bricolage>

yvesonline · Answer 2 · 2020-01-22T08:32:36.003

Assuming your text is in input.txt try this:

from xml.etree.ElementTree import Element, ElementTree, SubElement, Comment, tostring


def indent(elem, level=0):
    i = "\n" + level*"  "
    if len(elem):
        if not elem.text or not elem.text.strip():
            elem.text = i + "  "
        if not elem.tail or not elem.tail.strip():
            elem.tail = i
        for elem in elem:
            indent(elem, level+1)
        if not elem.tail or not elem.tail.strip():
            elem.tail = i
    else:
        if level and (not elem.tail or not elem.tail.strip()):
            elem.tail = i


top = Element("Bricolage")

with open("input.txt", "r") as f:
    for x in f:
        splits = x.split(";")
        child = SubElement(top, "Article")
        sub_child_1 = SubElement(child, "Code_Article")
        sub_child_1.text = splits[0]
        sub_child_2 = SubElement(child, "Nom_Article")
        sub_child_2.text = splits[1]
        sub_child_3 = SubElement(child, "Unite_Article")
        sub_child_3.text = splits[2]
        sub_child_4 = SubElement(child, "Nombre")
        sub_child_4.text = splits[3]

indent(top)

tree = ElementTree(top)

tree.write("output.xml")

This uses the pretty printing from http://effbot.org/zone/element-lib.htm#prettyprint.

Is there any way to make it look exactly like the model I gave you ?, because there's no line breaks, everything's on the same line. — , Jan 20 '20 at 09:08
That's just a case of pretty printing the resulting `xml`. Have a look at this question for an answer: https://stackoverflow.com/questions/749796/pretty-printing-xml-in-python — yvesonline, Jan 20 '20 at 09:16
I tried to add what you advised me but it doesn't work, I mean, I have mistakes. — , Jan 20 '20 at 09:44
What kind of mistakes? You'll need to paste them here so that I can help you. — yvesonline, Jan 20 '20 at 16:19

Converting a txt file to an xml file in Python

2 Answers2