Re: [GNC] New Balsheet (and P report)
Hi Stephen Thank you for valuable feedback... all these issues are cosmetic / account selection, and are relatively trivial except that Placeholder accounts can also contain transactions therefore must not necessarily accumulate their children account amounts. My major concern relates to switching amounts to a so-called "Report Currency". But IMO this leads to balance sheets to being confused with 'stock valuation' The existing balance sheet offers weighted-average, average-cost, nearest, latest. AFAIU weighted-average and average-cost obtains prices from the actual transactions; nearest means 'use price nearest to report-date', and latest means 'use today's nearest price' Let's say I bought: 100 AAPL at $10 in 2006, and 50 AAPL at $20 in 2009; and AAPL was $110 in 2015 AAPL is about $180 in 2018 I'm wanting stock valuation in 2015. - original currency - shows 150 AAPL, no price conversion (i.e. simplest) - cost price - 100x$10 + 50x$20 = $2000 (labour intensive because each stock transaction must be analysed, and converted using any available price entry to the report currency) - nearest - 150x$110 = $16,500 (simple) - latest - 150x$180 = $27,000 (also simple) Please check latest showing balsheet multicolumn amounts converted to report currency; although they're esthetically nice, this has increased the level of complexity a magnitude a tad too high... (I wouldn't know how/if income/expense amounts can/must be subject to price conversion...) I'd be keen to remove price conversion to report currency myself... On 26 June 2018 at 03:34, Stephen M. Butler wrote: > Christopher, > > I am attaching the three balance sheet reports available from within GNC > for both our test company and for my apartment building. Of the three, > the accountant likes the layout and totals of the eguile version the best. > > Her specific comments regarding the Multicolumn (pnl) are: > > 1. Not unheard of to compare this year-to-date with last year-ti-date > on a balance sheet (and income/expense) report. Less likely to be > beginning period/end period. Most generally only done for last report > of the year (to compare back to prior year). She prefers the single > point-in-time version for personal and small company finances. > > 2. Placeholder accounts should not show $0.00. Their true value is the > total for their level. > > 3. The dates should not be repeated for each section of the report. > Once at the top is enough. > > 4. Equity is the same as Net Worth. Its total should include: > a. Equity account totals > b. Trading account totals (if there are no trading accounts, > suppress that portion) > c. Period to date Profit/Loss which should match the (Income - > Expense) from the Income Statement. > > 5. Assets = Liabilities + Equity and the total of Liabilities and > Equity should be shown and match the total of Assets. > > 6. Put in the column underlines for the totals as is done on the eguile > version. Then you can remove the "Total for XXX" labels as it will be > obvious it is a total. > > > Now, for our test company, I think we have a problem with the GPB > valuations. We haven't done any bookkeeping with multiple currencies. > So will need input from somebody else. > > > > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > On 06/25/2018 06:56 AM, Christopher Lam wrote: > > Seeking beta testers. > > > > https://github.com/christopherlam/gnucash/tree/maint-balsheet-pnl > > > > Or, anyone with v3.2 onwards can copy the file directly into the > > build's standard-reports folder: > > https://raw.githubusercontent.com/christopherlam/gnucash/ > maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm > > > > Adds new balsheet and income statement (i.e. Profit) report. I > > still have further ideas in the pipeline, just wish to check accuracy > > of amounts produced. Not all options have been implemented. > > > > C > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or
Re: [GNC] Fwd: The two modules
Stephen, There is no need to install the libofx7specifically. If you install libofx-dev that should install the the appropriate version of the library for your ubuntu version (i.e. libofx4 on 14.04(Trusty), libofx6 on 16.04 (Xenial) and libofx7 on 18.04 (Bionic) David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: The two modules
Stephen, You can possibly force the case of sum of the children account totals being the parent account total by making the parent a placeholder account. Then it cannot have any transactions into it, only the child accounts. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] New Balsheet (and P report)
Christopher, I am attaching the three balance sheet reports available from within GNC for both our test company and for my apartment building. Of the three, the accountant likes the layout and totals of the eguile version the best. Her specific comments regarding the Multicolumn (pnl) are: 1. Not unheard of to compare this year-to-date with last year-ti-date on a balance sheet (and income/expense) report. Less likely to be beginning period/end period. Most generally only done for last report of the year (to compare back to prior year). She prefers the single point-in-time version for personal and small company finances. 2. Placeholder accounts should not show $0.00. Their true value is the total for their level. 3. The dates should not be repeated for each section of the report. Once at the top is enough. 4. Equity is the same as Net Worth. Its total should include: a. Equity account totals b. Trading account totals (if there are no trading accounts, suppress that portion) c. Period to date Profit/Loss which should match the (Income - Expense) from the Income Statement. 5. Assets = Liabilities + Equity and the total of Liabilities and Equity should be shown and match the total of Assets. 6. Put in the column underlines for the totals as is done on the eguile version. Then you can remove the "Total for XXX" labels as it will be obvious it is a total. Now, for our test company, I think we have a problem with the GPB valuations. We haven't done any bookkeeping with multiple currencies. So will need input from somebody else. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/25/2018 06:56 AM, Christopher Lam wrote: > Seeking beta testers. > > https://github.com/christopherlam/gnucash/tree/maint-balsheet-pnl > > Or, anyone with v3.2 onwards can copy the file directly into the > build's standard-reports folder: > https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm > > Adds new balsheet and income statement (i.e. Profit) report. I > still have further ideas in the pipeline, just wish to check accuracy > of amounts produced. Not all options have been implemented. > > C > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > CL Inc Balance Sheet 06/25/2018 Assets [1]Asset $0.00 [2]Bank1 $0.00 [3]Checking $0.00 [4]Savings $100.00 [5]Bonds $2,000.00 [6]Bank2 $500.00 [7]ForeignBank $0.00 [8]Broker $2,000.00 [9]Stock $4,000.00 [10]House $500.00 Total Assets $9,100.00 __ __ Liabilities [11]Liability $0.00 [12]Bank2 $0.00 [13]Loan -$9,000.00 [14]Creditcard -$500.00 Total Liabilities $9,500.00 __ Equity [15]Equity $400.00 Total Equity -$400.00 __ Total Liabilities & Equity $9,100.00 References 1. gnc-register:acct-guid=7fcbfd020fc34c04b40a9dc974b86bef 2. gnc-register:acct-guid=f99452f2d77548d6bf358d0ec762869b 3. gnc-register:acct-guid=c6ba7462d05848fb8ef0bd33d26009f2 4. gnc-register:acct-guid=9cd11b4781fc41f5aa19af7ecf2a5542 5. gnc-register:acct-guid=ac1afdb4517a40fd9181d58395ad59d6 6. gnc-register:acct-guid=000682dbdb2149f9891a3f3fe0f20bf5 7. gnc-register:acct-guid=18b586b15e6449a79429ec81c2c501ee 8. gnc-register:acct-guid=d6bdb46b4af0421eb376fc804836b6c4 9. gnc-register:acct-guid=a9eecc82cd904f44822550882a56bcb8 10. gnc-register:acct-guid=8e6fd8b862e84e0a9bfe6dd3c0ce21d7 11. gnc-register:acct-guid=26e0d29bd40f40468e7cda0650d8902d 12. gnc-register:acct-guid=4643a6d3c5c34c9d83d5e53c5ae34e59 13. gnc-register:acct-guid=c0fae8ed7a484d1ca883f34402cf56f6 14. gnc-register:acct-guid=686ff299b6a845cf9c906ba24b71dea9 15. gnc-register:acct-guid=3758364a8113489f9ce00013b2c1f065 CL Inc Balance Sheet (eguile) 06/25/2018 Assets Accounts [1]Asset [2]Bank1 [3]Checking $0.00 [4]Savings $100.00 [5]Bonds $2,000.00 Total [6]Bank1
Re: [GNC] Dark theme on Windows
Thank you Geert, For me it worked too in Windows with the same problems reported by Michael: In the record we have dark background and black font making it difficult to read. The alternative is to use the "Use GnuCash Built-in color theme" record option. But that's better than without black theme, it's already in use! I did not notice a difference without this line: gtk-theme-name=Adwaita And with Adwaita-Slim everything goes white again. Regards Em dom, 24 de jun de 2018 às 18:15, Geert Janssens < geert.gnuc...@kobaltwit.be> escreveu: > I have come across the following combination of settings to enable a > default > dark theme on linux. Creating a file settings.ini in $HOME/.config/gtk-3.0 > with this contents > > [Settings] > gtk-application-prefer-dark-theme=true > gtk-theme-name=Adwaita > > gives me the default Adwaita-dark theme. I would be interested to know if > this > also works on Windows (the file should be created in > %LOCALAPPDATA%\gtk-3.0 > instead). > > If so this could be added to our wiki here: > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes > > Can someone run this experiment and report back ? > > Thanks, > > Geert > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash 3.2 Released
Further research: It appears that net-charts.scm is a replacement for two other files in standard-reports: net-linecharts.scm and net-barcharts.scm I renamed those two to have a .old extension on them and GnuCash now starts up without complaining about duplicate report IDs. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/25/2018 10:20 AM, Stephen M. Butler wrote: > Compiled and installed on Ubuntu 18.04. > > When starting up it reports several duplicate report IDs. Should I have > uninstalled 3.1 first? I did these commands (with an empty mybuild): > > cd mybuild > > cmake ../gnucash-3.2 > > make > > sudo make install > > > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > On 06/24/2018 08:40 PM, John Ralls wrote: >> The GnuCash development team announces GnuCash 3.2, the second release of >> the 3.x stable release series. >> >> Changes >> >> Between 3.0 and 3.2, the following bugfixes were accomplished: >> >> • Bug 787401 - Test Report System - Report Definition. >> • Bug 794617 - Can't compile with -DWITH_GNUCASH=NO due to >> scm-gnome-utils. >> • Bug 795101 - Scroll Bar in Reconcile Window Floats in and covers the >> check boxes. >> • Bug 795247 - datepicker broken in Persian. GnuCash passes dates as >> integer y/m/d without using locale-specific formats, so we need to strip out >> 'E' and 'O' from the format when scanning dates or determining separators in >> gnc-date. None of '-', 'E', or 'O' are supported by boost (and '-' causes >> errors), so strip them out from formatters in gnc-datetime as well. >> • Bug 795253 - Have problems input Chinese. >> • Bug 795272 - QIF importer causes application crash if action is >> invalid. >> • Bug 795276 - Invalid date on price stops file from being parsed. >> • Bug 795362 - Special variable "i" not parsed in function calls. Due >> to balance tests with insane random values. >> • Bug 795471 - Impossible to Edit Budget Unless Maximized. >> • Bug 795519 - Credit card payment after reconciliation. >> • Bug 795666 - Backslash '\' in Description field spoils CSV Import >> without helpful error message. >> • Bug 795831 - When read only threshold set, dates are silently >> changed. Display a message box informing the user of the change. >> • Bug 795944 - Cannot store change to Business Suppliers data. >> • Bug 796079 - Repeatable Crash in Tax Report Options. >> • Bug 796081 - Tax Schedule Report - An error occurred while running >> the report. >> • Bug 796083 - Reconcile Selection Doesn't Work Anymore. >> • Bug 796117 - Connecting 3.1 to an existing mysql db drops all data. >> Provide a backup recovery function that instead of dropping primaries and >> restoring backups merges the primaries and backups. This should handle a >> worst-case safe-save failure where the backup tables don't have a complete >> set of rows for some reason. >> • Bug 796256 - Main Window stays hidden when starting after closing >> main window while minimized. >> • Bug 796369 - Notes lost or perhaps just not displaying when using >> SQLite backend. This bug caused data loss if you saved your SQLite3 database >> to a different file or database. The problem is that in SQLite3 (though not >> in MySQL or PgSQL) the subquery ((SELECT DISTINCT guid FROM transactions)) >> (note the double parentheses) returns only the first guid in the subquery's >> results. Some transactions are loaded by special queries and those queries >> are also used to retrieve the transaction's slots so they weren't affected. >> • Bug 796398 - Restrict accelerator keys to valid date range. >> • Bug 796409 - Incorrect Current Value for Stocks. Missed calculating >> the value in the register summary bar. >> • Bug 796423 - Cannot Input Chinese, seems does not work with other IME >> too. Toggles not in view with all rows selected weren't being redrawn. >> • Bug 796484 - csv import: iostream error. Unfortunately it turns out >> that we can't use filestreams because they can't take path arguments >> containing Unicode on Windows. >> • Bug 796527 - invalid currency on scheduled transactions. >> • Don't even check for price/exchange rate on template >> transactions, there's no point. >> • Check all split commodities are valid, abort transaction >> creation if not. >> • If the template transaction's currency isn't used by any of >> the splits set the new transaction's currency to the first-found currency if >> there is one, otherwise to the first-found commodity. >> • Bug 796537 - Transaction Report cannot sort by "num". >>
Re: [GNC] GnuCash 3.2 Released
Compiled and installed on Ubuntu 18.04. When starting up it reports several duplicate report IDs. Should I have uninstalled 3.1 first? I did these commands (with an empty mybuild): cd mybuild cmake ../gnucash-3.2 make sudo make install Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/24/2018 08:40 PM, John Ralls wrote: > The GnuCash development team announces GnuCash 3.2, the second release of the > 3.x stable release series. > > Changes > > Between 3.0 and 3.2, the following bugfixes were accomplished: > > • Bug 787401 - Test Report System - Report Definition. > • Bug 794617 - Can't compile with -DWITH_GNUCASH=NO due to > scm-gnome-utils. > • Bug 795101 - Scroll Bar in Reconcile Window Floats in and covers the > check boxes. > • Bug 795247 - datepicker broken in Persian. GnuCash passes dates as > integer y/m/d without using locale-specific formats, so we need to strip out > 'E' and 'O' from the format when scanning dates or determining separators in > gnc-date. None of '-', 'E', or 'O' are supported by boost (and '-' causes > errors), so strip them out from formatters in gnc-datetime as well. > • Bug 795253 - Have problems input Chinese. > • Bug 795272 - QIF importer causes application crash if action is > invalid. > • Bug 795276 - Invalid date on price stops file from being parsed. > • Bug 795362 - Special variable "i" not parsed in function calls. Due > to balance tests with insane random values. > • Bug 795471 - Impossible to Edit Budget Unless Maximized. > • Bug 795519 - Credit card payment after reconciliation. > • Bug 795666 - Backslash '\' in Description field spoils CSV Import > without helpful error message. > • Bug 795831 - When read only threshold set, dates are silently > changed. Display a message box informing the user of the change. > • Bug 795944 - Cannot store change to Business Suppliers data. > • Bug 796079 - Repeatable Crash in Tax Report Options. > • Bug 796081 - Tax Schedule Report - An error occurred while running > the report. > • Bug 796083 - Reconcile Selection Doesn't Work Anymore. > • Bug 796117 - Connecting 3.1 to an existing mysql db drops all data. > Provide a backup recovery function that instead of dropping primaries and > restoring backups merges the primaries and backups. This should handle a > worst-case safe-save failure where the backup tables don't have a complete > set of rows for some reason. > • Bug 796256 - Main Window stays hidden when starting after closing > main window while minimized. > • Bug 796369 - Notes lost or perhaps just not displaying when using > SQLite backend. This bug caused data loss if you saved your SQLite3 database > to a different file or database. The problem is that in SQLite3 (though not > in MySQL or PgSQL) the subquery ((SELECT DISTINCT guid FROM transactions)) > (note the double parentheses) returns only the first guid in the subquery's > results. Some transactions are loaded by special queries and those queries > are also used to retrieve the transaction's slots so they weren't affected. > • Bug 796398 - Restrict accelerator keys to valid date range. > • Bug 796409 - Incorrect Current Value for Stocks. Missed calculating > the value in the register summary bar. > • Bug 796423 - Cannot Input Chinese, seems does not work with other IME > too. Toggles not in view with all rows selected weren't being redrawn. > • Bug 796484 - csv import: iostream error. Unfortunately it turns out > that we can't use filestreams because they can't take path arguments > containing Unicode on Windows. > • Bug 796527 - invalid currency on scheduled transactions. > • Don't even check for price/exchange rate on template > transactions, there's no point. > • Check all split commodities are valid, abort transaction > creation if not. > • If the template transaction's currency isn't used by any of > the splits set the new transaction's currency to the first-found currency if > there is one, otherwise to the first-found commodity. > • Bug 796537 - Transaction Report cannot sort by "num". > • Bug 796586 - QIF import incorrectly converts unicode characters from > UTF8 encoded file. > • Bug 796595 - QIF Import Select Account button to add a new account is > labled gnc-account-new but should be New. > • Bug 796600 - stock split cash-in-lieu income/asset labels backwards. > • Bug 796614 - Reconciliation report contains incorrect transactions. > • Bug 796638 - configuration not properly saved for CSV transactions > import form. > The Following fixes and improvemts were not associated with bug reports: > > • Transaction report improvements: >
Re: [GNC] [regression] delete key functionality lost after pasting into a transaction field
> On Jun 25, 2018, at 8:16 AM, Jay Kvam wrote: > > Noticed the following regression since installing 3.2 this morning and have > been able to reproduce it predictably: > > After pasting anything into a transaction field—such as description, note, > memo, or value—the delete key no longer works, not only failing to delete > the contents of a field but also triggering a bell as if the user had > attempted to delete an already blank field. This occurs whether or not the > transaction has been saved. The only way to restore delete key > functionality is to close the register and reopen it. That, of course, does > not withstand another paste operation … > > Would have reported this as a bug in Bugzilla; however, 3.2 is not yet > available in the Version list, so I’m first posting here. > > macOS 10.12.5 “Sierra” That's been reported already: https://bugzilla.gnome.org/show_bug.cgi?id=796665. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Dark theme on Windows
Thanks. Hopefully Robert Fewell can pick it up as he did most of the css and theming work for Gnucash 3.x. Geert Op maandag 25 juni 2018 17:47:15 CEST schreef Fross, Michael: > The bug has been added. Please let me know how I can help. > > https://bugzilla.gnome.org/show_bug.cgi?id=796669 > > Regards, > > Michael > > On Mon, Jun 25, 2018 at 9:16 AM, Fross, Michael wrote: > > Sure. Will do. I had this issue with v2.x as well. > > > > On Mon, Jun 25, 2018 at 8:26 AM, Geert Janssens < > > > > geert.gnuc...@kobaltwit.be> wrote: > >> Thanks for the followup Michael. > >> > >> Normally GnuCash should detect a dark theme and adjust text color > >> accordingly. > >> If it doesn't, that's a bug then. Can you file this in bugzilla ? > >> > >> Thanks, > >> > >> Geert > >> > >> Op maandag 25 juni 2018 14:32:12 CEST schreef Fross, Michael: > >> > Hello Geert. > >> > > >> > This worked for me in Windows (although I used Adwaita-Slim instead of > >> > Adwaita.) > >> > > >> > I prefer the dark themes, but in the registers, the text is black on > >> > >> "dark" > >> > >> > and very hard to read. I know I can change around the row colors, but > >> > I > >> > don't know how to change the text color. Any idea? > >> > > >> > Michael > >> > > >> > On Sun, Jun 24, 2018 at 5:14 PM, Geert Janssens < > >> > >> geert.gnuc...@kobaltwit.be> > >> > >> > wrote: > >> > > I have come across the following combination of settings to enable a > >> > > default > >> > > dark theme on linux. Creating a file settings.ini in > >> > >> $HOME/.config/gtk-3.0 > >> > >> > > with this contents > >> > > > >> > > [Settings] > >> > > gtk-application-prefer-dark-theme=true > >> > > gtk-theme-name=Adwaita > >> > > > >> > > gives me the default Adwaita-dark theme. I would be interested to > >> > >> know if > >> > >> > > this > >> > > also works on Windows (the file should be created in > >> > > %LOCALAPPDATA%\gtk-3.0 > >> > > instead). > >> > > > >> > > If so this could be added to our wiki here: > >> > > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes > >> > > > >> > > Can someone run this experiment and report back ? > >> > > > >> > > Thanks, > >> > > > >> > > Geert > >> > > > >> > > > >> > > ___ > >> > > gnucash-user mailing list > >> > > gnucash-user@gnucash.org > >> > > To update your subscription preferences or to unsubscribe: > >> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> > > If you are using Nabble or Gmane, please see > >> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > >> > > - > >> > > Please remember to CC this list on all your replies. > >> > > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Dark theme on Windows
The bug has been added. Please let me know how I can help. https://bugzilla.gnome.org/show_bug.cgi?id=796669 Regards, Michael On Mon, Jun 25, 2018 at 9:16 AM, Fross, Michael wrote: > Sure. Will do. I had this issue with v2.x as well. > > On Mon, Jun 25, 2018 at 8:26 AM, Geert Janssens < > geert.gnuc...@kobaltwit.be> wrote: > >> Thanks for the followup Michael. >> >> Normally GnuCash should detect a dark theme and adjust text color >> accordingly. >> If it doesn't, that's a bug then. Can you file this in bugzilla ? >> >> Thanks, >> >> Geert >> >> Op maandag 25 juni 2018 14:32:12 CEST schreef Fross, Michael: >> > Hello Geert. >> > >> > This worked for me in Windows (although I used Adwaita-Slim instead of >> > Adwaita.) >> > >> > I prefer the dark themes, but in the registers, the text is black on >> "dark" >> > and very hard to read. I know I can change around the row colors, but I >> > don't know how to change the text color. Any idea? >> > >> > Michael >> > >> > On Sun, Jun 24, 2018 at 5:14 PM, Geert Janssens < >> geert.gnuc...@kobaltwit.be> >> > wrote: >> > > I have come across the following combination of settings to enable a >> > > default >> > > dark theme on linux. Creating a file settings.ini in >> $HOME/.config/gtk-3.0 >> > > with this contents >> > > >> > > [Settings] >> > > gtk-application-prefer-dark-theme=true >> > > gtk-theme-name=Adwaita >> > > >> > > gives me the default Adwaita-dark theme. I would be interested to >> know if >> > > this >> > > also works on Windows (the file should be created in >> > > %LOCALAPPDATA%\gtk-3.0 >> > > instead). >> > > >> > > If so this could be added to our wiki here: >> > > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes >> > > >> > > Can someone run this experiment and report back ? >> > > >> > > Thanks, >> > > >> > > Geert >> > > >> > > >> > > ___ >> > > gnucash-user mailing list >> > > gnucash-user@gnucash.org >> > > To update your subscription preferences or to unsubscribe: >> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > > If you are using Nabble or Gmane, please see >> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> > > - >> > > Please remember to CC this list on all your replies. >> > > You can do this by using Reply-To-List or Reply-All. >> >> >> >> >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] [regression] delete key functionality lost after pasting into a transaction field
Noticed the following regression since installing 3.2 this morning and have been able to reproduce it predictably: After pasting anything into a transaction field—such as description, note, memo, or value—the delete key no longer works, not only failing to delete the contents of a field but also triggering a bell as if the user had attempted to delete an already blank field. This occurs whether or not the transaction has been saved. The only way to restore delete key functionality is to close the register and reopen it. That, of course, does not withstand another paste operation … Would have reported this as a bug in Bugzilla; however, 3.2 is not yet available in the Version list, so I’m first posting here. macOS 10.12.5 “Sierra” kindly, Jay On Mon, Jun 25, 2018 at 6:33 AM, wrote: > Send gnucash-user mailing list submissions to > gnucash-user@gnucash.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to > gnucash-user-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-user-ow...@gnucash.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > >1. Re: Problem with Reports (D) >2. GnuCash 3.2 Released (John Ralls) >3. Re: CSV to QIF converter for Mobile viking usage reports > (Bram Mertens) >4. Re: Upgrade to 3.x Save As (sqlite3) failing with data > corruption error (Geert Janssens) >5. Problem with Reports (Shelley Salter) >6. 3.2 out and no mention here? (randix) >7. Re: Upgrade to 3.x Save As (sqlite3) failing with data > corruption error (Steve Alex) >8. Re: 3.2 out and no mention here? (Maf. King) >9. Re: Dark theme on Windows (Fross, Michael) > 10. Re: Dark theme on Windows (Geert Janssens) > 11. Re: Upgrade to 3.x Save As (sqlite3) failing with data > corruption error (Geert Janssens) > > > -- > > Message: 1 > Date: Sun, 24 Jun 2018 21:48:27 -0400 > From: D > To: Shelley Salter , Gnucash Users > > Subject: Re: [GNC] Problem with Reports > Message-ID: <32h9luhfw1rmc2mapoy0nswk.1529891307...@email.android.com> > Content-Type: text/plain; charset=utf-8 > > Shelley, > > Welcome. > > It looks from your example like you have your main accounts in USD, and > your sub accounts in Canadian dollars. I do not use multiple currencies, > but I believe that your problem stems from this. Someone who uses multiple > currencies should be able to give you more specific guidance. > > David > > On June 24, 2018, at 12:20 PM, Shelley Salter via gnucash-user < > gnucash-user@gnucash.org> wrote: > > Just downloaded the program and thought I would try it out but don't > understand why the Income Statement is showing Total Revenue and Total > Expenses as 0? > Income Statement For Period Covering 01/01/2018 to 12/31/2018 > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?Revenues Income C$500.00 > $0.00Total Revenue $0.00? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? > ?Expenses Expenses C$50.00 $0.00Total Expenses $0.00Net income for Period > $0.00 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > -- > > Message: 2 > Date: Sun, 24 Jun 2018 20:40:38 -0700 > From: John Ralls > To: Gnucash-User > Cc: gnucash-annou...@gnucash.org, gnucash-devel > > Subject: [GNC] GnuCash 3.2 Released > Message-ID: > Content-Type: text/plain; charset=utf-8 > > The GnuCash development team announces GnuCash 3.2, the second release of > the 3.x stable release series. > > Changes > > Between 3.0 and 3.2, the following bugfixes were accomplished: > > ? Bug 787401 - Test Report System - Report Definition. > ? Bug 794617 - Can't compile with -DWITH_GNUCASH=NO due to > scm-gnome-utils. > ? Bug 795101 - Scroll Bar in Reconcile Window Floats in and covers > the check boxes. > ? Bug 795247 - datepicker broken in Persian. GnuCash passes dates > as integer y/m/d without using locale-specific formats, so we need to strip > out 'E' and 'O' from the format when scanning dates or determining > separators in gnc-date. None of '-', 'E', or 'O' are supported by boost > (and '-' causes errors), so strip them out from formatters in gnc-datetime > as well. > ? Bug 795253 - Have problems input Chinese. > ? Bug 795272 - QIF importer
Re: [GNC] Dark theme on Windows
Sure. Will do. I had this issue with v2.x as well. On Mon, Jun 25, 2018 at 8:26 AM, Geert Janssens wrote: > Thanks for the followup Michael. > > Normally GnuCash should detect a dark theme and adjust text color > accordingly. > If it doesn't, that's a bug then. Can you file this in bugzilla ? > > Thanks, > > Geert > > Op maandag 25 juni 2018 14:32:12 CEST schreef Fross, Michael: > > Hello Geert. > > > > This worked for me in Windows (although I used Adwaita-Slim instead of > > Adwaita.) > > > > I prefer the dark themes, but in the registers, the text is black on > "dark" > > and very hard to read. I know I can change around the row colors, but I > > don't know how to change the text color. Any idea? > > > > Michael > > > > On Sun, Jun 24, 2018 at 5:14 PM, Geert Janssens < > geert.gnuc...@kobaltwit.be> > > wrote: > > > I have come across the following combination of settings to enable a > > > default > > > dark theme on linux. Creating a file settings.ini in > $HOME/.config/gtk-3.0 > > > with this contents > > > > > > [Settings] > > > gtk-application-prefer-dark-theme=true > > > gtk-theme-name=Adwaita > > > > > > gives me the default Adwaita-dark theme. I would be interested to know > if > > > this > > > also works on Windows (the file should be created in > > > %LOCALAPPDATA%\gtk-3.0 > > > instead). > > > > > > If so this could be added to our wiki here: > > > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes > > > > > > Can someone run this experiment and report back ? > > > > > > Thanks, > > > > > > Geert > > > > > > > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > If you are using Nabble or Gmane, please see > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > > - > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Upgrade to 3.x Save As (sqlite3) failing with data corruption error
> On Jun 25, 2018, at 6:33 AM, Geert Janssens
> wrote:
>
> Op maandag 25 juni 2018 13:20:10 CEST schreef Steve Alex:
>>> On Jun 25, 2018, at 3:40 AM, Geert Janssens
>>> wrote:>
>>> Op maandag 25 juni 2018 01:38:35 CEST schreef salex:
I've been trying to set up a procedure where two people can access our
XML
file located on a file server and of course ran into problems and know
there are other possible problem (file marked open if you loose the
network - yes I know its single user)
My tests last week seemed to work, but I've been cautious. There may be
potential problems in that I'm on a Mac and the other user will be on
Windows 10. Then the file server is a debian server.
I noticed that the Windows version 3.x and I was using 2.6.4. Also
noticed
that the windows version had Postgres option. I download the new version
using brew cask wanting to try postgres for my report system,
I've been using a procedure for years that now seems broken.
I update the main book on a Mac (using xml). A few times a month I do a
"Save As" and save off an sqlite3 version in another folder inside my
GnuCash folder. I immediately open the xml version and quit.
I then run a bash script to backup the folder(rsync) to the debian
server.
The sqlite3 file is used by a Rails server to produce reports I've
developed.
I figured we'd use a modified procedure in that the updates would use the
XML version on the debian server (maybe a script to check dates or see if
file is open). I'd also put in a cron task to backup the folder to
another
offsite server.
Since I was on the server, when I did my "Save As", it was in the same
file
system. I alway just did the save as over the existing version since its
just a read only file ( just confirm overwrite message)
When I did that with 3.x, after confirming overwrite, I'd get an error
message saying it could complete because of data corruption.
>>>
>>> This sounds like https://bugzilla.gnome.org/show_bug.cgi?id=789594
>>> If you remove the existing sqlite file before running a Save As, do you
>>> still get the error message about data corruption ?
>>
>> I just saw that in the release 3.2 message, then got this reply.
>>
>> I don’t think so. I think I set a different file name (or different folder)
>> and there was no error. I think thats when I discovered my report system
>> broke - most likely by the date format change mentioned below.
Don't know if this is 3.x problem or not. Switched back to 2.6 and it
worked, even working on the server version.
Before I switched back to 2.6, I did the save as on my mac and copied the
file the the server, I haven't verified this but my report system broke.
I
got no errors but a simple checkbook register had a balance but do ledger
lines.
>>>
>>> We had to make some changes to the database schema that may affect your
>>> direct access to the book.
>>>
>>> A few that come to mind:
>>> - the field format to store dates has changed (affecting many tables)
>>
>> That is most likely it.
>>
>> What did dates change to? Just another version of a timestamp (and not
>> MMDDHHMM ? I have lots of code (functions) that is basically taking a
>> ruby date and doing something like; def self.month_transactions(date)
>> month = Vfwcash.mm(date) # just date parser that returns string in
>> format MM trans = Tran.where('transactions.post_date BETWEEN ? and
>> ?',month+"00",month+"32").order(:post_date,:num) end
>
> I believe the change was to
> -MM-DD HH:MM:SS
> Though I'm not sure. I haven't done this part and I'm not really using the
> SQL
> backends.
>
That’s correct. SQLite3 stores everything as strings. The old database code
wrote MMDDHHMMSS, the new writes -MM-DD HH:MM:SS so that it’s
consistent with what MySQL and Postgresql return.
Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] New Balsheet (and P report)
Seeking beta testers. https://github.com/christopherlam/gnucash/tree/maint-balsheet-pnl Or, anyone with v3.2 onwards can copy the file directly into the build's standard-reports folder: https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm Adds new balsheet and income statement (i.e. Profit) report. I still have further ideas in the pipeline, just wish to check accuracy of amounts produced. Not all options have been implemented. C ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Upgrade to 3.x Save As (sqlite3) failing with data corruption error
Op maandag 25 juni 2018 13:20:10 CEST schreef Steve Alex:
> > On Jun 25, 2018, at 3:40 AM, Geert Janssens
> > wrote:>
> > Op maandag 25 juni 2018 01:38:35 CEST schreef salex:
> >> I've been trying to set up a procedure where two people can access our
> >> XML
> >> file located on a file server and of course ran into problems and know
> >> there are other possible problem (file marked open if you loose the
> >> network - yes I know its single user)
> >>
> >> My tests last week seemed to work, but I've been cautious. There may be
> >> potential problems in that I'm on a Mac and the other user will be on
> >> Windows 10. Then the file server is a debian server.
> >>
> >> I noticed that the Windows version 3.x and I was using 2.6.4. Also
> >> noticed
> >> that the windows version had Postgres option. I download the new version
> >> using brew cask wanting to try postgres for my report system,
> >>
> >> I've been using a procedure for years that now seems broken.
> >>
> >> I update the main book on a Mac (using xml). A few times a month I do a
> >> "Save As" and save off an sqlite3 version in another folder inside my
> >> GnuCash folder. I immediately open the xml version and quit.
> >>
> >> I then run a bash script to backup the folder(rsync) to the debian
> >> server.
> >>
> >> The sqlite3 file is used by a Rails server to produce reports I've
> >> developed.
> >>
> >> I figured we'd use a modified procedure in that the updates would use the
> >> XML version on the debian server (maybe a script to check dates or see if
> >> file is open). I'd also put in a cron task to backup the folder to
> >> another
> >> offsite server.
> >>
> >> Since I was on the server, when I did my "Save As", it was in the same
> >> file
> >> system. I alway just did the save as over the existing version since its
> >> just a read only file ( just confirm overwrite message)
> >>
> >> When I did that with 3.x, after confirming overwrite, I'd get an error
> >> message saying it could complete because of data corruption.
> >
> > This sounds like https://bugzilla.gnome.org/show_bug.cgi?id=789594
> > If you remove the existing sqlite file before running a Save As, do you
> > still get the error message about data corruption ?
>
> I just saw that in the release 3.2 message, then got this reply.
>
> I don’t think so. I think I set a different file name (or different folder)
> and there was no error. I think thats when I discovered my report system
> broke - most likely by the date format change mentioned below.
> >> Don't know if this is 3.x problem or not. Switched back to 2.6 and it
> >> worked, even working on the server version.
> >>
> >> Before I switched back to 2.6, I did the save as on my mac and copied the
> >> file the the server, I haven't verified this but my report system broke.
> >> I
> >> got no errors but a simple checkbook register had a balance but do ledger
> >> lines.
> >
> > We had to make some changes to the database schema that may affect your
> > direct access to the book.
> >
> > A few that come to mind:
> > - the field format to store dates has changed (affecting many tables)
>
> That is most likely it.
>
> What did dates change to? Just another version of a timestamp (and not
> MMDDHHMM ? I have lots of code (functions) that is basically taking a
> ruby date and doing something like; def self.month_transactions(date)
> month = Vfwcash.mm(date) # just date parser that returns string in
> format MM trans = Tran.where('transactions.post_date BETWEEN ? and
> ?',month+"00",month+"32").order(:post_date,:num) end
I believe the change was to
-MM-DD HH:MM:SS
Though I'm not sure. I haven't done this part and I'm not really using the SQL
backends.
Regards,
Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Dark theme on Windows
Thanks for the followup Michael. Normally GnuCash should detect a dark theme and adjust text color accordingly. If it doesn't, that's a bug then. Can you file this in bugzilla ? Thanks, Geert Op maandag 25 juni 2018 14:32:12 CEST schreef Fross, Michael: > Hello Geert. > > This worked for me in Windows (although I used Adwaita-Slim instead of > Adwaita.) > > I prefer the dark themes, but in the registers, the text is black on "dark" > and very hard to read. I know I can change around the row colors, but I > don't know how to change the text color. Any idea? > > Michael > > On Sun, Jun 24, 2018 at 5:14 PM, Geert Janssens > wrote: > > I have come across the following combination of settings to enable a > > default > > dark theme on linux. Creating a file settings.ini in $HOME/.config/gtk-3.0 > > with this contents > > > > [Settings] > > gtk-application-prefer-dark-theme=true > > gtk-theme-name=Adwaita > > > > gives me the default Adwaita-dark theme. I would be interested to know if > > this > > also works on Windows (the file should be created in > > %LOCALAPPDATA%\gtk-3.0 > > instead). > > > > If so this could be added to our wiki here: > > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes > > > > Can someone run this experiment and report back ? > > > > Thanks, > > > > Geert > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Dark theme on Windows
Hello Geert. This worked for me in Windows (although I used Adwaita-Slim instead of Adwaita.) I prefer the dark themes, but in the registers, the text is black on "dark" and very hard to read. I know I can change around the row colors, but I don't know how to change the text color. Any idea? Michael On Sun, Jun 24, 2018 at 5:14 PM, Geert Janssens wrote: > I have come across the following combination of settings to enable a > default > dark theme on linux. Creating a file settings.ini in $HOME/.config/gtk-3.0 > with this contents > > [Settings] > gtk-application-prefer-dark-theme=true > gtk-theme-name=Adwaita > > gives me the default Adwaita-dark theme. I would be interested to know if > this > also works on Windows (the file should be created in > %LOCALAPPDATA%\gtk-3.0 > instead). > > If so this could be added to our wiki here: > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes > > Can someone run this experiment and report back ? > > Thanks, > > Geert > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 3.2 out and no mention here?
On Monday, 25 June 2018 11:39:16 BST randix wrote: > or has it been out for a while and i'm just not paying attention? > Announced on the list about 8 hours ago by John Ralls. (Thanks John & devs!) Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Upgrade to 3.x Save As (sqlite3) failing with data corruption error
> On Jun 25, 2018, at 3:40 AM, Geert Janssens
> wrote:
>
> Op maandag 25 juni 2018 01:38:35 CEST schreef salex:
>> I've been trying to set up a procedure where two people can access our XML
>> file located on a file server and of course ran into problems and know there
>> are other possible problem (file marked open if you loose the network - yes
>> I know its single user)
>>
>> My tests last week seemed to work, but I've been cautious. There may be
>> potential problems in that I'm on a Mac and the other user will be on
>> Windows 10. Then the file server is a debian server.
>>
>> I noticed that the Windows version 3.x and I was using 2.6.4. Also noticed
>> that the windows version had Postgres option. I download the new version
>> using brew cask wanting to try postgres for my report system,
>>
>> I've been using a procedure for years that now seems broken.
>>
>> I update the main book on a Mac (using xml). A few times a month I do a
>> "Save As" and save off an sqlite3 version in another folder inside my
>> GnuCash folder. I immediately open the xml version and quit.
>>
>> I then run a bash script to backup the folder(rsync) to the debian server.
>>
>> The sqlite3 file is used by a Rails server to produce reports I've
>> developed.
>>
>> I figured we'd use a modified procedure in that the updates would use the
>> XML version on the debian server (maybe a script to check dates or see if
>> file is open). I'd also put in a cron task to backup the folder to another
>> offsite server.
>>
>> Since I was on the server, when I did my "Save As", it was in the same file
>> system. I alway just did the save as over the existing version since its
>> just a read only file ( just confirm overwrite message)
>>
>> When I did that with 3.x, after confirming overwrite, I'd get an error
>> message saying it could complete because of data corruption.
>>
> This sounds like https://bugzilla.gnome.org/show_bug.cgi?id=789594
> If you remove the existing sqlite file before running a Save As, do you still
> get the error message about data corruption ?
I just saw that in the release 3.2 message, then got this reply.
I don’t think so. I think I set a different file name (or different folder) and
there was no error. I think thats when I discovered my report system broke -
most likely by the date format change mentioned below.
>
>> Don't know if this is 3.x problem or not. Switched back to 2.6 and it
>> worked, even working on the server version.
>>
>> Before I switched back to 2.6, I did the save as on my mac and copied the
>> file the the server, I haven't verified this but my report system broke. I
>> got no errors but a simple checkbook register had a balance but do ledger
>> lines.
>
> We had to make some changes to the database schema that may affect your
> direct
> access to the book.
>
> A few that come to mind:
> - the field format to store dates has changed (affecting many tables)
That is most likely it.
What did dates change to? Just another version of a timestamp (and not
MMDDHHMM ? I have lots of code (functions) that is basically taking a ruby
date and doing something like;
def self.month_transactions(date)
month = Vfwcash.mm(date) # just date parser that returns string in
format MM
trans = Tran.where('transactions.post_date BETWEEN ? and
?',month+"00",month+"32").order(:post_date,:num)
end
> - some parts of gnucash now store their slots in flat format instead of
> hierarchically. If you're not using the slots in your custom report, this
> won’t affect you
Don’t use slots, just Accounts, Splits and Transactions.
>
> Regards,
>
> Geert
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] 3.2 out and no mention here?
or has it been out for a while and i'm just not paying attention? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Problem with Reports
Thank you for your help, I did have two currencies and now have fixed the problem.Shelley ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Upgrade to 3.x Save As (sqlite3) failing with data corruption error
Op maandag 25 juni 2018 01:38:35 CEST schreef salex: > I've been trying to set up a procedure where two people can access our XML > file located on a file server and of course ran into problems and know there > are other possible problem (file marked open if you loose the network - yes > I know its single user) > > My tests last week seemed to work, but I've been cautious. There may be > potential problems in that I'm on a Mac and the other user will be on > Windows 10. Then the file server is a debian server. > > I noticed that the Windows version 3.x and I was using 2.6.4. Also noticed > that the windows version had Postgres option. I download the new version > using brew cask wanting to try postgres for my report system, > > I've been using a procedure for years that now seems broken. > > I update the main book on a Mac (using xml). A few times a month I do a > "Save As" and save off an sqlite3 version in another folder inside my > GnuCash folder. I immediately open the xml version and quit. > > I then run a bash script to backup the folder(rsync) to the debian server. > > The sqlite3 file is used by a Rails server to produce reports I've > developed. > > I figured we'd use a modified procedure in that the updates would use the > XML version on the debian server (maybe a script to check dates or see if > file is open). I'd also put in a cron task to backup the folder to another > offsite server. > > Since I was on the server, when I did my "Save As", it was in the same file > system. I alway just did the save as over the existing version since its > just a read only file ( just confirm overwrite message) > > When I did that with 3.x, after confirming overwrite, I'd get an error > message saying it could complete because of data corruption. > This sounds like https://bugzilla.gnome.org/show_bug.cgi?id=789594 If you remove the existing sqlite file before running a Save As, do you still get the error message about data corruption ? > Don't know if this is 3.x problem or not. Switched back to 2.6 and it > worked, even working on the server version. > > Before I switched back to 2.6, I did the save as on my mac and copied the > file the the server, I haven't verified this but my report system broke. I > got no errors but a simple checkbook register had a balance but do ledger > lines. We had to make some changes to the database schema that may affect your direct access to the book. A few that come to mind: - the field format to store dates has changed (affecting many tables) - some parts of gnucash now store their slots in flat format instead of hierarchically. If you're not using the slots in your custom report, this won't affect you Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] CSV to QIF converter for Mobile viking usage reports
Thanks, I'll see if I can add it there later today. Bram On Mon, Jun 25, 2018 at 12:45 AM GT-I9070 H wrote: > > Hi Bram, > > It would look better here: https://wiki.gnucash.org/wiki/Published_tools > > Regards > > Em dom, 24 de jun de 2018 às 12:05, Bram Mertens > escreveu: >> >> Hi, >> >> I have created a simple python script that creates a QIF file from the >> usage report of Mobile Vikings. >> Mobile Vikings a Mobile Virtual Network Operator active in Belgium. >> >> The script and a README are available at >> https://gitlab.com/m8ram/vikingcsv2qif . >> >> The target audience is probably quite small: GnuCash users in Belgium >> with an account with this operator but perhaps it can serve as >> inspiration for other similar uses. >> >> Feel free to send me remarks/suggestions and use the code. >> >> Hope this helps >> >> Bram >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
