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

2019-02-23 Thread Wm via gnucash-devel
On 02/02/2019 23:05, David Cousens wrote: I don't since I retired a few years ago, but I did for 8 years prior to retiring (and I used MYOB for the 10 years prior to that before escaping). I am certainly not alone. You could have a proviso that the script won't work for files using the business

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

2019-02-23 Thread Wm via gnucash-devel
On 03/02/2019 04:10, 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? it is perl, if you have F::Q working you probably have enough kit to run it. -- Wm

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

2019-02-11 Thread Wm via gnucash-devel
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

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

2019-02-11 Thread Wm via gnucash-devel
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

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

2019-02-04 Thread Geert Janssens
Op zaterdag 2 februari 2019 22:36:18 CET schreef Wm via gnucash-devel: > On 02/02/2019 15:24, Geert Janssens wrote: > > As for Colin's question: on Windows and MacOS sqlite is supported out of > > the box. On linux it may require the additional installation of a libdbi > > driver. Most distros I

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

2019-02-04 Thread Geert Janssens
Op zaterdag 2 februari 2019 22:36:18 CET schreef Wm via gnucash-devel: > 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

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

2019-02-03 Thread John Ralls
> 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 here that you have Strawberry

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

2019-02-02 Thread David Carlson
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? David C > > ___ gnucash-devel mailing list gnucash-devel@gnucash.org

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

2019-02-02 Thread David Cousens
Steve, 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 which do a specific function. One

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

2019-02-02 Thread Frank H. Ellenberger
Hello Wm Am 01.02.19 um 14:36 schrieb Wm via gnucash-devel: > > My suggestion is we ask people to save a *copy* of their data in SQLite > and they then run a script across that copy that munges and obfuscates > Did you see https://wiki.gnucash.org/wiki/ObfuscateScript ? It is targeting xml

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

2019-02-02 Thread David Cousens
Wm, >> It doesn't end there, payments can be split over multiple invoices, so >> again >> when one randomizes invoice amounts care must be taken to adjust the >> payments >> in proportion to the invoice amount change or fully paid invoices >> suddenly can >> become partially paid or overpaid.

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

2019-02-02 Thread Wm via gnucash-devel
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

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

2019-02-02 Thread Wm via gnucash-devel
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

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

2019-02-02 Thread Wm via gnucash-devel
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

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

2019-02-02 Thread Wm via gnucash-devel
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

2019-02-02 Thread Geert Janssens
Op zaterdag 2 februari 2019 16:40:34 CET schreef David Carlson: > 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? > > Thiswould bypass the need to figure out how to sanitize every possible

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

2019-02-02 Thread David Carlson
On Sat, Feb 2, 2019, 9:25 AM Geert Janssens Op zaterdag 2 februari 2019 10:19:02 CET schreef Wm via gnucash-devel: > > 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

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

2019-02-02 Thread Geert Janssens
Op zaterdag 2 februari 2019 10:19:02 CET schreef Wm via gnucash-devel: > 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

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

2019-02-02 Thread Colin Law
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?Colin Colin ___ gnucash-devel mailing list gnucash-devel@gnucash.org

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

2019-02-02 Thread Wm via gnucash-devel
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

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

2019-02-01 Thread David Cousens
Wm 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. Also possible any data relating to the owner of the file which is stored in the file/database. The combination of the above would

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

2019-02-01 Thread Wm via gnucash-devel
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] Normalizing live data, a suggestion for discussion

2019-02-01 Thread Wm via gnucash-devel
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

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

2019-02-01 Thread Stephen M. Butler
On 2/1/19 5:36 AM, Wm via gnucash-devel wrote: > 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

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

2019-02-01 Thread Wm via gnucash-devel
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