Re: gbonds

2000-12-12 Thread Dave Peticolas
Jim Evins writes: > Hello, > I am the author of a program called gbonds, which may be of interest > to the gnucash developers. It is a small savings bond inventory program for > GNOME. More information can be found at > > http://snaught.com/gbonds/ > > Would there be any interest i

RE: File store (was Re: Salutations)

2000-12-12 Thread Phillip Shelton
Would not be surprised if there were even some conflicts in the "set" > -Original Message- > > That means sitting in the somewhat uncomfortable seat named "No, we're > not assuming that there is a Single Fixed Set of Accounting > Doctrines." > [Which, if you see the size of wall covered

Re: File store (was Re: Salutations)

2000-12-12 Thread Christopher Browne
On Tue, 12 Dec 2000 12:49:22 EST, the world broke into rejoicing as David Merrill <[EMAIL PROTECTED]> said: > On Tue, Dec 12, 2000 at 12:35:45PM -0500, Derek Atkins wrote: > > David Merrill <[EMAIL PROTECTED]> writes: > > > > [snip] > > > > > But I do take issue with the argument that period cl

RE: Balance Checkpoints

2000-12-12 Thread Phillip Shelton
Ok. So our example of 1000's of transactions in a day is unrealistic. However, just because it is unrealistic does not mean it does not have a bearing on the present problem. I will try to recast what I can see as a realistic concern. When can we consider that all of today's, this weeks, this m

Re: Balance Checkpoints

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 09:22:44PM -0600, Christopher Browne wrote: > On Tue, 12 Dec 2000 15:22:15 EST, the world broke into rejoicing as > Consider two cases: [snipped all over] > a) Someone who generates an average of ten transactions per month. >120 transactions; 12 checkpoints; no perfor

Lack of Transaction List

2000-12-12 Thread Christopher Browne
On Wed, 13 Dec 2000 10:20:07 +1000, the world broke into rejoicing as "Phillip Shelton" <[EMAIL PROTECTED]> said: > > > Transactions aren't entered in the ledger. In fact, > > > there's no global > > > way to get a list of transactions at all. > > First, an apology for airing just how much I do

Balance Checkpoints

2000-12-12 Thread Christopher Browne
On Tue, 12 Dec 2000 15:22:15 EST, the world broke into rejoicing as David Merrill <[EMAIL PROTECTED]> said: > On Wed, Dec 13, 2000 at 06:08:46AM +1000, Phillip J Shelton wrote: > > Derek Atkins wrote: > > > David Merrill <[EMAIL PROTECTED]> writes: > > > > aisb, I consider the issue of closing th

Re: Schema

2000-12-12 Thread David Merrill
On Wed, Dec 13, 2000 at 01:41:41AM +, Al Snell wrote: > On Tue, 12 Dec 2000, Dave Peticolas wrote: > > > Yes, if possible, we should store numbers as 64-bit ints. It is also > > possible that in the db we can just dispense with the denominators > > in splits all together. This is something we

Re: Thoughts about the stock quote database

2000-12-12 Thread Steven Rutter
A few months back I wrote a perl/gtk program called GtkPortfolio [can be found on freshmeat]. It will automatically update quotes for multiple portfolios, view news, charts and allows you to set price alerts. I released it on freshmeat under the Artistic License because I though others might find

Re: Thoughts about the stock quote database

2000-12-12 Thread Dave Peticolas
=?iso-8859-1?Q?Tor-=D8yvind_Gundersen?= writes: > > I don't think I can stop using GnuCash after getting the taste of it. Good > work, guys :) On behalf of everyone, thanks! > I recently joined the gnucash-devel list, so I haven't even had the time to > lurk around a lot, but I've browsed thro

gbonds

2000-12-12 Thread Jim Evins
Hello, I am the author of a program called gbonds, which may be of interest to the gnucash developers. It is a small savings bond inventory program for GNOME. More information can be found at http://snaught.com/gbonds/ Would there be any interest in this functionality in gnucas

Re: Schema

2000-12-12 Thread Al Snell
On Tue, 12 Dec 2000, Dave Peticolas wrote: > Yes, if possible, we should store numbers as 64-bit ints. It is also > possible that in the db we can just dispense with the denominators > in splits all together. This is something we need to design carefully, > as some engine assumptions may need to

Re: Schema

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 04:27:21PM -0800, Dave Peticolas wrote: > "Phillip Shelton" writes: > > In the db, I would imagine that the transactions will almost certainly > have their own table, so there will be an 'explicit' list of them. That's the plan, yes. -- Dr. David C. Merrill

