2018-01-02 GnuCash IRC logs
00:19:05 *** Mechtilde has joined #gnucash
01:25:41 *** fell has quit IRC
01:26:45 *** fell has joined #gnucash
01:47:04 *** Aussie_matt has joined #gnucash
01:49:52 *** Mechtilde has quit IRC
01:54:56 *** Aussie_matt has quit IRC
02:54:32 *** jotrago has quit IRC
02:55:59 *** gnomey has quit IRC
02:57:32 *** Aussie_matt has joined #gnucash
02:58:05 *** jotrago has joined #gnucash
02:59:38 *** gnomey has joined #gnucash
04:09:17 *** fabior has joined #gnucash
04:52:30 *** dougransom has quit IRC
04:52:42 *** dougransom has joined #gnucash
05:01:52 *** chris has quit IRC
05:02:03 *** chris has joined #gnucash
05:21:59 *** fekepp has joined #gnucash
05:33:25 *** dougransom has quit IRC
05:33:36 *** dougransom has joined #gnucash
06:51:19 *** fabior has quit IRC
06:54:01 *** Mechtilde has joined #gnucash
06:55:57 *** Jimraehl1 has joined #gnucash
06:58:24 *** Jimraehl1 has quit IRC
07:02:01 *** User_ has joined #gnucash
07:02:26 *** fabior has joined #gnucash
07:08:06 *** Aussie_matt has quit IRC
07:15:25 *** fabior has quit IRC
07:15:53 *** Aussie_matt has joined #gnucash
07:19:33 *** Aussie_matt has quit IRC
07:21:46 *** User_ has quit IRC
07:22:25 *** oozer has joined #gnucash
07:29:44 *** Aussie_matt has joined #gnucash
07:29:57 *** noah has joined #gnucash
07:33:08 *** hoijui has joined #gnucash
07:37:43 *** Aussie_matt has quit IRC
07:41:56 *** oozer has quit IRC
07:49:35 <lmat> chris: I think what I need to do at this point is cherry pick all my commits onto your branch. There are lots of merge conflicts in scheme code when I try to rebase onto your branch. I'll let you know how it goes.
07:50:10 <chris> lmat agree sorry about that!
07:54:05 <lmat> chris: no worries! It looks like you got all mine anyway!
07:54:48 <lmat> chris: git diff <early commit>..<my time64-ftw> --author=lmat; and git diff <other early commit>..chris/time64-ftw --author=lmat; is the same set \o/
07:57:12 <chris> well I can't find any other scm timepairs to eradicate, so, if it's acceptable to jralls_afk / jralls then my branch could be merged... which means the new time64 API is effectively frozen for now.
07:57:33 <chris> it means you could both continue working on tp->t64 in C++
07:58:02 <chris> and when it's all complete, the TT variants could be mass-renamed
07:58:56 <chris> unless you wish to reword some of your early commits and I'll rebase onto yours again
07:59:25 <chris> all that dance only for a 2-person team :-o
08:00:57 <chris> ... for me this was interesting and I'd be keen to continue bug hunting
08:01:04 <chris> :)
08:04:47 <chris> I have to wish you luck, in comparison to scheme the C job sounds painful!
08:13:37 *** noah has quit IRC
08:31:16 <warlord> .
08:39:02 *** noah has joined #gnucash
08:40:46 *** noah has quit IRC
09:08:54 *** Aussie_matt has joined #gnucash
09:25:35 <lmat> chris: No need to reword my earlier commits.
09:27:02 *** oozer has joined #gnucash
09:27:53 *** fabior has joined #gnucash
09:29:09 <lmat> chris: Maybe create a pull request to represent this request to pull ;-)
09:29:25 <lmat> chris: Oh yeah, you're not requesting to pull. we'll keep working on C t64.
09:35:19 *** Aussie_matt has quit IRC
09:46:40 <gnomey> frozenjim: it's hard to follow what your issue is, but i'm working in multiple currencies all the time. when you say "with non-CURR expense accounts" I think that's your problem
09:47:24 <gnomey> i initially found it very aggrivating that expense accounts had to have a currency associated
09:47:57 <lmat> chris: gnucash/report/locale-specific/us/taxtxf.scm:735 uses time64?
09:47:59 <gnomey> in any case, you need a different currency account for every expense account
09:48:33 <gnomey> frozenjim: i will be interested to see the video you end up making
09:49:39 <gnomey> e.g. you would need Expense:Groceries:usd and also Expense:Groceries:cad, unfortunately
09:51:19 <gnomey> in the past I've proposed a feature whereby a child currency account would automatically be created for every expense, and then hidden from the user, which would simplify the human interface, but that didn't seem to get much notice
09:51:47 <lmat> chris: It looks like there may be a number of places where you're passing a time64 to a function that takes timespec: ./gnucash/report/locale-specific/us/taxtxf.scm:722, ./gnucash/report/standard-reports/advanced-portfolio.scm:1042 et allii.
09:52:10 *** fekepp has quit IRC
09:52:18 <lmat> chris: I swear I didn't wait for you to finish to reveal these! I'm converting gnc-pricedb timespec->time64 and coming across them
09:52:33 *** fekepp has joined #gnucash
09:53:07 <lmat> chris: I plan on fixing what I see, but I thought you would have a good idea of your thought process...I'm not sure if I should be expecting these all over the place or if it is a localized issue, etc.
09:53:34 <lmat> chris: (Of course, the fix in this case is to make the function take time64 instead of timespec which is what I was doing anyway.)
09:56:37 *** Mechtilde has quit IRC
09:58:09 *** rkninja has joined #gnucash
09:59:44 <gnomey> i associated a file and a location with a txn. Then I only have the option to "open associated file/location", and it chooses the file. How can I force it to open the location?
09:59:53 <rkninja> Hi Friends, I have gnucash 2.6.18 and it was on fc26, recently I upgraded to fc27. Now when I open the gnucash it reads the mysql db and loads the data , but when I am trying to save any transaction it throws error "Unable to save to database"
10:04:14 <rkninja> Even tried to build from scratch with latest tar 2.6.19 but got error "Package webkit-1.0 was not found in the pkg-config search path. Perhaps you should add the directory containing `webkit-1.0.pc' to the PKG_CONFIG_PATH environment variable Package 'webkit-1.0', required by 'virtual:world', not found
10:04:14 <rkninja> configure: error: Library requirements (webkit-1.0 >= "1.2") not met; consider adjusting the PKG_CONFIG_PATH environment variable if your libraries are in a nonstandard prefix so pkg-config can find them." I already have webkitgtk4.x86_64 Version 2.18.2-1.fc26 installed on my pc
10:05:55 <rkninja> @gnomey: If you are trying to open db then install libdbi & associated devel and can use mysql,pgsql etc dbs.
10:05:55 <gncbot> rkninja: Error: "gnomey:" is not a valid command.
10:27:10 *** rkninja has quit IRC
10:27:31 *** rkninja has joined #gnucash
10:32:19 *** ArtGravity has joined #gnucash
10:37:12 *** rkninja has quit IRC
10:55:46 *** kael has joined #gnucash
11:09:16 <lmat> @tell rkninja what distribution are you using?
11:09:16 <gncbot> lmat: The operation succeeded.
11:21:29 *** kael has quit IRC
11:23:40 *** pau has joined #gnucash
11:25:03 *** Mechtilde has joined #gnucash
11:26:17 <pau> Hi. I'm looking to hire someone to import GNUCash data into Quickbooks Online. I know there isn't a supported tool for this. But I'm assuming that there are some things that can be done to automate at least part of the process. I'd prefer to hire someone who has done this before.
11:27:02 *** fabior has quit IRC
11:36:25 *** jralls_afk is now known as jralls
11:37:05 <jralls> pau: You're not likely to find anyone like that here.
11:40:05 <jralls> chris: We make no representation whatever about the stability of the API--yet. We probably should, and we definitely should write up the changes we're making for both dates and numbers so that those who've custom reports or scripts will know what to do to get them to work in 3.0.
11:43:32 *** fabior has joined #gnucash
11:44:51 <jralls> lmat, chris: I think it might be a good idea to merge the time64-ftw work done so far. It's a lot easier to keep a feature branch in sync with its companion branch when one merges frequently. The only stipulation is that merging shouldn't break anything.
11:49:00 <jralls> gnomey: IIRC the attachment feature is either a file or a location, not both. But it was a drive-by contribution.
11:51:11 <jralls> @tell rkninja F27 has dropped support for WebKit1, required for GnuCash 2.6.*. The Fedora packager had said that he'd bundle it up somehow, but I don't know if he did--and if he did you'll need to do a fresh install to get it.
11:51:11 <gncbot> jralls: The operation succeeded.
11:53:30 <jralls> @tell rkninja Otherwise your choices are to switch to 2.7.3 (recognizing that it's barely-beta at this point) or to build WebKitGtk-2.4.11 from source, that being the last version that supported the WebKit1 API.
11:53:30 <gncbot> jralls: The operation succeeded.
11:59:33 *** storyjesse has quit IRC
12:16:01 *** pau has quit IRC
12:40:51 *** noah has joined #gnucash
12:43:46 *** tgunb has joined #gnucash
12:48:42 *** kael has joined #gnucash
12:54:27 <tgunb> hey, can someone point me to the chapter of the manual that explains how to close the book?
12:54:57 *** noah has quit IRC
12:56:26 *** noah has joined #gnucash
12:56:43 <warlord> tgunb: Tools -> Close Books
13:04:49 <tgunb> warlord: I know where it is, but not the idea behind it and what the fields in the popup are for.
13:09:33 <warlord> It just rolls up all your Income and Expense accounts into Equity.
13:19:00 <warlord> Do you have specific questions about the fields?
13:23:30 <tgunb> what are the second and third field for?
13:23:59 <warlord> Sorry, I don't have it in front of me -- what are the labels?
13:24:15 *** hoijui has quit IRC
13:26:18 <tgunb> income total and exponse total. seems like I have to enter an account name
13:28:49 <chris> tgunb: you specify which equity account should receive the split from Income/Expense account to close the books. Some people like to choose separate ones eg Equity:Closing Income & Closing Equity, some prefer to use the same - Equity:Closing
13:29:15 <tgunb> k
13:29:16 <chris> lmat: looks like you found funcs which I've missed somehow
13:31:35 *** tgunb has left #gnucash
13:57:35 *** oozer has quit IRC
14:04:04 <chris> lmat: well my thought process is to look for patterns of code whereby timepair was used, so I will occasionally miss some. where API was changed without renaming, I performed global grep.
14:04:45 <chris> lmat: hence I'd think it was safer to add t64 api for now and use it, and any missed timepair calls would appear when removing tp API
14:04:46 *** e-type has joined #gnucash
14:06:03 *** frakturfreak has joined #gnucash
14:06:29 <e-type> is there a difference in the date format used by stable vs dev gnucash versions?
14:07:41 <e-type> YYYYMMDDhhmmss vs YYYY-MM-DD hh:mm:ss ?
14:14:16 <warlord> e-type: the textual representation is different.
14:15:25 <warlord> the actual data is not.
14:15:29 *** noah has quit IRC
14:19:15 <e-type> and dev understands the stable format? I've suddenly some transactions that pop up with the wrong dates.
14:19:57 <e-type> 20170123105900 is translated to 13-12-17 (in DD-MM-YY format for Belgium)
14:20:08 <lmat> chris: okay, thanks
14:22:15 <warlord> e-type: 20170123105900 should be 2017-01-23 10:59:00. I don't see how it could get translated to Dec 13.
14:22:48 <warlord> I could see an off-by-one due to timezone differences.
14:22:59 <warlord> jralls: do you have any idea about e-type's issue?
14:23:58 <e-type> I'm guessing the issue is that the dev version doesn't realise it's working on a stable dateformat
14:24:18 <e-type> so my db now has mixed formats
14:24:47 <warlord> What data backend are you using?
14:24:50 <e-type> which is fine if it happens to me, but I'm guessing not all users will appreciate that too much when they upgrade :-)
14:24:53 <e-type> sqlite
14:25:24 <warlord> well, this is why we have alpha/test releases and tell users not to use it for real data. You have a backup, right?
14:25:55 <jralls> e-type: It's https://bugzilla.gnome.org/show_bug.cgi?id=792106.
14:26:44 <jralls> warlord: There's obviously a hole in detecting the old format.
14:28:15 *** fabior has quit IRC
14:29:12 <jralls> And it's related to https://bugzilla.gnome.org/show_bug.cgi?id=791848.
14:30:33 <e-type> warlord: sure, no data lost. Just checking that you guys know about it.
14:30:58 <warlord> apparently we do.
14:31:28 <e-type> yes, good :-)
14:31:32 <warlord> jralls: FYI, I was away on holiday since the 20th and just finally getting back to emails today (which is why I finally responded to your message from a couple weeks ago)
14:35:07 <e-type> jralls: I think, like you say, that the dev version doesn't handle the old format correctly, which is not part of the two bugs you sent (I think)
14:35:34 <e-type> ah, no, the first bug is on the mark
14:36:55 *** puck has quit IRC
14:38:18 <jralls> e-type: 791848 is the original report that I thought that I'd fixed. 792106 came in yesterday telling me that I hadn't.
14:38:37 <jralls> warlord: I know. How was the beach?
14:42:51 *** puck has joined #gnucash
14:45:18 *** crossan007 has quit IRC
14:45:42 *** crossan007 has joined #gnucash
14:50:30 *** User_ has joined #gnucash
14:52:57 <warlord> It was wonderful. Sad to be back.
15:02:49 *** hoijui has joined #gnucash
15:03:34 <jralls> Well, while it's great that you had a good time, we're happy that you're back.
15:07:17 *** dbear has joined #gnucash
15:09:21 <dbear> importing OFX files places the data in to the wrong 'primary' account. is there a way to specify on import what the primary account is?
15:24:16 <warlord> jralls: thanks. Working through 4300 emails.
15:25:29 <warlord> dbear: you had to have done that when you assign the OFX account to the GNC account. Did you choose the wrong account the first time?
15:26:14 <dbear> warlord: I don't remember ever being asked which account to assign the import to
15:26:30 <dbear> but then, it could have been a late night problem
15:27:08 <dbear> is there a way to 'unassign' the mapping?
15:27:33 <warlord> you need to reassign the correct account to some other OFX account and then re-run the import.
15:28:02 <dbear> where do I do that?
15:28:27 <warlord> The same way you import your existing OFX, but change it to a bogus account#
15:30:13 <dbear> file -> import -> import ofx is the menu structure, but I don't see how to change which account receives the ofx
15:32:03 <warlord> take your OFX file, change the account# in the OFX to something bogus, File -> Import -> Import OFX to the modified file, choose the account you want to reset, then you can cancel. Then import the original OFX and it will ask you for the account and this time choose the correct account.
15:33:43 <dbear> is the ACCTID number in the ofx that I modify?
15:33:52 *** e-type has quit IRC
15:33:56 <warlord> I believe so
15:34:42 <dbear> ok, I'll give it a try
15:34:44 <dbear> thanks
15:34:52 *** tuxd00d has joined #gnucash
15:35:01 <dbear> BTW, are you the same warlord that used to be active in the openafs crowd?
15:36:10 <warlord> dbear: I am
15:36:32 <dbear> cool -- do you still use openafs ? CIFS seems to have buried everything
15:36:53 <warlord> Only tangentially.
15:37:06 *** rubdos has joined #gnucash
15:37:08 <warlord> I do run a bunch of Fedora OpenAFS build slaves.
15:37:51 <dbear> wow, openafs is one of those ancient things that I have kind of good memories about
15:38:03 <warlord> :)
15:38:10 <dbear> lots of things to like about it..
15:38:12 <dbear> oh well.
15:38:22 <dbear> thanks for the suggestion
15:38:32 <dbear> will try to see how badly I can mess up my book..
15:40:44 <warlord> Make a backup first
16:01:32 *** Mechtilde has quit IRC
16:09:14 *** frakturfreak has quit IRC
16:16:12 *** frakturfreak has joined #gnucash
16:16:49 *** hoijui has quit IRC
16:21:21 *** frakturfreak has quit IRC
16:21:48 *** oozer has joined #gnucash
16:21:54 *** frakturfreak has joined #gnucash
16:32:48 *** oozer has quit IRC
16:32:52 *** User_ has quit IRC
16:34:27 *** oozer has joined #gnucash
16:45:46 *** noah has joined #gnucash
17:10:42 *** ah has joined #gnucash
17:11:56 *** ah has quit IRC
17:24:15 *** fekepp has quit IRC
17:24:53 *** fekepp has joined #gnucash
17:32:14 *** fekepp has quit IRC
17:36:26 *** fekepp has joined #gnucash
17:53:49 *** ArtGravity has quit IRC
18:08:08 *** gncbot sets mode: +o fell
18:10:01 <fell> Happy New Yerar! :-)
18:40:37 *** Aussie_matt has joined #gnucash
19:03:44 *** kael has quit IRC
20:08:23 *** noah has quit IRC
20:09:09 *** noah has joined #gnucash
20:09:40 *** Aussie_matt has quit IRC
20:12:57 *** noah has quit IRC
20:13:37 *** noah has joined #gnucash
20:20:27 <fell> Jralls, wiki:UpdateNotes is from nowhere linked.Such pages will easy fell bitrotten.
20:21:06 <jralls> fell: It's linked in the NEWS file on the website.
20:25:00 <fell> jralls: IMHO an earlier and publicer announcement of the string freeze would have helped me to finish some stuff before the release.
20:25:19 <jralls> fell: As for bit-rot, it need last only until the 3.0 release. We can use it as the basis of a "What's New in 3.0" page on the website, and then it can go away.
20:26:42 *** kael has joined #gnucash
20:27:00 <jralls> fell: Sorry, but I've been pushing gjanssens, chris, and lmat about it for most of the last month. What do you have in-process?
20:27:41 <fell> There are a bunch of translator comments in de.po
20:28:15 <fell> But after a week of working on that, I had to do something else.
20:30:22 <fell> I am usually 2 weeks at home and 2 weeks offline
20:33:20 <jralls> fell: Comments aren't a problem. They help the translator but they don't change the msgid. Go ahead and finish them up and push when you're ready.
20:34:48 <fell> It is a mixture of comments and GUI improvements, which I wrote down while translating.
20:35:20 <fell> e.g. missing accelerators in the GUI.
20:42:51 *** fbruetting has joined #gnucash
20:43:02 <jralls> Are accelerators translated? I thought that they weren't (accelerators are keyboard "hot-keys" like ctrl-c for copy).
20:44:21 <jralls> Mnemonics are part of the menu label, the underscore, so they would be included in the msgid, but it doesn't look like we use them much.
20:44:40 <fell> They change the string: "New Account" -> "_New Account"
20:44:53 *** oozer has quit IRC
20:46:55 <jralls> That's a Mnemonic. Which glade file is it in?
20:48:51 <fell> Oh, IIRC there were several. Some dialogs had duplicates, some had no accelerators, ...
20:49:16 <jralls> *mnemonics*. accelerators are different.
20:49:55 *** fbruetting has quit IRC
20:50:07 <jralls> https://developer.gnome.org/gtk3/unstable/GtkMenuItem.html#gtk-menu-item-new-with-mnemonic vs. https://developer.gnome.org/gtk3/unstable/gtk3-Keyboard-Accelerators.html
20:53:29 <jralls> If we're going to use mnemonics we should use them everywhere or nowhere. But they're very difficult to discover in Gtk3 so in spite of they're being really good for a11y they're unfortunately less helpful than they should be.
20:53:58 <jralls> oops, s/they're/their/
20:56:22 <fell> I fear, I have to read and testb the gtk3 stuff
20:57:55 <fell> But before I will finish PR #254
21:05:30 <jralls> It looks like there is *exactly one* menuitem name with an underscore in it in all of the glade files, customer_import. We don't call gtk_menu_item_new_with_mnemonic, so there aren't any created in code.
21:10:27 <jralls> Off to dinner, and away tomorrow.
21:10:30 *** jralls has quit IRC
21:47:12 *** opal has quit IRC
21:47:39 *** opal has joined #gnucash
21:49:45 *** fekepp has quit IRC
22:14:18 *** puck has quit IRC
22:15:35 *** puck has joined #gnucash
22:35:00 <fell> @tell jralls I have 34 Fixme comments in de.po, most of them affecting the sources.
22:35:00 <gncbot> fell: The operation succeeded.
22:37:52 *** kael has quit IRC
23:24:57 *** jonas has quit IRC
23:47:42 *** kael has joined #gnucash