[GNC-dev] Gnucash and the UK's "Making Tax Digital" initiative

2018-11-19 Thread Graham Leggett
Hi all, I just learned with some shock that the UK wants to force SMEs to submit VAT returns “via external software packages” by 1 April 2019, and presents a list of some 150 packages to choose from. If you’re lucky enough to already be using one of those packages, great. If you’re not, you’re

Re: Announcement: GnuCash 2.6.0 Released

2013-12-30 Thread Graham Leggett
On 31 Dec 2013, at 8:54 AM, Graham Leggett wrote: > More information, attempting to run gnucash from the command line fails as > follows: > > Little-Net:Testing minfrin$ Gnucash.app/Contents/MacOS/Gnucash > Application Path /Applications/Testing/Gnucash.app/Contents/Ma

Re: Announcement: GnuCash 2.6.0 Released

2013-12-30 Thread Graham Leggett
On 31 Dec 2013, at 9:14 AM, Graham Leggett wrote: > I tried to raise this as a bug in bugzilla, but the "forgot password" > mechanism is currently broken, it goes through the complete process of > allowing you to change your password, confirms that your password

Re: cmd line: import of transactions and invoice data

2014-01-01 Thread Graham Leggett
On 01 Jan 2014, at 7:25 PM, John Ralls wrote: > Gnucash *probably* writes things to the XML file in the same order that they > were read > in just because we use linked lists for just about everything internally, but > there's > no guarantee of that and it might well create excessive churn in a

Re: Credit notes analysis

2011-09-11 Thread Graham Leggett
On 11 Sep 2011, at 11:26 PM, Geert Janssens wrote: I have spent some time to investigate what is needed to support credit notes in GnuCash. The result of my analysis can be found here: http://wiki.gnucash.org/wiki/Credit_Notes For simplicity I'm using the term "credit note" as the inverse of

Re: New data field for invoice object

2011-10-08 Thread Graham Leggett
On 08 Oct 2011, at 8:18 PM, John Ralls wrote: The way you'd implement an optional type field in an RDB is to create a new table for it with two fields, a key (which would be the invoice GUID) and the type, and the code for handling that table would have to examine the database version and n

Building gnucash for MacPorts + Quartz fails

2011-11-30 Thread Graham Leggett
Hi all, Having followed the instructions below in an attempt to install a quartz version of gnucash, the build fails complaining that it cannot find libgtk-x11-2.0.la. It seems that despite being configured for quartz, gnucash still attempts an X11 build. http://wiki.gnucash.org/wiki/MacOSX/Ma

Re: Building gnucash for MacPorts + Quartz fails

2011-11-30 Thread Graham Leggett
On 30 Nov 2011, at 10:53 PM, David T. wrote: > My workaround has been to download the dmg off Sourceforge. ;) I had done that already, and found it depended on X11. I wanted something cleaner if that was possible, and it was possible that the people who made the quartz build work didn't know it

Re: Strategy

2011-12-04 Thread Graham Leggett
On 03 Dec 2011, at 11:40 PM, Donald Allen wrote: > Gnucash has been around > for a long time, and its life-span covers the development of a lot of > tools. If you were going to start with a blank sheet of paper today, I > doubt very much whether you would do a lot of the system as it is > today. T

Re: Add IRS audit capabilities

2012-02-15 Thread Graham Leggett
On 15 Feb 2012, at 6:15 PM, Ted Creedon wrote: > Being audited for 2 years, Gnucash is very helpful. > > Suggestion, it would be helpful if receipts, check stubs and other > documents could be scanned in and made part of the transaction record. > > Binary BLOBS would require a lot of database st

Re: For The Love Of Bitcoin

2012-02-16 Thread Graham Leggett
On 16 Feb 2012, at 7:45 AM, karmicads wrote: >>> I suppose I´d like to see bitcoin supported as a mainstream currency, >>> despite the lack of official ISO recognition. I imagine GnuCash not only > >> I don't know what our policy is on adding non-ISO currencies to the list >> of currencies. > >

Thoughts on budgeting

2012-02-19 Thread Graham Leggett
Hi all, For a while now I have been capturing transactions up to a year ahead (as opposed to being behind), entering the expected transaction value. When the account is reconciled, the values become actual values. What this allows me to do is know what my bank account will look like in three m

Re: Credit notes

