2018-05-07 GnuCash IRC logs
00:31:00 *** Mechtilde has joined #gnucash
01:04:42 *** boldstripe has quit IRC
01:14:12 *** fell has quit IRC
01:15:25 *** fell has joined #gnucash
01:17:58 *** Trel has quit IRC
01:38:20 *** Mechtilde has quit IRC
02:07:42 *** Trel has joined #gnucash
02:21:52 *** ngong has quit IRC
02:47:07 *** fabior has joined #gnucash
03:22:16 *** gour has joined #gnucash
04:06:11 *** gjanssens has joined #gnucash
04:06:11 *** ChanServ sets mode: +o gjanssens
04:06:31 *** fekepp has joined #gnucash
04:10:18 <gjanssens> .
04:47:39 *** Mechtilde has joined #gnucash
05:22:46 *** Mechtilde has quit IRC
05:25:24 *** Mechtilde has joined #gnucash
05:27:12 *** ncv has joined #gnucash
06:27:49 *** Jimraehl1 has joined #gnucash
06:47:26 *** fabior has quit IRC
06:54:00 *** boldstripe has joined #gnucash
07:08:50 *** O01eg has joined #gnucash
07:23:13 *** Jimraehl1 has left #gnucash
07:34:44 *** Mechtilde has quit IRC
07:35:18 *** Mechtilde has joined #gnucash
07:46:30 *** storyjesse has joined #gnucash
07:49:10 *** oozer has joined #gnucash
07:51:41 *** pilotauto has quit IRC
07:59:06 *** chris has joined #gnucash
08:05:19 <warlord> .
08:11:28 <chris> apologies for spam on github/travis; my cmake;ninja;ninja check shows no errors yet travis is complaining
08:38:46 *** Mechtilde has quit IRC
08:42:58 *** chris has quit IRC
08:52:37 *** Mechtilde has joined #gnucash
09:05:06 *** fekepp has quit IRC
09:11:04 *** fekepp has joined #gnucash
09:14:13 *** fekepp has quit IRC
09:16:13 *** fekepp has joined #gnucash
09:16:32 <gjanssens> .
09:30:46 *** Mechtilde has quit IRC
09:38:10 *** Mechtilde has joined #gnucash
09:41:40 *** fekepp has quit IRC
09:44:49 <Mechtilde> .
09:47:20 *** lmat has quit IRC
09:47:22 *** lmat has joined #gnucash
09:49:34 *** chris has joined #gnucash
09:51:51 *** chris has quit IRC
09:52:08 *** fekepp has joined #gnucash
10:14:10 <warlord> Mechtilde: Are you expecting any gncbot @tell messages? ;)
10:14:44 <Mechtilde> maybe
10:14:49 <warlord> :)
10:15:39 <Mechtilde> I pinged gjanssens and fell
10:16:36 <fell> Mechtilde: About what?
10:17:01 <Mechtilde> gjanssens, fell FrOSCon in Sankt Augustin/Bonn is at 25.8 and 26.8.2018
10:17:07 <Mechtilde> CfP is running
10:17:11 <Mechtilde> is there interest to present GnuCash
10:17:14 <Mechtilde> I'm there too
10:17:51 <Mechtilde> I discussed it wih gjanssens at FOSDEM in brussels
10:17:58 <Mechtilde> as an idea
10:20:42 <fell> Please submit your talks, devroom and project booth requests until May 23rd.
10:22:33 <fell> https://www.froscon.de/en/cfp/
10:26:27 *** kael has joined #gnucash
10:30:42 *** ncv has quit IRC
10:33:44 *** ncv has joined #gnucash
10:43:50 *** Vote4Pedro has joined #gnucash
10:48:03 *** Vote4Pedro has quit IRC
10:50:15 *** Mechtilde has quit IRC
11:15:19 *** kael has quit IRC
11:27:32 *** ArtGravity has joined #gnucash
11:50:12 *** boldstripe has quit IRC
11:51:57 *** chris has joined #gnucash
11:52:02 *** chris has left #gnucash
11:58:18 *** chris has joined #gnucash
12:13:38 *** chris has quit IRC
12:19:26 *** storyjesse has quit IRC
12:24:50 *** fabior has joined #gnucash
12:25:25 *** kael has joined #gnucash
12:31:07 *** gour_ has joined #gnucash
12:33:15 *** gour has quit IRC
12:37:13 *** Mechtilde has joined #gnucash
12:38:10 *** kael has quit IRC
12:44:44 *** fell_laptop has joined #gnucash
12:46:15 *** gncbot sets mode: +o fell
13:11:46 <gjanssens> Mechtilde: I just checked and unfortunately I won't be available during froscon :(
13:40:39 *** fabior has quit IRC
13:52:28 *** harshitaneja has joined #gnucash
13:55:11 *** fabior has joined #gnucash
13:59:32 *** fell is now known as fell_afk
14:01:42 *** O01eg has quit IRC
14:02:00 *** fell_laptop has quit IRC
14:14:35 *** warlord has quit IRC
14:15:22 *** warlord has joined #gnucash
14:17:50 *** O01eg has joined #gnucash
14:21:10 *** harshitaneja_ has joined #gnucash
14:22:00 *** harshitaneja has quit IRC
14:23:32 *** harshitaneja_ is now known as harshitaneja
14:25:47 *** fabior has quit IRC
14:31:19 *** frakturfreak has joined #gnucash
14:38:26 *** fabior has joined #gnucash
14:44:45 *** harshitaneja has quit IRC
14:45:11 *** harshitaneja_ has joined #gnucash
14:46:35 *** harshitaneja_ is now known as harshitaneja
14:48:28 *** fabior has quit IRC
14:53:52 *** fell_laptop has joined #gnucash
14:54:30 *** gncbot sets mode: +o fell_laptop
14:59:03 *** Mechtilde has quit IRC
14:59:47 *** tomtom2 has joined #gnucash
14:59:52 *** warlord has quit IRC
15:01:29 <fell_laptop> gjanssens: a few weeks ago you told me a smart (cmake) sequence to create an eclipse project directory. Unfortunately I didn't write it down.
15:01:37 <tomtom2> I would like to setup GneCash to analyze past financial data. A whole year's worth. Is that possible?
15:02:03 <fell_laptop> tomtom2: Sure.
15:02:31 <fell_laptop> Do you have records in some other app?
15:03:02 <tomtom2> How do I do it? Just enter past dates?
15:03:28 <fell_laptop> Why not?
15:03:35 <tomtom2> Yes I have years worth of spreadsheet data.
15:04:25 <fell_laptop> Once there was a tool calc2qif. I am not shure it is still functional.
15:05:01 <fell_laptop> Because QIF is easier to import than CSV.
15:05:16 *** harshitaneja has quit IRC
15:06:04 <tomtom2> As of right now I don't have GnueCash set up. but I thought that if it works on past data maybe I will start using it.
15:07:48 <fell_laptop> Because of learning bayes algorithm you import at first small chunks and assign the right accounts to train it.
15:08:31 <tomtom2> My impression of the software was that when you set it up it works only from the time and date onward and you cannot add data prior to that date.
15:10:25 <fell_laptop> Most users might start with the current year, but it is possible to enter older data, e.g. a commodity you bought some time ago.
15:11:58 <fell_laptop> You might adjust the preferences, filters and report options to display the year which you are entering
15:14:09 <tomtom2> OK. I guess I'll just go ahead and try setting up as if it were 2010. Let's see what happens. Thanks for the suggestions.
15:14:31 *** tomtom2 has quit IRC
15:22:50 *** fekepp has quit IRC
15:26:03 *** fekepp has joined #gnucash
15:38:17 <gjanssens> fell_laptop: https://lists.gnucash.org/logs/2018/01/26.html#T14:00:38
15:38:44 *** harshitaneja has joined #gnucash
15:43:27 *** fekepp1 has joined #gnucash
15:44:29 *** fekepp has quit IRC
15:44:30 *** fekepp1 is now known as fekepp
15:45:45 *** gjanssens has quit IRC
15:55:08 *** fabior has joined #gnucash
15:58:17 *** fell_laptop is now known as fell
16:07:24 *** mipesom has quit IRC
16:19:30 *** mipesom has joined #gnucash
16:21:55 *** gour_ has quit IRC
16:22:59 *** frakturfreak has quit IRC
16:31:58 *** Grav has joined #gnucash
16:32:33 *** ArtGravity has quit IRC
16:33:27 *** chamillo has joined #gnucash
16:36:07 <chamillo> Hi. I recently started using gnucash. I like the simplicity of it, but I'm really struggling to import transactions to it. Has anyone been successful importing transactions to gnucash?
16:45:30 *** harshitaneja has quit IRC
16:45:30 *** ncv has quit IRC
16:45:30 *** Trel has quit IRC
16:45:30 *** wget has quit IRC
16:45:30 *** chf has quit IRC
16:45:30 *** jethrogb has quit IRC
16:45:30 *** jchonig has quit IRC
16:45:30 *** ggherdov_ has quit IRC
16:45:30 *** linas has quit IRC
16:45:30 *** Unhammer has quit IRC
16:45:30 *** Cork has quit IRC
16:45:30 *** xmaka has quit IRC
16:45:30 *** luwum[m] has quit IRC
16:45:30 *** DiogoGomes[m] has quit IRC
16:45:30 *** tms has quit IRC
16:45:30 *** luc14n0 has quit IRC
16:45:30 *** chamillo has quit IRC
16:45:30 *** mipesom has quit IRC
16:45:30 *** fell has quit IRC
16:45:30 *** O01eg has quit IRC
16:45:30 *** lmat has quit IRC
16:45:30 *** fell_afk has quit IRC
16:45:30 *** bertbob has quit IRC
16:45:30 *** Farelli has quit IRC
16:45:30 *** puck has quit IRC
16:45:30 *** seanh has quit IRC
16:45:30 *** badger92 has quit IRC
16:45:30 *** nichevo has quit IRC
16:45:30 *** g5pw has quit IRC
16:45:30 *** gnomey has quit IRC
16:45:30 *** flips has quit IRC
16:45:30 *** akv has quit IRC
16:45:30 *** Yotson has quit IRC
16:45:30 *** arahael has quit IRC
16:45:30 *** redarrow has quit IRC
16:45:30 *** Grav has quit IRC
16:45:30 *** fabior has quit IRC
16:45:30 *** jotrago has quit IRC
16:45:30 *** CDB-Away has quit IRC
16:45:30 *** masterkorp has quit IRC
16:45:30 *** CDB-Man has quit IRC
16:45:30 *** yuriks has quit IRC
16:45:30 *** jonas has quit IRC
16:45:30 *** mdf has quit IRC
16:45:30 *** fiddlerwoaroof has quit IRC
16:45:30 *** Derperperd has quit IRC
16:45:30 *** crossan007 has quit IRC
16:46:26 *** harshitaneja_ has joined #gnucash
16:46:26 *** ggherdov_ has joined #gnucash
16:46:26 *** jchonig has joined #gnucash
16:46:26 *** chf1 has joined #gnucash
16:46:26 *** ncv_ has joined #gnucash
16:46:26 *** chamillo has joined #gnucash
16:46:26 *** Grav has joined #gnucash
16:46:26 *** mipesom has joined #gnucash
16:46:26 *** fabior has joined #gnucash
16:46:26 *** fell has joined #gnucash
16:46:26 *** O01eg has joined #gnucash
16:46:26 *** lmat has joined #gnucash
16:46:26 *** fell_afk has joined #gnucash
16:46:26 *** bertbob has joined #gnucash
16:46:26 *** Farelli has joined #gnucash
16:46:26 *** jotrago has joined #gnucash
16:46:26 *** CDB-Away has joined #gnucash
16:46:26 *** puck has joined #gnucash
16:46:26 *** seanh has joined #gnucash
16:46:26 *** badger92 has joined #gnucash
16:46:26 *** masterkorp has joined #gnucash
16:46:26 *** nichevo has joined #gnucash
16:46:26 *** CDB-Man has joined #gnucash
16:46:26 *** g5pw has joined #gnucash
16:46:26 *** gnomey has joined #gnucash
16:46:26 *** yuriks has joined #gnucash
16:46:26 *** jonas has joined #gnucash
16:46:26 *** mdf has joined #gnucash
16:46:26 *** flips has joined #gnucash
16:46:26 *** fiddlerwoaroof has joined #gnucash
16:46:26 *** akv has joined #gnucash
16:46:26 *** Yotson has joined #gnucash
16:46:26 *** Derperperd has joined #gnucash
16:46:26 *** arahael has joined #gnucash
16:46:26 *** crossan007 has joined #gnucash
16:46:26 *** redarrow has joined #gnucash
16:46:26 *** irc.gimp.ca sets mode: +oo fell fell_afk
16:48:35 *** wget has joined #gnucash
16:51:27 *** luc14n0 has joined #gnucash
16:53:18 *** chf1 has quit IRC
16:53:20 *** Cork has joined #gnucash
16:53:20 *** jethrogb has joined #gnucash
16:53:28 *** xmaka has joined #gnucash
16:54:24 *** Trel has joined #gnucash
16:54:35 *** tms has joined #gnucash
16:54:35 *** jotrago has quit IRC
16:54:36 *** linas has joined #gnucash
16:55:34 *** Unhammer has joined #gnucash
16:58:18 *** boldstripe has joined #gnucash
16:58:48 *** chf has joined #gnucash
17:07:34 <fell> First almost successfull cmake run returns: No package 'gwengui-gtk3' found
17:09:15 <fell> chamillo: Yes! ;-)
17:09:26 <chamillo> Great!
17:09:47 <chamillo> Is there a template you can share?
17:10:17 <fell> Which file format are you trying?
17:14:01 <fell> chamillo, most financial apps can export QIF files.
17:14:41 *** harshitaneja_ has quit IRC
17:18:21 <chamillo> I need to import transactions from a .CSV
17:19:47 *** boldstripe has quit IRC
17:20:05 <fell> OK, I would just create an example set of transactions in gnucash and export it to csv.
17:20:51 *** boldstripe has joined #gnucash
17:20:52 <chamillo> I already did that, but when I try to import back to gnucash it fails.
17:21:13 *** fabior has quit IRC
17:21:27 <fell> Are there any error messages?
17:22:05 <fell> Which OS are you using?
17:22:15 <chamillo> Linuxmint
17:23:33 <chamillo> The error says: There are problems with the import settings! The date format could be wrong or there are not enough columns set...
17:24:32 *** boldstripe_ has joined #gnucash
17:25:07 *** boldstripe has quit IRC
17:25:07 *** chf has quit IRC
17:25:07 *** tms has quit IRC
17:25:07 *** xmaka has quit IRC
17:25:09 *** boldstripe_ is now known as boldstripe
17:25:12 *** chf has joined #gnucash
17:25:26 <fell> Your locale is en_US.UTF8?
17:25:59 <chamillo> Yes.
17:26:36 <fell> And which Gnucash version are you using?
17:27:04 <chamillo> Version 2.6.12
17:27:30 <fell> That is a few years old ...
17:28:14 <fell> So it might be an already fixed error.
17:29:01 <chamillo> How do I upgrade? I installed from the linuxmint software manager.
17:30:44 <chamillo> If I run:
17:30:47 <chamillo> sudo apt-get install gnucash
17:31:13 <chamillo> Will it give me the most recent package? I understand that I need to purge the old one first.
17:32:23 <Grav> If there was a newer version apt-get upgrade would have installed it already, assuming that you run that periodically.
17:34:22 <chamillo> I have not run: apt-get upgrade, but I will do that now. Thank you.
17:34:35 <Grav> You want to do that all the time
17:34:42 <Grav> That's how you get regular system updates
17:35:38 <Grav> You need to run apt-get update first
17:36:05 <Grav> That will pull down the latest contents from your configured software repositories
17:36:53 <Grav> I suddenly get "No suitable backend was found for mysql://user@127.0.0.1/database" when I try to open my books. This configuration has been working for six years, and I have checked the obvious suspects like ssh tunnel not up and inappropriate local instance of mysql running.
17:37:16 <Grav> Anyone have any suggestions of other things to check for that error?
17:39:01 <Grav> The only relevant thing that I can think of that has changed since the last time I successfully used gnucash is the installation of Oracle mysql packages on my workstation.
17:39:58 <fell> Grav did you change something around libdbi and it's dbd drivers?
17:39:59 *** xmaka has joined #gnucash
17:40:06 <chamillo> I just updated and upgraded, but I'm still using version 2.6.12
17:40:29 <Grav> chamillo, Debian based releases don't see frequent upgrades
17:41:01 <Grav> They are traditionally frozen at the version in the base release when it shipped, unless there is a security update.
17:41:09 <fell> Eventually they have one at GetDeb?
17:41:24 <chamillo> If someone could provide a .CSV file that was successfully uploaded, I could use it to build my file.
17:42:36 <Grav> fell, re: libdbi, not that I know of, but your answer is uncanny as the page I am reading (on Linux Mint forums coincidentally) had me thinking that I should check my libdbi versions
17:43:14 <Grav> fell, GetDeb has 2.6.17 for Xenial (which I am using)
17:48:46 <Grav> fell, Thanks for the suggestion. It looks like my libdbd-mysql package wound up getting uninstalled when I installed the Oracle community mysql package.
17:49:04 *** storyjesse has joined #gnucash
17:49:09 <Grav> Installing it and restarting gnucash fixed it
17:49:26 <fell> Great!
18:03:50 *** tms has joined #gnucash
18:08:52 <chamillo> I removed the version of gnucash I had using:
18:08:59 <chamillo> sudo apt-get purge gnucash
18:09:06 <chamillo> sudo apt-get autoremove
18:09:16 <chamillo> and reinstalled using:
18:09:22 <chamillo> sudo apt-get update
18:09:29 <chamillo> sudo apt-get install gnucash
18:10:00 <chamillo> I ended up with the same version. 2.16.12
18:10:55 *** storyjesse has quit IRC
18:11:02 <fell> Can you add other repositories? (I don't know the Mint/Ubuntu specifics)
18:14:02 <fell> Or you could ask on the gnucash-user mailinng list if and how other mint users get more recent versions.
18:18:38 <fell> BTW, the bug list of csv: https://bugzilla.gnome.org/buglist.cgi?component=Import%20-%20CSV&list_id=308406&order=changeddate%20DESC%2Cbug_status%2Cpriority%2Cassigned_to%2Cbug_id&product=GnuCash&query_based_on=&query_format=advanced
18:19:02 <fell> there a fixed date issues.
18:19:35 <chamillo> I just downloaded the new version from:
18:19:42 <chamillo> http://ftp.us.debian.org/debian/pool/main/g/gnucash/
18:20:18 *** fekepp has quit IRC
18:31:56 <fell> @tell gjanssens, Thanks! When I wanted to document it, I found https://wiki.gnucash.org/wiki/index.php?title=Eclipse&diff=prev&oldid=13313
18:31:56 <gncbot> fell: The operation succeeded.
18:35:58 *** pilotauto has joined #gnucash
18:49:00 *** pilotauto has quit IRC
18:52:28 *** pilotauto has joined #gnucash
19:16:11 *** DiogoGomes[m] has joined #gnucash
19:20:55 *** boldstripe has quit IRC
19:41:47 *** ncv_ has quit IRC
19:46:37 *** fell has quit IRC
19:53:59 *** fell has joined #gnucash
19:54:42 *** gncbot sets mode: +o fell
20:12:11 *** fell has quit IRC
20:52:50 *** luwum[m] has joined #gnucash
21:07:37 <chamillo> Can anyone provide a template for a .CSV transaction import into gnucash? It's not that I didn't try to find it on my own. I have looked all over for a sample of a successful import .CSV file, but I have not been able to find such a file.
21:08:22 <chamillo> I think that it would be very helpful to others to create a template file that we could post on the support site.
22:04:36 *** boldstripe has joined #gnucash
22:18:24 *** oozer has quit IRC
22:45:27 *** Grav has quit IRC
23:12:36 *** storyjesse has joined #gnucash
23:14:13 *** storyjesse has joined #gnucash
23:48:30 *** fell_afk has quit IRC
23:52:12 *** fell has joined #gnucash