2015-01-02 GnuCash IRC logs
00:32:41 *** MechtiIde has quit IRC
00:49:15 *** Krzysiek_K has quit IRC
00:53:31 *** jack has joined #gnucash
00:53:57 <jack> Has anyone had any luck importing CSV histories?
00:54:31 <jack> it seems pretty tedious to go through and manually set the transfer for each transaction
01:25:34 *** GabrieleV_ has joined #gnucash
01:26:06 *** GabrieleV has quit IRC
01:26:06 *** GabrieleV_ is now known as GabrieleV
01:32:43 *** Caemor1 has joined #gnucash
01:33:00 *** fell__ has joined #gnucash
01:33:00 *** gncbot sets mode: +o fell__
02:19:12 *** gour has joined #gnucash
02:36:05 *** GabrieleV_ has joined #gnucash
02:36:07 *** GabrieleV has quit IRC
02:36:07 *** GabrieleV_ is now known as GabrieleV
02:39:59 *** aqua___ has joined #gnucash
02:44:07 *** andy has quit IRC
02:45:19 *** mlncn has quit IRC
02:52:58 *** andy has joined #gnucash
03:29:21 *** warlord has quit IRC
03:29:23 *** aqua___ has quit IRC
03:52:19 *** gour_ has joined #gnucash
04:01:31 *** gour has quit IRC
04:02:04 *** gour_ is now known as gour
04:15:54 *** rubdos has joined #gnucash
04:20:33 *** GabrieleV_ has joined #gnucash
04:20:33 *** GabrieleV has quit IRC
04:20:35 *** GabrieleV_ is now known as GabrieleV
04:49:07 *** rubdos has quit IRC
05:19:12 *** Jimraehl1 has joined #gnucash
05:43:50 *** gour_ has joined #gnucash
05:47:25 *** aqua___ has joined #gnucash
05:52:32 *** gour has quit IRC
06:11:28 *** rickoehn has joined #gnucash
06:15:51 *** himaxx has joined #gnucash
06:16:39 *** himaxx has quit IRC
06:34:38 <daum> this is weird - my invoice i just created has a ton of blank table row lines
06:35:32 <daum> ah its the minium # entries
06:35:37 <daum> is there a way to set that to 1?
06:35:46 <daum> it seems to keep wanting to be a min of only 4
06:45:00 <daum> ah i had switch to fancy invoice vs regular printable nvm
06:50:11 <daum> is there a way to set technicolor as your default style sheet on reports?
07:32:55 *** gour_ has quit IRC
07:34:47 *** gour has joined #gnucash
07:35:23 *** mlncn has joined #gnucash
08:03:14 *** danley has joined #gnucash
08:05:34 <danley> Hi, I've been using GnuCash for a while now and there is one thing I haven't found a solution yet. Maybe one of you know if/how this works. I get my transactions from my bank account online using AqBanking. I have a transaction every month that needs to be split. e.g. 100€ transaction 50€ to account A, 50€ to account B. is there a way to do this automatically
08:07:00 <danley> otherwise I always have to book the whole 100€ on some equalisation account and then change it manually every time. thanks
08:08:25 *** mlncn has quit IRC
08:49:44 *** danley has quit IRC
08:51:01 *** mlncn has joined #gnucash
09:22:35 *** GabrieleV_ has joined #gnucash
09:23:06 *** GabrieleV has quit IRC
09:23:07 *** GabrieleV_ is now known as GabrieleV
09:29:48 *** mlncn has quit IRC
09:43:33 *** mlncn has joined #gnucash
09:44:25 *** Krzysiek_K has joined #gnucash
09:46:00 *** AlonzoTG has joined #gnucash
09:46:34 <AlonzoTG> Hey, what's the stupid trick for making gnucash show me all six digits of my liabilities account? =(
09:47:04 <AlonzoTG> After all these years, I STILL can't make it shrink the description field.
09:49:18 *** mlncn-agaric has joined #gnucash
09:49:49 *** mlncn has quit IRC
09:55:05 *** warlord has joined #gnucash
09:55:06 *** gncbot sets mode: +o warlord
10:17:35 *** GabrieleV_ has joined #gnucash
10:18:09 *** GabrieleV has quit IRC
10:18:09 *** GabrieleV_ is now known as GabrieleV
10:18:48 *** MechtiIde has joined #gnucash
10:33:51 *** fell__ is now known as fell
10:35:56 <fell> AlonzoTG: First expand another column, then you can shrink the decriptions. They are always filling the rest of the window.
10:41:44 *** rpg has joined #gnucash
10:41:47 *** fell_ has joined #gnucash
10:41:48 *** gncbot sets mode: +o fell_
10:50:37 *** fell has quit IRC
10:54:40 *** fell_ is now known as fell
10:54:49 <fell> @tell danley You could create the monthly splited transaction in the scheduled txn editor and then mark the imported one as duplicate.
10:54:49 <gncbot> fell: The operation succeeded.
11:23:36 *** GabrieleV_ has joined #gnucash
11:23:38 *** GabrieleV has quit IRC
11:23:38 *** GabrieleV_ is now known as GabrieleV
11:24:43 *** aqua___ has quit IRC
11:36:55 *** mlncn-agaric has quit IRC
11:58:42 *** Gbarr1 has quit IRC
11:59:51 *** mlncn-agaric has joined #gnucash
12:15:26 *** mlncn-agaric has quit IRC
12:29:28 *** Gbarr has joined #gnucash
12:46:16 *** mlncn-agaric has joined #gnucash
13:05:35 *** danley has joined #gnucash
13:06:14 <danley> I asked a question earlier today but timed out in the meantime. did anybody have an answer?
13:06:14 <gncbot> danley: Sent 2 hours and 11 minutes ago: <fell> You could create the monthly splited transaction in the scheduled txn editor and then mark the imported one as duplicate.
13:07:08 <danley> fell: thanks, I'll try that.
13:27:28 *** MechtiIde has quit IRC
13:31:14 *** gour has quit IRC
13:34:21 *** Tam5 has joined #gnucash
13:34:46 <Tam5> Does GNUcash have a general journal?
13:35:17 <Tam5> I almost did not use the program until I discovered you can have it use the traditional debit credit labels. I was happy to see that
13:37:00 <Tam5> The only thing so far that concerns me a bit is how GNUcash seems to I guess access data within itself might make it very possible for data to leak outside the network, in fact likely
13:38:30 *** mlncn-agaric has quit IRC
13:38:36 <jralls> Tam5: Yes, Tools>General Ledger.
13:39:47 <jralls> Tam5: What do you mean "leak outside the network"? By default GnuCash uses a local file.
13:40:52 <Tam5> General ledger does not equal General Journal does it?
13:42:00 <Tam5> jralls: It just seems to be set up to make it much easier for data to leak. There was an article about it somewhere on the internet
13:43:58 <warlord> Tam5: I have no idea what kind of data leakage you're talking about. It's a local desktop app. The only network services it uses are for Quote lookup
13:45:11 <jralls> Tam5: In this case, yes, General Ledger and General Journal are the same.
13:46:38 <jralls> Tam5: Some users keep their GnuCash data on an encrypted volume. One even disconnects his computer from the network whenever the encrypted volume is mounted. If that's not sufficient, look into building a TEMPEST room.
13:48:10 <jralls> Tam5: If you're that paranoid, you'll need such protection for any computer handling sensitive data.
13:49:36 <jralls> http://en.wikipedia.org/wiki/Tempest_%28codename%29
13:54:29 <Tam5> I knew it would not take long for the paranoid label to come out. The general journal is not at all the same as the general journal. Swapping or equating labels like that can make it very difficult for people to understand the basics of bookkeeping unless they take a class on the subject.
13:54:33 <warlord> jralls: I'm not seeing any messages from tam -- is he PMing you and you're responding in channel?
13:55:21 <warlord> Tam5: "The basics" go back like 500 years, well before computers. These days it makes no sense. Even the concepts for "Books" make no sense these days. But people still use the labels.
13:55:45 <jralls> warlord: Looks like he's sending in-channel to me. My client makes a separate window for PMs.
13:55:46 <Tam5> That is the dumbest statement I have seen in an accounting channel yet.
13:55:50 <warlord> As far as GnuCash is concerned the GL and GJ are exactly the same because modern systems autopost
13:56:11 <warlord> Tam5: then go away.
13:56:17 <Tam5> good lord
13:56:27 *** Tam5 was kicked by warlord (warlord)
13:57:38 <warlord> jralls: no wonder I saw no comments
13:58:03 <warlord> Sorry I kicked him without warning..
13:58:34 <jralls> warlord: Sorry, why did you see no comments?
13:59:05 <warlord> jralls: no clue. I was just seeing a bunch of messages from you but nothing from Tam.
13:59:47 <warlord> there was his comment about leaking... and then nothing until "I knew ... the paranoid label to come out"
13:59:48 <jralls> Yeah, he had two threads going, GJ and COMSEC.
14:00:19 <jralls> I was responding to each in turn.
14:00:40 <warlord> Right, well whatever you were responding to wasn't "in channel"
14:01:46 <danley> he only sent those 8 messages
14:02:04 <warlord> danley: jralls appeared to be responding to many more.
14:02:31 <warlord> for example, not answering what kind of data leaking he was talking about.
14:02:33 * warlord shrugs
14:02:58 <warlord> People asking for help shouldn't call the people providing help (or the help they give) dumb.
14:04:09 <danley> true...
14:04:49 <jralls> warlord: He never did explain the data leaking. I think he doesn't actually know, it's just some nonsense he read about.
14:05:26 <jralls> You're being charitable. Seemed more like trolling than asking for help.
14:06:59 <danley> is there an easy way to automatically import a file monthly or so? my use case: I split the bills for groceries with my girlfriend. each of us has their own gnucash file. I have an account for the groceries that we share and then for each transaction in that account I want to export 50% of that, import that in her gnucash so that she sees what she has to send
14:07:19 <danley> but that workflow has so many manual steps at the moment
14:07:29 <warlord> danley: sorry, there is no batch import; you need to do it manually.
14:07:36 <danley> I hesitate to actually do it... it'll become a chore
14:08:42 <jralls> danley: Actually, I think there might be a way with CSV export and import. Ask on the user list; a couple of folks there have been talking about it recently.
14:10:27 * warlord doesnt use any importers
14:10:32 <danley> I tried it and it works. but exporting alone is 10 clicks (just counted). I'd rather read up on the python bindings and try something there before getting frustrated by doing this task every month for 10 minutes
14:11:49 <danley> sames goes for the import of the android app. to import that file I have to click "next" about 10 times. even though I know that the accounts are correct and everything because I always export the latest account structure to my phone
14:13:15 <danley> I mean gnucash can do all of those things. it's just not very nice to do it in such a complicated way over and over again
14:14:52 <jralls> danley: It doesn't look like the import-export functions are exported to the guile or python bindings. You might find a SQL approach the easiest way to script it.
14:16:40 <danley> jralls: just saw that. plus I wouldn't be able to run the scripts while running gnucash anyway. I thought it would be calls to gnucash but it's more like just an API to the .gnucash file
14:17:00 <danley> It's SQLite, correct?
14:17:24 <warlord> danley: if you know everything is correct then what is the issue wth just hitting next 10 times? gnucash doesnt know its correct..
14:18:26 <warlord> that is one sql option
14:20:41 <danley> warlord: it's just unnecessary. it could be automated. it should be automated :)
14:23:26 <jralls> danley: The SQL backend supports SQLite3, MySQL, and Postgresql, but the latter two are server-based. SQLite3 would be the easiest to deal with. You can query the "sending" database while GnuCash has it open, but writing to the "receiving" db when it's open in GnuCash would cause trouble.
14:23:45 <warlord> and how is gnucash, the app, supposed to know that you want to make zero changes to the defaults?
14:26:29 *** aqua___ has joined #gnucash
14:26:35 <danley> jralls: because the receiving one has the data in memory and wouldn't notice the changes, correct?
14:26:55 <jralls> danley: Yes.
14:27:16 <danley> warlord: maybe have a "trusted" import, or "standard batch import"... something along those lines
14:28:59 <warlord> danley: patches always welcome. ;) (I'll note that the QIF importer is completely separate from everything else)
14:29:35 <jralls> danley: ISTM it would be better to expose the importer to the scripting interface. That protects the unsophisticated user from making a mess.
14:30:41 <danley> warlord: I will have to freshen up on C first ;)
14:30:48 <warlord> jralls: the qif importer is 1/2 in scheme anyways, so it probably *could* be scripted.
14:31:06 <warlord> danley: actually, for QIF, most if it is in scheme
14:31:31 <danley> in that case I will have to order "Scheme for Dummies" first
14:31:33 <danley> never used it before
14:31:38 <warlord> danley: have you ever programmed anything?
14:31:41 <danley> lots.
14:31:41 <warlord> if so, you can learn scheme syntax in a day
14:31:51 <warlord> the ins-and-outs will take longer, but the syntax is simple... keep in mind that it was designed for an Intro to CS class
14:32:05 <danley> but it would be neat to have an import function for the data the mobile app. that thing could just go through automatically unless one of the accounts in the QIF is not an exact match to the accounts in the tree
14:32:11 <danley> maybe I'll look at that
14:32:11 <warlord> danley: I agree, that would be a useful feature.
14:32:18 <danley> do you guys develop on windows or *nix?
14:32:19 <warlord> The way I would approach that is to make a new UI based around the QIF Importer UI that is effectively "Import from Mobile App"
14:32:21 * warlord devs on Linux
14:32:45 <warlord> danley: jralls is based on Mac, but uses VMs for Linux and Windows
14:34:21 <danley> I'll get some gnome based distribution
14:34:25 <jralls> danley: Nobody devs GnuCash on Windows if he can avoid it. The environment is such that compilation takes forever. You can't use Visual Studio, either.
14:34:29 <danley> seems the easiest to start
14:34:50 <danley> wanted to try the current fedora anyway :)
14:35:06 <jralls> gjanssens uses Fedora.
14:35:31 <jralls> IIRC he likes Eclipse for an IDE. I like emacs.
14:35:35 * warlord uses fedora too
14:35:49 <warlord> ... and emacs
14:36:01 <danley> I'd go for ecplise
14:41:55 <danley> ohhh... scheme is LISP
14:42:09 <danley> in that case I have some experience
14:42:29 <warlord> yeah, it is a lisp dialect
14:49:19 *** lmat has joined #gnucash
14:53:10 *** mlncn-agaric has joined #gnucash
15:22:23 *** pacon has joined #gnucash
15:47:04 *** fell has quit IRC
15:53:43 *** rpg_ has joined #gnucash
15:58:54 *** rpg has quit IRC
16:03:04 *** cigarshark has joined #gnucash
16:03:58 *** rpg_ has quit IRC
16:05:33 *** fell has joined #gnucash
16:05:34 *** gncbot sets mode: +o fell
16:21:21 *** rickoehn has quit IRC
16:34:14 *** danley has quit IRC
17:27:42 *** rpg has joined #gnucash
17:29:22 *** rpg_ has joined #gnucash
17:29:23 *** rpg has quit IRC
17:29:50 *** fell has quit IRC
17:32:20 *** fell has joined #gnucash
17:32:21 *** gncbot sets mode: +o fell
17:47:17 *** fell has quit IRC
17:50:32 *** rpg_ has quit IRC
17:57:03 *** cigarshark has quit IRC
17:59:51 *** fell has joined #gnucash
17:59:52 *** gncbot sets mode: +o fell
18:22:18 *** mlncn-agaric has quit IRC
19:57:37 *** fell has quit IRC
20:27:44 *** Caemor has joined #gnucash
20:36:12 *** Caemor1 has quit IRC
21:08:20 *** Caemor has quit IRC
21:54:14 *** GabrieleV_ has joined #gnucash
21:54:28 *** GabrieleV has quit IRC
21:54:29 *** GabrieleV_ is now known as GabrieleV
22:22:34 *** Krzysiek_K has quit IRC
22:53:45 *** GabrieleV_ has joined #gnucash
22:53:47 *** GabrieleV has quit IRC
22:53:48 *** GabrieleV_ is now known as GabrieleV
23:48:17 *** GabrieleV_ has joined #gnucash
23:48:29 *** GabrieleV has quit IRC
23:48:29 *** GabrieleV_ is now known as GabrieleV