2021-02-09 GnuCash IRC logs

00:24:27 *** jervin has joined #gnucash
00:41:53 *** o01eg has quit IRC
01:12:41 *** Mechtilde has joined #gnucash
01:16:11 *** fell has quit IRC
01:17:30 *** fell has joined #gnucash
01:17:30 *** ChanServ sets mode: +o fell
01:28:12 *** sbluhm has joined #gnucash
01:28:12 *** ChanServ sets mode: +v sbluhm
01:52:46 *** frakturfreak has quit IRC
02:07:11 *** frakturfreak has joined #gnucash
02:09:42 *** Aussie_matt has quit IRC
02:24:11 *** jervin has quit IRC
02:33:37 *** AdrienM has quit IRC
02:34:23 *** AdrienM has joined #gnucash
02:34:23 *** ChanServ sets mode: +v AdrienM
02:36:53 *** David has quit IRC
02:37:07 *** David has joined #gnucash
02:37:58 *** Mechtilde has quit IRC
03:24:08 *** jervin has joined #gnucash
03:24:51 *** jervin has quit IRC
03:53:57 *** bertbob has quit IRC
03:54:27 *** gjanssens has joined #gnucash
03:54:27 *** ChanServ sets mode: +o gjanssens
03:56:50 *** bertbob has joined #gnucash
03:56:50 *** ChanServ sets mode: +v bertbob
04:02:32 *** mikee_ has quit IRC
04:16:04 *** Mechtilde has joined #gnucash
04:18:34 *** David has quit IRC
04:18:48 *** David has joined #gnucash
04:29:09 *** bertbob has quit IRC
04:30:17 <gjanssens> .
04:37:35 *** bertbob has joined #gnucash
04:37:35 *** ChanServ sets mode: +v bertbob
05:07:06 *** sparrohawk has quit IRC
05:07:32 *** mikee has joined #gnucash
05:16:30 *** field^Mop has joined #gnucash
05:31:56 *** Aussie_matt has joined #gnucash
05:46:18 *** o01eg has joined #gnucash
06:23:09 *** User_ has joined #gnucash
06:23:45 *** qwer has joined #gnucash
06:37:50 *** User_ has quit IRC
07:22:42 *** qwer has quit IRC
07:39:18 <warlord> .
07:39:30 *** ChanServ sets mode: +qo warlord warlord
07:39:33 *** warlord sets mode: +o gncbot
07:43:33 *** qwer has joined #gnucash
07:45:41 *** mikee has quit IRC
07:45:51 *** mikee has joined #gnucash
07:45:52 *** gncbot sets mode: +o mikee
07:46:43 *** qwer has quit IRC
07:59:23 *** Aussie_matt has quit IRC
08:00:29 *** mydogsnameisrudy has joined #gnucash
08:01:28 <gjanssens> fell: I have gone through the wiki and have made some updates. I think I have added cmake updates to the most important pages now. I have also updated the README file in the gnucash-docs repo.
08:06:38 *** mydogsnameisrudy has quit IRC
08:17:19 *** nathan has joined #gnucash
08:17:57 <nathan> good morning I have a question about how to use the security price database to fetch price quotes for mutual funds
08:23:00 <nathan> I have no issues fetching prices for single stocks. I added a mutual fund and I get this error message, for only the mutual fund:
08:23:04 <nathan> https://imagebin.ca/v/5rAUP6maSz3h
08:25:57 *** sbluhm has quit IRC
08:46:52 *** kalpu has joined #gnucash
08:49:44 <kalpu> Ahoj, here in germany I tested gnucash (debian stable version) with skr04 and I'm a bit irritated because the Balance-Sheet (Bilanz) seems wrong: "Gezeichnetes Kapital" (issued capital) gets listed under "Liabilities" but it should be under "Equitiy". Any ideas?
08:57:49 *** Jimraehl1 has joined #gnucash
08:58:40 *** Jimraehl1 has quit IRC
09:06:57 <warlord> nathan, probably because your chosen quote source is invalid? Try using gnc-fq-dump and see if it works there?
09:07:41 <warlord> nathan, yahoo_json source works fine for me
09:08:07 <nathan> ok. I had been using alphavantage. I will try that.
09:09:02 <nathan> if it helps, here is the properties view for the mutual fund. I wondered if it makes a difference whether it is listed as FUND or NASDAQ
09:09:05 <nathan> v
09:09:09 <nathan> https://imagebin.ca/v/5rAiJSFXFtD4
09:10:34 <warlord> No, that shouldn't matter. It's all about the quote source.
09:10:56 <nathan> ok I could not find gnc-fq-dump so I used yahoo as json and it worked.
09:11:15 <nathan> thank you, have a great day
09:11:18 <warlord> You're welcome
09:11:27 <warlord> looks like you had been using AlphaVantage.
09:11:35 <nathan> yes
09:11:40 <warlord> I don't have an AV key myself, so I only use YahooJSON
09:11:46 <warlord> It works for MOST of my quotes.
09:12:02 <nathan> gtk for future ref.
09:13:46 <warlord> Enjoy. Happy Gnucashing
09:14:23 *** nathan has quit IRC
09:57:11 *** mikey has quit IRC
10:06:55 *** lmat has quit IRC
10:18:15 <kalpu> Ahoj, here in germany I tested gnucash (debian stable version) with skr04 and I'm a bit irritated because the Balance-Sheet (Bilanz) seems wrong: "Gezeichnetes Kapital" (issued capital) gets listed under "Liabilities" but it should be under "Equitiy". Any ideas?
10:26:12 *** truelehr has joined #gnucash
10:27:55 <warlord> kalpu, we saw you question the first time. I suggest you ask your question either on gnucash-user or gnucash-de
10:30:53 *** truelehr has left #gnucash
10:32:27 *** Mechtilde has quit IRC
10:34:56 *** storyjesse has quit IRC
10:39:36 *** Pegasus_RPG has quit IRC
10:44:33 *** jcarl43 has joined #gnucash
10:44:33 *** ChanServ sets mode: +v jcarl43
10:48:02 *** guak has joined #gnucash
10:52:49 *** AdrienM has quit IRC
10:52:55 *** AdrienM has joined #gnucash
10:52:55 *** ChanServ sets mode: +v AdrienM
10:55:22 *** ArtGravity has joined #gnucash
10:55:22 *** ChanServ sets mode: +v ArtGravity
11:01:04 *** Pegasus_RPG has joined #gnucash
11:19:28 *** jervin has joined #gnucash
11:30:13 <fell> kalpu: The reason is https://bugs.gnucash.org/show_bug.cgi?id=421766
11:33:11 <fell> and at that time liability was translated with "Passive" in de.
11:34:05 <fell> warlord: gnucash-user can not help in such questions.
11:48:49 *** lmat has joined #gnucash
11:58:15 *** Mechtilde has joined #gnucash
12:02:23 *** Mechtilde has joined #gnucash
12:09:07 *** Mechtilde has quit IRC
12:12:22 *** Mechtilde has joined #gnucash
12:44:17 <kalpu> fell: Wow, this blows! So since 2007 (or even before) there is no realworld usage of gnucash for small/mid companies in germany (skr04)? ... Is there anything I can do?
12:44:24 *** angel has joined #gnucash
12:53:19 *** jervin has quit IRC
13:00:54 *** jervin has joined #gnucash
13:06:29 *** angel has quit IRC
13:07:44 *** gjanssens has quit IRC
13:20:50 *** halipaul has joined #gnucash
13:28:35 *** frakturfreak has quit IRC
13:29:39 *** frakturfreak has joined #gnucash
13:29:39 *** ChanServ sets mode: +v frakturfreak
13:32:25 <fell> I had expanded a stub in 2005, announced it on gnucash-de but only a few years later it became an official part. But in between i had other priorities. Further developement of the templates should be discussed on gnucash-de perhaps with drafts in the wiki.
13:34:28 <fell> I do not think, it is useless. At least I used it several years.I see the issue more as cosmetic.
13:35:23 <fell> kalpu, if you like, fix the bug.
13:36:16 <fell> I iknow also the other template authors would be happy.
13:50:13 *** jervin has quit IRC
13:50:57 *** jervin has joined #gnucash
13:51:07 *** jervin has quit IRC
14:34:28 <fell> Has someone an Idea, from where https://hosted.weblate.org/projects/gnucash/glossary-1/ is?
14:36:18 <fell> I suspect Milo behind it.
14:52:59 *** Agfarmer18 has joined #gnucash
15:28:48 <jralls> Or kingu. I don't understand why you granted either of them admin.
15:29:49 <jralls> If glossary-1 just appeared, it's kingu. milotype hasn't been on for almost a week.
15:30:01 *** halipaul has quit IRC
15:32:04 <jralls> Hmm, maybe that's not true. It says your last login was a month ago, so I guess it can't tell if you're always logged in.
15:40:00 *** hannes1 has joined #gnucash
15:47:29 *** hannes1 has quit IRC
15:53:15 *** Mechtilde has quit IRC
15:55:33 *** hannes1 has joined #gnucash
15:57:08 <hannes1> Hello, I have following problem: When I'm importing the csv-file I would like to have the rows to be imported in the same order as they are in the csv-file, but this is not the case.
15:58:38 *** hannes1 has quit IRC
16:01:34 <warlord> @tell hannes1 what do you mean "rows .. imported in the same order"? Are these transactions or splits? GnuCash will sort transactions by its own way, and splits within a transaction get sorted debits then credits in the order created. However it is certainly possible the importer uses a more arbitrary order.
16:01:34 <gncbot> warlord: The operation succeeded.
16:01:34 *** jw4 has quit IRC
16:03:00 *** jw4 has joined #gnucash
16:07:34 <kalpu> fell: Thanks for the input.
16:07:49 *** kalpu has quit IRC
16:09:17 *** twanny796 has quit IRC
16:10:47 *** hannes1 has joined #gnucash
16:11:12 <hannes1> Hello, I have following problem: When I'm importing the csv-file I would like to have the rows to be imported in the same order as they are in the csv-file, but this is not the case.
16:11:12 <gncbot> hannes1: Sent 9 minutes ago: <warlord> what do you mean rows .. imported in the same order ? Are these transactions or splits? GnuCash will sort transactions by its own way, and splits within a transaction get sorted debits then credits in the order created. However it is certainly possible the importer uses a more arbitrary order.
16:12:19 <hannes1> yes, it is about transactions
16:17:34 <hannes1> Is there a way that gnucash imports the transactions in the same order as they are in the csv-file?
16:18:31 *** hannes1 has quit IRC
16:20:41 *** hannes2 has joined #gnucash
16:21:03 *** hannes2 has left #gnucash
16:21:29 *** hannes1 has joined #gnucash
16:23:12 <fell> Hannes1 has its internal sort order, but perhaps a transaction report sortded by date entered could help you.
16:24:55 <hannes1> the problem is that there are usually several transaction with the same date and gnucash sorts them differently
16:27:26 <jralls> There are two dates, one visible (posted), one not (entered). Posted has 1-day resolution, entered has 1-second. Date entered is the 3rd sort criterion after date posted and number.
16:28:00 <jralls> When you import GnuCash is able to process a lot of transactions in 1 second so they all get the same date entered timestamp.
16:30:07 <hannes1> jralls: than its maybe the best to add an additional column with number in my csv-file
16:32:16 <jralls> The fourth sort key is the description and the fifth is GUID, which is effectively random for this purpose. So you could add a number column or you could fudge the descriptions.
16:37:59 *** Agfarmer18 has quit IRC
16:43:43 <hannes1> jralls: hm, I tried now with date and number, but number seams not to be the 2nd sort criterion
16:48:45 <hannes1> sorry this was my fault, exchanged increasing and decreasing. This workaround works fine. thanks!
16:51:16 *** David has quit IRC
16:51:30 *** David has joined #gnucash
16:58:04 *** hannes1 has quit IRC
16:58:59 *** Agfarmer18 has joined #gnucash
17:06:47 *** Agfarmer18 has quit IRC
17:08:51 *** Aussie_matt has joined #gnucash
17:18:08 *** mikey has joined #gnucash
17:18:08 *** ChanServ sets mode: +v mikey
18:26:44 <fell> chhris,https://code.gnucash.org/builds/win32/build-logs/maint/2021-02/build-maint-2021-02-09-03-01-03.log:
18:26:54 <fell> FAILED: lib/guile/2.2/site-ccache/gnucash/locale/de_DE/tax/txf.go
18:27:06 <fell> FAILED: lib/guile/2.2/site-ccache/gnucash/locale/us/tax/txf.go
18:29:22 <jralls> minus the ':'.
18:30:16 <fell> chris ^
18:30:38 <jralls> Not Chris's fault. Copying the scm files didn't work again.
18:32:57 <fell> Disk full again?
18:35:23 <jralls> No, something
18:38:56 <jralls> about the way CMake creates them at configure instead of as targets for Ninja to create. Cmake creates the copies and then ninja cleans the directory, removing them.
18:45:31 *** TownsendHardware has quit IRC
19:07:03 <jralls> fell, I surprised you haven't pestered me about Gwenhywfar-5.5.0. ;-) After making the update in flatpack I thought to check if org.gnucash.flatpak was up to date. It was quite a bit behind, so I diffed the whole modules dir between the two. There are a lot of differences. Should there be?
19:07:54 <fell> let me see …
19:08:42 <fell> I had not seen it
19:11:38 <jralls> There's a mistake in src/os/windows.gwenthread.c, though.
19:15:23 <chris> jralls: from your profiling what is exactly the holdup in loading/saving datafile?
19:16:16 <jralls> chris, a little more context?
19:16:31 <chris> why datafile load takes 1min for you?
19:18:03 <jralls> Because engine uses a zillion linked lists. Because the SQL backend communicates with the engine using GObject Properties. Because doing those two very slow things 100 bytes at a time 550 thousand times takes a while.
19:19:23 <chris> and both are obsolete data structures?
19:20:57 <jralls> GObject Properties allocate-and-copy at least 4 times for every assignment and retrieval. It helps a bit that they use gslice instead of going to the OS for those allocs, but it's still a lot slower than a direct memory write.
19:24:13 <jralls> Linked lists aren't obsolete per se, but they don't scale well because there's no indexed access and in the case of GLists they're double-allocated, meaning that the list node is separate from the actual data. That makes it darn near impossible for the CPU to efficiently cache one for fast access.
19:28:29 *** bertbob has quit IRC
19:28:29 <fell> @tell gjanssens Nice work, thank you! Nitpick. in gnucash-docs/README I had preferred cmake before autotools.
19:28:30 <gncbot> fell: The operation succeeded.
19:29:31 <chris> would be a major hurdle to convert Account.cpp to std::vector ?
19:30:16 <chris> xaccAccountGetSplitList would need to change slightly
19:31:55 <chris> gtg...
19:31:55 *** bertbob has joined #gnucash
19:31:55 *** ChanServ sets mode: +v bertbob
19:32:25 <jralls> It's consumed in a lot of places so you'd wind up either converting all of those places to c++ or writing a shim that copied the vector to a list, which would be even slower.
19:39:26 <jralls> fell, updating gwen on Windows will have to wait a couple of days, there's more than the one build problem. I guess Martin didn't test on Windows.
19:39:30 <jralls> I
19:39:51 <jralls> I've filed https://www.aquamaniac.de/rdm/issues/230 for the first one.
19:40:24 <fell> commit 648b6df: OS: Added first thread implementation for Windows (not tested, yet).
19:41:26 <jralls> But there's more and I'm out of time for tonight.
19:41:43 *** jralls is now known as jralls_afk
20:04:32 *** jcarl43 has quit IRC
20:58:19 *** TownsendHardware has joined #gnucash
21:02:30 *** field^Mop has quit IRC
21:23:37 *** mikey has quit IRC
21:25:56 *** chf has quit IRC
21:33:56 *** mikey has joined #gnucash
21:33:56 *** ChanServ sets mode: +v mikey
21:49:46 *** linas has joined #gnucash
22:07:21 *** chf has joined #gnucash
22:17:42 *** guak has quit IRC
22:20:07 *** ArtGravity has quit IRC
22:21:09 *** FH_thecat has joined #gnucash
22:24:10 *** FH_thecat has quit IRC
22:54:57 *** jervin has joined #gnucash
23:44:21 *** jervin has quit IRC