Re: Replacement for libdbi

2014-01-16 Thread Daniel Espinosa
Hi all, I think I'm the crazy guy trying to re-write GnuCash to use GDA. Now I'm one of the maintainers of GDA on GObject Introspection and Vala bindings support, but patch some things here and there when possible. May be is time you consider to use GDA, it has a current Debian version and well

Re: Announcing a new sub-project in gnucash: GUI in C++, Qt, CMake.

2010-03-04 Thread Daniel Espinosa
Long time a go, I told about to create a library using the GnuCash's engine. This library could be based on GObject, be GObject Introspectable (live.gnome.org/GObjectIntrospection), for bindings friendly, and reused for any language and toolkits. This library could use the Database backend, to all

DWI, QOF and gnome-db

2004-12-19 Thread Daniel Espinosa
Has anyboddy take a look at DWI and QOF eforts, and may to use the ones into the gnome-db framework? I think the idea to have a "configuration-file" to forms and the dependences between the widgets it great!, in the case of DWI is that, but need support for DataSources, then GDA (http://www.gnome-

Re: [gnome-db] DWI, QOF and gnome-db

2004-12-19 Thread Daniel Espinosa
--- Rodrigo Moya <[EMAIL PROTECTED]> escribió: > On Fri, 2004-10-29 at 18:50 -0500, Daniel Espinosa > wrote: > > Has anyboddy take a look at DWI and QOF eforts, > and > > may to use the ones into the gnome-db framework? > > > > I think the idea to have

r15522 has been commited: The initial work in QOF->GObject

2007-02-07 Thread Daniel Espinosa
Hi All, just to inform you a new gobject-engine-dev revision 15522 is commited to the repository!! This is my first work, and can't be stablished as fineshed, I'll do A LOT of new changes before to complete the transformation to GObject system... And ofcouse I'll commit early, commit often -- T

[QOF->GObject] Commited r15578: Work on GncAccount

2007-02-13 Thread Daniel Espinosa
Message: "Begin Work on GncAccount object. Modifications (for now) to: QofInstance, QofBook, QofBackend" Notes: The work to ensure the correct construction and destruction of objects, have made to work back to QofInstance, QofBook and QofBackend, becouse the way QOF work on begin_edit/commit_edit

Re: Recommendations on managing inventory

2007-02-16 Thread Daniel Espinosa
In GnuCash exist an object to manage in a generic way Commodities, actualy just some objects financial objects (bonds, currencies, funds, NASDAQ), but if you see it could manage some kind of inventory, but you need to inspect /src/engine/gnc-commodity.c/.h and create an object derived from this obj

Re: Merging trunk changes into branches

2007-02-16 Thread Daniel Espinosa
2007/2/15, Phil Longstaff <[EMAIL PROTECTED]>: > Are there any guidelines on merging changes in trunk into a branch or changes > from another branch into a branch? Merging from the trunk would allow me to > keep up with bug fixes and other changes and make the future merge back into > the trunk

GObject in GC implementation Plan

2007-03-20 Thread Daniel Espinosa
GOBJECT IN GC IMPLEMENTATION PLAN: OBJECTIVE Get GObject as the base of GC's objects. With the following advantages: - Get ref counting - Get signals events STATE OF THE ART QOF is the object system used by the GC's objects, it has the following features: - Base class

Re: GObject in GC implementation Plan

2007-03-21 Thread Daniel Espinosa
2007/3/21, Josh Sled <[EMAIL PROTECTED]>: > On Wed, 2007-03-21 at 00:42 -0600, Daniel Espinosa wrote: > > Get GObject as the base of GC's objects. With the following advantages: > > - Get ref counting > > - Get signals events > > Using GObj

Re: GObject in GC implementation Plan

2007-04-02 Thread Daniel Espinosa
2007/3/30, Derek Atkins <[EMAIL PROTECTED]>: > Hi, > > Sorry for not responding to this sooner.. Apparently it fell into > my Spam folder and I didn't notice it until today. Mea Culpa. > > More inline... > > "Daniel Espinosa" <[EMAIL PROTECTED]&

Re: GObject in GC implementation Plan

2007-04-03 Thread Daniel Espinosa
2007/4/3, Derek Atkins <[EMAIL PROTECTED]>: > Hola... > > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > >> 2) Implement GObject refcounting. I think this might be able to go > >> on an object by object basis, but I don't know

