Re: Save to MySQL

2018-03-22 Thread daniel
te it ? Answering Yes creates another set of tables with _back suffix to all tables. How to resolve the issue ? Kind regards, Daniel Orkan -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gn

Re: Save to MySQL

2018-03-22 Thread daniel
9 (built from sources using cmake) - MySQL version 5.7.21 Daniel Orkan -- 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 unsub

[GNC] Trouble with gnc-fq-dump

2021-12-08 Thread Daniel Torstenson
Hi, I'm trying to get online quotes to work with Alphavantage, but I'm having trouble. I'd appreciate any pointers for debugging this, as I don't see anyone else with this problem after searching the web a little bit. I'm running Linux. I have an Alphavantage API key. A call to https://www.alph

Re: [GNC] Trouble with gnc-fq-dump

2021-12-08 Thread Daniel Torstenson
There were a lot of them!), and installed perl-finance-quote through the Arch repository. Now it works great! Thanks for your help! On Wed, Dec 8, 2021 at 9:37 PM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Hi Daniel, > > I get: > > gnc-fq-dump -v alphava

[GNC] Trouble creating this report

2021-12-12 Thread Daniel Torstenson
Hi, I'm hoping someone can point me in the right direction. I'm trying to create a report like the one enclosed. It seems very similar to something I can create with the "Transaction Report", but I can't quite get it. So this report shows the amount spent in each of the expense subaccounts, broken

Re: [GNC] Trouble creating this report

2021-12-13 Thread Daniel Torstenson
On Mon, Dec 13, 2021 at 6:03 AM Derek Atkins wrote: Did you try the Display -> Subtotal Table option? > Yeah, and I also check Sorting -> Show subtotals only (hide transactional data) and that *almost* gets me where I want to be. It gives a multicolumn table that looks like the one I enclosed, b

Re: [GNC] Trouble creating this report

2021-12-13 Thread Daniel Torstenson
unction to > estimate them based on transaction history, if you want to play with the > module anyway) Simply hide the 'budget' and 'variance' columns in the > report options. > > > Regards, > Adrien > > On 12/12/21 10:43 PM, Daniel Torstenson wrote: &

[GNC] Tracking capital gains, commissions and the Trial Balance report

2021-12-20 Thread Daniel Torstenson
Hi, I've been looking into tracking my capital gains and commissions for a brokerage account, and I'm running into an issue that I see others have run into. Namely, I'd like to account for my commissions and also keep track of my capital gains, as my brokerage reports them (and as the IRS expects

Re: [GNC] Tracking capital gains, commissions and the Trial Balance report

2021-12-21 Thread Daniel Torstenson
sset cost base >$5 (CR) > Assets:Investments:Brokerage Account > $105 (CR) > > On Tue, 21 Dec 2021 at 13:35, Daniel Torstenson > wrote: > >> Hi, >> >> I've been looking into tracking my capital gains a

Re: [GNC] Tracking capital gains, commissions and the Trial Balance report

2021-12-21 Thread Daniel Torstenson
stepf...@comcast.net> wrote: > On 12/20/2021 9:34 PM, Daniel Torstenson wrote: > > Hi, > > > > I've been looking into tracking my capital gains and commissions for a > > brokerage account, and I'm running into an issue that I see others have > run > &

[GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Daniel Fishman
Hello, Suppose that you go with your friend to a shop, and then a friend remembers that he forgotten his credit card and asks you to pay for his merchandise. He intends to return the money later. You pay in the shop (for example, buy a book) using your credit card. Then a few days later the frien

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Daniel Fishman
On 9/21/20 5:15 PM, Christopher Lam wrote: I wouldn't add an entry into Expenses:shop -- you didn't exactly spend your money into this shop. Spending/lending money: Liability:credit card -$50 Asset:Friend owes me +$50 Recovering funds: Asset:Friend owes me -$50 Asset:Cash or bank +$50 It seem

[GNC] Having trouble trying to use Gnucash instead of Aplos

2019-09-15 Thread Daniel Wieberdink
I was hoping to transition to Gnucash to track finances for the small church we belong to. I started by optimistically trying to import about 3 years worth of transactions from Aplos into GC via a CSV file. That didn't go as smoothly as I hoped. Most of the transactions ended up in the "Imbalance-U

Re: [GNC] Having trouble trying to use Gnucash instead of Aplos

2019-09-15 Thread Daniel Wieberdink
donor. On Sun, Sep 15, 2019 at 10:34 AM Mike or Penny Novack < stepbystepf...@comcast.net> wrote: > On 9/15/2019 9:15 AM, Daniel Wieberdink wrote: > > I was hoping to transition to Gnucash to track finances for the small > > church we belong to. I started by optimistically tr

Re: [GNC] Having trouble trying to use Gnucash instead of Aplos

2019-09-15 Thread Daniel Wieberdink
nt. > > -derek > Sent using my mobile device. Please excuse any typos. > On September 15, 2019 8:17:14 AM Daniel Wieberdink > wrote: > > > I was hoping to transition to Gnucash to track finances for the small > > church we belong to. I started by optimistically trying

Re: [GNC] Having trouble trying to use Gnucash instead of Aplos

2019-09-15 Thread Daniel Wieberdink
that when you delete the Imbalance account it > is trying to reassign all your transactions To Imbalance. So it > recreates the account. > > -derek > Sent using my mobile device. Please excuse any typos. > On September 15, 2019 8:17:14 AM Daniel Wieberdink > wrote: > &g

Re: [GNC] Having trouble trying to use Gnucash instead of Aplos

2019-09-16 Thread Daniel Wieberdink
t I should have started with a much smaller chuck of data to import. I will try the File>Export>Account Tree function to save my account setup and start over. Thanks again. On Sun, Sep 15, 2019 at 4:54 PM David Cousens wrote: > Daniel, > > Have you read the first few chapters of

Re: [GNC] Having trouble trying to use Gnucash instead of Aplos

2019-09-16 Thread Daniel Wieberdink
Ok thanks. I'll take a look at it. On Sun, Sep 15, 2019 at 5:16 PM David Cousens wrote: > Daniel > > The updated documentation on import matching is available > https://www.dropbox.com/sh/k0vy82he9g46wdc/AADfnttumgC71eZfJWGHfRuDa?dl=0 > here. If you point your browser at t

[GNC] How should I enter values on a budget in gnucash ?

2024-05-15 Thread Daniel Sheffield
if I can figure the C++. Is anyone looking at this at the moment? I'd like to help. At least two of the issues on the Budgeting feature can be resolved if we fix this math error. We could tackle separately perhaps getting the budget charts and editor to respect the Reverse values for Cre

[GNC] Fund management without an actual account

2024-08-04 Thread Daniel Sheffield
my opinion) than single-entry accounting... but then again, I'm probably doing wrong. Cheers, Daniel S -- In the beginning Kibo created the Internet. Now the Internet was formless, and empty. Randomness was upon the face of computing, and the Spirit of ARPA moved upon the face of the computers.

Re: [GNC] Fund management without an actual account

2024-08-05 Thread Daniel Sheffield
nd adjust your budget to suit if you like. If it's an obligatory fund, the advanced amount needs to be repaid within the accounting period, or it will carry over to the next period (if permissible). I still feel this is more complicated than I would like. So still soliciting more ideas... Le

[GNC] Fwd: Fund management without an actual account

2024-08-05 Thread Daniel Sheffield
Hi Richard, thanks for your reply. Alan had a similar suggestion. Since I forgot to cc the mailing list in my response to Alan, I'll include it here in case it is helpful to someone reading the mail archive. Thanks for all the input, Daniel -- In the beginning Kibo created the Internet. No

Re: [GNC] Fwd: Fund management without an actual account

2024-08-06 Thread Daniel Sheffield
unt seems to be the prevailing view... probably for a reason... perhaps I should try harder... Cheers, Daniel -- In the beginning Kibo created the Internet. Now the Internet was formless, and empty. Randomness was upon the face of computing, and the Spirit of ARPA moved upon the face of the compu

Re: [GNC] Fund management without an actual account

2024-08-06 Thread Daniel Sheffield
en the main account can debit the real expense account and I can add a reversing transaction from Expenses:Fund:Pending into the Asset:Checking:Fund account. I can handle the overspending in the same way I mention previously. Thanks all for your responses, I'm learning a lot! Cheers, Daniel -

Re: [GNC] Fwd: Fund management without an actual account

2024-08-06 Thread Daniel Sheffield
abusing equites going by the fact that my net worth appears to be what I would expect, but I could certainly be wrong about that. I must admit I have avoided using Equities as much as possible because I am sure I don't fully understand how they are supposed to work. Cheers, Daniel S -- In th

