2009-07-11 GnuCash IRC logs

00:46:42 *** Jimraehl has left #gnucash
00:56:19 *** Jimraehl has joined #gnucash
02:20:02 *** MechtiIde has joined #gnucash
03:19:56 *** Bearman has quit IRC
03:28:45 *** Bearman has joined #gnucash
05:41:49 *** MechtiIde has quit IRC
06:01:04 *** cortana has joined #gnucash
06:44:55 *** phil has joined #gnucash
07:03:06 *** phil has quit IRC
07:04:04 *** phil has joined #gnucash
07:04:09 *** nomeata has joined #gnucash
07:25:13 *** Abu_Hady has joined #gnucash
07:28:44 <Abu_Hady> ding dong
07:34:10 *** warlord-afk is now known as warlord
07:38:50 *** MechtiIde has joined #gnucash
07:54:47 *** Abu_Hady has left #gnucash
08:22:39 *** andyt has joined #gnucash
08:48:23 *** nomeata has quit IRC
08:58:17 *** phil_ has joined #gnucash
09:03:36 *** nimrod has joined #gnucash
09:03:45 *** nimrod has left #gnucash
09:05:22 <Jimraehl> I submitted a patch in bug 587853 (Gnucash 2.3.1 transaction log open fails). This fixes that bug, and fixes the GUI File > Open error message that resulted from the fix to bug 585939 (Opening XAC file crashes Gnucash Windows 2.3.1).
09:05:35 *** phil has quit IRC
09:06:06 <Jimraehl> Phooey. I was hoping Phil saw that.
09:07:25 <warlord> hopefully he'll come back
09:13:15 <Jimraehl> Is there a way to restrict "svn diff" to just a folder in src (like engine), or even better just one file?
09:14:42 <Jimraehl> I did CD to /soft/gnucash/repos/src before running "svn diff" but that command apparently looks at the entire src folder structure.
09:17:25 *** cort has joined #gnucash
09:18:21 *** cortana has quit IRC
09:28:52 <warlord> sure, svn diff <path>
09:30:38 <Jimraehl> Thanks
09:36:54 <Jimraehl> When I execute my built Gnucash 2.3.2 (with AQBANKING_WITH_QT=no and AQBANKING3=yes, in custom.sh) I get SQL library error messages:
09:37:11 <Jimraehl> Error code 1(126) while loading library o:/soft/libdbi-drivers/lib/dbd\libdbdmysql.dll
09:37:11 <Jimraehl> libdbi: Failed to load driver: o:/soft/libdbi-drivers/lib/dbd\libdbdmysql.dll
09:37:12 <Jimraehl> Error code 1(126) while loading library o:/soft/libdbi-drivers/lib/dbd\libdbdpgsql.dll
09:37:12 <Jimraehl> libdbi: Failed to load driver: o:/soft/libdbi-drivers/lib/dbd\libdbdpgsql.dll
09:38:06 <warlord> do those dlls exist?
09:39:25 <Jimraehl> Sure looks like they do.
09:39:52 <Jimraehl> I think they would be found, except for the \ in the path.
09:39:56 <warlord> i wonder if it's a mixed-path thing?
09:40:12 <warlord> Do the daily builds work?
09:40:23 <Jimraehl> That's my guess, but I don't know where to look.
09:41:56 <Jimraehl> The daily builds don't emit the messages, but what is the setting for AQBANKING_WITH_QT in the daily builds? I'm thinking the mangled path occurs due to saying "no".
09:43:47 <warlord> It's set to the default.
09:44:57 <warlord> There are only 4 settings in custom.sh:
09:45:07 <warlord> MSYS_DIR=c:\\msys\\1.0
09:45:07 <warlord> QTDIR=/c/Qt/2009.02/qt
09:45:07 <warlord> UPDATE_SOURCES=yes
09:45:07 <warlord> NO_SAVE_PROFILE=yes
09:47:07 <Jimraehl> The default is yes, which is opposite of no.
09:51:42 <warlord> well, that could be one place to look in the logic.
09:54:15 <Jimraehl> I tried, but didn't see anything that looked suspicious. I also just searched all the sources for libdbdpgsql.dll and libpq.dll and turned up no hits.
09:56:09 <Jimraehl> The only reference to libpq.dll in /soft/packaging is a test for its existence, which looks okay.
09:57:16 <warlord> Hmm
10:46:04 *** nimrod has joined #gnucash
10:46:48 *** nimrod has left #gnucash
11:01:11 *** Jimraehl has left #gnucash
11:08:07 *** JimRaehl2 has joined #gnucash
11:11:23 *** JimRaehl2 has left #gnucash
11:11:41 *** JimRaehl2 has joined #gnucash
11:17:36 *** Bearman has quit IRC
11:45:29 *** mib_at13g4 has joined #gnucash
11:45:50 <mib_at13g4> anyone active?
11:46:27 <mib_at13g4> Does anyone know how to launch a specific GnuCash account via a shortcut?
11:48:44 <jsled> do you mean open a specific Account's register?
11:48:51 <jsled> I don't believe there are any shortcut bindings for that.
11:49:09 <warlord> mib_at13g4: i know of no way to automatically open a register via a shortcut.
11:49:10 <jsled> But you should be able to work the keyboard navigation of the relevant widgets to make it happen via the keyboard.
11:49:17 <mib_at13g4> No, I want to open say - Personal Accounts with a shortcut and Business accounts with another shortcut
11:49:22 *** phil has joined #gnucash
11:49:36 <jsled> mib_at13g4: two different datafiles?
11:49:42 <mib_at13g4> Yes
11:49:52 <jsled> so, at the desktop/icon level, you're asking?
11:50:03 <mib_at13g4> Yes
11:50:22 <mib_at13g4> I would imagine there would be a startup command to open specific datafiles
11:50:46 <mib_at13g4> gnucash?=personalaccounts or some type of command to open it.
11:51:18 <mib_at13g4> Right now, it always opens the "open file with" box when I select the datafile I want to open
11:51:54 <jsled> just `gnucash /path/to/datafile` will work.
11:51:57 <warlord> Ahh... "gnucash <file>"
11:52:59 <mib_at13g4> gnucash and the name of the datafile? LOL, if it's that simple I'm going to slap myself. Man what a brain fart that will have been...Let me try it out...
11:53:12 <jsled> you can make an icon for that, if you want. If you use one of the extensions ".gnucash", ".gnc" or ".xac" for your datafile, then you should be able to double-click on the file in any common file-manager.
11:53:19 <jsled> (well, any reasonable file-manager. :)
11:54:25 <mib_at13g4> what do you mean use the extension? Doesn't it already have that extension?
11:54:34 <mib_at13g4> Oh wait...I know what you mean
11:54:59 <mib_at13g4> Add it to the list of file extensions and have it automatically open those type of files with gnucash?
11:55:02 <jsled> gnucash does not enforce or even promote any extension
11:55:36 <jsled> well, the "shared-mime-info" package from freedesktop.org that most distros ship and install already has the mapping.
11:56:18 <jsled> But, yeha, it might take some mapping in the filemanager now that I think about it.
11:56:32 <mib_at13g4> let me try this out..brb
11:57:05 <jsled> It's not like it's almost 2010 or anything and this should just f'ing work … but I'm really glad GNOME's re-building damn sticky note applications!
11:59:38 <mib_at13g4> In my datafile directory I see a few different files .log .xac and one file that doesn't seem to have an extension
12:00:02 <mib_at13g4> Which one do I try to open with gnucash?
12:05:53 <JimRaehl2> phil: I submitted a patch in bug 587853 (Gnucash 2.3.1 transaction log open fails). This fixes that bug, and fixes the GUI File > Open error message that resulted from the fix to bug 585939 (Opening XAC file crashes Gnucash Windows 2.3.1). Are you the likeliest person to check that patch, and if you like it, put it into Gnucash 2.3.2?
12:07:03 <phil> yes, I'll put it in later today.
12:08:09 <JimRaehl2> mib_at13g4: the file without the extension is your current data file. Check that it has the most recent timestamp. The files with xac extensions are backups. The log files are transaction logs.
12:08:27 <JimRaehl2> phil: thanks
12:09:07 <mib_at13g4> The file without the extension does open correctly. The only problem I have is that every time I open it, I have to select a program to open it.
12:09:21 <mib_at13g4> OH and the gnucash-bin file won't open it correctly
12:09:46 <mib_at13g4> only the gnucash.cmd one will open it correctly
12:10:02 <mib_at13g4> BTW on Windows Vista- that might help to know
12:11:12 <JimRaehl2> gnucash.cmd sets up the environment, then calls the executable. it's the one to use.
12:11:17 <mib_at13g4> Ok, I think i figured it out
12:11:33 <mib_at13g4> here is what I just did.
12:11:53 <mib_at13g4> I added an extension .gnc to the file without an extension.
12:12:10 <mib_at13g4> Then I selected it and open-with - gnucash.cmd
12:12:45 <mib_at13g4> It opens the correct datafile but doesn't seem to remember the open windows...like it would if I opened the file the normal way.
12:12:48 <mib_at13g4> Not a big deal
12:14:11 <JimRaehl2> BTW I'm only somewhat ahead of you in the learning curve, but am starting to find my way around.
12:14:41 <mib_at13g4> I LOVE this software. For me the ONLY thing it is missing is a payroll system.
12:15:24 <mib_at13g4> I've been using it for a while - really early versions - and I really haven't run into any problems. Mostly tweeks needed.
12:15:57 <mib_at13g4> Actually, I do have one problem with this current version...I can edit an invoice style sheet but it never saves it.
12:16:07 <mib_at13g4> If I close the file, it won't be there next time.
12:16:22 <mib_at13g4> It also won't show my header image for my custom invoices...
12:16:28 <mib_at13g4> BRB coffee refil
12:16:34 <warlord> mib_at13g4: don't close the invoice window.
12:21:29 <warlord> Just like any report, you lose it if you close it.
12:26:25 <mib_at13g4> sorry, I'm back..
12:26:35 <mib_at13g4> No, you know where you go to create a new stylesheet?
12:26:51 <mib_at13g4> I go there, create one and save it
12:27:29 <mib_at13g4> Then when I go back to it...say to make another style change - its' gone
12:28:29 <mib_at13g4> UPDATE - adding .gnc to the account file without an extension does open with gnucash.cmd and it DOES remember the open windows.
12:30:07 *** delaman has joined #gnucash
12:30:50 <delaman> i would like to try out the mysql feature on the new gnucash, how do i enable/use it. i dont see anything with the default installation
12:31:52 <warlord> delaman: what OS/DIstro and what version of gnucash are you using?
12:32:16 <delaman> distro Archlinux and gnucash 2.3.2
12:32:34 <mib_at13g4> What's this mySql feature? I didn't hear anything about it
12:32:40 <warlord> The File -> Open and File -> Save As dialogs should let you choose; provided you have the DBI providers.
12:33:12 <warlord> mib_at13g4: then you haven't been reading the 2.3.x test-release announcements.
12:34:19 <delaman> warlord: i dont get anything providing with DBI providers
12:34:45 <warlord> delaman: then that's why it's not working for you.
12:34:53 <warlord> install the DBI providers...
12:35:01 <warlord> then gnucash will pick them up
12:35:58 <delaman> let me try
12:36:10 <warlord> (provided you compiled gnucash with dbi support)
12:36:23 <delaman> no i didnt, whats the flag
12:36:31 <warlord> ./configure --help
12:36:41 <warlord> (I think --enable-dbi)
12:37:25 <delaman> k let me try
12:45:14 *** mib_at13g4 has quit IRC
12:47:33 <delaman> what is the next stable release ? 2.3.4?
12:51:57 <warlord> Next stable is 2.4.x
12:52:01 <delaman> warlord: it still didn't work after i --enable-dbi
12:52:20 <delaman> warlord: http://pic.leech.it/i/3db30/ce76136f2009071111.jpg
12:52:21 <warlord> delaman: Do you have the dbi drivers?
12:53:19 <delaman> yes i do, ./configure complained i didnt have it so then i installed them, then i ./configure --enable-dbi
12:53:37 <delaman> how can i make sure i have the dbi installed on linux
12:53:51 <warlord> On ArchLinux? No clue.
12:54:14 <warlord> on Fedora I install libdbi-dbd-mysql
12:55:22 <warlord> When I do File -> Save As I see a dropdown menu in the top-left that lets me choose the mechanism.
12:55:22 <delaman> warlord: http://pastebin.com/m1dd0b366 what package do i need to install
12:56:05 <warlord> aur/libdbi-drivers
12:56:15 <delaman> thats installed
12:57:03 <warlord> Sorry, no clue.
12:57:09 <warlord> Ask the ArchLinux people?
12:57:24 <delaman> :( , i will play around with it a bit longer then i will call it a day
12:57:29 <delaman> thanks for the help
12:58:42 <warlord> Like I said, on Fedora it's libdbi-dbd-mysql
12:58:52 <warlord> maybe Arch doesn't build that?
12:59:09 <delaman> warlord: could i get a screenshot of your File -> Open and File -> Save As dialogs ?
13:00:56 <delaman> maybe i need another flag when i compile?
13:02:24 <warlord> http://imagebin.ca/view/6Bg50H7W.html
13:02:48 <delaman> yeah i dont get anything like that
13:04:38 <delaman> im going to try to build it with a debian machine see if it works there
13:05:36 <delaman> brb
13:06:33 <warlord> okay. on there I recommend you start with: apt-get build-dep gnucash
13:06:45 <warlord> And then make sure you have the libdbi dev package too..
13:15:37 *** delaman has quit IRC
13:36:58 *** FrozenZia has joined #gnucash
13:37:52 <FrozenZia> Upgraded to LinuxMint6 today, and trying to get GnuCash 2.2.9 compiled - running to SLIB problems.
13:38:49 <FrozenZia> apt-get installed a pkg called "slib"
13:40:28 <FrozenZia> Am working on rtfm, but so far no joy. Ooo - now I got a new error when trying to run ./configure... Back in a bit.
13:44:12 *** XiXaQ has joined #gnucash
14:01:13 <warlord> FrozenZia: did you apt-get build-dep gnucash ?
14:23:17 *** delaman has joined #gnucash
14:24:00 <delaman> warlord there?
14:24:08 <warlord> yes
14:24:29 <delaman> warlord: was able to get is install on a debian machine but its just crashes A LOT :(
14:25:01 <delaman> prob b/c its not stable lol
14:25:28 <warlord> maybe.
14:25:38 <warlord> crashes should be reported
14:26:44 <delaman> im getting something like "gnc.gui:ERROR:dialog-file-access.c:304:gnc_ui_file_access: assertion failed: (acctive_access_method_index >=0)"
14:32:10 <delaman> hey i got it working with archlinux, yah!!!!!!!!!!
14:32:20 <warlord> cool.
14:32:28 <warlord> post how on the wiki!
14:34:48 <delaman> ok
14:37:35 *** MechtiIde has quit IRC
15:03:08 *** warlord has quit IRC
15:06:53 *** sjc has joined #gnucash
15:10:05 <phil> that is a known crash.
15:10:22 <phil> I should probably spin a 2.3.3 pretty soon to deal with it
15:16:26 *** XiXaQ has quit IRC
15:34:26 <FrozenZia> warlord: no, hadn't done that -- not a real experienced compiler -- but somehow I musta done something right -- configure went thru okay, and the make seemed to compile okay -- so far so good...
15:39:27 *** phil_ has quit IRC
15:42:35 *** MechtiIde has joined #gnucash
15:44:49 <FrozenZia> seem to be good to go...
15:45:01 *** FrozenZia has quit IRC
15:57:43 *** sjc has quit IRC
16:05:26 *** sjc has joined #gnucash
16:11:44 *** JimRaehl2 has left #gnucash
16:13:13 <delaman> what are fields guid and tx_guid in the MySQL splits table?
16:14:07 <jsled> the guide of the split and the guid of the transaction the splits are part of, I'd guess.
16:14:12 <jsled> s/guide/guid/
16:14:25 <delaman> k
16:15:29 <delaman> im trying to dump some POS data into the gnucash MySQL database, how would i generate a guid
16:15:55 <jsled> it's just a random hex identifier.
16:16:02 *** Jimraehl has joined #gnucash
16:17:26 <jsled> select md5(uuid()); should work.
16:17:52 <jsled> Might need some uppercase forcing, I'm not sure how pickup gnucash is.
16:18:00 <jsled> phil: ?
16:18:17 <jsled> s/pickup/picky/
16:21:08 <phil> In my home file db (sqlite3), all guids are lower case
16:23:56 <phil> looks as though the string -> guid translator is case insensitive, so that having upper case chars would work.
16:24:20 <phil> However, comparisons wouldn't. So, make them lower case
16:54:54 <delaman> in the mysql database, table "transactions" field "enter_date" ,,,,, the last six digits for example 20090711185727 how would i generate the last six digits with php or mysql?
16:55:20 <jsled> it looks like it's just hhmmss, eh?
16:55:41 <delaman> lol
16:55:43 <delaman> yeah it is
17:05:24 *** delaman has quit IRC
17:42:04 *** holt_kessler has joined #gnucash
17:42:23 <holt_kessler> hi all
17:43:50 <holt_kessler> just compiled 2.3.2 on !#crunchbang -that was interesting!
17:44:33 <jsled> how so?
17:44:52 <jsled> ubuntu should have all the deps pretty readily accessible.
17:45:10 <holt_kessler> only for 2.6
17:45:32 <holt_kessler> no dev libraries jsled
17:45:54 <holt_kessler> its crunchee uses openbox very slim
17:47:21 <holt_kessler> it went great but --disable-deprecated-xxx stops make
17:47:45 <holt_kessler> glib gtk gdk or gnome
17:48:57 <holt_kessler> where can i see a full list of vendors?
17:57:42 *** BlueAidan has quit IRC
18:02:07 *** BlueAidan has joined #gnucash
18:11:39 *** holt_kessler has quit IRC
18:29:21 *** sjc has quit IRC
18:37:14 *** sjc has joined #gnucash
18:43:54 <phil> :q
18:43:58 <phil> :q
20:00:12 *** delaman has joined #gnucash
20:21:10 *** cort has quit IRC
20:22:18 *** sjc has quit IRC
20:30:15 *** sjc has joined #gnucash
20:33:48 *** Jimraehl has left #gnucash
20:52:50 *** Jimraehl has joined #gnucash
21:13:20 *** sjc has quit IRC
21:20:03 *** phil has quit IRC
21:28:30 *** jcreigh has joined #gnucash
22:04:47 *** jcreigh has quit IRC
22:26:17 *** delaman has quit IRC
22:35:31 *** Jimraehl has left #gnucash
22:55:53 *** JimRaehl2 has joined #gnucash
23:27:43 *** JimRaehl2 has left #gnucash
23:28:14 *** Jimraehl has joined #gnucash