Re: Does anyone successfully use GNU Android App. If not get it off the main web site.

[cicko]

John, you do not necessarily have to use the GnuCash for Android app to
achieve what you want. You can use practically any app that will export
transactions into a .qif file. For example, I'm using Money Manager Ex for
Android (to which I also contribute in development, just like with GnuCash
for Android) but anything that creates a valid .qif file will work. You
could try another app untill the issues you mention are resolved. Make sure
that you submit a bug report with a reproducible case, though.
You can also check the exported .qif file with a text editor and see if the
values are really there.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Adrien Monteleone]

I’m not sure I’d say ‘whatever’ the users request, certainly any software is a 
product of the developers and such things are their choice. Being open source 
as GnuCash is, if you find fundamental disagreement on that point, you can 
fork. But I’ve found the GnuCash developers to be very amenable to change (they 
have lots in the works themselves) but their resources are very limited and 
outside of squashing bugs their priority right now is behind the scenes stuff. 
The reason for that is once they get the code modernized and structured the way 
they need it, they’ll be able to open up much more possibility for new features 
and reporting.

The reason I used the term ‘template’ was that the already existing ‘scheduled’ 
transactions are already ‘triggered.’ It’s just that they trigger on a date, 
not an event like adding a particular kind of transaction or in a particular 
account. Scheduled transactions already use templates and those are saved. It’s 
the ‘fire on demand’ rather than ‘fire on a schedule’ functionality I think 
will be needed to better implement the savings mechanisms we’re discussing.

And yes, one can always spend funds at any time out of an account those funds 
don’t reside in, but as you see, that either requires at least two extra 
splits, or a separate transfer transaction prior to the expense transaction. 
Avoiding doing so not only keeps the visual clutter down and confusion to a 
minimum but also is part of enforcing the savings plan in the first place.

Regards,
Adrien

> On Jan 28, 2018, at 7:25 PM, Matt Graham  wrote:
> 
> Agree with your other email! A program should entertain whatever users are 
> requesting for better functionality. Of course, open source volunteer 
> developers can't be expected to drop everything to implement "my awesome 
> idea". Hence why I'm going to try to contibute (sigh, always need more time).
> 
> Template transactions (I'd probably call them "Triggerred transactions", but 
> it doesn'tmatter) sound awesome. As someone else highlighted, there are 
> implementation difficulties to consider, but I dont think that it would be 
> too onerous.
> 
> In terms of spending from another account but recording against a 
> sub-account, its easy:
> Dr Exp whatever account
> Cr Cash I pay for something awesome
> Dr Parent account the amount I paid
> Cr sub-account the amount I paid
> 
> This is (like all of our segregating money transactions) a virtual one, but 
> it wont affect your reconciling (because as discussed previously we are 
> reconciling by the parent and including sub-accounts).
> Hmmm now that I re-read your email, I think you might have meant this 
> already. Sorry!
> 
> Thanks and regards,
> Matt
> 
> 
>  Original message 
> From: Adrien Monteleone  > 
> Date: 28/1/18 15:33 (GMT+10:00) 
> To: GNU Cash User  > 
> Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets] 
> 
> You can already use formulas in scheduled transactions, I just don’t think 
> you can use a present GC register value as a variable. (such as x% of the 
> balance of Assets:Checking) I could be wrong. It should be possible though to 
> use the value of one split as a variable so some auto-allocation might be 
> possible.
> 
> There’s also the issue with triggering the transaction based on an event 
> other than a date stamp. (such as triggering after you post a credit to 
> income or a debit to an checking account)
> 
> What we really need there isn’t so much a Scheduled Transaction but a 
> Template Transaction. (that can retain formulas)
> 
> As for keeping accounts straight, if someone in the real world wants to spend 
> money from a savings account by writing a check on their checking account - 
> that’s physically impossible. (barring auto adjusting as overdraft 
> protection) I don’t see why GnuCash should be any different. Trying to make 
> that possible I think would lead to all sorts of confusion as to where money 
> came from or where it should be. To help reduce the tendency to do so, I 
> suggested splitting up the sub-accounts based on where you are most likely to 
> draw funds from for those particular purposes. Otherwise, you’d have to do a 
> transfer from say ‘Savings’ to ‘Checking’ in GnuCash first just like you 
> would in the real world. But if you’re in the habit of spending from any ole’ 
> source for any ole’ purpose then by all means, keep the sub-accounts 
> separate, you’ll just have to include the transfer split in the expense 
> transaction or else do a separate transfer transaction.
> 
> Regards,
> Adrien
> 
> > On Jan 27, 2018, at 9:25 PM, Matt Graham  > > wrote:
> > 
> > Nice! It seems like we are getting somewhere. I am convinced that the 
> > process we think of budgeting where we are 

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Adrien Monteleone]

Matt,

What Mike was talking about with Liabilities was with respect to ‘reserve’ or 
‘restricted’ funds. In the case of non-profits taking donations that can be 
earmarked
those funds have to be legally separated and cannot be used for any desired 
purpose.

As well, ‘deposits’ which are pre-payments set aside for particular purpose 
can’t be thrown into a general funds pool. (you might have to refund them if 
you don’t deliver the requested goods or services)

But both of those cases are real life liabilities.

The funds don’t ‘belong’ to whomever received them unless and until they are 
used for the appropriate purpose.

While what we are discussing is somewhat similar in concept, in real life, 
there is no actual liability incurred by not wanting to spend all you have and 
not save for vacation or the occasional night on the town, so using that type 
of account, while mathematically possible, isn’t necessarily the best idea to 
model what’s going on in the real world.

Regards,
Adrien

> On Jan 28, 2018, at 7:11 PM, Matt Graham  wrote:
> 
> :-) you missed one of the previous posts. Using Liability accounts that way 
> is adding anoter "layer" of accounting to your system. When you look at what 
> liabilities really are, Adrien and I concluded on this thread that this 
> situation (segmenting money for future) is really using a separate asset 
> account. After all - creating a liability INCREASES your cash available. 
> However, shifting it to another asset account (either sub-account or 
> completely different area) reduces cash available AND allows you to record 
> the increasing amount you have segmented. If I get a chance, I think I'll 
> type all this up with some examples (it is easier to show with exampes).
> 
> Thanks and regards,
> Matt
>  Original message 
> From: Mike or Penny Novack 
> Date: 29/1/18 00:51 (GMT+10:00)
> To: gnucash-user@gnucash.org
> Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]
> 
> On 1/27/2018 10:25 PM, Matt Graham wrote:
>> Nice! It seems like we are getting somewhere. I am convinced that the 
>> process we think of budgeting where we are saving up for something is really 
>> a case of segmenting money within a sub-account. And it looks like Gnucash 
>> is already happy with this kind of situation - with the include sub-accounts 
>> in the recociliation window.
> Not exactly. This is a case where the term "budgeting" is being used in
> different ways meaning different things. Budgets my be legal
> (organizations, government entities) or advisory (personal, business)
> though of course businesses might have requirements to set aside funds
> << might be in the terms of a loan, etc. >>
> 
> ONE way of doing this is with liability accounts (typical -- account for
> amounts needed for taxes) but that method can also be used for "reserve
> funds" <<  I deal mainly with non-profits where "restricted funds" are
> common >>
> 
> Note that partitioning of a checking account in this way earlier
> described is still just "advisory" as it would NOT prevent you from
> writing a check for more than the balance remaining in the unrestricted
> portion of the account. Just you can't do that without seeing that you
> are doing it.
> 
> Michael D Novack
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7Cd653d44ededf436304a408d566563154%7C84df9e7fe9f640afb435%7C1%7C0%7C636527442736383577=2IRNnuUZ4u9Vu%2FEryYTBw6QSBfRJOx8OV0%2FBBYbZn%2BM%3D=0
> If you are using Nabble or Gmane, please see 
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7Cd653d44ededf436304a408d566563154%7C84df9e7fe9f640afb435%7C1%7C0%7C636527442736383577=sveoJ58ma1r3tnK4q1zqT5IuppYFxRlvmnJQrOj7g8E%3D=0
>  for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Matt Graham]

Agree with your other email! A program should entertain whatever users are 
requesting for better functionality. Of course, open source volunteer 
developers can't be expected to drop everything to implement "my awesome idea". 
Hence why I'm going to try to contibute (sigh, always need more time).

