2014-11-23 GnuCash IRC logs
00:42:58 *** mlncn has quit IRC
00:44:43 *** pppp2 has joined #gnucash
00:51:43 *** ErKa has joined #gnucash
01:53:03 *** jimvideo has quit IRC
01:59:32 *** ErKa has quit IRC
02:02:18 *** MechtiIde has joined #gnucash
02:04:15 *** fell_ has quit IRC
02:04:28 *** fell_ has joined #gnucash
02:04:28 *** gncbot sets mode: +o fell_
02:55:48 *** fell_ has quit IRC
03:23:47 *** gjanssens has joined #gnucash
03:23:47 *** gncbot sets mode: +o gjanssens
03:57:06 *** pppp2 has quit IRC
04:21:39 *** smw has quit IRC
04:46:41 *** GabrieleV_ has joined #gnucash
04:46:43 *** GabrieleV has quit IRC
04:46:43 *** GabrieleV_ is now known as GabrieleV
04:56:03 *** pppp2 has joined #gnucash
05:20:30 *** cartsoftware has joined #gnucash
05:23:44 *** pppp2 has quit IRC
05:35:44 *** Girobino has joined #gnucash
05:40:20 *** pppp2 has joined #gnucash
05:41:21 <Girobino> Hi there! Is there any way to import a .gnucash file into another? I am the treasurer of an association and get .gnucash files from a member who is competent to do some work for our association.
05:51:06 *** aqua___ has quit IRC
06:06:43 *** GabrieleV_ has joined #gnucash
06:06:47 *** GabrieleV has quit IRC
06:06:47 *** GabrieleV_ is now known as GabrieleV
06:16:03 *** himaxx has joined #gnucash
06:23:04 *** himaxx has quit IRC
06:23:27 *** himaxx has joined #gnucash
06:28:15 *** cartsoftware has quit IRC
06:30:35 *** himaxx has quit IRC
06:48:54 <gjanssens> Girobino: There is no direct importer for .gnucash files
06:50:54 <gjanssens> I was about ot propose to export to qif but I see that's not possible. The only export format is csv.
07:11:44 *** GabrieleV_ has joined #gnucash
07:11:57 *** GabrieleV has quit IRC
07:11:57 *** GabrieleV_ is now known as GabrieleV
07:29:05 <gjanssens> deadmeiker: as far as I know the lines on the report you refer to are introduced by the "Head or Tail" stylesheet
07:29:21 <gjanssens> you can switch to a different stylesheet to get rid of them
07:42:37 *** Jimraehl1 has left #gnucash
07:44:58 *** cartsoftware has joined #gnucash
07:46:56 *** wol has joined #gnucash
07:47:49 *** cartsoftware has quit IRC
07:48:39 *** cartsoftware has joined #gnucash
08:48:58 *** wol has quit IRC
08:53:51 *** O01eg has joined #gnucash
08:55:47 *** pppp2 has quit IRC
09:03:36 *** himaxx has joined #gnucash
09:04:03 *** himaxx has quit IRC
09:18:07 <Girobino> gjanssens: I have tried to export and reimport a set of transacctions via a .csv file. The import dialogue shows a lot of errors in cause of each subpart of a transaction. The data could be imported, but a "real" interface between .gnucash files would be great.
09:18:32 <Girobino> gjanssens: At the moment this also works. Thanks
09:31:44 <gjanssens> Girobino: yes our export/import cycle could use improvement :(
09:49:05 *** wol has joined #gnucash
10:10:38 *** mlncn has joined #gnucash
10:16:49 *** wol has quit IRC
10:18:09 *** fell_ has joined #gnucash
10:18:09 *** gncbot sets mode: +o fell_
10:29:26 *** mikee_ has joined #gnucash
10:35:51 *** mlncn has quit IRC
10:37:17 *** mikee has quit IRC
10:37:17 *** mikee_ is now known as mikee
10:37:38 <deadmeiker> hi so my question again: in my report is a text message "created for (erstellt für)" an i don't now where i can edit this ..... http://www.pic-upload.de/view-25337515/Bericht.jpg.html
10:59:47 *** GabrieleV_ has joined #gnucash
10:59:57 *** GabrieleV has quit IRC
10:59:57 *** GabrieleV_ is now known as GabrieleV
11:07:56 *** Jeff999_ has joined #gnucash
11:10:00 *** Jeff999 has quit IRC
11:11:58 <gjanssens> deadmeiker: so my reply again: choose another stylesheet in the report options :)
11:12:12 <gjanssens> (Allgemein -> Stilvorlage)
11:12:49 <gjanssens> Or did I misunderstand and you *want* this text but have a different value ?
11:15:29 <gjanssens> In that case you can go to Edit->Stylesheets and edit the Head & Foot stylesheet
11:15:32 <deadmeiker> change the text
11:15:53 <gjanssens> The preparer and prepared for options are under the General tab there.
11:17:03 <deadmeiker> Perfect thank you very much
11:19:15 *** deadmeiker has quit IRC
11:35:30 *** andy has quit IRC
11:46:24 *** jralls has quit IRC
11:47:03 *** jralls has joined #gnucash
11:47:04 *** gncbot sets mode: +o jralls
11:54:33 *** andy has joined #gnucash
11:58:28 <gjanssens> jralls: I'm looking at Ulrich Mörke's python problem he posted yesterday on gnucash-user
11:59:05 <gjanssens> From my experiments your commit eaae6e9546cd1ed34504c4a3817111c2b7ddea4b seems to break creating new files in python
12:00:27 <gjanssens> self.load() on a new session results in the backend error Ulrich is experiencing
12:01:14 <gjanssens> Is that self.load really needed for new files in the context of bug 726891
12:01:22 <gjanssens> Or only for existing files
12:05:52 <gjanssens> If I partly revert commit eaae6e9546cd1ed34504c4a3817111c2b7ddea4b creating files works again.
12:12:34 <gjanssens> That is, creating xml files works again, but creating and saving to an sqlite3 file fails miserably...
12:13:31 <gjanssens> Looks to me the two backends have different assumptions on the sequence of commands required to save to a new file...
12:14:44 *** ErKa has joined #gnucash
12:22:14 <gjanssens> I have reopened the bug for further investigation. Unfortunately I don't have time to do so myself :(
12:22:29 *** gjanssens is now known as gjanssens_
12:37:04 *** smw has joined #gnucash
12:55:53 <jralls> gjanssens_: I'll look into it, but I suspect based on my comment #4 that it's user error on both Mörke's part and yours: You're not passing the -new arg to tell the script to create a new file instead of opening an existing one. But I'll have to re-examine the code to be sure that's right.
12:56:36 <jralls> gjanssens_: 8 months is too long for my mental cache. ;-)
13:06:55 *** aqua___ has joined #gnucash
13:18:53 *** gjanssens_ is now known as gjanssens
13:18:57 <gjanssens> :)
13:19:28 <gjanssens> I don't think that's the problem. I am passing is_new=True
13:19:40 <gjanssens> Unless you mean something else still
13:19:53 <gjanssens> Anyway, I've got a quick fix ready if you like
13:20:40 <gjanssens> If I replace self.load() with
13:20:43 <gjanssens> if book_uri[:3] != "xml" or not is_new:
13:20:45 <gjanssens> self.load()
13:21:05 <gjanssens> It will skip self.load for a newly created xml file
13:21:17 <jralls> gjanssens: I thought you didn't have time to work on it ;-)
13:21:53 <gjanssens> I thought so too, but this just occured to me while doing something else so I quickly tried it :)
13:22:17 <gjanssens> And with this change I can create both new xml and sqlite3 files
13:22:34 <jralls> OK. That seems right, then.
13:22:52 <gjanssens> It's slightly hacky because it hard-codes the uri prefix but I think that should be ok
13:23:20 <gjanssens> Anyway got to go again. I'll try to push the fix tomorrow.
13:23:22 *** aqua___ has quit IRC
13:24:22 <gjanssens> With some comments to explain why this was done so we still remember in a couple of months
13:24:27 *** gjanssens is now known as gjanssens_
13:24:31 <jralls> OK. I'll look for a way to avoid the hard-coding once I get this WebKit build going.
13:29:49 *** aqua___ has joined #gnucash
13:59:21 *** GabrieleV_ has joined #gnucash
13:59:27 *** GabrieleV has quit IRC
13:59:27 *** GabrieleV_ is now known as GabrieleV
14:12:02 *** aqua___ has quit IRC
14:14:05 *** MechtiIde has quit IRC
14:39:38 *** aqua___ has joined #gnucash
14:59:21 *** GabrieleV_ has joined #gnucash
14:59:21 *** GabrieleV has quit IRC
14:59:21 *** GabrieleV_ is now known as GabrieleV
15:14:43 *** ErKa has quit IRC
15:23:45 *** mlncn has joined #gnucash
15:29:20 *** Girobino has left #gnucash
15:35:51 *** cartsoftware has quit IRC
15:42:05 *** aqua___ has quit IRC
15:49:03 *** jralls has quit IRC
15:50:00 *** jralls has joined #gnucash
15:50:00 *** gncbot sets mode: +o jralls
15:57:48 *** gjanssens_ has quit IRC
16:02:27 <smw> Are bugs for the android app filed in the same place as the desktop version?
16:06:07 *** mlncn has quit IRC
16:07:24 *** mlncn has joined #gnucash
16:15:47 *** jralls has quit IRC
16:16:29 *** jralls has joined #gnucash
16:16:30 *** gncbot sets mode: +o jralls
16:20:30 <jralls> smw: No, Ngewi's bug tracker is at https://github.com/codinguser/gnucash-android/issues?state=open
16:20:59 <smw> jralls: ok, I will move my bug report over there :-)
16:21:47 <smw> jralls: also, do you happen to be a developer? Any idea why trading account balances aren't inverted like liabilities?
16:23:18 <jralls> smw: Yes, but no. I didn't implement the trading accounts feature. That said, they're not really intended for direct manipulation, so why invert them?
16:23:49 <smw> jralls: because my unrealized gains are negative. It makes me feel bad :-(
16:24:33 <jralls> Where/how are you looking at unrealized gains? In the Advanced Portfolio Report?
16:24:49 <smw> jralls: my trading account (since all my equity and income are USD) perfectly matches my unrealized loss
16:25:02 <kimmo2> smw, maybe it's not the accounts, but your trading? ;)
16:25:20 <smw> kimmo2: you are right, I should get a loss so all my numbers can be positive ;-)
16:26:03 *** cartsoftware has joined #gnucash
16:27:21 <kimmo2> and that's actually pretty easy to do, too!
16:27:21 <smw> kimmo2: the trading account works by debiting currency and crediting securities. When the prices of the securities increase (unrealized gain), the credits > debits and the balance is negative
16:27:25 <jralls> No it doesn't. Only comparing your book value with the latest price in the price db shows you unrealized gains and losses. Trading accounts only help Gnucash balance transactions in more than two currencies/commodities.
16:27:38 <kimmo2> I know just kidding ;)
16:28:07 <kimmo2> all my holdings are just plan asset accounts
16:28:23 <smw> jralls: yes. it does. Of course, this is just an artifact of all my equity and income being in USD
16:28:24 <kimmo2> I couldn't be bothered to track the present value of my stocks
16:29:11 <jralls> smw: Explain in excrutiating detail how you think that unrealized prices are affecting your book.
16:29:23 <smw> jralls: then again, I imagine that will be the case forever because for tax purposes, I need all my stocks to be based on the USD value and receipt and sell
16:29:30 <smw> jralls: oh, they aren't
16:29:45 <jralls> Then how can the trading account relfect them?
16:30:15 <smw> jralls: the account is considered USD and uses current prices when giving me the balance.
16:30:24 <smw> I fetch latest prices from the internet
16:31:03 <smw> jralls: I mean the placeholder trading account. It converts all its subaccts to USD using current prices
16:31:22 <smw> jralls: therefore, my trading account is -2000 because I have 2000 unrealized gains from my stocks
16:31:23 <jralls> Ah, you don't mean in the account register, you mean on the Accounts page.
16:31:29 <smw> correct
16:32:44 <smw> jralls: I am only upset with the display showing negative because I have an unrealized gain. :-)
16:33:21 <jralls> So mark it as hidden and you won't see it. ;-)
16:33:34 <smw> lol
16:34:34 <jralls> But you raise an interesting point. Trading accounts probably also affect the amounts in the summary bar, and that probably wasn't considered when they were implemented.
16:35:20 <smw> jralls: oh, I thought the reason they implemented a "trading" type was to avoid that.
16:39:48 <jralls> No, they were really intended for folks who use multiple currencies. Without them GnuCash gets confused about prices in a >2-way transaction. Suppose you bought a stock on a foreign exchange, say Toronto. The stock would be priced in CAD, so you'd have to first convert the USD to CAD then buy the stock. If you did it in one transaction GnuCash would treat the stock price (in CAD) as being in USD without having the trading
16:39:48 <jralls> accounts to keep the two parts of the transaction separate.
16:42:23 <smw> jralls: I see. I thought they were for making it easier to keep track of capital gains. Sort of like http://www.mscs.dal.ca/~selinger/accounting/tutorial.html#5.1
16:51:15 *** fell__ has joined #gnucash
16:51:16 *** gncbot sets mode: +o fell__
16:56:26 *** mlncn has quit IRC
16:57:36 <jralls> smw: Well, that article is what the trading accounts feature was based on, but although Selinger claims that realized gains are "implicitly recorded in the trading acount", that's not correct. It only records actual transactions.
16:57:38 *** mlncn has joined #gnucash
16:59:52 *** jimvideo has joined #gnucash
17:01:03 <smw> jralls: hm, looks like lots are what I should be using for this. I need to read up on this
17:01:16 *** fell_ has quit IRC
17:01:31 <jralls> smw: Be careful, the lots feature is finnicky.
17:03:43 <smw> jralls: that sounds scary. Got something for me to read on it?
17:08:34 <jralls> smw: http://wiki.gnucash.org/wiki/Concept_of_Lots
17:10:39 *** mlncn-agaric has joined #gnucash
17:11:37 <smw> jralls: yep, already reading
17:12:00 <smw> jralls: maybe I need to just get quickbooks :-P
17:12:57 <smw> damn it, thats right, quickbooks doesn't work on linux
17:13:36 <jralls> smw: Maybe. But bear in mind that lots doesn't do anything for you wrt unrealized gains. Have you tried the Advanced Portfolio Report?
17:14:03 <smw> nope, will look into that
17:15:00 *** mlncn has quit IRC
17:22:39 *** mlncn-agaric has quit IRC
17:39:23 *** kpreid has joined #gnucash
17:45:32 *** dwa1 has joined #gnucash
17:46:40 *** dwa1 has quit IRC
18:16:24 *** GabrieleV_ has joined #gnucash
18:16:32 *** GabrieleV has quit IRC
18:16:32 *** GabrieleV_ is now known as GabrieleV
18:30:49 *** Jimraehl1 has joined #gnucash
18:50:55 *** fell__ is now known as fell
18:51:18 <fell> jralls read my mail about the ocs error
18:51:24 <fell> docs
18:52:08 <fell> he was reading 2.4. It was fixed in 2.6
18:52:53 <jralls> fell: You mean the warning was fixed. The other bit wasn't.
18:53:25 <jralls> fell: Since you're looking at it, is the German ch_basics.xml correct in maint?
18:53:53 <jralls> I'm *really* slow at reading German.
18:54:22 <fell> I saw the mistake in the german translation and pushed the fix to both
18:55:04 <fell> If you improve something, I will update the german version again.
18:56:54 <jralls> Huh? You mean you fixed both in the warning, right? You didn't fix the third para?
18:58:04 <fell> let me see it was some time ago...
18:59:45 <fell> https://github.com/Gnucash/gnucash-docs/commit/a561ae6cc51d46461dcc028205df2cd40a97ece6
19:00:18 <fell> Only the warning
19:02:19 <jralls> OK. It looks to me like the German third para is completely different from the English one, not a translation at all.
19:05:30 <jralls> It doesn't seem to say anything about debits and credits. Maybe that's why you didn't notice an error there.
19:10:37 <jralls> As far as Google translate is able to do Japanese it looks OK, though it says "net assets" instead of Equity. I hope that's just a poor translation from Japanese and not an error in the doc.
19:10:46 <fell> Yeah, the floating text is totally different!
19:11:37 <jralls> Anyway, I've pushed my change to the English chapter.
19:14:15 *** kpreid has quit IRC
19:14:54 <fell> I believe the german localization was there before I joined.
19:16:08 <fell> Based on the different view - we use 2 column balance sheets, T-accounts, ... it is the continental view.
19:18:03 <fell> with a nice historical intro
19:21:06 <fell> It is on my todo list, to add a section with the historical continental approach to the english docs - at least for other continental translators.
19:24:32 <jralls> OK.
19:25:12 <jralls> My todo list is way too long already for something like that.
19:32:51 *** himaxx has joined #gnucash
19:45:58 *** ErKa has joined #gnucash
20:16:04 *** cartsoftware has quit IRC
20:27:30 *** GabrieleV_ has joined #gnucash
20:27:36 *** GabrieleV has quit IRC
20:27:36 *** GabrieleV_ is now known as GabrieleV
20:49:25 *** jralls has quit IRC
20:50:17 *** jralls has joined #gnucash
20:50:17 *** gncbot sets mode: +o jralls
21:21:31 *** GabrieleV_ has joined #gnucash
21:21:38 *** GabrieleV has quit IRC
21:21:38 *** GabrieleV_ is now known as GabrieleV
21:32:26 *** Jeff999 has joined #gnucash
21:34:12 *** Jeff999_ has quit IRC
21:56:29 *** mlncn-agaric has joined #gnucash
21:57:48 *** StuM has joined #gnucash
22:10:32 *** jralls has quit IRC
22:11:05 *** jralls has joined #gnucash
22:11:05 *** gncbot sets mode: +o jralls
22:16:55 *** AndreeeCZ has joined #gnucash
22:17:05 *** AndreeeCZ has left #gnucash
22:33:00 *** jralls has quit IRC
22:34:07 *** jralls has joined #gnucash
22:34:08 *** gncbot sets mode: +o jralls
22:34:25 *** kpreid has joined #gnucash
22:45:51 *** jralls has quit IRC
22:46:13 *** jralls has joined #gnucash
22:46:14 *** gncbot sets mode: +o jralls
23:08:51 *** sfrique has quit IRC
23:13:59 *** jralls has quit IRC
23:14:41 *** jralls has joined #gnucash
23:14:41 *** gncbot sets mode: +o jralls
23:50:00 *** sfrique has joined #gnucash