2023-12-07 GnuCash IRC logs

00:57:50 *** NoobAlice has quit IRC
01:34:25 *** yyoshino has quit IRC
01:35:14 *** yyoshino has joined #gnucash
01:48:07 *** fell has quit IRC
01:49:26 *** fell has joined #gnucash
01:49:27 *** ChanServ sets mode: +o fell
02:16:27 *** Aussie_matt has quit IRC
02:46:23 *** gjanssens has joined #gnucash
02:46:23 *** ChanServ sets mode: +o gjanssens
04:27:38 *** Aussie_matt has joined #gnucash
05:59:36 *** sunyibo has joined #gnucash
05:59:36 *** ChanServ sets mode: +v sunyibo
07:50:35 *** sunyibo has quit IRC
08:24:35 *** sunyibo has joined #gnucash
08:24:35 *** ChanServ sets mode: +v sunyibo
08:51:46 *** Aussie_matt has quit IRC
09:05:33 *** sunyibo has quit IRC
10:11:30 *** Rammstein has joined #gnucash
10:12:00 *** ChanServ sets mode: +v Rammstein
10:18:26 *** chris has joined #gnucash
10:18:26 *** ChanServ sets mode: +v chris
10:18:26 *** gncbot sets mode: +o chris
10:24:18 <chris> .
10:30:58 <Rammstein> I'm thinking of writing a script that can fetch transactions from an API and create it in GNU Cash (one-way sync only). Is it possible to programmatically refresh GNU Cash after a transaction is created by a script or will I need to reload the file?
10:33:00 <Simon> You can't modify the file while gnucash has it open
10:33:33 <Simon> I use the python bindings and have it retry when the file is busy
10:36:59 <Rammstein> So there's no way to actually interact with the GNU Cash UI itself (as a plugin/module), but rather just write to the file when it's not running?
10:46:47 <chris> Rammstein: some users have successfully used something like AutoHotKey (sometimes with fancy image recognition to click on toolbar icons)
10:49:36 <Rammstein> Oh, not looking to go that route. I am exploring a more elegant way to do this. I was just checking if there's a built-in way it pulls transactions from external sources so that I can possibly just emulate those APIs.
10:50:41 <chris> Make your API output CSV, and import it. The CSV importer will conveniently allow you to save column->datatype settings. It's your best bet!
10:56:58 *** palerider has joined #gnucash
10:57:07 *** palerider has left #gnucash
11:26:26 *** chris has quit IRC
12:12:16 <Simon> but you'd still need to run that importer in the GUI?
12:13:11 <Simon> you could perhaps pretend to be one of the online banking APIs that are supported but that feels like a lot more work
12:13:20 * Simon prefers these things to just happen automatically in the background
12:17:31 <Rammstein> It would've been nice if it just synced as soon as a transaction is created on the external system, but yeah, I guess I can live with just writing to the file when it's not running.
12:34:47 *** sunyibo has joined #gnucash
12:34:48 *** ChanServ sets mode: +v sunyibo
13:52:46 *** gjanssens has quit IRC
15:00:56 <Simon> you'd need something like https://wiki.gnucash.org/wiki/AqBanking and then maybe you could get it to sync when you want it to without closing GnuCash, but I've never used it
15:01:31 <Simon> and you'd need to make your own server because there are no test server implementations
15:40:46 *** sunyibo has quit IRC
15:43:15 <jralls> Unless you're using a German bank AQBanking is just another file importer, if you expand file to include OFX DirectConnect streams on the network port.
15:44:46 <Kaligula> Rammstein:
15:45:07 <Kaligula> Rammstein: I'd love to try it if it arises :D
15:52:18 <jralls> There's the Python console. It's supposed to connect to the running session.
16:25:10 *** Kaligula has quit IRC
16:36:51 *** Kaligula has joined #gnucash
16:37:03 *** ChanServ sets mode: +v Kaligula
16:37:27 <Kaligula> .
18:18:33 *** Kaligula has quit IRC
18:47:07 *** chris has joined #gnucash
18:47:07 *** ChanServ sets mode: +v chris
18:47:07 *** gncbot sets mode: +o chris
19:17:40 *** NoobAlice has joined #gnucash
19:17:40 *** ChanServ sets mode: +v NoobAlice
19:57:19 *** chris has quit IRC
20:00:02 *** raghukamath has quit IRC
20:19:16 *** raghukamath has joined #gnucash
20:19:16 *** ChanServ sets mode: +v raghukamath