2020-05-19 GnuCash IRC logs

00:00:22 *** angel has joined #gnucash
00:23:12 *** Mechtilde has joined #gnucash
00:55:24 *** sbluhm has joined #gnucash
00:55:24 *** ChanServ sets mode: +v sbluhm
00:57:48 *** bertbob has quit IRC
01:00:17 *** bertbob has joined #gnucash
01:00:17 *** ChanServ sets mode: +v bertbob
01:01:24 *** angel has quit IRC
01:03:35 *** jethrogb has quit IRC
01:04:25 *** jethrogb has joined #gnucash
01:13:04 *** aminbegood has joined #gnucash
01:19:40 *** ECDHE_RSA_AES256 has joined #gnucash
01:20:03 *** ecdhe has quit IRC
01:23:09 *** sbluhm has quit IRC
01:33:08 *** FH_thecat has quit IRC
01:33:33 *** fell has quit IRC
01:34:52 *** fell has joined #gnucash
01:34:53 *** ChanServ sets mode: +o fell
01:40:24 *** sbluhm has joined #gnucash
01:40:24 *** ChanServ sets mode: +v sbluhm
02:03:55 *** Gerd has joined #gnucash
02:28:49 *** Mechtilde has quit IRC
02:29:00 *** Gerd has quit IRC
02:42:23 *** Hamaryns has joined #gnucash
02:42:23 *** ChanServ sets mode: +v Hamaryns
03:02:21 *** User_ has joined #gnucash
03:02:43 *** suukim has joined #gnucash
03:08:24 *** User_ has quit IRC
03:11:03 *** gjanssens has joined #gnucash
03:11:03 *** ChanServ sets mode: +o gjanssens
03:13:20 *** gnomey has quit IRC
03:14:23 *** crossan007 has quit IRC
03:14:25 *** crossan007 has joined #gnucash
03:17:04 *** gnomey has joined #gnucash
03:26:38 *** suukim has quit IRC
03:33:32 *** Hamaryns has quit IRC
03:36:51 *** omnireq has quit IRC
03:37:02 *** omnireq has joined #gnucash
03:37:02 *** ChanServ sets mode: +v omnireq
03:57:51 *** omnireq has quit IRC
03:58:01 *** omnireq has joined #gnucash
03:58:01 *** ChanServ sets mode: +v omnireq
03:58:04 *** aminbegood has quit IRC
04:00:34 *** Mechtilde has joined #gnucash
04:19:21 *** omnireq has quit IRC
04:19:32 *** omnireq has joined #gnucash
04:19:32 *** ChanServ sets mode: +v omnireq
04:37:41 *** Hamaryns has joined #gnucash
04:37:42 *** ChanServ sets mode: +v Hamaryns
05:28:09 *** Oscar has joined #gnucash
05:28:22 *** Aussie_matt has quit IRC
05:32:22 *** Gerd has joined #gnucash
05:36:08 <Oscar> Hello ! I'm using GnuCash with two societies and i want personalise my reports for each one. Actually GnuCash don't load the report file (.gcm) when i change for society. It shows me always the reports for thr first society. Is someone can help me please ?
05:48:21 *** omnireq has quit IRC
05:48:31 *** omnireq has joined #gnucash
05:48:31 *** ChanServ sets mode: +v omnireq
05:51:46 <fell> Oscar, did you create for each a separate .gnucash file?
05:54:38 *** Hamaryns has quit IRC
05:55:08 <fell> Usually you should open your .gnucash file and that will load the metadata file .gcm.
05:55:51 *** Gerd has quit IRC
05:56:22 <Oscar> @feel : Yes i have two .gnucash files and two .gcm files. My societies are totaly differents
05:56:22 <gncbot> Oscar: Error: "feel" is not a valid command.
06:00:33 <Oscar> When i start GnuCash the first society is open, and i have the personalised report for this society. if i change, i open the second file, datas are corectly loaded bunt the personalised reports are not for this activity, they are the first society's reports.
06:02:56 <fell> OK, have a look at https://wiki.gnucash.org/wiki/Metadata_File. I believe you succeeded in assigning the same book Id.
06:03:33 *** Gerd has joined #gnucash
06:07:59 <Oscar> I don't know how i did it, i 'll look this article and i hope i could chande the book ID
06:17:27 *** Hamaryns has joined #gnucash
06:17:27 *** ChanServ sets mode: +v Hamaryns
06:17:55 <fell> Save your books uncompressed, then can view/edit them with a plain text editor.
06:18:56 <Oscar> yes i can open the .gcm file with Notepad
06:21:35 <Oscar> The "BookGuid" in the "Top" section are différents in each file
06:30:15 <gjanssens> Oscar: saved report configurations are not stored in the .gcm file, only reports that are opened in tabs.
06:30:36 <gjanssens> Saved reports are in the same saved-reports file for all of your books.
06:31:31 <gjanssens> So each configuration you save using "Save report configuration" will be available for all of your books.
06:31:50 <gjanssens> If you need to distinguish you will have to give them different names.
06:32:12 <gjanssens> But you can't filter them out for only one society in there.
06:32:35 *** Jimraehl1 has joined #gnucash
06:33:31 *** Jimraehl1 has quit IRC
06:33:49 <Oscar> each society's files have distinguish names
06:34:47 <gjanssens> @tell jralls you suggested to chris earlier to use a default file to save an html report to when generating it from the command line. At least in linux it's more common for command line tools to output by default to stdout and I would prefer that. Do you have a strong motivation not to do so ?
06:34:47 <gncbot> gjanssens: The operation succeeded.
06:35:03 <gjanssens> Oscar: that doesn't matter.
06:35:12 <gjanssens> But let's take a step back.
06:35:36 <gjanssens> What exactly do you mean with "It shows me always the reports for the first society" ?
06:36:06 <gjanssens> Where does it show these ? What menu command did you use to show your personalized reports ?
06:40:42 <Oscar> if i resume the application GnuCash load and open the society1.gnucash file and the society1.gcm file but load and open the society2.gnucash file and ignore the society2.gcm file.
06:41:52 <Oscar> The society1.gcm file is always loaded !
06:43:35 <gjanssens> Why do you think so ?
06:45:47 <Oscar> this is what i see on my screen
06:47:08 <gjanssens> I can't see your screen, so will you link to a screen shot ?
06:48:03 <gjanssens> Other than that GnuCash doesn't tell you which .gcm file it loads. So you are basing that assumption on something else.
06:48:22 <gjanssens> And until now I'm not convinced we're talking about the same thing.
06:48:41 <gjanssens> So please provide more details of why you think this is the case.
06:53:30 <Oscar> Well, I am using a French version of GnuCash. With my first company I created personalized reports (works, credits ...) and the reports are correctly displayed when I call them: Menu: Reports / Saved Report Configuration
06:55:47 <Oscar> With the second company I also created different personalized reports (personal, car ...) but when I load this company I do not find these reports in the menu of personalized reports ...
06:58:19 <Oscar> I always find the reports of the first company (works, credits ...) and of course it does not work when I ask to see the results since the data are different. It even happens to crash GnuCash in some cases.
07:02:35 *** keiffer has quit IRC
07:04:24 <gjanssens> So that confirms what I explained above.
07:04:59 *** keiffer has joined #gnucash
07:04:59 <gjanssens> When you save a report using "Save report configuration" it will be stored in a common file for all societies.
07:05:16 <gjanssens> That file is called saved-reports-2.8
07:05:48 <gjanssens> Did you have both your society books open when you were creating the reports for the second society ?
07:06:15 <gjanssens> I guess there may be a data race condition in that case.
07:06:55 <gjanssens> But to go forward, you should use report names including your society name when using "Save Report Configuration As..."
07:07:22 <gjanssens> That way they will be easier to identify in the Reports / Saved Report Configuration menu.
07:08:03 <gjanssens> So for example save a report as "Society 1 - work" and another as "Society 2 - work"
07:08:33 <gjanssens> And for safety be sure your Society 1 book is closed when you save reports for Society 2
07:08:55 <gjanssens> Note you can rename existing reports in the Reports / Saved Report Configuration dialog.
07:09:01 <gjanssens> (Got to go now)
07:09:51 *** omnireq has quit IRC
07:10:01 *** omnireq has joined #gnucash
07:10:01 *** ChanServ sets mode: +v omnireq
07:11:01 <Oscar> Yes that's what I think, and it's a shame. Maybe in a future version of GnuCash, manipulation will be possible because it would be nice not to mix everything
07:13:49 <Oscar> Thanks for all the details. I'm going too. Goodbye !
07:15:57 *** Hamaryns has quit IRC
07:16:36 *** Oscar has left #gnucash
07:31:32 *** phoenix has joined #gnucash
07:49:01 *** Hamaryns has joined #gnucash
07:49:01 *** ChanServ sets mode: +v Hamaryns
07:55:51 *** omnireq has quit IRC
07:56:01 *** omnireq has joined #gnucash
07:56:01 *** ChanServ sets mode: +v omnireq
08:03:01 *** Gerd1 has joined #gnucash
08:04:32 *** Gerd has quit IRC
08:04:32 *** Gerd1 is now known as Gerd
08:08:03 *** freewary has joined #gnucash
08:09:11 <freewary> Hi I posted a request for help switching versions of GNU cash on here last night, and then I logged off, not realizing that when I returned I wouldn't be able to see the history. Did anyone answer and if so how can I see the chat history?
08:17:21 *** omnireq has quit IRC
08:17:31 *** omnireq has joined #gnucash
08:17:31 *** ChanServ sets mode: +v omnireq
08:17:39 *** phoenix has quit IRC
08:26:33 *** Gerd has quit IRC
08:32:39 <warlord> freewary, you can see the logs at https://code.gnucash.org/logs/
08:36:29 <warlord> freewary, looking back, nobody answered you. There should be no data loss; what makes you think there is loss? Are you sure that the issue wasn't just a DISPLAY issue that was hiding data?
08:38:51 *** omnireq has quit IRC
08:39:01 *** omnireq has joined #gnucash
08:39:01 *** ChanServ sets mode: +v omnireq
08:39:38 <freewary> thanks for following up warlord. Here is what happens- look at the file on version 2.6..., I can see a full history of transactions in one account from 2011 through last week. Copy the .gnucash file over to another computer with a higher version, open the same account, and cannot see any transactions after 2015. How would I determine if it's a display issue or a data loss issue? (replicated issue on xubuntu and windows 10)
08:40:26 <warlord> Check the View -> Filter By selections when you open the account register.
08:40:35 <warlord> Make sure the Date Range is set to all.
08:40:50 <warlord> Make sure you don't have, e.g., reconciled splits turned off..
08:41:52 <warlord> There is also a preference for total number of entries to display; make sure it's not too small (Edit -> Preferences -> Register Defaults -> Number of Transactions) -- Set to '0' for "all"
08:42:10 <freewary> ok I just verified that all selections are included on the view-> filter by menu. Still can't see all the transactions
08:42:58 <freewary> And I just verified that Edit -> Preferences -> Register Defaults -> Number of Transactions is set to zero
08:43:02 <warlord> How do you know you're not seeing all transactions?
08:43:13 <warlord> What appear to be missing?
08:43:42 <freewary> I know I'm not seeing all, because I sorted the register by standard order and the most recent transaction is from 4/21/205
08:43:53 <warlord> (I need to step away for a bit... I'll be back)
08:44:06 <freewary> On the computer that has the complete history tho most recent transaction is 5/2020
08:44:16 <warlord> Are you sure you copied the correct data file over?
08:44:40 <freewary> yes. I checked the precise file name and also the timestamp of the file before and after transfer
08:49:11 *** aminbegood has joined #gnucash
08:50:33 <warlord> What does the titlebar say on the old computer and the new computer?
08:50:40 <warlord> I don't believe you're using the same datafile.
08:54:03 *** aminbegood has quit IRC
08:54:32 <freewary> abinbegood I am checking
08:56:57 <freewary> ok I verified that the titlebar on both computers matches: gnucash_[my name].gnucash . And the file names should exactly match because I copied the good version of the file to the computer with the newer version using SCP
08:58:41 <warlord> freewary, can you create screenshots of both versions and post them somewhere I can see so I can see what you're seeing? If you're opening the same data file then all your data will be there, so it's a display question.
08:58:51 <warlord> Or you're not using the same data file.
08:59:21 <warlord> What OS is the old computer again?
08:59:51 *** omnireq has quit IRC
09:00:01 *** omnireq has joined #gnucash
09:00:01 *** ChanServ sets mode: +v omnireq
09:00:06 <warlord> Ah, Ubuntu.. can you do an "ls -lt | head" in the directory where your data files are stored and paste the first couple lines here?
09:00:40 <freewary> the old computer is xubuntu 18.04 LTS operating system and gnucash version 2.6.19.
09:00:41 <warlord> I really feel like on the old system you started using a backup file as your main file, but you copied the main file.
09:05:35 *** Hamaryns has quit IRC
09:05:59 <freewary> ok gnu cash is currently open to my main file, not a backup, here is a printout of ls from the good computer:
09:06:01 <freewary> nt@zilla:/home/ng/Documents/Budget/gnucash$ ls -lt | head
09:06:01 <freewary> total 121648
09:06:02 <freewary> -rw-rw-r-- 1 ng ng 462038 May 19 07:55 gnucash_ford.gnucash.20200519075520.log
09:06:02 <freewary> -rw------- 2 ng ng 0 May 19 07:55 gnucash_ford.gnucash.7f0101.18683.LNK
09:06:02 <freewary> -rw------- 2 ng ng 0 May 19 07:55 gnucash_ford.gnucash.LCK
09:06:02 <freewary> -rw-rw-r-- 1 ng ng 462301 May 18 22:26 gnucash_ford.gnucash.20200518221950.log
09:06:02 <freewary> -rw-rw-r-- 1 ng ng 170 May 18 21:17 gnucash_ford.gnucash.20200518211356.log
09:06:03 <freewary> -rw-rw-r-- 1 ng ng 1036002 May 18 21:13 gnucash_ford.gnucash
09:06:04 <freewary> -rw-rw-r-- 1 ng ng 45037064 May 18 21:13 gnucash_ford.gnucash.20200518211253.log
09:06:06 <freewary> -rw-rw-r-- 1 ng ng 696 May 18 21:05 gnucash_ford.gnucash.20200518210505.log
09:06:08 <freewary> -rw-rw-r-- 1 ng ng 170 May 18 21:05 gnucash_ford.gnucash.20200518210504.log
09:06:29 <freewary> as you can see gnucash_ford.gnucash.LCK shows that it has locked the primary file, NOT a backup
09:07:13 <warlord> Indeed!!
09:07:31 <warlord> So you copy gnucash_ford.gnucash across to the new system...
09:07:42 <freewary> exactly, using SCP
09:07:59 <warlord> And then you File -> Open that copied file...
09:08:06 <freewary> yes
09:08:30 <freewary> I understand what gnucash backup files are, I have used them fluently over the years to fix when I screw things up.
09:08:44 <freewary> I'm 100% sure I'm not mixing up backup files.
09:08:56 <freewary> Also, consider the backup files by default only have 30 days
09:09:10 <freewary> and I'm missing 5 YEARS of history when reading in the same file on a new version of gnucash
09:09:19 <warlord> Then all your data should be there. Although I'm curious what you did this morning that caused a 462KB log file but didn't save ? strange.
09:09:32 <warlord> Regardless, your data should be there. So the question is: why isn't it being displayed?
09:10:01 <freewary> what I'm trying right now while chatting is unzipping the file and digging into the xml for that account to see if the transactions are in there
09:10:18 <warlord> Speaking of which -- I don't see any backup files in that list? Are you using SQLite storage or XML?
09:12:25 <freewary> I just use the default settings, there are backup files in there, lots, I just used head on ls so you only saw the first few
09:13:10 <freewary> ok I'm digging in the xml
09:13:19 <freewary> I found the GUID for my account that is having problems is: c095277fced82a1eae4ffe1b84fb8921
09:13:29 <freewary> Now I'm digging it the xml for the transactions of that account
09:15:37 <warlord> Okay.
09:16:53 <freewary> ok I was able to find at least a few transactions for that account that are not displaying
09:17:09 *** sbluhm has quit IRC
09:17:12 <warlord> PHEW!
09:17:20 <freewary> for example, I found a margin interest transaction that referenced that account, then I jumped to it, and it doesn't display
09:17:24 <warlord> I knew they had to be in there. So now the question is: why are they not displaying?
09:17:49 <warlord> Unfortunately jralls is still asleep, and gjanssens is busy..
09:18:21 <freewary> ok and that gave me a clue what to look for, I just found more examples
09:18:46 <warlord> GREAT! So we know your data is there. Phew.
09:19:05 <freewary> so I can look at income and expense accounts that have splits involving my non-displaying account, and when I jump back to that account, the split is not there
09:19:29 <freewary> phew indeed
09:20:05 <warlord> That's just so weird. It still points to a display error..
09:21:09 <freewary> also wierd that the problem is replicated an Windows 10 with gnucash 3.10, Xubuntu 20.04 with gnucash 3.8B, and Xubuntu 20.04 with flatpak/gnucash 3.1
09:22:47 <warlord> Indeed..
09:23:08 *** ellia has joined #gnucash
09:25:21 *** omnireq has quit IRC
09:26:06 *** omnireq has joined #gnucash
09:26:06 *** ChanServ sets mode: +v omnireq
09:26:32 <freewary> oh my goodness I just fixed it!
09:26:53 <freewary> somehow the filter by date got set!
09:28:11 <freewary> warlord thanks for your effort!
09:28:50 <warlord> I told you to check that!!! ;)
09:29:00 <warlord> YAY. Glad you fixed it.
09:29:48 <freewary> yes you did
09:30:48 <freewary> when I looked at filter by, my habit is to always click on status, so out of habit I clicked filter by, status and passed over the date filters
09:30:56 <warlord> Oops.
09:31:06 <freewary> sorry!
09:31:34 <freewary> by the way, this is my first time ever speaking to anyone else who even knows what gnucash is and I love it so much I am so grateful.
09:33:33 <warlord> You're welcome.
09:33:35 <warlord> Enjoy!
09:34:15 *** chris has joined #gnucash
09:34:15 *** ChanServ sets mode: +v chris
09:39:23 *** Gerd has joined #gnucash
09:45:42 *** PowaBanga has quit IRC
09:46:49 *** PowaBanga has joined #gnucash
09:55:27 <chris> gjanssens: having writing report to stdout is a double-edge sword: it means I can't use stdout to show progress loading large datafile.
09:57:21 *** PowaBanga has quit IRC
09:59:07 *** sbluhm has joined #gnucash
09:59:07 *** ChanServ sets mode: +v sbluhm
09:59:37 *** PowaBanga has joined #gnucash
10:03:37 *** sbluhm has quit IRC
10:04:04 *** Gerd has quit IRC
10:06:49 <warlord> chris, use stderr for progress
10:15:32 <chris> is it appropriate tho?
10:16:37 <warlord> For a large data file, maybe
10:17:38 <chris> i'm planning fancy progress report: "Loading /path/to/datafile.gnucash\n" then "\r 25% complete" every 5% increments
10:18:20 <gjanssens> freewary: note gnucash 3.x will have indicators in the bottom right corner when you have a filter enabled or chosen a custom sort order. Hovering your mouse over these indicators will show you what filters/sort order is set.
10:18:45 <warlord> chris, cool.
10:20:05 <gjanssens> chris: I don't mean to support only stdout. By all means keep the --output-file option, but in the absense of it, default to stdout
10:20:31 <gjanssens> Using stderr for progress is not uncommon by the way
10:20:48 <chris> gjanssens: ok is it defacto standard then?
10:21:02 <chris> if yes then i'll do all progress update to stderr
10:21:52 <gjanssens> I however would want to be able to use the gnucash command line tool in combination with other tools by piping its output to another command directly, like awk or html2pdf or scp,...
10:22:49 <chris> in principle I agree, however my datafile takes 5-10s to load and it's disconcerting to see nothing while loading. if stderr is acceptable then I'll use it.
10:24:52 <gjanssens> stderr is even better in this case as that's not buffered.
10:25:12 <gjanssens> In other words whatever you write to stderr will be displayed immediately
10:25:24 <chris> ok.
10:25:28 <gjanssens> Output to stdout will only be displayed if the internal buffer is full
10:26:29 <gjanssens> Another possible approach is to print progress information only when an output file is set other than stdout (curl does this for example)
10:27:24 <warlord> Also, using stderr will still allow you to pipe it.
10:28:20 <gjanssens> True
10:29:21 * chris thought stderr was only for abort etc
10:29:36 <chris> have a whirl of the branch any case :)
10:29:46 <chris> we can transplant to gnucash-cli anytime
10:33:30 <gjanssens> Ok. I would like to tweak gnucash-cli some more before merging it to master
10:33:57 <chris> \o/
10:37:05 <warlord> chris, FYI, running a report to CLI is a wonderful addition
10:39:01 <chris> thank you!
10:39:42 <warlord> And I suspect this is a read-only open so you could run it even if GnuCash is already running!
10:40:27 <chris> hmm no; qofsession seems to reject loading if LCK exists, hence my issue documented in github
10:41:13 <chris> the solution is to qof_session_begin (session, file, ***TRUE***, false, false)
10:41:23 <chris> "force load even if lck exists"
10:41:55 <chris> and afterwards if I qof_session_end() without qof_session_save() it can complain about LCK
10:42:42 <chris> FWIW specifying the report can be done either via the unique guid string, or the unique saved-report report-name :)
10:43:21 *** Hamaryns has joined #gnucash
10:43:21 *** ChanServ sets mode: +v Hamaryns
10:44:25 <chris> in other words, force-loading datafile seems to delete .LCK file
10:45:51 *** omnireq has quit IRC
10:46:14 <warlord> There should be a way to open read-only without deleting the LCK file
10:47:12 *** omnireq has joined #gnucash
10:47:12 *** ChanServ sets mode: +v omnireq
10:50:39 *** jervin has joined #gnucash
10:50:44 *** phoenix has joined #gnucash
10:57:55 *** storyjesse has joined #gnucash
10:58:48 <freewary> thx for tip gjanssens
10:59:00 <gjanssens> you're welcome
11:07:51 *** omnireq has quit IRC
11:08:18 *** omnireq has joined #gnucash
11:08:18 *** ChanServ sets mode: +v omnireq
11:14:50 *** Hamaryns has quit IRC
11:16:19 *** Gerd has joined #gnucash
11:27:11 *** storyjesse has quit IRC
11:29:21 *** omnireq has quit IRC
11:29:39 *** omnireq has joined #gnucash
11:29:39 *** ChanServ sets mode: +v omnireq
11:30:38 *** guak has joined #gnucash
11:33:06 <jralls> gjanssens, It's common for command line tools that would be part of a pipeline to write to stdout, but AFAIK you can't pipe html into a browser: `gnucash --run-report="My Report" | /usr/bin/firefox` won't work. The other reason to write to stdout would be to display the results in the terminal for the user to read, but I don't see that being useful with html formatting.
11:33:06 <gncbot> jralls: Sent 4 hours and 58 minutes ago: <gjanssens> you suggested to chris earlier to use a default file to save an html report to when generating it from the command line. At least in linux it's more common for command line tools to output by default to stdout and I would prefer that. Do you have a strong motivation not to do so ?
11:35:24 <jralls> gjanssens So what is the use case for writing a report to stdout?
11:36:09 <gjanssens> Direct postprocessing with other tools like awk or sed, direct conversion to pdf with html2pdf
11:36:28 *** Mechtilde has quit IRC
11:37:11 <gjanssens> And tbh I was not limiting this to report generation. I was thinking from the perspective of any data extraction using a gnucash-cli tool
11:38:08 <gjanssens> I don't mind having an option to write to a file, but I'd like to keep the option to write to stdout
11:38:36 <gjanssens> And I certainly don't like gnucash hard-coding a default file name if none is given.
11:39:06 <gjanssens> I could see that for binary output, but not for text such as html
11:39:59 *** Gerd has quit IRC
11:50:07 <jralls> OK, I hadn't thought of html2pdf as a use-case, and I suppose the awk script would be to do something like html->csv.
11:51:30 *** sbluhm has joined #gnucash
11:51:31 *** ChanServ sets mode: +v sbluhm
11:51:48 <jralls> If the default is to stdout there's no need for a default filename, the cmdline processing can just reject the naked --output.
11:53:05 <chris> /me is also planning --export-type=CSV to trigger CSV output \o/
11:53:46 <gjanssens> jralls: that's what I had in mind
11:53:54 <gjanssens> chris: nice :)
11:54:32 <jralls> chris, that would be popular. It would be even more popular if a report tab had a File>Export to CSV to do the same.
11:55:21 *** omnireq has quit IRC
11:55:31 *** omnireq has joined #gnucash
11:55:31 *** ChanServ sets mode: +v omnireq
11:55:35 <chris> this would be difficult... most report use custom html-tables in various guises and there's no reliable multiple-html-table->CSV converter
11:56:12 <chris> CSV output would have to be implement by reports individually
11:56:39 <jralls> So make the menu item sensitive only if the report supports it.
11:57:17 <chris> already exists. Income_GST_STatement and taxtxf are the only 2 that have export options IIRC
11:57:43 <jralls> OK
11:59:48 <chris> gnucash --run-report="Customized TaxTXF" --export-type=TXF --output-file=~/$YEAR$MONTH.txf
12:01:02 <jralls> That last bit will blow up unless the user happens to have the environment variables $YEAR and $MONTH set in the shell.
12:01:28 <chris> sure
12:03:10 <gjanssens> It wouldn't even blow up. Just create a hidden file named .txf (on linux)
12:04:22 <jralls> Most users would consider that "blowing up".
12:05:06 <jralls> And it would do that on all OSes, it's just that on Windows it wouldn't be hidden.
12:05:58 <gjanssens> Fair enough. Clearly we all understand how it works :)
12:07:56 *** znoteer has joined #gnucash
12:13:54 <znoteer> I'm having trouble replaying a log file. Part of the problem is that the dialogue is too big for my laptop window, so I don't see the whole thing (I can't see the bottons to say OK or cancel at the bottom, nor the top of the dialogue). When I select a file and click enter, gnucash appears to hang. The dialogue box doesn't go away, and I have to kill gnucash to get bach to normal. Can anyone
12:13:56 <znoteer> suggest what to do with this problem?
12:16:21 *** omnireq has quit IRC
12:16:31 *** omnireq has joined #gnucash
12:16:31 *** ChanServ sets mode: +v omnireq
12:20:00 *** sbluhm has quit IRC
12:47:56 *** bertbob has quit IRC
12:48:43 *** ArtGravity has joined #gnucash
12:48:43 *** ChanServ sets mode: +v ArtGravity
12:49:25 <jralls> znoteer, do you mean that the file browser is too big for your laptop?
12:49:44 *** bertbob has joined #gnucash
12:49:45 *** ChanServ sets mode: +v bertbob
13:00:05 <jralls> znoteer and how big is the log file?
13:12:03 *** Mechtilde has joined #gnucash
13:17:15 *** znoteer has quit IRC
13:18:21 *** omnireq has quit IRC
13:18:32 *** omnireq has joined #gnucash
13:18:32 *** ChanServ sets mode: +v omnireq
13:20:40 *** sbluhm has joined #gnucash
13:20:41 *** ChanServ sets mode: +v sbluhm
13:22:50 *** Gerd has joined #gnucash
13:36:49 *** Hamaryns has joined #gnucash
13:36:49 *** ChanServ sets mode: +v Hamaryns
13:39:21 *** omnireq has quit IRC
13:39:33 *** omnireq has joined #gnucash
13:39:33 *** ChanServ sets mode: +v omnireq
13:40:55 *** sbluhm has quit IRC
13:41:27 <warlord> chris, why not just say --output-file=~/2020-05.txf And then people would know what it means.
13:42:06 <chris> 'twas an example
13:50:39 <warlord> I know, but might as well use an example that people can copy-and-paste ;)
13:51:16 *** chris has quit IRC
14:05:05 *** Gerd has quit IRC
14:05:21 *** omnireq has quit IRC
14:06:11 *** omnireq has joined #gnucash
14:06:11 *** ChanServ sets mode: +v omnireq
14:07:27 *** jervin has quit IRC
14:22:36 *** Gerd has joined #gnucash
14:26:09 *** frakturfreak has joined #gnucash
14:33:27 *** sbluhm has joined #gnucash
14:33:27 *** ChanServ sets mode: +v sbluhm
15:10:46 *** Hamaryns has quit IRC
15:14:58 *** Mechtilde has quit IRC
15:21:45 *** znoteer has joined #gnucash
15:23:09 *** Agfarmer18 has joined #gnucash
15:24:03 *** Agfarmer18 has quit IRC
15:24:51 <znoteer> jralls: sorry, there was a power outage in my area. I'm just getting back on line now. Yes, the dialogue window that opens so you can choose a log file is larger than my physical screen. The top and bottom of the window are missing. The log file is 596 bytes
15:26:02 <znoteer> I don't know if anyone else said anything to me before or after jrall_s about 2 hrs 20 min ago. If so, I've not seen it
15:27:21 <jralls> znoteer, Nobody did, but note that IRC is logged at https://code.gnucash.org/logs.
15:27:48 <znoteer> thanks
15:28:21 *** omnireq has quit IRC
15:28:31 *** omnireq has joined #gnucash
15:28:31 *** ChanServ sets mode: +v omnireq
15:30:28 <znoteer> jralls: do you have any insight into my log replaying problem?
15:30:32 <jralls> I think it likely that the "hang" is due to GnuCash putting up a modal dialog that you can't see, perhaps because your screen is too small. The file dialog's default size is 600w x 500h.
15:30:35 <warlord> znoteer, a log file of 596 bytes is not a lot of data. That's like one operation.
15:30:47 <znoteer> hmm
15:30:55 <znoteer> where's the rest
15:31:09 <jralls> Where's the rest of what?
15:31:20 <znoteer> the operations
15:31:37 <jralls> In other log files?
15:31:43 <warlord> Probably a different log file
15:32:09 <warlord> Why do you think you need to replay the log file?
15:32:31 <znoteer> The help file says to open the last data file and rerun the last log file. Should I be opening previous log files too
15:32:41 <jralls> OTOH, the log file only contains transaction operations, not any business stuff like bills & invoices.
15:33:35 <jralls> From what are you trying to recover?
15:35:53 <znoteer> Because, for some reason, the last three times I've used gnucash, though I've saved before quitting, my file never got over written. I've got data files and log files from my work from May 5, 6, 7, and 11, but the main file hasn't been overwritten since apr 19 for some reason. Though I have all the paper work and can reenter everything again, I'd rather not
15:36:46 <warlord> Are you sure you didn't open (and write to) a different file?
15:37:03 <znoteer> yes
15:37:11 <jralls> The main file is never overwritten. On save GnuCash renames the main file with a timestamp and writes out a new one. Make sure you have no files with two timestamps.
15:38:21 <jralls> As for the log files, you'll have at least one for each save.
15:39:20 <znoteer> So, the data file with the most recent time stamp will have the details of the log files with previous timestamps, correct?
15:39:53 <warlord> znoteer, can you run "ls -lt | head" in the data file directory and show us the results?
15:39:54 <jralls> Yes.
15:47:14 <znoteer> warlord, jralls: https://paste.debian.net/hidden/e0ae9013/
15:47:29 *** Unhammer has quit IRC
15:47:40 *** angel has joined #gnucash
15:49:19 <warlord> znoteer, right. So it looks like yesterday you opened a backup file from May 13th and then made two small changes to it.
15:49:33 <warlord> Notice: Comptes_personnels_2019.gnucash.20200513132830.gnucash
15:49:51 *** omnireq has quit IRC
15:50:01 *** omnireq has joined #gnucash
15:50:01 *** ChanServ sets mode: +v omnireq
15:50:15 <warlord> And more importantly: Comptes_personnels_2019.gnucash.20200513132830.gnucash.8323329.22575.LNK
15:51:02 <warlord> Your main data file, Comptes_personnels_2019.gnucash, was last saved yesterday at 22:26. Just File -> Open and ensure you choose Comptes_personnels_2019.gnucash and then you'll just need to re-apply whatever you did yesterday/today.
15:51:45 <znoteer> Yes, that is the last time I did a save. I have it open at the moment because I would like to replay the log file that goes with it, but I am unable to do so
15:51:49 <warlord> You also have a bunch of .gpg files in there -- not sure why.
15:52:50 <znoteer> the main file was saved yesterday at 22:26 because I was going to add some transactions but realised that all my transactions entered the 13th were missing
15:53:16 <znoteer> I encrypt everything after a session, that's why the gpg files are there
15:53:40 *** Gerd has quit IRC
15:53:49 <warlord> That makes it harder to see how the data file grows (or doesn't).
15:54:04 <warlord> So you've got this backup file: -rw------- 1 ger ger 315092 May 13 13:31 Comptes_personnels_2019.gnucash.20200513132830.gnucash.gpg
15:54:55 <warlord> Then one log file at 20:05 with the saved (backup) file from 20:29: Comptes_personnels_2019.gnucash.20200518222615.gnucash
15:55:10 <warlord> Does that backup not have your May 13 entries?
15:55:17 <znoteer> no
15:55:39 <znoteer> everything after the 13th is my attempt to restart work and recover
15:55:44 <warlord> Did your disk fill up?
15:56:30 <znoteer> it has filled up a couple of times (lvm, so I just grew the volume) but never when I was working with gnucash
15:56:38 <warlord> Can you un-gpg Comptes_personnels_2019.gnucash.20200513132830.gnucash.gpg so we can see the raw file size and compare it to more recent data?
15:58:09 <warlord> Specifically I want to see it vs Comptes_personnels_2019.gnucash.20200518222615.gnucash
15:58:28 <znoteer> It's already decrypted. Fourth down in the list
15:59:44 <warlord> Interesting. Also, can you recall what operations you did between May 13 and May 18th? There is only 1 log entry before the "bad" data file.
15:59:53 <warlord> Did you do anything to accounts?
15:59:58 <warlord> Do you use any business features?
16:00:29 <warlord> Frankly, it looks like you only did 4 or 5 things total; instead of replaying the log file, why not just re-enter those 5-ish transactions?
16:01:40 <znoteer> I don't save after every transaction, so there are many expenses entered for each log file. I actually ahve many many transactions to reenter
16:01:49 <znoteer> I may have added an acount
16:03:40 *** freewary has quit IRC
16:07:19 <warlord> If you added an account then you DEFINITELY cannot replay the log file.
16:07:43 <warlord> As for adding lots and lots of transactions, your log files don't back up that statement.
16:08:10 <warlord> I see 5 log files.
16:08:22 *** Unhammer has joined #gnucash
16:08:24 <warlord> Go open one up and you'll see; it's just a text file.
16:08:45 <warlord> I'm going to guess about 15 operations today.
16:08:46 <znoteer> I have, on average, 4 expenses/day since avril 10th
16:08:55 <warlord> s/today/total
16:09:24 <znoteer> s/avril/April/
16:10:47 <warlord> The more important question, to me, is what happened between May 13 and May 18 such that the data got lost.
16:11:12 <znoteer> That's what bugs me, too. It's not the first time
16:12:16 <warlord> What version of gnucash is this?
16:12:27 <znoteer> Everything was peachy on my old laptop, but since moving to the new one, I've had save problems
16:12:46 <warlord> I wonder if it's a disk/filesystem issue?
16:12:47 <znoteer> warlord: 3.4
16:13:07 <znoteer> brand new disk
16:13:54 *** angel has quit IRC
16:14:00 <znoteer> I haven't seen any such problems elsewhere
16:14:13 <znoteer> I mean with other software on this laptop
16:14:56 <warlord> it could also be your gpg wrapper.
16:16:23 <warlord> Anyways... to get your data back.. Starting from your May 13 backup... If you File -> Save As Comptes_personnels_2020.gnucash What file size gets created?
16:16:37 <znoteer> hmm, I suppose, but it's the same wrapper that was working before. the wrapper hasn't changed, just the laptop and the versions of Debian/Gnucash
16:16:59 <warlord> Which also changes the version of gpg.. and underlying libraries... and compression...
16:17:15 <znoteer> ah yes
16:17:25 <znoteer> let me try that save...
16:19:56 *** sbluhm has quit IRC
16:21:00 <warlord> znoteer, so back to your original screen --- how large is your laptop screen? In general we require 1024x768 minimum size.
16:21:04 <znoteer> warlord: it gets saved as the exact same size: 314,709
16:21:16 <warlord> Okay, that's good!
16:21:35 <znoteer> Hmm, let me chech the specs
16:21:56 <warlord> So now let's get the rest of your new data from May 13th. Frankly it might be easier to just re-enter the dezen transactions by hand.
16:22:05 <warlord> It's only 5 days. It's not like you lost months of data.
16:22:53 <warlord> And especially if you created new accounts; the log file doesn't record that, but any transactions into that account will have the account's GUID and will cause a failure on replay.
16:23:36 *** Unhammer has quit IRC
16:24:48 <znoteer> warlord: 12,5 inches, 1366x768
16:28:18 <warlord> inches aren't as important as #pixels. That SHOULD be tall enough for all the dialogs, unless you have font sizes way too high.
16:28:28 *** Unhammer has joined #gnucash
16:28:54 <warlord> Regardless, I think that, now that you've got your data and it's saving, you should just re-enter the transactions by hand. It'll be faster than trying to replay your 5 log files.
16:28:56 <znoteer> I haven't changed from whatever the defaults are
16:29:36 <znoteer> warlord: Yah, ok, I'll get busy re-entering everything <sigh
16:29:42 <znoteer> >
16:29:58 <znoteer> thanks for your help, <- warlord
16:30:15 <warlord> It's 16 transactions. That should take you 5 minutes at most.
16:32:10 *** phoenix has quit IRC
16:32:26 <znoteer> This has been happening since the 10th April. It's more like 80 transactions
16:33:00 <warlord> First thing to do: Turn off your GPG scripts.
16:33:25 <warlord> If you want encrypted data, use EncFS or something like that.
16:33:36 <warlord> Or better yet, just dm-crypt your whole disk.
16:34:38 <jralls> znoteer, It may have been happening since 10 April, but your most recent backup file is only 6 days ago.
16:35:46 <jralls> And you had to have had a good file to open on the 13th, so something happened that replaced that file with the one from 10 April.
16:45:25 *** jervin has joined #gnucash
16:49:15 <warlord> Right, so you should only have to enter data for May 13 - May 18
16:49:18 <warlord> 5 days
16:56:21 *** omnireq has quit IRC
16:56:29 *** gjanssens has quit IRC
16:56:31 *** omnireq has joined #gnucash
16:56:31 *** ChanServ sets mode: +v omnireq
17:07:50 *** frakturfreak has quit IRC
17:12:31 *** jervin has quit IRC
17:12:53 *** fell has quit IRC
17:14:31 *** fell has joined #gnucash
17:14:31 *** ChanServ sets mode: +o fell
17:17:51 *** omnireq has quit IRC
17:19:12 *** omnireq has joined #gnucash
17:19:12 *** ChanServ sets mode: +v omnireq
17:39:51 *** omnireq has quit IRC
17:40:01 *** omnireq has joined #gnucash
17:40:01 *** ChanServ sets mode: +v omnireq
17:47:48 *** chf has quit IRC
17:58:38 *** chf has joined #gnucash
18:09:18 *** chf has quit IRC
18:09:23 <codesmythe> Someone wrote a nice intro-to-gnucash blog post a couple of days ago: https://www.csun.io/2020/05/17/gnucash-finance.html Commentary on Hacker News here: https://news.ycombinator.com/item?id=23237445
18:13:39 *** chf has joined #gnucash
18:24:58 *** jervin has joined #gnucash
18:36:36 *** chf has quit IRC
18:47:21 *** omnireq has quit IRC
18:47:40 *** omnireq has joined #gnucash
18:47:40 *** ChanServ sets mode: +v omnireq
18:54:29 *** Aussie_matt has joined #gnucash
19:21:03 *** r3dkoder has joined #gnucash
19:22:01 <r3dkoder> Hi, would someone be able to help me with changing the font size on windows? I put a gtk-3.0.css in the right folder but it doesn't seem to have any effect.
19:26:53 <jralls> r3dkoder your best bet is to ask on gnucash-user.
19:27:09 <r3dkoder> thanks
19:28:12 *** ArtGravity has quit IRC
19:28:15 <r3dkoder> seems like there is no such channel
19:29:21 *** omnireq has quit IRC
19:29:31 *** omnireq has joined #gnucash
19:29:31 *** ChanServ sets mode: +v omnireq
19:38:36 <jralls> r3dkoder, it's not a channel, it's GnuCash's user support mailing list: https://lists.gnucash.org/mailman/listinfo/gnucash-user
19:42:58 *** guak has quit IRC
19:46:06 *** Unhammer has quit IRC
19:50:21 *** omnireq has quit IRC
19:50:31 *** omnireq has joined #gnucash
19:50:31 *** ChanServ sets mode: +v omnireq
19:55:26 *** Unhammer has joined #gnucash
19:56:39 *** chf has joined #gnucash
20:09:48 *** r3dkoder has quit IRC
20:16:20 *** chf has quit IRC
20:20:14 *** jervin has joined #gnucash
20:24:41 *** Unhammer has quit IRC
20:32:21 *** omnireq has quit IRC
20:32:36 *** omnireq has joined #gnucash
20:32:36 *** ChanServ sets mode: +v omnireq
20:41:26 *** Unhammer has joined #gnucash
21:15:39 *** Hirppa has quit IRC
21:16:29 *** chf has joined #gnucash
21:22:47 *** marusich has joined #gnucash
21:22:47 *** ChanServ sets mode: +v marusich
21:25:15 *** Hirppa has joined #gnucash
21:34:52 *** chris has joined #gnucash
21:34:52 *** ChanServ sets mode: +v chris
21:41:30 *** storyjesse has joined #gnucash
21:42:05 *** chris has quit IRC
21:45:57 *** chf has quit IRC
21:52:41 *** chf has joined #gnucash
21:57:13 *** chf has quit IRC
22:12:48 *** jervin has quit IRC
22:22:15 *** chf has joined #gnucash
22:49:51 *** omnireq has quit IRC
22:50:01 *** omnireq has joined #gnucash
22:50:01 *** ChanServ sets mode: +v omnireq
23:33:38 *** chris has joined #gnucash
23:33:38 *** ChanServ sets mode: +v chris
23:35:51 *** omnireq has quit IRC
23:36:31 *** omnireq has joined #gnucash
23:36:32 *** ChanServ sets mode: +v omnireq
23:38:41 *** bertbob has quit IRC
23:54:13 *** Mechtilde has joined #gnucash
23:57:21 *** omnireq has quit IRC
23:57:31 *** omnireq has joined #gnucash
23:57:31 *** ChanServ sets mode: +v omnireq