Re: [GNC] Saving to MySQL 8.0.36

2024-02-29 Thread Cam Ellison
Ira, there's not enough information in what you have posted to assist in getting your problem solved. What does "Saving to Windows on local network does not work" mean? What actually happens? What error message is generated? Is there one MySQL database or two? If there is one, on which machin

Re: [GNC] Saving to MySQL 8.0.36

2024-02-28 Thread Cam Ellison
On 2024-02-28 18:28, Tommy Trussell wrote: On Wed, Feb 28, 2024 at 8:02 PM Ira Fuchs wrote: I am trying to save my Gbucash data to MySQl v8.0.36 on a newly installed MySQL instance on WIndwos 10. Gnucash is running on a Mac and I also have a MySQL instance on that machine running v .8.0.22. I

Re: [GNC] iPhone or iPad app

2023-12-10 Thread Cam Ellison
On 2023-12-10 10:46, Adrien Monteleone wrote: There is no official app other than the main GnuCash app for desktop. Anything else you find is a 3rd Party project. And they don't do much, frankly. I tried an Android version, and it was not helpful. If dealing with more than a few items a day

Re: [GNC] Invoice emailing?

2023-01-02 Thread Cam Ellison
If you use GnuCash with a database, and have the coding skills, you could generate whatever invoice you want, and convert and email it. This would be straightforward in most cases, though not trivial. Access to the database is not confined to GnuCash itself. Just the same, you'd have to do it o

Re: [GNC] Can I export a list of vendors and customers?

2022-11-18 Thread Cam Ellison
On 2022-11-18 13:55, Adrien Monteleone wrote: Unfortunately no. Regards, Adrien On 11/18/22 12:11 PM, Dr. David Kirkby wrote: Is it possible to export the customers as a .csv file in a database, and also I'd like to export the vendors. There are no transactions with these yet. If you stor

Re: [GNC] Is GnuCash right for me?

2022-08-20 Thread Cam Ellison
On 2022-08-20 09:08, Robert Heller wrote: At Sat, 20 Aug 2022 10:32:03 -0400 d...@ditdit.us wrote: HI Everyone, Sorry for the totally noob uneducated question. I'm an engineer by training, not an accountant! I recently started a home business and everyone said "Quickbooks". It's too expensive a

Re: [GNC] MariaDB?

2022-07-15 Thread Cam Ellison
ter wrote: Are there issues with using MariaDB in place of MySQL? I'll second John's comment. My system is Debian, so when I switched to using a database, it was MariaDB from the start. Never a problem. Cheers Cam Ellison ___ gnucash-user

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread Cam Ellison
On 2022-01-03 8:22 p.m., john wrote: Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal Bank of *Canada* is absolutely not a German bank and isn't likely to support HBCI. EBICS is also German only. https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftw

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread Cam Ellison
On 2022-01-03 5:39 p.m., Jesse MacDougall wrote: Guy's, I'm stumped here. My Bank is Royal Bank in Canada. I have no idea where to get this information from. When I call the bank they talk to me like I am a terrorist due to Iddiocracy. Never seen this side of technology before. I read the Aq

Re: [GNC] gnucash-cli --quotes get

2021-05-27 Thread Cam Ellison
On 2021-05-27 10:50 a.m., John Ralls wrote: On May 27, 2021, at 10:35 AM, Cam Ellison wrote: On 2021-05-27 10:08 a.m., mike823 wrote: Hi Robin, I used your code to load quotes and I've noticed that when runs multiple times, it will create multiple quote records for the same day. Any w

Re: [GNC] gnucash-cli --quotes get

2021-05-27 Thread Cam Ellison
On 2021-05-27 10:08 a.m., mike823 wrote: Hi Robin, I used your code to load quotes and I've noticed that when runs multiple times, it will create multiple quote records for the same day. Any way to avoid this behavior? I mean, if you re-run it, it should just update the quote for the day, not cr

