2015-01-31 GnuCash IRC logs
00:09:40 *** jimvideo has quit IRC
00:42:06 *** GabrieleV_ has joined #gnucash
00:42:12 *** GabrieleV has quit IRC
00:42:12 *** GabrieleV_ is now known as GabrieleV
00:47:13 *** gjanssens has joined #gnucash
00:47:13 *** gncbot sets mode: +o gjanssens
01:19:12 *** cartsoftware has joined #gnucash
02:05:07 *** MechtiIde has joined #gnucash
03:05:38 *** GabrieleV_ has joined #gnucash
03:05:38 *** GabrieleV has quit IRC
03:05:39 *** GabrieleV_ is now known as GabrieleV
03:06:03 *** MechtiIde has quit IRC
03:29:47 *** aqua___ has joined #gnucash
03:29:56 *** wol has joined #gnucash
03:57:21 *** MechtiIde has joined #gnucash
03:57:48 *** O01eg has quit IRC
04:07:49 *** fabior has joined #gnucash
04:38:02 *** fabior has quit IRC
04:47:51 *** aqua___ has quit IRC
04:48:11 *** MechtiIde has quit IRC
04:50:02 *** MechtiIde has joined #gnucash
05:10:11 *** MechtiIde has quit IRC
05:31:40 *** Gbarr has quit IRC
05:31:42 *** GabrieleV_ has joined #gnucash
05:32:16 *** GabrieleV has quit IRC
05:32:16 *** GabrieleV_ is now known as GabrieleV
05:54:29 *** cartsoftware has quit IRC
05:57:13 *** GabrieleV_ has joined #gnucash
05:57:21 *** GabrieleV has quit IRC
05:57:22 *** GabrieleV_ is now known as GabrieleV
06:17:45 *** himaxx has joined #gnucash
06:19:47 *** himaxx has quit IRC
06:52:51 *** himaxx has joined #gnucash
06:54:28 *** himaxx has quit IRC
07:21:43 *** GabrieleV_ has joined #gnucash
07:21:49 *** GabrieleV has quit IRC
07:21:50 *** GabrieleV_ is now known as GabrieleV
07:30:42 *** Jimraehl1 has left #gnucash
07:36:28 *** Jimraehl1 has joined #gnucash
07:45:23 *** andy has quit IRC
07:57:29 *** MechtiIde has joined #gnucash
08:00:03 *** andy has joined #gnucash
08:11:34 *** himaxx has joined #gnucash
08:16:01 *** himaxx has quit IRC
08:48:11 *** Ard0nik has joined #gnucash
08:52:13 *** GabrieleV_ has joined #gnucash
08:52:34 *** GabrieleV has quit IRC
08:52:34 *** GabrieleV_ is now known as GabrieleV
08:53:21 *** MechtiIde has quit IRC
08:56:59 *** Ardonik has quit IRC
09:06:05 *** fell has joined #gnucash
09:17:26 *** MechtiIde has joined #gnucash
09:19:15 *** gjanssens has quit IRC
09:19:21 *** aqua___ has joined #gnucash
09:20:09 *** gjanssens has joined #gnucash
09:20:09 *** gncbot sets mode: +o gjanssens
09:25:25 *** jimvideo has joined #gnucash
09:27:58 *** gjanssens has quit IRC
09:28:31 *** gjanssens has joined #gnucash
09:28:31 *** gncbot sets mode: +o gjanssens
09:32:35 *** Krzysiek_K has left #gnucash
09:38:53 *** MechtiIde has quit IRC
09:55:58 *** wol has quit IRC
10:21:52 *** mib_b8fsq6 has joined #gnucash
10:26:14 *** ErKa has joined #gnucash
10:39:51 *** gjanssens has quit IRC
10:46:53 *** MechtiIde has joined #gnucash
10:52:25 *** fabior has joined #gnucash
10:54:15 *** gjanssens has joined #gnucash
10:54:15 *** gncbot sets mode: +o gjanssens
11:02:14 *** MechtiIde has quit IRC
11:09:26 <mib_b8fsq6> Hello do you speak English?
11:09:46 <kimmo2_> yep
11:10:29 <mib_b8fsq6> Howdy! I'm having trouble with the online setup with my bank.
11:11:18 *** Gbarr has joined #gnucash
11:11:24 <mib_b8fsq6> I'm in the US, wanting to download with USD currency.In the Aq Banking Wizard I've chosen aqofxdirectconnect (the bottom choice of backends), and defaults to the euro, even after editing the account and clicking OK. Is this the problem?
11:12:21 <kimmo2_> hmm, I don't use the online banking features, I think you'd be better off waiting for jralls or warlord or gjanssens
11:12:52 * gjanssens is not using online banking either :(
11:13:00 <mib_b8fsq6> Please explain, does that mean to keep this window in the background and check for input from these handles, or can I contact them somehow?
11:14:09 <mib_b8fsq6> I see Warlord as an "idler", what does that mean please?
11:14:29 <kimmo2_> just hang around here, warlord usually pops up around this time
11:14:42 <kimmo2_> he's just left his handle online, but is away
11:14:56 <kimmo2_> most of us do
11:15:17 <mib_b8fsq6> Thanks, friend, I'll do just as you say, am feeling supported by this system, that there are humans out there in the world to help, a deep bow to you both!
11:15:19 <kimmo2_> I've been on for the better part of the past 25 years
11:15:39 <kimmo2_> warlord is actually the main developer
11:15:47 <mib_b8fsq6> aha!
11:25:54 *** cartsoftware has joined #gnucash
11:34:06 *** gjanssens has quit IRC
11:38:52 *** aqua___ has quit IRC
11:40:30 *** aqua___ has joined #gnucash
11:41:37 *** fell_ has joined #gnucash
11:50:05 *** fell has quit IRC
12:09:27 *** fabior has quit IRC
12:18:45 *** Ahmuck has joined #gnucash
12:19:00 <Ahmuck> well i think i found my hack to get done what i need to do
12:21:25 *** ErKa has quit IRC
12:34:00 <mib_b8fsq6> Hello Ahmuch, any chance you can help me hack my way to a successful online banking set up?
12:40:11 <Ahmuck> i've not done that yet
12:40:25 <Ahmuck> u mean as in pulling down qif files?
12:45:24 *** himaxx has joined #gnucash
12:47:20 *** himaxx has quit IRC
12:53:41 <Ahmuck> mib_b8fsq6, ping
13:08:44 *** himaxx has joined #gnucash
13:37:41 *** Ahmuck has quit IRC
13:51:02 *** gjanssens has joined #gnucash
13:51:02 *** gncbot sets mode: +o gjanssens
14:16:02 *** jralls has joined #gnucash
14:16:03 *** gncbot sets mode: +o jralls
14:21:54 <jralls> mib_b8fsq6: Don't worry about the default currency, that's just because the
14:22:47 <jralls> mib_b8fsq6: Scratch that. Where are you getting seeing the default currency?
14:33:25 *** mib_b8fsq6 has quit IRC
14:46:16 *** gjanssens has quit IRC
14:46:55 *** kode has joined #gnucash
14:48:56 <kode> Hi, i need some help. I exported a list of txs in csv format and try to import it back, but i got msg "There are problems with the import settings.."
14:49:39 <kode> Tried to check "Skip alternate rows.." and set "Start import on row" with various combinations.
14:50:01 <kode> Anyone has an idea what could be wrong?
15:08:50 *** GabrieleV_ has joined #gnucash
15:08:52 *** GabrieleV has quit IRC
15:08:52 *** GabrieleV_ is now known as GabrieleV
15:33:18 <jralls> kode: IIRC the csv doesn't round-trip cleanly, but I don't remember the details.
15:35:45 <kode> I have a huge excel file that i want to import to Gnucash. I wanted to prepare csv to import, and then save as sqlite3 in order to play with the data
15:35:57 <kode> jralls: Do you know some other options?
15:36:18 <jralls> kode: For doing what?
15:36:54 <kode> To move the data into Gnucash and save it as sqlite3
15:37:31 <kode> I can export the excel as csv and modify it with script to prepare gnucash format
15:37:34 <jralls> Oh, sorry. Where did the spreadsheet data come from?
15:37:45 <kode> but since the import is not working, this is not an option.
15:38:12 <kode> The spreadsheet is a file that i filled over the years
15:39:13 <jralls> Perhaps I misunderstood. Is that what you tried to import, or did you try to import a CSV file that you'd exported from GnuCash?
15:40:26 <kode> No, this is my goal - to modify the excel -> csv and import it into Gnucash.
15:41:00 <kode> And the issue I have is that I filled some of the txs into gnucash, export it into csv, and then try to import it back.
15:41:24 <kode> But the import is giving the message in red text
15:42:09 <kode> So, basically i am trying to import exported csv from Gnucash.
15:42:37 *** ErKa has joined #gnucash
15:42:51 <jralls> Got it. You tried to use the exported csv as a sample to help you format the larger file. Unfortunately that doesn't work well because the importer expects a somewhat different format from what gets exported.
15:44:38 <kode> Exactly. Is there a sample format of a csv file that can be imported?
15:48:22 <kode> jralls: Do youknow any other format that can be used for import and is easily modified?
15:49:44 <jralls> kode: Both QIF and OFX are text formats, but you'd need to write a program to convert your CSV or Excel File.
15:50:07 <kimmo2_> hrm
15:50:11 <jralls> But the CSV importer does work, just not with exported files.
15:50:12 <kimmo2_> I have an extra 15 euros
15:50:22 <kimmo2_> I wonder how
15:50:41 <jralls> Or rather, just not with unedited exported files.
15:51:28 <kode> jralls: Do you know where i can find working example csv for import?
15:52:00 <jralls> kode: No, and I just googled to look for something and came up dry.
15:52:30 <jralls> But I don't think that the actual format is that critical as long as the data are all there and there aren't a bunch of blank lines.
15:53:54 <kode> Sure. I will try figure it out. Thanks for your time.
15:54:28 <jralls> Oh, I see another problem with the export: It's splitting transactions across multiple lines. That won't work.
15:58:27 <jralls> So edit it to remove the split lines.
16:00:51 <kode> jralls: Should be there only one line or two? (currently there are 3)
16:03:29 <jralls> kode: Only one. You need to indicate at least date, description, deposit, and withdrawal. I think. Everything else should be extraneous. I'm not sure about the account field. That might be necessary to tell it what is the primary account; the counter-account should be picked up by the matcher.
16:10:54 *** mishehu_ has quit IRC
16:13:11 <kode> jralls: Yep, that worked. Thanks a lot!
16:16:23 <jralls> kode: You're welcome.
16:33:21 *** jimvideo has quit IRC
16:34:21 *** GabrieleV_ has joined #gnucash
16:34:22 *** GabrieleV has quit IRC
16:34:23 *** GabrieleV_ is now known as GabrieleV
16:43:54 *** aqua___ has quit IRC
17:08:51 *** GabrieleV_ has joined #gnucash
17:09:27 *** GabrieleV has quit IRC
17:09:28 *** GabrieleV_ is now known as GabrieleV
17:36:58 *** kode has quit IRC
17:49:16 *** desperateFish has joined #gnucash
18:07:12 *** himaxx has joined #gnucash
18:17:18 *** himaxx has quit IRC
18:37:45 *** kode has joined #gnucash
18:47:46 *** kode has quit IRC
19:00:48 *** calp_ has joined #gnucash
19:03:38 <keret> Hi. Have a question about charge-backs.
19:04:11 <keret> I have a bill that is partially reimbursable by another entity (a customer in gnc-speak).
19:04:53 <keret> Would it be best to generate 2 separate gnc bills - one for the reimbursable part and one for the non-reimbursable part.
19:05:56 *** calp has quit IRC
19:05:56 *** calp_ is now known as calp
19:06:15 <keret> Or generate a single bill, setting the customer in the new invoice dialog and splitting up the reimbursable/non-reimbursable components as separate splits/items in the lower section of the bill, with the reimbursable items flagged as billable?
19:06:50 *** ErKa has quit IRC
19:06:52 <keret> Or is there another, better approach?
19:42:51 *** GabrieleV_ has joined #gnucash
19:42:56 *** GabrieleV has quit IRC
19:42:57 *** GabrieleV_ is now known as GabrieleV
20:32:57 *** desperateFish has quit IRC
21:07:21 *** GabrieleV_ has joined #gnucash
21:07:57 *** GabrieleV has quit IRC
21:07:57 *** GabrieleV_ is now known as GabrieleV
21:11:40 *** ErKa has joined #gnucash
21:31:01 *** ErKa has quit IRC
22:33:32 *** Ahmuck has joined #gnucash
22:37:20 <Ahmuck> i'm having problems with csv import
22:38:24 <Ahmuck> i'm getting the following error
22:38:26 <Ahmuck> There are problems with the import settings!
22:38:26 <Ahmuck> The date format could be wrong or there are not enough columns set...
22:38:49 <Ahmuck> i was looking through the docs for a csv format example but have not found any yet
22:41:46 <Ahmuck> i think i've figured it out. sry. i need accounts setup i think
22:50:05 <Ahmuck> so i can import accounts by creating a csv file with a column header "Accounts" and accounts labeled as "Expenses:Automobile:Gasoline" ?
22:52:17 <Ahmuck> ok, looking at "new account" i understand the csv import, however i don't see "type" there
22:52:50 <Ahmuck> ok, nm, got it
23:14:29 *** Ahmuck has quit IRC
23:30:29 *** Ahmuck has joined #gnucash
23:39:30 <bozonius> More fun... so I try to use that "job" (see business menus...) and I can't change the owner of the job -- it is owned by a customer that was also created by accident. This is frustrating.
23:39:53 <bozonius> I created that job by accident, too.
23:39:57 <bozonius> Trying to re-use it.
23:40:18 <bozonius> The job is not part of any invoice.
23:40:33 <bozonius> And the customer is a dummy called "blank"
23:40:51 <bozonius> (I renamed the job "blank" also to be consistent)
23:44:10 <bozonius> OK! I think I've "solved" this... if you can call obfuscation genuine closure, but it works for me
23:44:44 <bozonius> I made these records "inactive" by unchecking the boxes in the dialogs -- they don't show up if I set my find params to look only for active records.
23:45:29 <bozonius> Not the solution I'd like, ideally, but I guess it will work for the time being. When I create a new customer, I can reuse the now-hidden record. Then I can re-use the now-hidden job for that customer.
23:45:40 <bozonius> Just have to remember though. ;^)