Projects / fineco2qif / Comments

Comments for fineco2qif

17 Sep 2010 08:21 marcoaicardi

Ho aggiornato il file di patch, sembrava dare alcuni errori.


--- fineco2qif.py 2009-01-23 17:13:00.000000000 +0100
+++ fineco-carta2qif.py 2010-09-17 10:17:17.368338655 +0200
@@ -1,10 +1,15 @@
#!/usr/bin/python
-# Importer script to convert Fineco xls files into QIF files,
+# Importer script to convert Fineco Credit Card xls files into QIF files,
# for use, among others, by gnucash.
#
+# Based on the fineo2qif.py script by
# Antonino Sabetta - antonino.sabetta@isti.cnr.it
# (C) - 2009
#
+# Modified by Marco Aicardi - marco [a] aicardi d0t org
+#
+# Released under GPLv3 License - www.gnu.org/licenses/g...
+#
# This is based on Jelmer Vernooij's script
# for PostBank mijn.postbank.nl .csv files.
# Jelmer Vernooij <jelmer@samba.org>, 2007
@@ -36,8 +41,7 @@
assert line == ['Risultato ricerca movimenti']

line = rows.next()
- assert line == ['DataOperazione','Data Valuta','Entrate','Uscite','Descrizione','Causale']
-
+ assert line == ['Data operazione','Data Registrazione','Descrizione Operazione','Tipo spesa','Tipo rimborso','Importo in euro']

##
# begin main program
@@ -75,10 +79,8 @@
p = l[0].split("/")
print "D%s/%s/%s" % (p[0], p[1], p[2]) # you can easily get month-day-year here...
# print 'D%s/%s/%s' % (l[0][4:6], l[0][6:8], l[0][0:4]) # date
- if l[2] == '':
- print 'T-%s' % l[3] # negative amount
- else:
- print 'T%s' % l[2] # positive amount
- print 'P%s' % l[4] # payee / description
- print 'M%s' % l[5] # comment
+ print 'T-%s' % l[5] # negative amount
+ print 'P%s' % l[2] # payee / description
+ print 'M%s' % l[2] # comment
print '^\n' # end transaction
+

27 Jul 2010 09:55 marcoaicardi

Come giÓ ti ho segnalato via email mi sono permesso di modificare il tuo script per permettere di elaborare gli XLS della carta di credito fineco.

Questo Ŕ il patch delle modifiche che ho fatto:

--- fineco2qif.py 2009-01-23 17:13:00.000000000 +0100
+++ fineco-carta2qif.py 2010-05-11 22:18:22.992442538 +0200
@@ -2 +2 @@
-# Importer script to convert Fineco xls files into QIF files,
+# Importer script to convert Fineco Credit Card xls files into QIF files,
@@ -4,0 +5 @@
+# Based on the fineo2qif.py script by
@@ -7,0 +9,4 @@
+# Modified by Marco Aicardi - marco [a] aicardi d0t org
+#
+# Released under GPLv3 License - http://www.gnu.org/licenses/gpl-3.0.html
+#
@@ -39 +44 @@
- assert line == ['DataOperazione','Data Valuta','Entrate','Uscite','Descrizione','Causale']
+ assert line == ['Data operazione','Data Registrazione','Descrizione Operazione','Tipo spesa','Tipo rimborso','Importo in euro']
@@ -78,6 +83,3 @@
- if l[2] == '':
- print 'T-%s' % l[3] # negative amount
- else:
- print 'T%s' % l[2] # positive amount
- print 'P%s' % l[4] # payee / description
- print 'M%s' % l[5] # comment
+ print 'T-%s' % l[5] # negative amount
+ print 'P%s' % l[2] # payee / description
+ print 'M%s' % l[2] # comment

Screenshot

Project Spotlight

ReciJournal

An open, cross-platform journaling program.

Screenshot

Project Spotlight

Veusz

A scientific plotting package.