2017-04-13 GnuCash IRC logs
00:16:24 *** kael has quit IRC
00:34:05 *** bertbob has quit IRC
00:38:42 *** bertbob has joined #gnucash
01:01:43 *** Mechtilde has joined #gnucash
01:37:45 *** fell_ has joined #gnucash
01:37:56 *** O01eg has quit IRC
01:39:35 *** fell has quit IRC
01:40:47 *** Mechtilde has quit IRC
02:30:28 *** mlncn has quit IRC
02:32:56 *** Unhammer has quit IRC
02:35:05 *** Unhammer has joined #gnucash
03:09:46 *** mrklintscher has quit IRC
03:30:29 *** mrklintscher has joined #gnucash
03:31:15 *** To7 has quit IRC
03:53:00 *** fabior has joined #gnucash
04:05:48 *** chf1 has quit IRC
04:06:46 *** chf has joined #gnucash
04:49:00 *** Artefact2 has quit IRC
04:55:26 *** Artefact2 has joined #gnucash
05:40:04 *** gr8kodr has quit IRC
05:46:18 *** gjanssens has joined #gnucash
05:46:18 *** ChanServ sets mode: +o gjanssens
06:25:08 *** fiddlerwoaroof has quit IRC
06:29:06 *** fiddlerwoaroof has joined #gnucash
06:51:27 *** chf has quit IRC
06:51:45 *** chf has joined #gnucash
07:03:11 *** Jimraehl1 has joined #gnucash
07:03:43 *** fabior has quit IRC
07:04:15 *** Jimraehl1 has left #gnucash
07:33:46 *** To7 has joined #gnucash
07:34:50 *** chf has quit IRC
07:39:11 *** chf has joined #gnucash
07:42:49 *** gjanssens has quit IRC
07:44:47 *** gjanssens has joined #gnucash
07:44:47 *** ChanServ sets mode: +o gjanssens
07:47:20 *** User_ has joined #gnucash
07:52:52 *** rickoehn has joined #gnucash
08:01:34 *** gjanssens has quit IRC
08:04:36 *** gjanssens has joined #gnucash
08:04:36 *** ChanServ sets mode: +o gjanssens
08:47:08 *** ThomasKeller has quit IRC
09:01:16 *** fabior has joined #gnucash
09:08:50 *** chf has quit IRC
09:09:40 *** chf has joined #gnucash
09:18:56 *** mlncn has joined #gnucash
09:33:23 *** chf1 has joined #gnucash
09:33:36 *** chf has quit IRC
10:07:07 *** kael has joined #gnucash
10:11:02 *** seanh has joined #gnucash
10:12:57 <seanh> Hi, am I right in thinking there's currently no way to set the transfer account when importing from CSV? That is, I have a Python script that can pre-process my CSV files and add a column to them specifying the Transfer account for each row. But then when importing the CSV into GnuCash, in the CSV transaction import wizard there's a column type for Account
10:12:57 <seanh> but none for Transfer
10:37:34 <seanh> I'm pretty sure I need to use the QIF importer instead, so off I go looking for a good way to write QIF files from Python...
10:48:26 *** Mechtilde has joined #gnucash
11:21:30 *** O01eg has joined #gnucash
11:35:41 *** chf has joined #gnucash
11:36:55 *** chf1 has quit IRC
12:46:45 *** ggherdov_ has quit IRC
12:46:57 *** ggherdov_ has joined #gnucash
13:21:36 *** mrklintscher has quit IRC
13:28:21 *** Mechtilde has quit IRC
13:51:33 <gjanssens> seanh: indeed. The current csv importer is rather limited. The next major release will come with a much improved csv importer that will allow this (amongst others)
14:01:44 *** fabior has quit IRC
14:16:01 *** frakturfreak has joined #gnucash
14:17:10 *** kael has quit IRC
14:21:43 *** mrklintscher has joined #gnucash
14:34:06 *** frakturfreak has quit IRC
14:35:28 *** frakturfreak has joined #gnucash
14:43:54 *** kael has joined #gnucash
14:43:54 *** chf has quit IRC
14:45:09 *** chf has joined #gnucash
14:52:18 *** mlncn has quit IRC
15:04:56 *** mlncn has joined #gnucash
15:11:10 <seanh> gjanssens: Cool. Currently I export CSVs from banks, run a Python script to process them (mostly assigning the transfer account: Expenses:Books etc based on the payee), and then convert the CSV to ledger format (the ledger cli accounting program). I think I may keep doing that for now, and wait until the next GnuCash comes out at which point I should be able
15:11:10 <seanh> to import my script's CSVs into GnuCash. I did look into converting the CSVs to QIF for GnuCash import but that seems to be a bit of a pain, the QIF format looks awkward and I didn't find a wonderfully quick and easy Python lib for it. Thanks
15:13:00 <gjanssens> seanh: depending on your OS you might also consider importing directly using Python
15:13:22 <gjanssens> Rather than making a detour via CSV or qif
15:13:44 <gjanssens> Gnucash has python bindings on linux.
15:26:19 <seanh> Is it fairly easy to call the gnucash bindings, in order to import transactions? (Any docs?)
15:26:25 *** gpto has joined #gnucash
15:33:12 *** chf has quit IRC
15:36:52 *** chf has joined #gnucash
15:56:07 <gpto> Anyone knows how to prevent gnucash from sorting the account names alphabetically when I open it? I have already tried disabling the "Save window size and position" check box from Edix.>Preferences->Windows but had no luck
16:19:33 <jralls> gpto: The only way is to have it sort on a different column. You can show more columns by clicking on the green arrow at the right side of the column headers. Once you've set the sort order you can hide the column again.
16:21:06 <jralls> gpto: Beware that any sort that doesn't reflect the hierarchy will look strange and be hard to use.
16:22:22 <jralls> gpto: I suggest assigning codes to each account in a sensible numbering system so that the codes reflect the structure. E.g. 1000 is Assets, 1100 is Assets:Current, etc.
16:37:41 <gjanssens> seanh: There's not much documentation unfortunately. There are a couple of example scripts that may get you going: https://github.com/Gnucash/gnucash/tree/master/src/optional/python-bindings/example_scripts
16:38:30 *** gjanssens has quit IRC
17:04:33 *** User_ has quit IRC
17:38:04 *** User_ has joined #gnucash
17:47:50 *** User_ has quit IRC
17:51:38 *** rickoehn has quit IRC
17:51:48 *** kael has quit IRC
18:00:53 *** kael has joined #gnucash
18:07:04 *** User_ has joined #gnucash
18:07:13 *** mlncn has quit IRC
18:09:15 *** chf has quit IRC
18:09:19 *** chf has joined #gnucash
18:26:48 *** mlncn has joined #gnucash
18:41:49 *** User_ has quit IRC
18:43:30 *** mlncn has quit IRC
18:59:04 *** mlncn has joined #gnucash
19:02:55 *** User_ has joined #gnucash
19:05:39 *** frakturfreak has quit IRC
19:07:47 *** User_ has quit IRC
19:21:41 *** User_ has joined #gnucash
19:23:21 *** fell_ is now known as fell
19:23:35 *** gncbot sets mode: +o fell
19:36:33 *** jonas_ has quit IRC
19:36:46 *** jonas_ has joined #gnucash
19:38:23 *** kael has quit IRC
19:47:16 *** chf1 has joined #gnucash
19:47:17 *** chf has quit IRC
20:04:59 *** mlncn has quit IRC
20:15:56 *** warlord has joined #gnucash
20:15:56 *** gncbot sets mode: +o warlord
20:18:09 <warlord> .
20:25:46 *** pwnguin has left #gnucash
20:57:58 *** warlord has quit IRC
20:58:45 *** User_ has quit IRC
21:05:46 *** bertbob has quit IRC
21:23:55 *** chf1 has quit IRC
21:27:07 *** chf has joined #gnucash
22:25:17 *** bertbob has joined #gnucash
22:51:55 *** kael has joined #gnucash
23:11:02 *** kael has quit IRC
23:40:49 *** CDB-Man has quit IRC
23:49:33 *** chf has quit IRC
23:50:37 *** chf has joined #gnucash