2013-01-08 GnuCash IRC logs

00:18:59 *** nafg has quit IRC
00:19:36 *** nafg has joined #gnucash
02:20:30 *** john has joined #gnucash
02:20:30 *** gncbot sets mode: +o john
02:39:34 *** ErKa has quit IRC
02:50:03 *** john has quit IRC
03:17:44 *** ecocode has joined #gnucash
04:31:17 *** Jimraeh1 has joined #gnucash
04:50:08 *** fabior has joined #gnucash
04:59:47 *** Neca has joined #gnucash
04:59:53 <Neca> Hello!!!!!
05:00:39 <Neca> I need to know how to add Summary Account (Total, Future, Cleared, Reconcilied) in a Summary report.
05:00:39 <Neca> Any one can help me edting the source code report? The two most important think is to show the Total (OK by default) and the Cleared. that value i can't figure.
05:01:51 <Neca> Transaction Report i mean.
05:07:51 *** nafg has quit IRC
05:08:59 *** nafg has joined #gnucash
05:24:38 *** aqua___ has joined #gnucash
06:07:21 *** aqua___ has quit IRC
06:18:17 *** aqua___ has joined #gnucash
06:18:34 *** Keeper_of_the_Keys has quit IRC
06:20:28 *** talso has quit IRC
06:22:10 *** talso has joined #gnucash
06:27:21 *** Jimraeh1 has quit IRC
06:36:14 <Neca> I need to know how to add Summary Account Details in Trasaction Report (Total (OK), Future, Cleared, Reconcilied)? any ideias?
07:04:38 *** Jimraeh1 has joined #gnucash
07:07:08 *** nafg has quit IRC
07:19:50 *** dfive has joined #gnucash
07:40:48 *** Controlsfreek has quit IRC
07:43:29 *** dfive has quit IRC
07:48:55 <warlord> Neca: I dont think I understand what you are trying to do.. or why?
07:49:42 <warlord> You would need to modify the report to collect the sums, but I don't understand why you'd want or need that in a report.
07:58:56 *** fabior has quit IRC
08:02:42 *** uXus has quit IRC
08:05:05 *** daniel_ has joined #gnucash
08:16:17 *** aqua_ has joined #gnucash
08:17:08 *** Neca has quit IRC
08:17:18 *** Neca has joined #gnucash
08:18:40 *** aqua___ has quit IRC
08:22:26 *** GabrieleV_ has joined #gnucash
08:23:51 *** GabrieleV has quit IRC
08:23:51 *** GabrieleV_ is now known as GabrieleV
08:31:57 *** aqua_ has quit IRC
08:36:26 *** aqua_ has joined #gnucash
09:09:57 <Neca> Warlord: thanks
09:10:31 <warlord> Neca: you're welcome.
09:11:10 <Neca> warload: sorry, i am in phone
09:12:59 <Neca> at first, or "now" i only need to show the actual "cleared or reconciled" value, the value present in "summary bar". sorry for my english :) and i am nervours because my boos is a woman and she is pressing me :P
09:15:04 <Neca> eg: after the sums (total for that accounts) i need to print Total xxxx.xxx (Cleared: xxxxx)
09:16:31 *** KaiForce has joined #gnucash
09:17:41 <Neca> she manage the business, using plafonds, so is important to have that value in transaction reports. i can put "reconcile date" and i will trye manage a way to put "X" replacing the date (X indicated is reconciled), because the date is not important to us.
09:17:42 <warlord> Neca: I still don't understand why you need to do that when you have that information on your bank statements.
09:18:08 <warlord> I dont know what a "plafond" is
09:18:33 <warlord> In any case, you would need to modify the .scm to implement it.
09:19:45 <Neca> yes, i now that, but i don't know why.
09:20:31 <Neca> i have opened the report, i really don't understand to much...
09:21:02 <Neca> speaking with experts i think i can learn
09:21:21 <warlord> Let's take a step back, because maybe there is another report that will work for you.
09:21:30 <warlord> What information, exactly, do you need to put into a report?
09:23:23 *** fabior has joined #gnucash
09:23:45 <Neca> firstly, i use transaction.scm and perfectly works to my needs. i only information i need for know is the Reconciled value or cleared. give 5 minutes, i will put a link to a screen shot ok?
09:24:05 <warlord> A screen shot of what you need?
09:25:33 <Neca> just for clarify :) and i am sure you will understand
09:25:38 <Neca> ok?
09:26:12 <warlord> go for it
09:29:13 *** arnotixe has joined #gnucash
09:33:05 <Neca> warlord: http://cersize.com/gnu.png
09:33:27 <warlord> Neca: BIAB..
09:33:49 <Neca> translate!!!! :P
09:34:14 <warlord> Back in a Bit. (having breakfast)
09:34:34 <Neca> sure
09:34:43 <Neca> thanks
09:39:22 *** dfive has joined #gnucash
09:52:46 *** aqua_ has quit IRC
09:53:11 *** aqua___ has joined #gnucash
10:02:47 <warlord> Neca: back.
10:03:33 <warlord> Okay, to add those to the report.... I'm not sure you necessarily want a Transaction report -- it almost looks like you want a Register Report. At least in the pic you show only a single account.
10:07:57 <Neca> hum
10:08:21 *** aqua___ has quit IRC
10:08:24 <Neca> i have tested my needs and i think i need transaction report
10:08:39 <Neca> i have many accounts, i this example i only use onbe
10:09:31 <warlord> Ah, okay.
10:09:46 <warlord> Note that the 'reconciled balance' et al is all "per account"
10:09:57 <Neca> yes
10:10:00 <Neca> i konw.
10:10:15 <warlord> So I'm not sure how that really maps to a transaction report, which is more reporting on transactions than on accounts.
10:10:48 <Neca> i will try to change the reconciled date to a simple char, because a dont need the date, only a "R" indicate that is reconciled...
10:11:33 <warlord> Why not turn on the 'reconciled date' column?
10:12:09 <Neca> yes, and its ok for me... but that is a minor problem...
10:12:39 <warlord> problem?
10:12:42 <Neca> i will find a way without help. the problem is the one to put these values after totals
10:13:15 <Neca> forget the reconciled date... i think i am confusing you
10:13:28 <Neca> look at my image, in red
10:14:05 <warlord> Yes, I see it. You would need to add additional accumulators to keep track of the cleared and reconciled balances.
10:15:04 <Neca> hum. just to know, i do't need accumulators relative to date, just the actual value. you understand?
10:15:33 <warlord> Yes.. You still need the accumulator. That's what the "sum" object is called in the source
10:15:41 <warlord> "commodity-collector"
10:17:21 <Neca> right
10:18:15 <warlord> You'll need one per account per type (reconciled, cleared).. and possibly another for 'future', but that might be much harder. I still don'
10:18:22 <warlord> t understand why you need this info in the report.
10:19:02 <Neca> yes, the future is not a problem, and in a limit i only need one of them (cleared ou reconciled)
10:19:56 <warlord> If you add the code for one it's simple to add the code for the other -- it's effectively the same code, just with a different flag to test for whether to add the transaction to the collector
10:20:07 <Neca> but i can imagine if i can do for one, it will be easy to add to another
10:20:11 <Neca> :P
10:20:14 <Neca> yes.
10:20:41 *** aqua___ has joined #gnucash
10:21:25 <Neca> i really aprreciate your help, and i am zero in programming as i am not a TI man
10:21:55 <warlord> Scheme is pretty easy to learn, IMHO. For a long time it was used in an Intro to CS class at MIT.
10:22:04 *** fabior has quit IRC
10:23:56 <Neca> do you think you can do it for me? sorry if i am abuse of my lucky!!!!!
10:24:07 *** dfive has quit IRC
10:24:14 <warlord> Sorry, I dont have the time for that right now.
10:25:53 <Neca> no problem, any examples you can give to me? which flags to use etc?
10:26:21 *** uXus has joined #gnucash
10:30:01 <warlord> Just take a look at the existing code to see how it computes the total.
10:32:38 <Neca> ok
10:32:42 <Neca> one more question
10:32:46 <Neca> imagine that gnc-split-get-date-reconciled
10:32:49 <warlord> Or you could just run 'xaccSplitGetClearedBalance' as of the last split in the account.. (and possibly use the same at the beginning to subtract)
10:33:03 <warlord> (and similarly xaccSplitGetReconciledBalance)
10:33:44 <Neca> hum....
10:34:28 <Neca> i think we are doint progress
10:34:30 <Neca> doing
10:34:39 <warlord> Note that this will not work properly if you filter out anything.
10:34:42 <Neca> lets me do some tests... you will be here?
10:34:47 <warlord> I'll be around.
10:34:51 <warlord> It's only 10:30am here.
10:34:58 <Neca> 15h34!!!!
10:35:06 <Neca> i am from Portugal, and you?
10:35:59 <warlord> USA
10:36:11 <warlord> GMT-02
10:36:15 <warlord> er, GMT-05
10:36:21 <Neca> ya
10:36:25 <Neca> ok man thanks...
10:36:33 <Neca> i will keep in touch...
10:36:37 <warlord> good luck.
10:36:50 <Neca> thanks
10:41:02 *** Bente_ has quit IRC
10:41:23 *** Bente_ has joined #gnucash
10:44:43 <Bente_> hi, I have an unanswered question a few days ago about an error in the report: advanced portfolio. Can someone help? I also need to find the OFX-tags: ORG and FID for one of the workds largest banks HSBC
10:50:13 *** aqua___ has quit IRC
10:50:56 *** ErKa has joined #gnucash
11:06:05 *** aqua___ has joined #gnucash
11:19:15 <warlord> Bente_: what is the report error? And I don't understand the second question about OFX tags.. What do you mean "need to find them"? They are in the downloaded OFX file.
11:28:38 *** dfive has joined #gnucash
11:42:47 *** dfive has quit IRC
11:43:12 *** mikee_ has joined #gnucash
11:44:34 *** mikee has quit IRC
11:44:47 *** mikee_ is now known as mikee
11:44:51 <mikee> @op
11:44:51 <gncbot> mikee: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
11:44:58 <mikee> @op
11:44:58 <gncbot> mikee: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
11:45:10 <mikee> @op
11:45:11 *** gncbot sets mode: +o mikee
11:59:18 *** aqua___ has quit IRC
12:41:21 *** john has joined #gnucash
12:41:22 *** gncbot sets mode: +o john
12:53:03 *** michel has joined #gnucash
12:58:08 <michel> Hello, does anyone now how I can split a transaction wrt dates. For example, I pay 1200 dollar this month, but I like to see this payment (in the reports) 12 times 100 dollar each month.
12:58:39 <michel> Thanx in advance..
13:00:19 *** ecocode has quit IRC
13:00:30 <warlord> michel: you need to use a suspense account for that.. Cash -> Suspense. Then Suspense -> Expense every month.
13:01:52 <michel> Ah let me try that..
13:05:11 <michel> warlord: do you mean the account type is 'cash' and the account name should be 'suspense'?
13:28:25 <warlord> No, there is no type 'suspense'. In this case it should be an asset.
13:28:39 <warlord> and '->' means 'transfer'
13:34:08 <michel> warlord: ok, now I created a transaction for every month on the suspense asset. Now the reports look good again, thank you
13:34:19 <warlord> you are welcome
13:47:48 <Bente_> Warlord: Under "reports, assets and liabilities there is an option: advanced portfolio. When I choose it, it says report error. There was a problem creating the report.
13:48:13 <warlord> Bente_: okay, and what's printed in your gnucash.trace?
13:48:59 <Bente_> How do i find that?
13:50:45 <warlord> Try in /tmp
13:55:30 <Bente_> Could this be it? iption notes memo action reconciled amount value date_reconciled
13:55:30 <Bente_> -----------------
13:55:30 <Bente_> ===== START
13:55:30 <Bente_> ===== END
13:55:30 <Bente_> ===== START
13:55:31 <Bente_> ===== END
13:56:39 <warlord> That looks like a log file, not /tmp/gnucash.trace
13:57:24 <Bente_> No, sorry, here is is: * 19:45:12 WARN <Gtk> Failed to set text from markup due to error parsing markup: Fejl p� linje 1 tegn 26: Element "b" blev lukket, men aktivt �bent element er "i"
13:57:24 <Bente_> * 19:45:12 WARN <Gtk> Failed to set text from markup due to error parsing markup: Fejl p� linje 1 tegn 26: Element "b" blev lukket, men aktivt �bent element er "i"
13:57:24 <Bente_> * 19:45:12 WARN <Gtk> Failed to set text from markup due to error parsing markup: Fejl p� linje 1 tegn 26: Element "b" blev lukket, men aktivt �bent element er "i"
13:57:24 <Bente_> * 19:45:12 WARN <qof.engine> [guid_init()] only got 1793 bytes.
13:57:25 <Bente_> The identifiers might not be very random.
13:57:27 <Bente_> * 19:53:51 WARN <gnc.scm> In C:\Program Files (x86)\gnucash\share\gnucash/guile-modules/gnucash/report/standard-reports/advanced-portfolio.scm:
13:57:30 <Bente_> ...
13:57:32 <Bente_> 344: 441 (let* (# # # # ...) (for-each # #) (set! use-txn #) ...)
13:57:34 <Bente_> 657: 442* (if (or include-empty #) (let* # # ...) ...)
13:57:36 <Bente_> 741: 443 [table-add-stock-rows-internal (# # # # ...) #t]
13:57:38 <Bente_> ...
13:57:42 <Bente_> 344: 444 (let* (# # # # ...) (for-each # #) (set! use-txn #) ...)
13:57:44 <Bente_> 657: 445* (if (or include-empty #) (let* # # ...) ...)
13:57:46 <Bente_> 741: 446 [table-add-stock-rows-internal (# # # # ...) #t]
13:57:48 <Bente_> ...
13:57:50 <Bente_> 344: 447 (let* (# # # # ...) (for-each # #) (set! use-txn #) ...)
13:57:52 <Bente_> 657: 448* (if (or include-empty #) (let* # # ...) ...)
13:57:54 <Bente_> 658: 449 (let* (# # # ...) (total-value # # ...) ...)
13:57:56 <Bente_> 696: 450* (if show-price (append! activecols (list #)))
13:57:56 <warlord> Bente_: STOP!
13:57:58 <Bente_> 696: 451 [append! (# # # #) ...
13:58:00 <Bente_> 696: 452* [list ...
13:58:01 <warlord> Bente_: use pastebin!
13:58:02 <Bente_> 696: 453* [gnc:make-html-table-header-cell/markup "number-cell" ...
13:58:04 <Bente_> 698: 454* (if use-txn (gnc:html-transaction-anchor pricing-txn price) ...)
13:58:06 <Bente_> 699: 455 [gnc:html-transaction-anchor #f #]
13:58:08 <Bente_> In C:\Program Files (x86)\gnucash\share\gnucash/scm/html-utilities.scm:
13:58:12 <Bente_> 97: 456 [gnc:make-html-text ...
13:58:14 <Bente_> 97: 457* [gnc:html-markup-anchor ...
13:58:16 <Bente_> 98: 458* [gnc:transaction-anchor-text #f]
13:58:18 <Bente_> 44: 459 [gnc:register-guid "trans-guid=" ...
13:58:20 <Bente_> 44: 460* [gncTransGetGUID #f]
13:58:22 <Bente_> C:\Program Files (x86)\gnucash\share\gnucash/scm/html-utilities.scm:44:36: In procedure gncTransGetGUID in expression (gncTransGetGUID trans):
13:58:25 <Bente_> C:\Program Files (x86)\gnucash\share\gnucash/scm/html-utilities.scm:44:36: Wrong type argument in position 1: #f
13:58:47 <warlord> Bente_: in the future please use pastebin -- do NOT cut-and-paste > 3 lines!
13:59:42 <warlord> Looks like you have a bad transaction, but I dont know how that would happen.
14:00:20 <Bente_> Sorry, I do not know the pastebin option, as I am just an ordinary user not a technician
14:01:01 <warlord> pastebin is a website for pasting text so you dont flood IRC
14:01:24 <warlord> regardless, too late now.
14:01:31 <warlord> next time, dont cut-and-paste. it's rude
14:02:06 <Bente_> OK, will ask a friend how to do in the future. Can I repair this report or see, what transaction went wrong?
14:02:20 <warlord> anyways, it looks like it's getting an empty list.. What version of gnucash is this?
14:02:35 <warlord> Bente_: http://pastebin.org
14:02:38 <warlord> (IIRC)
14:02:44 <warlord> or google for "pastebin"
14:03:21 <Bente_> latest stable version, it was downloaded a month ago
14:03:52 <warlord> Please tell me the full version, just to be sure.
14:04:03 <warlord> Also, what OS/Distro? (not that it makes a huge difference)
14:04:43 <Bente_> 2.4.11 on windows7
14:05:35 <warlord> ok.
14:06:34 <warlord> Try editing the report options and change the quote source?
14:06:43 <Bente_> will do
14:11:57 <warlord> What quote source did you have set? Probably "weighted average"? Also, what account(s) do you have selected?
14:21:39 <Bente_> Mostly yahoo europe, but also Nasdaq and NYSE. This time I just chose one one my investment accounts with about 10 shares in it, but is still says the same. However it does give me the report investment porfolio, but most of the values are 0. Does it mean anything that I named alle the shares I've sold years ago "template"?
14:23:34 <warlord> AH, yes, that would be BAD!!!
14:23:36 <warlord> VERY bad.
14:23:50 <warlord> And unfortunately the only way to fix it is by manual edit of your datafile.
14:24:00 <Bente_> And does it mean anything that I chose to have only one account for dividends and one for interest,instead of one per share
14:24:03 <warlord> (Geeze, that bug bites more people...)
14:24:12 <warlord> That I don't know.
14:24:25 <warlord> But using 'template' for your stock namespace is very VERY bad.
14:24:56 <warlord> It is not supposed to be used -- it's for internal use only.. but there is a bug making it visible in one bad place.
14:25:09 <Bente_> OK tell me what is meant by template, as I do not want all the shares I do not own any longer to be in my report
14:25:53 <Bente_> I just named them template to get rid of them
14:26:31 <warlord> the template namespace is for use internally ..
14:26:44 <warlord> (I dont recall what it's used for -- I think it's part of the Scheduled Transaction system)
14:27:24 <Bente_> understand, I'll rename them all, but how do I get rid of them?
14:37:35 <warlord> Not sure what you mean by "get rid of them"?
14:43:56 <Bente_> Meaning I do not want to include old shares in my reports, but I just found out that I can "hide" them. Do I need to rename them then?
14:48:48 *** Topcat has joined #gnucash
14:53:39 *** Topcat has quit IRC
14:54:09 *** aqua___ has joined #gnucash
14:55:12 *** Topcat has joined #gnucash
14:58:33 <Bente_> warlord, I've tried to rename my old shares from template to eurex before hiding them, but I cannot make it work! How do I change the templates into eurex?
15:05:36 *** Topcat has quit IRC
15:05:59 *** Topcat has joined #gnucash
15:06:29 *** ErKa has quit IRC
15:08:32 <warlord> No, you do not need to rename them
15:09:08 <warlord> Bente_: like I said earlier, you cannot do it in the UI (because you shouldn't been able to access template in the first place!) The only way to fix it is hand-editing the data file. Please read the mailing list archives on this.
15:21:10 *** Topcat has quit IRC
15:21:33 *** Topcat has joined #gnucash
15:27:59 *** daniel_ has left #gnucash
15:36:20 *** john has quit IRC
15:40:26 *** KaiForce has quit IRC
15:50:38 *** aqua___ has quit IRC
16:08:30 *** Topcat has quit IRC
16:25:18 *** Bente_ has quit IRC
16:42:39 *** john has joined #gnucash
16:42:39 *** gncbot sets mode: +o john
16:55:07 *** ErKa has joined #gnucash
17:17:29 *** michel has quit IRC
17:24:14 *** benoitg has joined #gnucash
17:48:02 *** benoitg has quit IRC
19:26:58 *** nafg has joined #gnucash
19:29:23 <Helio_> ok, this is strange, I reconcile subaccounts, and if I have a transfer between two subaccounts in the group, when I reconcile on one side, it clears it on the other side.
19:43:57 *** Getty has quit IRC
20:24:38 *** pnema has joined #gnucash
20:44:30 *** Controlsfreek has joined #gnucash
20:54:44 *** Getty has joined #gnucash
21:04:17 *** john has quit IRC
21:10:27 *** pnema has quit IRC
21:34:18 *** DimStar_ has joined #gnucash
21:38:05 *** DimStar has quit IRC
22:05:03 *** kpreid has quit IRC
22:05:36 *** kpreid has joined #gnucash
22:47:24 *** ErKa has quit IRC