2015-02-01 GnuCash IRC logs
00:06:24 <Ahmuck> in account import full_name == parent account?
00:20:47 *** MechtiIde has joined #gnucash
00:25:15 *** gjanssens has joined #gnucash
00:25:15 *** gncbot sets mode: +o gjanssens
00:42:53 *** fell_ has quit IRC
00:44:07 *** MechtiIde has quit IRC
01:00:34 *** gjanssens has quit IRC
01:09:34 *** Ahmuck has quit IRC
01:28:57 *** ErKa has joined #gnucash
02:15:35 *** MechtiIde has joined #gnucash
02:26:59 *** ErKa has quit IRC
02:46:32 *** kode has joined #gnucash
03:02:55 *** fabior has joined #gnucash
03:24:27 *** kode has quit IRC
03:36:55 *** kode has joined #gnucash
03:38:44 *** MechtiIde has quit IRC
03:42:34 *** pacon has joined #gnucash
03:48:04 *** MechtiIde has joined #gnucash
03:55:39 *** fabior has quit IRC
04:19:27 *** Krzysiek_K has joined #gnucash
04:20:25 *** GabrieleV_ has joined #gnucash
04:20:25 *** GabrieleV has quit IRC
04:20:26 *** GabrieleV_ is now known as GabrieleV
04:23:53 *** MechtiIde has quit IRC
04:40:12 *** aqua___ has joined #gnucash
04:43:22 *** aqua_ has joined #gnucash
04:51:50 *** aqua___ has quit IRC
05:10:35 *** pacon has quit IRC
05:18:11 *** cartsoftware has quit IRC
05:19:07 *** cartsoftware has joined #gnucash
05:38:36 *** O01eg has joined #gnucash
05:39:06 *** aqua_ has quit IRC
06:12:35 *** MechtiIde has joined #gnucash
06:35:43 *** himaxx has joined #gnucash
06:41:05 *** himaxx has quit IRC
07:02:33 *** aqua_ has joined #gnucash
07:19:36 *** wol has joined #gnucash
07:31:27 *** _kas has joined #gnucash
07:34:16 *** _kas has joined #gnucash
07:45:14 *** himaxx has joined #gnucash
07:52:06 *** Jimraehl1 has left #gnucash
07:52:43 *** himaxx has quit IRC
07:53:15 *** Jimraehl1 has joined #gnucash
08:00:07 *** aqua_ has quit IRC
08:16:56 *** Jimraehl1 has left #gnucash
08:22:07 *** cartsoftware has quit IRC
08:24:14 *** MechtiIde has quit IRC
08:24:52 *** Jimraehl1 has joined #gnucash
08:26:53 *** kode has quit IRC
08:34:22 *** MechtiIde has joined #gnucash
08:42:25 *** cartsoftware has joined #gnucash
08:47:40 *** Ahmuck has joined #gnucash
08:47:43 <Ahmuck> hi.
08:49:12 <Ahmuck> i'm having trouble with gnucash's transactions import, specifically the account part and it's format in the csv file. any help would be appreciated
08:57:14 *** Krzysiek_K has left #gnucash
09:00:28 <Ahmuck> ok, i've got the example by using the export function
09:01:52 *** desperateFish has joined #gnucash
09:03:55 *** rubdos has joined #gnucash
09:10:39 <desperateFish> Hi everybody, I have a question concerning reports, I'd like to hav a report made after I closed the books in order to show that the profit is now added to the equity.
09:11:57 <desperateFish> Surprisingly, GnuCash doesn't seem to see that I have closed the books and makes the report with all the amounts as before, i.e. with equity and profits shown separately.
09:12:19 <desperateFish> What am I doing wrong and how can I fix this?
09:12:41 <desperateFish> Any help is appreciated
09:14:30 *** rubdos has quit IRC
09:29:08 *** fell has joined #gnucash
09:32:02 *** wol has quit IRC
09:32:44 *** Ahmuck has quit IRC
09:36:22 *** kode has joined #gnucash
09:46:27 *** kode has quit IRC
09:52:28 *** Ahmuck has joined #gnucash
09:55:17 *** Caesar has joined #gnucash
10:00:27 *** MechtiIde has quit IRC
10:03:58 *** Ard0nik has quit IRC
10:17:20 *** aqua___ has joined #gnucash
10:39:10 <Ahmuck> how do you delete accounts using import accounts
10:42:00 *** aqua___ has quit IRC
10:53:13 *** aqua___ has joined #gnucash
10:57:34 *** fabior has joined #gnucash
11:13:39 <Ahmuck> !bug
11:32:10 *** wizkid238 has quit IRC
11:35:01 *** fell_ has joined #gnucash
11:44:01 *** fell has quit IRC
12:32:02 *** ErKa has joined #gnucash
12:43:25 *** kode has joined #gnucash
12:51:49 <Ahmuck> there does not seem to be a way to assign a category based on account description. ie BANK:Assets:Checking Account:Bank A:Checking Account #123
12:52:01 <Ahmuck> BANK:Assets:Checking Account:Bank A:Checking Account # 456
12:52:03 <Ahmuck> etc.
12:52:26 <Ahmuck> i assume that when importing transactions that accounts are not created as in account imports if they are not there
12:53:07 <Ahmuck> like when importing accounts csv
12:53:37 <Ahmuck> so i can't put the account in the category section of the transactions import so it will sort it out accordingly?
12:54:35 <Ahmuck> i did get it to import properly, everything is in "IMBALANCE" which is ok as I can assign categories, however I assumed I could do it with the category section as my ie above.
12:57:32 <Ahmuck> on the ledger i have the option of sorting on "date of entry". when importing a csv file to transactions it does not keep the order, rather it reorders it by date/number. is there a way to set the date of entry for import?
12:58:15 *** fabior has quit IRC
13:26:41 *** desperateFish has quit IRC
13:28:42 <Ahmuck> ok, so the import dialog has an option for "notes". one of the reports indicate this as "memo/notes". i thought i would try it and see.
13:29:57 *** kode has quit IRC
13:33:42 <Ahmuck> is there a way to display the memo in the transaction register?
13:33:50 <Ahmuck> the transaction report has the memo
13:35:49 *** kode_ has joined #gnucash
13:39:18 <warlord> keret: You can specify which line-items are charged back
13:39:28 *** ErKa has quit IRC
13:40:05 <warlord> bozonius: you cannot have a job without a customer. A job *BELONGS* to a customer
13:40:32 <warlord> Ahmuck: convert your CSV to QIF
13:40:51 <warlord> Ahmuck: gnucash cannot import the csv it exports.
13:40:57 <Ahmuck> hi warlord :)
13:41:52 <warlord> Ahmuck: to display the memo: split-expand the txn
13:41:58 <Ahmuck> i created my csv on export and import. export so i could see the fields import so i could manage them
13:42:33 <warlord> Ahmuck: like I said, gnucash cannot import the csv it exports.
13:42:42 <Ahmuck> sure sure.
13:42:52 <Ahmuck> let me see if i can't clear a few things
13:43:17 <Ahmuck> i've got a long way in figuring out the import/export issues by examining the exports and the gnucash dialogs
13:43:21 <warlord> but frankly, don't use CSV, you'll have better luck converting your import to QIF
13:43:41 <warlord> And examining the csv output from gnucash wont help you.
13:43:48 <Ahmuck> i've been finding inconsistency in naming conventions.
13:44:09 <Ahmuck> ok. i've been creating my own ledger in libreoffice calc first
13:44:17 <Ahmuck> then importing it into gnucash
13:45:06 <Ahmuck> by doing it this way i can assign a line # to each transaction and then sort multiple times to check names, amounts, balances, missed lines, etc.
13:45:22 <Ahmuck> so that i have an accurate import and a printable ledger for my parents to review
13:45:30 <Ahmuck> tax code, etc.
13:46:14 <Ahmuck> i've never worked with qif, but am willing to. is there a way to edit/view it?
13:47:08 *** gjanssens has joined #gnucash
13:47:08 *** gncbot sets mode: +o gjanssens
13:47:24 <Ahmuck> in "category" i noticed that there was a T for top level and a S for subaccounts. i wondered how to import a transaction directly into a sub sub sub account
13:47:34 <Ahmuck> possible or not?
13:48:17 <Ahmuck> i'm only really missing two things. a way to set the order on import through "real time" sort option
13:49:04 <Ahmuck> ah ha! is the date format for import also have a time inclusion? ie 02-01-15-08-15-00
13:49:57 <Ahmuck> the other is the memo/note entry in the transaction ledger. i looked at the split and did not see a memo option. do you mean "double line"?
13:51:35 <Ahmuck> so like the memo is there on the report coming from the csv but not displaying in the transaction register anywhere but does display on the report. this is ok for me as i have a column in my csv for the memo entry
13:53:00 <Ahmuck> i checked "double line", "auto-split ledger", "transaction journal", and "split" but still am not seeing the "memo" in the transaction ledger.
13:54:04 * Ahmuck has been testing since 8:00 pm yesterday ... finally got the accounts import worked out and almost the transaction imports worked out
13:56:23 <Ahmuck> i have a column for Reconciled in the csv and it appears to be coming through?
14:01:08 <warlord> What are you talking about?
14:01:11 <warlord> T and S?
14:01:24 <warlord> For QIF? That's not what those lines mean..
14:01:39 <warlord> T and S in QIF are used for non-split and split transactons
14:01:48 <warlord> and no, AFAIK there is no time in any date formats
14:02:36 <warlord> Ahmuck: Which "memo" are you referring to? There are three main places where it could go: Txn Desc, Txn NOtes (view -> double line mode), and Split Memo
14:05:27 <warlord> Ahmuck: I still feel like you're making more work for yourself because of some ingrained belief that the entries should appear in a certain way based on external inputs.
14:07:35 *** Caesar has quit IRC
14:07:58 <Ahmuck> ah, great, got it
14:08:06 *** Caesar has joined #gnucash
14:08:07 <Ahmuck> on the notes thing. i missed the greyed out portion
14:18:46 *** MechtiIde has joined #gnucash
14:27:16 <Ahmuck> warlord, it helps me to keep track of the lines. if i miss a line i am able to rapidly find the corresponding balance and then began working down.
14:27:34 <Ahmuck> because i am doing this in libreoffice calc, the import is perfect before it gets to gnucash
14:28:12 <Ahmuck> i'm using gnucash for the power and ease of it's cross account double entry system and hopefully for it's report capabilities
14:28:30 <Ahmuck> warlord, i have an example csv if you'd like to view
14:28:53 <Ahmuck> i made one up in the last couple of hours as part of my testing
14:31:15 <Ahmuck> i realized upon working with the spreadsheet what gnucash was doing with the "balancing" as well as the date, number and description ordering. it was doing the same as gnucash until i set the line order. honestly if one sorts by date entered or "real time" it works the same way. but if i am not careful and miss something i've had to delete a couple months of entry. rapid data entry.
14:31:23 <Ahmuck> in the spreadsheet i just insert or delete a line
14:31:29 <Ahmuck> and order it when it is complete
14:47:30 <warlord> Ahmuck: the fact that you care about the order is frustringly maddening
14:47:37 <warlord> frustratingly even
14:48:10 *** kode_ has quit IRC
14:51:02 *** kode has joined #gnucash
14:51:06 <warlord> I truely absolutely believe you're making more work for yourself because of that "requirement"
14:55:55 *** David417 has joined #gnucash
15:00:04 <David417> Hi I just had a crash of release 2.6.5 in Windows as I was editing a split transaction in an account relating to stock transactions. The trace file ended with several critical GNC errors, I can provide details. Would this be a manifestation of bug 734247?
15:06:31 <David417> Curiously, the last input was a mouseclick on the reconcile box in a split line
15:08:05 *** gjanssens has quit IRC
15:11:48 <jralls> David417: Can't tell if it's the same as 734247, not enough info. Did you click on a reconcile box in the open transaction? If so, then it's not 734247, which is asserting in gnc_split_register_save().
15:12:21 <jralls> David417: What is the last message in the trace file?
15:12:55 <David417> 14:58:34 CRIT <gnc.register.gnome> gnucash_sheet_cursor_set_from_table: assertion 'gnucash_sheet_cell_valid (sheet, v_loc)' failed
15:12:56 <jralls> David417: You're David Carlson, IIRC. Do I remember correctly?
15:13:11 <David417> Yes I am
15:13:43 <jralls> Yeah, that's the wrong place for 734247.
15:13:47 <David417> I know just enough to be dangerous
15:14:08 <jralls> Actually you know enough to be quite dangerous. ;-)
15:14:33 <David417> TY
15:15:17 *** kode has quit IRC
15:15:46 <David417> Offhand can you say if there is another bug to look at?
15:16:11 <warlord> Sometimes I wish I could more easily have two GnuCash instances open with different data without the potential preferences-backend interference..
15:17:38 <David417> You mean that you do not have a room full of computers runniong simultaneously?
15:17:45 <warlord> LOL.
15:18:03 <warlord> I would prefer not to have a unique machine per gnucash instance. ;)
15:18:44 <jralls> warlord: I suppose a separate VM equates to a unique machine...
15:18:49 <David417> That would generate too many BTUs
15:19:29 <David417> VMs use a lot of resources too
15:21:42 <jralls> David417: There aren't any bugs mentioning that function. The error in question is from clicking somewhere that GnuCash thought wasn't valid. Whether that's what crashed it only a stack trace could tell. Can you make one?
15:22:50 <jralls> David417: Considering your proficiency at crashing GnuCash it's be really nice if you'd switch to a Mac. They make a stack trace automatically for every crash.
15:23:47 <David417> I have not tried that in a long time and I do not know if this is reproducible yet either.
15:24:55 <David417> Is it possible to set up a Mac VM on a Linux host without buying software from Apple?
15:26:07 <David417> perhaps the correct term would be is it legal
15:26:29 <jralls> David417: In theory, yes. The trick is getting the software. No, it's not legal to run OSX on anything but Mac hardware.
15:27:29 <jralls> Since Apple distributes OSX through the App store, which can see what kind of machine you're running, it's hard to get it even though they give it away.
15:28:38 <David417> Interesting. I may have a friend that uses a Mac.
15:30:02 <jralls> Considering that gnucash_sheet_set_from_table() doesn't return anything or have any side effects except on the display, it seems unlikely that it's the cause of the crash.
15:31:13 <Ahmuck> warlord, yes, i suppose. once imported it doesn't matter but if i wasn't using an outside input form it would be important for the fact of finding the error quickly. it has more to do with delayed bookkeeping rather than timely bookkeeping. and it's not my habits that need to change.
15:31:56 <Ahmuck> if there is a balance error after data input, working down the working balance in a statement where line transactions are ordered according to the statement one can find the error rather quickly based on running balance alone
15:32:04 *** MechtiIde has quit IRC
15:32:09 <Ahmuck> otherwise it's picking through the statement line by line
15:32:32 <Ahmuck> i gtg for now. need to read a book or something
15:32:51 <Ahmuck> er, picking through the register line by line
15:33:00 *** Ahmuck has quit IRC
15:34:10 <David417> Back to the first subject, I will try setting up something either on Linux or Windows and see if I can reproduce this crash.
15:34:49 <jralls> David467: OK.
15:34:57 <David417> A few Previous errors:14:58:34 CRIT <gnc.ledger> [gnc_split_register_get_trans_split()] bad row
15:34:59 <David417> * 14:58:34 CRIT <gnc.register.gnome> gnucash_sheet_cursor_set_from_table: assertion 'gnucash_sheet_cell_valid (sheet, v_loc)' failed
15:35:00 <David417> * 14:58:34 CRIT <gnc.ledger> [gnc_split_register_get_trans_split()] bad row
15:35:02 <David417> * 14:58:34 CRIT <gnc.register.gnome> gnucash_sheet_cursor_set_from_table: assertion 'gnucash_sheet_cell_valid (sheet, v_loc)' failed
15:35:03 <David417> * 14:58:34 CRIT <gnc.ledger> [gnc_split_register_get_trans_split()] bad row
15:35:05 <David417> * 14:58:34 CRIT <gnc.register.gnome> gnucash_sheet_cursor_set_from_table: assertion 'gnucash_sheet_cell_valid (sheet, v_loc)' failed
15:35:06 <David417> * 14:58:34 CRIT <gnc.ledger> [gnc_split_register_get_trans_split()] bad row
15:35:08 <David417> *
15:39:23 <jralls> David417: More symptoms of the same problem, a bad tree-cell location.
15:40:38 <jralls> So maybe the click in the reconciled field was in the wrong transaction. Were you in ledger view?
15:41:47 *** wizkid238 has joined #gnucash
15:42:38 <David417> That could even have been caused by a cosmic ray going through a ram chip. Actually, I was in the General ledger view. That view was missing when I restarted GnuCash along with several of the recent edits
15:43:28 <David417> I have yet to import the last log file
15:48:51 <David417> They do not talk about cosmic rays much anymore. Did they go out of vogue when the Big Bang theory was proposed?
15:53:14 <David417> The last NASA reference to cosmic rays was on April 23, 2012
16:00:52 <jralls> No, the term just became too general. There are so many identified sources of extra-solar radiation that "cosmic rays" isn't really a useful term.
16:03:02 <jralls> For that matter when a charged particle flips a bit on your computer you really have no way of knowing whether the source was terrestrial or not.
16:03:34 <David417> If I can reproduce this crash I will be back. Bye
16:04:12 <jralls> If you can reproduce it and get a stack trace, file a bug.
16:04:20 <David417> Yeah, checksums are supposed to catch most of those.
16:04:49 <keret> warlord: so for bill with items reimbursable by single customer, create new bill and assign reimbursable items line by line.
16:05:46 <keret> what about the situation of a single bill that includes multiple items reimbursable by multiple customers? create multiple bills?
16:06:10 <keret> ... given only one customer can be assigned to each bill?
16:09:48 *** David417 has quit IRC
16:16:51 *** himaxx has joined #gnucash
16:19:35 *** Ard0nik has joined #gnucash
16:24:15 *** Caesar has quit IRC
16:26:41 *** Jimraehl1 has left #gnucash
16:28:54 *** himaxx has quit IRC
16:45:57 <warlord> keret: yes, you need multiple bills for that; there's only one chargeback customer on a bill.
16:54:39 <keret> warlord: thank you.
17:01:04 *** Jimraehl1 has joined #gnucash
17:09:26 *** Caesar has joined #gnucash
17:17:50 *** Ard0nik has quit IRC
18:26:54 *** andy has quit IRC
18:37:05 *** Ard0nik has joined #gnucash
18:42:06 *** Caesar has quit IRC
19:14:17 *** andy has joined #gnucash
19:38:52 *** fell__ has joined #gnucash
19:45:56 *** fell_ has quit IRC
20:04:05 *** GabrieleV_ has joined #gnucash
20:04:13 *** GabrieleV has quit IRC
20:04:14 *** GabrieleV_ is now known as GabrieleV
20:35:24 *** ErKa has joined #gnucash
20:58:36 *** GabrieleV_ has joined #gnucash
20:59:04 *** GabrieleV has quit IRC
20:59:05 *** GabrieleV_ is now known as GabrieleV
21:25:08 <bozonius> I get the relationship of job to customer. It makes sense. I was just trying to confirm that there is no way to break the association once the job record is created.
22:15:15 *** mlncn has joined #gnucash
22:26:20 *** O01eg has quit IRC
22:27:02 *** aqua_ has joined #gnucash
22:32:13 *** aqua___ has quit IRC
22:53:07 *** Ardonik has joined #gnucash
23:00:53 *** Ard0nik has quit IRC