Re: Schema

2000-12-12 Thread Dave Peticolas
"Phillip Shelton" writes: > > > > -Original Message- > > > > > cleared_balance money " > > > > > reconciled_balance money " > > > > > share_balance money " > > > > > share_cleared_balance money

RE: Schema

2000-12-12 Thread Phillip Shelton
> -Original Message- > > > > cleared_balance money " > > > > reconciled_balance money " > > > > share_balance money " > > > > share_cleared_balance money " > > > > share_reconciled_balance

RE: Schema

2000-12-12 Thread Phillip Shelton
How about Security for the damount and currency for the value as that is what we are using them for, at least for stocks. Do the people working on the inventory have any suggestions? > -Original Message- > David Merrill writes: > > On Tue, Dec 12, 2000 at 04:06:48PM -0600, Bill Gribble w

RE: Schema

2000-12-12 Thread Phillip Shelton
> -Original Message- > > Um, could you explain GUIDs? I am lost. > > Globally Unique ID, also known as UUID or Universal Unique ID. It is a > 32 byte value usually calculated using the machine's MAC address and > the time, plus some random stuff, plus more stuff I don't understand. > It

Re: Schema

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 03:02:15PM -0600, Bill Gribble wrote: > On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote: > > It is the smallest amount that this account can change by. GnuCash is > > now using a variation on rational numbers which have a numerator, the > > value, and a d

Re: Schema

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 02:33:55PM -0800, Dave Peticolas wrote: > David Merrill writes: > > On Tue, Dec 12, 2000 at 04:06:48PM -0600, Bill Gribble wrote: > > > On Tue, Dec 12, 2000 at 04:53:51PM -0500, David Merrill wrote: > > > > iow, what is a "suitable rational representation"? > > > > > > A g

Re: Schema

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 02:09:17PM -0800, Dave Peticolas wrote: > David Merrill writes: > > On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote: > > > David Merrill wrote: > > > > > > > I'm beginning to work on the database schema for an eventual SQL back > > > > end. I am keeping m

Re: Schema

2000-12-12 Thread Dave Peticolas
David Merrill writes: > On Tue, Dec 12, 2000 at 04:06:48PM -0600, Bill Gribble wrote: > > On Tue, Dec 12, 2000 at 04:53:51PM -0500, David Merrill wrote: > > > iow, what is a "suitable rational representation"? > > > > A gnc_numeric data structure; 64 bit int for each of numerator and > > denomina

Re: Schema

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 04:06:48PM -0600, Bill Gribble wrote: > On Tue, Dec 12, 2000 at 04:53:51PM -0500, David Merrill wrote: > > iow, what is a "suitable rational representation"? > > A gnc_numeric data structure; 64 bit int for each of numerator and > denominator. > > > Why "d"amount? > > Fi

Re: Schema

2000-12-12 Thread Dave Peticolas
David Merrill writes: > > So, valid values would include 2/3? And how would this be stored, by > the approximation 0.666? Or as the actual text value "2/3"? You > said that *each* of damount and value is a rational number, right? > iow, what is a "suitable rational representation"? > > Why "

Re: Schema

2000-12-12 Thread Dave Peticolas
David Merrill writes: > On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote: > > David Merrill wrote: > > > > > I'm beginning to work on the database schema for an eventual SQL back > > > end. I am keeping my notes in an ASCII file, which will always be > > > available at http://www

Re: Schema

2000-12-12 Thread Bill Gribble
On Tue, Dec 12, 2000 at 04:53:51PM -0500, David Merrill wrote: > iow, what is a "suitable rational representation"? A gnc_numeric data structure; 64 bit int for each of numerator and denominator. > Why "d"amount? Figuring that out is archaeology at this point :) > What is the difference betwee

Re: Schema

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 03:02:15PM -0600, Bill Gribble wrote: > On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote: > > It is the smallest amount that this account can change by. GnuCash is > > now using a variation on rational numbers which have a numerator, the > > value, and a d

Re: Schema

2000-12-12 Thread David Merrill
On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote: > David Merrill wrote: > > > I'm beginning to work on the database schema for an eventual SQL back > > end. I am keeping my notes in an ASCII file, which will always be > > available at http://www.lupercalia.net/schema.txt > > so

Re: Schema

2000-12-12 Thread Bill Gribble
On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote: > It is the smallest amount that this account can change by. GnuCash is > now using a variation on rational numbers which have a numerator, the > value, and a denominator, the damont. This isn't right. Each of 'value' and 'damou