2012-08-30 Thread Graham Leggett
On 30 Aug 2012, at 18:35, Geert Janssens wrote: > Anyone who's good with words, can you voice your opinions here please ? A credit note is a type of invoice, the other type of invoice being a debit note. I would recommend not making up out own terms for this this, but rather leaving it as "in

Re: GnuCash XML spec (for non-C languages?)

2012-11-05 Thread Graham Leggett
On 05 Nov 2012, at 9:58 AM, Colin Law wrote: >> I wouldn't go there. Most people, me included, consider their financial data >> to be extremely sensitive and private. The potential liability from such a >> cloud storage facility getting hacked is incalculable. > > That is a valid argument agai

Re: GnuCash XML spec (for non-C languages?)

2012-11-06 Thread Graham Leggett
On 06 Nov 2012, at 12:22 PM, Christian Stimming wrote: > Hence, even though it is still not yet realistic to find a complete > specification of data store access independently from our C library, I think > it should be possible to do a specification of a subset of the data. And > applications

Re: GnuCash XML spec (for non-C languages?)

2012-11-06 Thread Graham Leggett
On 06 Nov 2012, at 3:14 PM, "Derek Atkins" wrote: > Another option would be to have a GnuCash "service" that runs on a home > server and enables remote access to the GnuCash data through a well defined > services API. A mobile app would implement the client side of the services > API and conne

Re: GnuCash XML spec (for non-C languages?)

2012-11-06 Thread Graham Leggett
On 06 Nov 2012, at 3:28 PM, Geert Janssens wrote: > Just for completeness, let me repeat what has been said multiple times > before: an XSD can't possibly describe the accounting constraints we impose > (eg sum of all splits in a transaction should be zero). So at best an XSD can > protect you

Re: Recommend IDE for coding in "C"

2013-03-20 Thread Graham Leggett
On 20 Mar 2013, at 7:13 PM, Buddha Buck wrote: > Both C and C++ are old enough languages that they have a certain amount of > cruft in their design with makes it hard for IDEs to get their hooks into > them to provide "advanced" services. For instance, while there are > "refactoring" tools for J

Re: Approval for Introducing Your Software in Japanese PC magazine

2013-04-28 Thread Graham Leggett
On 28 Apr 2013, at 04:45, John Ralls wrote: > The rules say that you have to distribute all of the source code, but I think > that it's become > pretty common to rely on the fact that the sources are all readily available > via the net. You'll > probably want to get an OK from your lawyers. Th

Re: Base And Gnucash

2013-04-29 Thread Graham Leggett
On 29 Apr 2013, at 7:28 PM, John Ralls wrote: > Because Gnucash isn't that kind of a program. It's an accounting program, the > exact domain for which SQL was invented. "Basically Available, Soft state, > Eventual consistency" are all anathema to accountants. Really? I am still waiting for one

Re: Bug 336843 - Attach files to Transactions

2013-11-14 Thread Graham Leggett
On 14 Nov 2013, at 7:17 AM, David Carlson wrote: > If there is is a short warning about the fragility of external links > within the program including a reference to a more thorough discussion > in a help file, I think that users can decide for themselves whether to > proceed. The discussion sho

Re: Announcement: GnuCash 2.6.0 Released

2013-12-30 Thread Graham Leggett
On 30 Dec 2013, at 5:22 PM, John Ralls wrote: > The Gnucash 2.6.0 MacOSX package can be downloaded from Sourceforge as well. Has anyone successfully got the MacOSX binary to start up? I download it, I copy it to applications, I double click on "Gnucash", the splash screen appears for a brief f

Re: Announcement: GnuCash 2.6.0 Released

2013-12-30 Thread Graham Leggett
On 31 Dec 2013, at 8:46 AM, Graham Leggett wrote: >> The Gnucash 2.6.0 MacOSX package can be downloaded from Sourceforge as well. > > Has anyone successfully got the MacOSX binary to start up? > > I download it, I copy it to applications, I double click on "Gnucash

Re: [PATCH] sort when saving

2009-05-03 Thread Graham Leggett
Jim Radford wrote: > The attached patches sort the slots, lots, book accounts, bill terms, > customers, employees, entries, invoices, jobs, orders, tax tables and > vendors before saving them to the gnucash XML file. > > This is an attempt to make saves more idempotent thereby facilitating > the

Re: New database backend and multi-user