Template transactions (I'd probably call them "Triggerred transactions", but it 
doesn'tmatter) sound awesome. As someone else highlighted, there are 
implementation difficulties to consider, but I dont think that it would be too 
onerous.

In terms of spending from another account but recording against a sub-account, 
its easy:
Dr Exp whatever account
Cr Cash I pay for something awesome
Dr Parent account the amount I paid
Cr sub-account the amount I paid

This is (like all of our segregating money transactions) a virtual one, but it 
wont affect your reconciling (because as discussed previously we are 
reconciling by the parent and including sub-accounts).
Hmmm now that I re-read your email, I think you might have meant this 
already. Sorry!

Thanks and regards,
Matt


 Original message 
From: Adrien Monteleone 
Date: 28/1/18 15:33 (GMT+10:00)
To: GNU Cash User 
Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

You can already use formulas in scheduled transactions, I just don’t think you 
can use a present GC register value as a variable. (such as x% of the balance 
of Assets:Checking) I could be wrong. It should be possible though to use the 
value of one split as a variable so some auto-allocation might be possible.

There’s also the issue with triggering the transaction based on an event other 
than a date stamp. (such as triggering after you post a credit to income or a 
debit to an checking account)

What we really need there isn’t so much a Scheduled Transaction but a Template 
Transaction. (that can retain formulas)

As for keeping accounts straight, if someone in the real world wants to spend 
money from a savings account by writing a check on their checking account - 
that’s physically impossible. (barring auto adjusting as overdraft protection) 
I don’t see why GnuCash should be any different. Trying to make that possible I 
think would lead to all sorts of confusion as to where money came from or where 
it should be. To help reduce the tendency to do so, I suggested splitting up 
the sub-accounts based on where you are most likely to draw funds from for 
those particular purposes. Otherwise, you’d have to do a transfer from say 
‘Savings’ to ‘Checking’ in GnuCash first just like you would in the real world. 
But if you’re in the habit of spending from any ole’ source for any ole’ 
purpose then by all means, keep the sub-accounts separate, you’ll just have to 
include the transfer split in the expense transaction or else do a separate 
transfer transaction.

Regards,
Adrien

> On Jan 27, 2018, at 9:25 PM, Matt Graham  wrote:
>
> Nice! It seems like we are getting somewhere. I am convinced that the process 
> we think of budgeting where we are saving up for something is really a case 
> of segmenting money within a sub-account. And it looks like Gnucash is 
> already happy with this kind of situation - with the include sub-accounts in 
> the recociliation window.
>
> I'm going to try this out over the next week or so and then try to 
> contriubute to the Tutorial and concepts guide on it. It can get pretty 
> complicated (for beginners) when you segment the money in your savings 
> acount, and then want to spend out of cash/checking etc. Is a pretty common 
> thing that people want out of Gnucash.
>
> After trying it, I'll also be in a position to suggest any feature changes 
> that would make it easier. Hinted already by others is the feature of 
> "formula" based data entry - doing data entry a bit like a spreadsheet, where 
> simple equations can be used often based on the values present in other 
> accounts/transactions... I'll leave that for now and explore it in my next 
> big discussion with you all!
>
> Thanks again - greatly appreciate your time,
> Matt
>
>
>  Original message 
> From: Adrien Monteleone  >
> Date: 27/1/18 18:15 (GMT+10:00)
> To: GNU Cash User >
> Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]
>
> That’s an interesting use of future dated transactions. Thanks!
>
>
> Regards,
> Adrien
>
> > On Jan 26, 2018, at 5:21 PM, Tommy Trussell  > > wrote:
> >
> > I was following the budget discussion, and I decided to split my comment
> > into a different thread. I'm not responding to any particular comment, and
> > this isn't quite germane to budgeting.
> >
> > But I want to clear up a few misunderstandings I'm seeing folks express
> > about 

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Matt Graham]

:-) you missed one of the previous posts. Using Liability accounts that way is 
adding anoter "layer" of accounting to your system. When you look at what 
liabilities really are, Adrien and I concluded on this thread that this 
situation (segmenting money for future) is really using a separate asset 
account. After all - creating a liability INCREASES your cash available. 
However, shifting it to another asset account (either sub-account or completely 
different area) reduces cash available AND allows you to record the increasing 
amount you have segmented. If I get a chance, I think I'll type all this up 
with some examples (it is easier to show with exampes).

Thanks and regards,
Matt
 Original message 
From: Mike or Penny Novack 
Date: 29/1/18 00:51 (GMT+10:00)
To: gnucash-user@gnucash.org
Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

On 1/27/2018 10:25 PM, Matt Graham wrote:
> Nice! It seems like we are getting somewhere. I am convinced that the process 
> we think of budgeting where we are saving up for something is really a case 
> of segmenting money within a sub-account. And it looks like Gnucash is 
> already happy with this kind of situation - with the include sub-accounts in 
> the recociliation window.
Not exactly. This is a case where the term "budgeting" is being used in
different ways meaning different things. Budgets my be legal
(organizations, government entities) or advisory (personal, business)
though of course businesses might have requirements to set aside funds
<< might be in the terms of a loan, etc. >>

ONE way of doing this is with liability accounts (typical -- account for
amounts needed for taxes) but that method can also be used for "reserve
funds" <<  I deal mainly with non-profits where "restricted funds" are
common >>

Note that partitioning of a checking account in this way earlier
described is still just "advisory" as it would NOT prevent you from
writing a check for more than the balance remaining in the unrestricted
portion of the account. Just you can't do that without seeing that you
are doing it.

Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7Cd653d44ededf436304a408d566563154%7C84df9e7fe9f640afb435%7C1%7C0%7C636527442736383577=2IRNnuUZ4u9Vu%2FEryYTBw6QSBfRJOx8OV0%2FBBYbZn%2BM%3D=0
If you are using Nabble or Gmane, please see 
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7Cd653d44ededf436304a408d566563154%7C84df9e7fe9f640afb435%7C1%7C0%7C636527442736383577=sveoJ58ma1r3tnK4q1zqT5IuppYFxRlvmnJQrOj7g8E%3D=0
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [MAINT] Planned server downtime today, 1700 US/EST

[Derek Atkins]

This maintenance is complete.
Please let me know if you have any issues.

-derek

On Sun, January 28, 2018 12:13 pm, Derek Atkins wrote:
> Hi,
>
> I need to take the gnucash server (code) down today to relocate it and
> rebalance UPS systems.  The total downtime should be less than 30
> minutes, with MOST of that time being spent taking the system down and
> waiting for it to boot back up.  I plan to start the take-down around
> 1700 US/EST, after I do some physical prepartions.
>
> I'll notify #gnucash/IRC before I take the server down, and I'll send
> mail when everything is back up.
>
> Please let me know if this is an issue; I can shift it around a little
> as necessary, but I DO need to move the servers today.
>
> Thanks!
>
> -derek
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Fwd: Android to Desktop

[Dave H]

Mike,

Take a look at https://github.com/codinguser/gnucash-android and the
support site at  https://plus.google.com/communities/104728406764752407046
if you want details/support for the Gnucash Android app.  The support site
which mentions the double minus signs in QIF export among other things -
see below.

As it says version 2.3.0 if that's what you are running is beta software
apparently so use with caution :-)

Also XML files are usually just text files which if all else fails you can
open with a text editor to see if there's anything strange looking in the
file.

Cheers Dave H.


[image: Inline images 1]

On 29 January 2018 at 07:57, Mike Stillingfleet <
mikestillingfl...@fastmail.co.uk> wrote:

> Ok so this is interesting done the upgrade.  The first thing I notice
> is that the individual account balances are still wrong but now instead
> of being completely random amounts they are a signed sum of the
> entries, regardless of DR/CR, as opposed to correct balance on the
> account. I.e. positive for assets negative for expenses. That is at
> least some progress.
> Overall the total Asset figure equals the total expense figure.
>
> I will attempt an export and see what happens.
>
>
> On Sun, Jan 28, 2018, at 6:10 PM, Di Mang wrote:
> > Hi Mike,
> > which version of android app do you use?
> > There was a bug in android app befor version 2.3.0 with a double minus
> > sign in QIF and XML export files.> This bug was fixed in the version
> 2.3.0 (on 9th January 2018). You can
> > check it in your QIF or XML export files by searching for "--".> In this
> case you can remove all entries "--" and import the file into
> > GnuCash. But please make the BACKUP files before you test it.> DM
> >
> > 2018-01-28 16:23 GMT+01:00 John Ralls :
> >>
> >>
> >> > On Jan 28, 2018, at 3:45 AM, Mike Stillingfleet
> >> >  wrote:
> >>  >
> >>  > Hi,
> >>  >
> >>  > I have exported my Android Transactions from Android to a QIF and
> >>  > then attempted to import them into the desktop.
> >>  >
> >>  > It says Transaction amount: Unrecognised or inconsistent format.
> >>  >
> >>  > When I exported from Android to XML and opened that various values
> >>  > where blank.
> >>  >
> >>  > When I look up those transactions on android they are not blank.
> >>  >
> >>  > When I reduce the amount of data passed over it opens and imports
> >>  > the file. I assume because these "blank transactions are omitted.
> >>  >
> >>  > Any ideas as to how this can be corrected??
> >>  >
> >>  > I have a lot of data to transfer.
> >>
> >> Sorry, not here. GnuCash for Android is a separate project developed
> >> by a Google Summer-of-Code student, Ngewi Fet, several years ago. He
> >> does support through a Google+ community [1] and takes bug reports
> >> through the Github page [2] and Uservoice [3].>>
> >>  Regards,
> >>  John Ralls
> >>
> >>  [1] https://plus.google.com/communities/104728406764752407046
> >>  >>
> [2] https://github.com/codinguser/gnucash-android
> >>  >>  [3]
> https://gnucash.uservoice.com/forums/320493-gnucash-android
> >>  >>
> >>
> >> ___
> >>  gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >>  To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>  If you are using Nabble or Gmane, please see
> >>  https://wiki.gnucash.org/wiki/Mailing_Lists for more information.>>
> -
> >>  Please remember to CC this list on all your replies.
> >>  You can do this by using Reply-To-List or Reply-All.
>
> --
>   Mike Stillingfleet
>   mikestillingfl...@fastmail.co.uk
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Fwd: Android to Desktop

[Mike Stillingfleet]

Sadly no go on the export.  Everything exactly the same. No values in 70
% of the transactions.
Now whether this is because they were entered before the upgrade or what
I just don't know.
Give up for now.  This is not worth the effort.  Be quicker to  go back
to quill pens and ledger books.

On Sun, Jan 28, 2018, at 6:10 PM, Di Mang wrote:
> Hi Mike,
> which version of android app do you use?
> There was a bug in android app befor version 2.3.0 with a double minus
> sign in QIF and XML export files.> This bug was fixed in the version 2.3.0 
> (on 9th January 2018). You can
> check it in your QIF or XML export files by searching for "--".> In this case 
> you can remove all entries "--" and import the file into
> GnuCash. But please make the BACKUP files before you test it.> DM
> 
> 2018-01-28 16:23 GMT+01:00 John Ralls :
>>
>>
>> > On Jan 28, 2018, at 3:45 AM, Mike Stillingfleet
>> >  wrote:
>>  >
>>  > Hi,
>>  >
>>  > I have exported my Android Transactions from Android to a QIF and
>>  > then attempted to import them into the desktop.
>>  >
>>  > It says Transaction amount: Unrecognised or inconsistent format.
>>  >
>>  > When I exported from Android to XML and opened that various values
>>  > where blank.
>>  >
>>  > When I look up those transactions on android they are not blank.
>>  >
>>  > When I reduce the amount of data passed over it opens and imports
>>  > the file. I assume because these "blank transactions are omitted.
>>  >
>>  > Any ideas as to how this can be corrected??
>>  >
>>  > I have a lot of data to transfer.
>>
>> Sorry, not here. GnuCash for Android is a separate project developed
>> by a Google Summer-of-Code student, Ngewi Fet, several years ago. He
>> does support through a Google+ community [1] and takes bug reports
>> through the Github page [2] and Uservoice [3].>> 
>>  Regards,
>>  John Ralls
>> 
>>  [1] https://plus.google.com/communities/104728406764752407046
>>  >>  [2] 
>> https://github.com/codinguser/gnucash-android
>>  >>  [3] 
>> https://gnucash.uservoice.com/forums/320493-gnucash-android
>>  >> 
>> 
>> ___
>>  gnucash-user mailing list
>> gnucash-user@gnucash.org
>>  To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>  If you are using Nabble or Gmane, please see
>>  https://wiki.gnucash.org/wiki/Mailing_Lists for more information.>>  -
>>  Please remember to CC this list on all your replies.
>>  You can do this by using Reply-To-List or Reply-All.

--
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Fwd: Android to Desktop

[Mike Stillingfleet]

Ok so this is interesting done the upgrade.  The first thing I notice
is that the individual account balances are still wrong but now instead
of being completely random amounts they are a signed sum of the
entries, regardless of DR/CR, as opposed to correct balance on the
account. I.e. positive for assets negative for expenses. That is at
least some progress.
Overall the total Asset figure equals the total expense figure.

I will attempt an export and see what happens. 


On Sun, Jan 28, 2018, at 6:10 PM, Di Mang wrote:
> Hi Mike,
> which version of android app do you use?
> There was a bug in android app befor version 2.3.0 with a double minus
> sign in QIF and XML export files.> This bug was fixed in the version 2.3.0 
> (on 9th January 2018). You can
> check it in your QIF or XML export files by searching for "--".> In this case 
> you can remove all entries "--" and import the file into
> GnuCash. But please make the BACKUP files before you test it.> DM
> 
> 2018-01-28 16:23 GMT+01:00 John Ralls :
>>
>>
>> > On Jan 28, 2018, at 3:45 AM, Mike Stillingfleet
>> >  wrote:
>>  >
>>  > Hi,
>>  >
>>  > I have exported my Android Transactions from Android to a QIF and
>>  > then attempted to import them into the desktop.
>>  >
>>  > It says Transaction amount: Unrecognised or inconsistent format.
>>  >
>>  > When I exported from Android to XML and opened that various values
>>  > where blank.
>>  >
>>  > When I look up those transactions on android they are not blank.
>>  >
>>  > When I reduce the amount of data passed over it opens and imports
>>  > the file. I assume because these "blank transactions are omitted.
>>  >
>>  > Any ideas as to how this can be corrected??
>>  >
>>  > I have a lot of data to transfer.
>>
>> Sorry, not here. GnuCash for Android is a separate project developed
>> by a Google Summer-of-Code student, Ngewi Fet, several years ago. He
>> does support through a Google+ community [1] and takes bug reports
>> through the Github page [2] and Uservoice [3].>> 
>>  Regards,
>>  John Ralls
>> 
>>  [1] https://plus.google.com/communities/104728406764752407046
>>  >>  [2] 
>> https://github.com/codinguser/gnucash-android
>>  >>  [3] 
>> https://gnucash.uservoice.com/forums/320493-gnucash-android
>>  >> 
>> 
>> ___
>>  gnucash-user mailing list
>> gnucash-user@gnucash.org
>>  To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>  If you are using Nabble or Gmane, please see
>>  https://wiki.gnucash.org/wiki/Mailing_Lists for more information.>>  -
>>  Please remember to CC this list on all your replies.
>>  You can do this by using Reply-To-List or Reply-All.

--
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Transaction locking after a specified interval

[Paul Konnersman]

Thank you David C. and Adrien.

I'm embarrassed to find that it was already answered and I didn't find the
thread.

"File>Properties>Accounts: Day Threshold" does what I needed (OSX). 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Has the Treasury Direct interface changed?

[farleykj]

So, after trying different methods of communicating with the treasurydirect
site, I finally bit the bullet and updated my Perl modules (via a cpan
"upgrade" command) and the problem has been fixed. Don't know which module
was mucked up or how it got that way, but things are working fine, now. I
noticed when I checked on the versions of things (using the cpan "r"
command) that a lot of modules were pretty old. Perhaps they just "aged out"
of usefulness? I don't know.
A beneficial side effect of this is that after digging deep into my Perl
code to get quotes for E/EE/I bonds, it's a lot cleaner and perhaps a bit
easier to read. Well, as easy as Perl gets, I suppose.



-
Ken Farley
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Fwd: Android to Desktop

[Mike Stillingfleet]

I tried reading both the XML file with an XML file reader but it could
not open the file. Ditto QIF file. So that I could look for exactly this
kind of issue. I will attempt an update. And see what happens.