Re: Schema

2000-12-12 Thread Phillip J Shelton
David Merrill wrote: > I'm beginning to work on the database schema for an eventual SQL back > end. I am keeping my notes in an ASCII file, which will always be > available at http://www.lupercalia.net/schema.txt some comments and suggestions. > SPLIT > - > account_guidc

Re: File store (was Re: Salutations)

2000-12-12 Thread David Merrill
On Wed, Dec 13, 2000 at 06:18:30AM +1000, Phillip J Shelton wrote: > David Merrill wrote: > > > Question: What if you really *need* to go back and correct data in the > > prior year? > > If the change is to the money amount then the book I own says that you make a > transaction dated at the time

Re: File store (was Re: Salutations)

2000-12-12 Thread David Merrill
On Wed, Dec 13, 2000 at 06:08:46AM +1000, Phillip J Shelton wrote: > Derek Atkins wrote: > > > David Merrill <[EMAIL PROTECTED]> writes: > > > > > aisb, I consider the issue of closing the books and making all > > > transactions prior to that immutable to be completely orthogonal to how > > > the

Re: File store (was Re: Salutations)

2000-12-12 Thread Phillip J Shelton
David Merrill wrote: > Question: What if you really *need* to go back and correct data in the > prior year? If the change is to the money amount then the book I own says that you make a transaction dated at the time you find the error that undoes the wrong data and then enter another transaction

Re: File store (was Re: Salutations)

2000-12-12 Thread Phillip J Shelton
Derek Atkins wrote: > David Merrill <[EMAIL PROTECTED]> writes: > > > aisb, I consider the issue of closing the books and making all > > transactions prior to that immutable to be completely orthogonal to how > > the running total is determined. I am proposing a solution to the > > maintenance of

Re: File store (was Re: Salutations)

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 01:09:22PM -0500, Derek Atkins wrote: > David Merrill <[EMAIL PROTECTED]> writes: > > > aisb, I consider the issue of closing the books and making all > > transactions prior to that immutable to be completely orthogonal to how > > the running total is determined. I am prop

Re: File store (was Re: Salutations)

2000-12-12 Thread Steve Greenland
On 12-Dec-00, 11:35 (CST), Derek Atkins <[EMAIL PROTECTED]> wrote: > Unfortunately I'm not convinced it completely solves the problem. The > problem with any checkpointing is that if any transaction changes > before the checkpoint, then you have to modify all checkpoints that > have occurred aft

Re: File store (was Re: Salutations)

2000-12-12 Thread Derek Atkins
David Merrill <[EMAIL PROTECTED]> writes: > aisb, I consider the issue of closing the books and making all > transactions prior to that immutable to be completely orthogonal to how > the running total is determined. I am proposing a solution to the > maintenance of running balances that scales we

Schema

2000-12-12 Thread David Merrill
I'm beginning to work on the database schema for an eventual SQL back end. I am keeping my notes in an ASCII file, which will always be available at http://www.lupercalia.net/schema.txt You can view this document at any time to see my progress. Right now it is extremely sparse but will grow as I

Re: File store (was Re: Salutations)

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 12:35:45PM -0500, Derek Atkins wrote: > David Merrill <[EMAIL PROTECTED]> writes: > > [snip] > > > But I do take issue with the argument that period closing, and the > > transfer of the account balance, is the way to accomplish this. It is > > certainly one way, but there

Re: File store (was Re: Salutations)

2000-12-12 Thread Derek Atkins
David Merrill <[EMAIL PROTECTED]> writes: [snip] > But I do take issue with the argument that period closing, and the > transfer of the account balance, is the way to accomplish this. It is > certainly one way, but there are others. Let me propose one other way > for your consideration. > > Let

Re: File store (was Re: Salutations)

2000-12-12 Thread David Merrill
On Tue, Dec 12, 2000 at 05:16:19AM +, Al Snell wrote: > On Mon, 11 Dec 2000, David Merrill wrote: > > > So that means you would retrieve the current balance, and then work > > *backwards* from there to calculate running balances in the ledger? > > That sounds like it would work with small dat

Thoughts about the stock quote database

2000-12-12 Thread Tor-Øyvind Gundersen
I don't think I can stop using GnuCash after getting the taste of it. Good work, guys :) I recently joined the gnucash-devel list, so I haven't even had the time to lurk around a lot, but I've browsed through the recent entries in the archive. There I read about the ongoing process of separating