Re: [GNC] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Cam Ellison
25.65 On 3/30/21 11:57 AM, Cam Ellison wrote: On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote: I'm trying to enter a refund split transaction to a credit card account and every time I do I get an Imbalance-USD amount. (see screen shots below) Why is this happening?

Re: [GNC] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Cam Ellison
On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote: I'm trying to enter a refund split transaction to a credit card account and every time I do I get an Imbalance-USD amount. (see screen shots below) Why is this happening? Screenshots don't work. Easiest way for me to do the re

Re: [GNC] Trouble getting stock quotes from TSX

2021-02-05 Thread Cam Ellison
On 2021-02-05 15:23, Geoff wrote: Hi Gord You are not doing anything wrong. The data sources / web pages used by Finance Quote are constantly changing, and unless someone rolls up their sleeves and puts in the work to fix it, we end up in this situation with a number of sources broken, includin

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread Cam Ellison
On 2021-01-31 20:05, David Cousens wrote: I don't have any experience of MySQL with GnuCash but I would try and look at logs for the MySQL server in /var/log/mysql. If the problem is with the server rather than GnuCash itself, that may indicate it. Also check the Gnucash,trace file ( https://w

Re: [GNC] Bankrupt stock

2020-12-29 Thread Cam Ellison
On 2020-12-29 14:18, smada46 wrote: I have a stock that went bankrupt, i.e. zero value. I have tried repeatedly to remove the stock by selling the shares at $0.00 per share, but no matter what combination I use, it changes the cost or amount so it does not remove the shares. For example, I put

Re: [GNC] Thank you for your patronage

2018-10-03 Thread Cam Ellison
On 2018-10-03 12:06 p.m., David Burleigh wrote: On Wed, 2018-10-03 at 11:52 -0700, Cam Ellison wrote: On 2018-10-03 10:51 a.m., David Burleigh wrote: How can I permanently change the message "Thank you for your patronage" that appears at the bottom of printed invoices? I am usi

Re: [GNC] Thank you for your patronage

2018-10-03 Thread Cam Ellison
On 2018-10-03 10:51 a.m., David Burleigh wrote: How can I permanently change the message "Thank you for your patronage" that appears at the bottom of printed invoices? I am using GnuCash version 3.2 under Linux (Debian). The file is at: /usr/share/gnucash/scm/gnucash/invoice.scm. Look for line

Re: Price Retrieval Failure

