2010-09-25 GnuCash IRC logs
01:01:03 <aneonoe> Hello, I only can import ofx files one by one ? How to import several files (with several accounts inside) in one click ?
01:01:15 <aneonoe> Thx for help.
01:02:04 <aneonoe> Indeed, I a am new (and happy) user. And I have about 20 ofx files to import...
01:26:20 *** jak has quit IRC
07:08:01 *** Jimraehl has left #gnucash
07:17:20 *** cortana has joined #gnucash
07:18:22 *** Jimraehl has joined #gnucash
07:23:35 *** seyfi has joined #gnucash
07:25:37 <seyfi> I have 2 accounts with same name but different parents, or an account has the same name as its parent. Are these not allowed?
07:27:49 <seyfi> GC did not complain while editing the hierarchy like that, but when I converted it into a template and loaded via the druid, accounts with same names vanished.
07:30:41 <seyfi> hmm, they only vanish on hierarchy page. Drop down list box on journal shows them all.
07:52:27 *** Askarii has joined #gnucash
08:00:02 <jsled> interesting bug. there's nothing wrong with accounts with the same name; accounts have an internal guid as their identity.
08:08:21 <seyfi> jsled: did you also observe it? if not I can send the account template causing this.
08:08:59 <jsled> not observed, no.
08:12:31 <seyfi> http://wikisend.com/download/612708/acctchrt_kodluTEKDUZ.gnucash-xea.gz
08:25:39 *** warlord-afk is now known as warlord
08:25:59 <warlord> aneonoe: Unfortunately you cannot; the ofx importer can only import 1 at a time.
08:26:38 <warlord> sibling accounts cannot have the same name.
08:26:47 <warlord> that's the only restriction.
08:33:32 <seyfi> I posted a dl link for the said account template. It has top level accounts named 1 to 9 , but only 1 and 7 appears on accounts page.
08:34:04 <seyfi> xmllint did not print any errors
08:34:19 <seyfi> I can see the full hierarcy even on druid's preview pane
08:36:45 <warlord> seyfi: have you perhaps set those accounts to hidden?
08:36:53 <warlord> VIew -> Show Hidden Accounts ?
08:37:03 <seyfi> yes, I checked that, no change
09:01:07 <warlord> Hmm, jsled, do XEA accounts need a ROOT account?
09:02:04 <warlord> seyfi: another possibility is placeholder v. non-placeholder
09:02:35 <warlord> seyfi: can you create a minimal xea file that exhibits the problem?
09:04:51 <seyfi> warlord: not sure, because I don't know what causes the problem. Does the one I posted give no clues? at least, can you repeat the prob?
09:05:32 <warlord> I have not tried it. I was just looking through the XEA file and, well, it's huge.
09:05:36 <warlord> Let me try
09:06:29 <seyfi> just compare what shows on druid's preview pane and then account page. that's it, pretty simple to repeat.
09:07:46 <warlord> I only see 1 and 7B top-level
09:08:03 <seyfi> yes, why do the others vanish?
09:08:14 <warlord> I dont know. duplicate GUIDs?
09:08:52 <seyfi> hm, I exported the account I created by hand. Is that not enough?
09:09:36 <seyfi> for unique guids I mean
09:10:41 <warlord> it should be. I dont see any dups.
09:11:22 <warlord> OTOH, you need to change <act:id type="guid"> to <act:id type="new">
09:11:30 <warlord> (not sure if that matters)
09:12:40 <seyfi> I just changed the name of top level 2 to 2a in the template, and it appeared in my new file. I guess this is related to names.
09:13:22 <warlord> OH, WAIT... What's in the account tree *DOES* match what's in the setup!
09:14:04 <warlord> Okay, it's something in the hierarchy druid.. because the 'chose accounts to create' page has one set, but then moving forward to the 'setup new accounts' page I only see 1 and 7B
09:16:08 <warlord> it's definitely a bug; i dont know where
09:18:00 <warlord> i recommend you file a bug report and upload the xea file to the report.
09:18:15 <seyfi> ok
09:36:55 *** warlord is now known as warlord-afk
09:45:25 *** Krumar has joined #gnucash
09:59:57 *** bentob0x has joined #gnucash
10:03:15 *** Askarii1 has joined #gnucash
10:04:52 *** remarkable has joined #gnucash
10:05:54 *** remarkable has left #gnucash
10:09:04 *** Askarii has quit IRC
10:10:50 *** zangbot has joined #gnucash
10:11:17 *** zangbot has left #gnucash
10:13:39 *** seyfi has quit IRC
10:20:30 *** kpreid has quit IRC
10:21:25 *** zangbot has joined #gnucash
10:26:49 <zangbot> first time in this room. Gnucash user for 5+ years, currently 2.3.13 r19217 (I know, "unstable" release) on Fedora 13 x86_64 2.6.43 kernel
10:27:06 <zangbot> Two questions:
10:27:45 <zangbot> 1: Haven't seen much discussion regarding pros/cons of sqlite vs mysql db backend.
10:29:18 <zangbot> 2: since I started using mysql backend, I find translog.yyyymmddhhmiss.log files in $HOME. Can I redirect these elsewhere?
10:39:24 <jsled> 1: mysql rules! sqlite drools! ;)
10:40:04 <jsled> 2/ they're placed in the working directory, IIRC, so you might want to start gnucash in /tmp to have them be cleaned up or kept out of the way. I don't believe there's a preference or anything for where to put them
10:49:49 *** Krumar has quit IRC
10:50:02 <zangbot> Thanks. I've been leaning toward mysql, as I am an Oracle DBA, and it's a little more like what I know that sqllite is. If I'm starting gnucash from a menu item or panel icon (gnome desktop), any idea how I would specify a "start in" directory?
10:51:29 <zangbot> I guess I could specify a "wrapper" script in the menu/icon that does a cd to "start in" dir.
11:16:31 *** cortana has quit IRC
11:16:51 *** warlord-afk is now known as warlord
11:17:22 <warlord> the bonus of sqlite is that it can get treated just like a file. You can make a backup via "cp". You can "mv" it to rename, and the .log files live in the same location.
11:17:41 <warlord> mysql requires more DB Admin experience on the part of the user to properly secure it.
11:24:15 *** cortana has joined #gnucash
11:32:18 <aneonoe> warlord: ok thx. Neverminds, I am convinced by the utility of gnucash and I enjoy it!
11:32:44 <warlord> :)
11:44:43 *** warlord is now known as warlord-afk
12:10:44 *** svetoslav has quit IRC
12:23:37 *** Krumar has joined #gnucash
12:45:49 *** Askarii1 has quit IRC
12:46:43 *** ErKa has joined #gnucash
13:05:55 *** blizgerg has quit IRC
13:31:50 *** ErKa has quit IRC
13:36:28 *** seyfi has joined #gnucash
13:41:46 <seyfi> Until now, I thought every parent account has to be a placeholder, but there's no such requirement AFAICS.
13:42:02 <seyfi> So what's the purpose of being parent without being place holder?
14:26:39 *** Askarii has joined #gnucash
15:30:39 *** bentob0x has quit IRC
15:50:43 *** ErKa has joined #gnucash
16:03:36 *** seyfi has quit IRC
16:43:53 *** ErKa has quit IRC
17:52:02 *** Linuturk has quit IRC
17:55:56 *** warlord-afk is now known as warlord
17:56:12 <warlord> placeholder means no transactions go into the account; it's sole purpose is to be the parent of other accounts.
18:05:03 *** kpreid has joined #gnucash
18:07:25 *** cortana has quit IRC
18:14:37 *** warlord is now known as warlord-afk
18:17:48 *** cortana has joined #gnucash
20:19:24 *** cortana has quit IRC
22:48:39 *** Askarii has quit IRC
23:52:26 *** Linuturk has joined #gnucash