Re: Future allocated money, aka Envelope Budgeting

On 31/01/2018 16:09, Christopher Lam wrote: Hi Matt- I thought this should move to the devel list, because of technical details, and this discussion will be very speculative. I had a thought about how envelope budgeting could work: "divide your paycheck into separate envelopes for different pu

Re: Future allocated money, aka Envelope Budgeting

On 31/01/2018 20:18, Matt Graham wrote: Love the thoughts! Simplicity is king I think. I am going to ponder your idea for longer Chris.. It may be that there is a better way to structure budgeting in gnc, or as Adrian says maybe a new user interface is the better way to go. One thing on my to

Re: Future allocated money, aka Envelope Budgeting

On 02/02/2018 08:17, Christopher Lam wrote: Dear Devs The more I consider (b)udget transactions the more I feel it is the right solution. See https://docs.google.com/spreadsheets/d/1aaMoMVVTky_Df_haNAeVk3XpsgFIC7eMOOT7uurlV-s/edit?usp=sharing for an example of a report with these "b"udget and

Re: Future allocated money, aka Envelope Budgeting

On 03/02/2018 00:12, Matt Graham wrote: Wow! That become contentious quick!!! Only sort of. If you read the devel list before the user list you get a feeling for what isn't going to happen soon and why. The primary issue I’m seeing here is one of philosophy. What is GNUCash for? What is t

Re: Future allocated money, aka Envelope Budgeting

On 04/02/2018 13:44, Christopher Lam wrote: I wished to experiment in what budgeting should look like by using the existing engine, UI, and reporting infrastructure. If you want to know how one form of budgeting, that which includes envelope budgeting budgeting is likely to be implemented fro

Re: Future allocated money, aka Envelope Budgeting

On 07/02/2018 09:45, Alen Siljak wrote: He he Thanks a lot for the tips. I'm in touch with Sebastien in order to polish the ledger export script. It is available either directly (pc-export has been renamed to export.py) or through piecash cli ("piecash ledger" is the command

Re: price.date, transaction.post_date and neutral time

On 11/02/2018 12:33, Sébastien de Menten wrote: When exporting data from SQL backends, I see some inconsistencies in the handling of some date & datetime columns. In the prices table, when adding price via the price editor, I see in the date column a datetime with the UTC of the /MM/DD 00:00

Re: price.date, transaction.post_date and neutral time

e else is interested. There is lots of scope in other projects, I don't like people forcing one to be another Sent: Monday, February 12, 2018 at 3:17 PM From: "Wm via gnucash-devel" To: gnucash-de...@lists.gnucash.org Subject: Re: price.date, transaction.post

Re: price.date, transaction.post_date and neutral time

On 12/02/2018 21:00, Sébastien de Menten wrote: When I enter a new price for a given day for a security on the NASDAQ via the price editor, it is stored in the date column the UTC time for that day at 00:00:00 local time (CET=Europe, not EST=New-York). Which is weird because across timezone, the

Re: price.date, transaction.post_date and neutral time

On 12/02/2018 18:57, Alen Siljak wrote: Sent: Monday, February 12, 2018 at 7:34 PM From: "Wm via gnucash-devel" To: gnucash-de...@lists.gnucash.org Subject: Re: price.date, transaction.post_date and neutral time On 12/02/2018 14:27, Alen Siljak wrote: I am currently sepa

Re: Scope of GNUCash

On 13/02/2018 01:42, Matt Graham wrote: IIRC the discussion at the time was about whether gnc should or could be used for trading. the result was "no" I said that. A couple of times I have noticed that people have said "That's not what GNUCash is for". It begs the question - where is it

Re: price.date, transaction.post_date and neutral time

On 13/02/2018 09:12, Alen Siljak wrote: Done. https://wiki.gnucash.org/wiki/GnuCash_and_Mobile_Devices sweet Aside: I am completely confused how MMEX for Android could be used for Asset Allocation, MMEX doesn't understand Assets and Liabilities and Equity! Looking at the forums, the dev's o