Error in Tip of the Day

2017-12-15 Thread Daniel Narvaes
I've been using gnucash for a long time, and I usually read the tip of the day, and try it if I have not seen it before.  Today it said "To switch between multiple tabs in the main window, press Control+Page Up/Down."  I tried it and it didn't work.  After browsing the users mailing list, I found

Re: Error in Tip of the Day

2017-12-15 Thread Daniel Narvaes
On Fri, 2017-12-15 at 09:36 +0100, Geert Janssens wrote: > Op zondag 10 december 2017 22:26:40 CET schreef Daniel Narvaes: > > > > I've been using gnucash for a long time, and I usually read the tip > > of the > > day, and try it if I have not seen it befor

[GNC] QIF Import in GnuCash 3.1

2018-06-14 Thread Daniel Rosenberg
n't find an option in the QIF importer like in the CSV importer where I can change the charset. Thanks Daniel ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org

Re: [GNC] QIF Import in GnuCash 3.1

2018-06-14 Thread Daniel Rosenberg
Thank you for the information. Any idea when this will be fixed? Do you know if a bug report has been filed already? Regards Daniel GT-I9070 H schrieb am Do., 14. Juni 2018 um 18:42 Uhr: > Yes Daniel, > This always happens after a major update of GnuCash and it happened again > aft

Re: [GNC] QIF Import in GnuCash 3.1

2018-06-14 Thread Daniel Rosenberg
David, Sorry, I missed Johns reply. Thanks for clarifying. David Carlson schrieb am Do., 14. Juni 2018, 21:14: > Daniel, > > If you read John's reply, there is a bug report. GT-I9070 H, you are out > of line. Do not insult the developers if you want them to help you. >

[GNC] Changing default font size in Gnucash 3.2

2018-07-01 Thread Daniel Dickinson
I just upgraded to Gnucash 3.2 (on Mac OS X 10.13.4) and am having trouble setting a default font size. The current font is too small and makes it very difficult for me to read the register. Following the instructions at https://wiki.gnucash.org/wiki/GTK3, I created the file ~/Library/Applica

Re: [GNC] Changing default font size in Gnucash 3.2

2018-07-04 Thread Daniel Dickinson
, July 2, 2018 2:34 PM To: Geert Janssens Cc: Gnucash Users; Daniel Dickinson Subject: Re: [GNC] Changing default font size in Gnucash 3.2 > On Jul 2, 2018, at 11:20 AM, Geert Janssens > wrote: > > Op maandag 2 juli 2018 18:34:18 CEST schreef John Ralls: >>> On Jul 2, 20

[GNC] Finance::Quote: CPAN or GitHub?

2018-08-02 Thread Daniel Rosenberg
I recently discovered that there is a more up to date version of Finance::Quote on GitHub than on CPAN (last update made in november 2017). I am using GnuCash 3.2 on WIndows 10 with Strawberry Perl. When I use gnc-fq-update it seems to got to CPAN and not GitHub, is that correct? I am having troub

[GNC] When will there be a new Finance::Quote version on CPAN?

2018-11-15 Thread Daniel Rosenberg
Hi, any ideas when a new version of F::Q will be available on CPAN? I get most of my stock Info using Alphavantage, which isn't working anymore due to throttling. Best regards Daniel ___ gnucash-user mailing list gnucash-user@gnucash.org To u

[GNC] Budget Report

2018-11-23 Thread DANIEL TREVORS
I am a new user. I have built my chart of accounts and budget, but I cannot get actual numbers to show on the budget report. Help please? Dan Trevors ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

Re: [GNC] When will there be a new Finance::Quote version on CPAN?

2018-11-27 Thread Daniel Rosenberg
Any infos on this? Daniel Am Do., 15. Nov. 2018 um 13:48 Uhr schrieb Daniel Rosenberg < dnlrsn...@gmail.com>: > Hi, > > any ideas when a new version of F::Q will be available on CPAN? I get most > of my stock Info using Alphavantage, which isn't working anymore due to

Re: [GNC] gnucash-user Digest, Vol 189, Issue 2

2018-12-02 Thread Daniel Rosenberg
> Thank you so much for that. I added the line and now I am able to retrieve > quotes. I missed the original message in september, so thank you very much > for repeating it. I added a screenshot with the modification. [image: grafik.png] > > -- Forwarded message -- > From: nvsoa