2018-01-24 Thread Cam Ellison
On 24/01/18 11:26 AM, Geert Janssens wrote: David, Another thing to try is run gnucash from the command line (I believe this is also possible on OS X, though I don't know the details). Normally gnucash prints the version of F::Q it finds to the console during startup. That may give a hint alre

Re: Finance:Quotes

2018-01-20 Thread Cam Ellison
On 20/01/18 07:54 PM, Paul Jones wrote: Thanks Dave, I'll give that a try. Are you aware of which finance-quote modules are working for Canadian stocks and mutual funds, or is it a case of trial and error? TSX and TSX.V are easily accessed using alphavantage. Also currency. For CSE (suffix .CN

Re: How to deal with RRSP's (Canada)

2018-01-03 Thread Cam Ellison
On 03/01/18 04:36 PM, Matthew Pounsett wrote: I am not an accountant.. or even a bookkeeper.. but here's how I deal with RRSPs. For me, the RRSPs have been converted to Income Funds, but the principle and procedure are still the same. Contribution is straightforward: from a Current Asset acco

Re: How to deal with RRSP's (Canada)

2018-01-02 Thread Cam Ellison
On 02/01/18 06:52 PM, DaveC49 wrote: Larry If your withdrawals from the RRSP are taxable on withdrawal then I think your approach of using two files recording transfers to your bank account from the RRSP as Expenses in the RRSP account and Income in your main accounts should work fine as it wil

Re: Bank reconciliation

2017-11-13 Thread Cam Ellison
On 13/11/17 09:45 AM, David Goodenough wrote: Does no-one else have this problem? When we try to split the transaction in the imbalance account to allocate the payment to invoices we notice that it almost lets us add one split, but it does not automatically decrement the amount allocated to th

Re: Finance-Quote 1.47 released!

2017-11-12 Thread Cam Ellison
On 12/11/17 08:27 AM, Erik Colson wrote: New version 1.47 of Finance-Quote is available with the following changes: * Use AlphaVantage for currency quotes instead of Yahoo (Mike Alexander) FYI: USD->CAD now works, but not GBP->CAD. Cheers Cam _

Re: Version 2.6 17 No Longer Downloads Quotes

2017-11-11 Thread Cam Ellison
On 11/11/17 11:10 AM, Robert L. Kief wrote: For the past couple of weeks, GnuCash 2.6.17 no longer downloads stock quotes.  The accompanying error message originally listed the stocks quotes being requested with the indication they couldn't be downloaded.  Now the error reads "There was an unkn

Re: Finance-Quote 1.44 released!

2017-11-10 Thread Cam Ellison
For anyone who has been following this thread, and especially for Erik: The problem turned out to be a couple of stocks that I no longer hold but are still in the table for historical reasons, whose quote assignments were incorrect. All good now. Thank you again, Erik, for your patience, Cam

Re: Finance-Quote 1.44 released!

2017-11-10 Thread Cam Ellison
Having re-read the FAQ, I think it may just be a time-out problem. I may have to change the cron job to the middle of the night - at least until there's a change in gnucash that will recognize this and allow for the extra time. Thank you, once again, Cam _

Re: Finance-Quote 1.44 released!

2017-11-10 Thread Cam Ellison
On 10/11/17 05:21 AM, Erik Colson wrote: Cam, I don't know about gnucash itself since I don't use it. F::Q handels the symbols correctly as shown below for CMI.V: ~/.../finance-quote/Examples >>> perl stockdump.pl alphavantage CMI.V $VAR1 = { 'CMI.Vopen' => '1.1400', 'CMI

Re: Finance-Quote 1.44 released!

2017-11-09 Thread Cam Ellison
On 09/11/17 01:37 AM, Erik Colson wrote: Cam Ellison writes: On 08/11/17 12:40 PM, Erik Colson wrote: Please list some symbols you tried. Here you go: CMI.V MBA.TO QST.V FCEL (on NASDAQ) Hi Cam, Please try again with F::Q v1.45. It does work on my system. So I did that. When I use

Re: Finance-Quote 1.44 released!

2017-11-08 Thread Cam Ellison
On 08/11/17 12:40 PM, Erik Colson wrote: Please list some symbols you tried. Here you go: CMI.V MBA.TO QST.V FCEL (on NASDAQ) I ran gnucash --add-price-quotes with debugging on and logged it. There are entries for currencies and for  stocks etc of this form (selected lines to show each ex

Re: Finance-Quote 1.44 released!

2017-11-08 Thread Cam Ellison
On 08/11/17 11:15 AM, Erik Colson wrote: ? ?? writes: Right now it works well with updating prices of my US stock. But for my Asian stocks, such as Hong Kong stock, China stock, and Taiwan stock, it's still not working now. Currency is not updated either. Is there a way for updating currency

Re: GnuCash quotes suddenly :- " Unable to retrieve quotes for these items:"

2017-11-07 Thread Cam Ellison
On 07/11/17 04:16 PM, WasserLand wrote: Ubuntu 16.04. Gnu Cash ver  2.6.17 Price Editor suddenly "Unable to retrieve quotes for these items:" Yahoo  ASX. Has been working very well for years but very recently has failed. I see there is an Finance::Quote update being discussed.  Does that hav

Re: F::Q has been working but not anymore

2017-11-03 Thread Cam Ellison
On 03/11/17 07:56 PM, MGM wrote: I am using latest version of F::Q ."1.38" .It  stopped  updating share prices 3 days ago. I am using  :  Type of source quote  as multiple ., Asia (Yahoo,..)as my shares are on Australian Stock Exchange ( .AX). Yahoo has quit providing quotes, apparently, so wh