Re: price.date, transaction.post_date and neutral time

On 13/02/2018 18:12, Sébastien de Menten wrote: r/2012/2018/ (it was a typo) ok My point is that a price entered via the price editor (manually) is handled differently than a price generated via a transaction Isn't that a good thing ? I shouldn't have to say again that the price db is jus

Re: Scope of GNUCash

On 13/02/2018 21:53, Matt Graham wrote: 😊 I think I would love to sit down in a pub with the three of you (Wm, Adrien, and Mike). I think we could have such awesome semi-drunken discussions about the nature of life, the universe and everything! I'm in London. Mike is in a Trump voting bit of

Re: Scope of GNUCash

On 13/02/2018 15:30, Adrien Monteleone wrote: Michael, I agree completely on the separation point, especially with regard to controls. If you agree on that you are an idiot, Mike's POV is (if I understand correctly over a period of time) mainly a charitable one. I’ve seen first hand when s

Re: Scope of GNUCash

On 14/02/2018 15:12, Mike or Penny Novack wrote: 😊 I think I would love to sit down in a pub with the three of you (Wm, Adrien, and Mike). I think we could have such awesome semi-drunken discussions about the nature of life, the universe and everything! I'm in London. Mike is in a Trump vo

Re: Scope of GNUCash

On 14/02/2018 03:55, Christopher Lam wrote: Hi Adrien - from someone who jumped head first into scheme, come on in :) the water's warm, and the old guard are very happy to help you implement your wishlist. Meanwhile you'll soon see for yourself what the project needs and can dabble in too. Scheme

Re: Scope of GNUCash

On 14/02/2018 04:46, Matt Graham wrote: Not sure why you think I’m one of the “demanding” people... I’m not actually asking for anything – I’m trying to figure out how this all works, what I really need, and how I can contribute to make it happen I don’t expect anything specific from the

Re: Scope of GNUCash

On 14/02/2018 15:29, Mike or Penny Novack wrote: On 2/13/2018 9:49 PM, Wm via gnucash-devel wrote: Why are you blaming the workers rather than the employers? Why do you think a piece of software can help if you are shitting on your employees? Mike, is this what you expected as a response

Re: Scope of GNUCash

On 14/02/2018 18:07, Adrien Monteleone wrote: On Feb 13, 2018, at 8:49 PM, Wm via gnucash-devel wrote: On 13/02/2018 15:30, Adrien Monteleone wrote: Michael, I agree completely on the separation point, especially with regard to controls. If you agree on that you are an idiot, I’m not

Re: price.date, transaction.post_date and neutral time

On 14/02/2018 10:58, Mark Haanen wrote: Wm via gnucash-devel schreef op 13-02-18 om 17:10: On 13/02/2018 09:12, Alen Siljak wrote: - we enter the investments we own, i.e. Stocks Fund, Bonds Fund, Direct Bond, favorite company ABC stock, etc. - we link the investments (by symbol) to the

Re: Scope of GNUCash

On 16/02/2018 16:19, David Carlson wrote: Wm, this is a GnuCash miallist, not a political forum. If there was any useful information in that last spate, I didn't even see it. Liz, you have my permission to cut him off again. David C I presume you do know Liz isn't american ? The sensible re

Re: price.date, transaction.post_date and neutral time

On 14/02/2018 02:59, David T. via gnucash-devel wrote: Wm, Sebastien, I profess to not paying too much attention to this thread, but IIRC, there was a time when the price entered into transactions was NOT entered into the price DB, which meant that users would often get useless reports on comm

Re: Scope of GNUCash

On 16/02/2018 16:19, David Carlson wrote: Wm, this is a GnuCash miallist, not a political forum. If there was any useful information in that last spate, I didn't even see it. Liz, you have my permission to cut him off again. I think David Carlson may also be an unrealistic attributer. David,

Re: Fwd: Gnucash Userlist