No stock quote for LU1233758587

2017-07-22 Thread Daniel Rosenberg
mbol for this (except for the Bloomberg code REMCIEE LX which I can't get to work), it used to work with the ISIN. I already ran gnc-fq-update, but still no quote Any ideas? Daniel ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.g

Re: No stock quote for LU1233758587

2017-07-24 Thread Daniel Rosenberg
oving the Bloomberg entry from Quotes.pm everything worked normally. Any ideas on that? Has anybody added Bloomberg module to GnuCash on Windows? Daniel > Message: 1 > Date: Sat, 22 Jul 2017 14:46:58 -0700 (PDT) > From: farleykj > To: gnucash-user@gnucash.org > Subject: Re:

Trouble installing Finance::Quote on Mac OSX Yosemite

2017-08-06 Thread Daniel Dickinson
I installed GnuCash 2.6.17 and it runs fine. However, I am having trouble with Finance::Quote. Initially FinanceQuote Update wouldn't run, but I got around that by allowing apps from unidentified developers. When I launch it, it opens a terminal window and asks for my password. It tries to i

Re: Trouble installing Finance::Quote on Mac OSX Yosemite

2017-08-07 Thread Daniel Dickinson
Thanks all for your replies. I do indeed have Xcode and command line tools installed, and I've run plenty of other Perl code without any issues. I did a little more digging. Here is the complete output from running sudo perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update: Rea

Re: Trouble installing Finance::Quote on Mac OSX Yosemite

2017-08-07 Thread Daniel Dickinson
). Sorry for all the email traffic over such a simple issue, but I appreciate all your replies and thought I'd pass the result along in case others experience similar issues. Thanks, Dan From: John Ralls Sent: Monday, August 7, 2017 2:29 PM To: Daniel Dick

Re: No stock quote for LU1233758587

2017-08-16 Thread Daniel Rosenberg
y[0] --> $curr_array[0] @date_array[0] --> $date_array[0] After doing that I was able to successfully retrieve a quote for REMCIEE:LX within GnuCash. Daniel > Message: 6 > Date: Mon, 24 Jul 2017 14:32:25 + > From: Daniel Rosenberg > To: gnucash-user@gnucash.org > Subject

[GNC] What does this mean?

2018-07-29 Thread Daniel G Rodriguez
; field is usually used to enter a transaction number? I think it means #2, but want to be sure. Thanks --Daniel ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org

Re: [GNC] What does this mean?

2018-08-04 Thread Daniel G Rodriguez
uld tend to find it a useful approach. The feature was introduced in version 2.6 -- by popular demand? ...to satisfy some corner cases? Thanks for reading and for all the help! --Daniel Alex Aycinena 于2018年7月30日周一 上午1:51写道: > Daniel, > > > >> From: Daniel G Rodriguez >> To:

Re: [GNC] What does this mean?

2018-08-04 Thread Daniel G Rodriguez
ction field for Number"? I'm not importing from Quicken and I don't yet know clearly how I "plan to use the Num field" as I've never used GnuCash before. Thank you. --Daniel ___ gnucash-user mailing list gnucash-user@gnuc

Re: [GNC] What does this mean?

2018-08-11 Thread Daniel G Rodriguez
Hi Adrian, Thank you for the explanation and tip. Will try this! --Daniel > Message: 2 > Date: Sun, 5 Aug 2018 11:54:53 -0500 > From: Adrien Monteleone > To: gnucash-user > Subject: Re: [GNC] What does this mean? > Message-ID: > Content-Type: text/plain; cha

Re: [GNC] What does this mean?

2018-08-11 Thread Daniel G Rodriguez
Hi David, Excellent. Thanks a lot for the info! Very helpful. --Daniel Message: 4 > Date: Sun, 5 Aug 2018 06:47:41 -0500 (CDT) > From: David Cousens > To: gnucash-user@gnucash.org > Subject: Re: [GNC] What does this mean? > Message-ID: <1533469661429-0.p...@n4.nabble.com>

[GNC] Can't download GNU

2023-10-17 Thread Daniel Stutzman via gnucash-user
I have been trying various times to download GNU cash on my computer.  It says "download will start in 5 seconds.  then after the fie seconds it waits a little and then says "Thank you for downloading GNU.  But I haven't gotten any downloads !  Why not ? {/Please