> On Aug 21, 2022, at 11:22 AM, Michael or Penny Novack
> wrote:
>
> On 8/21/2022 11:42 AM, john wrote:
>>
>>
>>> On Aug 21, 2022, at 7:51 AM, Michael or Penny Novack
>>> wrote:
>>>
>>> I do not understand what you could mean by going back and forth from
>>> Quickbools to gnucash (or an
On 8/21/2022 11:42 AM, john wrote:
On Aug 21, 2022, at 7:51 AM, Michael or Penny Novack
wrote:
I do not understand what you could mean by going back and forth from
Quickbools to gnucash (or any other double entry bookkeeping
software) as Quickbooks is not double entry.
Michael, you're c
> On Aug 21, 2022, at 7:51 AM, Michael or Penny Novack
> wrote:
>
> I do not understand what you could mean by going back and forth from
> Quickbools to gnucash (or any other double entry bookkeeping software) as
> Quickbooks is not double entry.
Michael, you're confusing Quicken that isn'
On 8/20/2022 3:06 PM, Scott Morgan wrote:
Hi John,
Well, I did some work building an open source Java Accounting Model (
adligo.org) a few times of the past two decades. Now I find my self using
QuickBooks online, so I have been looking for some collaborators and
gnucash seems like the most
ould start looking at the model you all were using inside
of GnuCash.
On Sat, Aug 20, 2022 at 11:51 AM john wrote:
> The SQL Schema is laid out in https://wiki.gnucash.org/wiki/SQL. There's
> an attached ERD, but note that it shows secondary keys and auxiliary tables
> that indicate how
igured I would start looking at the model you all were using inside
> of GnuCash.
>
> On Sat, Aug 20, 2022 at 11:51 AM john <mailto:jra...@ceridwen.us>> wrote:
>> The SQL Schema is laid out in https://wiki.gnucash.org/wiki/SQL. There's an
>> attached ERD, but
The SQL Schema is laid out in https://wiki.gnucash.org/wiki/SQL. There's an
attached ERD, but note that it shows secondary keys and auxiliary tables that
indicate how GnuCash treats the data once it's loaded. The actual schema
defines only a few secondary keys and the data represen
Hi All,
Is the Data Model, / DB Schema stored somewhere with enriched metadata?
If not I would like to volunteer to do this work, in part because I'm
probably going to create a sibling Java project at some point to share the
schema / data model.
Cheers,
Scott
On Wed, Aug 17, 2022 at 11:
"Frank H. Ellenberger" writes:
> Am 15.08.2018 um 17:16 schrieb Derek Atkins:
>> I think it's safe to remove it; the old text will remain in the page
>> history.
>
> Because some pages have several pages of history, do you know similar
> command like git blame for mediawiki?
I do not. That does
Am 15.08.2018 um 17:16 schrieb Derek Atkins:
> I think it's safe to remove it; the old text will remain in the page
> history.
Because some pages have several pages of history, do you know similar
command like git blame for mediawiki?
~Frank
pEpkey.asc
Description: application/pgp-keys
Op woensdag 15 augustus 2018 17:16:04 CEST schreef Derek Atkins:
> David,
>
> "David T." writes:
> > Ah! Thank you! I have updated the links.
> >
> > On a more substantial note: I see that this page makes significant
> > reference to changes in XML implementation from version 1.9
> > forward. An
David,
"David T." writes:
> Ah! Thank you! I have updated the links.
>
> On a more substantial note: I see that this page makes significant
> reference to changes in XML implementation from version 1.9
> forward. An examination of the page history shows that most of the
> content was developed i
ormat
>> <http://wiki.gnucash.org/wiki/GnuCash_XML_format>, and found a reference to
>> "a non-normative RELAX NG schema for the XML file format (gnucash-v2.rnc).”
>> Unfortunately, the link
>> (https://github.com/Gnucash/gnucash/blob/master/src/doc/xml/gnucash-v
XML_format
<http://wiki.gnucash.org/wiki/GnuCash_XML_format>, and found a reference to
"a non-normative RELAX NG schema for the XML file format (gnucash-v2.rnc).”
Unfortunately, the link
(https://github.com/Gnucash/gnucash/blob/master/src/doc/xml/gnucash-v2.rnc
<https://github.
Hello,
In preparation for writing up data storage information to address Bug 777893, I
consulted the Wiki at wiki.gnucash.org/wiki/GnuCash_XML_format
<http://wiki.gnucash.org/wiki/GnuCash_XML_format>, and found a reference to "a
non-normative RELAX NG schema for the XML file format
On Wednesday 11 December 2013 09:01:43 Geert Janssens wrote:
> Hi Mike,
>
> This is a bug in the current trunk I still have to fix [1].
>
And just for your information, this bug has been fixed in the mean
time.
Geert
>
> [1] https://bugzilla.gnome.org/show_bug.cgi?id=720235
>
t/gnucash-devel/bin/gnucash-env python test
> * 21:09:52 OTHER Settings schema 'org.gnucash.general' is
> not installed
> [1]32166 trace trap (core dumped)
> /opt/gnucash-devel/bin/gnucash-env python test
>
> I don't know anything about GConf or GSetings bu
latex-docs --enable-python
I created this script:
#!/usr/bin/env python
import gnucash
session = gnucash.Session()
And I get this output:
% /opt/gnucash-devel/bin/gnucash-env python test
* 21:09:52 OTHER Settings schema 'org.gnucash.general' is
not installed
[1]32166 trace tr
From: Florian Haas
---
src/gnome/schemas/apps_gnucash_general.schemas.in | 18 ++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/gnome/schemas/apps_gnucash_general.schemas.in
b/src/gnome/schemas/apps_gnucash_general.schemas.in
index 758b0b1..a78b73b 100644
--On January 11, 2011 3:39:54 PM -0500 Christian Stimming
wrote:
Author: cstim
Date: 2011-01-11 15:39:53 -0500 (Tue, 11 Jan 2011)
New Revision: 20065
Trac: http://svn.gnucash.org/trac/changeset/20065
Modified:
gnucash/trunk/src/gnome-utils/schemas/Makefile.am
Log:
Bug #638615: Fix schema
les/xml2/ms-money.gml2
> gnucash/trunk/src/backend/xml/test/test-files/xml2/pricedb1.gml2 Log:
> Updated test files complying with the xml schema as of 2011-11-02
>
Wow, John, I knew you had some talents, but I wasn't aware of your visionary
capabilities ! You already know what the x
Baptiste Debrabant writes:
> Is there a place where I can get some doc on the db schema so I can
> convert the data myself?
The source code is the only documentation.
Note that this is why the readme, announcements, websites, etc all had
big disclaimers that YOU SHOULD NOT BE USIN
On 07/06/10 21:22, Klaus Dahlke wrote:
> On Mon, 07 Jun 2010 19:25:27 +0100
> Baptiste Debrabant wrote:
>
>
>> Is there a place where I can get some doc on the db schema so I can
>> convert the data myself?
>>
>>
>>
> Hi Baptiste,
> in one
On Mon, 07 Jun 2010 19:25:27 +0100
Baptiste Debrabant wrote:
>
> Is there a place where I can get some doc on the db schema so I can
> convert the data myself?
>
>
Hi Baptiste,
in one or the other case when working with gnucash-2.3.x it worked for me to
save the data as xml
Is there a place where I can get some doc on the db schema so I can
convert the data myself?
On 07/06/2010 15:39, Derek Atkins wrote:
Hi,
Geert Janssens writes:
On Saturday 5 June 2010, bdebrabant wrote:
Hi,
I am currently running gnucash 2.3.1 with postgresql backend.
When
s.
>> When launching gnucash after the upgrade, it recreated the db schema,
>> dumping the existing one (which I had to restore from backup).
>>
>> One thing I've tried was to dump the data into an xml file. It failed,
>> due apparently to the amount of data.
On Saturday 5 June 2010, bdebrabant wrote:
> Hi,
>
> I am currently running gnucash 2.3.1 with postgresql backend.
> When recently trying to upgrade to the latest release, I've faced a few
> issues related to the db changes.
> When launching gnucash after the upgrade, it
Hi,
I am currently running gnucash 2.3.1 with postgresql backend.
When recently trying to upgrade to the latest release, I've faced a few
issues related to the db changes.
When launching gnucash after the upgrade, it recreated the db schema,
dumping the existing one (which I had to restore
2009/9/25 Christian Stimming :
> Am Freitag, 25. September 2009 17:26 schrieb Colin Law:
>> I have worked out how to add a new checkbox to the general/register
>> settings and have the value saved in gconf. Do I need to manually
>> edit the schema f
Am Freitag, 25. September 2009 17:26 schrieb Colin Law:
> I have worked out how to add a new checkbox to the general/register
> settings and have the value saved in gconf. Do I need to manually
> edit the schema file src/gnome/schemas/apps_gnucash_general.schemas.in
> to provide the
I have worked out how to add a new checkbox to the general/register
settings and have the value saved in gconf. Do I need to manually
edit the schema file src/gnome/schemas/apps_gnucash_general.schemas.in
to provide the description etc or is there some other mechanism?
Colin L
Phil Longstaff writes:
>> Thanks. :)
>>
>> I'll start working on my implementation in the next days then.
>> The accounts-Table has a field "non_std_scu".
>> I guess a std-scu would be the one of the associated currency
>> but does it not violate the first normal form to save this
>> in an extra
On June 30, 2009 04:33:27 am marcus.wolsc...@googlemail.com wrote:
> On Mon, 29 Jun 2009 21:30:56 -0400, Phil Longstaff
>
> wrote:
> > Here's a first cut at the database schema. It only covers the main
>
> tables
>
> > and
> > types (not business table
On Mon, 29 Jun 2009 21:30:56 -0400, Phil Longstaff
wrote:
> Here's a first cut at the database schema. It only covers the main
tables
> and
> types (not business tables). I will put this information into the header
> files
> so that it gets put into the doxygen deve
>>> Hello,
> >>>
> >>> is there some documentation on the database-schema
> >>> Gnucash 2.3 introduces, the foreign keys used, if
> >>> transactions are used, where future extensions are
> >>> supposed to be added,...?
> >
On Wed, 20 May 2009 15:30:59 +0200, wrote:
> On Wed, 20 May 2009 08:25:26 -0400, Phil Longstaff
> wrote:
>> On May 20, 2009 04:32:50 am marcus.wolsc...@googlemail.com wrote:
>>> Hello,
>>>
>>> is there some documentation on the database-schema
>>&g
On Wed, 20 May 2009 08:25:26 -0400, Phil Longstaff
wrote:
> On May 20, 2009 04:32:50 am marcus.wolsc...@googlemail.com wrote:
>> Hello,
>>
>> is there some documentation on the database-schema
>> Gnucash 2.3 introduces, the foreign keys used, if
>> transactions
On May 20, 2009 04:32:50 am marcus.wolsc...@googlemail.com wrote:
> Hello,
>
> is there some documentation on the database-schema
> Gnucash 2.3 introduces, the foreign keys used, if
> transactions are used, where future extensions are
> supposed to be added,...?
> I'd li
Hello,
is there some documentation on the database-schema
Gnucash 2.3 introduces, the foreign keys used, if
transactions are used, where future extensions are
supposed to be added,...?
I'd like to give it a close look to see how much
I need to change any of my existing database-backe
On Sat, 2006-03-04 at 08:16 -0500, Josh Sled wrote:
> David, I'm a bit unclear on how this should work, but I'm hoping we can
> find a solution before 1.9.2. With respect to the schema installation
> done in the Makefiles, it seems like we should make the gconftool-2
>
David, I'm a bit unclear on how this should work, but I'm hoping we can
find a solution before 1.9.2. With respect to the schema installation
done in the Makefiles, it seems like we should make the gconftool-2
calls conditional on GCONF_DISABLE_MAKEFILE_SCHEMA_INSTALL, and insteadd
ca
racked them down yet.
Which DTD? If it's one(s) from the gnucash source tree, it's likely
out of date and unmaintained. Chris's message was regarding
validating the datafile using the schema at
http://svn.gnucash.org/trac/browser/gnucash/trunk/src/doc/xml/gnucash
-v2.rnc . If you pr
h source tree, it's likely out
of date and unmaintained. Chris's message was regarding validating the
datafile using the schema at
http://svn.gnucash.org/trac/browser/gnucash/trunk/src/doc/xml/gnucash-v2.rnc .
If you prefer XSD, trang [1] can be used to convert; I might eventually
s
--On February 4, 2006 11:34:46 PM -0500 Chris Shoemaker
<[EMAIL PROTECTED]> wrote:
On Sat, Feb 04, 2006 at 06:56:57PM -0500, Joshua Sled wrote:
FYI,
nXML shows the following for my datafile:
"Unknown element"
"Element not allowed in this context"
"Unknown element"
hbci
fied:
>gnucash/trunk/ChangeLog
>gnucash/trunk/src/backend/file/io-gncxml-v2.c
> Log:
> Emit all used namespaces; add XML datafile schema.
FYI,
nXML shows the following for my datafile:
"Unknown element"
"Element not allowed in this context"
"Un
Hi all (and particularly David -- sorry),
the file
./gnome/schemas/apps_gnucash_warnings.schemas
contains several user-visible strings. However, these strings 1. do not make
it into the po/gnucash.pot file and if they were in there 2. they are not yet
translated.
How do we get them into g
On Thu, 2005-10-13 at 16:29 -0500, Larry Evans wrote:
> Anyone have any better ideas on how to communicate
> between Gnumeric and GnuCash?
http://gnomesupport.org/wiki/index.php/GnuCashFrequentlyAskedQuestions#Q:_How_can_I_export_data.3F
http://gnomesupport.org/wiki/index.php/GnuCashFrequentlyAske
On 10/13/2005 01:25 PM, Neil Williams wrote:
[snip]
Full details of QSF are here (including a Schema):
http://code.neil.williamsleesmill.me.uk/qsf.html
Very interesting. The page:
http://code.neil.williamsleesmill.me.uk/map.html
contains:
qsf-map is an XML format used to map a series
Quoting Phil Longstaff <[EMAIL PROTECTED]>:
--- Neil Williams <[EMAIL PROTECTED]> wrote:
Not for the current file backend, it is also slated
for replacement. XML
is not an ideal choice of long term storage of
important data.
The Massachusetts state government might not agree
with you.
Let m
--- Neil Williams <[EMAIL PROTECTED]> wrote:
> Not for the current file backend, it is also slated
> for replacement. XML
> is not an ideal choice of long term storage of
> important data.
The Massachusetts state government might not agree
with you.
Phil
__
also allows you to deal
with data from non-file data sources like sql etc.
| Is there any interest in developing such a schema?
Not for the current file backend, it is also slated for replacement. XML
is not an ideal choice of long term storage of important data.
Full details of QSF are here
st in developing such a schema?
I did notice some schema discusssions back in
2000:
<- cut here
From: Richard Wackerbarth <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.gnome.apps.gnucash.devel
Subject: Re: Schema
Date: Tue, 26 Dec 2000 07:00:25 -0600
>-- cut here
On Thu, 2005-10-13 at 12:48 -0500, Larry Evans wrote:
> Is there any interest in developing such a schema?
It would take, practically, a total re-write of the XML backend to
actively use the schema in parsing or generation. The code right now
isn't in flux, so there's little need
>So the denominator goes: smallest divisible unit. (amount atoms?)
>And the numerator: number of smallest divisible units
>
>or in sentence form:
> The denominator represents the divisor for the smallest countable
>unit of this currency/asset. For
>example in the United States, it is 100 for $0
On Sun, Dec 17, 2000 at 05:04:49PM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > When I looked at the code the algorithm seemed nonstandard to me,
> > and I want to make sure I use a standard GUID algorithm. It's well
> > tested and has proved itself. If Our algorit
David Merrill <[EMAIL PROTECTED]> writes:
> When I looked at the code the algorithm seemed nonstandard to me,
> and I want to make sure I use a standard GUID algorithm. It's well
> tested and has proved itself. If Our algorithm is already standard,
> then I just misread it; I'm human. If it's not
On Sat, Dec 16, 2000 at 12:05:42PM -0500, David Merrill wrote:
> Obviously, the current algorithm is working. So there is no reason to
> change it, but I'm doing essentially a new implementation of that
> code, so I want to make sure it is solid in all respects. Possibly
> postgres has a built-in
On Sat, Dec 16, 2000 at 08:26:24AM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > I'd recommend we use the standard GUID including MAC where it is
> > available. If there is no MAC, then we could fallback to some
> > arbitrary 48 bit pattern entered in the config tab
David Merrill <[EMAIL PROTECTED]> writes:
> I'd recommend we use the standard GUID including MAC where it is
> available. If there is no MAC, then we could fallback to some
> arbitrary 48 bit pattern entered in the config table, or do without it
> entirely. After all...
>
> Q: How often would a
On Fri, Dec 15, 2000 at 07:35:09PM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > It really *is* just a rational number expressed as integer numerator
> > over integer denominator.
>
> Right. The fact that we'll probably have to represent it with two
> columns in a
On Fri, Dec 15, 2000 at 07:29:30PM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > Ugh! That is a completely meaningless name. *Every* numeric field is
> > a "quantity". Of WHAT is it a quantity?
>
> Well, we had talked about using "quantity" and "value". Quantity
>
David Merrill <[EMAIL PROTECTED]> writes:
> It really *is* just a rational number expressed as integer numerator
> over integer denominator.
Right. The fact that we'll probably have to represent it with two
columns in a database is just an artifact of the fact that SQL doesn't
have RATIONAL_64
Dave Peticolas <[EMAIL PROTECTED]> writes:
> GnuCash does not keep an explicit list of transactions around.
> However, it does provide an api to traverse over each one, hitting
> each transaction only once.
>
> In the db, I would imagine that the transactions will almost certainly
> have their o
Dave Peticolas <[EMAIL PROTECTED]> writes:
> My best guess is that it stands for 'debit'.
I had always thought it meant d(elta)amount.
--
Rob Browning <[EMAIL PROTECTED]> PGP=E80E0D04F521A094 532B97F5D64E3930
___
gnucash-devel mailing list
[EMAIL PR
David Merrill <[EMAIL PROTECTED]> writes:
> Ugh! That is a completely meaningless name. *Every* numeric field is
> a "quantity". Of WHAT is it a quantity?
Well, we had talked about using "quantity" and "value". Quantity
would indicate how much of the thing you have, and value it's value.
Though
> I said I would work on the database schema today, but my partner and I
> decided it was time to put our tree up, before Yule was past. :-)
>
> So no schema. I'll try to do some work on it tomorrow night.
SLACKER!!
So, where were you two Sunday? Missed ya
On Thu, Dec 14, 2000 at 05:11:57PM -0500, Derek Atkins wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > I *still* don't think I understand how the rational numbers work when
> > working with stocks. An example or two would help. It seems that the
> > denominator value might change based o
David Merrill <[EMAIL PROTECTED]> writes:
> I *still* don't think I understand how the rational numbers work when
> working with stocks. An example or two would help. It seems that the
> denominator value might change based on stock splits and such, for
> example.
If you are dealing with real st
On Wed, Dec 13, 2000 at 11:37:00PM -0800, Dave Peticolas wrote:
> David Merrill writes:
> > And, what do these quantities represent when storing a stock?
>
> Generally, the precision with which your brokerage allows you to
> buy stock. This may not always be something you can find out.
??? Stil
David Merrill writes:
> On Wed, Dec 13, 2000 at 02:35:30PM -0800, Gordon Oliver wrote:
> > So the denominator goes: smallest divisible unit. (amount atoms?)
> > And the numerator: number of smallest divisible units
>
> Got it now, thanks. The numerator value is in terms of the smallest
> unit of
David Merrill <[EMAIL PROTECTED]> writes:
> True, security is a lot easier when everything's local.
Agreed.
> If the client accesses the server via ssh and is then logged onto the
> database using their user account on the db machine, where are the
> weaknesses? Where is it vulnerable?
To do t
Patrick Spinler <[EMAIL PROTECTED]> writes:
[snip]
> For the server and client on the same machine, this method provides a
> reasonable expectation of privacy for the database - file protections
> stop raw access to the file, and database user auth'ing stops people
> running a database engine aga
On Wed, Dec 13, 2000 at 05:31:55PM -0600, Patrick Spinler wrote:
> David Merrill wrote:
> >
> > > Most database support auth'ing database users against the OS's auth
> > > method. Essentially, once you've logged into the system, as long as
> > > you're listed as a valid database user, you're oka
David Merrill wrote:
>
> > Most database support auth'ing database users against the OS's auth
> > method. Essentially, once you've logged into the system, as long as
> > you're listed as a valid database user, you're okay. I suggest we use
> > this method.
>
> The downside of that is the main
On Wed, Dec 13, 2000 at 02:35:30PM -0800, Gordon Oliver wrote:
> So the denominator goes: smallest divisible unit. (amount atoms?)
> And the numerator: number of smallest divisible units
Got it now, thanks. The numerator value is in terms of the smallest
unit of measure for the item. Pennies in t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Dec 13, 2000 at 02:35:30PM -0800, Gordon Oliver wrote:
>
> > Or am I thinking too much like an American, and some
> > currencies could actually be held in the amount of 3/16, for example?
>
> probably ;-)
>
> some at least used to have div
ntirely sure why. Maybe because of some
Windows bletcherousness.
Oh, now I remember. It's because of how screwy the OS-to-SQL authorization is in
Windows. More bugs than 2 week old roadkill.
I took that paragraph out of the doc, but I didn't replace it. If you want to
write a description I
ing a single username?
Most database support auth'ing database users against the OS's auth
method. Essentially, once you've logged into the system, as long as
you're listed as a valid database user, you're okay. I suggest we use
this method.
In the SCHEMA the split t
> Or am I thinking too much like an American, and some
> currencies could actually be held in the amount of 3/16, for example?
probably ;-)
some at least used to have divisions of 200 (for example, there used to be - and
perhaps still
is - a halfpence in Great Britain...)
Also common here ar
On Wed, Dec 13, 2000 at 10:15:06AM -0600, Bill Gribble wrote:
> On Tue, Dec 12, 2000 at 06:04:08PM -0500, David Merrill wrote:
> > Would you please give me an example that uses both numerator and
> > denominator in each field? Or a set of example, if that is easier?
> > I'm having trouble seeing h
On Tue, Dec 12, 2000 at 06:04:08PM -0500, David Merrill wrote:
> Would you please give me an example that uses both numerator and
> denominator in each field? Or a set of example, if that is easier?
> I'm having trouble seeing how this works.
I'm not sure what you mean by "uses". The C data type
On Wed, Dec 13, 2000 at 03:28:11PM +, Al Snell wrote:
> On Wed, 13 Dec 2000, David Merrill wrote:
>
> > Do you think people feel less able to contribute because I'm doing
> > this? If so, then by all means put it in cvs!
>
> No, no, this wasn't me saying "Oi! Put it in CVS you lazy slacker!"
On Wed, 13 Dec 2000, David Merrill wrote:
> Do you think people feel less able to contribute because I'm doing
> this? If so, then by all means put it in cvs!
No, no, this wasn't me saying "Oi! Put it in CVS you lazy slacker!" - it
was me saying "I have a CVS server if you want one" :-)
ABS
--
On Wed, Dec 13, 2000 at 03:07:35PM +, Al Snell wrote:
> On Tue, 12 Dec 2000, 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
On Tue, 12 Dec 2000, 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
Would you like a CVS repository to keep it
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
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
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
money "
> > > > > share_cleared_balance money "
> > > > > share_reconciled_balancemoney "
> [snip]
> > Then I will remove these fields from my schema. Storing the running
> >
lance money "
> > > > share_reconciled_balancemoney "
[snip]
> Then I will remove these fields from my schema. Storing the running
> balance this way just won't work for very large data sets.
>
> This does bring up an
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
> -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
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
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
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
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
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
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 "
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
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
1 - 100 of 107 matches
Mail list logo
