search

mtotschnig / MyExpenses

GPL licenced Android Expense Tracking App
http://www.myexpenses.mobi/
GNU General Public License v3.0
768 stars 209 forks source link

optimized qif format for gnucash #34

Closed timbo-lino closed 11 years ago

timbo-lino commented 11 years ago

Für den Import in gnucash sollte das qif output Format optimiert werden. Denn gnucash kann mit der Notiz zu einem Buchungssatz nichts anfangen, Der wird beim Import einfach ignoriert. Gebe ich z.B. als Empfänger "Deutsche Bahn" an und vermerke in der Notiz die Reise, taucht diese in gnucash nicht mehr auf.

Bisher sieht der output so aus: D11/07/2012 T-49,80 MFahrt nach Frankfurt LFahrtkosten : Fahrtkosten PDeutsche Bahn

durch eine Einstellungsmöglichkeit, sagen wir "gnucash import" in den Einstellungen könnte doch der Buchungssatz anders geschrieben werden.

z.B. D11/07/2012 T-49.80 LFahrtkosten : Fahrtkosten PDeutsche Bahn - Fahrt nach Frankfurt Also, die Notiz hinter den Empfänger

//////////////////////////////////////////////////////////////////////////////////////////////7 For the import in gnucash the "qif" output format should be optimized. Because gnucash can not deal with the note in the record. It will simply be ignored during import. If I give e.g. as a receiver "Deutsche Bahn" and put the destination into the notes field, this will not be shown in gnucash.

So far, the output looks like this: D11/07/2012 T-49,80 MFahrt nach Frankfurt LFahrtkosten : Fahrtkosten PDeutsche Bahn

by providing a new menu entry, lets say "gnucash import" in the preferences menu, the new record could look like

D11/07/2012 T-49.80 LFahrtkosten : Fahrtkosten PDeutsche Bahn - Fahrt nach Frankfurt

So, the note behind the receiver

lauco74 commented 11 years ago

I do not think that feature would be useful because, for "grisbi", it will involvesthe creation of a new category at each change of the memo field. Furthermore, I doubt that it was correctly interpreted by other software using QIF format. The goal is the compliance of the standard "QIF" for the most of software.

timbo-lino commented 11 years ago

@lauco74

For that reason I want the possibility to enable that feature just for the case that you need / want it. With the current settings the "note" field is useless for people that want to import the data into gnucash.

I change this manually now and this is only little work, but it would be better with this feature.

mtotschnig commented 11 years ago

Hello timbo-lino, I googled about how Gnucash handles the memo field, and it appears that it is not ignored, but simply not displayed by default. Just select "View -> Double line" ("Ansicht -> Bemerkung anzeigen"). Hope that helps