On Sun, Jan 28, 2018, at 6:10 PM, Di Mang wrote:
> Hi Mike,
> which version of android app do you use?
> There was a bug in android app befor version 2.3.0 with a double minus
> sign in QIF and XML export files.> This bug was fixed in the version 2.3.0 
> (on 9th January 2018). You can
> check it in your QIF or XML export files by searching for "--".> In this case 
> you can remove all entries "--" and import the file into
> GnuCash. But please make the BACKUP files before you test it.> DM
> 
> 2018-01-28 16:23 GMT+01:00 John Ralls :
>>
>>
>> > On Jan 28, 2018, at 3:45 AM, Mike Stillingfleet
>> >  wrote:
>>  >
>>  > Hi,
>>  >
>>  > I have exported my Android Transactions from Android to a QIF and
>>  > then attempted to import them into the desktop.
>>  >
>>  > It says Transaction amount: Unrecognised or inconsistent format.
>>  >
>>  > When I exported from Android to XML and opened that various values
>>  > where blank.
>>  >
>>  > When I look up those transactions on android they are not blank.
>>  >
>>  > When I reduce the amount of data passed over it opens and imports
>>  > the file. I assume because these "blank transactions are omitted.
>>  >
>>  > Any ideas as to how this can be corrected??
>>  >
>>  > I have a lot of data to transfer.
>>
>> Sorry, not here. GnuCash for Android is a separate project developed
>> by a Google Summer-of-Code student, Ngewi Fet, several years ago. He
>> does support through a Google+ community [1] and takes bug reports
>> through the Github page [2] and Uservoice [3].>> 
>>  Regards,
>>  John Ralls
>> 
>>  [1] https://plus.google.com/communities/104728406764752407046
>>  >>  [2] 
>> https://github.com/codinguser/gnucash-android
>>  >>  [3] 
>> https://gnucash.uservoice.com/forums/320493-gnucash-android
>>  >> 
>> 
>> ___
>>  gnucash-user mailing list
>> gnucash-user@gnucash.org
>>  To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>  If you are using Nabble or Gmane, please see
>>  https://wiki.gnucash.org/wiki/Mailing_Lists for more information.>>  -
>>  Please remember to CC this list on all your replies.
>>  You can do this by using Reply-To-List or Reply-All.

--
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Fwd: Android to Desktop

[Mike Stillingfleet]

Android 4.4.4.   GNUCASH App 2.2.1.

So the blank Value fields and the fact that none , f the account
balances reflect the transactions  entered under the account are known
issues that have now been fixed?

On Sun, Jan 28, 2018, at 6:10 PM, Di Mang wrote:
> Hi Mike,
> which version of android app do you use?
> There was a bug in android app befor version 2.3.0 with a double minus
> sign in QIF and XML export files.> This bug was fixed in the version 2.3.0 
> (on 9th January 2018). You can
> check it in your QIF or XML export files by searching for "--".> In this case 
> you can remove all entries "--" and import the file into
> GnuCash. But please make the BACKUP files before you test it.> DM
> 
> 2018-01-28 16:23 GMT+01:00 John Ralls :
>>
>>
>> > On Jan 28, 2018, at 3:45 AM, Mike Stillingfleet
>> >  wrote:
>>  >
>>  > Hi,
>>  >
>>  > I have exported my Android Transactions from Android to a QIF and
>>  > then attempted to import them into the desktop.
>>  >
>>  > It says Transaction amount: Unrecognised or inconsistent format.
>>  >
>>  > When I exported from Android to XML and opened that various values
>>  > where blank.
>>  >
>>  > When I look up those transactions on android they are not blank.
>>  >
>>  > When I reduce the amount of data passed over it opens and imports
>>  > the file. I assume because these "blank transactions are omitted.
>>  >
>>  > Any ideas as to how this can be corrected??
>>  >
>>  > I have a lot of data to transfer.
>>
>> Sorry, not here. GnuCash for Android is a separate project developed
>> by a Google Summer-of-Code student, Ngewi Fet, several years ago. He
>> does support through a Google+ community [1] and takes bug reports
>> through the Github page [2] and Uservoice [3].>> 
>>  Regards,
>>  John Ralls
>> 
>>  [1] https://plus.google.com/communities/104728406764752407046
>>  >>  [2] 
>> https://github.com/codinguser/gnucash-android
>>  >>  [3] 
>> https://gnucash.uservoice.com/forums/320493-gnucash-android
>>  >> 
>> 
>> ___
>>  gnucash-user mailing list
>> gnucash-user@gnucash.org
>>  To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>  If you are using Nabble or Gmane, please see
>>  https://wiki.gnucash.org/wiki/Mailing_Lists for more information.>>  -
>>  Please remember to CC this list on all your replies.
>>  You can do this by using Reply-To-List or Reply-All.

--
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Does anyone successfully use GNU Android App. If not get it off the main web site.

[Matt Graham]

I find the android app useful, exporting transactions by qif file and then 
bringing them into my desktop app. It is very limited, as you say. Really needs 
to implement proper access to the ".gnucash" files so that we can keep the two 
in sync easily.

Pretty sure that app is also open source on github, so the best way to get it 
improved is to help out, or donate/set bounties.

Having said all that, it would be ideal to have an "official" mobile version of 
GNUcash with as close as possible to full functionality. Hopefully using a 
large part of the desktop code (translated to Java for android though)
Coding party, anyone?

Thanks and regards,
Matt


 Original message 
From: jeffrey black 
Date: 29/1/18 07:12 (GMT+10:00)
To: john_mike , gnucash-user@gnucash.org
Subject: Re: Does anyone successfully use GNU Android App. If not get it off 
the main web site.

On 1/28/2018 8:31 AM, john_mike wrote:
> Dear All,
>
> I gave up trying to import the QIF file generated by the Android App.
>
> I exported from Android as XML then opened that file in GNU Cash. This had
> the dates of the transactions the narrative (well some of it) and the
> relevant accounts and about 30% of the values.
>
> I have nearly gone blind going through each transaction on my phone and
> entering the amount in the GNU Cash file.
>
> Now I need to work out how to import these completed transactions into my
> main file.
>
> I think I am done with the Android App. Every time I try to use it in messes
> up. It is therefore a huge waste of time.
>
> One of the reasons I started with GNU was the option of having the Android
> companion.
>
> Clearly it doesn't work. Clearly it was never intended to be a 'clone' of
> the main GNU Cash Application.
>
> Might I suggest that it is removed from the GNU Cash web site. It is
> detrimental to GNU Cash which by and large works. The Android App is just a
> huge waste of time.
>
> I wondered if there is any intention to create an App that works.
>
> All I wish to do is record stuff on the phone and load it to the PC. Is this
> possible / achievable.
>
> What I don't want is to spend time recording stuff on my phone and then
> spend 3-4 days transferring it across as that is completely pointless and
> very frustrating. It would be much better to remove the current offering
> from the system as it is setting a false user expectation. Which it turn
> leads to mistrust of GNU Cash.
>
>
>
>
> --
> Sent from: 
> https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgnucash.1415818.n4.nabble.com%2FGnuCash-User-f1415819.html=02%7C01%7C%7Cbd466c05436a48f13b8008d5668b7b25%7C84df9e7fe9f640afb435%7C1%7C0%7C636527671605334518=KJJZ1IZM9TtHb4ZGAQvB7q7BoxVmbU9XwNp00kb%2BI%2FM%3D=0
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7Cbd466c05436a48f13b8008d5668b7b25%7C84df9e7fe9f640afb435%7C1%7C0%7C636527671605334518=qK9uN7vSV%2FTBz2fotCUC9kAI4X6KhjQFUIeIs2OUJoo%3D=0
> If you are using Nabble or Gmane, please see 
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7Cbd466c05436a48f13b8008d5668b7b25%7C84df9e7fe9f640afb435%7C1%7C0%7C636527671605334518=lWeKmb9NHUQcB33%2B7vafWZEw9UeqtT6cvb7LwZ4EovE%3D=0
>  for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> .
>
I use the Android app on my LG phone.  For me it works wonderfully.  It
does lack a few features of  GnuCash on the desktop.  Most notably Check
number.  And it requires a little getting used to for doing split
transactions.

