Re: Win32 build fails installing guile

2006-10-25 Thread Ivars Grinbergs
Hi, I confirm - have got the same problem. The first breakdown of install was due to slib3a3.zip vs slib3a4.zip file: --13:23:25-- http://swiss.csail.mit.edu/ftpdir/scm/slib3a3.zip = `c:/soft/tmp/slib3a3.zip' Resolving swiss.csail.mit.edu...

Re: SQL backend for GnuCash 2

2006-10-25 Thread Tony Bloomfield
As designer of the SQL backend for a rival package (KMyMoney), I'd be happy to swap ideas, etc. There's not a great deal of difference between the two products, except that KMM does not really support small business. Anyhow, let me know if you'd like me to post the DDL, usage description, etc.

Win32 build fails installing guile

2006-10-25 Thread R. Bibrach
Hi, the line /usr/share/slib/require in guile.init should be deleted. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: Win32 build fails installing guile

2006-10-25 Thread Steve Ellis
Hi, I still have the same issue. I started over again and edited the contents of slib3a4.zip as mentioned by Thomas. When this still came back with the error I put a symlink in for the location of the slib directory and I could see the files under /usr/share/slib $ ls /usr/share/slib/req*

Re: SQL backend for GnuCash 2

2006-10-25 Thread Phil Longstaff
On Wed, 2006-25-10 at 14:12 +0100, Tony Bloomfield wrote: As designer of the SQL backend for a rival package (KMyMoney), I'd be happy to swap ideas, etc. There's not a great deal of difference between the two products, except that KMM does not really support small business. Anyhow, let

Re: SQL backend for GnuCash 2

2006-10-25 Thread Derek Atkins
Phil, Nice work so far. I've got a few comments. IDs: The ID should be the GUID. I don't think you can make that an int per-se; although it IS a 128-bit number. I don't think the databases have 128-bit integer data types. LOTS: You probably want a Lots table. The table would have the

Re: SQL backend for GnuCash 2

2006-10-25 Thread Daniel Espinosa
I'll response message by message, then this is for this: 2006/10/23, Phil Longstaff [EMAIL PROTECTED]: On Mon, 2006-23-10 at 17:14 -0500, Daniel Espinosa wrote: Attached you'll find a DataBase Schema for GnuCash. This is in order to bigin the development to support DB backend (and

Re: SQL backend for GnuCash 2

2006-10-25 Thread Derek Atkins
Hi, A few more comments (my previous comments directly to Phil still apply). I just looked at the Dia drawings, and I've got a few more comments. Note that you didn't send out an updated doc, so these comments are based on the original version: 1) We don't need an AccountType table.

Re: SQL backend for GnuCash 2

2006-10-25 Thread Daniel Espinosa
2006/10/23, Josh Sled [EMAIL PROTECTED]: On Mon, 2006-10-23 at 17:14 -0500, Daniel Espinosa wrote: Attached you'll find a DataBase Schema for GnuCash. This is in order to bigin the development to support DB backend (and replase the actual file one). I agree with Phil's comments. Here's

Re: SQL backend for GnuCash 2

2006-10-25 Thread Daniel Espinosa
2006/10/24, Phil Longstaff [EMAIL PROTECTED]: On Mon, 2006-23-10 at 22:38 -0400, Josh Sled wrote: It'll probably be the case that the SQL DDL statements will be easier to work with than these pictures. Just plain text like... CREATE TABLE accounts ( id int NOT NULL,

Re: SQL backend for GnuCash 2

2006-10-25 Thread Phil Longstaff
On Wed, 2006-25-10 at 11:29 -0400, Derek Atkins wrote: Phil, Nice work so far. I've got a few comments. IDs: The ID should be the GUID. I don't think you can make that an int per-se; although it IS a 128-bit number. I don't think the databases have 128-bit integer data types. Well,

Re: SQL backend for GnuCash 2

2006-10-25 Thread Daniel Espinosa
2006/10/25, Phil Longstaff [EMAIL PROTECTED]: On Wed, 2006-25-10 at 14:12 +0100, Tony Bloomfield wrote: As designer of the SQL backend for a rival package (KMyMoney), I'd be happy to swap ideas, etc. There's not a great deal of difference between the two products, except that KMM does

Re: SQL backend for GnuCash 2

2006-10-25 Thread Derek Atkins
Quoting Phil Longstaff [EMAIL PROTECTED]: On Wed, 2006-25-10 at 11:29 -0400, Derek Atkins wrote: Phil, Nice work so far. I've got a few comments. IDs: The ID should be the GUID. I don't think you can make that an int per-se; although it IS a 128-bit number. I don't think the

Re: SQL backend for GnuCash 2

2006-10-25 Thread Derek Atkins
Quoting Daniel Espinosa [EMAIL PROTECTED]: Consider that may in the future GnuCash and KMyMoney, could share the same DB and give diferent GUI, why don't work together and define a solid DB storage structure for the end user (and leave him to use the GUI he wants, even a web one). I don't

Re: SQL backend for GnuCash 2

2006-10-25 Thread Josh Sled
On Wed, 2006-10-25 at 14:52 -0500, Daniel Espinosa wrote: Let me study this items, but at first, I could say that the way GnuCash handles the numeric values and representation, could be out the scope of the schema becouse it will show how the values are stored in the database and how they are

Re: importing happens even when transaction matcher told not to

2006-10-25 Thread Benoit Gregoire
On Tuesday 24 October 2006 23:50, David Reiser wrote: On Oct 24, 2006, at 11:14 AM, Derek Atkins wrote: j debert [EMAIL PROTECTED] writes: I have seen the same happen as you describe as well. Seems like this is related to bug 364104: when importing ofx it goes ahead and reconciles

Re: SQL backend for GnuCash 2

2006-10-25 Thread Mark Johnson
Derek Atkins wrote: Quoting Phil Longstaff [EMAIL PROTECTED]: On Wed, 2006-25-10 at 11:29 -0400, Derek Atkins wrote: Phil, Nice work so far. I've got a few comments. IDs: The ID should be the GUID. I don't think you can make that an int per-se; although it IS a 128-bit number. I