On 16/02/2018 16:27, David Carlson wrote: -- Forwarded message -- From: David Carlson Date: Fri, Feb 16, 2018 at 10:25 AM Subject: Gnucash Userlist To: Gnucash Users to Wm, Gnucash Wm, this is a GnuCash miallist, not a political forum. If there was any useful information in th

Re: trial balance - how to find mismatch question

On 16/02/2018 10:57, David Carlson wrote: As another user with a lot of stock trades, I sometimes use that report to find an issue, although I have developed a process involving outside spreadsheets to calculate realized gains per security account as GnuCash calculates them and net gains as the

Re: trial balance - how to find mismatch question

On 16/02/2018 11:24, Christopher Lam wrote: I like the way this is going. Please describe or file minimal data file cases in Bugzilla. Perhaps I'll be able to decode the trial balance and we can decide then what it should really do. It is possible I've missed a detail but in RL a TB should only

Re: Permissions for gnc-fq-update

On 16/02/2018 04:07, David T. via gnucash-devel wrote: Hello, In my quixotic quest to try and get quote retrieval working again on my Mac, I’ve been looking at ways to remove and reload all the Perl underlying Finance::Quote. (As John noted to me recently, there isn’t any uninstall command in

Re: trial balance - how to find mismatch question

On 03/03/2018 17:59, Geert Janssens wrote: Op zaterdag 3 maart 2018 16:35:27 CET schreef David Carlson: On January 30, 2015 I reported https://bugzilla.gnome.org/show_bug.cgi?id=743753 pointing out this behavior in Gnucash suggesting that the nearest in time criterion should not select future da

Re: trial balance - how to find mismatch question

On 03/03/2018 18:52, D via gnucash-devel wrote: I think having nearest in time use future dates relative to the report date is not useful. Mind you, matching a broker statement for value (as opposed to holdings) is perhaps equally not useful. I guess I could see a point to a nearest in time u

Re: trial balance - how to find mismatch question

On 03/03/2018 18:52, D via gnucash-devel wrote: I think having the extra option would be useful and less confusing than having "Nearest in time" only look backwards. Nearest in time is relative to the report date? Where is the confusion? -- Wm ___

Re: trial balance - how to find mismatch question

On 16/02/2018 04:55, David T. via gnucash-devel wrote: I don’t believe I’ve seen anywhere in this thread any attempt to explain that there is a difference between IMBALANCE-XXX (an indication that you have transactions that lacked a balancing split) and the Imbalance entry in the Trial Balance rep

Re: trial balance - how to find mismatch question

On 16/02/2018 08:20, Adrien Monteleone wrote: At least on my version of the Trial Balance report, there is no ‘Imbalance entry’ specifically. There is at the bottom, the Imbalance-XXX and Orphan-XXX accounts listed along with the others. There is also a line for ‘Unrealized Gains’ or ‘Unreali

emojis everywhere, seeking understanding / clarity / opinion

background: gnc 3.0 allows emojis in places I think inappropriate e.g. account names account codes securities and offers them in places it shouldn't e.g. dates numbers === the thing I'm wondering about is if I am totally out of date or just being realistic. Argument A: emojis are everyw

Re: emojis everywhere, seeking understanding / clarity / opinion

On 07/04/2018 19:50, Buddha Buck wrote: [much snipped] thanks to JohnR too, BB's message was more fun to reply to On Sat, Apr 7, 2018 at 2:12 AM Wm via gnucash-devel < gnucash-devel@gnucash.org> wrote: Perhaps, but I don't think it is GnuCash's place to dictate that

Re: [GNC-dev] Register + Unicode (was Re: emojis everywhere...)

On 08/04/2018 07:30, Eric Siegerman wrote: sensible world view stuff that shouldn't have to be said [*] We call our numerals "Arabic", but most(?) of the Arab world actually uses different ones -- somewhat related to ours, but not closely enough to be very legible to my Anglo eyes. I believe o

Re: [GNC-dev] emojis everywhere, seeking understanding / clarity / opinion

On 08/04/2018 04:38, John Ralls wrote: Well, I suppose that’s always a concern with pictographs, eh? The standard *the* standard ? specifies a description, in a few words of English, of what each code point is supposed to represent. *supposed* to > After that it’s up to the artist creatin

Re: [GNC-dev] Bye-bye Unstable

On 16/04/2018 17:40, Geert Janssens wrote: Op maandag 16 april 2018 12:33:53 CEST schreef Robert Fewell: Just trying to get myself straight for going forward. maint is now for bug fixes on version 3.0 master is for new stuff that would go into 4.0 but may be backported to 3.x if appropriate Mo

Re: [GNC-dev] GDPR and gnucash as a project

On 22/05/2018 14:02, Geert Janssens wrote: Yesterday John raised some concerns about GDPR compliance of the gnucash project itself. This is a different question from the one Mike Evans asked in April this year about GDPR compliance by people *using* gnucash. This requires some thought as the GD

Re: [GNC-dev] GDPR and terrorism

On 22/05/2018 19:42, Frank H. Ellenberger wrote: Am 22.05.2018 um 19:21 schrieb Geert Janssens: IRC includes IP addresses, which the GDPR explicitly mentions as personal information, in “joined” messages, and those get logged. ISTM those messages aren’t important as they’re not part of the conve

Re: [GNC-dev] GDPR and gnucash as a project

On 22/05/2018 15:36, David T. via gnucash-devel wrote: Geert, I am not fluent with the issues of the GDPR, relatively few people are but they have been thought about they are not harmful to you or I I am not accepting the offered changes in T+C unless it is a bank or business I know, then I

Re: [GNC-dev] GDPR and gnucash as a project

On 22/05/2018 15:36, David T. via gnucash-devel wrote: * - I would be extremely surprised to find that a user’s name, in and of itself, would constitute protected personal information. There are some unusual circumstances where a person's name may be protected in UK and EU law I doubt they

Re: [GNC-dev] GDPR and gnucash as a project

On 22/05/2018 18:14, Geert Janssens wrote: Op dinsdag 22 mei 2018 16:36:47 CEST schreef David T.: Geert, I am not fluent with the issues of the GDPR, but I have had a lifetime of considering intellectual property issues (as a librarian). Personal contributions of ideas, thoughts, or intellectua

Re: [GNC-dev] GDPR and gnucash as a project

On 22/05/2018 18:14, Geert Janssens wrote: Op dinsdag 22 mei 2018 16:36:47 CEST schreef David T.: Geert, I am not fluent with the issues of the GDPR, but I have had a lifetime of considering intellectual property issues (as a librarian). Personal contributions of ideas, thoughts, or intellectua

[GNC-dev] GnuCash Portable is no longer portable as of 3.x

GnuCash Portable https://portableapps.com/apps/office/gnucash_portable is no longer portable as of 3.x I have "reached out" [1] but I am not getting a reply from the person I think has the power to fix this. What I don't want is for GnuCash to pick up the shit when someone loses their work an

Re: [GNC-dev] GnuCash Portable is no longer portable as of 3.x

On 05/07/2018 08:24, Colin Law wrote: On 5 July 2018 at 06:05, Wm via gnucash-devel wrote: GnuCash Portable https://portableapps.com/apps/office/gnucash_portable is no longer portable as of 3.x I think it would be useful if you detailed the problem a little so others would not fall into the

Re: [GNC-dev] GnuCash Portable is no longer portable as of 3.x

On 08/07/2018 15:52, John Ralls wrote: Wm, Portable Apps is just another downstream distro. We have no ability to enforce anything against any distro. Either they maintain a usable GnuCash in their package manager or they don’t and there’s not a darn thing we can do about it unless they hav

Re: [GNC-dev] GnuCash Portable is no longer portable as of 3.x

On 09/07/2018 04:03, John Ralls wrote: Notice: Subject may be wrong at time of writing as I see there is a new PA version, I haven't tested it yet. On Jul 8, 2018, at 7:35 PM, Wm via gnucash-devel wrote: On 08/07/2018 15:52, John Ralls wrote: Wm, Portable Apps is just another downs

Re: [GNC-dev] [GNC] GnuCash 3.2 Released

On 11/07/2018 03:49, John Ralls wrote: On Jul 10, 2018, at 6:45 PM, Wm wrote: Aside: is there a reason why version changes aren't on (or easily found from) the front page of gnucash.org? they used to be there. David T. thought that it made the front page too busy and moved it to https

Re: [GNC-dev] GnuCash Portable is no longer portable as of 3.x

On 12/07/2018 01:14, John Ralls wrote: I wrote a lengthy reply and then pressed the wrong key Nothing you said suggests anything other than that Portable Apps is just another distro. The purposes of the distribution and the version tracking are immaterial. They make a big shake of asking p

Re: [GNC-dev] avoid the brain dead import

On 25/08/2018 07:22, David Cousens wrote: i thank David for his posting which i have read, I don't address all he said Keep trying. Tthe brain dead importer does get less brain dead with repeated use. i'm not sure it does get better as implemented because 2 of the bits of brain dead-ity are

Re: [GNC-dev] avoid the brain dead import

On 29/08/2018 23:52, David Cousens wrote: I think the decision about whether to import a small number of transactions by hand is really one for the user and not the importer to make. I would import small batches, maybe 20-30 to test the importer function and ensure it was working as expected be

Re: [GNC-dev] GnuCash 3.3 Released

On 01/10/2018 15:43, Christopher Lam wrote: No it's stalled because I cannot figure out equity unrealized/realized/trading gains at all. I have no reliable guidance to create equity section reliably. If the equity section is ignored, and only the asset/liability sections used, then the report co

Re: [GNC-dev] Drop link to 2.6 release tour, , The page itself still exists as older news items refer to it.

On 06/10/2018 01:07, John Ralls wrote: On Oct 5, 2018, at 3:51 PM, Frank H. Ellenberger wrote: Hi all That makes it slightly harder to check translations. For normal visitors are now only the 2.0 screenshots shown under Features. OK, I know the nonexistant GTK3 screenshots would look dif

[GNC-dev] hello, do people that know what they are talking about really get blocked

yeah, I know, some of you think Trump is a good guy. will you get over yourselves and try processing my posts. ffs ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] UK VAT - Making Tax Digital

