2011-07-20 GnuCash IRC logs

00:01:38 *** puck has joined #gnucash
01:28:04 *** kpreid has joined #gnucash
02:51:35 *** e-ndy has joined #gnucash
03:47:54 *** ErKa has joined #gnucash
04:12:47 *** Krzysiek_K has joined #gnucash
04:13:07 *** Krzysiek_K has left #gnucash
06:01:03 *** Krzysiek_K has joined #gnucash
06:29:23 *** Krzysiek_K has left #gnucash
06:37:15 *** Sparxz has quit IRC
07:52:34 *** Jimraehl2 has left #gnucash
08:08:24 *** Jimraehl2 has joined #gnucash
08:23:51 *** fbond has joined #gnucash
08:25:48 *** warlord-afk is now known as warlord
09:19:36 *** fbond has quit IRC
09:28:40 *** ErKa has quit IRC
09:51:43 *** fleischergesell has joined #gnucash
09:53:24 <fleischergesell> How can I copy clients between companies? I use the mysqlbackend and only need this to do once.
09:56:59 *** fbond has joined #gnucash
10:10:01 <warlord> You could try just copying the table? But honestly this operation is not supported.
10:10:33 *** warlord is now known as warlord-afk
10:15:38 *** Jimraehl2 has quit IRC
10:20:10 <fleischergesell> I feared you say that.
10:20:55 <fleischergesell> I do not really want to mess with all those uuid stuff that gnucash uses, but I'll try to copy them over, maybe it works.
10:59:53 *** e-ndy has quit IRC
11:15:32 *** alexandros has joined #gnucash
11:16:56 *** kpreid has quit IRC
11:59:10 *** nomeata has joined #gnucash
12:10:18 *** markjenkinsparit has joined #gnucash
12:20:22 *** warlord-afk is now known as warlord
12:20:45 <warlord> fleischergesell: unfortunately it's not designed to copy from one file to another.
12:23:36 *** bunk3m has joined #gnucash
12:27:55 <fleischergesell> Yeah, well, its not file based with mysql so I might get lucky. Will try later and get back here if it fails
12:34:52 *** e-ndy has joined #gnucash
12:57:18 *** bunk3m has quit IRC
12:57:25 <warlord> By "file" I really mean "Dataset".. A SQL DB is equivalent to a "file" in this case.
13:15:01 *** Krzysiek_K has joined #gnucash
13:18:10 *** bunk3m has joined #gnucash
13:19:13 *** Krzysiek_K has left #gnucash
13:39:44 *** nomeata has quit IRC
13:40:54 <bunk3m> Hi everyone. I'm still trying to get the currency separator correct for Canadian Dollars / CAD. Gnucash is giving me $1234,56 instead of $1234.56.
13:40:54 <bunk3m> I've tried to change the defaults in the International settings but Gnucash isn't picking it up properly. All other applications including Quicken, SeeFinance, Libreoffice, Excel etc. us the correct currency separator.
13:40:54 <bunk3m> In the FAQ it says to do the following command to customize: "defaults write -app Gnucash AppleLocale = "en_US@currency=CAD" "
13:40:57 <bunk3m> but I'm getting the following error when I run that command:
13:40:59 <bunk3m> "2011-07-20 13:34:29.426 defaults[4657:10b] Couldn't find an application named "Gnucash"; defaults unchanged"
13:41:04 <bunk3m> Gnucash is located in /Applications/Gnucash/Gnucash.
13:41:08 <bunk3m> Could someone give me an idea what I am doing wrong and how to fix the currency separator? Thank you.
13:44:36 <bunk3m> Quick update. I modified the command to say
13:44:36 <bunk3m> defaults write -app /Applications/Gnucash/Gnucash.app AppleLocale="en_US@currency=CAD"
13:44:36 <bunk3m> Now the error is:
13:44:37 <bunk3m> 2011-07-20 13:42:44.553 defaults[4877:10b]
13:44:39 <bunk3m> Rep argument is not a dictionary
13:44:41 <bunk3m> Defaults have not been changed.
13:44:45 <bunk3m> I have no idea what this is supposed to mean and would appreciate some guidance. thank you.
13:45:31 <bunk3m> Oh, I see that I forgot to tell you that I am running OSX 10.5.8 on a Mac.
13:45:32 <warlord> bunk3m: I recommend you subscribe to and ask on the gnucash-user mailing list
13:45:43 <warlord> I dont see any mac people here
13:45:58 <bunk3m> OK. Thank you. I'll try that.
13:46:50 <warlord> Why not do something like LANG=en_CA, LC_NUMERIC=en_US
13:47:04 <warlord> (I think that's the right one)
13:47:17 <warlord> Besides, I thought all of Canada used 1.000,00
14:14:51 <bunk3m> Nope. Perhaps in French speaking Canada they use 1.000,00 but in English speaking Canada we use $1,234.56
14:15:44 * warlord is trying to remember what his Bramptonite friends used..
14:16:03 <warlord> I know you used D/M dates (instead of the US M/D convention)
14:17:25 <bunk3m> warlord: I ran
14:17:25 <bunk3m> locale
14:17:25 <bunk3m> and got the following:
14:17:25 <bunk3m> LANG="en_US.UTF-8"
14:17:27 <bunk3m> LC_COLLATE="en_US.UTF-8"
14:17:29 <bunk3m> LC_CTYPE="en_US.UTF-8"
14:17:31 <bunk3m> LC_MESSAGES="en_US.UTF-8"
14:17:33 <bunk3m> LC_MONETARY="en_US.UTF-8"
14:17:35 <bunk3m> LC_NUMERIC="en_US.UTF-8"
14:17:37 <bunk3m> LC_TIME="en_US.UTF-8"
14:17:39 <bunk3m> LC_ALL=
14:17:43 <bunk3m> This shows LC_NUMERIC is en_US.UTF-8
14:18:46 <warlord> Yes, but... the gnucash app might rerun 'setlocale()' based on your system locale setting.
14:23:03 *** bunk3m has quit IRC
14:25:38 *** bunk3m has joined #gnucash
14:26:22 *** bunk3m has joined #gnucash
14:32:14 <bunk3m> warlord: I've joined the gnucash-user list and posted the question there. Thank you for your help. Cheers!
14:32:28 *** bunk3m has left #gnucash
14:43:33 *** nomeata has joined #gnucash
14:53:25 *** Krzysiek_K has joined #gnucash
14:53:34 *** Krzysiek_K has left #gnucash
15:48:35 *** Krzysiek_K has joined #gnucash
15:48:36 *** fleischergesell has quit IRC
15:49:20 *** Krzysiek_K has left #gnucash
15:52:42 *** fleischergesell has joined #gnucash
16:01:07 *** fleischermeister has joined #gnucash
16:02:59 *** fleischergesell has quit IRC
16:22:32 *** alexandros has quit IRC
16:31:35 *** fleischermeister has quit IRC
16:36:28 *** e-ndy has quit IRC
16:44:40 *** alexandros has joined #gnucash
16:54:45 *** alexandros has quit IRC
17:15:40 *** alexandros has joined #gnucash
17:33:13 *** fbond has quit IRC
17:53:21 *** ErKa has joined #gnucash
18:17:46 *** nomeata has quit IRC
18:34:04 *** markjenkinsparit has quit IRC
19:07:47 *** wizkid238 has quit IRC
19:36:37 *** kpreid has joined #gnucash
20:10:39 *** Jimraehl2 has joined #gnucash
20:11:31 *** warlord is now known as warlord-afk
20:49:34 *** ErKa has quit IRC
21:31:04 *** kpreid has quit IRC
22:52:59 *** kpreid has joined #gnucash
22:56:23 *** kpreid has quit IRC
22:57:18 *** kpreid has joined #gnucash
23:45:05 *** alexandros has quit IRC