refactory/csv2xml.py at staging · cecep-edu/refactory · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
# csv2xml.py
# FB - 201010107
# First row of the csv file must be header!

# example CSV file: myData.csv
# id,code name,value
# 36,abc,7.6
# 40,def,3.6
# 9,ghi,6.3
# 76,def,99

import csv

csvFile = 'entidad.csv'
xmlFile = 'entity_public_data.xml'

csvData = csv.reader(open(csvFile))
xmlData = open(xmlFile, 'w')
xmlData.write('<?xml version="1.0"  encoding="utf-8"?>' + "\n")
# there must be only one top-level tag
xmlData.write('<openerp>' + "\n" + '<data noupdate="1">' + "\n")

rowNum = 1

#estado = ("azuay","bolivar","canar","carchi","chimborazo","cotopaxi","oro","esmeraldas","galapagos","guayas","imbabura","loja","rios","manabi","morona","napo","orellana","pastaza","pichincha","santa","tsachilas","sucumbios","tungurahua","zamora")

for row in csvData:
    xmlData.write('<record model="entity.public" id="entitypublic_%s">'%str(rowNum) + "\n")
    #xmlData.write('<field name="cod_mrl">%s</field>'%row[1] + "\n")
    xmlData.write('<field name="name">%s</field>'%row[1] + "\n")
    xmlData.write('<field name="ruc">%s</field>'%row[0] + "\n")
    xmlData.write('<field name="description"></field>' + "\n")
    xmlData.write('</record>'+ "\n")
    rowNum = rowNum + 1

xmlData.write("\n" + '</data>' + "\n" + '</openerp>')
xmlData.close()