I do need to trim my account list on the phone, I have all of my
accounts in the app.  I don't really need accounts like depreciation
while pumping gas.  The really nice thing is I can log my transactions
as I do them rather than reading a bunch of crumpled up receipts at the
end of the week.

All I do is export the app data to a qif file and use the usb port to
transfer it to my desktop.  Never had a problem with it. I have never
tried exporting as xml.

Keep in mind the android app is an entirely separate product, developed
by a different group.


--JEffrey Black M.B.A.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7Cbd466c05436a48f13b8008d5668b7b25%7C84df9e7fe9f640afb435%7C1%7C0%7C636527671605334518=qK9uN7vSV%2FTBz2fotCUC9kAI4X6KhjQFUIeIs2OUJoo%3D=0
If you are using 

Re: Transaction locking after a specified interval

[David Carlson]

see the thread called Transactions Locked starting 1/31/2016 and look for
my answer in early February

David C

On Sun, Jan 28, 2018 at 12:43 PM, Paul Konnersman 
wrote:

> When setting up Gnucash I choose to lock all transactions older than 90
> days.
> These accounts are not audited. I now find 90 days to be inconveniently
> short and would like to lengthen the period during which I can edit
> transactions.
>
> Can anybody suggest a way to remove or reset this parameter? I am prepared
> to start over if I have to.
>
> Paul
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Does anyone successfully use GNU Android App. If not get it off the main web site.

[jeffrey black]

On 1/28/2018 8:31 AM, john_mike wrote:
> Dear All,
>
> I gave up trying to import the QIF file generated by the Android App.
>
> I exported from Android as XML then opened that file in GNU Cash. This had
> the dates of the transactions the narrative (well some of it) and the
> relevant accounts and about 30% of the values.
>
> I have nearly gone blind going through each transaction on my phone and
> entering the amount in the GNU Cash file.
>
> Now I need to work out how to import these completed transactions into my
> main file.
>
> I think I am done with the Android App. Every time I try to use it in messes
> up. It is therefore a huge waste of time.
>
> One of the reasons I started with GNU was the option of having the Android
> companion.
>
> Clearly it doesn't work. Clearly it was never intended to be a 'clone' of
> the main GNU Cash Application.
>
> Might I suggest that it is removed from the GNU Cash web site. It is
> detrimental to GNU Cash which by and large works. The Android App is just a
> huge waste of time.
>
> I wondered if there is any intention to create an App that works.
>
> All I wish to do is record stuff on the phone and load it to the PC. Is this
> possible / achievable.
>
> What I don't want is to spend time recording stuff on my phone and then
> spend 3-4 days transferring it across as that is completely pointless and
> very frustrating. It would be much better to remove the current offering
> from the system as it is setting a false user expectation. Which it turn
> leads to mistrust of GNU Cash.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> .
>
I use the Android app on my LG phone.  For me it works wonderfully.  It 
does lack a few features of  GnuCash on the desktop.  Most notably Check 
number.  And it requires a little getting used to for doing split 
transactions.

I do need to trim my account list on the phone, I have all of my 
accounts in the app.  I don't really need accounts like depreciation 
while pumping gas.  The really nice thing is I can log my transactions 
as I do them rather than reading a bunch of crumpled up receipts at the 
end of the week.

All I do is export the app data to a qif file and use the usb port to 
transfer it to my desktop.  Never had a problem with it. I have never 
tried exporting as xml.

Keep in mind the android app is an entirely separate product, developed 
by a different group.


--JEffrey Black M.B.A.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Transaction locking after a specified interval

[David Reiser]

> On Jan 28, 2018, at 1:43 PM, Paul Konnersman  wrote:
> 
> When setting up Gnucash I choose to lock all transactions older than 90 days.
> These accounts are not audited. I now find 90 days to be inconveniently
> short and would like to lengthen the period during which I can edit
> transactions.
> 
> Can anybody suggest a way to remove or reset this parameter? I am prepared
> to start over if I have to.
> 
> Paul
> 


That setting appears under File>Properties>Accounts. I have never set it on my 
files, so I don’t know whether gnucash will complain if you change it.
--
Dave Reiser
dbrei...@icloud.com





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Adrien Monteleone]

David,

Generally yes, the basic math operations in the register are sufficient for 
most daily needs.

I also agree that an accounting package tracks real transactions.

I don’t agree that an accounting package can’t include features of financial 
management together with the accounting features so that you don’t have to 
enter data twice in two separate (or more) pieces of software and so that you 
can see your entire financial picture in one place. (or have to finagle exports 
and imports between the two) I see the purpose of accounting is to make 
financial decisions. Budgeting, savings goals, investment plans and such are 
all financial decisions that all have real transactions at their base. To me, 
these are integrally linked and requiring a separation in software packages 
would be an artificial limitation that just duplicates work and increases the 
chance of data entry error. (And I don’t mean that anyone presently requires 
GnuCash to be accounting of past transactions only - the other functionality 
just isn’t there yet)

Following your line, the business features should be removed because 
‘invoicing’, ‘receivables’  and ‘payables’ isn’t ‘accounting’ and that people 
should use a separate Invoicing-AR/AP management system and export the 
accounting entries from that package into GnuCash.

With regards to formulas in transactions, I think we can get most of the way 
there with Template Transactions. I would suspect the code used for Scheduled 
Transactions would be sufficient with minor tweaks. Instead of these 
transactions firing on a date stamp, they fire when you tell them to. You might 
have to fill in one or two of the split amounts, but the rest of the splits 
would auto calculate based on those entries.

This might also be accomplished with a tweak to the Transfer window code. (As 
that’s the main need for this purpose anyway) Options could be added to split 
the transfer amongst multiple accounts with each one being a formula using the 
first split as a variable. (say a credit to checking with debit splits at 10%, 
5%, and 8.3% of that credit to each of three particular sub-accounts of 
checking)

I also don’t think that most of what’s been discussed here is really budgeting. 
Budgeting is a spending plan. This isn’t a plan, it’s a way to keep to that 
plan. In order to do that, one needs to have a savings plan or a way to enforce 
the spending plan so funds are available for their budgeted purposes. One very 
effective and proven method of doing so is by segregating funds either 
physically or virtually. I can only imagine the trouble one would have to go 
through to maintain a spreadsheet just for the purpose of segregating funds and 
having to do double data entry of real transactions to keep both systems 
current.


Regards,
Adrien

> On Jan 27, 2018, at 11:11 PM, D  wrote:
> 
> I'm glad you're going to look at documenting your suggestions in the 
> Tutorial. I imagine they would fit as a special section in the budgets 
> chapter.
> 
> As for the idea of having formulas active in the register, I think that there 
> are a number of issues that need consideration and addressing.
> 
> First, when entering transactions, you already can enter numeric formulas 
> (35/57), and Gnucash will calculate these. If I am entering transactions for 
> real accounting events, then that is all I really need, it seems to me. 
> Calculations with variables would only arise for future, tentative 
> transactions. But entering future, tentative transactions goes counter to the 
> idea that an accounting package tracks real transactions--using real 
> money--rather than potential transactions. This has been where such 
> discussions have foundered in the past on these lists. The scheduled 
> transactions module attempts to finesse this by allowing formulas which are 
> processed separately, and which create real transactions at specified points 
> in time.
> 
> I imagine also that activating variable-based calculations into the register 
> itself would require some serious reprogramming, and I do not know how likely 
> that is to happen. I have read here that the register code is challenging to 
> work with, and that an attempt to update the register has stalled.
> 
> Personally, I have come to believe that budgeting is fundamentally different 
> from accounting, and keep them separate. I use a spreadsheet to track the few 
> areas I choose to budget, and have a report in Gnucash that gives me usage 
> numbers for those areas, which I transfer over manually. Gnucash's budget 
> tools always hurt too much for my brain.
> 
> David
> 
> On January 28, 2018, at 8:27 AM, Matt Graham  
> wrote:
> 
> Nice! It seems like we are getting somewhere. I am convinced that the process 
> we think of budgeting where we are saving up for something is really a case 
> of segmenting money within a sub-account. And it looks like Gnucash is 
> already happy with this kind of 

Fwd: Android to Desktop

[Di Mang]

Hi Mike,

which version of android app do you use?

There was a bug in android app befor version 2.3.0 with a double minus sign
in QIF and XML export files.
This bug was fixed in the version 2.3.0 (on 9th January 2018). You can
check it in your QIF or XML export files by searching for "--".
In this case you can remove all entries "--" and import the file into
GnuCash. But please make the BACKUP files before you test it.

