2017-06-11 GnuCash IRC logs
00:00:11 <Tyson> I have heard the gnucash reads all data into memory at launch. Is this true for a postgres backend?
00:22:17 *** kael has joined #gnucash
01:19:06 *** kael has quit IRC
01:26:38 *** Mechtilde has joined #gnucash
01:28:39 *** kael has joined #gnucash
01:29:14 *** Cail has joined #gnucash
01:29:21 *** kael has joined #gnucash
01:29:32 *** kael has quit IRC
01:35:14 *** Cail has left #gnucash
02:19:34 *** Aussie_matt has joined #gnucash
02:35:29 *** mlncn has joined #gnucash
02:40:35 *** Mechtilde has quit IRC
02:42:38 *** Mechtilde has joined #gnucash
02:55:47 *** mlncn has quit IRC
03:58:28 *** Mechtilde has quit IRC
04:00:07 *** Mechtilde has joined #gnucash
05:00:44 *** Aussie_matt has quit IRC
05:37:32 *** fabior has joined #gnucash
06:34:03 *** karelk has quit IRC
06:53:53 *** mlncn has joined #gnucash
07:00:17 *** Jimraehl1 has joined #gnucash
07:02:25 *** Jimraehl1 has quit IRC
07:08:26 *** fabior has quit IRC
08:02:48 *** fabior has joined #gnucash
08:07:31 *** User has joined #gnucash
08:21:54 *** Aussie_matt has joined #gnucash
09:00:09 *** mlncn has quit IRC
10:13:57 *** mlncn has joined #gnucash
10:14:01 *** karelk has joined #gnucash
10:37:33 *** Aussie_matt has quit IRC
10:42:01 *** Mechtilde has quit IRC
10:42:28 *** Mechtilde has joined #gnucash
11:02:12 *** fekepp has joined #gnucash
11:02:27 *** jotrago has quit IRC
11:02:42 *** jotrago has joined #gnucash
11:24:05 *** jotrago1 has joined #gnucash
11:24:32 *** jotrago has quit IRC
11:24:33 *** jotrago1 is now known as jotrago
11:32:59 *** jotrago has quit IRC
11:41:40 *** cyphase_ has quit IRC
11:45:24 *** mlncn has quit IRC
11:54:56 *** cyphase_ has joined #gnucash
11:58:03 *** jotrago has joined #gnucash
11:58:14 *** mlncn has joined #gnucash
12:05:51 *** jotrago has quit IRC
12:19:23 *** jotrago has joined #gnucash
13:02:13 *** User_ has joined #gnucash
13:07:57 *** schnaaki has joined #gnucash
13:09:40 <schnaaki> Hey folks! Any helping hand available with some accounting experience? Preferably German speaking, as I am not really familiar with the English accounting terminology. :)
13:12:50 *** mlncn has quit IRC
13:17:03 *** User_ has quit IRC
13:26:04 <Mechtilde> schnaaki, try it
13:33:55 <schnaaki> well I got a total permanent disability (TPD) insurance where parts of my fees contribute to the insurance and other parts are a financial investment based on investment fonds. Once a year I get a status report telling me how much money went into these fonds, but it's completely intransparent how this is calculated (including fees, changing prices, ...).
13:34:12 <schnaaki> I tried the whole day to get the same numbers as in this report but failed.
13:34:28 <schnaaki> Now my question is how to I account the money I spend each month for the insurance?
13:35:10 <schnaaki> parts of the money vanish in the insurance and other parts will be funds someday in the future
13:35:26 <schnaaki> but except the yearly report I have no clue how to split my monthly fees
13:35:52 <schnaaki> as I am a total beginner I hoped to find some experienced accountants here :)
13:36:53 <schnaaki> hope it makes sense to some extent what I tried to describe :-/
13:38:34 <Mechtilde> did you read the chapter about splits in "Kurs und Konzepte"?
13:39:56 <Mechtilde> as I remember there is an example for Income as an employee
13:41:07 <schnaaki> well in general I know how a split works and I also have a structure ready on how I would account my monthly fees
13:41:41 <schnaaki> but since I don't know the exact monthly parts that go into my fonds I cannot split accordingly
13:41:51 <Mechtilde> then you can try to do it simmilar
13:42:02 <Mechtilde> you know what you want to get
13:42:03 <schnaaki> I only have a once-a-year information on these fonds
13:42:42 *** dougransom has joined #gnucash
13:43:21 <Mechtilde> you can differ it to 12 month as an approach
13:45:07 <dougransom> I downloaded transactions from my bank account. The Transfer for a particular transaction is an account "Advances". Will I create a problem for future downlaods if I change the Description from the bank default "PC-Email Money TRF" to the employee name (i.e. "Home Simpson")?
13:45:12 <schnaaki> so you would just split the yearly fonds into equal parts?
13:49:00 <schnaaki> but gnucash supports also keeping track of fonds over time and report on how their price develop... i would love to use that, even if that makes it more complicated ;)
14:17:05 *** frakturfreak has joined #gnucash
14:17:51 *** mlncn has joined #gnucash
14:22:06 *** fabior has quit IRC
14:23:44 *** mlncn has quit IRC
14:24:04 *** Mechtilde has quit IRC
14:25:01 *** mikee_ has joined #gnucash
14:26:00 *** mikee has quit IRC
14:26:01 *** mikee_ is now known as mikee
14:26:02 *** ChanServ sets mode: +o mikee
14:53:28 *** Mechtilde has joined #gnucash
14:55:45 *** mlncn has joined #gnucash
15:05:40 *** mlncn has quit IRC
15:07:04 *** mlncn has joined #gnucash
15:09:04 <warlord> Tyson: Yes, even with SQL all data is read into core. GnuCash is not a DB App
15:09:21 <warlord> dougransom: It might confuse it down the road, maybe..
15:15:32 *** mlncn has quit IRC
15:36:17 <dougransom> warlord: I am trying to determine correct workflow. I have downloaded some transactions, and need to split them to reflect payroll taxes. So I am just editing the transaction downloaded from the bank to inclue the splits. I think that is the right way.
15:42:17 *** fabior has joined #gnucash
16:23:36 *** aperali has joined #gnucash
16:24:39 <aperali> Hi all, could you help me to setup SQLite3 because I cant save as this DB, please?
16:25:44 <aperali> Id like to put an user and password on my gnucash files
16:26:30 *** frakturfreak has quit IRC
17:18:29 *** schnaaki has quit IRC
17:45:35 *** mlncn has joined #gnucash
18:03:31 *** fabior has quit IRC
18:07:58 <jralls> aperali: SQLite3 won't do that. Only one of the servers (MySQL/Maria or Postgresql) will... but you need to know what you're doing to run one of those.
18:16:03 *** mrklintscher2 has joined #gnucash
18:17:17 *** mrklintscher has quit IRC
18:38:32 *** kael has joined #gnucash
18:39:28 *** mrklintscher has joined #gnucash
18:40:59 *** mrklintscher2 has quit IRC
18:42:08 *** mlncn has quit IRC
18:43:52 *** kael has joined #gnucash
18:51:01 *** kael has joined #gnucash
18:53:59 <Tyson> warlord: when I insert a value in the GL it auto commits to the DB, no?
18:54:09 <Tyson> warlord: Postgres
19:14:58 *** mrklintscher has quit IRC
19:36:58 *** Aussie_matt has joined #gnucash
20:14:41 *** fekepp has quit IRC
20:27:29 <Aussie_matt> can someone please help me get stock prices on some australian stocks?
20:29:00 *** aperali has left #gnucash
20:39:35 <warlord> Tyson: yes, the main benefit of the SQL backend is that data commits get stored immediately. HOWEVER, all data is still in core and read/search/etc is all done using the in-core data. It is never "refreshed".
20:40:05 <warlord> dougransom: possibly, but future downloads wont consider it a duplicate.
20:40:53 <warlord> Aussie_matt: what's the symbol? and what's the proper quote source?
20:43:14 <Aussie_matt> hi warlord, let start with Commonwealth bank, CBA on the ASX
20:46:56 <warlord> Are you sure CBA is the correct name? Also, it's possible that F::Q ASX quote source broke
20:47:44 <warlord> I think the ASX quote source is broken.
20:49:54 <Tyson> warlord: So the data gets written to core and the database?
20:50:18 <Aussie_matt> right, ok. so yahoo aussie finance is a good pick?
20:56:39 <warlord> Aussie_matt: that seems to work for me. gnc-fq-dump yahoo_australia CBA returns good data.
20:57:01 <warlord> Tyson: well, "core" is "RAM", so, ... yes
20:57:28 <warlord> If you're using a SQL backend it will get written out to the DB immediately. If you're using XML, then no -- it stays in core until you "Save"
20:57:41 <warlord> (just like if you're editing a Word document)
21:01:22 <Aussie_matt> warlord: nice, can you walk me though testing that at my end please?
21:04:40 <warlord> Aussie_matt: run gnc-fq-dump yahoo_australia CBA
21:04:55 <Aussie_matt> just from cli?
21:05:36 <warlord> yes. that will verify that you have F::Q installed correctly and it's working for you If that works, then you just need to set the quote source for your CBA security to yahoo_australia
21:05:36 *** CDB-Man has joined #gnucash
21:05:52 *** CDB-Away_ has quit IRC
21:06:14 <Aussie_matt> ok, that looks good! comes up with a few lines of output
21:06:19 *** CDB-Man_ has quit IRC
21:06:58 <Aussie_matt> that's a relief, I used the mageia packaged version of gnucash, wasn't sure if it pulled in everything
21:09:33 <Aussie_matt> right, so how can I change it from the asx source to yahoo?
21:15:25 <Aussie_matt> when i try to edit the account, I get 'commodity already exists'
21:17:35 <Tyson> warlord: The reason I ask is I have been experimenting with adding data to the relations outside of the application. I noticed the data does not show up right way until I "refresh" the app.
21:22:22 <warlord> Aussie_matt: Tools -> Security Editor
21:22:26 *** mlncn has joined #gnucash
21:22:42 <warlord> Tyson: modifying the database from outside the gnucash API is not supported.
21:22:58 <warlord> And no, the app will not notice changes to the database until it is reloaded
21:23:14 <warlord> This is exactly what I mean by read/search is only from in-core.
21:24:52 <Aussie_matt> warlord: cool! thank you , are you a developer?
21:30:13 <Tyson> warlord: Thank you. I understand it is not supported. Is there a way to programmatically refresh the in-core data?
21:30:52 <warlord> Aussie_matt: used to be. Now I just hang around, help people, and run the infrastructure
21:30:59 <warlord> Tyson: no.
21:31:11 <warlord> Well, yes. "Close" and "Reopen"
21:31:45 <Aussie_matt> warlord: thanks! it's a pretty neat bit of software.. anyways, I have to head out. Got my share price quotes working.... now just to enter them all
21:33:05 <warlord> Enjoy
21:36:42 <Tyson> warlord: Thank you.
21:39:01 <warlord> Tyson: what you're asking for is "multiple simultaneous users". It's on the roadmap
21:56:19 *** cyphase_ is now known as cyphase
22:03:57 *** CDB-Away has joined #gnucash
22:05:54 *** mlncn has quit IRC
22:11:55 *** mlncn has joined #gnucash
22:23:12 *** CDB-Away has quit IRC
22:29:02 *** User has quit IRC
22:29:38 *** CDB-Away has joined #gnucash
22:34:28 *** CDB-Away has quit IRC
22:53:13 *** tuxd00d_ has joined #gnucash
22:53:30 *** tuxd00d has quit IRC
22:53:30 *** tuxd00d_ is now known as tuxd00d
23:24:04 *** Aussie_matt has quit IRC