GObject in GC: A new Library

2007-04-03 Thread Daniel Espinosa
*A PURE GOBJECT LIBRARY* *JUSTIFICATION* GC doesn't use the GObject conventions: the engine re-#define most functions and data types from QOF and most objects have functions that may could be better in other object. The problem is evident when I want to add GObject definitions in each GC's object

Re: GObject in GC implementation Plan

2007-04-05 Thread Daniel Espinosa
2007/4/4, Derek Atkins <[EMAIL PROTECTED]>: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > >> > You need to remove g_free and the end of the object destruction, and > >> > keep qof_instance_release to call there g_object_unref. > &

Re: GObjectification status

2007-04-05 Thread Daniel Espinosa
Please Derek, try to follow the GObject code conventions to be more clear about your work, and please see my e-mail get coments. 2007/4/4, Derek Atkins <[EMAIL PROTECTED]>: > After about 6 hours of work over the last few days I've got > all the qofinstance-derived data objects using gobject > init

Re: GDA: Recent SX changes in trunk/GObject questions

2007-04-11 Thread Daniel Espinosa
> > Questions about use of GObjects in GC. Is the plan to base backends on > GObjects as well? Also, does it make sense to replace the whole begin > edit/commit edit architecture with an architecture where "object changed" > events are caught and acted upon by the GDA backend but not the file

Re: GObject in GC implementation Plan

2007-04-11 Thread Daniel Espinosa
2007/4/5, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > > >> >> I would think that we could just change g_free() to g_object_unref() > >> >> and let the qof_instance_release() code get executed from within the

Re: GObject in GC implementation Plan

2007-04-12 Thread Daniel Espinosa
2007/4/12, Derek Atkins <[EMAIL PROTECTED]>: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > >> I think we have a major communication issue here... > > > > Yes we do... > > Well, we should work on that. > Ok great! > >> qof_

Re: GObject in GC implementation Plan

2007-04-12 Thread Daniel Espinosa
2007/4/12, Josh Sled <[EMAIL PROTECTED]>: > On Thu, 2007-04-12 at 09:24 -0400, Derek Atkins wrote: > > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > > I have some ideas, to add this feature: > > > > > > - Add a GdaDataModel

Re: GObject in GC implementation Plan

2007-04-12 Thread Daniel Espinosa
2007/4/12, David Hampton <[EMAIL PROTECTED]>: > On Thu, 2007-04-12 at 14:06 -0500, Daniel Espinosa wrote: > > > I can understand why you feel that; the reason is that I don't think > > that convert QOF to GObject will be a good idea because its > > implementa

Re: GObject in GC implementation Plan

2007-04-12 Thread Daniel Espinosa
2007/4/12, Daniel Espinosa <[EMAIL PROTECTED]>: > 2007/4/12, David Hampton <[EMAIL PROTECTED]>: > > On Thu, 2007-04-12 at 14:06 -0500, Daniel Espinosa wrote: > > > > > I can understand why you feel that; the reason is that I don't think > > > that

Re: PATCH: fix KVP bug/allow gnc_numeric to be a GBoxed value

2007-04-12 Thread Daniel Espinosa
Derek: I have added some types declared in gnc-engine.h file as string to GType in my gobject-engine-dev, like the one for gnc_numeric Phil does, then this could be added to your branch with out alter the system, and could help Phil in he's branch. 2007/4/9, Derek Atkins <[EMAIL PROTECTED]>: > I

Re: GObject in GC implementation Plan

2007-04-13 Thread Daniel Espinosa
2007/4/13, Derek Atkins <[EMAIL PROTECTED]>: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > >> Well, it's a lot less than what you did.. And the tree continues to > >> work build and actually work. THAT was the goal for step 1. Get th

Re: GObject in GC implementation Plan

2007-04-13 Thread Daniel Espinosa
2007/4/13, Josh Sled <[EMAIL PROTECTED]>: > On Thu, 2007-04-12 at 17:42 -0500, Daniel Espinosa wrote: > > 2007/4/12, David Hampton <[EMAIL PROTECTED]>: > > > On Thu, 2007-04-12 at 14:06 -0500, Daniel Espinosa wrote: > > > > I can understand why you f