2009-09-07 Thread Graham Leggett
Phil Longstaff wrote: > 1) locking/transactions - db transactions are used whenever an object is > written or updated. However, no locking is done, and there are certain cases > where related objects are not saved in the same db transaction, because the > back-end does not have enough informat

Re: Patch: removed trailing white spaces

2009-09-10 Thread Graham Leggett
Geert Janssens wrote: > You can ignore this. > > I have found how to disable the automatic trailing whitespace removal in > Eclipse. +1 to the patch anyway, getting rid of glitches like this prevents other eclipse users running into the same problem. Regards, Graham -- smime.p7s Description:

Algorithm for allocating payments

2009-11-08 Thread Graham Leggett
Hi all, I am currently trying to create some code to add a payment to a gnucash xml file in java, and I am struggling to find a proper description of the procedure I need to create the lots that link the transaction in A/R with the customer who made the payment. Is there a definitive description

Re: Algorithm for allocating payments

2009-11-09 Thread Graham Leggett
marcus.wolsc...@googlemail.com wrote: > Why write it yourself? Because jgnucashlib didn't exist when I started writing this code, it's been around for a while :) > That code already exists in jGnucashLib. > https://sourceforge.net/projects/jgnucashlib/ > > I remember that I wrote code to mark t

Re: Why is your Software Free

2010-03-27 Thread Graham Leggett
On 25 Mar 2010, at 11:51 PM, Cam KELLY wrote: My brother speaks highly of your software and I have a question. Why is gnucash available for free and/or donation ? I have a limited understanding of the GNU Software License but if I understand correctly, you are not required by the license to ma

Re: We need to prevent multi-user access to the SQL backend (Re: New GnuCash article on LWN)

2010-05-19 Thread Graham Leggett
On 19 May 2010, at 11:47 PM, Per Kjeldaas wrote: Your solution to block the whole database is good enough for me. It's a real shame that a system fundamentally designed to offer multi user access to data should be crippled in such a fashion. In the process, virtually all reasons to use a S

Re: We need to prevent multi-user access to the SQL backend (Re: New GnuCash article on LWN)

2010-05-20 Thread Graham Leggett
On 20 May 2010, at 6:32 PM, Derek Atkins wrote: Your solution to block the whole database is good enough for me. It's a real shame that a system fundamentally designed to offer multi user access to data should be crippled in such a fashion. In the process, virtually all reasons to use a SQL da

Re: We need to prevent multi-user access to the SQL backend (Re: New GnuCash article on LWN)

2010-05-20 Thread Graham Leggett
On 20 May 2010, at 6:55 PM, Derek Atkins wrote: Well, over time one would hope that we can slowly rearchitect gnucash to be more aware of multi-user situations. I'm keen to do some of that work, as I need it directly. In any practical usage, even in it's simplest form, you start off small

Re: We need to prevent multi-user access to the SQL backend (Re: New GnuCash article on LWN)

2010-05-23 Thread Graham Leggett
On 21 May 2010, at 6:04 PM, Derek Atkins wrote: Because a situation arises when both of you need to make writes. Which copy is the authoritative copy? Using svn alleviates this somewhat, but isn't ideal. The authoritative copy belongs to whomever has the "write token". Otherwise known as t

Re: Invoice Importer

2010-06-09 Thread Graham Leggett
On 09 Jun 2010, at 3:33 PM, Phil Longstaff wrote: I've had thoughts of a generic importer, so I'll lay them out here and you can use some or all or none of them. I have used an accounting system in the past which allows CVS files to be imported. You specify the CVS file and which CVS colum

Trial balance includes data from previous financial years

2010-07-26 Thread Graham Leggett
Hi all, I am currently struggling with the trial balance report in gnucash v2.2.7. When I attempt to run a trial balance from 2009-03-01 to 2010-02-28, I end up with transactions included in the report from before 2009-03-01. I keep the same gnucash file spanning multiple years, and the i

Re: Getting 2.4 Released - Yes!

2010-10-20 Thread Graham Leggett
On 20 Oct 2010, at 12:17 AM, AshokR wrote: By this approach, it is a win-win for both users and developers. The users get the option to save in relational database formats to use third- party reporting tools and integrate with other applications. And the developers get to bake SQLite3 integ

Re: Challenging python coders: Who can create a gnucash-like GUI in python in a few weeks?

2011-01-10 Thread Graham Leggett
On 10 Jan 2011, at 12:24 PM, Christian Stimming wrote: We've been discussing various future directions for gnucash, including a switch to a different programming language for the GUI code [1]. GUI coding in C sucks. Because of this, I've experimented with C++/Qt and was able to write up a u

