2014-02-06 GnuCash IRC logs

00:19:08 *** kpreid has quit IRC
00:20:01 *** kpreid has joined #gnucash
00:38:53 *** C has joined #gnucash
00:54:19 *** C has quit IRC
01:11:53 *** MechtiIde has joined #gnucash
01:45:51 <fell> warlord: I am trying upload of images in De/Onlinebanking-Einrichtungsassistent and
01:46:08 <fell> get error: Fehler beim Erstellen des Vorschaubildes: Die Miniaturansicht konnte nicht am vorgesehenen Ort gespeichert werden
01:47:00 <fell> Error creating preview. could not be stored at the designated place.
01:47:56 <fell> Probably your manual uploads are in the way. Can you remove them?
01:52:47 <fell> My upload is stored as http://wiki.gnucash.org/wiki/images/1/18/Assistent1.png
01:53:32 <fell> Yours are in http://wiki.gnucash.org/wiki/images/assistent1.png
01:56:52 <fell> They have the form: [Ass[istant][-][netbank]*.png
02:07:08 *** MechtiIde has quit IRC
02:15:26 *** fell_ has joined #gnucash
02:15:26 *** gncbot sets mode: +o fell_
02:24:24 *** fell has quit IRC
02:42:33 *** fell_ is now known as fell
03:03:28 *** aqua___ has joined #gnucash
03:16:42 *** gjanssens has joined #gnucash
03:16:43 *** gncbot sets mode: +o gjanssens
03:28:08 *** aqua_ has joined #gnucash
03:32:59 *** aqua___ has quit IRC
03:52:07 *** aqua_ has quit IRC
04:18:14 *** aqua___ has joined #gnucash
04:30:21 <fell> gjanssens: Are the notes about trunk still valid in http://wiki.gnucash.org/wiki/Git#Non-Committers ?
04:37:11 *** stephan48 has quit IRC
04:50:51 *** stephan48 has joined #gnucash
05:06:15 <gjanssens> fell: thanks for pointing that out.
05:06:22 <gjanssens> The notes were no longer valid
05:06:31 <gjanssens> I have updated them to my best knowledge
05:07:06 <gjanssens> Our branching strategy still needs thought and discussion though
05:09:13 * fell is reloading and rereading
05:25:00 * fell added some cosmetics.
05:41:26 *** aqua___ has quit IRC
07:01:11 *** Jimraehl1 has joined #gnucash
07:06:16 *** Jimraehl1 has quit IRC
08:10:51 *** benoitg has quit IRC
09:18:24 *** benoitg has joined #gnucash
09:31:41 *** Legolas has joined #gnucash
09:32:00 <Legolas> Hi
09:52:31 *** lmat has joined #gnucash
10:22:25 <gjanssens> fell: thanks for the cosmetics in the wiki
10:23:04 <fell> Welcome!
10:26:42 <fell> But I still have a practical problem: What is the best way to fetch changes from github/userX, test them and push them.
10:28:27 <fell> Hi, Legolas! If there is a question just ask,
10:42:34 *** ErKa has joined #gnucash
10:43:26 <gjanssens> fell: push these changes where ?
10:43:46 <gjanssens> back to github or to code.gnucash.org ?
10:43:51 <fell> upstream
10:44:08 <fell> to code
10:45:57 <Legolas> hello
10:46:23 <Legolas> I have a problem with a gnucash file, can someone help me?
10:46:37 <gjanssens> fell: you specify the repository you want to push to as first command line argument to push
10:47:00 <gjanssens> like: git push upstream <frombranch>:<tobranch>
10:47:34 <gjanssens> But I recommend you'd first run a git rebase master <yourbranch>
10:47:53 <gjanssens> That will give you the best push experience
10:47:57 <fell> logo
10:48:17 <Legolas> I got the error "no suitable backend found" after recovery a gnucash file from a bad HDD, I recover the file with recuva, the size its ok, but cant open it.
10:48:21 <gjanssens> If you forget the rebase step, you may end up with a merge action while pushing
10:48:55 <gjanssens> Legolas: how was the file saved originally ? In xml format or sqlite format ?
10:49:11 <Legolas> XML format
10:50:16 <gjanssens> Ok, and which version of GnuCash are you using ?
10:51:37 <Legolas> 2.6.1
10:52:14 <fell> can you open cmd.exe
10:52:36 <Legolas> ok
10:52:47 <Legolas> I am on Windows, forgot tell you
10:52:54 <Legolas> cmd open
10:52:58 <fell> Then try gnucash <path/to>EPSMedical.gnucash
10:55:45 <Legolas> I tried the command and same warning appeared
10:56:14 <fell> Nothing else?
10:57:06 <fell> No other output?
10:57:11 <Legolas> not
10:57:44 <fell> Follow the instructions in http://wiki.gnucash.org/wiki/FAQ#Q:_Something_bad_happened.3B_how_can_I_help_debug.3F
10:57:45 <Legolas> gnucash its open and them show the warning
10:58:03 <gjanssens> Legolas: the gnucash data file is normally a compressed zip file
10:58:13 <gjanssens> Let's check if it is still intact:
10:58:17 <Legolas> ok
10:58:49 <gjanssens> make a copy of the file and rename it to EPSMedical.gnucash.zip
10:59:18 <gjanssens> Then try to open the file that ends in .zip in your windows explorer
10:59:37 <gjanssens> If not corrupt it should open as a directory with one file in it
11:00:24 <Legolas> Winrar says its damaged
11:00:44 <Legolas> or unknow format
11:01:26 <gjanssens> Which means it probably is I'm afraid
11:01:53 <Legolas> :(
11:02:30 <gjanssens> Just in case it wasn't compressed (which is an option in GnuCash), can you try to open EPSMedical.gnucash in a text editor
11:02:40 <gjanssens> to see if that gives you a readable xml file
11:03:05 <gjanssens> With text editor I mean word pad or notepad or similar
11:03:50 <gjanssens> If these show only garbage your file was compressed and not properly recovered from your bad hd
11:04:04 <Legolas> Not, i have only symbols
11:04:08 <Legolas> garbage
11:04:40 <Legolas> ok, but hte program that I use its Recuva, if I use another programa its possible recover the file or are the same soft?
11:05:30 <gjanssens> I have no idea. I don't know Recuva
11:05:49 <gjanssens> And in general the chances of recovery really depend on how badly the disk crashed
11:05:57 <gjanssens> Sorry about that
11:06:16 <gjanssens> Did Recuva recover gnucash backup files as well, or only the main file?
11:06:47 <gjanssens> If it found backup files as well you may try to those
11:07:12 <fell> Files in the form EPSMedical.YYYY-MM-DD-HH-SS.gnucash
11:07:55 <Legolas> yes, I recover files EPSMedical.YYY-MM-DD-HH-SS.gnucash
11:08:01 <Legolas> but say the same error
11:08:52 <fell> Geert, have sqlite files the same ending?
11:08:58 <gjanssens> yes
11:09:44 <fell> And the contnt looks like garbage?
11:09:52 <gjanssens> Yes
11:09:59 <Legolas> yes like garbage
11:10:01 <gjanssens> But on Windows it doesn't matter
11:10:18 <gjanssens> GnuCash on Windows ships with the sqlite and xml backends by default
11:10:26 <fell> Sorry, time for supper.
11:11:10 <Legolas> them if try on gnucash of ubuntu can be open?
11:11:11 <gjanssens> On other platforms the error "no suitable backend found" can mean you are trying to open a file saved in a format for which no backend is installed
11:11:36 <gjanssens> You can certainly try
11:12:53 <gjanssens> To rule out bugs in GnuCash for Windows
11:13:05 <gjanssens> But if the datafile is really corrupted, no version of gnucash will be able to open it unfortunately
11:14:20 <Legolas> ouch
11:14:50 <gjanssens> Yeah, ouch :(
11:15:16 <gjanssens> I don't suppose you had external backups of your data file ?
11:16:26 <Legolas> Not, I dont have, that its the problem, the disk suddenly its bad.
11:18:16 <gjanssens> That's a painful confrontation with one basic computing rule: always make backups of important data
11:18:50 <gjanssens> With harddisk failure it's not a question of "if" but of "when"
11:19:09 <gjanssens> I'm sorry we can't be of more help here
11:23:10 <Legolas> ok, do you use ubuntu?
11:23:59 <gjanssens> No, I'm on fedora
11:24:56 <Legolas> but have the gnucash installed, maybe its open on another plataform
11:26:54 <gjanssens> I'm not sure I understand you properly
11:27:26 <gjanssens> Do you want me to try and open your data file ?
11:29:00 <Legolas> yes
11:29:04 <Legolas> if its not problem
11:29:08 <Legolas> for you
11:31:02 <gjanssens> Ok, I'm willing to give that a try.
11:36:31 *** gncbot` has joined #gnucash
11:36:50 *** aqua___ has joined #gnucash
11:38:27 <Legolas> how can I sen dyou?
11:39:26 *** gncbot has quit IRC
11:42:13 *** kpreid has quit IRC
11:42:30 *** gjanssens sets mode: +o gncbot`
11:45:59 *** benoitg has quit IRC
11:50:48 *** JeremyK has quit IRC
12:00:16 *** TradeBorG114 has joined #gnucash
12:05:24 *** aqua___ has quit IRC
12:05:26 *** benoitg has joined #gnucash
12:07:14 <gjanssens> Legolas: I looked at your data files, but they won't open on Fedora either
12:07:31 <gjanssens> I doubt however that these are gnucash files, even if named like that
12:08:21 <gjanssens> Among the garbage there are lots of keywords (near the end of the file) that are not in common in gnucash files
12:08:35 <gjanssens> And certainly should not be there if the files are zipped xml files
12:09:07 <gjanssens> So it looks like Recuva is either doing odd things to the recovered files and you should open them via Recuva or so
12:09:19 <gjanssens> Or Recuva is plainly mistaken
12:09:34 <gjanssens> That can happen if the disk meta data is messed up
12:11:09 <gjanssens> There nothing else I can do for you, sorry
12:11:30 <Legolas> ok thanks, them its possible try with another
12:11:39 <Legolas> program to recover the data
12:11:58 <Legolas> else I need work on copy all the data again
12:16:26 *** ErKa has quit IRC
12:19:06 *** jmd has joined #gnucash
12:20:58 *** MechtiIde has joined #gnucash
12:23:28 *** Krzysiek_K has joined #gnucash
12:37:56 *** Krzysiek_K has quit IRC
12:53:14 <warlord> fell: I don't have any of the old images anymore.. I didn't move them across to the new server.
12:54:06 <fell> Ok, warlord, then there must be another reason.
12:56:07 <warlord> fell: yeah, it looks like an error with a preview. I'll research. The image itself is there.
13:00:08 <warlord> fell: is that the *actual* english error message, or your translation of the german?
13:01:18 <warlord> I don't see anything obvious in the logs.
13:01:19 <fell> I got the german message, the english is my retranslation of the content.
13:02:32 *** ErKa has joined #gnucash
13:02:59 <warlord> fell: ah. That explains why my searching cannot find the error ;)
13:04:36 *** Krzysiek_K has joined #gnucash
13:05:35 <fell> http://wiki.gnucash.org/wiki/Special:ListFiles
13:07:10 <warlord> thx
13:10:21 <warlord> From there I found http://www.mediawiki.org/wiki/Thread:Project:Support_desk/Error_creating_thumbnail:_Unable_to_save_thumbnail_to_destination/reply
13:14:10 <warlord> Okay, I think I've fixed it, but I don't know how to get MW to re-attempt to create the thumbnail from your upload.
13:14:40 <fell> I can upload i again.
13:14:58 <warlord> Yeah, you might need to.. Can you?
13:15:31 *** JeremyK has joined #gnucash
13:16:32 <fell> http://wiki.gnucash.org/wiki/De/Onlinebanking-Einrichtungsassistent
13:17:18 <warlord> Awesome. Looks like the thumbnail is there.
13:18:37 <fell> One minor issue in the upload page: the licence list is empty.
13:37:07 <fell> Finally after 2 month and 14h the page is ready! ;-)
13:51:25 *** lmat has quit IRC
13:59:43 <fell> I announced the feature on gnucash-de, -devel and -user.
14:11:11 <warlord> Hmm.. not sure what to do about the license page..
14:11:56 <warlord> Note that upload is limited to an explicit set of users. A user needs to me a member of the "uploadaccess" group
14:14:21 *** lmat has joined #gnucash
14:15:32 <fell> I told them the admins can upload.
14:17:32 <warlord> that is true
14:19:03 <warlord> fell: if there are non-admins that are trustworthy we can give them upload access.
14:20:11 <fell> OK, why not
14:21:13 <warlord> Do you have permissions to do that?
14:21:21 <fell> If you like, you can respond with the details.
14:24:56 <fell> I am in Admins and can upload. I don't know if I can grant rights, but believe thats what bureaucrats are for.
14:26:26 <warlord> true
14:26:34 <fell> You could consider to promote a few active admins to bureaucrats.
14:27:25 <fell> jralls, gjanssens and me
14:29:46 <warlord> True. Wouldn't be a bad idea.
14:36:21 * gjanssens has never been called a bureaucrat before. Is that a compliment or an insult ? ;)
14:39:53 <warlord> fell: I'm considering deleting all user accounts that were not email-verified and haven't been touched since 2014.. There's 16000 of them. So the question is: should I make a list of those first? Or just delete them outright? (I've verified that WikiSysop isn't included)
14:41:32 <fell> I would dump them on a cd or floppy
14:42:24 <fell> Just for the case we forgot a criteria.
14:44:21 <warlord> Well, I can make a backup of the database before I do it.. I'm not sure how to dump out just those items ...
14:45:32 <fell> SELECT * WHERE ... TO file; IIRC
14:46:41 <warlord> select count(*) from user where user_email_authenticated is NULL and user_touched < 20140202010000;
14:46:52 <warlord> gives me: 16605
15:03:12 <warlord> Okay, I was able to dump it out:
15:03:21 <warlord> select * from user where user_email_authenticated is NULL and user_touched < 20140202010000 into outfile '/tmp/user.sql' FIELDS TERMINATED by ',' LINES TERMINATED BY '\n';
15:04:04 <warlord> Can I safely just delete those users from the user table? Or is there some better way to mass-delete them?
15:05:30 *** Legolas has quit IRC
15:07:17 <warlord> My fear is that just deleting them from the user table may leave residual references.
15:09:28 <warlord> fell: even though that will remove 16605 accounts, there are currently 29814 in the db. Which means there are still a lot that are "valid" (at least by the above constraints.
15:15:32 <fell> That depends on the db design. A good design would not leave much residuals.
15:17:25 <fell> 33% is much, IMHO. We can later try other criterias.
15:17:42 <warlord> What about user residuals? Like user pages? Or edits?
15:17:57 <warlord> I guess if the page doesn't exist then it doesn't exist..
15:20:00 <warlord> fell: also FYI I enabled the 'Nuke' extension to allow Mass Deletion of pages.
15:20:10 <fell> I think, if they didn't confirm, they couldn'tedit?
15:20:18 <warlord> That wasn't true for a while.
15:24:34 <fell> compare the user pages with your list.
15:36:10 <warlord> There are 16000 names in my list.. Not sure how to best do that search..
15:40:42 <warlord> if there were a good sql command to run I would..
15:42:40 <fell> TOday I am too tired, to work it out. I could tomorow study the db srtucture-
15:43:13 <jmd> fell: There is no such word as 'criterias'.
15:46:08 <fell> count(*) from pages ... user:name ... in yourlist
15:47:53 <fell> equivalent to http://wiki.gnucash.org/wiki/index.php?title=Special%3APrefixIndex&prefix=&namespace=2
15:49:08 <fell> the user pages are not much
15:49:49 <fell> user talk: http://wiki.gnucash.org/wiki/index.php?title=Special%3APrefixIndex&prefix=&namespace=3
15:50:59 *** jmd has quit IRC
16:02:19 *** TradeBorG114 has quit IRC
16:05:24 *** fell has quit IRC
16:11:10 *** fell has joined #gnucash
16:11:31 *** fell has quit IRC
16:22:29 <JeremyK> I am looking for a report that will show all of the invoices and bills related to a specific job. I can't seem to find one. The final result would be to have as a income/expense statement for a job. Any Ideas?
16:26:30 <warlord> JeremyK: did you try the Job Report?
16:28:35 <JeremyK> I did. I can select a job. But only the accounts receivable shows up. Not the Invoices or bills. Also the even after the Invoice for the job has been posted, paid and not in AR anymore. The Job Report still shows the invoice as due.
16:29:29 <warlord> JeremyK: try your receivables aging and Customer reports.. If reports are still showing an invoice as due that means you didn't Process Payment correctly.
16:33:57 <JeremyK> both the receivables aging and the Customer reports show that there is no money owing. The accounts all show the money in the correct accounts. The Job report shows "Total Due : 129.00" but the "0-30 days" shows "$0". The Job report does not show the bills that I have associated with the job just the invoice.
16:39:29 <warlord> How did you try to associate Bills with the job?
16:39:53 <warlord> Jobs are tied to Customers or Vendors, (Customer Job, Vendor Job).. They are not meta objects.
16:40:03 <warlord> So I dont know how you could create a Bill against a Customer Job
16:41:11 <JeremyK> I goto Vender and Create a new bill and use the default charge back to customer with a specific job
16:41:42 <warlord> I don't think that does what you think it does..
16:41:50 <JeremyK> oh
16:41:51 <warlord> It wont show up on a "Job Report"
16:42:39 <warlord> what it does is says that entries on the bill that you mark as "ChargeBack" will be available to be added to an invoice that's owned by the Job's Customer
16:42:54 <warlord> (at least I'm pretty sure it wont show up on a Job report)
16:44:57 <JeremyK> I thought that because you can select on the vender bill as not "Billable" it will not show up on the next customer invoice. But that it was still associated with that job.
16:45:29 <warlord> Nope
16:45:48 <warlord> If it's not billable then it's not tied to the (customer) Job at all.
16:47:43 <JeremyK> So how can I track my expenses to a specific job? Could I create a vender Job and a Customer job and then have a report that will show both and the difference?
16:48:17 <warlord> Maybe.... And you would have to write that report.
16:48:27 <warlord> Currently GnuCash doesn't do that.
16:48:36 <warlord> (the Job feature was poorly considered)
16:51:16 <JeremyK> That would be my down fall.... report writing. You have been kind in the past and helped me configure a few tweaks to invoices. I would be willing to give it a go. But I would be asking a ton of questions along the way. I really want to stay on your good side.
16:52:18 *** aqua___ has joined #gnucash
16:54:29 <warlord> LOL
16:54:36 <warlord> Buy me a beer ;)
16:54:46 * warlord has to go for a bit. I'll be back in a while.
17:09:26 *** lmat has quit IRC
17:19:13 <JeremyK> So I have been doing some digging. The Job report will show all of the invoices from a customers Job. But will not show any of the bills from the venders Jobs, if the Venders job is selected. I think that this is the first thing to solve.
17:26:02 *** gjanssens has quit IRC
17:26:53 <JeremyK> Also on the job report if an invoice has been posted but not paid it shows under the 91+ days. Yet on the Receivable Aging it shows under the 0-30 days.
17:29:36 *** aqua___ has quit IRC
17:32:29 *** JeremyK is now known as JeremyK-AFK
17:37:04 *** JeremyK-AFK is now known as JeremyK
17:38:10 <JeremyK> I think the reason that the Venders Job does not show bills is because I cannot select an Accounts Payable just a Accounts Receivable
17:42:50 *** JeremyK is now known as JeremyK-
17:43:01 *** JeremyK- is now known as JeremyK-AFK
18:49:50 *** JeremyK-AFK has quit IRC
19:36:50 *** JeremyK has joined #gnucash
19:37:43 *** benoitg has quit IRC
19:39:05 *** ErKa has quit IRC
20:00:18 *** JeremyK has quit IRC
20:06:16 *** JeremyK has joined #gnucash
20:30:33 *** ErKa has joined #gnucash
20:41:56 *** JeremyK has quit IRC
20:57:02 <warlord> @nice gncbot
20:57:02 <gncbot`> warlord: Error: "nice" is not a valid command.
20:57:09 <warlord> @nick gncbot
20:57:09 *** gncbot` is now known as gncbot
21:06:51 *** kpreid has joined #gnucash
21:12:21 <warlord> @tell fell 16604 users deleted. (I backed up just before)
21:12:21 <gncbot> warlord: The operation succeeded.
21:20:54 <warlord> @tell fell strangely there are only 1415 users that have no email authentication. We have over 10,000 users who *somehow* authorized their email address! I'm not sure how that happened, or what we do about it..
21:20:54 <gncbot> warlord: The operation succeeded.
21:30:31 *** JeremyK has joined #gnucash
22:57:17 *** ErKa has quit IRC
23:53:05 *** JeremyK has left #gnucash
23:53:38 *** JeremyK has joined #gnucash
23:54:11 *** JeremyK has left #gnucash