[GNC] Help
This is James Baxter.I am writing email asking for help with the import of stock/tickers from the web to Gnucash. I am not getting anything on this, WhyJames baxterkangaro...@yahoo.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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Stock quotes hung
On Monday, 9 October 2023 16:52:17 BST David Carlson wrote: > Not sure exactly what happened in your case. But usually, if you can put > the focus on the "frozen" process, then Alt-F4 will kill it. > > > There are other ways as well in Linux, for example with htop. Ctrl-Alt-Escape is quite good at killing a stuck process, as long as it has a window open. Quick too > > On Mon, Oct 9, 2023, 10:13 AM Fred Tydeman wrote: > > I am back home and stock quotes is working fine. > > So, my problem must have been a very slow internet connection. > > It would be nice if there were some way to cancel a stock quote fetch > > in progress. I had to reboot the entire Linux system before. > > > > On Sat, Sep 9, 2023 at 3:25 PM Fred Tydeman > > > > wrote: > > > I was wrong. The gnucash-cli command, after a couple of minutes, did > > > finish. > > > And looking at the price history, it did get the AT price for > > > > yesterday. > > > > > So, it looks like things are very slow for some reason. > > > Perhaps the internet at this airbnb is causing problems. > > > > > > On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman > > > > > > wrote: > > >> I have removed Get Quotes for all of my stocks and have just GBP > > > > currency > > > > >> getting quotes. > > >> Doing the gnucash-cli command works. > > >> > > >> If I add in just one stock (T == AT), gnucash-cli hangs. > > >> > > >> I tried adding in --debug to that gnucash-cli, but nothing stood out as > > > > a > > > > >> problem. > > >> > > >> Suggestions? > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > 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. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Stock quotes hung
Not sure exactly what happened in your case. But usually, if you can put the focus on the "frozen" process, then Alt-F4 will kill it. There are other ways as well in Linux, for example with htop. On Mon, Oct 9, 2023, 10:13 AM Fred Tydeman wrote: > I am back home and stock quotes is working fine. > So, my problem must have been a very slow internet connection. > It would be nice if there were some way to cancel a stock quote fetch > in progress. I had to reboot the entire Linux system before. > > On Sat, Sep 9, 2023 at 3:25 PM Fred Tydeman > wrote: > > > I was wrong. The gnucash-cli command, after a couple of minutes, did > > finish. > > And looking at the price history, it did get the AT price for > yesterday. > > So, it looks like things are very slow for some reason. > > Perhaps the internet at this airbnb is causing problems. > > > > On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman > > wrote: > > > >> I have removed Get Quotes for all of my stocks and have just GBP > currency > >> getting quotes. > >> Doing the gnucash-cli command works. > >> > >> If I add in just one stock (T == AT), gnucash-cli hangs. > >> > >> I tried adding in --debug to that gnucash-cli, but nothing stood out as > a > >> problem. > >> > >> Suggestions? > >> > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Stock quotes hung
I am back home and stock quotes is working fine. So, my problem must have been a very slow internet connection. It would be nice if there were some way to cancel a stock quote fetch in progress. I had to reboot the entire Linux system before. On Sat, Sep 9, 2023 at 3:25 PM Fred Tydeman wrote: > I was wrong. The gnucash-cli command, after a couple of minutes, did > finish. > And looking at the price history, it did get the AT price for yesterday. > So, it looks like things are very slow for some reason. > Perhaps the internet at this airbnb is causing problems. > > On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman > wrote: > >> I have removed Get Quotes for all of my stocks and have just GBP currency >> getting quotes. >> Doing the gnucash-cli command works. >> >> If I add in just one stock (T == AT), gnucash-cli hangs. >> >> I tried adding in --debug to that gnucash-cli, but nothing stood out as a >> problem. >> >> Suggestions? >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Issues Recognizing Account Names When Importing CSV into GnuCash
Thank you On Sat, Oct 7, 2023 at 3:35 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If I'm not mistaken, you should only have to do this once per account. > Now, combining this with your other question, there is reason #2 to > break this into smaller import chunks. You don't want to have to > manually assign those in a large quantity in a single pass. > > Regards, > Adrien > > On 10/7/23 12:01 AM, Gio Bacareza wrote: > > I'm experiencing difficulties when importing a CSV file into GnuCash, > > particularly when the file contains both "Account" and "Target Account" > > columns. Despite meticulously encoding the account names in the CSV to > > match the exact account names as they appear in GnuCash (e.g., > > “Asset:Cash”), the software does not seem to automatically recognize and > > match these names during the import process. > > > > Instead, GnuCash prompts me to manually match the account names through > its > > import wizard every time, which is unexpected and inconvenient. For > > instance, even if the CSV file contains the precise name “Asset:Cash”, > > GnuCash still requires manual intervention to match the names correctly. > > > > Is there a specific reason for this issue, or am I possibly making an > error > > during the import process? I would appreciate any insight or advice on > how > > to streamline this process and ensure GnuCash recognizes account names > from > > the CSV file automatically. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?
Thank you, Adrien. I get it now. On Sat, Oct 7, 2023 at 3:33 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > This is one of the reasons why it is not recommended to import a large > file, especially one containing transactions from more than a single > account on one side of each transaction. > > Read over the Help Manual & the Tutorial & Concepts Guide concerning > imports. > > The usual recommended procedure is to break the import into smaller > chunks depending on how many transactions you have in a month/year, etc. > > So for example, you might import January 2023 of your checking account. > (from whatever other app, or from a bank download) Then reconcile, and > repeat for February, then March, etc. > > As you go, you are training the matcher, so the imports speed up, and > duplicates are detected. > > It is up to you, how big the import chunks are, but bigger is not > necessarily faster, and maybe rarely is. > > Regards, > Adrien > > On 10/6/23 11:57 PM, Gio Bacareza wrote: > > I've been attempting to import a large, consolidated CSV file containing > > multiple accounts into GnuCash. Previously, I used to import transaction > > logs from various accounts individually, which I thought was a cumbersome > > process. To simplify this, I’ve created scripts to compile all > transactions > > into one comprehensive CSV file for what I thought would be a more > > straightforward import process. > > > > However, I've encountered an issue where GnuCash duplicates certain > > transactions during the import. Specifically, this happens when a > > transaction represents a withdrawal from one account and a deposit into > > another, which are naturally recorded as two separate entries in the CSV. > > For instance, when money is withdrawn from a bank account and deposited > > into a cash account, the consolidated CSV file includes one row showing > the > > bank account debit and another showing the cash account credit. > > > > I assumed that GnuCash’s import algorithm would recognize and eliminate > > these duplicate transactions during the import process as it typically > does > > with other duplicates. Unfortunately, my tests indicate that it imports > > both transactions, resulting in duplicated entries. > > > > Is this a mistake on my part, or is this behavior expected from GnuCash > > when importing a large CSV with multiple accounts? Any insights or > > solutions to prevent these duplicates would be greatly appreciated. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.