On 01/11/2018 21:02, Michael or Penny Novack wrote: I'll leave it up to the UK folks to determine what the new requirement is. It is confusing and I don't think gnc folks in other parts of the world need to do anything. Plus the majority [1] apparently voted Brexit so it could all change.

Re: [GNC-dev] UK VAT - Making Tax Digital

On 01/11/2018 16:12, Clint Redwood wrote: Hi Folks, I’ve been using GNUcash to manage my company accounts for 10 years, but a change in the UK law means that all VAT will need to be submitted electronically from an accounting package from April 2019. That isn't actually true. Is anyone pla

Re: [GNC-dev] Wiki:Dependencies

On 28/10/2018 09:27, David T. via gnucash-devel wrote: Hello, The wiki page on dependencies (https://wiki.gnucash.org/wiki/Dependencies ) includes a table that covers dependencies up until version 2.4.0. Does anyone on the devel list have a more up-

Re: [GNC-dev] Wiki:Dependencies

On 28/10/2018 09:27, David T. via gnucash-devel wrote: Hello, The wiki page on dependencies (https://wiki.gnucash.org/wiki/Dependencies ) includes a table that covers dependencies up until version 2.4.0. Does anyone on the devel list have a more up-

Re: [GNC-dev] Convert Imap to Flat

On 05/11/2018 16:07, Robert Fewell wrote: Hi, I was poking around with the CSV importer and I noticed the following, this may also be an issue with other importers on first use after creating a new file... With a new empty xml file, I used a one line transaction csv file with appropriate settings

Re: [GNC-dev] Convert Imap to Flat

On 05/11/2018 17:50, Geert Janssens wrote: Like you though I suspect this may be at least one cause of the import issues we see. Thanks for poking at it! this is a basic issue, people aren't allowed to decide if their tx are new or not -- Wm ___

[GNC-dev] Currencies in Price Database UI gone weird in 3.4

I tried to get new exchange rates today for the first time since updating to 3.4. Tools / Price Database / Currencies was largely unpopulated. I looked in the file and the prices are there. I reverted to 3.3 and all looks well again. Would someone else that uses one or two currencies other

Re: [GNC-dev] Currencies in Price Database UI gone weird in 3.4

On 14/01/2019 08:04, Mike Alexander wrote: On Jan 13, 2019, at 7:44 AM, Wm via gnucash-devel wrote: I tried to get new exchange rates today for the first time since updating to 3.4. Tools / Price Database / Currencies was largely unpopulated. I looked in the file and the prices are there

[GNC-dev] Alphavantage strategies

I was unaware [1] until recently that Alphavantage wanted individuals / non-subscribers / poor people / whoever doesn't pay / to back off a bit. I don't have a problem with this, it is a good free service and it has been obvious they're struggling. [1] but not surprised to discover There hav

Re: [GNC-dev] Currencies in Price Database UI gone weird in 3.4

On 14/01/2019 15:14, John Ralls wrote: On Jan 14, 2019, at 12:04 AM, Mike Alexander wrote: On Jan 13, 2019, at 7:44 AM, Wm via gnucash-devel wrote: I tried to get new exchange rates today for the first time since updating to 3.4. Tools / Price Database / Currencies was largely

Re: [GNC-dev] Alphavantage strategies

On 16/01/2019 14:12, Derek Atkins wrote: Hi, Wm via gnucash-devel writes: [snip] Let's consider some simple backoff strategies that gnc could implement, feel free to add your own. Wm's suggestion === only collect if the most recent price is more than 1 day (or 12 hours

Re: [GNC-dev] Currencies in Price Database UI gone weird in 3.4

On 14/01/2019 15:38, Geert Janssens wrote: Op maandag 14 januari 2019 16:14:56 CET schreef John Ralls: I also noticed that it seems to be impossible to edit a transaction when the price editor is open. It is permanently in front of the register window and seems to steal all keyboard events.

Re: [GNC-dev] Alphavantage strategies

On 21/01/2019 20:10, Derek Atkins wrote: Wm via gnucash-devel writes: [snip] Wm's suggestion === only collect if the most recent price is more than 1 day (or 12 hours, etc) old [2]. this sort of fits in with the existing post collection [snip] Do you really miss the poi

Re: [GNC-dev] Alphavantage strategies

On 22/01/2019 15:16, John Ralls wrote: Wm, F::Q has had a commit to add 6 seconds between requests in its git repo for almost a year, but the maintainer hasn’t been able to make time to do a new release. This has been discussed several times on the user list. Naughty F::Q ... don't be silly

[GNC-dev] Normalizing live data, a suggestion for discussion

Situation: someone reports a problem with gnc, at triage it becomes clear some data is going to be required to identify or solve the problem. Normal question? Can you give us a file. Problem: for any number of reasons ranging from plain old personal privacy through to people that live in supp

Re: [GNC-dev] Pie Chart

On 27/01/2019 22:22, Stephen M. Butler wrote: But, you didn't ask me for that!  What, in particular, would you like me to review? you are giving way to much personal information ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.

Re: [GNC-dev] Pie Chart

On 31/01/2019 01:56, Stephen M. Butler wrote: Took me awhile to figure out how to drill down. Ummm, you appear to be less capable than the people trying to help you. To me this is a Trump supporter so obviously. If you follow the conversation, the idiot is Stephen, everyone is trying too hel

Re: [GNC-dev] Normalizing live data, a suggestion for discussion

On 01/02/2019 19:17, Stephen M. Butler wrote: Ummm, Stephen M. Butler I don't think you were my intended audience. Let me put you down gently. It might be better to have a standardized test file that folks could download, and run their scenario against. Nope, we can do that already, I was ad

Re: [GNC-dev] Normalizing live data, a suggestion for discussion

On 01/02/2019 13:36, Wm via gnucash-devel wrote: would someone other than idiot Stephen M Butler attempt a reply please TIA ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] End of 'X' date on 3.4-50 (maint)

On 30/01/2019 01:54, Stephen M. Butler wrote: I compiled origin/maint (gnucash 3.4-50) and noticed that the end of accounting period was at 12/31/2020 while the start of accounting period is at 1/1/2019. Checked: * Today:  1/29/2019 what the fuck do you expect if you are using american dates

Re: [GNC-dev] Normalizing live data, a suggestion for discussion

On 02/02/2019 00:16, David Cousens wrote: As well as the account names you might also want to munge data in the description/memo fields. This can contain identifying information for customers/vendors. How about we just zap the stuff in description/memo fields by default? They're not mathemat

Re: [GNC-dev] Pie Chart

On 01/02/2019 16:05, David Carlson wrote: Wm, you are at it again. We need to help your tiny brain. Liz! Help! the bad people are talking amongst themselves! FFS, grow up dullard. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://

Re: [GNC-dev] Pie Chart

On 29/01/2019 18:12, stephen.m.butler51 wrote: My first problem is figuring why my compile script stopped working.   I was out most of yesterday and out most of today. Yes, the first round didn't show any anomalies. Why the Trump do you think anyone is interested in your day to day movements

Re: [GNC-dev] Normalizing live data, a suggestion for discussion

On 02/02/2019 09:59, Colin Law wrote: Can all users save files as sqlite? Does that need anything extra installed on the OS side that may not be there? Also what about different builds of GC, do they all have sqlite? I'm fairly sure all of the official builds can save SQLite. If someone is

Re: [GNC-dev] Normalizing live data, a suggestion for discussion

On 02/02/2019 15:40, David Carlson wrote: Wouldn't it be simpler to create a library of template files designed to exercise various features that a user could find one to illustrate his concern? To some extent this is already done in the build process. Life always throws up something unexpect

Re: [GNC-dev] Normalizing live data, a suggestion for discussion

On 02/02/2019 16:11, Geert Janssens wrote: But I don't know how feasible it is to effectively obfuscate that data withoug resorting to a complex script The script will be seen by others that do understand sql before anyone innocent gets to use it, promise. If the script is well documented (I

Re: [GNC-dev] Normalizing live data

On 02/02/2019 13:31, Hendrik Boom wrote: On 2/1/19 5:36 AM, Wm via gnucash-devel wrote: [2] as long as the transaction stream balances the actual numbers don't matter (their will be occasions where the numbers are important but these tend to be number extremes related to commodities r

Re: [GNC-dev] Normalizing live data, a suggestion for discussion

On 02/02/2019 15:24, Geert Janssens wrote: Yes, if you use business features, you may have entered business identifying data in File->Properties. It think that's what David is referring to. I agree, the third party should not be identified. Similarly there may be customer and vendor data (na

[GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

Background: My gnc TB has been wrong for years. This hasn't been a problem for me because I can do my own TB in sql and satisfy myself all is relatively well with my accounts. Over the last week or so I decided to try again and I think the gnc TB report is b0rked. Looking at the bug list, I'

Re: [GNC-dev] Normalizing live data

On 02/02/2019 17:44, Hendrik Boom wrote: On Sat, Feb 02, 2019 at 04:30:30PM +0100, Geert Janssens wrote: Op zaterdag 2 februari 2019 14:31:43 CET schreef Hendrik Boom: On 2/1/19 5:36 AM, Wm via gnucash-devel wrote: [2] as long as the transaction stream balances the actual numbers don't m

Re: [GNC-dev] Normalizing live data

On 02/02/2019 18:00, John Ralls wrote: So maybe we should just forget it and continue the practice of asking users to send their account files directly to a developer with the promise of confidentiality if they're unable to reproduce the bug in a test file. That's what I'm thinking. No one

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

On 09/02/2019 07:00, Wm via gnucash-devel wrote: Background: My gnc TB has been wrong for years.  This hasn't been a problem for me because I can do my own TB in sql and satisfy myself all is relatively well with my accounts.  Over the last week or so I decided to try again and I think th

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

On 09/02/2019 07:00, Wm via gnucash-devel wrote: Background: My gnc TB has been wrong for years.  This hasn't been a problem for me because I can do my own TB in sql and satisfy myself all is relatively well with my accounts.  Over the last week or so I decided to try again and I think th

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

On 10/02/2019 09:14, Geert Janssens wrote: Op zondag 10 februari 2019 09:56:51 CET schreef Adrien Monteleone: I’m in agreement on that note. I understand why someone who doesn’t close books would like a report that shows a current position. But the Trial Balance report is really only useful for

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

On 10/02/2019 16:54, John Ralls wrote: The "Average Cost" price source creates a price based on the actual transaction prices and is designed for the TB report, see the thread beginning with https://lists.gnucash.org/pipermail/gnucash-devel/2008-July/023297.html. I broke it for 2.6.13-2.6.21,

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

On 10/02/2019 12:40, David Carlson wrote: Lets all step back a second and consider what the report is supposed to show before deciding whether it is always correct. I think the report is conceptually broken. The report is supposed to cover all of the assets and liabilities that were selected

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

On 10/02/2019 19:46, Alex Aycinena wrote: It is possible that Wm is noting a problem in gnucash that I'm trying to address with my 'Book Currency' enhancement (unfortunately, a bit delayed). I am certainly interested. I went to the end of your message and read that just in case you thought B

Re: [GNC-dev] Further feedback

On 09/02/2019 03:46, John Ralls wrote: On Feb 8, 2019, at 5:52 PM, Christopher Lam wrote: On 9/2/19 7:49 am, Stephen M. Butler wrote: On 2/8/19 5:12 AM, Christopher Lam wrote: I've been experimenting and I think there's a logic error in your thinking -- *during* reconciliation, until it's

Re: [GNC-dev] Further feedback

On 09/02/2019 04:05, Christopher Lam wrote: Well I've been schooled. Please refresh and try again. The headers should match the desired report *post* reconciliation. The transactions reported are: uncleared, cleared, and reconciliation whereby split-reconciliation-date = account's last-reconc

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

On 10/02/2019 22:52, David Carlson wrote: Wm, Where does unrealized income fall into tb if there is no price in the database on the closing date for one or more security or currency accounts because it was not sold? Essentially it doesn't occur, it is just a number of something if you aren't

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

On 09/02/2019 13:03, D via gnucash-devel wrote: That sounds to me like it's using a different exchange rate from one day to another, and I'd agree with your assessment in that case. I would have thought that the exchange rate in the transaction would be used. You are correct. I have an amoun

Re: [GNC-dev] Normalizing live data, a suggestion for discussion

On 03/02/2019 02:01, David Cousens wrote: As Geert pointed out whole of program testing is very difficult and rapidly reaches a situation where complexity is equal to or greater than the program complexity and this is really what gave rise to unit testing where you test individual components wh

Re: [GNC-dev] Normalizing live data, a suggestion for discussion

On 03/02/2019 16:03, John Ralls wrote: On Feb 2, 2019, at 8:10 PM, David Carlson wrote: OK, I want to try https://wiki.gnucash.org/wiki/ObfuscateScript but I am not a computer programmer. I have no clue how to use it. Can someone help me? Run it from a command line using perl, assuming h

Re: [GNC-dev] Normalizing/obfuscating live data

On 04/02/2019 08:40, Christian Stimming wrote: In a real data file there are still more places with text that need to be modified, e.g. the scheduled transaction templates, bayes import matching, and such. Also, the dates are left unmodified which may or may not be a problem. Stripping out sche

Re: [GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

On 11/02/2019 04:03, David Carlson wrote: Wm, before you run off at the mouth with all your innuendos, look at facts. I'm hoping you get a message from Liz If you don't there is something rotten in this list's administration. Did you try running a test on one of your backups from around Jun

  1   2   >