2015-11-27 GnuCash IRC logs
00:02:46 *** meb has joined #gnucash
00:51:45 *** meb has quit IRC
01:18:01 *** MechtiIde has joined #gnucash
02:41:17 *** len has quit IRC
02:49:10 *** meb has joined #gnucash
03:04:40 *** uXus has quit IRC
03:08:58 *** uXus has joined #gnucash
03:48:52 *** gour has joined #gnucash
03:52:42 *** autoditac__ has joined #gnucash
04:00:54 *** rubdos has quit IRC
04:04:16 *** autoditac__ has quit IRC
04:11:13 *** autoditac__ has joined #gnucash
04:17:01 *** MechtiIde has quit IRC
04:21:47 *** srbaker has joined #gnucash
04:28:45 *** lastmikoi has joined #gnucash
04:28:53 <lastmikoi> Hello there.
04:30:02 <lastmikoi> I'm trying to set up scheduled transactions 5 years in advance (long-term saving plan), but it would seem that, no matter what I put in the "Create in advance" field, it gets capped to 731
04:30:18 <lastmikoi> Is this hard limit alterable from the settings ?
04:35:16 *** gour has quit IRC
04:35:22 *** gour has joined #gnucash
04:38:27 *** srbaker has quit IRC
04:39:09 *** gour has quit IRC
04:47:16 *** fabior has joined #gnucash
05:03:33 *** srbaker has joined #gnucash
05:11:15 *** srbaker has quit IRC
05:14:43 *** gour has joined #gnucash
05:16:52 *** gour has joined #gnucash
05:17:38 *** gour has joined #gnucash
05:18:07 *** gour has quit IRC
05:19:43 *** gour has joined #gnucash
05:21:17 *** nomeata has joined #gnucash
05:30:11 *** srbaker has joined #gnucash
06:08:11 *** MechtiIde has joined #gnucash
06:16:17 *** gour1 has joined #gnucash
06:18:06 *** gour has quit IRC
06:21:50 *** gour1 is now known as gour
06:59:25 *** fabior has quit IRC
06:59:42 *** nomeata has quit IRC
07:21:17 *** nomeata has joined #gnucash
07:25:31 *** himaxx has joined #gnucash
07:28:22 *** himaxx has quit IRC
07:32:39 *** Jimraehl1 has joined #gnucash
08:03:17 *** fabior has joined #gnucash
08:08:39 *** srbaker has quit IRC
09:23:50 *** CDB-Man has joined #gnucash
09:24:02 *** CDB-Man_ has quit IRC
09:37:04 *** nomeata has quit IRC
09:40:22 *** fell_ has joined #gnucash
09:42:16 *** fell has quit IRC
10:17:12 *** warlord has quit IRC
10:40:27 *** MechtiIde has quit IRC
10:40:39 *** MechtiIde has joined #gnucash
10:42:41 *** mlncn has joined #gnucash
10:46:17 *** mlncn has quit IRC
11:23:41 *** MechtiIde has quit IRC
11:24:28 *** lastmikoi has quit IRC
11:25:16 *** MechtiIde has joined #gnucash
12:27:50 *** MechtiIde has quit IRC
12:28:06 *** MechtiIde has joined #gnucash
12:40:03 *** gnomey has joined #gnucash
12:47:41 *** karelk has quit IRC
12:53:50 <gnomey> although tax is a "liability", does it make sense to have tax payments go to liabilities:tax, for example?
12:54:15 <gnomey> or expenses:tax?
12:54:35 *** CharlesIC has joined #gnucash
12:54:44 <CharlesIC> hello, how do i see a list of all invoices?
12:55:28 <gnomey> CharlesIC: the documentation says to search for ".", but that does not work.. at least, not for me
12:55:58 <gnomey> i search for "0", and so far i'm lucky to not have reached 100000 invoices yet
12:56:28 <CharlesIC> oh, you have to click * again
12:56:32 <CharlesIC> search for *
12:56:33 <CharlesIC> hit enter
12:56:34 <CharlesIC> then hit find
12:57:38 <gnomey> CharlesIC: that works for you? for me, "*" matches nothing
12:58:51 <gnomey> ah, i got it to work with dot (".") by changing criteria to regex
12:59:10 <CharlesIC> oh ok
13:01:50 <CharlesIC> thnanks
13:01:51 <CharlesIC> thanks
13:01:51 *** CharlesIC has left #gnucash
13:02:56 *** MechtiIde has quit IRC
13:08:06 *** MechtiIde has joined #gnucash
13:19:30 *** gour has quit IRC
13:22:04 *** gour has joined #gnucash
13:35:23 *** fabior has quit IRC
14:09:26 *** gnomey has quit IRC
14:11:34 *** karelk has joined #gnucash
14:17:53 *** gnomey has joined #gnucash
14:18:31 *** MechtiIde has quit IRC
14:26:43 *** himaxx has joined #gnucash
14:28:20 *** himaxx has quit IRC
14:34:14 *** rubdos has joined #gnucash
14:54:06 *** gour has quit IRC
15:07:15 *** srbaker has joined #gnucash
15:34:55 *** srbaker has quit IRC
15:35:09 *** srbaker has joined #gnucash
15:52:22 *** mlncn_ has joined #gnucash
16:10:55 *** autoditac__ has quit IRC
16:12:57 *** autoditac__ has joined #gnucash
16:25:34 *** autoditac__ has quit IRC
16:27:22 *** autoditac__ has joined #gnucash
16:32:03 *** autoditac__ has quit IRC
16:32:56 *** azlev has joined #gnucash
16:33:03 <azlev> Hi, all
16:33:44 *** autoditac__ has joined #gnucash
16:33:48 <azlev> I'm trying to import transactions from an account from multiple ofx files. But just the first worked. Can someone help me?
17:08:21 *** autoditac__ has quit IRC
17:17:51 *** srbaker has quit IRC
17:18:41 <jralls> azlev: What went wrong with the subsequent imports?
17:30:04 *** meb has quit IRC
17:47:59 *** rubdos has quit IRC
17:48:34 *** rubdos has joined #gnucash
18:00:06 <azlev> jralls: 0 records
18:00:55 <azlev> and if I edit the ofx, I can see the records
18:03:09 <jralls> aslev: Then you probably had a lot of transactions that looked like duplicates to the matcher. They would have appeared red in the matcher window, so you'd need to check the A box for each of them.
18:04:14 <azlev> the matcher doesnt show any record
18:05:26 <azlev> itś the first time I'm using gnucash, so it can be my mistake
18:05:38 <azlev> I'm used to kmymoney
18:05:56 <azlev> but it doesnt play well in windows
18:10:10 <jralls> Well, GnuCash is a lot different from kmymoney (read the Tutorial and Concepts Guide) but that isn't what's making the OFX import fail. Each OFX dataset has a TRNUID file and the importer keeps track of which ones it has seen. That means that you can't re-run an OFX and it also means that if the different imports reuse the same TRNUID that only one will get imported.
18:11:00 <jralls> If the latter is what happened you can just edit each file and increment its number.
18:12:34 <azlev> let me check the ofx file
18:14:21 <jralls> Sorry, s/TRNUID file/TRNUID number/. The numbers must be different between files.
18:17:46 <azlev> they were the same, I edited and it dindt work yet
18:18:25 <azlev> how gnucash use bankid and acctid?
18:20:05 <azlev> I have those messages: http://paste.fedoraproject.org/295279/66372144
18:24:26 <jralls> I
18:25:45 <jralls> I don't know libofx's code so I can't interpret those info messages.
18:27:05 <azlev> ok
18:28:23 <jralls> Looking at the example data at http://www.ofx.net/OFXExamplesPage/OFXExamples.aspx, BANKID and ACCTID would be used for determining what root account -- you
18:29:10 <jralls> you'd set that once when you first import a file with that combo -- the transactions go to, and the matcher will help auto-select what the "other" account will be.
18:31:31 <jralls> Oh, I'm mistaken. Though I think TRNUID is significant, each individual transaction has an FITID that must also be different. Check your files for that. If the source is using a simple serialization in each file then that would explain your problem.
18:32:58 <jralls> The example data appears to use a date string (e.g. 980310) + a 3-digit serial number. The second transaction in the sample has 9803100001.
18:35:15 <azlev> all FITIDs are 0
18:35:31 <azlev> the first import worked, but others I need to change that
18:35:43 <jralls> That will do it. Where did the OFX files come from, kmymoney?
18:36:04 <azlev> my bank
18:36:31 <azlev> kmymoney doesnt use fitid I guess
18:36:47 <jralls> Huh. That's a surprise, I'd expect a bank to get the format right. Do they also export QIF?
18:37:13 <azlev> nope
18:37:39 <jralls> Bummer. Can you code? It will be a real PITA to change every FITID by hand.
18:41:31 <azlev> I can, but the user will be my mom, and thats the problem. And windows too
18:44:16 <azlev> damn damn state-owned banks :-(
18:45:03 <jralls> Well, you can write her a little utility that scans the file and creates an FITID from the date and a serial number. Unfortunately on Windows that means either writing it in a compiled language or installing a script language interpreter on her computer.
18:45:13 <azlev> other banks create the file correctly
18:45:26 <jralls> I guess VB would be the least work...
18:45:35 <azlev> powershell can do this
18:46:12 <jralls> Yes, but can you make a clickable utility with powershell?
18:47:41 <azlev> yes, I think
18:47:54 <azlev> like a clickable bash
18:51:39 <jralls> Well, that sounds like the easiest way, then.
19:01:15 *** fell_ has quit IRC
19:14:41 *** len has joined #gnucash
19:14:45 *** len__ has joined #gnucash
19:16:45 *** mournblade has joined #gnucash
19:30:57 *** rubdos has quit IRC
19:31:47 *** len has quit IRC
19:31:54 *** len__ has quit IRC
21:26:36 *** warlord has joined #gnucash
21:26:37 *** gncbot sets mode: +o warlord
21:32:54 *** mlncn_ has quit IRC
21:48:27 *** meb has joined #gnucash
23:19:59 *** mlncn_ has joined #gnucash
23:51:33 *** mlncn_ has quit IRC