2014-04-21 GnuCash IRC logs
00:14:10 *** benoitg has quit IRC
00:21:42 *** ErKa has quit IRC
00:49:08 *** alazyguy has joined #gnucash
00:50:04 <alazyguy> Hi, is it possible to make journal entries in excel, and import it into GnuCash? I making the entry I want in GnuCash, and exporting it into csv to see what format I have to follow, but can't make heads or tails of the CSV.
00:50:30 <alazyguy> I tried making*
00:56:58 <alazyguy> Basically, I want to turn this: http://puu.sh/8ha5E.png into this: http://puu.sh/8ha75.png
02:17:11 *** O01eg has quit IRC
02:18:33 <alazyguy> I see that the "Possibly a few hours!!!" in the topic wasn't a lie. XD
02:40:46 *** MechtiIde has joined #gnucash
03:06:58 *** SteveG has joined #gnucash
03:18:19 *** drl has quit IRC
03:18:46 <alazyguy> Does anyone know how to make journal entries ine xcel, and import it into GnuCash? I've tried making the entry in GnuCash, and exporting the entry as a csv to get the format to follow, but can't make heads or tails of the CSV. I want to turn this: http://puu.sh/8ha5E.png into this: http://puu.sh/8ha75.png
03:20:41 *** floh1111 has joined #gnucash
03:36:02 *** gjanssens has joined #gnucash
03:36:02 *** gncbot sets mode: +o gjanssens
03:36:53 <alazyguy> Does anyone know how to make journal entries in excel, and import it into GnuCash? I've tried making the entry in GnuCash, and exporting the entry as a csv to get the format to follow, but can't make heads or tails of the CSV. I want to turn this: http://puu.sh/8ha5E.png into this: http://puu.sh/8ha75.png Sorry for spamming this. Is there a forum somewhere for questions like this?
03:56:03 *** floh1111 has quit IRC
04:15:49 <mikee> alazyguy: No need to re-ask your question. Try the mailing list https://lists.gnucash.org/mailman/listinfo/gnucash-user
04:18:48 <alazyguy> Okay, thanks. Hopefully reproducing the "General Ledger" function in GnuCash using a spreadsheet is possible...
04:51:44 *** alazyguy has quit IRC
05:47:17 *** SteveG has quit IRC
05:49:37 *** drl has joined #gnucash
05:56:37 *** fell has joined #gnucash
05:56:37 *** gncbot sets mode: +o fell
06:30:39 *** TradeBorG11110 has joined #gnucash
06:46:36 *** aqua___ has joined #gnucash
07:14:46 *** Jimraehl1 has joined #gnucash
07:15:34 *** SteveG has joined #gnucash
07:24:50 *** Jimraehl1 has quit IRC
07:55:19 *** fell_ has joined #gnucash
07:55:19 *** gncbot sets mode: +o fell_
08:04:24 *** fell has quit IRC
08:09:40 *** fell_ is now known as fell
08:12:14 *** SteveG has quit IRC
08:16:24 <drl> We are using the wizard to set up a chart of account. We are at the Setup Selected Accounts window. It will not let us make Placeholder accounts. What are we doing wrong?
08:17:28 <drl> We are using version 2.6.3 for Windows.
08:28:19 *** Jimraehl1 has joined #gnucash
08:38:23 *** Jimraehl1 has quit IRC
08:48:38 *** aqua___ has quit IRC
08:49:14 *** aqua___ has joined #gnucash
09:21:06 *** lmat has joined #gnucash
09:37:19 *** wol has joined #gnucash
09:38:39 *** jmd has joined #gnucash
09:38:44 <jmd> #gnu-webmasters
09:58:06 *** gregg4567 has joined #gnucash
10:06:09 *** ErKa has joined #gnucash
10:41:27 *** danield has joined #gnucash
10:44:28 *** uXus has joined #gnucash
10:45:07 *** aqua___ has quit IRC
10:45:43 <danield> Hi. I'm interested to know if there are any sets of account used for testing the 'Advanced Portfolio' report. I'm curious to know how cash dividends which normally go from Income:Dividends to a cash account (http://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-dividends1.html) are connected to the actual stock holding.
10:58:30 <warlord> drl: What do you mean "wont let you set up placeholder accounts"?
10:59:16 <warlord> danield: If they are not reinvested I believe they are not connected at all.
10:59:38 <warlord> (except through convention of using the stock name in the income account name)
11:03:45 <danield> warlord: The reinvested dividends show up as expected in the Advanced Portfolio report. However I was having trouble with the cash dividends
11:04:19 <danield> warlord: I've got a sort of workaround which isn't too bad but I've not tried it on 2.6.3
11:04:44 <warlord> I know that the reporthas been redone for 2.6.x
11:05:07 <danield> warlord: Okay, looks like I'll have to try that out.
11:06:26 <danield> warlord: My workaround for 2.4.x is to have 3 splits for a dividend (amount x for income:dividend:ticker, amount x for cash account, then 0 amount for stock holding account)
11:06:35 <warlord> okay
11:07:15 <danield> warlord: I was surprised it worked with a 0 amount in the stock holding account but it seems to)
11:08:50 *** linas__ is now known as linas
11:15:55 <drl> warlord: It won't let me place a checkmark in the Placeholder square.
11:18:14 <warlord> drl: in the hierarchy helper? or in the Edit Account dialog?
11:30:58 <drl> warlord: in the setup wizard.
11:31:23 <warlord> I'm not sure you're allowed to change them there. I think they are for display purposes only. You can change them later.
11:31:33 <warlord> Can you set them there on other platforms?
11:32:50 <drl> warlord: I don't know, but if they can be changed later then I'm not worried. Thanks for the info.
11:34:50 *** jralls has quit IRC
11:35:23 *** jralls has joined #gnucash
11:36:52 *** todd has quit IRC
11:37:40 *** todd has joined #gnucash
11:44:43 *** O01eg has joined #gnucash
12:46:24 *** wol has quit IRC
12:50:48 *** drl has quit IRC
13:07:16 *** uXus has quit IRC
13:07:25 *** uXus has joined #gnucash
13:08:18 *** wol has joined #gnucash
13:11:01 *** jmd has quit IRC
13:22:13 *** jmd has joined #gnucash
13:27:07 *** aqua___ has joined #gnucash
14:02:01 *** warlord has quit IRC
14:16:34 *** warlord has joined #gnucash
14:16:34 *** gncbot sets mode: +o warlord
14:32:57 *** PpGo has joined #gnucash
14:37:11 <PpGo> when gnucash start,why sometimes don't translate the menus to spanish?
14:37:33 <warlord> PpGo: what OS/Distro?
14:37:55 <PpGo> Windows vista
14:39:28 <warlord> either your system settings aren't set to spanish, or the gnucash 'environment' file isn't configured for spanish
14:41:52 <PpGo> how configure gnucash environment file?
14:50:21 *** wol has quit IRC
15:01:12 *** PpGo has quit IRC
15:18:36 *** jmd has quit IRC
15:30:31 *** aqua___ has quit IRC
15:33:05 *** MechtiIde has quit IRC
15:35:10 *** fell_ has joined #gnucash
15:35:11 *** gncbot sets mode: +o fell_
15:39:23 *** Krzysiek_K has joined #gnucash
15:41:50 *** hashable has joined #gnucash
15:42:04 *** fell has quit IRC
15:43:28 <hashable> Hey there - wondering if anyone knows a way to set up quick-viewing of all my balances from an Android phone (web-based, application, summary auto-uploaded to Google Drive?)
15:45:54 <jralls> GnuCash doesn't have anything like that. The best you could do would be to generate a report, export it as html, and put that on Google Drive.
15:48:03 <hashable> That makes good sense, thank you. Is there any way to set up automated creation of reports?
15:56:02 *** wol has joined #gnucash
16:18:52 *** himaxx has joined #gnucash
16:20:40 *** himaxx has quit IRC
16:30:33 *** aqua___ has joined #gnucash
16:32:50 *** gjanssens has quit IRC
16:35:06 *** wol has quit IRC
16:46:36 *** PpGo has joined #gnucash
16:52:05 *** PpGo has quit IRC
16:57:03 *** hashable has quit IRC
17:04:54 *** floh1111 has joined #gnucash
17:17:28 *** MWB has joined #gnucash
17:26:37 <MWB> Hello everyone, as nooby I tried to start with gnucash [on win8.1 - Dutch]. On startup it gives a problemwindow: gnucash.exe - No disk [There is no disk in the station. Please place a suitable medium in station C:.] That old problemwindow that always came up when you tried to open the floppy / cd / dvd disk when no disk was in place. I do not have a C: drive, gnucash is installed on E:. When
17:26:37 <MWB> I hit continue (from cancel / try again / continue) it starts to load, but requires me to hit continue about 50 times (or more) while loading. Anyone knows what went wrong. Is is a bug, did I do something wrong or is it something else altogether?
17:27:15 <MWB> Thanks in advance!
17:30:50 *** floh1111 has quit IRC
17:31:12 *** danield has quit IRC
17:40:42 *** gregg4567 has left #gnucash
17:46:48 *** wol has joined #gnucash
17:54:13 *** wol has quit IRC
17:58:40 *** jralls has quit IRC
18:07:44 *** linas_ has joined #gnucash
18:07:44 *** linas has quit IRC
18:12:08 *** aqua___ has quit IRC
18:23:04 *** PpGo has joined #gnucash
18:23:58 <PpGo> hi, how configurate gnucash language to spanish?
18:51:49 *** erpingham_ has joined #gnucash
18:59:31 *** jralls has joined #gnucash
19:28:03 *** PpGo has quit IRC
19:28:30 *** benoitg has joined #gnucash
19:40:17 <warlord> MWB: why don't you have a C: drive?
19:59:43 *** MWB has quit IRC
20:02:56 *** erpingham_ has quit IRC
21:09:02 *** ErKa has quit IRC
21:09:53 *** amjam has joined #gnucash
22:29:35 *** fell_ has quit IRC
22:53:59 *** TradeBorG11111 has joined #gnucash
23:00:59 *** TradeBorG11110 has quit IRC
23:37:05 *** amjam has quit IRC