2021-07-27 GnuCash IRC logs
01:10:42 *** marusich has joined #gnucash
01:10:42 *** ChanServ sets mode: +v marusich
01:37:39 *** Mechtilde has quit IRC
01:38:04 *** frakturfreak has quit IRC
01:45:45 *** fell has quit IRC
01:46:33 *** fell has joined #gnucash
01:46:34 *** ChanServ sets mode: +o fell
01:50:05 *** sbluhm has joined #gnucash
01:52:08 *** frakturfreak has joined #gnucash
02:29:26 *** chris_ has joined #gnucash
02:29:26 *** gncbot sets mode: +o chris_
02:30:55 *** chris has quit IRC
03:18:06 *** chris_ is now known as chris
03:42:39 *** Mechtilde has joined #gnucash
04:29:50 *** Hamaryns has joined #gnucash
04:29:50 *** ChanServ sets mode: +v Hamaryns
04:46:41 *** User has joined #gnucash
04:49:58 *** thechitowncubs has joined #gnucash
04:49:58 *** ChanServ sets mode: +v thechitowncubs
05:44:07 *** Hamaryns has quit IRC
05:45:21 *** Hamaryns has joined #gnucash
05:45:21 *** ChanServ sets mode: +v Hamaryns
06:00:03 *** chf has quit IRC
06:00:32 *** chf has joined #gnucash
06:05:12 *** Aussie_matt has joined #gnucash
06:18:45 *** Mechtilde has quit IRC
06:24:34 *** Mechtilde has joined #gnucash
06:26:02 *** chf has quit IRC
06:26:19 *** chf has joined #gnucash
06:56:53 *** Mechtilde_ has joined #gnucash
06:58:46 *** Mechtilde has quit IRC
07:01:40 *** Hamaryns has quit IRC
07:09:04 *** marusich has quit IRC
07:11:30 *** chris_ has joined #gnucash
07:11:30 *** gncbot sets mode: +o chris_
07:13:00 *** chris has quit IRC
07:22:08 *** marusich has joined #gnucash
07:22:08 *** ChanServ sets mode: +v marusich
07:29:41 *** mydogsnameisrudy has joined #gnucash
07:33:38 *** mydogsnameisrudy has quit IRC
07:43:03 *** Hamaryns has joined #gnucash
07:43:03 *** ChanServ sets mode: +v Hamaryns
08:09:55 *** Hamaryns has quit IRC
08:16:49 *** Hamaryns has joined #gnucash
08:16:49 *** ChanServ sets mode: +v Hamaryns
08:25:52 *** qwer has quit IRC
08:39:58 *** Jimraehl1 has joined #gnucash
08:40:36 *** Jimraehl1 has quit IRC
08:45:57 *** qwer has joined #gnucash
08:53:36 *** Mechtilde_ has quit IRC
08:54:06 *** Mechtilde has joined #gnucash
08:58:27 *** Mechtilde has quit IRC
09:08:49 *** Hamaryns has quit IRC
09:45:00 *** Aussie_matt has quit IRC
10:11:09 *** Hamaryns has joined #gnucash
10:11:09 *** ChanServ sets mode: +v Hamaryns
10:23:28 *** Hamaryns has quit IRC
10:26:38 *** NoobAlice has joined #gnucash
10:27:33 *** marusich has quit IRC
10:31:05 *** marusich has joined #gnucash
10:31:05 *** ChanServ sets mode: +v marusich
10:34:43 *** Hamaryns has joined #gnucash
10:34:43 *** ChanServ sets mode: +v Hamaryns
10:45:36 *** sbluhm has quit IRC
10:59:47 *** KevinDB has quit IRC
10:59:57 *** KevinDB has joined #gnucash
10:59:57 *** ChanServ sets mode: +v KevinDB
11:02:26 *** sbluhm has joined #gnucash
11:11:29 *** chf has quit IRC
11:12:50 *** chf has joined #gnucash
11:17:25 *** sbluhm has quit IRC
11:23:03 *** Mechtilde has joined #gnucash
11:36:24 *** guak has joined #gnucash
12:19:51 *** Hamaryns has quit IRC
12:23:28 <warlord> .
13:02:32 *** kcin has joined #gnucash
13:48:49 *** Pegasus_RPG has joined #gnucash
14:30:58 *** sbluhm has joined #gnucash
15:10:29 *** Pegasus_RPG has quit IRC
15:24:54 *** Mechtilde has quit IRC
15:54:29 *** NoobAlice1 has joined #gnucash
15:55:07 *** NoobAlice has quit IRC
16:20:56 *** thechitowncubs has quit IRC
16:21:58 *** sbluhm has quit IRC
16:26:12 *** kcin has quit IRC
16:48:04 *** User has quit IRC
17:22:25 *** accuser has joined #gnucash
17:23:19 *** ChanServ sets mode: +v accuser
17:23:30 *** accuser has left #gnucash
17:23:35 *** accuser has joined #gnucash
17:23:35 *** ChanServ sets mode: +v accuser
17:23:41 <accuser> hi
17:24:38 <accuser> i have a CSV file with the following data: Date, Description, Shares amount and USD price paid for each share
17:26:03 <accuser> i also have an account for these stocks, and another USD account i want to credit for those shares at the rate specified in the CSV
17:27:01 <accuser> how can i import these transactions from the CSV file correctly?
17:30:23 <jralls> accuser, I doubt that you can. Multi-commodity importing from CSV doesn't work very well.
17:32:00 <accuser> jralls: i can but it debits the same amount in shares that credits in the USD account, which is wrong. tried to add another column with the exchange rate and select it as "price" but doesn't seems to have any effect.
17:32:37 <jralls> So you can't, because you specified "correctly" and it isn't importing correctly.
17:35:32 <accuser> that's a pity. i'll see if i can do something to implement this.
17:39:55 *** mydogsnameisrudy has joined #gnucash
17:41:48 *** mydogsnameisrudy has quit IRC
17:55:38 *** thechitowncubs has joined #gnucash
17:55:38 *** ChanServ sets mode: +v thechitowncubs
17:59:05 *** marusich has quit IRC
18:10:41 <jralls> accuser there are several csv->OFX and csv->QIF tools out there. Several users over the years have reported success using one and importing the resulting file into GnuCash.
18:13:10 <accuser> jralls thanks, i'll take a look. for the moment i'm reading the python bindings docs and see if i can write something to import my transactions
18:20:24 <accuser> "Python bindings have been added to gnucash in 2008 or earlier. There is still very little documentation and probably few people would know how to use it. "
18:20:29 <accuser> great haha
18:27:41 *** jervin has quit IRC
18:28:46 *** NoobAlice1 is now known as NoobAlice
18:28:59 *** ChanServ sets mode: +v NoobAlice
18:29:10 <NoobAlice> accuser: I think there has been some mailing list discussion about this topic fairly recently. Here's a searchable archive of the mailing list: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
18:35:28 <accuser> NoobAlice related to my problem or about the python bindings lack of docs?
18:36:08 *** guak1 has joined #gnucash
18:36:35 *** guak has quit IRC
18:36:35 *** guak1 is now known as guak
18:37:09 <NoobAlice> About importing CSV/CSV converted to QIF and about python bindings, but possibly not together. I just recall seeing similar types of discussion recently.
18:38:42 <accuser> i'll take a look. but fortunately i found a python lib called piecash which looks very promising
18:38:59 <NoobAlice> Haha, that's been in the mailing list recently, too. :)
18:41:15 <NoobAlice> Linked in a recent thread, this *might* help, but I have no experience with it, just saw it: http://gnucash.1415818.n4.nabble.com/GNC-Tracking-cash-flows-with-balanced-transactions-td4721056.html
18:45:51 <NoobAlice> ...also, I am just a noob user, and jralls is an actual dev, so his advice is best.
18:55:19 <accuser> i only have the option for saving with XML format, i don't have SQLITE or POSTGRESS as i can see in the docs. should i install something to enable support for this?
19:14:54 <NoobAlice> accuser: On my distro, libdbi-drivers for saving in SQL-type formats is an optional dependency.
19:15:53 <accuser> NoobAlice which distro is it? i'm on debian
19:16:16 <NoobAlice> Arch. It looks like Debian has it under the same name.
19:16:24 <NoobAlice> https://repology.org/project/libdbi-drivers/versions
19:18:48 <NoobAlice> Oh wait, there's a list? https://packages.debian.org/stable/source/libdbi-drivers
19:18:59 <NoobAlice> Sorry, I don't know other distros well.
19:21:03 <accuser> NoobAlice yes, it works by installing libdbd-sqlite. thanks!
19:21:11 <NoobAlice> :D
19:25:00 <NoobAlice> accuser: If something is wrong with Debian's packaging, do tell Debian so they can fix it and other users don't run into the same problem. I see "adep: libdbd-sqlite3" on the page https://packages.debian.org/stable/source/gnucash , but somehow you didn't have it installed? Anyway, you're the best judge of whether/how to report. :)
19:25:59 <accuser> not sure what "adep" means
19:26:14 <accuser> but i installed libdbd-sqlite3 and the option showed up in gnucash
19:54:32 *** accuser has quit IRC
20:07:07 *** thechitowncubs has quit IRC
20:09:20 *** guak has quit IRC
20:20:06 *** hoppity has joined #gnucash
23:20:37 *** marusich has joined #gnucash
23:20:37 *** ChanServ sets mode: +v marusich
23:27:41 *** jervin has joined #gnucash