2015-03-27 GnuCash IRC logs
00:08:07 *** ErKa has joined #gnucash
00:10:02 *** GabrieleV_ has joined #gnucash
00:11:04 *** GabrieleV has quit IRC
00:11:05 *** GabrieleV_ is now known as GabrieleV
00:35:56 *** fell_ has joined #gnucash
00:35:57 *** gncbot sets mode: +o fell_
00:35:57 *** fell has quit IRC
00:36:01 *** GabrieleV_ has joined #gnucash
00:36:03 *** GabrieleV has quit IRC
00:36:03 *** GabrieleV_ is now known as GabrieleV
00:51:01 *** GabrieleV_ has joined #gnucash
00:51:07 *** GabrieleV has quit IRC
00:51:07 *** GabrieleV_ is now known as GabrieleV
00:56:13 *** ErKa has quit IRC
00:58:10 *** josePHPagoda has quit IRC
01:14:24 *** warlord has joined #gnucash
01:14:25 *** gncbot sets mode: +o warlord
01:16:03 *** GabrieleV has quit IRC
01:16:03 *** GabrieleV_ has joined #gnucash
01:16:11 *** GabrieleV_ is now known as GabrieleV
01:49:39 *** O01eg has quit IRC
02:15:10 *** jchonig has quit IRC
02:28:25 *** jethrob has quit IRC
02:33:12 *** jethrogb has joined #gnucash
02:46:32 *** StuM has quit IRC
03:07:17 *** len has quit IRC
03:37:27 *** Krzysiek_K has joined #gnucash
03:41:08 *** Krzysiek_K has left #gnucash
03:41:56 *** cartsoftware has joined #gnucash
03:44:52 *** jralls has joined #gnucash
04:12:34 *** GabrieleV_ has joined #gnucash
04:12:56 *** GabrieleV has quit IRC
04:12:56 *** GabrieleV_ is now known as GabrieleV
04:44:21 *** cartsoftware1 has joined #gnucash
04:51:33 *** cartsoftware has quit IRC
05:02:37 *** ArchangelXL has quit IRC
05:59:17 *** fabior has joined #gnucash
06:14:16 *** jralls has quit IRC
06:15:00 *** warlord has quit IRC
06:22:26 *** jethrogb has quit IRC
07:01:07 *** misha_ has quit IRC
07:02:25 *** misha has joined #gnucash
07:07:50 *** Jimraehl1 has left #gnucash
07:10:47 *** Jimraehl1 has joined #gnucash
07:40:07 *** jralls has joined #gnucash
07:40:23 *** himaxx has joined #gnucash
07:44:43 *** himaxx has quit IRC
07:50:09 *** jethrogb has joined #gnucash
07:50:30 *** jralls has quit IRC
07:52:36 *** jralls has joined #gnucash
08:10:00 *** rickoehn has joined #gnucash
08:28:42 *** himaxx has joined #gnucash
08:29:47 *** himaxx has quit IRC
08:56:39 *** warlord has joined #gnucash
08:56:40 *** gncbot sets mode: +o warlord
09:14:10 *** David417 has joined #gnucash
09:21:05 <David417> It's morning here in chilly Chicago, so chilly that GnuCash has again frozen. This is release 2.6.5 in Windows 7. I was part way through re-configuring a custom balance sheet report to show different accounts, and suddenly I cannot scroll down the account list or do anything else in GnuCash. Other programs are fine, except the Windows Resource monitor has also stopped updating, but I can...
09:21:07 <David417> ...still scroll around sub-windows.
09:21:36 <David417> in that program
09:26:13 <David417> The computer management logs also seem incomplete as of several minutes ago.
09:26:45 *** ErKa has joined #gnucash
09:29:36 <David417> The security system is logging on and off and a few system services are generating started and stopped messages.
09:30:07 <warlord> David417: sounds like you're having a larger issue than just GnuCash
09:32:36 <David417> yeah. All of the other programs that were running still are, I can still use Firefox,
09:33:50 <warlord> doesn't mean you aren't have a system issue.
09:34:00 <warlord> ... just that currently only GnuCash is really showing you it's being affected.
09:34:16 <warlord> Try running a Linux LiveCD?
09:34:21 <warlord> or running memtest86?
09:36:04 <David417> I want to do some more investigating before re-booting. Virtual box seems to be starting of and opening a Linux Mint image
09:38:12 <David417> Mint can find other computers on my LAN
09:40:25 <warlord> I dont use Windows myself so can't really help you. (When I need to run Win I do so in a VM. I run Linux natively)
09:41:13 *** ErKa has quit IRC
09:41:21 <David417> do you know how to rum memtest86?
09:42:14 <warlord> you need to reboot into it. it's included into many tools, but I like system-rescue-cd
09:43:36 <David417> I am not a real techie, I just pretend. I think it is time to reboot. Thanks.
09:45:55 <David417> even config.sys seems to still start and run correctly
09:45:58 <warlord> Good luck!
09:46:16 <warlord> It could be a gnucash issue..
09:47:13 <David417> yes, that is why I was trying to gather more info before giving up
09:49:40 <David417> I should try using the task manager to kill GnuCash before re-booting the computer
09:51:21 <David417> I can even switch the focus back and forth between the main GnuCash window and the report configuration window, but they are both frozen
09:53:59 <warlord> sure, you could try.
09:59:18 <warlord> Maybe there's another hidden window somewhere? A modal dialog that popped behind, or is on a "second" screen?
09:59:28 <warlord> (sorry, gotta run... time to catch my flight)
09:59:34 *** warlord has quit IRC
10:05:55 *** ErKa has joined #gnucash
10:18:39 <David417> Killing Gnucash worked, and I re-started it without incident. Repeating the same actions that I did before the freeze did not re-trigger the freeze.
10:18:58 <David417> oh well...
10:23:33 <David417> I do still think that there is still something going on in the background that occasionally makes GnuCash freeze as I reported recently in a bug 746702.
10:27:41 *** fabior has quit IRC
10:47:09 *** MechtiIde has joined #gnucash
11:04:43 *** MechtiIde has quit IRC
11:06:47 *** fabior has joined #gnucash
11:07:05 *** misha has quit IRC
11:07:26 *** misha has joined #gnucash
11:10:43 *** aqua___ has joined #gnucash
11:12:14 *** David417 has quit IRC
11:12:15 *** aqua___ has quit IRC
11:17:35 *** misha has quit IRC
11:29:23 *** ErKa has quit IRC
11:30:11 *** uXus has quit IRC
11:33:10 *** uXus has joined #gnucash
11:35:14 *** ErKa has joined #gnucash
11:56:48 *** fabior has quit IRC
12:17:57 *** misha has joined #gnucash
12:34:26 *** fabior has joined #gnucash
12:40:58 *** aqua___ has joined #gnucash
13:06:06 *** ArchangelXL has joined #gnucash
13:13:53 *** Krzysiek_K has joined #gnucash
13:30:29 *** O01eg has joined #gnucash
14:04:51 *** fell__ has joined #gnucash
14:04:52 *** gncbot sets mode: +o fell__
14:05:52 *** fabior has quit IRC
14:13:35 *** fell_ has quit IRC
15:40:47 *** GabrieleV_ has joined #gnucash
15:40:57 *** GabrieleV has quit IRC
15:40:57 *** GabrieleV_ is now known as GabrieleV
15:52:33 *** misha has quit IRC
15:53:46 *** misha has joined #gnucash
15:56:14 *** jeffsf has quit IRC
15:57:05 *** jeffsf has joined #gnucash
16:23:06 *** misha_ has joined #gnucash
16:28:52 *** misha has quit IRC
16:33:21 *** len has joined #gnucash
16:42:22 *** rubdos has joined #gnucash
16:56:13 *** misha has joined #gnucash
16:56:58 *** warlord has joined #gnucash
16:56:58 *** gncbot sets mode: +o warlord
17:03:16 *** misha_ has quit IRC
17:19:53 *** ArchangelXL has quit IRC
17:21:31 *** cartsoftware1 has quit IRC
17:26:50 *** misha_ has joined #gnucash
17:35:17 *** misha has quit IRC
17:46:34 *** rickoehn has quit IRC
17:48:01 *** josePHPagoda has joined #gnucash
18:03:28 *** rubdos has quit IRC
18:39:48 <wafflej0ck> Hi everyone, I've been using GnuCash for a couple of years for my small business but got tired of manually entering things from our bank but don't 100% trust/like how the OFX data import works out so I decided to save the data to MySQL database so I could insert records myself, I managed to get this working but I'm wondering where I could look in the source for the SQL queries it runs for various actions to be sure I'm insertin
18:39:49 <wafflej0ck> g the appropriate records?
18:48:46 *** Krzysiek_K has left #gnucash
18:49:24 *** misha has joined #gnucash
18:53:52 *** misha_ has quit IRC
19:11:53 *** himaxx has joined #gnucash
19:13:18 *** O01eg has quit IRC
19:21:41 *** O01eg has joined #gnucash
19:46:10 *** ErKa has quit IRC
20:11:12 <jralls> Wafflejock: We don't recommend that you do that.
20:13:44 <jralls> wafflejock: GnuCash doesn't run queries for most actions. It loads the whole database into memory at startup and only runs update queries with the finished objects when the objects are committed (in the GnuCash code sense, not the database sense.)
20:14:48 <jralls> wafflejock: The preferred method for what you want to do is to use the Python bindings to make your changes.
20:18:08 <wafflej0ck> jralls, okay good to know I'll try to check out the Python bindings but really haven't done any Python programming, suppose it's an opportunity to check it out some, I'll keep that in mind about the database not immediately reflecting changes too, I did notice that when I inserted records I had to restart to see the new entries but good to have clarification on that
20:21:05 <jralls> wafflejock: The *database* reflects changes immediately. *GnuCash* doesn't because it only loads from the database at startup. Since the only locking is the rather crude locking table entry that only GnuCash knows about, you shouldn't have GnuCash running when you do your manipulations.
20:23:17 <wafflej0ck> I do web development and mostly use PHP on the server side and JS client side so I just wrote a JS script that reads in the file input using the HTML5 file API and it matches against some regular expressions and queries for the accounts to match as much as it can automatically, then I just have to select the accounts for remaining unmatched transactions and hit a button for it to update... I'm inserting one transaction entry, t
20:23:17 <wafflej0ck> wo splits, and a slot based on this http://wideopenstudy.blogspot.com/2014/11/how-to-add-transaction-to-gnucash.html also I did have it closed when I ran the script to insert data since I was worried about it writing back when I closed
20:24:30 *** misha_ has joined #gnucash
20:24:30 *** misha has quit IRC
20:25:15 <wafflej0ck> my plan was basically to see if I can find a way to diff the database or setup triggers so I know when tables get changed and then just reverse engineer the actions so I could have a web interface that I can more easily customize (having not done a lot of C programming and never used Scheme)
20:26:30 <wafflej0ck> I'll try to check out the Python bindings though and see if I can figure out how I could incorporate that instead
20:37:56 <wafflej0ck> thx for the info and direction to check things out jralls
20:40:17 <jralls> wafflejock: You're welcome. I don't think triggers will help you much in this case. I can tell you that the tables affected by an import will be transactions, splits, and slots, but that there's a bunch of stuff going on in the C code that you'll never see in the database.
20:42:45 <jralls> wafflej0ck: Have you considered transforming the OFX file instead?
20:51:25 *** ErKa has joined #gnucash
20:51:33 <jralls> wafflej0ck: Also, did you turn on the transaction matcher in Preferences? GnuCash can do most of that matching itself.
20:53:03 <wafflej0ck> jralls, well say I take a copy of the database, then make some change in GNUCash and close it out and then I use mysqldbcompare I can see what entries change, then I can just be sure my script makes the same changes when I'm trying to achieve the same action, regarding the OFX file I actually didn't think it had the category/destination account info in there which is part of what my page/scripts are doing, I have used the OFX i
20:53:03 <wafflej0ck> mport before but don't think I did the auto matching, regardless I like having the data in the database so I can generate my own charts/reports when the need arises
20:54:31 <wafflej0ck> I found the ERD diagram and I see that a lot of the derived tables are based on the key value pairs in the slots and I think I may have even seen some of your posts talking about this not being super great but overall so far my experience with just hacking around this way has been pretty good
20:54:32 <jralls> wafflej0ck: Ad-hoc reporting from a SQL database is encouraged! Writing to the database, not so much.
20:54:41 <wafflej0ck> okay gotcha
20:57:45 <jralls> wafflej0ck: I don't remember if the OFX standard allows a counter-account; IIRC QIF does. warlord, who's probably gone to bed already, knows that stuff better than I. Anyway, of course the download won't include the GnuCash counter accounts, it doesn't know anything about them. But I think if you add them to the OFX/QIF file before importing the importer will respect that. I admit I've never tried.
20:59:15 <jralls> wafflej0ck: What I have done for many years is trained the import matcher, and it works reasonably well once trained. That does require that you match the transactions in the dialog, not blow through it and then reassign them from the orphans account.
21:00:36 <wafflej0ck> I'll give that another go when I need to do another import
21:14:54 <jralls> wafflej0ck: It will take a few imports to properly train the matcher.
21:20:50 *** misha_ has quit IRC
21:21:26 *** misha has joined #gnucash
21:25:38 <wafflej0ck> yeah as is I just wrote some manual matching rules (look for "parking" or common gas stations by name or pick off entries that were pay out to me or my business partner), was planning on just adding a little web interface for modifying those rules, but if the OFX and auto-matcher works well I may do that, really I had already built a basic online CRM and incorporated invoices and online payments so I was hoping to eventually me
21:25:39 <wafflej0ck> rge that with our GNUCash data so I can still use GNUCash in the interim as I build out the custom things we need, I figured I can also integrate with QuickBooks in the future using their API and sell the web based solution along with custom designed stuff we do
21:26:16 <wafflej0ck> right now it's a fair amount of double duty with regard to entering invoices
21:28:23 <wafflej0ck> as is the import scripts I have do the job for importing and matching up destination accounts then for the sales I just have to go into GNUCash afterwards and assign those rows as payments against the appropriate invoices, but would like to automate all the things as much as possible
21:31:29 <wafflej0ck> regarding the GPL license if I re-use the DB structure but build all my own code for interacting with that data structure would I still be bound by the GPL? (I am a fan of open source but my business partner is harder to convince sometimes)
21:37:41 <jralls> wafflej0ck: IANAL and all that. It boils down to copyrights: If the schema is copyrightable (and I don't know if it is or not; I'm inclined to think not) then your right to reproduce it is granted via the GPL. However, the FSF FAQ doesn't talk about data structures, just code.
21:39:12 <wafflej0ck> yeah my business partner actually is a lawyer but would need to have him examine the GPL I guess, that was the general answer I got from #programming too though they though data structures are okay to re-use and can't be patented or copyrighted most places I guess
21:39:56 <jralls> wafflj0ck: If your partner is really twitchy then you should find an "Intellectual Property" attorney for advice. One without experience in copyright law might not get it right.
21:40:05 <wafflej0ck> yeah
21:56:15 <jralls> Time to go home. Back in 18 hours.
21:56:21 *** jralls has quit IRC
22:10:19 *** jeffsf has quit IRC
22:18:40 *** jeffsf has joined #gnucash
22:39:36 *** jeffsf has quit IRC
22:40:30 *** jeffsf has joined #gnucash
23:16:34 *** StuM has joined #gnucash