2023-12-03 GnuCash IRC logs
01:17:48 *** NoobAlice has quit IRC
01:49:11 *** chris has quit IRC
01:51:48 *** fell has quit IRC
01:53:07 *** fell has joined #gnucash
01:53:07 *** ChanServ sets mode: +o fell
02:04:50 *** chris has joined #gnucash
02:04:50 *** ChanServ sets mode: +v chris
02:04:50 *** gncbot sets mode: +o chris
02:59:49 *** chris has quit IRC
03:34:00 *** Aussie_matt has quit IRC
03:34:04 *** Aussie_matt has joined #gnucash
04:29:42 *** chris has joined #gnucash
04:29:43 *** ChanServ sets mode: +v chris
04:29:43 *** gncbot sets mode: +o chris
05:10:36 *** chris has quit IRC
06:52:31 *** Kaligula has joined #gnucash
06:52:43 *** ChanServ sets mode: +v Kaligula
06:54:02 <Kaligula> Is there a way to export prices from GnuCash? I know I can import, and I'd like to use it.
06:54:26 <Simon> you could use the python API
06:54:35 <Kaligula> I need to export all my prices (which are in USD), convert them all to my native currency and import.
06:54:39 <Simon> https://github.com/nomis/gnucash-prices
06:54:54 <Kaligula> Oh, thanks! I'll take a look at it.
06:55:03 <Simon> you could also parse the XML file or read them out of the database directly
06:55:42 <Kaligula> I thought the only way is to open *.gnucash file in text editor and do sth like parse XML tags to CSV, use Excel to convert prices and parse CSV to XML…
06:56:05 <Kaligula> Oh, it seems we wrote about the same way ;)
06:56:11 <Simon> this really depends on how often you want to do it
06:56:18 <Kaligula> Once in a lifetime.
06:56:59 <Simon> if there may be more prices in the future you'd want to repeat the process, so reading it directly with python would be easier
06:58:17 <Simon> get_prices() returns a sorted list of all the prices
06:58:38 <Kaligula> I can take care of future prices (wrote myself a F::Q module to get prices the way I want), so I really believe this will be the only time I need it :D
06:59:04 <Kaligula> But I don't know Python. The description page says it's used for updating, checking or removing prices.
06:59:28 <Simon> you'd need to use it as an example of how to access all prices in the GnuCash file
06:59:52 <Kaligula> Is there any help included whe you run the Python file/script?
07:00:43 <Simon> it has a --help but it's not going to do what you want directly
07:01:12 <Kaligula> ah
07:01:33 <Simon> it's mostly replicating the GnuCash price db update process, but avoids retreiving prices when there's already a price for the most recent financial day
07:01:39 <Kaligula> Thank, I'll try it :)
07:01:39 <Kaligula> Later, now I don't have much time.
07:01:46 <Simon> and bypassing F::Q for currency because the F::Q API for currency doesn't tell you the date
07:02:20 <Kaligula> Thank you for help. Have a nice day :)
07:29:05 *** CWehli has joined #gnucash
08:28:17 *** chris has joined #gnucash
08:28:17 *** ChanServ sets mode: +v chris
08:28:17 *** gncbot sets mode: +o chris
08:30:10 *** CWehli has quit IRC
08:56:21 *** chris has quit IRC
09:54:06 *** DemonicSavage has quit IRC
09:55:06 *** DemonicSavage has joined #gnucash
09:55:07 *** ChanServ sets mode: +v DemonicSavage
10:00:28 *** NoobAlice has joined #gnucash
10:00:29 *** ChanServ sets mode: +v NoobAlice
10:35:13 *** palerider has joined #gnucash
10:36:34 *** palerider has left #gnucash
10:39:16 *** DemonicSavage has quit IRC
10:40:37 *** DemonicSavage has joined #gnucash
10:40:37 *** ChanServ sets mode: +v DemonicSavage
10:45:37 *** DemonicSavage has quit IRC
10:46:59 *** DemonicSavage has joined #gnucash
10:46:59 *** ChanServ sets mode: +v DemonicSavage
11:03:50 *** sabine has joined #gnucash
11:04:14 *** sabine has quit IRC
11:04:39 *** sabine has joined #gnucash
11:28:35 *** sabine has quit IRC
13:29:07 *** AdrienM has joined #gnucash
13:29:07 *** ChanServ sets mode: +v AdrienM
13:29:36 *** AdrienM_ has quit IRC
15:32:05 *** giuseppef has quit IRC
18:09:03 *** bertbob has quit IRC
18:13:46 *** bertbob has joined #gnucash
18:13:46 *** ChanServ sets mode: +v bertbob
18:51:15 *** keith has joined #gnucash
18:58:22 *** keith is now known as debian-gnucash-user
19:07:32 *** debian-gnucash-user has left #gnucash
19:11:09 *** debian-gnucash-user has joined #gnucash
19:11:38 *** debian-gnucash-user has left #gnucash
19:46:27 *** chris has joined #gnucash
19:46:27 *** ChanServ sets mode: +v chris
19:46:28 *** gncbot sets mode: +o chris
20:00:02 *** raghukamath has quit IRC
20:20:04 *** raghukamath has joined #gnucash
20:20:05 *** ChanServ sets mode: +v raghukamath
20:20:53 *** debian_gc_user2 has joined #gnucash
20:21:54 *** debian_gc_user2 has left #gnucash
20:24:52 *** debian_gc_user has joined #gnucash
20:25:19 *** debian_gc_user has left #gnucash
20:26:36 *** debian_gc_user has joined #gnucash
20:26:36 *** ChanServ sets mode: +v debian_gc_user
20:29:17 <debian_gc_user> Hi! After upgrading to Debian's 5.4-2 I'm getting a crash while loading data:
20:29:17 <debian_gc_user> "ERROR: In procedure string->number: Value out of range: 85262" in read.scm.
20:29:17 <debian_gc_user> I tried to debug, and it seems it's doing a string->number on a guid of the bayesian matches for transactions import: <slot:key>import-map-bayes/#117/1754e85262f16aa77c4362e71f1aa1ee</slot:key>
20:31:27 *** chris has quit IRC
22:01:49 *** chris has joined #gnucash
22:01:50 *** ChanServ sets mode: +v chris
22:01:50 *** gncbot sets mode: +o chris
23:17:54 <debian_gc_user> Fixed my problem... for the record: in my .local/share/gnucash/books/Accounts.gnucash.gcm, I had pages open with reports involving the account which guid includes the digits in the error message. I edited them out of the gcm file, and now all seems fine!
23:32:54 *** NoobAlice has quit IRC
23:37:50 *** chris has quit IRC