2018-04-25 GnuCash IRC logs
00:36:04 *** boldstripe has quit IRC
00:38:32 *** Mechtilde has joined #gnucash
00:47:27 *** MPL_ has quit IRC
01:05:20 *** fell_laptop has joined #gnucash
01:14:12 *** MPL_ has joined #gnucash
01:17:16 *** MPL_ has quit IRC
01:26:34 *** fell_laptop has quit IRC
01:26:34 *** fell has quit IRC
01:27:40 *** fell has joined #gnucash
01:27:43 *** fell_laptop has joined #gnucash
02:49:39 *** gncbot has joined #gnucash
02:49:46 *** ChanServ sets mode: +qo warlord warlord
02:49:49 *** warlord sets mode: +o gncbot
02:49:56 *** warlord sets mode: +o fell
03:12:35 *** warlord has quit IRC
03:13:10 *** bertbob has joined #gnucash
03:55:56 *** gjanssens has joined #gnucash
03:55:56 *** ChanServ sets mode: +o gjanssens
03:56:32 *** fell_laptop has quit IRC
03:59:32 <gjanssens> .
03:59:32 <gncbot> gjanssens: Sent 6 hours and 47 minutes ago: <jralls> My last push didn't go through to github so you'll need to pull from code before you can push.
04:00:05 *** warlord has joined #gnucash
04:02:00 <warlord> .
04:03:10 *** gnomey has quit IRC
04:03:17 <warlord> I am making progress on my BZ move -- I now have code that can pull down the product info, get the list of bugs, and pull down each bug, comments, history, and attachments, and then extract the users and pull the user data. Next I need to put that all together and see if it will actually write into a BZ Database.
04:05:58 <warlord> I'm going to start with a single bug and make sure that works. The downside is that I think that the migration might want to pull everything down first, process it, and the load it in a single large transaction -- I don't know how easy that will be.
04:06:19 *** gnomey has joined #gnucash
04:39:17 *** ncv has joined #gnucash
04:50:35 *** MPL_ has joined #gnucash
04:53:49 *** MPL_ has quit IRC
05:19:06 *** kus has joined #gnucash
05:26:12 *** MPL_ has joined #gnucash
05:29:28 *** MPL_ has quit IRC
05:37:07 *** fabior has joined #gnucash
05:38:23 *** warlord has quit IRC
05:40:21 <chris> Hi gjanssens
05:40:42 <chris> the reason I didn't sanitise double quote is that guile can do it automatically
05:41:15 <chris> (format #f "~a" a-string) will output a-string
05:41:29 <chris> (format #f "~s" a-string) will automatically sanitise doublequotes
05:41:51 <chris> you'll see from my chartjs I've used ~a or ~s judiciously to output (I believe) safe strings
05:42:14 <gjanssens> chris: Ok, I didn't know that.
05:43:21 <gjanssens> However I thought you sanitize function was separate from the chartjs work. That is, we need a fix for jqplot-escape-strings more urgently that we can look at chartjs
05:43:51 <gjanssens> I don't know whether the latter will eventuall end up in maint or only master
05:43:53 <chris> ok - I was think along the lines of string-sanitize and string-sanitize-and-unquote as separate functions
05:44:31 <gjanssens> Do you have examples where we need string-sanitize ?
05:45:24 <gjanssens> The jqplot labels only need doublequote escaping
05:45:47 <chris> 1) to start with, *any* report including text-reports will need sanitizing because if acct-name or trans-description contain html, it will send it raw -- this means upgrading html-style-info.scm as follows - https://imgur.com/LAGFuKu
05:45:47 <gjanssens> By the way does (format #f "~s" a-string) also sanitize a backslash ?
05:46:34 <chris> yes ~s also sanitises backslash
05:46:55 *** MPL_ has joined #gnucash
05:47:09 <gjanssens> Great.
05:47:41 <gjanssens> What am I looking at in the imgur image ?
05:47:43 <chris> in the https://imgur.com/LAGFuKu screenshot notice that the acct-name contains html and is sanitised, but the "quotes" are wrongly converted to \" by jqplot-escape-string
05:48:41 <chris> the imgur image shows the necessary change to sanitise strings; compared to the current maint behaviour https://imgur.com/a/krVR4hJ showing © in acct-name and trans-desc -> copyright symbol
05:50:06 *** MPL_ has quit IRC
05:50:19 <chris> brb dinner
05:50:42 <gjanssens> Ok
05:52:29 <gjanssens> I think the © issue has been there for a long time, right ?
05:53:21 <gjanssens> So this confirms we have different sanitizing needs for html and javascript
05:54:24 <gjanssens> I would prefer the function names to express this, like string-sanitize-html and string-sanitize-js
05:54:41 <chris> Ok
05:54:55 <gjanssens> The caller doesn't need to know the exact details, just in which context to call which function
05:56:02 <chris> btw check the https://github.com/christopherlam/gnucash/blob/master-chartjs/gnucash/report/report-system/html-chart.scm#L433 in my PR for illustrations how ~s and ~a are both used - you'll see how I deftly avoid any string-escaping or backslash in my JS builder - making this was fun
05:57:26 <chris> ^ yes © issue was there long time. currently if acct-name is "Expenses<b>one</b>" the reports currently send raw string to html
05:57:34 <chris> brb dinner, really
06:00:55 <gjanssens> For when you're back...
06:05:13 <gjanssens> string-sanitize-js will be as simple as (format #f "~s" (string-sanitize-html a-string))
06:05:40 <gjanssens> And then it's just a matter of replacing jqplot-escape-string with the proper sanitize function depending on the context in which it's called.
06:06:15 *** oozer has joined #gnucash
06:07:42 *** MPL_ has joined #gnucash
06:10:41 *** gjanssens has quit IRC
06:10:51 *** MPL_ has quit IRC
06:13:52 *** gjanssens has joined #gnucash
06:13:52 *** ChanServ sets mode: +o gjanssens
06:15:37 <gjanssens> .
06:29:21 *** kus has quit IRC
06:35:34 *** Videostar has joined #gnucash
06:38:37 <Videostar> How do I change the start date for the bank account - I'm trying to set up the complete package to begin on 1st March 2018, thanks.
06:43:07 *** Jimraehl1 has joined #gnucash
06:44:40 <gjanssens> Videostar: there is no "start date" for an account. The earliest transaction you enter will be the "start date"
06:44:49 *** Jimraehl1 has left #gnucash
06:44:59 <gjanssens> But perhaps you want to add an opening balance on March 1st ?
06:45:40 <gjanssens> An opening balance in gnucash is a transaction like any other with the transfer account set to Equity:Opening Balances
06:46:01 <gjanssens> So if you create such a transaction in your bank account register on March 1st. you should be set.
06:58:42 *** storyjesse has joined #gnucash
07:01:34 <Videostar> Yes, I wanted to enter an opening balance for March 1st but on the "Bank Accounts" tab it won't let me change today's date.
07:03:05 <gjanssens> Is this in an account register or in the Opening balance tab in the account hierarchy assistant ?
07:03:16 <gjanssens> Also which version of gnucash and on which OS ?
07:06:51 <Videostar> There are two tabs open - one simply called "accounts" which displays a list of all the accounts available (payable, receivable, current etc.) and a second tab when I clicked on "current account". It is the current account I wish to start on March 1st.
07:13:05 <Videostar> Sorry, missed the bit about OS etc. GnuCash 2.6.20 on Win XP Pro with all updates.
07:29:38 *** fabior has quit IRC
07:31:28 <Videostar> Thanks for your help, I changed to one of the "sub" accounts and was able to change the date and enter the start balance lthough it does say "imbalance" under "transfer". I assume it will all correct itself when I start to enter all the invoices (both in & out).
07:36:41 <chris> gjanssens: can't quote use straight ~s because this will always include the surrounding doublequotes. try (define s "simple-string") (format #f "a = ~a, s = ~s" s s) to understand the difference
07:40:22 <chris> we could use the ~s trick by changing the uses of jqplot-escape-string to remove the preceding and succeeding \"
07:43:33 <chris> I have now defined string-sanitize-js which I believe can be plugged instead of jqplot-escape-string directly
07:47:45 *** Aussie_matt has quit IRC
07:56:26 *** warlord has joined #gnucash
08:11:24 <gjanssens> chris: oh well, I'm glad you take care of the guile nitty-gritty details :)
08:12:09 <gjanssens> Videostar: you should not have 'Imbalance' under transfer, but "Equity:Opening Balances". You can change that yourself.
08:13:25 <gjanssens> Do you understand the details of double entry bookkeeping? Using gnucash requires this. If you don't I can recommend to read our Tutorial and Concepts guide which you'll find on our website.
08:13:39 *** boldstripe has joined #gnucash
08:19:25 *** gjanssens is now known as gjanssens_afk
08:29:20 *** MPL_ has joined #gnucash
08:32:29 *** MPL_ has quit IRC
08:37:48 *** warlord has quit IRC
09:04:57 *** MPL_ has joined #gnucash
09:08:03 *** MPL_ has quit IRC
09:08:16 *** ptoal1 has quit IRC
09:14:37 *** fabior has joined #gnucash
09:18:15 <Videostar> gjanssens : no, I don't understand double entry bookkeeping. I will wait until I have read the tutorial - many thanks.
09:25:45 *** MPL_ has joined #gnucash
09:28:49 *** MPL_ has quit IRC
09:36:41 *** Videostar has quit IRC
09:39:11 *** Videostar has joined #gnucash
09:50:05 *** MPL_ has joined #gnucash
09:53:15 *** MPL_ has quit IRC
10:00:00 *** storyjesse has quit IRC
10:03:05 *** storyjesse has joined #gnucash
10:04:28 *** ptoal1 has joined #gnucash
10:09:16 *** MPL_ has joined #gnucash
10:13:19 *** MPL_ has quit IRC
10:19:35 *** MPL_ has joined #gnucash
10:21:38 *** ptoal1 has quit IRC
10:27:03 <lmat> Oh look at that! https://i.imgur.com/idMh41f.png . ...checking... ah yes, I'm on version 3.0!
10:27:03 <gncbot> lmat: Sent 3 weeks, 2 days, 22 hours, and 55 minutes ago: <chris> sounds like a good idea which doesn't translate very well in practice lol
10:27:28 <chris> hi lmat ;)
10:28:21 <lmat> chris: yo! Rock on!
10:28:54 <lmat> oh wow, it looks a lot different, too.
10:49:43 *** gour_ has joined #gnucash
10:50:50 *** storyjesse1 has joined #gnucash
10:51:17 *** storyjesse has quit IRC
10:51:18 *** storyjesse1 is now known as storyjesse
10:51:41 *** gour has quit IRC
11:10:18 *** MPL_ has quit IRC
11:28:40 *** MPL_ has joined #gnucash
11:31:44 *** MPL_ has quit IRC
11:38:05 *** gjanssens_afk is now known as gjanssens
11:38:22 <gjanssens> Hi lmat! Enjoy the switch :)
11:38:25 *** storyjesse has quit IRC
11:38:37 <gjanssens> Your sweat is in this release as well :D
11:56:39 *** Videostar has quit IRC
11:59:32 *** MPL_ has joined #gnucash
12:10:18 *** fekepp has joined #gnucash
12:13:14 *** seanh has quit IRC
12:13:21 *** seanh has joined #gnucash
12:28:21 *** Farelli has quit IRC
12:28:37 *** Farelli has joined #gnucash
12:53:28 *** gour_ is now known as gour
12:53:33 *** fabior has quit IRC
13:02:47 *** MPL_ has quit IRC
13:04:41 *** MPL_ has joined #gnucash
13:05:07 *** jchonig has quit IRC
13:05:14 *** jchonig has joined #gnucash
13:05:29 *** boldstripe has quit IRC
13:08:25 *** ncv has quit IRC
13:28:39 *** O01eg has quit IRC
13:30:46 *** ArtGravity has joined #gnucash
13:39:14 *** O01eg has joined #gnucash
13:43:36 *** MPL_ has quit IRC
13:44:25 <lmat> gjanssens: Thanks!
13:51:07 *** MPL_ has joined #gnucash
13:59:57 *** MPL_ has quit IRC
14:08:27 *** oozer has quit IRC
14:55:35 *** frozenjim has joined #gnucash
15:00:11 <frozenjim> gjanssens Gnucash 3.0 (2018-04-01) crashes on any(?) invoice search. Do you need a report or is this part of 795031?
15:06:11 *** MPL_ has joined #gnucash
15:07:31 *** frakturfreak has joined #gnucash
15:10:49 *** frozenjim2 has joined #gnucash
15:15:33 <gjanssens> frozenjim: That's probably 795031, no need te report again
15:16:26 <frozenjim2> gjanssens: ok, thanks - for the response and for all the work you do on this.
15:17:46 <gjanssens> frozenjim2: you're welcome. jrals (currently not on irc) deserves at least as much credit though :)
15:18:22 <frozenjim2> :-) yep. I knew that as well. You guys are awesome.
15:41:15 *** oozer has joined #gnucash
15:54:27 *** gjanssens has quit IRC
15:54:29 *** tuxd00d has joined #gnucash
16:22:16 *** MPL_ has quit IRC
16:23:32 *** MPL_ has joined #gnucash
16:26:03 *** Agfarmer18 has joined #gnucash
16:27:26 *** Agfarmer18 has quit IRC
16:46:40 *** Guest56 has joined #gnucash
16:50:18 *** benoitg has joined #gnucash
17:01:55 *** frakturfreak has quit IRC
17:03:56 *** warlord has joined #gnucash
17:09:39 *** Guest56 has quit IRC
17:23:03 *** Guest56 has joined #gnucash
17:40:02 *** Mechtilde has joined #gnucash
17:40:06 *** Guest56 has quit IRC
17:47:30 *** Guest56 has joined #gnucash
17:55:35 *** ptoal1 has joined #gnucash
18:19:03 *** ptoal2 has joined #gnucash
18:19:37 *** ptoal1 has quit IRC
18:20:21 *** Mechtilde has quit IRC
18:27:33 *** gour has quit IRC
18:33:44 *** Guest56 has quit IRC
18:33:53 *** MPL_ has quit IRC
18:35:09 *** MPL_ has joined #gnucash
18:36:30 *** pilotauto has joined #gnucash
18:36:53 *** g5pw has quit IRC
18:37:12 *** g5pw has joined #gnucash
18:38:20 *** MPL_ has quit IRC
18:39:15 *** ptoal2 has quit IRC
18:46:50 *** Guest56 has joined #gnucash
18:49:54 *** MPL_ has joined #gnucash
18:59:12 *** Guest56 has quit IRC
19:18:40 *** tuxd00d has quit IRC
19:30:47 *** fell_laptop has joined #gnucash
19:31:37 *** Guest56 has joined #gnucash
19:51:00 *** Guest56 has quit IRC
20:19:06 *** ptoal2 has joined #gnucash
20:22:08 *** ptoal2 has quit IRC
20:22:21 *** ptoal2 has joined #gnucash
20:36:29 *** ptoal2 has quit IRC
20:36:54 *** ptoal2 has joined #gnucash
20:41:51 *** kus has joined #gnucash
20:48:01 *** ptoal2 has quit IRC
20:48:12 *** ptoal2 has joined #gnucash
20:48:34 *** fell_laptop has quit IRC
20:52:23 *** fell_laptop has joined #gnucash
21:01:41 *** ptoal3 has joined #gnucash
21:03:07 *** ptoal2 has quit IRC
21:06:44 *** MPL_ has quit IRC
21:08:03 *** fell_laptop has quit IRC
21:13:27 *** ptoal4 has joined #gnucash
21:14:49 *** ptoal3 has quit IRC
21:15:28 *** MPL_ has joined #gnucash
21:18:39 *** MPL_ has quit IRC
21:30:33 *** ptoal4 has quit IRC
21:44:28 *** MPL_ has joined #gnucash
21:47:39 *** MPL_ has quit IRC
21:53:23 *** oozer has quit IRC
21:56:32 *** g5pw has quit IRC
22:02:34 *** g5pw has joined #gnucash
22:11:11 *** fekepp has quit IRC
22:11:49 *** wippler has joined #gnucash
22:22:12 *** kus has quit IRC
22:35:37 *** wippler has quit IRC
22:37:32 *** Agfarmer18 has joined #gnucash
22:39:40 *** fell_laptop has joined #gnucash
22:45:05 *** PaulG has joined #gnucash
22:46:48 <PaulG> Issue with Price Editor: I have 100+ securities all set to get quotes via alphacentric. When I use the Price Editor's "Get Quotes" button it "goes away" for several minutes before reporting a non-specific "There was an error" message.
22:47:12 <PaulG> 1. Could we get a more specific error? Which security was it trying? Which source/method?
22:47:43 <PaulG> and 2. Could we get it to store/use the prices obtained up to that point? rather than discarding any progress that may have been made?
22:48:17 <PaulG> 3. Wouldn't it be nice if you could select a subset of everything and only Get-Quotes for the selection, rather than all or nothing?
22:48:32 <fell> PaulG, did you read https://wiki.gnucash.org/wiki/Online_Quotes?
22:48:50 <PaulG> not recently - let me go look at it right now.
22:49:39 <PaulG> oh, you mean the "it's external" part! :) Sorry, I totally forgot about that.
22:49:52 <PaulG> let me see if I can find the help channel for Get-Quotes
22:49:55 <PaulG> and sorry for the noise!
22:50:15 <fell> No, you are here right
22:52:04 <fell> At first, I need to know a few things like your OS, GC version...
22:52:42 <PaulG> I'm running GC 3.0+ on NetBSD-8
22:52:56 <PaulG> F::Q 1.47
22:53:25 <fell> I think, there should appear a box telling you, which quotes failed
22:54:14 <PaulG> I've seen that box before, on earlier versions of GC. Usually when I attempted to get a quote for a non-existing ticker (ie, changed).
22:54:47 <PaulG> when the ticker-specific error was given, the other results were successfully processed and added to the price db
22:54:59 <PaulG> this situation is different, with a non-specific error box
22:55:07 <fell> You entered you alphavantage key in Gnucashs Prefs?
22:55:42 <PaulG> I set the key via environment variable
22:56:57 <fell> https://code.gnucash.org/docs/C/gnucash-help/set-prefs.html#prefs-online-fig
22:58:50 <PaulG> ah, that looks new. let me try it, as soon as my previous Get-Quotes aborts (there's no abort, or cancel, capability - once you start you have to wait!)
22:59:12 <PaulG> OK, exact error message is: There was an unknown error while retrieving the price quotes.
22:59:22 <fell> File an enhancement request!
23:00:43 <fell> for the ability to abort
23:02:07 *** Agfarmer18 has quit IRC
23:02:36 <PaulG> where to file the enhancement req?
23:03:30 <fell> Is explained in https://wiki.gnucash.org/wiki/Bugzilla
23:05:04 <fell> But for your current problem, you followed alread step 3 for alphavantage in https://code.gnucash.org/docs/C/gnucash-help/fq-sources.html?
23:05:32 <fell> already
23:07:13 <PaulG> step 3 is the one about setting enviornment variable for alphavantage key - yes i did that already
23:07:47 <PaulG> this has all worked before on older gnucash version.
23:08:15 <fell> then you can run 'gnc-fq-dump -v alphavantage <Symbol>' for all your symbols to find that which fail.
23:09:14 <PaulG> is there a way to get the list of symbols?
23:09:25 <PaulG> other than manual transcription
23:09:28 <PaulG> :)
23:10:38 <fell> If you were using the xml backend you could write an XSLT to extract them. ;-)
23:11:43 <PaulG> maybe after I spent 5 years learning XML/XSLT
23:16:28 <PaulG> interestingly, I had the symbol list in a separate spreadsheet (one I maintain for my taxes) so I extracted from there.
23:16:44 <PaulG> All of the symbols pass the gnc-fq-dump command you suggested
23:19:02 <PaulG> the only symbol not tested is the one for PHP currency (Philippine Peso)
23:19:23 <PaulG> I don;'t know the symbol for that (Yahoo used to use USDPHP=X )
23:19:55 <PaulG> oh, that works too!
23:20:17 <PaulG> so now I'm totally confused. gnc-fq-dump works on everything, but online-quotes still fails
23:20:44 <PaulG> let me go back again and verify that the symbol/security list matches
23:20:54 <PaulG> thanks for your time - hopefully I won't need any more
23:22:51 <fell> The final test, is to run e.g. echo '(alphavantage "A0GFY7.SG")' | gnc-fq-helper
23:23:26 <fell> which should result in a scheme expression like (("A0GFY7.SG" (symbol . "A0GFY7.SG") (gnc:time-no-zone . "2008-09-26 16:58:00") (last . 89.50) (currency . "EUR ")))
23:24:26 <fell> In that case there was a trailing blank in the currency symbol.
23:25:04 <PaulG> hang on - I will try
23:27:16 <PaulG> hmmm if I use symbol A0GFY7.SG it returns (#f)
23:27:24 <PaulG> but it returns sane results for AAPL
23:29:38 <fell> I get errormsg: Invalid API call.from gnc-fq-dump
23:30:49 <fell> but a result for yahoo_json
23:32:00 <PaulG> is there some way I can take these "manual" results and just import them into gnucash?
23:32:27 <PaulG> I've seen hints about import/export but not been able to find anything detailed in the docs
23:34:51 <PaulG> in any case gnc-fq-helper was successful fior all my symbols
23:35:06 <fell> It seems alphavantage is missing Stuttgart Stock Exchange
23:35:46 <PaulG> oh i thought sg was singapore
23:36:03 <fell> https://code.gnucash.org/docs/C/gnucash-help/apas02.html
23:36:28 <PaulG> ah
23:37:20 <PaulG> in any case, -dump and -helper are both working fine for all the symbols I need, so now I need to verify everything in the gnucash setup to see what the heck is wrong
23:37:24 <PaulG> thanks again for the help
23:38:43 <fell> Got to the security editor, disable all and (enable one and test), ...