Re: GObject in GC implementation Plan

2007-04-13 Thread Daniel Espinosa
2007/4/13, Josh Sled <[EMAIL PROTECTED]>: > On Fri, 2007-04-13 at 12:04 -0500, Daniel Espinosa wrote: > > I insist to wrap QOF and step by step migrate QOF into a new pure > > GObject implementation (move the code from QOF to the new) > > I still don't think adding

Re: PATCH: fix KVP bug/allow gnc_numeric to be a GBoxed value

2007-04-13 Thread Daniel Espinosa
2007/4/13, Derek Atkins <[EMAIL PROTECTED]>: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > > Derek: > > I have added some types declared in gnc-engine.h file as string to > > GType in my gobject-engine-dev, like the one for gnc_numeric Phil >

Re: PATCH: fix KVP bug/allow gnc_numeric to be a GBoxed value

2007-04-13 Thread Daniel Espinosa
Sorry forget to add links: 2007/4/13, Daniel Espinosa <[EMAIL PROTECTED]>: > 2007/4/13, Derek Atkins <[EMAIL PROTECTED]>: > > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > > > > Derek: > > > I have added some types declared in gn

Re: Import prices API

2007-04-13 Thread Daniel Espinosa
2007/4/7, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Bengt Thuree <[EMAIL PROTECTED]>: > > > Perhaps import history data ? > > There's a historical-data F::Q backend out there somewhere, IIRC. > > > Or data that F::Q is not handling? I have a few of those myself... > > Then write an F::Q backend f

Re: GnuCash: 403 Forbidden

2007-05-28 Thread Daniel Espinosa
Could Any update the sourceforge page for GNUCash to include Windows as an operating system? or does this not happend until 2.2 is released? 2007/5/24, Nathan Buchanan <[EMAIL PROTECTED]>: > On 5/23/07, Josh Sled <[EMAIL PROTECTED]> wrote: > > > > On Wed, 2007-05-23 at 23:10 +0200, Sigmund Breuer

Questions about GObjectification in GnuCash

2007-05-31 Thread Daniel Espinosa
Does any one know why QofInstance's functions use gpointer instead of QofInstance* ? Does any one know why when you change QofInstance object's Book, just change the pointer? May be you need: (a) remove from the actual book's collection (b) add to the new book's collection (c) change the pointer t

Re: Questions about GObjectification in GnuCash

2007-06-07 Thread Daniel Espinosa
2007/6/1, Derek Atkins <[EMAIL PROTECTED]>: > Hi, > > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > > Does any one know why QofInstance's functions use gpointer instead of > > QofInstance* ? > > Um, probably because they haven't be

Re: MySQL

2007-06-07 Thread Daniel Espinosa
Phil may you want to look at this [1] discussion about GC backend system and a proporsal to use GDA more directly and not by QofBackend system with limits the power in GDA for Queries, for example. [1] https://lists.gnucash.org/pipermail/gnucash-devel/2007-June/020685.html 2007/6/1, Albert Lash <

Re: MySQL

2007-06-07 Thread Daniel Espinosa
t see it if you want or consider is important for your help in GC. > -derek > > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > > > Phil may you want to look at this [1] discussion about GC backend > > system and a proporsal to use GDA more directly and not by QofBacken

Re: Questions about GObjectification in GnuCash

2007-06-11 Thread Daniel Espinosa
I think that communication between peaple is dificult, even if they talk the same language, but I'm trying to describe my ideas to get feedback as clear as possible, I hope you have time and patience to hear them. 2007/6/11, Derek Atkins <[EMAIL PROTECTED]>: > "Daniel Espinosa

Re: I'd like to create an applet for gnucash

2007-06-26 Thread Daniel Espinosa
2007/6/26, Christian Stimming <[EMAIL PROTECTED]>: > Quoting Martin Kaffanke <[EMAIL PROTECTED]>: > >> Well, it would require work to integrate into gnome-session, get the > >> icon, do the hide vs. exit, and handle graceful shutdown.. But I think > >> this would be much easier than what you propo

PATCH - QofCollection to be a GObject

2007-06-27 Thread Daniel Espinosa
I've managed to convert QofCollection to a GObject. The API for this object is unchanged, the only affectation was QofInstance, to set/get its property "collection" from a gpointer to a GObject. -- Trabajar, la mejor arma para tu superación "de grano en grano, se hace la arena" (R) (entrámite, pe

