2013-09-09 GnuCash IRC logs

00:01:42 <Judah> More study of the gconf docs required. Will have to continue tomorrow. Out for now, thanks.
01:22:17 *** Jimraehl1 has quit IRC
01:28:22 *** Judah has left #gnucash
01:36:50 *** aqua___ has joined #gnucash
01:59:06 *** aqua_ has joined #gnucash
02:04:17 *** aqua___ has quit IRC
02:12:19 *** aqua__ has joined #gnucash
02:17:41 *** aqua_ has quit IRC
02:50:01 *** Krzysiek_K1 has quit IRC
03:05:22 *** fuzzybunny69y has joined #gnucash
03:32:33 *** uXus has quit IRC
03:36:37 *** uXus has joined #gnucash
03:43:48 *** wolfluffyf has joined #gnucash
03:49:49 *** aqua__ has quit IRC
03:52:16 *** olfluffywf has quit IRC
04:10:02 *** john has quit IRC
04:16:19 *** Topcat has joined #gnucash
04:46:26 *** Topcat has quit IRC
05:10:54 *** Topcat has joined #gnucash
05:15:56 *** Topcat has quit IRC
05:16:18 *** Topcat has joined #gnucash
05:26:34 *** Topcat has quit IRC
05:26:57 *** Topcat has joined #gnucash
05:31:56 *** Topcat has quit IRC
05:32:29 *** Topcat has joined #gnucash
05:37:29 *** Topcat has quit IRC
05:38:04 *** Topcat has joined #gnucash
05:43:04 *** Topcat has quit IRC
05:43:12 *** mitzekotze has joined #gnucash
05:43:44 *** Topcat has joined #gnucash
05:48:47 *** Topcat has quit IRC
05:49:28 *** Topcat has joined #gnucash
05:53:52 <mitzekotze> hi, I wanted to import my transaction from my gnucash android app into the gnucash desktop program but the account IDs don't match, although I exported my gnucash account structure from my desktop program to the android app
05:54:23 <mitzekotze> now I'm trying to import my android app transactions in my desktop program via a ofx file
05:55:34 <mitzekotze> but while the matching of the accounts of the ofx file with my accounts on my desktop I matched some accounts wrong
05:56:11 <mitzekotze> now I want to correct that but the gnucash desktop program use my old matching I did bevor
05:56:36 <mitzekotze> can I delete or modify these matchings?
05:58:12 <PaulFertser> mitzekotze: it looks like accounts can never match
05:58:41 <PaulFertser> mitzekotze: I faced the same issue and came to the conclusion you have to rely on "Generic Import" bayessian matcher to do it right after you "train" it several times.
05:59:15 <PaulFertser> mitzekotze: when you import it the next time you can select different accounts and it'll alter the statistics
05:59:45 <PaulFertser> mitzekotze: you can alter the transactions you've already matched manually in the corresponding Registers.
06:00:13 <PaulFertser> mitzekotze: you can manually edit the gnucash xml file to remove the bayes map if you're comfortable with hand-editing xml.
06:00:29 <mitzekotze> where can I find that xml file?
06:00:45 <mitzekotze> I'm a linux user btw
06:01:50 <PaulFertser> mitzekotze: gnucash file is a gzipped xml
06:02:38 <mitzekotze> aaah ok I see
06:02:56 <PaulFertser> mitzekotze: make backup before editing :)
06:03:09 <PaulFertser> mitzekotze: btw, you do not need to gzip it again, gnucash will do it automatically
06:03:29 <mitzekotze> ok, but I will first try it via the gui
06:03:48 <mitzekotze> but I'm a little bit confused
06:04:07 <PaulFertser> mitzekotze: so you can use GNU gzip to extract it, then GNU Emacs to modify it and GNUCash will see use it fine on your GNU/Linux system ;)
06:04:53 <mitzekotze> when I import an ofx file in gnucash then I have to match in the first place the accounts from the ofx file and the gnucash file
06:05:53 <mitzekotze> because of the use of double bookkeeping where do I then edit the second account?
06:08:17 <mitzekotze> do I have to double click on every transaction and chose the corresponding account for it?
06:09:31 <PaulFertser> mitzekotze: you just have to disable double bookkeeping in android gnucash afaict
06:12:29 <mitzekotze> but I want to keep it because I thought that import in desktop gnucash would go easier because there double bookkeeping is used
06:13:20 <PaulFertser> mitzekotze: then on import it first asks to match some "bank ids" to your accounts, and you should always select your "Cash" (or whatever you used to pay), and then it'll open a list of transactions in "generic import wizard" and there you'll be able to select particular accounts for every transaction.
06:13:26 <PaulFertser> mitzekotze: I though that too but alas
06:14:13 <PaulFertser> mitzekotze: I've read android gnucash issue tracker and came to the conclusion matching can't work properly and that its double bookkeeping option is useless.
06:14:26 <mitzekotze> oh -.-
06:14:39 <PaulFertser> And you just have to rely on statistics to help you match individual transactions in the generic import window.
06:15:31 <PaulFertser> mitzekotze: i think the main problem is using OFX as an exchange format, and GNUCash not being that smart about matching "bank ids" to accounts.
06:16:34 <mitzekotze> I was just wondering because when I export my account structure to android I thought the bank IDs must the same so desktop and android app accounts can match
06:16:56 <mitzekotze> but it seems that I was wrong
06:17:21 <PaulFertser> mitzekotze: i hoped for exactly the same
06:20:17 <mitzekotze> but my problem now remains, how can I change the already matched accounts in the import process without manuel editing the gnucash file
06:21:25 <PaulFertser> mitzekotze: you do not need to, as you can choose the right accounts the next time you import.
06:21:37 <mitzekotze> really?
06:21:54 <mitzekotze> gnucash seems to remember the account matches
06:22:01 <PaulFertser> mitzekotze: or if you're talking about changing already imported transactions, you can just open the corresponding register and manually select another account in there, see the FAQ about "moving transactions".
06:22:27 <PaulFertser> mitzekotze: it sort of does, but you can always override it on per-transaction basis the next time you import.
06:22:42 <PaulFertser> mitzekotze: or I'm not sure we're talking about the same thing.
06:23:57 <mitzekotze> I think we do not ^^
06:24:08 <PaulFertser> mitzekotze: even when transaction is "green" in import window you can still double-click it and select another account.
06:24:24 <mitzekotze> I mean the account you chose bevor that window
06:25:09 <PaulFertser> I had the impression android gnucash app randomly generates new ids all the time...
06:25:18 <mitzekotze> where you match the origin account in the ofx file with the origin account in the gnucash file
06:27:11 <PaulFertser> Yes, right, I see what you mean now.
06:27:36 <PaulFertser> mitzekotze: lurk here for some more please
06:28:42 <mitzekotze> sry what do you mean by that?
06:36:41 <PaulFertser> mitzekotze: I meant wait here for an answer from me or someone else
06:37:26 <PaulFertser> mitzekotze: I think in your existing Accounts there is some additional field "online_id" and it should be possible to change it via GUI.
06:46:14 *** Topcat has quit IRC
06:46:23 <PaulFertser> And if it's not in GUI it should be easy to edit out in xml manually.
06:46:24 <mitzekotze> PaulFertser: you mean the accounts in the gnucash file on my desktop?
06:46:40 <PaulFertser> mitzekotze: yes
06:46:50 *** Topcat has joined #gnucash
06:47:00 <PaulFertser> mitzekotze: if you're sure they've stored some wrong match for the bank ids used by android app.
06:49:11 <mitzekotze> maybe a stupid question but where do I can find that filed?
06:50:18 <mitzekotze> in the import dialog?
06:52:07 <PaulFertser> mitzekotze: no, i think it's not visible anywhere and you can change it only manually in gnucash file (if it's stored there at all).
06:56:58 *** mad has joined #gnucash
07:05:52 <PaulFertser> (visible for editing)
07:16:27 *** Topcat has quit IRC
07:16:49 *** Topcat has joined #gnucash
07:17:46 <mitzekotze> PaulFertser: I just transfer the transactions manuel by copying the content of the ofx file by hand in gnucash
07:19:12 <mitzekotze> I think that was the easiest way :D
07:19:31 <mitzekotze> but thank you very much for you patience and time
07:19:54 <PaulFertser> mitzekotze: eh eh
07:20:23 <PaulFertser> mitzekotze: i think it's a one-time solution but in the long run it's easier to import it the usual way.
07:20:33 <PaulFertser> mitzekotze: btw, i've consulted the source code to answer your questions.
07:20:43 <PaulFertser> Not that I'm sure I fully understood what was needed.
07:22:12 <mitzekotze> I think you understand what I needed but the direct editing in the gnucash xml file was a too fuzzy in the end for me
07:22:26 <mitzekotze> so I copied it per hand
07:23:50 <PaulFertser> mitzekotze: are you sure the next time you export ofx the ids would be the same and would get matched and gnucash would import it improperly again?
07:23:50 <mitzekotze> sry for using you time :/
07:24:40 <mitzekotze> no I'm not I think I have to stick with the manuel method
07:24:56 <PaulFertser> mitzekotze: btw, I have another probably unsuitable suggestion: if your smartphone has connectivity all the time, you can use ledger-rpc android client that would save everything straight to ledger files. Which you can then either process with ledger (without gnucash at all) or import in gnucash in automatic mode.
07:25:28 <PaulFertser> mitzekotze: why do not you try to add another transaction in the android app and see how it would get imported?
07:25:58 <PaulFertser> mitzekotze: do you really mean that you're going to stick to the manual importing method just because you made a wrong association between those "bank ids" and accounts _once_?
07:27:39 <mitzekotze> mhhh I could delete the account structure on the android app and create a new
07:27:45 <mitzekotze> so I will have new bank IDs
07:27:51 <PaulFertser> Yes, that would make it for sure
07:28:23 <mitzekotze> but even if I do that how can I know which bank ID is matched to which account when I import it into the desktop gnucash
07:28:26 <mitzekotze> ?
07:29:22 *** mad_ has joined #gnucash
07:30:10 <PaulFertser> mitzekotze: you'll choose it the first time desktop gnucash sees an unknown id.
07:30:19 <PaulFertser> mitzekotze: ah, i see what you mean
07:30:34 <PaulFertser> You can inspect the ofx beforehand manually to undestand which transactions correspond to which
07:30:46 <mitzekotze> mhhh that's an idea
07:31:09 *** mad has quit IRC
07:31:30 <mitzekotze> ok I think I will do that
07:43:36 *** Topcat has quit IRC
07:43:58 *** Topcat has joined #gnucash
07:45:17 <mitzekotze> PaulFertser: ok this way it works
07:46:41 <mitzekotze> but its not very intuitive in my opinion
07:48:51 <PaulFertser> mitzekotze: it's not indeed :(
07:49:01 <PaulFertser> mitzekotze: android is pos, so no wonder
07:49:10 <mitzekotze> pos?
07:49:43 <PaulFertser> piece of shit
07:49:56 <mitzekotze> xD
07:50:29 <mitzekotze> I hope this will be fixed in the near future
07:50:52 <PaulFertser> Judging by his bugtracker, unlikely :(
07:51:07 <mitzekotze> urgh
07:52:04 *** Ard0nik has quit IRC
07:53:49 <mitzekotze> the best way to use the android app with the desktop application is, that you only have one account (cash) on the app and you have to chose the second account to which it will go while you import the data or is there a way to use it more elegantly?
07:59:06 *** Topcat has quit IRC
07:59:40 *** Topcat has joined #gnucash
08:04:36 <PaulFertser> mitzekotze: i think if you mostly use one-two accounts you can just import it in that silly way, and then correct the source account by moving transactions manually in GUI.
08:16:52 *** Topcat has quit IRC
08:17:31 *** Topcat has joined #gnucash
08:27:32 *** Topcat has quit IRC
08:41:58 *** mad_ has quit IRC
09:12:10 *** TradeBorG has joined #gnucash
10:10:41 *** fuzzybunny69y has quit IRC
10:30:29 *** ErKa has joined #gnucash
10:39:32 *** benoitg has joined #gnucash
11:11:06 *** fell__ has joined #gnucash
11:11:07 *** gncbot sets mode: +o fell__
11:16:07 *** Jimraehl1 has joined #gnucash
11:20:39 *** fell_ has quit IRC
11:29:14 *** john has joined #gnucash
11:29:14 *** gncbot sets mode: +o john
11:30:52 *** benoitg has quit IRC
11:31:03 *** benoitg has joined #gnucash
11:40:14 *** TradeBorG has quit IRC
11:42:02 *** ErKa has quit IRC
11:54:50 *** mitzekotze has quit IRC
12:10:26 *** ErKa has joined #gnucash
12:27:20 *** kim27 has joined #gnucash
12:40:33 *** Topcat has joined #gnucash
12:46:33 *** ErKa has quit IRC
12:55:43 *** Topcat has quit IRC
12:56:16 *** Topcat has joined #gnucash
13:11:32 *** ErKa has joined #gnucash
13:31:49 *** Topcat has quit IRC
13:32:23 *** Topcat has joined #gnucash
13:37:24 *** Topcat has quit IRC
13:37:46 *** Topcat has joined #gnucash
13:42:47 *** Topcat has quit IRC
13:43:10 *** Topcat has joined #gnucash
13:53:12 *** Topcat has quit IRC
13:53:59 *** Topcat has joined #gnucash
13:58:59 *** Topcat has quit IRC
13:59:31 *** Topcat has joined #gnucash
14:04:30 *** Topcat has quit IRC
14:05:16 *** Topcat has joined #gnucash
14:09:50 *** shanny has joined #gnucash
14:22:35 *** Topcat has quit IRC
14:29:57 *** rpg has joined #gnucash
15:36:04 *** Jimraehl1 has quit IRC
17:26:29 *** Krzysiek_K has joined #gnucash
17:52:32 *** fell__ has quit IRC
17:52:36 *** fell__ has joined #gnucash
17:52:38 *** gncbot sets mode: +o fell__
17:53:08 *** fuzzybunny69y has joined #gnucash
18:03:09 *** fell__ has quit IRC
18:10:08 *** Topcat has joined #gnucash
18:13:05 *** Topcat has quit IRC
18:32:47 *** Krzysiek_K has quit IRC
18:57:41 *** benoitg has quit IRC
19:21:19 *** mad_ has joined #gnucash
19:44:23 *** fuzzybunny69y has quit IRC
19:54:58 *** fuzzybunny69y has joined #gnucash
19:59:56 *** ErKa has quit IRC
20:19:02 *** ErKa has joined #gnucash
20:34:25 *** fuzzybunny69y has quit IRC
20:37:29 *** Jimraehl1 has joined #gnucash
20:42:40 *** ErKa has quit IRC
20:49:44 *** mad_ has quit IRC
21:46:04 *** twunder has joined #gnucash
21:47:01 *** benoitg has joined #gnucash
21:47:01 *** gncbot sets mode: +o benoitg
22:02:10 *** rpg has quit IRC
23:13:09 *** twunder has quit IRC