DM

2018-01-28 16:23 GMT+01:00 John Ralls :

>
>
> > On Jan 28, 2018, at 3:45 AM, Mike Stillingfleet <
> mikestillingfl...@fastmail.co.uk> wrote:
> >
> > Hi,
> >
> > I have exported my Android Transactions from Android to a QIF and then
> attempted to import them into the desktop.
> >
> > It says Transaction amount: Unrecognised or inconsistent format.
> >
> > When I exported from Android to XML and opened that various values where
> blank.
> >
> > When I look up those transactions on android they are not blank.
> >
> > When I reduce the amount of data passed over it opens and imports the
> file. I assume because these "blank transactions are omitted.
> >
> > Any ideas as to how this can be corrected??
> >
> > I have a lot of data to transfer.
>
> Sorry, not here. GnuCash for Android is a separate project developed by a
> Google Summer-of-Code student, Ngewi Fet, several years ago. He does
> support through a Google+ community [1] and takes bug reports through the
> Github page [2] and Uservoice [3].
>
> Regards,
> John Ralls
>
> [1] https://plus.google.com/communities/104728406764752407046 <
> https://plus.google.com/communities/104728406764752407046>
> [2] https://github.com/codinguser/gnucash-android <
> https://github.com/codinguser/gnucash-android>
> [3] https://gnucash.uservoice.com/forums/320493-gnucash-android <
> https://gnucash.uservoice.com/forums/320493-gnucash-android>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Does anyone successfully use GNU Android App. If not get it off the main web site.

[Di Mang]

Hello john_mike,

i use gnucash android app. It is very helpful for me.
I use it to enter the expenses immediately (on-the-fly) and transfer it one
time per month into desktop version (as QIF export).

I had problems with it a month ago: there was a bug in android app bevor
version 2.3.0 with double minus sign.
But now everything works fine.

DM

2018-01-28 17:13 GMT+01:00 David Carlson :

> Have you sent a comment to
> https://plus.google.com/communities/104728406764752407046??
>
> While i do not use the app myself, I believe that it is actively developed
> and should not be mis-behaving like you describe.
>
> I see there that there is currently a buggy beta release floating around.
> Perhaps you got that by mistake.
>
> David C
>
> On Sun, Jan 28, 2018 at 8:31 AM, john_mike  co.uk
> > wrote:
>
> > Dear All,
> >
> > I gave up trying to import the QIF file generated by the Android App.
> >
> > I exported from Android as XML then opened that file in GNU Cash. This
> had
> > the dates of the transactions the narrative (well some of it) and the
> > relevant accounts and about 30% of the values.
> >
> > I have nearly gone blind going through each transaction on my phone and
> > entering the amount in the GNU Cash file.
> >
> > Now I need to work out how to import these completed transactions into my
> > main file.
> >
> > I think I am done with the Android App. Every time I try to use it in
> > messes
> > up. It is therefore a huge waste of time.
> >
> > One of the reasons I started with GNU was the option of having the
> Android
> > companion.
> >
> > Clearly it doesn't work. Clearly it was never intended to be a 'clone' of
> > the main GNU Cash Application.
> >
> > Might I suggest that it is removed from the GNU Cash web site. It is
> > detrimental to GNU Cash which by and large works. The Android App is
> just a
> > huge waste of time.
> >
> > I wondered if there is any intention to create an App that works.
> >
> > All I wish to do is record stuff on the phone and load it to the PC. Is
> > this
> > possible / achievable.
> >
> > What I don't want is to spend time recording stuff on my phone and then
> > spend 3-4 days transferring it across as that is completely pointless and
> > very frustrating. It would be much better to remove the current offering
> > from the system as it is setting a false user expectation. Which it turn
> > leads to mistrust of GNU Cash.
> >
> >
> >
> >
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[MAINT] Planned server downtime today, 1700 US/EST

[Derek Atkins]

Hi,

I need to take the gnucash server (code) down today to relocate it and
rebalance UPS systems.  The total downtime should be less than 30
minutes, with MOST of that time being spent taking the system down and
waiting for it to boot back up.  I plan to start the take-down around
1700 US/EST, after I do some physical prepartions.

I'll notify #gnucash/IRC before I take the server down, and I'll send
mail when everything is back up.

Please let me know if this is an issue; I can shift it around a little
as necessary, but I DO need to move the servers today.

Thanks!

-derek
-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

[David Carlson]

I also noticed that after returning to release 2.6.18-3 the main text font
used in the body of the register windows appears to be a couple of points
larger than before, so dates and amounts no longer fit in the columns
nicely like before the experiment, and less text is visible in the
description column, but the other changes in the tabs and menubars appear
to be returned to 'as original'.
I have forgotten how to shrink the text in Windoze.  Can someone please
remind me?

Thanks,

David C

On Sat, Jan 27, 2018 at 3:30 PM, John Ralls  wrote:

>
>
> > On Jan 25, 2018, at 10:00 PM, David Carlson 
> wrote:
> >
> > Also, I think it is known that release 2.7.3 is unable to install F::Q,
> even via the manual program link in the GnuCash program group of the
> Windows 7 start menu.
>
> If I knew that I'd forgotten. The new build scripts missed copying over
> the implementation file into the bundle. Thanks for bringing it up (again).
>
> Regards,
> John Ralls
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Does anyone successfully use GNU Android App. If not get it off the main web site.

[David Carlson]

Have you sent a comment to
https://plus.google.com/communities/104728406764752407046??

While i do not use the app myself, I believe that it is actively developed
and should not be mis-behaving like you describe.

I see there that there is currently a buggy beta release floating around.
Perhaps you got that by mistake.

David C

On Sun, Jan 28, 2018 at 8:31 AM, john_mike  wrote:

> Dear All,
>
> I gave up trying to import the QIF file generated by the Android App.
>
> I exported from Android as XML then opened that file in GNU Cash. This had
> the dates of the transactions the narrative (well some of it) and the
> relevant accounts and about 30% of the values.
>
> I have nearly gone blind going through each transaction on my phone and
> entering the amount in the GNU Cash file.
>
> Now I need to work out how to import these completed transactions into my
> main file.
>
> I think I am done with the Android App. Every time I try to use it in
> messes
> up. It is therefore a huge waste of time.
>
> One of the reasons I started with GNU was the option of having the Android
> companion.
>
> Clearly it doesn't work. Clearly it was never intended to be a 'clone' of
> the main GNU Cash Application.
>
> Might I suggest that it is removed from the GNU Cash web site. It is
> detrimental to GNU Cash which by and large works. The Android App is just a
> huge waste of time.
>
> I wondered if there is any intention to create an App that works.
>
> All I wish to do is record stuff on the phone and load it to the PC. Is
> this
> possible / achievable.
>
> What I don't want is to spend time recording stuff on my phone and then
> spend 3-4 days transferring it across as that is completely pointless and
> very frustrating. It would be much better to remove the current offering
> from the system as it is setting a false user expectation. Which it turn
> leads to mistrust of GNU Cash.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Android to Desktop

[John Ralls]

> On Jan 28, 2018, at 3:45 AM, Mike Stillingfleet 
>  wrote:
> 
> Hi, 
> 
> I have exported my Android Transactions from Android to a QIF and then 
> attempted to import them into the desktop.
> 
> It says Transaction amount: Unrecognised or inconsistent format.
> 
> When I exported from Android to XML and opened that various values where 
> blank.
> 
> When I look up those transactions on android they are not blank.
> 
> When I reduce the amount of data passed over it opens and imports the file. I 
> assume because these "blank transactions are omitted.
> 
> Any ideas as to how this can be corrected??
> 
> I have a lot of data to transfer.

Sorry, not here. GnuCash for Android is a separate project developed by a 
Google Summer-of-Code student, Ngewi Fet, several years ago. He does support 
through a Google+ community [1] and takes bug reports through the Github page 
[2] and Uservoice [3].

Regards,
John Ralls

[1] https://plus.google.com/communities/104728406764752407046 

[2] https://github.com/codinguser/gnucash-android 

[3] https://gnucash.uservoice.com/forums/320493-gnucash-android 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Please remove me from the mailing list

[Geert Janssens]

These changes look good to me. Thanks!

Geert