Re: PATCH - QofCollection to be a GObject

2007-07-03 Thread Daniel Espinosa
Updated PATCH, it fixes some problems not finished, but now it works with TRUNK and the resent 2.1.5 release. El 27/06/07, Daniel Espinosa <[EMAIL PROTECTED]> escribió: I've managed to convert QofCollection to a GObject. The API for this object is unchanged, the only affectation was

Bug 453502 - Are there any plan to apply patch

2007-08-14 Thread Daniel Espinosa
Are there any plan to apply the attached bug 453502's patch? -- Trabajar, la mejor arma para tu superación "de grano en grano, se hace la arena" (R) (entrámite, pero para los cuates: LIBRE) ___ gnucash-devel mailing list gnucash-devel@gnucash.org https

Re: Questions about gnuCash backend access

2007-08-24 Thread Daniel Espinosa
2007/8/24, Samuel deHuszar Allen <[EMAIL PROTECTED]>: > I am a Lotus Notes / web developer. Have built a custom Notes app for > invoicing and billing and am wondering if there is a programmatic way to > create transactions and records in gnuCash. If so, what languages/tools are > needed to talk t

Re: Questions about gnuCash backend access

2007-08-25 Thread Daniel Espinosa
2007/8/24, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > > > 2007/8/24, Samuel deHuszar Allen <[EMAIL PROTECTED]>: > >> I am a Lotus Notes / web developer. Have built a custom Notes app for > >> invoicing and bil

Re: Questions about gnuCash backend access

2007-08-27 Thread Daniel Espinosa
2007/8/26, Derek Atkins <[EMAIL PROTECTED]>: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > > 2007/8/24, Derek Atkins <[EMAIL PROTECTED]>: > [snip] > >> Agreed. We really need a viable multi-user backend for GnuCash. > > > >

External App connection to a GnuCash file

2007-08-28 Thread Daniel Espinosa
Hi all As part of the work to Fix bug #470753 and #470767, I'm creating a test application that access to the GC file using the API in the Engine and QOF, but I need some help about the following: /* HELP No 1 */ While compiling my test program I have an error message: Why I hav

Re: External App connection to a GnuCash file

2007-08-29 Thread Daniel Espinosa
2007/8/28, Josh Sled <[EMAIL PROTECTED]>: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > Why I have an error message for the file > > /usr/local/include/gnucash/qofutil.h in the line: > > > > # error "No scanf format string is known for

Re: External App connection to a GnuCash file

2007-08-29 Thread Daniel Espinosa
2007/8/29, Josh Sled <[EMAIL PROTECTED]>: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > I found a macro in /macros/legacy_macros.m4 witch test for sscanf to > > support %lld (long long decimal integer) if so defines HAVE_SCANF_LLD. > > I think this

Re: External App connection to a GnuCash file

2007-08-29 Thread Daniel Espinosa
2007/8/29, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > > > 2007/8/29, Josh Sled <[EMAIL PROTECTED]>: > >> "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > >> > I found a macro in /macros/legac

Re: External App connection to a GnuCash file

2007-08-30 Thread Daniel Espinosa
2007/8/29, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > > >> > I found a some macros used in GnuCash's configure.in file, and I'll > >> > trying to add to my program in order to fix this error, does any kn

Re: Questions about gnuCash backend access

