Re: errir in SQL syntax

Does that happen when you try to save from within gnucash? Colin On 18 Dec 2017 7:19 a.m., "Wolfgang Paul Rauchholz" wrote: My config: Linux CENTOS 7, mariadb-5.5.56-2.el7.x86_64 Setting up the database on my home server. Will connect fomr laptops in the network onto

Re: Gnucash + mysql

On 18 Dec 2017 7:04 a.m., "wp.rauchholz" wrote: Is am trying to setup gnucash and access mysql on my homeserver. Is there a \cookbook' how to do this? I googled and there does not seem to be a lot Assuming you have setup your mysql server then check whether the File,

Re: errir in SQL syntax

You misspelled AUTO_INCREMENT (note the underscore character). On 2017-12-17 23:03, Wolfgang Paul Rauchholz wrote: > My config: > Linux CENTOS 7, mariadb-5.5.56-2.el7.x86_64 > > Setting up the database on my home server. Will connect fomr laptops in the > network onto mariadb. > > When trying

Re: MacOS 10.13.2 won't work with Gnucash

No, 2.6.18 didn't work either. I looked for the update when my existing version of Gnucash (2.6.17) just crashed. I admit I haven't used Gnucash for some time. ===Pat. M -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Gnucash + mysql

Is am trying to setup gnucash and access mysql on my homeserver. Is there a \cookbook' how to do this? I googled and there does not seem to be a lot Wolfgang -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

Re: export general ledger

On 17/12/2017 19:31, Jeff Abrahamson wrote: I'd like to export the general ledger to a csv file.  When I use File -> Export, however, I'm offered a choice of exporting income, expenses, assets, or liabilities.  But I'd like to have all transactions in the csv file. I think I see how to do this

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

Adrien, It seems to me that what you want is not an accounting solution but a software enhancement. I believe that you need to say exactly what you want in a bugzilla RFE. For the issue you describe below what seems to be required is a special version of scheduled transactions which will post a

Re: GnuCash 2.6.19 released

> On Dec 17, 2017, at 7:59 PM, Ken Pyzik wrote: > > John -- Have installed the new 2.6.19 version on Windows 10 (64-bit) - as > production. No issues to report. Thanks! Thanks. It’s always nice to get good news! Regards, John Ralls

Re: MacOS 10.13.2 won't work with Gnucash

> On Dec 17, 2017, at 7:32 PM, its...@gmail.com wrote: > > Hi, > > I have just installed Gnucash 2.16.19 on my Mac that is running High Sierra. > In spite of all my efforts, I cannot get Gnucash to load or even open > properly. I understand from previous posts about High Sierra issues that >

RE: GnuCash 2.6.19 released

John -- Have installed the new 2.6.19 version on Windows 10 (64-bit) - as production. No issues to report. Thanks! -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org] On Behalf Of John Ralls Sent: Sunday, December 17, 2017 2:54 PM To: Gnucash

Re: Has the Treasury Direct interface changed?

I'm using the bond quote grabbing code I wrote in 2012 which has been serving me faithfully since 2016-04-04. I am using https in the url, here's the full contents I get from the post request: Can't connect to www.treasurydirect.gov:443 (Connection refused) LWP::Protocol::https::Socket: connect:

MacOS 10.13.2 won't work with Gnucash

Hi, I have just installed Gnucash 2.16.19 on my Mac that is running High Sierra. In spite of all my efforts, I cannot get Gnucash to load or even open properly. I understand from previous posts about High Sierra issues that when the latest stable version of Gnucash is installed, the libraries are

Re: Has the Treasury Direct interface changed?

> On Dec 17, 2017, at 3:17 PM, farleykj wrote: > > Well, it appears that the only data being returned by quote requests is: > > "Can't connect to www.treasurydirect.gov:80 (Connection refused)" > > Don't have any idea why - my Perl experience is rather limited. Definitely

Re: Has the Treasury Direct interface changed?

Well, it appears that the only data being returned by quote requests is: "Can't connect to www.treasurydirect.gov:80 (Connection refused)" Don't have any idea why - my Perl experience is rather limited. Definitely throws a wrench into the works for me, though. - Ken Farley -- Sent from:

GnuCash 2.6.19 released

Announcement: GnuCash 2.6.19 Release 2017-12-16 GnuCash 2.6.19 released The GnuCash development team announces GnuCash 2.6.19, the nineteenth maintenance release in the 2.6-stable series. Changes Between 2.6.18 and 2.6.19, the following bugfixes were accomplished: Bug 787497 - Disabling

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

Dale, Thank you, but in my case the first event to happen (for me) is the bill arriving. Here is the sequence: 1) Renewal bill is generated 2) Renewal bill is mailed 3) Renewal bill arrives in the mailbox 4) Renewal bill is entered in GnuCash with date of #1 as ‘opening date' 5) Renewal bill

export general ledger

I'd like to export the general ledger to a csv file.  When I use File -> Export, however, I'm offered a choice of exporting income, expenses, assets, or liabilities.  But I'd like to have all transactions in the csv file. I think I see how to do this using python (the example script

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

Mike, There are several dates at issue, but the main one I’m concerned with is ‘a’ or ‘when work done’. The problem is that this date infrequently occurs in the same period as either the real or effective date of the invoice/bill, or the date you open/post it in GnuCash. Receiving, creating

Re: gnucash not updating mutual funds

Make sure you are running F::Q 1.45 or higher. Then change to yahoo json or alphavantage quote source. -derek Sent using my mobile device. Please excuse any typos. On December 17, 2017 11:20:27 AM david amaral via gnucash-user wrote: gnucash was working fine

gnucash not updating mutual funds

gnucash was working fine and now has stopped updating my investments in mutual funds.i am getting the error message:there was an unknown errorwhile receiving the price quote These are the version numbers i am working with.Ubuntu 16.04 LTSGnucash 2.6.12Perl5 v5.22.1 I have looked thru some