Op zondag 28 januari 2018 09:52:50 CET schreef Liz:
> I've made some changes to the FAQ, the Wiki and to the footer. You may
> have more suggestions for me.
> 
> Liz


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Mike or Penny Novack]

On 1/27/2018 10:25 PM, Matt Graham wrote:

Nice! It seems like we are getting somewhere. I am convinced that the process 
we think of budgeting where we are saving up for something is really a case of 
segmenting money within a sub-account. And it looks like Gnucash is already 
happy with this kind of situation - with the include sub-accounts in the 
recociliation window.
Not exactly. This is a case where the term "budgeting" is being used in 
different ways meaning different things. Budgets my be legal 
(organizations, government entities) or advisory (personal, business) 
though of course businesses might have requirements to set aside funds 
<< might be in the terms of a loan, etc. >>


ONE way of doing this is with liability accounts (typical -- account for 
amounts needed for taxes) but that method can also be used for "reserve 
funds" <<  I deal mainly with non-profits where "restricted funds" are 
common >>


Note that partitioning of a checking account in this way earlier 
described is still just "advisory" as it would NOT prevent you from 
writing a check for more than the balance remaining in the unrestricted 
portion of the account. Just you can't do that without seeing that you 
are doing it.


Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Accuracy / Rounding issues - Difference between gnucash and broker account

[Mike or Penny Novack]

On 1/27/2018 4:54 PM, Pawel Wocjan wrote:

Hi,



Are there some general guidelines how to choose accuracy for fractional 
shares/price etc? Has anybody experience such minor discrepancies between 
his/her broker account and gnucash?

Thank you for your help,
Pawel
   
There is no way to do this (guarantee agreement). Whenever rounding is 
involved, it matters not just the particular rounding rule used but WHEN 
rounding is applied, because rounded(A) + rounded(B) does not 
necessarily = rounded (A+B).


One of the things I used to do (in my working days) was calculate the 
necessary "fuzz" for compare operations necessary not to have these 
small "errors" (different rounding process) cause mismatches.


Michael D Novack

PS: You can manually adjust by including a child account for "rounding 
errors" which you might name that or "fuzz".

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: File Format : XML v MySQL / postgres / sqllite

[Sébastien de Menten]

It is indeed a python package so typically you write a script. For
instance, create the file test_piecash.py with the content

# start of the file
import piecash
book = piecash.open_book("/the/path/to/your/gnucash-book.gncash")

for transaction in book.transactions:
print(transaction.post_date)
for split in transaction.splits:
print("  ", split.account.name, split.value)
print()
# end of the file

and then run it with "python test_piecash.py" and you will see all your
transactions printed (do not forget to change "
/the/path/to/your/gnucash-book.gncash" with the path to your real gnucash
file save in the SQLite format).

You can see other examples of use in the piecash doc (like on
http://piecash.readthedocs.io/en/latest/tutorial/index_existing.html#access-to-objects
)

I was answering to this thread as the topic was about the file format and
how to access the file outside gnucash ... but indeed, it requires some
programming skills (but python is one of the most accessible language out
there).

If you have further questions or remarks that are piecash specific, better
to post on https://groups.google.com/forum/#!forum/piecash

kr

sebastien

On Sun, Jan 28, 2018 at 12:58 PM, David T.  wrote:

> For what it’s worth, I was able to execute “sudo pip install piecash”
> successfully, but there is a gap for me at this point: what next? Is there
> a python shell? Am I supposed to write a script file (and once written,
> would I use some python command to run it? Which command?)? What, exactly,
> did I install?
>
> Clearly, piecash isn’t for the average end user…
>
> David
>
>
> On Jan 28, 2018, at 4:31 PM, Sébastien de Menten 
> wrote:
>
> Editing a gnucash book via piecash is not the approved way of doing it
> (advice from the gnucash core team that recommends to go through the
> gnucash engine) but a very nice way ;-)
>
> However, for reading gnucash books, it is an alternative as they are many
> to choose (to read from XML, to read from SQL, ...)
>
> On Jan 28, 2018 12:03, "D"  wrote:
>
>> Sébastien,
>>
>> I know that users are advised not to edit their Gnucash data directly; is
>> piecash an approved application to edit Gnucash data directly?
>>
>> David
>>
>>
>> On January 28, 2018, at 3:41 PM, Sébastien de Menten 
>> wrote:
>>
>>
>> David,
>>
>> This is one of the key reason for piecash to exist as it does not need
>> any compilation (it is a pure python package) and works even without having
>> gnucash installed.
>> It doesn't use gnucash libraries as it reads (and writes) directly to the
>> gnucash book through SQL.
>>
>>
>> I do not have a Mac so I can't test the installation directly but it
>> should be just a matter of installing the "piecash" package available on
>> PyPI (the python package index).
>>
>> Sebastien
>>
>> On Jan 28, 2018 08:00, "David T."  wrote:
>>
>>> Sebastien,
>>>
>>> The problem isn’t with Python (I am told that Macs already have Python
>>> on them). The problem as I understand it (John will no doubt correct me
>>> when my statements prove ill-informed or flat out wrong) has to do with the
>>> fact that GnuCash requires a specific version of Python, which can only be
>>> guaranteed by compiling GnuCash with the current version of Python. Short
>>> of shipping GnuCash with a complete Python installation, the only way
>>> around this is for individual users to compile locally. Which, as I noted,
>>> is a painful process for me. But thanks for the information.
>>>
>>> David
>>>
>>>
>>> On Jan 28, 2018, at 11:55 AM, Sébastien de Menten 
>>> wrote:
>>>
>>> Hello David,
>>>
>>> Regarding the use of python on windows and Mac, Anaconda has made a huge
>>> difference in the last years providing all packages in an easy precompiled
>>> version.
>>> You can have a look at https://conda.io/docs/user-
>>> guide/install/macos.html for the installation (which is simple and does
>>> not require any compiler).
>>>
>>>
>>> On Jan 28, 2018 05:42, "D"  wrote:
>>>
 Ah, yes that was my incorrect reference. Sorry for the crossed
 reference.

 I will note that my confusion stems in part from the fact that, as a
 Mac user, I have never used anything to do with python and Gnucash, on
 account of the high barrier to install the proper toolsets (i.e., compiling
 yourself). My previous attempts at this process always ended in frustration
 and failure. As a consequence, when I see anything that mentions python and
 Gnucash, my eyes glaze over.

 In the past, there hasn't been much to recommend beating my head
 against that wall, but perhaps the time has come to see what happens at
 this time, since there eh to be increasing numbers of ways to use python
 with Gnucash data.

 David

 On January 28, 2018, at 12:55 AM, John Ralls 
 wrote:

 I 

Re: File Format : XML v MySQL / postgres / sqllite

[D via gnucash-user]

Sébastien,

I know that users are advised not to edit their Gnucash data directly; is 
piecash an approved application to edit Gnucash data directly?

David

On January 28, 2018, at 3:41 PM, Sébastien de Menten  
wrote:

David,


This is one of the key reason for piecash to exist as it does not need any 
compilation (it is a pure python package) and works even without having gnucash 
installed.

It doesn't use gnucash libraries as it reads (and writes) directly to the 
gnucash book through SQL.



I do not have a Mac so I can't test the installation directly but it should be 
just a matter of installing the "piecash" package available on PyPI (the python 
package index).


Sebastien


On Jan 28, 2018 08:00, "David T."  wrote:

Sebastien,


The problem isn’t with Python (I am told that Macs already have Python on 
them). The problem as I understand it (John will no doubt correct me when my 
statements prove ill-informed or flat out wrong) has to do with the fact that 
GnuCash requires a specific version of Python, which can only be guaranteed by 
compiling GnuCash with the current version of Python. Short of shipping GnuCash 
with a complete Python installation, the only way around this is for individual 
users to compile locally. Which, as I noted, is a painful process for me. But 
thanks for the information.


David



On Jan 28, 2018, at 11:55 AM, Sébastien de Menten  wrote:


Hello David,


Regarding the use of python on windows and Mac, Anaconda has made a huge 
difference in the last years providing all packages in an easy precompiled 
version.

You can have a look at https://conda.io/docs/user-guide/install/macos.html for 
the installation (which is simple and does not require any compiler).



On Jan 28, 2018 05:42, "D"  wrote:

Ah, yes that was my incorrect reference. Sorry for the crossed reference.

