2018-12-30 GnuCash IRC logs

00:07:19 *** kapil___ has joined #gnucash
00:12:09 *** nimish has joined #gnucash
01:17:30 *** jotrago has quit IRC
01:18:35 *** jotrago has joined #gnucash
01:19:03 *** fell has quit IRC
01:19:45 *** fell has joined #gnucash
01:50:54 *** boldstripe has quit IRC
01:51:50 *** boldstripe has joined #gnucash
01:52:43 *** gour has joined #gnucash
02:02:52 *** nimish has quit IRC
02:13:46 *** nimish has joined #gnucash
02:34:02 *** Mechtilde has joined #gnucash
03:04:16 *** CDB-Man_ has joined #gnucash
03:06:28 *** CDB-Man has quit IRC
03:19:07 *** nimish has quit IRC
03:19:39 *** nimish has joined #gnucash
03:19:56 *** nimish has quit IRC
03:20:23 *** nimish has joined #gnucash
03:38:35 *** nimish has quit IRC
03:51:35 *** boldstripe has quit IRC
03:52:31 *** boldstripe has joined #gnucash
03:54:51 *** User_ has joined #gnucash
04:38:59 *** jrp has joined #gnucash
05:27:04 *** kapil___ has quit IRC
05:27:20 *** nimish has joined #gnucash
05:36:29 *** jrp has quit IRC
05:36:38 *** jrp has joined #gnucash
05:37:21 *** jrp has quit IRC
05:37:26 *** jrp has joined #gnucash
05:38:13 *** jrp has joined #gnucash
05:38:57 *** jrp has quit IRC
05:39:02 *** jrp has joined #gnucash
05:39:49 *** jrp has joined #gnucash
05:40:32 *** jrp has quit IRC
05:40:38 *** jrp has joined #gnucash
05:41:21 *** jrp has quit IRC
05:41:26 *** jrp has joined #gnucash
05:42:14 *** jrp has joined #gnucash
05:42:57 *** jrp has quit IRC
05:43:02 *** jrp has joined #gnucash
05:43:50 *** jrp has joined #gnucash
05:44:33 *** jrp has quit IRC
05:44:37 *** jrp has joined #gnucash
05:45:20 *** jrp has quit IRC
05:45:26 *** jrp has joined #gnucash
05:46:13 *** jrp has joined #gnucash
05:46:57 *** jrp has quit IRC
05:47:02 *** jrp has joined #gnucash
05:47:51 *** jrp has joined #gnucash
05:48:34 *** jrp has quit IRC
05:48:38 *** jrp has joined #gnucash
05:49:22 *** jrp has quit IRC
05:49:26 *** jrp has joined #gnucash
05:50:15 *** jrp has joined #gnucash
05:50:58 *** jrp has quit IRC
05:51:02 *** jrp has joined #gnucash
05:51:51 *** jrp has joined #gnucash
05:52:15 *** boldstripe has quit IRC
05:52:34 *** jrp has quit IRC
05:52:39 *** jrp has joined #gnucash
05:53:11 *** boldstripe has joined #gnucash
05:53:22 *** jrp has quit IRC
05:53:27 *** jrp has joined #gnucash
05:54:15 *** jrp has joined #gnucash
05:54:58 *** jrp has quit IRC
05:55:02 *** jrp has joined #gnucash
05:55:51 *** jrp has joined #gnucash
05:56:34 *** jrp has quit IRC
05:56:39 *** jrp has joined #gnucash
05:57:22 *** jrp has quit IRC
05:57:27 *** jrp has joined #gnucash
05:58:15 *** jrp has joined #gnucash
05:58:58 *** jrp has quit IRC
05:59:02 *** jrp has joined #gnucash
05:59:51 *** jrp has joined #gnucash
06:00:34 *** jrp has quit IRC
06:05:31 *** kapil___ has joined #gnucash
06:16:59 *** User_ has quit IRC
06:28:18 *** oozer has joined #gnucash
06:35:37 *** jrp has joined #gnucash
06:37:02 *** nimish has quit IRC
06:38:37 *** jrp has quit IRC
06:45:49 *** fabior has joined #gnucash
06:51:59 *** Mechtilde has quit IRC
06:56:26 *** CDB-Man has joined #gnucash
06:58:15 *** CDB-Away_ has joined #gnucash
06:58:43 *** CDB-Man_ has quit IRC
06:59:00 *** CDB-Man_ has joined #gnucash
06:59:54 *** CDB-Man has quit IRC
07:01:21 *** CDB-Away_ has quit IRC
07:03:20 *** nimish has joined #gnucash
07:08:09 *** Mechtilde has joined #gnucash
07:09:32 *** nimish has quit IRC
07:11:55 *** FoxT has quit IRC
07:12:51 *** jrp has joined #gnucash
07:19:08 *** FoxT has joined #gnucash
07:20:50 *** gjanssens has joined #gnucash
07:20:50 *** ChanServ sets mode: +o gjanssens
07:21:14 *** fabior has quit IRC
07:21:16 <gjanssens> ,
07:25:30 *** nimish has joined #gnucash
07:27:59 *** Mechtilde has quit IRC
07:28:12 *** Mechtilde has joined #gnucash
07:31:06 *** gour has quit IRC
07:31:10 *** nimish has quit IRC
07:31:37 *** nimish has joined #gnucash
07:31:39 *** gour has joined #gnucash
07:39:14 *** jrp has quit IRC
07:44:21 *** maschinenhans has joined #gnucash
07:52:56 *** boldstripe has quit IRC
07:53:52 *** boldstripe has joined #gnucash
07:55:48 *** nimish has quit IRC
08:02:11 *** O01eg has quit IRC
08:06:09 *** max has joined #gnucash
08:15:49 *** nimish has joined #gnucash
08:33:35 *** RobinC has joined #gnucash
08:36:44 <RobinC> Hello, just testing 3.3 with remote mysql server (windows client, mysql on linux server) . All worked fine until i tried a failed network test. With network lost, gnucash hangs and needs to be killed. Is this expected? anyway to get a more graceful fail, even if its followed by gnucash exiting?
08:39:31 *** jrp has joined #gnucash
08:42:31 *** jrp has quit IRC
08:49:07 *** ARampoor has joined #gnucash
08:49:59 <ARampoor> How to search these logs for topic please
08:52:48 <gjanssens> ARampoor: what do you mean by that ?
08:54:00 <gjanssens> RobinC: I don't know. I don't think I have ever tested gnucash behavior in a failing network environment.
09:05:02 *** nimish has quit IRC
09:08:15 <ARampoor> gjanssens: Where is index for searching these logs?
09:08:54 <gjanssens> https://lists.gnucash.org/logs/
09:09:37 <gjanssens> Although they are not really searchable. You'll have to browse them.
09:09:55 <gjanssens> Or you can use google's site search like this
09:10:13 <gjanssens> your-search-term site:lists.gnucash.org
09:10:41 <ARampoor> search logs only using google?
09:10:45 <RobinC> gjanssens, yea client is on wifi and connects to internet via DSL so drop outs are likely even if not that frequent. I guess i'll stick with an XML file and dropbox sync. My use case is being able to access accounts from home/work/other places but not always the same computer
09:11:28 <gjanssens> ARampoor: yes
09:12:09 <gjanssens> RobinC: ok. You may poll the gnucash-user mailing list for the experiences others have with unstable networks
09:13:22 *** Mechtilde has quit IRC
09:14:18 *** Mechtilde has joined #gnucash
09:16:43 <ARampoor> gjanssens: google finds to pipermail. It is different index from the logs?
09:17:37 <gjanssens> Yes, pipermail is our mailing list archive for the gnucash-user, gnucash-devel and other mailing lists
09:17:52 <gjanssens> The logs/ path is the archive of all irc conversations.
09:18:05 <gjanssens> I don't know if you can separately search those via google
09:18:32 *** finster has joined #gnucash
09:18:58 <gjanssens> It seems you can by making the site parameter more specific:
09:19:11 <gjanssens> your-search-term site:lists.gnucash.org/logs
09:20:06 <finster> hello all. using gnucash 3.3. what is the quickest way to get the net worth per end of month?
09:20:26 <finster> possibly for a series of months
09:22:11 <ARampoor> gjanssens: searching site:lists:gnucash.org/logs is finding no documents
09:23:04 <gjanssens> That should be site:lists.gnucash.org/logs (a . between lists and gnucash, not a :)
09:25:31 <ARampoor> gjanssens: still is finding no documents
09:25:40 <gjanssens> It does for me
09:25:44 <gjanssens> What are you looking for ?
09:27:38 *** fabior has joined #gnucash
09:27:45 <finster> there is default reports that show net worth per 1st of month. does that show data for the 1st of the month 00:00am or 11:59pm? in the former case it would be safe to assume net worth of, say, January 1st equals that one of December 31st of the previous year
09:28:05 <ARampoor> gjanssens: searching how to clear multiple register entries at once, making "n" into "c" in R column
09:28:58 <Mechtilde> ARampoor, you mean "Reconcile"?
09:29:22 <ARampoor> yes, Reconcile multiple entries at once
09:29:25 <gjanssens> Perhaps this was never discussed on irc ?
09:30:15 <Mechtilde> ARampoor, choose the funktion and set the first and the last day you want to recncile
09:30:18 <Mechtilde> and say ok
09:32:56 <ARampoor> Mechtilde: choosing Reconcile showing "statement date", "starting balance", "ending balance", but not first and last day
09:33:55 <Mechtilde> Thats what I mean
09:34:25 <Mechtilde> I did translation without seeing the dialog
09:35:15 <Mechtilde> so what is your problem with these statements
09:37:41 <RobinC> gjanssens, yea i'll take another look. Found a relevant message relating to "no keep alive", but in their case they actually got a "unable to connect to database" message. Had a quick source browse, looks like problem lies in libdbi, the mysql backend has a timeout option and in gnucash when it calls libdbi it does not pass a timeout using dbi_conn_set_option().
09:40:34 *** jotrago has quit IRC
09:41:41 <ARampoor> Mechtilde: New screen opens with "funds in", "funds out", but missing many entries
09:43:40 <Mechtilde> Is that the account you want to reconcile?
09:45:14 <ARampoor> Mechtilde: yes
09:45:25 <Mechtilde> and you know the "tutorial and Concepts"?
09:48:07 <Mechtilde> can you see a difference between the shown entries and the missed entries?
09:49:12 <ARampoor> Mechtilde: "funds in" is missing entries
09:50:30 <ARampoor> Mechtilde: register is showing all entries, "funds in" showing only some
09:51:27 <Mechtilde> are there some entries reconciled so there are only found the newer one?
09:52:10 <Mechtilde> so you have to choose an older starting balance
09:53:37 *** boldstripe has quit IRC
09:54:33 *** boldstripe has joined #gnucash
09:55:42 <ARampoor> Mechtilde: yes, choosing older starting date is making "funds in" complete, but "funds out" still is missing entries
09:56:32 <Mechtilde> older or newer one?
09:57:09 *** richard has quit IRC
09:59:16 <ARampoor> Mechtilde: older
09:59:48 <Mechtilde> then you have to set the startingbalance earlier
10:02:18 <ARampoor> Mechtilde: setting starting balance earlier is not making funds out complete
10:03:53 <Mechtilde> then there is a problem with your data
10:05:28 *** finster has left #gnucash
10:07:41 <ARampoor> Mechtilde: how to fix the problem?
10:08:34 <Mechtilde> The datas exist at that account?
10:08:47 <Mechtilde> are they already reconciled?
10:09:04 <Mechtilde> how do they differ from the other datas?
10:09:18 <ARampoor> Mechtilde: nothing reconciled
10:10:07 <Mechtilde> then you staarted with the first statement in this account?
10:10:24 <ARampoor> Mechtilde: yes, first statement
10:10:33 <Mechtilde> and last statement
10:10:47 *** jrp has joined #gnucash
10:11:54 <ARampoor> Mechtilde: no. changing my answer, I started with statement Jan 2018, but not first statement
10:12:24 <Mechtilde> and the missing entries are younger then jan 2018?
10:12:33 <Mechtilde> s/then/than
10:13:19 <ARampoor> Mechtilde: missing entries in Jan 2018
10:13:47 *** jrp has quit IRC
10:13:53 <ARampoor> Mechtilde: missing some entries in jan 2018
10:14:16 <Mechtilde> do you choose the first enry of the first day of Jan 2018?
10:15:01 <ARampoor> Mechtilde: choose where?
10:15:28 <Mechtilde> in the reconcile dialog for the start balance
10:17:02 <ARampoor> Mechtilde: yes. choosing first entry is finding first entry in "funds in" but first entry still is missing in "funds out"
10:17:47 <Mechtilde> and the missing entry in funds out is youngeer than the one in funds in?
10:21:20 <ARampoor> Mechtilde: missing entry is missing in funds out
10:21:52 <Mechtilde> yes are they younger than the oldest entry in funds in?
10:21:54 <ARampoor> Mechtilde: funds in is finding Jan 1, 2018 entry but funds out is not finding same entry
10:22:19 <Mechtilde> one entry can only fund in or fund out
10:23:12 <ARampoor> Mechtilde: not both?
10:23:29 <Mechtilde> e.g the first fund in comes at Jan 1 but the first fund out comes at Jan 2
10:24:06 <ARampoor> Mechtilde: how then to reconcile if entry is not in both?
10:27:29 *** max has quit IRC
10:27:34 <ARampoor> Mechtilde: what is meaning of funds in and funds out?
10:28:16 <Mechtilde> and you know the "tutorial and Concepts"?
10:30:08 <ARampoor> Mechtilde: no, where to find it?
10:30:34 <Mechtilde> http://gnucash.org/docs.phtml
10:31:34 <ARampoor> Mechtilde: ok, thank you
10:32:54 *** ARampoor has quit IRC
10:35:17 *** kapil___ has quit IRC
10:35:30 *** fabior has quit IRC
10:59:02 *** User_ has joined #gnucash
10:59:18 *** nimish has joined #gnucash
11:01:43 *** maschinenhans has quit IRC
11:02:05 *** User_ has quit IRC
11:06:36 *** tienne has joined #gnucash
11:07:20 *** oozer has quit IRC
11:28:45 *** RobinC has quit IRC
11:45:55 *** puck has quit IRC
11:53:03 *** puck has joined #gnucash
11:54:17 *** boldstripe has quit IRC
12:03:05 *** oozer has joined #gnucash
12:19:02 *** boldstripe has joined #gnucash
12:21:42 *** Mechtilde has quit IRC
12:22:00 *** Mechtilde has joined #gnucash
12:32:37 *** oozer has quit IRC
13:08:03 *** doubledev has joined #gnucash
13:11:26 *** jrp has joined #gnucash
13:11:26 *** tienne has quit IRC
13:12:20 <doubledev> Hello everyone, I had a question about how I should handle loaning money. I have a small business and created a couple of loans. They are in Liabilities > Loans > Loan 1, Loan 2, ... How do I get the loans amounts to go into the Checking account? Is it as simple as create the loan and then put that in as a deposit in the Checking? I would assume that it would have done that automatically.
13:14:25 *** jrp has quit IRC
13:32:27 <gjanssens> doubledev: just to be clear - with "loan" do you mean money you have received and have to pay back or money you borrowed to someone else and they will pay back to you ?
13:32:52 <gjanssens> The principle in gnucash is the same, I just like to explain in the proper direction
13:33:50 <gjanssens> So the next question is, how did you create these loans ? I presume you have created an opening transaction.
13:34:10 <gjanssens> So where did you transfer the loan's opening transaction to ?
13:39:53 <doubledev> gjanssens: I think I figured it out. I initially did an opening transaction and associated it to the Liabilities > Loan category. And when creating the account in the Assets > Current Assests > Checking account it was doubling up. I changed the Loan's category to the Assets > Current Assests > Checking and it seems to look right. Does this seem about right?
13:41:04 <gjanssens> Well, probably mostly. Gnucash doesn't work with "categories", but accounts.
13:41:24 <gjanssens> And all money moves from an account to an account (in the simplest form)
13:41:50 <gjanssens> So to map your transactions, the easiest is to follow the money flow.
13:42:34 <gjanssens> If you received money you have to pay back that means in your checking account the balance goes up. That money must come from somewhere, in this case your newly created loan account
13:42:54 <gjanssens> So you create a transaction between those two accounts
13:43:22 <gjanssens> For most people it's easier to understand if you create the transaction starting in your bank account
13:44:02 <gjanssens> If you're new to double entry accounting, I highly recommend you to read the tutorial and concepts guide you will find on our website.
13:45:01 <gjanssens> In any case if your books now have one transaction between your checking and your loan account and the checking balance has changed the way you expect, you probably did it correctly :)
14:02:51 *** doubledev has quit IRC
14:02:53 *** doubledev has joined #gnucash
14:04:48 <doubledev> gjanssens: Thank you. I was looking on your site and also on YouTube, there are a few people that have some good information on there. I didn't see anything that covered this specifically but grazed through some of the other videos to see if they talked about anything like this.
14:06:29 *** max has joined #gnucash
14:12:44 *** jrp has joined #gnucash
14:15:44 *** jrp has quit IRC
14:16:57 *** frakturfreak has joined #gnucash
14:56:45 *** nimish has quit IRC
14:58:12 *** gncbot sets mode: +o fell
15:07:06 *** jralls changes topic to " Free GPL Personal and Small Business Accounting || Please don't ask to ask, just ask and wait! (Possibly a few hours!!) || publicly-logged channel || latest stable: 3.4 || www.gnucash.org || wiki.gnucash.org/wiki/"
15:24:10 <gjanssens> Oh, is the release ready ? Congrats!
15:29:19 <jralls> Yup, went pretty smoothly for a change. The only issue was the links to gnc-docbookx.dtd in docs. Distcheck wouldn't make them, so I switched to telling xmllint to look in ${top_srcdir}/docbook.
15:33:56 <jralls> Wow, Steve Butler got a .deb up 10 minutes after the release!
15:35:09 <gjanssens> Impressive indeed :)
15:35:48 <gjanssens> I may have to revisit the gnc-docbookx.dtd issue. I believe your change will break my itstool experiment.
15:35:54 <gjanssens> But that can be done later.
15:38:58 <gjanssens> I'm heading for bed early today. It have been busy weeks.
15:39:23 <gjanssens> By the way, I'll be afk from Jan 1st to Jan 8th
15:39:34 <gjanssens> Taking a break
15:39:54 <gjanssens> I can probably check in from time to time though
15:40:17 <gjanssens> TTYL
15:40:51 *** gjanssens has quit IRC
16:04:27 *** Mechtilde has quit IRC
16:14:00 *** jrp has joined #gnucash
16:17:00 *** jrp has quit IRC
16:21:01 *** Mechtilde has joined #gnucash
16:27:57 *** Mechtilde has quit IRC
16:28:10 *** Mechtilde has joined #gnucash
16:39:39 *** mateharu has joined #gnucash
16:59:51 *** gour1 has joined #gnucash
17:01:39 *** gour has quit IRC
17:01:52 *** gour1 has quit IRC
17:15:31 *** jrp has joined #gnucash
17:18:32 *** jrp has quit IRC
17:37:57 *** Mechtilde has quit IRC
17:45:26 *** CDB-Away has joined #gnucash
17:47:03 *** oozer has joined #gnucash
18:52:57 *** frakturfreak has quit IRC
19:09:30 *** waltman has joined #gnucash
19:10:42 *** max has quit IRC
19:12:30 <waltman> I'm seeing fractional prices in my mutual fund accounts. I see that people reported this over the summer and that it was supposed to be fixed in version 3.3. I'm running version 1:3.3-2 on Ubuntu 18.10 but I'm still seeing it.
19:12:37 *** philthornley has joined #gnucash
19:14:32 *** mateharu has quit IRC
19:17:23 *** philthornley has quit IRC
19:54:11 *** bertbob has quit IRC
19:55:59 *** bertbob has joined #gnucash
19:59:04 *** bertbob has quit IRC
20:00:08 <jralls> waltman: Select "Force Prices to display as decimals" under Numbers in the General tab of Preferences.
20:01:05 <jralls> fell: Gotta go make dinner, but do you know anything about new SEPA formats for PSD2? There was a UserVoice item about it today.
20:01:11 *** jralls is now known as jralls_afk
20:02:15 <fell> Not offhand
20:12:54 *** fell has quit IRC
20:14:21 *** bertbob has joined #gnucash
20:18:26 *** fell has joined #gnucash
20:34:57 *** oozer has quit IRC
21:12:54 *** Bernard641 has joined #gnucash
21:13:18 <Bernard641> hello
21:13:24 <fell> jralls, I rejected it.
21:13:59 <fell> Hello, Bernard641!
21:14:15 <Bernard641> Hi Fell
21:14:26 <Bernard641> Can I ask something about gnu?
21:14:50 <fell> AFAIK, Gnus are animals. ;-)
21:15:04 <fell> How about GnuCash?
21:15:38 <Bernard641> yes, gnucash
21:15:59 <Bernard641> can i ask something about gnucash?
21:17:52 <fell> Don't ask to ask, just ask!
21:18:15 <Bernard641> When I open my gnucash
21:18:34 <Bernard641> When I open my gnucash, the currency icon is shown as ?
21:18:54 <Bernard641> How can I correct this?
21:19:18 <Bernard641> currency is Pesos
21:19:33 <fell> That is usually an issue with your font
21:19:59 <Bernard641> ok
21:20:16 <Bernard641> do you know how to solve it?
21:21:08 <fell> https://wiki.gnucash.org/wiki/FAQ#Q:_How_get_I_rid_of_strange_unreadable_characters_or_adjust_the_font_size
21:27:47 <Bernard641> fell, do you mind if i send you a private message?
21:28:03 <fell> why?
21:28:54 <Bernard641> coz i still don't know how to fix it after reading the link you sent
21:28:55 <Bernard641> :(
21:29:37 <fell> https://wiki.gnucash.org/wiki/Locale_Settings
21:29:53 <fell> is the starting point
21:30:21 <fell> your OS/distri?
21:30:29 <Bernard641> windows
21:30:53 <fell> 1, 2, 95, ...
21:31:02 <Bernard641> 10
21:31:21 <Bernard641> windows 10
21:32:15 <fell> your language and country?
21:32:57 <Bernard641> Pesos, Philippines
21:35:41 *** chris has quit IRC
21:36:13 <Bernard641> ₱
21:38:38 <fell> Yes, it is shown, when you use utf-8 as character set.
21:39:07 <Bernard641> how do I use utf-8?
21:39:23 <fell> I am no windows user.
21:39:44 <Bernard641> i tried to go to tools, security editor and change the font there but it is not accepting it
21:40:25 <fell> Ususually there is in windows something like System setting
21:40:53 <fell> and inside somthing to set language and region
21:41:35 <fell> Another topic might be about fonts
21:42:01 <Bernard641> ok
21:43:11 *** chris has joined #gnucash
21:44:44 <fell> then you need a font, where the symbol is defined
21:45:36 *** chris has quit IRC
21:46:08 *** storyjesse has joined #gnucash
21:46:29 *** chris has joined #gnucash
21:52:20 *** Bernard641 has quit IRC
21:59:56 *** doubledev has left #gnucash
23:29:44 *** Bernard641 has joined #gnucash
23:32:49 <Bernard641> when i press the right arrow key when using auto completion, it won't go to the end of the line
23:32:57 *** kapil___ has joined #gnucash
23:33:51 <Bernard641> for example, i am typing washing machine, when i type w, it will show washing machine, but then when i press the right arrow key to go to the end of the word, it will remain at w
23:34:07 <Bernard641> do you know what im trying to say, fell?
23:41:10 <Bernard641> https://1drv.ms/u/s!AseoAkBuCK_Qgrlh3F1D30rA5VH8Mw
23:41:23 <Bernard641> please check the link i sent to illustrate what I meant
23:41:25 <Bernard641> thank you