2007-08-31 Thread Daniel Espinosa
2007/8/29, Josh Sled <[EMAIL PROTECTED]>: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > Well I still wait for my patch to be applied to QofCollection (see bug > > #453502) and wants to alling the current API convention to GObject's > > one (

Fwd: [gnome-db] Libgda/Libgnomedb version 3.1.1 available

2007-09-03 Thread Daniel Espinosa
I hope this is interesting, if not, please tell me to avoid forwarding. -- Forwarded message -- From: Vivien Malerba <[EMAIL PROTECTED]> Date: 02-sep-2007 2:58 Subject: [gnome-db] Libgda/Libgnomedb version 3.1.1 available To: gnome-db list <[EMAIL PROTECTED]>, [EMAIL PROTECTED], [E

Re: External App connection to a GnuCash file

2007-09-03 Thread Daniel Espinosa
2007/9/2, Christian Stimming <[EMAIL PROTECTED]>: > Am Mittwoch, 29. August 2007 21:52 schrieb Josh Sled: > > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > > I found a macro in /macros/legacy_macros.m4 witch test for sscanf to > > > suppo

Re: Symbian

2007-10-20 Thread Daniel Espinosa
Things like this is why is better to have a library doing the hardwork and allows the users to create it's interface, I don't know about Symbian, but GDA and GnomeDB have a porting to Maemo (Nokia N800 - I have one:) and that was in a relative short time, even Glom witch uses GDA, have one. Rememb

Accounts for locate es_MX

2008-01-08 Thread Daniel Espinosa
I've finished to create the set of accounts for es_MX locate, you'll find them attached and the required patch. -- Trabajar, la mejor arma para tu superación "de grano en grano, se hace la arena" (R) (entrámite, pero para los cuates: LIBRE) es_MX.tar.gz Description: GNU Zip compressed data dif

Re: GDA: empty PostgreSQL table failed workaround

2008-02-13 Thread Daniel Espinosa
2008/2/13, Mark Johnson <[EMAIL PROTECTED]>: > Phil Longstaff wrote: > > The slot_id is used to provide a unique primary key. I don't know if it > > would work to have the slots table have *no* key, but have an index on > > the obj_guid field. The obj_guid field can't be the primary key because >

Re: GDA: PostgreSQL empty slots table

2008-02-19 Thread Daniel Espinosa
gda-3.0-docs.sgml (revisión: 3056) +++ doc/C/libgda-3.0-docs.sgml (copia de trabajo) @@ -207,6 +207,16 @@ libgda, gda-postgres, gda-mysql + +Daniel +Espinosa Ortiz + + + [EMAIL PROTE

Re: GDA spurious save dialog

2008-03-03 Thread Daniel Espinosa
2008/2/28, Mark Johnson <[EMAIL PROTECTED]>: > I see from the ChangeLogs and message traffic that the issues arising > from the missing SQL records have been dealt with. > > I have patched and compiled libgda 3.0.2 with the following two patches: > 1. Escaping of single quotes in strings is corr

Re: GDA: Transactions (was Re: Managing large files)

2008-03-10 Thread Daniel Espinosa
2008/3/9, Andrew Sackville-West <[EMAIL PROTECTED]>: > On Sun, Mar 09, 2008 at 08:10:34PM -0400, Phil Longstaff wrote: > > Andrew Sackville-West wrote: > > > On Sun, Mar 09, 2008 at 06:35:01PM -0400, Phil Longstaff wrote: > > > > >> My proposed (temporary?) solution is to modify the gda backend t

Re: GDA: Status

2008-05-29 Thread Daniel Espinosa
2008/5/26 Phil Longstaff <[EMAIL PROTECTED]>: > Graham Leggett wrote: >> Phil Longstaff wrote: >> >>> Well, V4 basically works with the sqlite provider. There were a number >>> of memory leaks and other small issues. However, there are a number of >>> problems with the V4 mysql provider - it's no

Re: GDA: Status

2008-05-29 Thread Daniel Espinosa
I've read all your other comments and is the same as before I "try" to re-write most of the GC's core, you don't want to lesen the others, the I don't plan to work on GC's as actualy is. If I can help Phil improving GDA it's Ok. If some others work to modify the GC's core to create a bussiness libr

Re: GDA: Status

2008-05-31 Thread Daniel Espinosa
. On version 4, you have just a GObject called GdaStatement and a tree of C structures describing the SQL query parts, in a realy simple way. To see a better explanation about this look at GDA documentation (boulding from svn). But there are a lot of API/ABI changes to get a more easy to use lib

Re: GDA: Status

2008-05-31 Thread Daniel Espinosa
2008/5/30 Derek Atkins <[EMAIL PROTECTED]>: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > >> I just want to point that if you use V4 you may will get inmediatly >> access to SQLite database, and after the API is stable enough the >> other database

Re: GDA: Status

2008-05-31 Thread Daniel Espinosa
2008/5/31 Daniel Espinosa <[EMAIL PROTECTED]>: > 2008/5/30 Derek Atkins <[EMAIL PROTECTED]>: >> "Daniel Espinosa" <[EMAIL PROTECTED]> writes: >> >>> I just want to point that if you use V4 you may will get inmediatly >>> access to SQLi

Re: Bug 105932

2008-06-25 Thread Daniel Espinosa
2008/6/1 Daniel Espinosa <[EMAIL PROTECTED]>: > Could you talk about Bug #470753, why don't create a pc suitable to > use for external applications? > > 2008/5/19 Charles Day <[EMAIL PROTECTED]>: >> On Mon, May 19, 2008 at 5:54 PM, Josh Sled <[EMAIL PROTECTED

Re: Reading whole db at startup (was Re: String lengths in the SQL backend)

2008-11-20 Thread Daniel Espinosa
If you look at libqof's code you'll find that all GC's QOF implementation is based in store *all* data object in memory using a GHashTable using a string for the object type and GUID for identification, any search for any object is a foreach routine. This implementation is good for XML data store,

Re: String lengths in the SQL backend

2008-11-22 Thread Daniel Espinosa
> > Having said that, we shouldn't rule out users accessing the data > out from under GnuCash, at least in a read-only means. I still > believe that external tools should not be writing data into the > GnuCash database. > Have you thought about how allow other applications could use GnuCash engin

Re: File/Database access (open and save-as)

2009-03-07 Thread Daniel Espinosa
Hi Phil, have you consider some of the GnomeDB widgets it has for open a GDA connection? This is more general and allows you to create new Data Source Names, from the providers supperted by GDA, then if any is added the user can use that database. 2009/3/6 Phil Longstaff > I've created a new di

GnuCash 1.9.7 doesn't run

2006-06-15 Thread Daniel Espinosa
I compile and install on a Ubuntu 6.06, the version 1.9.7, but it just shows the splash intent to open the main window but close inmediately with the next message: : In procedure scm-error in expression (scm-error (quote misc-error) #f ...): : no code for module (g-wrap gw standard) -- Trabajar,

Re: GnuCash 1.9.7 doesn't run

2006-06-16 Thread Daniel Espinosa
2006/6/16, Christian Stimming <[EMAIL PROTECTED]>: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Daniel Espinosa schrieb: > > I compile and install on a Ubuntu 6.06, the version 1.9.7, but it just > shows > > the splash intent to open the main w

GnuCash and Reports in C# or Python?

2006-09-10 Thread Daniel Espinosa
Are any way to use C# or Python to create reports, access the database or create custom forms? I know that you use guile, but python (or even C#) are more popular and most peaple knows it; if it could be may others could help in improve the actual reports and create new one... -- Trabajar, la mej

Stock in GnuCash?

2006-09-19 Thread Daniel Espinosa
Are there any plan to include stock management in Gnucash? I mean, number of articules, type, code, individual values and total (to be in the assets side) -- Trabajar, la mejor arma para tu superación "de grano en grano, se hace la arena" (R) (entrámite, pero para los cuates: LIBRE) _

Re: Fwd: Stock in GnuCash?

2006-09-20 Thread Daniel Espinosa
It's too complicated, as a small business you just want: a) Create a DB for the articules you have in your business b) State a Price List value for each articule (the default) c) Sale a quantity and stablish a sell value (or accept the Price List) d) Reduce automaticaly the number of goods in stoc

Re: SQL backend for GnuCash 2

2006-10-23 Thread Daniel Espinosa
2006/10/22, Josh Sled <[EMAIL PROTECTED]>: > On Sat, 2006-10-21 at 22:56 -0400, Phil Longstaff wrote: > > 1) target SQLite, PostgreSQL or MySQL directly in a QOF back end, or > > 2) target libdbi or another such layer (how many data layers do we > > want?) which would give us all three (SQList, Pos

Re: SQL backend for GnuCash 2

2006-10-23 Thread Daniel Espinosa
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 added a Inventory Table (or Class) in wich you can have the merchandise in a small business like a small store. 2006/10/23, Daniel Esp

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 d

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 agr

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

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 K

Re: SQL backend for GnuCash 2

2006-10-25 Thread Daniel Espinosa
2006/10/25, Derek Atkins <[EMAIL PROTECTED]>: 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

Re: SQL backend for GnuCash 2

2006-10-25 Thread Daniel Espinosa
2006/10/25, Josh Sled <[EMAIL PROTECTED]>: > 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 sche

Re: SQL backend for GnuCash 2

2006-10-26 Thread Daniel Espinosa
2006/10/26, Ivars Grinbergs <[EMAIL PROTECTED]>: Derek Atkins wrote: > "Daniel Espinosa" <[EMAIL PROTECTED]> writes: > > >>> 1) We don't need an AccountType table. AccountTypes are not data, >>>they are encoded in the application.

Re: Updated DDL for SQL backend

2006-10-27 Thread Daniel Espinosa
2006/10/26, Phil Longstaff <[EMAIL PROTECTED]>: > I've attached an updated DDL for the proposed SQL backend. I used MySQL > to test, and it creates the tables correctly. I have tested your DDL in PostgreSQL and it doesn't work, may need to modify it in a more portable area: Command: psql gnucash

Re: GUIDs (was Re: SQL backend for GnuCash 2)

2006-10-30 Thread Daniel Espinosa
2006/10/30, Derek Atkins <[EMAIL PROTECTED]>: > Phil Longstaff <[EMAIL PROTECTED]> writes: > > >> Sorry, what I meant was that I didn't understand what you meant by > >> "small add-on".. I don't know GDA well-enough to know what that means > >> or how that would work. > >> > >> > Phil > > > > I ha

Re: Updated DDL for SQL backend

2006-10-31 Thread Daniel Espinosa
2006/10/28, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Phil Longstaff <[EMAIL PROTECTED]>: > > >> Nah... Think of a KVP slot like a filesystem directory tree. Each node > >> can either be a File or a Directory. The Slot Path walks down the > >> tree (through KVP_FRAMEs) until you get down to a

Re: GC architecture for backends

2006-11-01 Thread Daniel Espinosa
2006/11/1, Derek Atkins <[EMAIL PROTECTED]>: > The QOFBackend interface is documented in the Doxygen docs. > The rest of it, however, hasn't been well documented. > > I do not believe that gnc-engine.c should load the module -- it should > get loaded elsewhere. If that's where stuff is being loade

Re: GC architecture for backends

2006-11-02 Thread Daniel Espinosa
2006/11/1, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > > >> Also, we'll need to make changes to handle the fact that file:// > >> should get redirected to sqlite:// -- but the code will need to > >> test the

Re: GC, QOF and queries

2006-11-03 Thread Daniel Espinosa
2006/11/3, Derek Atkins <[EMAIL PROTECTED]>: > Phil Longstaff <[EMAIL PROTECTED]> writes: > > >> What version of LibGDA do you need to get GdaQuery? Is libgda-1.9.100 > >> recent enough? Or do you need something more recent than that? (I ask > >> because 1.9.100 is what FC5 has). > > > > I don't

Re: GC, QOF and queries

2006-11-03 Thread Daniel Espinosa
2006/11/2, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Phil Longstaff <[EMAIL PROTECTED]>: > > > I have started working on a gda backend and am starting with a QofQuery > > -> SQL translator. I assume no one else has such a beast (there is a > > SQL -> QofQuery translator as part of QOF. When we

Re: GC, QOF and queries

2006-11-03 Thread Daniel Espinosa
2006/11/3, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > > > 2006/11/2, Derek Atkins <[EMAIL PROTECTED]>: > >> Quoting Phil Longstaff <[EMAIL PROTECTED]>: > >> > >> > I have started work

Re: GC, QOF and queries

2006-11-03 Thread Daniel Espinosa
2006/11/3, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > > > I'm trying to question in the best way, with out injury to any, the GC > > architecture and try to HELP to have a better one. > > The steps towards a better ar

Re: GC, QOF and queries

2006-11-03 Thread Daniel Espinosa
2006/11/3, Phil Longstaff <[EMAIL PROTECTED]>: > On Fri, 2006-03-11 at 17:00 -0500, Derek Atkins wrote: > > I think, Phil, that you should use Daniel as a resource to better > > understand GDA. Daniel, I think you should provide your GDA knowledge > > to Phil who seems to better understand the is

Re: Gnucash doesn't work with external QOF (was: Re: GC, QOF and queries)

2006-11-03 Thread Daniel Espinosa
2006/11/3, Christian Stimming <[EMAIL PROTECTED]>: > Am Freitag, 3. November 2006 21:40 schrieb Daniel Espinosa: > > 2006/11/3, Derek Atkins <[EMAIL PROTECTED]>: > > > 1) Convert QOF to use GObject natively instead of being GObject-like > > > 2) Using the

GObject & QOF

2006-11-25 Thread Daniel Espinosa
Hi all, this message is to tell you about my work in embed the GObject in QOF. At moment I had made QofQuery a GObject derived from GdaQuery. The code is living aside the existing one and with out modify the current API as possible; the objective is to create a GdaQuery object when you create or

Re: gda-dev does not compile

2006-12-13 Thread Daniel Espinosa
2006/12/12, Mark Johnson <[EMAIL PROTECTED]>: > Mark Johnson wrote: > > >I've modified the config file as follows: > > > > > > > > >value="URI=/home/phil/.libgda/sales_test.db"/> > > > > > > > > > > > > > > > > > > > >

Re: gda-dev does not compile

2006-12-20 Thread Daniel Espinosa
2006/12/18, Derek Atkins <[EMAIL PROTECTED]>: > Hi, > > Quoting Mark Johnson <[EMAIL PROTECTED]>: > > > After a few minutes playing with it, I offer the following feedback: > > 1. It should use the username and password from the connection rather > > than requiring them on the command line. > > Agr

QOF->GObject Plan

2006-12-20 Thread Daniel Espinosa
Well it takes me too much of my free time, but it's here: The attached plan in OOo writer format, describes the considerations, analisys, implementation plan and aditional comments derived to allows QOF to be based in GObject. As the results this is my conclusions: Most of the actual QOF object

Re: QOF->GObject Plan

2006-12-26 Thread Daniel Espinosa
2006/12/22, Josh Sled <[EMAIL PROTECTED]>: > On Wed, 2006-12-20 at 16:10 -0600, Daniel Espinosa wrote: > > May is time to consider to deprecate the actual File backend and > > construct some utilities to automaticaly convert this to a SQLite file > > (it isn't a t

Re: QOF->GObject Plan

2006-12-28 Thread Daniel Espinosa
2006/12/26, Derek Atkins <[EMAIL PROTECTED]>: > Quoting Daniel Espinosa <[EMAIL PROTECTED]>: > > >> As discussed not too long ago on the list, you can't ignore the GUIDs in > >> deference to the databases's identity datatype. The GUIDs *are* the >

Re: gda-dev; new libgda version

2006-12-28 Thread Daniel Espinosa
2006/12/28, Derek Atkins <[EMAIL PROTECTED]>: > Mark Johnson <[EMAIL PROTECTED]> writes: > > > A new version of libgda has been released. It is 2.99.2. They have > > bumped the ABI version to 3.0. Consequently, libgda-2.0.pc is now > > libgda-3.0.pc. Therefore, after upgrading to libgda 2.99.2,

Re: gda-dev; new libgda version

2006-12-28 Thread Daniel Espinosa
> > > > > >>Further feedback on gda-dev: > >>configure did not fail when libgda-2.0.pc was not present. The > >>configure.in should be updated to have an option to enable/disable this > >>backend (like the --enable-sql option for postgresql). When the libgda > >>is not present and the option is e

Re: gda-dev; new libgda version

2006-12-28 Thread Daniel Espinosa
2006/12/28, Daniel Espinosa <[EMAIL PROTECTED]>: > > > > > > > > >>Further feedback on gda-dev: > > >>configure did not fail when libgda-2.0.pc was not present. The > > >>configure.in should be updated to have an option to enable/

GObject in the Engine example

2007-01-10 Thread Daniel Espinosa
Attached you'll find a C code example in how I can "hide" QOF from the GObject implementation in the GC's engine. Please consider the following: 1) This is just an example and not all the methods supported for the objects had been implemented 2) This example just take three objects: the top leve

Re: GObject in the Engine example

2007-01-11 Thread Daniel Espinosa
2007/1/11, Chris Shoemaker <[EMAIL PROTECTED]>: > Just some comments from a brief look... > > 1) What's with GdaBinary? > Its a mistake, I had copy some code to declare a GdaBinary as a G_TYPE_BOXED derived type, and I forgot to update this reference must be GncNumeric. > 2) Why don't the Accoun

  1   2   >