I will note that my confusion stems in part from the fact that, as a Mac user, 
I have never used anything to do with python and Gnucash, on account of the 
high barrier to install the proper toolsets (i.e., compiling yourself). My 
previous attempts at this process always ended in frustration and failure. As a 
consequence, when I see anything that mentions python and Gnucash, my eyes 
glaze over.

In the past, there hasn't been much to recommend beating my head against that 
wall, but perhaps the time has come to see what happens at this time, since 
there eh to be increasing numbers of ways to use python with Gnucash data.

David

On January 28, 2018, at 12:55 AM, John Ralls  wrote:

I suspect David was thinking of CuteCash, Christian Stimming’s experimental Qt 
GUI.

Regards,
John Ralls

> On Jan 27, 2018, at 10:44 AM, Sébastien de Menten  wrote:
>
> Hello David,
>
> I saw you were mentioning piecash in your message. If you talk about
> http://piecash.readthedocs.io/en/latest/, it is not a proof of concept for
> a frontend but an alternative to the gnucash python bindings to work with
> gnucash books stored in any of the 3 SQL backends (SQLite, postgres and
> MySQL) and is alive and maintained (last release on the 20th December 2017).
>
> The following article https://arachnoid.com/gnucash_utilities/ shows some
> interesting use cases for it.
>
> With gnucash 3.0, piecash will also allow you to write your own reports
> using si python and jinja2 (work in progress).
>
> For people interested to contribute, https://github.com/sdementen/piecash.
>
>
> On Jan 27, 2018 18:27, "D via gnucash-user" 
> wrote:
>
> Mike,
>
> There is nothing new as far as I know about the file formats. You are right
> that the primary benefit to using sql is being able to generate data sets
> from sql that can used in reports. Processing a data file is no quicker in
> sql, since it all gets loaded in at start up. Sql, moreover, adds a
> database manager role to the mix; many users are not prepared to learn how
> to manage a database platform to manage their financial accounts.
>
> I stick with the XML because it also can store the data compressed; when
> dealing with the main data file and all its copies, the difference between
> 3mb and 13mb adds up quickly.
>
> Piecash, as I understand it, was a proof-of-concept experiment to see
> whether a python front end could be designed. It has not been maintained
> for some years now, and I recall recent discussion about changing its
> status with the project.
>
> As far as I know, there has been no change in recommendation to stay with
> xml.
>
> David
>
> On January 27, 2018, at 12:13 PM, Adrien Monteleone <
> adrien.montele...@gmail.com> wrote:
>
> I switched from XML to SQLite about a year ago. I perceive a performance
> improvement on loading, but that’s about it. (and I generally never shut
> the app down anyway)
>
> I haven’t attempted any custom reporting yet, but I plan to.
>
> I could be mistaken, but I think PyCash is 

Re: File Format : XML v MySQL / postgres / sqllite

[Sébastien de Menten]

David,

This is one of the key reason for piecash to exist as it does not need any
compilation (it is a pure python package) and works even without having
gnucash installed.
It doesn't use gnucash libraries as it reads (and writes) directly to the
gnucash book through SQL.


I do not have a Mac so I can't test the installation directly but it should
be just a matter of installing the "piecash" package available on PyPI (the
python package index).

Sebastien

On Jan 28, 2018 08:00, "David T."  wrote:

> Sebastien,
>
> The problem isn’t with Python (I am told that Macs already have Python on
> them). The problem as I understand it (John will no doubt correct me when
> my statements prove ill-informed or flat out wrong) has to do with the fact
> that GnuCash requires a specific version of Python, which can only be
> guaranteed by compiling GnuCash with the current version of Python. Short
> of shipping GnuCash with a complete Python installation, the only way
> around this is for individual users to compile locally. Which, as I noted,
> is a painful process for me. But thanks for the information.
>
> David
>
>
> On Jan 28, 2018, at 11:55 AM, Sébastien de Menten 
> wrote:
>
> Hello David,
>
> Regarding the use of python on windows and Mac, Anaconda has made a huge
> difference in the last years providing all packages in an easy precompiled
> version.
> You can have a look at https://conda.io/docs/user-guide/install/macos.html
> for the installation (which is simple and does not require any compiler).
>
>
> On Jan 28, 2018 05:42, "D"  wrote:
>
>> Ah, yes that was my incorrect reference. Sorry for the crossed reference.
>>
>> I will note that my confusion stems in part from the fact that, as a Mac
>> user, I have never used anything to do with python and Gnucash, on account
>> of the high barrier to install the proper toolsets (i.e., compiling
>> yourself). My previous attempts at this process always ended in frustration
>> and failure. As a consequence, when I see anything that mentions python and
>> Gnucash, my eyes glaze over.
>>
>> In the past, there hasn't been much to recommend beating my head against
>> that wall, but perhaps the time has come to see what happens at this time,
>> since there eh to be increasing numbers of ways to use python with Gnucash
>> data.
>>
>> David
>>
>> On January 28, 2018, at 12:55 AM, John Ralls  wrote:
>>
>> I suspect David was thinking of CuteCash, Christian Stimming’s
>> experimental Qt GUI.
>>
>> Regards,
>> John Ralls
>>
>> > On Jan 27, 2018, at 10:44 AM, Sébastien de Menten 
>> wrote:
>> >
>> > Hello David,
>> >
>> > I saw you were mentioning piecash in your message. If you talk about
>> > http://piecash.readthedocs.io/en/latest/, it is not a proof of concept
>> for
>> > a frontend but an alternative to the gnucash python bindings to work
>> with
>> > gnucash books stored in any of the 3 SQL backends (SQLite, postgres and
>> > MySQL) and is alive and maintained (last release on the 20th December
>> 2017).
>> >
>> > The following article https://arachnoid.com/gnucash_utilities/ shows
>> some
>> > interesting use cases for it.
>> >
>> > With gnucash 3.0, piecash will also allow you to write your own reports
>> > using si python and jinja2 (work in progress).
>> >
>> > For people interested to contribute, https://github.com/sdementen/p
>> iecash.
>> >
>> >
>> > On Jan 27, 2018 18:27, "D via gnucash-user" 
>> > wrote:
>> >
>> > Mike,
>> >
>> > There is nothing new as far as I know about the file formats. You are
>> right
>> > that the primary benefit to using sql is being able to generate data
>> sets
>> > from sql that can used in reports. Processing a data file is no quicker
>> in
>> > sql, since it all gets loaded in at start up. Sql, moreover, adds a
>> > database manager role to the mix; many users are not prepared to learn
>> how
>> > to manage a database platform to manage their financial accounts.
>> >
>> > I stick with the XML because it also can store the data compressed; when
>> > dealing with the main data file and all its copies, the difference
>> between
>> > 3mb and 13mb adds up quickly.
>> >
>> > Piecash, as I understand it, was a proof-of-concept experiment to see
>> > whether a python front end could be designed. It has not been maintained
>> > for some years now, and I recall recent discussion about changing its
>> > status with the project.
>> >
>> > As far as I know, there has been no change in recommendation to stay
>> with
>> > xml.
>> >
>> > David
>> >
>> > On January 27, 2018, at 12:13 PM, Adrien Monteleone <
>> > adrien.montele...@gmail.com> wrote:
>> >
>> > I switched from XML to SQLite about a year ago. I perceive a performance
>> > improvement on loading, but that’s about it. (and I generally never shut
>> > the app down anyway)
>> >
>> > I haven’t attempted any custom reporting yet, but I plan to.
>> >
>> > I could 

Re: Please remove me from the mailing list

[Liz]

On Sat, 27 Jan 2018 12:36:55 +0100
"Frank H. Ellenberger"  wrote:

> Hi,
> 
> Am 26.01.2018 um 23:53 schrieb Adrien Monteleone:
> > I suppose you’re referring to this:
> >   
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.  
> > 
> > I would think altering this to say:
> >   
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >>
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>
> >> To do the same if you’re using Nabble:
> >> (insert link here)  
> 
> To do the same if you’re using Gmane:
> (insert link here)
> To do the same if you’re using whoever mirrors the list else:
> (insert link here)
> 
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.  
> > 
> > 
> > would do the trick.
> > 
> > Regards,
> > Adrien  
> :
>  I think it should be more general.
> 
> Regards
> Frank

I've made some changes to the FAQ, the Wiki and to the footer. You may
have more suggestions for me.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.