Re: gnucash-android implementation (Three projects for Gnucash)

2011-02-06 Thread Graham Leggett
On 06 Feb 2011, at 9:44 PM, Christian Stimming wrote: There is no such interchange file format available as well at the moment. Again: Even though in gnucash we always insisted you have to use the existing C code, the situation now has changed and there is a significant user request which c

Re: Three projects for Gnucash

2011-02-06 Thread Graham Leggett
On 05 Feb 2011, at 11:09 PM, Ryan M. Ward wrote: 1) Implementing a way of storing receipt images (scanned or from a cell phone, etc) in a database- referenced by transaction (IE from the ledger, you would have the option of looking up the reciept associated with a particular transaction

Re: Un-reconciling - how?

2001-04-20 Thread Graham Leggett
Dave Peticolas wrote: > > I am currently in danger of developing advanced RSI trying to fix this > > error - is there a way of switching off the annoying dialog box? It > > should have at least a checkbox on it saying "do not warn me again". > > Sorry, there is no way to turn off the message. Bu

Un-reconciling - how?

2001-04-20 Thread Graham Leggett
Hi all, I have a need to cancel all reconciled flags on an account full of transactions (there's an error in there, no I cannot find it, it's quicker to reconcile from scratch). The trouble is that gnucash is hell bent on trying to stop me from doing this - popping up an annoying warning dialog

New bill crash in gnucash v2.0.5

2007-02-26 Thread Graham Leggett
Hi all, I reported a crash in January where it was not possible to create a new bill with gnucash v2.0.4 on MacOSX Intel (latest version) - I have just tried to upgrade to v2.0.5, and the problem is still there. This time round I have managed to get a proper backtrace out of it, which is inc

Re: New bill crash in gnucash v2.0.5

2007-02-26 Thread Graham Leggett
Derek Atkins wrote: I haven't been able to reproduce this on my Linux system. I'm wondering if it's a MacIntel issue or a broken dependency or some issue with a particular dependent library? Are you using fink or MacPorts? I'm using fink and the instructions at http://captnswing.net/2006/07

Re: New bill crash in gnucash v2.0.5

2007-02-27 Thread Graham Leggett
David Reiser wrote: If you're willing to try the whole fink route, 2.0.5 went up a day or two ago. For that you would have to use 'fink install gnucash2' Neither I nor the dev checking my packaging has an intel mac, however. Let me try this, will report back if I have some success. Regards,

Re: New bill crash in gnucash v2.0.5

2007-03-04 Thread Graham Leggett
David Reiser wrote: If you're willing to try the whole fink route, 2.0.5 went up a day or two ago. For that you would have to use 'fink install gnucash2' Neither I nor the dev checking my packaging has an intel mac, however. After lots of fighting with it (fink seems to have quite a few dep

Re: New bill crash in gnucash v2.0.5

2007-03-05 Thread Graham Leggett
On Mon, March 5, 2007 3:02 pm, Derek Atkins wrote: > Just to confirm what you're saying, after upgrading to 2.0.5 > you no longer see the crash, right? No, after upgrading all the fink packages I no longer see the crash. In other words, if people are to use gnucash under fink, fink needs to be f

Gnucash v2.0.5 on Fink - Printing blank invoices

2007-05-17 Thread Graham Leggett
Hi all, Having just installed a completely new installation of fink, followed by "fink install gnucash2", I now have gnucash v2.0.5 installed on MacosX 10.4.9. Unfortunately, any attempt at printing results in a blank page - the lines making up the invoice table appear, and if the technicolour st

Re: [dev] Gnucash v2.0.5 on Fink - Printing blank invoices

2007-05-17 Thread Graham Leggett
On Thu, May 17, 2007 4:37 pm, Ariel wrote: > No direct answer for you, but try exporting the report, and printing from > a web browser. You can also edit if necessary in any HTML editor. That was plan B. Unfortunately the HTML export doesn't seem to export any stylesheet information associated wi

Re: Gnucash v2.0.5 on Fink - Printing blank invoices

2007-05-17 Thread Graham Leggett
On Thu, May 17, 2007 4:48 pm, Ariel wrote: > If I'm not mistaken gnucash does not have any stylesheets with reports. So > you are not missing anything - does the export look very different from > what shows up on the screen? Very different, yes. Without a stylesheet, the browser places all the i

Re: Gnucash v2.0.5 on Fink - Printing blank invoices

2007-05-17 Thread Graham Leggett
On Thu, May 17, 2007 5:17 pm, [EMAIL PROTECTED] wrote: > That's a different problem. GktHTML doesn't properly export the > 'align' tags. This is a known bug in GtkHTML but there's no workaround. I remember having this problem in the v1.8 series, this bug has been around for a very long time -

Re: Gnucash v2.0.5 on Fink - Printing blank invoices

2007-05-17 Thread Graham Leggett
On Thu, May 17, 2007 6:00 pm, Derek Atkins wrote: > Well... There are the scheme reports which form a scheme structure > that uses the stylesheets to convert everything into HTML. This HTML > is then fed into GtkHTML for display. GnuCash also adds hooks to > GtkHTML to handle the GoG images and

Major timezone breakage

2007-05-28 Thread Graham Leggett
Hi all, Having recently moved from ZA to the UK, I changed the timezone on my laptop to match, moving the timezone back by 1 hour. All of a sudden, all the dates in my gnucash files were out by one day - invoices dated 1 March were now dated 28 February, which is in the previous VAT period a

Segfault in customer report on v2.0.5

2007-05-28 Thread Graham Leggett
Hi all, I have found a segfault in gnucash v2.0.5. When you select reports -> business -> customer report, and fill in the various details of which customer to report on, gnucash segfaults. It doesn't do it all the time, but does quite often. The backtrace is below. #0 gw__tmp438_xaccQueryA

Special version of automake required?

2007-06-12 Thread Graham Leggett
Hi all, I just tried to run autogen.sh to build the gda-dev tree, and I got the errors below. Is there a specific version of automake / autoconf needed to build gnucash? Machine-Of-Doom:~/src/gnucash/gda-dev minfrin$ ./autogen.sh Creating ./po/POTFILES.in ... Creating ./aclocal.m4 ... Running

Re: Special version of automake required?

2007-06-12 Thread Graham Leggett
Derek Atkins wrote: Running aclocal -I macros ... aclocal:configure.in:51: warning: macro `AM_GCONF_SOURCE_2' not found in library aclocal:configure.in:81: warning: macro `AM_GLIB_GNU_GETTEXT' not found in library aclocal:configure.in:229: warning: macro `AM_PATH_GLIB_2_0' not found in libra

Customer payments not working in v2.0.5

2007-08-02 Thread Graham Leggett
Hi all, Out of the blue, I have been having a problem with customer process payments with v2.0.5. Attempts to add a payment causes a transaction to be created, but the value on the transaction stays blank. This is regardless of what you type as the value when creating the payment, and it is

Re: Customer payments not working in v2.0.5

2007-08-02 Thread Graham Leggett
Derek Atkins wrote: Sounds like a Currency issue.. Make sure all the currencies are correct and THE SAME! Yes, all the currencies are the same, as they have been for the last 5 years. Digging further, it looks like an invoice belonging to the same customer is also showing up with blank va

Re: Customer payments not working in v2.0.5

2007-08-03 Thread Graham Leggett
On Fri, August 3, 2007 5:17 pm, Derek Atkins wrote: > If it's been working for the last five years then what changed between > the last time it worked and the when it stopped working? What caused the problem was a change made 3 months ago when I started a new business in a new country. The proble

The payment amount must be greater than zero

2007-08-19 Thread Graham Leggett
Hi all, I have been trying to make a note of a refund paid back from a vendor, and am trying to make a payment with a negative amount, but I get the error message: "you must enter the amount of the payment. The payment amount must be greater than zero" If you can't add a refund this way, i

Re: The payment amount must be greater than zero

2007-08-19 Thread Graham Leggett
Derek Atkins wrote: Create a new Vendor Bill; or unpost the previous vendor bill and put it there. At this point in time GnuCash does not support "Credit memos" (I guess this would be a "Debit memo" from a vendor). In this case, the vendor credited an invoice on a credit card, so unposting

Re: The payment amount must be greater than zero

2007-08-19 Thread Graham Leggett
Derek Atkins wrote: Unfortunately it's not THAT simple. From the UI, yes, but there are underlying assumptions that the UI is helping enforce. Entering a negative amount would break those underlying assumptions. What underlying assumptions? All cashflows can flow in either direction for any

Re: The payment amount must be greater than zero

2007-08-20 Thread Graham Leggett
On Mon, August 20, 2007 4:36 pm, Derek Atkins wrote: > See, this is where you're not quite right. Gnucash really is a little > schizophrenic here; it's not sure if it wants to be a Personal finance > program or a Small Business finance program. It's really trying to be > both. It's NOT trying t

Re: The payment amount must be greater than zero

2007-08-20 Thread Graham Leggett
Nigel Titley wrote: He does have a point though. Feature enhancements take time. None of us have enough time. Neither do the people who need the features, which is why the very first step is to ensure that no time is wasted - by asking the list whether there is a well understood reason for s

Re: r16624 - gnucash/trunk - Remove the spurious m4/ directory. Use macros/ instead.

2007-12-11 Thread Graham Leggett
Christian Stimming <[EMAIL PROTECTED]> writes: The whole point of cmake is that it will perform all those platform-checks (more precisely: host and target checks) which used to be done by the autoconf-generated shell scripts which nobody was able to understand. But the price for this is that c

Re: r16624 - gnucash/trunk - Remove the spurious m4/ directory. Use macros/ instead.

2007-12-11 Thread Graham Leggett
Christian Stimming wrote: I'm sorry, but the last part is some FUD that doesn't need to be redistributed any further. The KDE project explicitly states that already very early into the migration to cmake, it built on more platforms than it ever did with autotools. What kind of adoption does

Re: Building GnuCash 2.2.2 on Mac OS X without Fink or MacPorts

2008-01-09 Thread Graham Leggett
Jeshua Lacock wrote: We have thousands of users and no one has ever reported a problem using /tmp with various binaries. /tmp means exactly what it says on the tin: It's temporary. Don't put anything in /tmp that a user might expect to be permanent. Regards, Graham -- smime.p7s Descripti

Re: GDA referential integrity

2008-01-18 Thread Graham Leggett
Mark Johnson wrote: This would certainly cause very slow performance. Here are some sample table sizes to give you an idea of how much data I have in gnucash. I don't think it is especially large. I have seen some users post who have quite a few more years of data in gnucash than I. I sus

Re: GDA: empty PostgreSQL table failed workaround

2008-02-14 Thread Graham Leggett
Derek Atkins wrote: I think the question was more: Does every table have to HAVE a primary key? Yes, the primary key must be unique, but what if a table has no primary key? Is that still okay? It's perfectly ok, yes - but primary keys are used heavily for optimisation. Without them, perfor

Re: Feature request from German list: Disable editing of transactions

2008-02-15 Thread Graham Leggett
Christian Stimming wrote: Some German business users brought up a "feature" request that sounds a bit weird for a programmer: They asked for a gnucash mode of operation where the user can not edit older transactions anymore! Makes perfect sense - wearing my programmer hat on financial systems

Re: Feature request from German list: Disable editing of transactions

2008-02-16 Thread Graham Leggett
Christian Stimming wrote: Makes sense, but do you have any ideas how such a per-account setting can be implemented in the GUI? Currently, all per-account settings can be set in the "Edit Account" dialog. However, a setting "Make this an inalterable account" shouldn't be allowed to be disabled

Re: Feature request from German list: Disable editing of transactions

2008-02-16 Thread Graham Leggett
Thilo Pfennig wrote: I think from the acounting perspective every entry consists on som field like the date, the accounts, some text,... I also dont think a mix of inalterable accounts and alterable accounts makes much sense because every entry has two ends, so if one end is inalterable the othe

Re: GDA save missing records

2008-02-18 Thread Graham Leggett
Mark Johnson wrote: Do we really want "unlimited"? I've alluded to this question in the past, but I don't know if there's been a definitive answer. Speaking for myself, I really want unlimited. As the accounting system is most often the system data is sent to, rather than originated from, i

Re: Feature request from German list: Disable editing of transactions

2008-02-18 Thread Graham Leggett
Thilo Pfennig wrote: Maybe this is a misunderstanding but what I mean is that if I make an entry into the account "bank" I think this should still be visible, because only if it wont there would be an error. I think oen should distinct the real bank account and the bank account in GnuCash. Sure

Re: GDA save missing records

2008-02-18 Thread Graham Leggett
Keith Bellairs wrote: Speaking as a user and not someone busting his butt on this, I hate the idea of "unlimited" everything when we go to a DB. Most of our databases have a mechanism (BLOB/CLOB) to store really big things, usually at the cost of indexing or searching (other than with special

Re: GDA: string lengths (was Re: GDA save missing records)

2008-02-18 Thread Graham Leggett
Phil Longstaff wrote: Well, as I originally said, I can use a TEXT type which allows up to 64K byte strings. Although not unlimited, I assume this is long enough for everyone's purposes. MySQL stores them as 2byte length + chars. I will need to check that that libgda has some good method of

Re: GDA: string lengths (was Re: GDA save missing records)

2008-02-18 Thread Graham Leggett
Keith Bellairs wrote: I think that depends on the DB. Using VARCHAR at least gives the engine a chance to optimize storage. CHAR is good for truly fixed length strings. This is true, I mixed up the varchar with the char. Adding a limit to varchar is entirely arbitrary though, if the varchar c

Re: GDA Missing records in SQLite

2008-02-20 Thread Graham Leggett
Mark Johnson wrote: By examining which transactions, accounts, and splits were missing from SQLite (as compared to MySQL), I was able to determine that anything which had a single quote in a string (description, name, & memo fields) failed to be inserted into SQLite. This is a one-to-one cor

Re: GDA Missing records in SQLite

2008-02-24 Thread Graham Leggett
Phil Longstaff wrote: The providers allow it, GDA allows it, but not all of the GDA providers use the facilities. I couldn't find any sqlite3_bind_xxx() calls in the GDA sqlite provider, for example. I agree that the gda backend should change to using the libgda parameter functions, but I s

Re: GDA Missing records in SQLite

2008-02-24 Thread Graham Leggett
Phil Longstaff wrote: There is a function to query the backend to see what features it supports, but prepared statements is not in that list. Also, if we require prepared statements, that might cut out the sqlite backend because a libgda modification to use it might not propagate out far eno

Re: GDA Missing records in SQLite

2008-02-25 Thread Graham Leggett
Derek Atkins wrote: Except SQLite is a requirement. If we can't support SQLite then IMNSHO the project has failed. So by that, if we have to make a workaround to get SQLite working, we should. Note that we can always key the workaround code based on the version of gda we find when we build gn

Re: GDA Missing records in SQLite

2008-02-27 Thread Graham Leggett
Derek Atkins wrote: Umm.. I can't imagine ANY workaround that gnucash would perform that would silently break with a gda upgrade. The biggest example is a workaround to escape strings not already escaped through the use of prepared statements. There is no reliable way to detect whether prepa

Another attempt to build gda-dev2

2008-05-01 Thread Graham Leggett
Hi all, Just tried again to build gda-dev2, and again I am stuck at autogen.sh. README.dependencies lists lots of dependencies for various Linux distros, but makes no mention of fink for MacOSX 10.4, which is what I am trying to build for. Following the various instructions from here http:/

Export QSF: Bus error

2008-05-02 Thread Graham Leggett
Hi all, While trying to run export QSF (for invoices), gnucash v2.2.4 bombs out with the bus error like so: Program received signal EXC_BAD_ACCESS, Could not access memory. Reason: KERN_PROTECTION_FAILURE at address: 0x0028 qof_begin_edit (inst=0x6bd1a30) at qofinstance.c:897 897 qofin

Re: Another attempt to build gda-dev2

2008-05-07 Thread Graham Leggett
David Reiser wrote: One thing that will be a problem is that to build from svn, you need swig. Fink's swig (the guile parts, anyway) is based on guile 1.8, but there is no slib-guile for guile 1.8. What I did was to build my own version of swig in /opt, pointing it at guile 1.6 (via guile16-

Re: GDA: Status

2008-05-27 Thread Graham Leggett
Geert Janssens wrote: And I have been looking around, although I didn't migrate yet because of the huge effort it usually takes: there's * Compiere: it does ERP (enterprise resource planning), BPM (Business Project Management) and accounting. It's maintained by a company also called Compiere,

Re: gnucash automation

2008-05-27 Thread Graham Leggett
Christian Stimming wrote: What the developers here mean by "the gnucash API" is all the source code that lives in src/engine/, also known as "the engine" here. Most of it is documented by doxygen comments in the source code. The source code in src/engine depends on glib, but it does not depend

Re: GDA: Status

2008-05-28 Thread Graham Leggett
Derek Atkins wrote: Hahahahahahaha!! Wow, now you're REAY funny! Have you forgotten that GnuCash is a Volunteer effort? *laughs* "Users"? Come across to Apache sometime. We take our users seriously over there. Regards, Graham -- smime.p7s Description: S/MIME Cryptographic Signa

Re: GDA: Status

2008-05-29 Thread Graham Leggett
Derek Atkins wrote: Hahahahahahaha!! Wow, now you're REAY funny! Have you forgotten that GnuCash is a Volunteer effort? *laughs* "Users"? Come across to Apache sometime. We take our users seriously over there. Last I checked Apache had a whole big funded foundation backing their

Re: GDA: Status

2008-05-30 Thread Graham Leggett
Derek Atkins wrote: A Process Payment gives you that "Negative" number. What you would do is Process Payment to, say, your checking account. Then after the transaction gets posted you can go in and change it from Checking to Income. Make sure you only change the account, not the AMOUNT. Chang

Re: GDA: Status

2008-05-31 Thread Graham Leggett
Derek Atkins wrote: Unfortunately it's not that easy. That check is in there because the underlying code uses the Value + AccountType to determine if this is an "Invoice" or a "Payment". All the linkage logic is based on the invariant that an Invoice is "positive" and a Payment is "negative"

Re: GDA: Status

2008-05-31 Thread Graham Leggett
Nathan Buchanan wrote: 2. Use GDA V4. We will probably send time fixing bugs here, but we are almost guaranteed that a release will happen. The advantages of this approach is that we will be current with the new GDA and releases will be done for us (or in conjunction with us - depending on how c

Re: GDA: Status

2008-06-01 Thread Graham Leggett
Derek Atkins wrote: gncInvoice.c in particular the code that implements the invoice and payment processing and the balancing code to make sure payment are split across invoices properly. I have found that the current implementation of this particular functionality doesn't work that well, as

Re: GDA: Status

2008-06-01 Thread Graham Leggett
Derek Atkins wrote: Eh? I receive a bill from my vendor. It's not due for another 20 days. I enter it into gnucash and then later on pay it. Some vendors are COD only, which means the payment will almost always come before the invoice. Or the payment is captured before the bill is captur

Gnucash XAC file XSDs

2008-06-01 Thread Graham Leggett
Hi all, In order to parse the gnucash XAC file from java, I have generated the following XSD files using Trang called from Oxygen XML. The XSD was generated from my company's XAC file, with additional entries added to make sure none of the fields were missed. While it works for me so far, it

Re: Gnucash XAC file XSDs

2008-06-01 Thread Graham Leggett
Josh Sled wrote: How does this reconcile with the hand-generated Relax-NG schema in ? An attempt to convert it with trang throws the following errors: Severity and DescriptionPathResourceLocation Creation Time Id [Xerces] cos-element-consistent: Error for type '#

Re: time_t

2008-07-15 Thread Graham Leggett
Nathan Buchanan wrote: I guess the real question is - can we wait a couple years for a 64 bit time_t? Probably, I think. Are there any systems in wide use that aren't yet 64 bit time_t? I was under the impression that OSes had already changed. A quick look under MacOSX Leopard shows time_t

Re: time_t

2008-07-15 Thread Graham Leggett
Nathan Buchanan wrote: I'm a bit out of my league here...but I believe a long (or long int) is defined to be a minimum of 32 bits - so if you're still using a 32 bit system(?) (or processor?) you may still get a 32 bit time_t. You're right - the 64 bit RHEL5 system showed sizeof(time_t) to be

Re: time_t

2008-07-15 Thread Graham Leggett
Derek Atkins wrote: Different database engines have different column types for storing dates/times, so I'm using a 'MMDDHHMMSS' char string. ... in what timezone?Do you always convert to UTC? The current XML file doesn't convert to UTC, and as a result my computer is stuck in the UT

Re: time_t

2008-07-15 Thread Graham Leggett
Derek Atkins wrote: I think this is being caused by dates that are actually dates and not times, being stores as times. You think incorrectly. There are LOTS of reasons to store times in transactions. There ARE timestamps in the real world. And there are reasons that some people want to act

Re: time_t

2008-07-16 Thread Graham Leggett
Derek Atkins wrote: These rules can certainly vary from place to place, locale to locale, or even person to person. Why force the issue? Because the consequences can be expensive. I was lucky in that I found and located the source of the problem relatively quickly. Had I not found it, I wo

  1   2   >