Re: [GNC] Lost all my transactions on Gnu cash
David, I am able to run 2.6.19 and 3.4 on the same data file without problem. For most users, there are no such file changes--although I believe there is a date format change in one of the SQL storage back ends that might cause this. Gnucash developers have very carefully ensured that such changes only occur exceptionally, and are prominently highlighted. As for your other points, Georgina didn't say she was having trouble opening Gnucash, she said her data was gone. That doesn't sound anything like those problems. Georgina, You said: "I have an Appl Mac laptop. I recently upgraded my working system to Mojavie, but then discovered my Gnu accounts package did not work. However, I was able to download a version of Gnu cash on an older computer, transferred the files to this older computer, and can now open the Gnu cash file. However, all the data appears to be lost. Do you have any idea how to recover the data?" When you upgraded, what problem did you encounter? What version of Gnucash did not work? What operating system was on your older computer? What version of Gnucash worked on that? Which files did you copy? How did you open the empty file on the older computer? Are you sure you opened the correct data file? And, have you ever made any backups of your system (e.g., using Time Machine)? There are many questions here, and I know you're worried right now, but it will take more digging to get to the bottom of your situation. The more detail you provide, the better you'll receive. David T. On January 15, 2019, at 8:00 AM, David Cousens wrote: Georgina, If the earlier version was 2.6.x ( use Help->About to check the version running) and the version on Mojave is V3.x, there is a file conversion which should be run the first time you open the data file. Most of it is related to changes in the locations of configuration files but there may have been some file conversion. That you can open the file on an earlier version indicates this has not happened as you should not be able to open the file with a 2.6.x version once it has been converted to run with v3. https://wiki.gnucash.org/wiki/Configuration_Locations gives the locations for the configuration files for all 3 Operating systems. the locations labelled as MacOS. If you have no files in the config locations listed for v3 and there are files in the locations listed for V2.6 then it is likely the conversion won't have happened. I don't use MacOS but know some users have experienced difficulty with initially running v3. If you look back through the user mailing list archives "http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=search_page=1415818=MacOS+++Gnucash+won%27t+open=180; you should throw up some posts which should have some useful details and solutions. Failing that one of the MacOS users may reply. Good luck David Cousens - David Cousens -- 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: [GNC] Lost all my transactions on Gnu cash
David, Gnucash maintains its own list server; your search should reference that. David T. On January 15, 2019, at 8:02 AM, David Cousens wrote: Also returns from a Mojave specific search http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=search_page=1415818=MacOS++Mojave+Gnucash+won%27t+open=180 David - David Cousens -- 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: [GNC] Lost all my transactions on Gnu cash
Also returns from a Mojave specific search http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=search_page=1415818=MacOS++Mojave+Gnucash+won%27t+open=180 David - David Cousens -- 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: [GNC] Lost all my transactions on Gnu cash
Georgina, If the earlier version was 2.6.x ( use Help->About to check the version running) and the version on Mojave is V3.x, there is a file conversion which should be run the first time you open the data file. Most of it is related to changes in the locations of configuration files but there may have been some file conversion. That you can open the file on an earlier version indicates this has not happened as you should not be able to open the file with a 2.6.x version once it has been converted to run with v3. https://wiki.gnucash.org/wiki/Configuration_Locations gives the locations for the configuration files for all 3 Operating systems. the locations labelled as MacOS. If you have no files in the config locations listed for v3 and there are files in the locations listed for V2.6 then it is likely the conversion won't have happened. I don't use MacOS but know some users have experienced difficulty with initially running v3. If you look back through the user mailing list archives "http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=search_page=1415818=MacOS+++Gnucash+won%27t+open=180; you should throw up some posts which should have some useful details and solutions. Failing that one of the MacOS users may reply. Good luck David Cousens - David Cousens -- 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: [GNC] Copy a month's budget
Hello, Thank you for the response. You are correct that that was the original question. As far as I know, no one has yet offered a solution. Someone did offer an alternative approach, but it would still be helpful for me if there is a way to copy the entire column without doing it one entry at a time, as you described. Regards, Patrick On Mon, Jan 14, 2019 at 6:52 PM Jim Passmore wrote: > I don't think the original question has been addressed--did I miss the > answer? I understood the question to be "is there a way to copy an entire > column of budget values?" Whether it's a month at a time, in a 12 month > period, or two weeks at a time in a quarter, if you have several expense > account parents, with sub-accounts underneath, it takes a while to copy the > entire column one entry at a time [by memory it's arrow down, return, type > value, return...and repeat for each account]. Surely there should be a way > to duplicate a column? > > -- > > *Jim Passmore* > > > > On Fri, Jan 11, 2019 at 12:09 PM Patrick wrote: > >> Andre, >> >> Thanks for the advice. This definitely gives me some possible alternatives >> to consider. >> >> I am not able to find a page that gives the etiquette rules for this >> mailing list. Is top-posting preferred on this list? I noticed that some >> people do and some don't. >> >> Thanks, >> Patrick >> >> On Fri, Jan 11, 2019 at 6:24 AM Andre Powell >> wrote: >> >> > Patrick, >> > The method that I use for budgeting is well "old-fashioned". My salary >> is >> > paid every fifteen days and my wife once a month, hence the two-week >> setup, >> > and the quarterly view because in my prior career we managed our P >> > monthly but with quarterly plans so mentally I am kind of used to that >> way >> > of thinking (or maybe I don't want to scroll so much). >> > >> > When income comes in is when I actually use the budget to plan where the >> > money is going to go (a mixture of Dave Ramsey and YNAB). I use the >> > Bills/Invoice feature to keep track of the bills that need to be paid, >> but >> > they don't get paid until they are planned for. >> > >> > For monitoring purposes, I use the Budget Report to do exactly that. You >> > can set it up to see a period before and after your current account >> period >> > (mine being set at a quarter), which will show your carryover. I am >> always >> > striving for a balanced budget (move/spend less money to make sure that >> the >> > budget is balanced. But in theory, you could create a second report >> with a >> > longer view (perhaps yearly) to see your overall progress with the >> period >> > before. >> > >> > I hope this helps. >> > >> > On Thu, Jan 10, 2019 at 10:30 AM Patrick wrote: >> > >> >> Andre, >> >> >> >> Thank you for the response. For each two-week period within the >> quarter, >> >> did you just have to copy the budget entries from each column to the >> next? >> >> That is what I would like to avoid, if possible. >> >> >> >> I would like to use one budget so that it is easy to see carryover from >> >> one budget period to the next. If I create a new budget for each >> quarter, I >> >> don't know of a way to get cumulative surplus/deficit for each budget >> >> category from the previous quarter. >> >> >> >> Thanks, >> >> Patrick >> >> >> >> On Thu, Jan 10, 2019 at 4:15 AM Andre Powell >> >> wrote: >> >> >> >>> Patrick, >> >>> I made a template and under the Budget menu just make a duplicate/copy >> >>> as needed (my accounting period is quarterly and the budgets are >> every two >> >>> weeks). >> >>> >> >>> >> >>> On Wed, Jan 9, 2019, 10:34 PM Patrick > >>> >> Hello, >> >> I recently started using GnuCash. Is there a way to copy one month's >> budget >> to the next month? I have a budget with a large number of entries, >> and >> copying each entry individually is somewhat cumbersome. >> >> Any help is appeciated. >> >> Regards, >> Patrick >> ___ >> 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. >> >> >>> >> > >> > -- >> > Andre >> > >> > >> > >> ___ >> 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: [GNC] Copy a month's budget
I don't think the original question has been addressed--did I miss the answer? I understood the question to be "is there a way to copy an entire column of budget values?" Whether it's a month at a time, in a 12 month period, or two weeks at a time in a quarter, if you have several expense account parents, with sub-accounts underneath, it takes a while to copy the entire column one entry at a time [by memory it's arrow down, return, type value, return...and repeat for each account]. Surely there should be a way to duplicate a column? -- *Jim Passmore* On Fri, Jan 11, 2019 at 12:09 PM Patrick wrote: > Andre, > > Thanks for the advice. This definitely gives me some possible alternatives > to consider. > > I am not able to find a page that gives the etiquette rules for this > mailing list. Is top-posting preferred on this list? I noticed that some > people do and some don't. > > Thanks, > Patrick > > On Fri, Jan 11, 2019 at 6:24 AM Andre Powell wrote: > > > Patrick, > > The method that I use for budgeting is well "old-fashioned". My salary is > > paid every fifteen days and my wife once a month, hence the two-week > setup, > > and the quarterly view because in my prior career we managed our P > > monthly but with quarterly plans so mentally I am kind of used to that > way > > of thinking (or maybe I don't want to scroll so much). > > > > When income comes in is when I actually use the budget to plan where the > > money is going to go (a mixture of Dave Ramsey and YNAB). I use the > > Bills/Invoice feature to keep track of the bills that need to be paid, > but > > they don't get paid until they are planned for. > > > > For monitoring purposes, I use the Budget Report to do exactly that. You > > can set it up to see a period before and after your current account > period > > (mine being set at a quarter), which will show your carryover. I am > always > > striving for a balanced budget (move/spend less money to make sure that > the > > budget is balanced. But in theory, you could create a second report with > a > > longer view (perhaps yearly) to see your overall progress with the period > > before. > > > > I hope this helps. > > > > On Thu, Jan 10, 2019 at 10:30 AM Patrick wrote: > > > >> Andre, > >> > >> Thank you for the response. For each two-week period within the quarter, > >> did you just have to copy the budget entries from each column to the > next? > >> That is what I would like to avoid, if possible. > >> > >> I would like to use one budget so that it is easy to see carryover from > >> one budget period to the next. If I create a new budget for each > quarter, I > >> don't know of a way to get cumulative surplus/deficit for each budget > >> category from the previous quarter. > >> > >> Thanks, > >> Patrick > >> > >> On Thu, Jan 10, 2019 at 4:15 AM Andre Powell > >> wrote: > >> > >>> Patrick, > >>> I made a template and under the Budget menu just make a duplicate/copy > >>> as needed (my accounting period is quarterly and the budgets are every > two > >>> weeks). > >>> > >>> > >>> On Wed, Jan 9, 2019, 10:34 PM Patrick >>> > Hello, > > I recently started using GnuCash. Is there a way to copy one month's > budget > to the next month? I have a budget with a large number of entries, and > copying each entry individually is somewhat cumbersome. > > Any help is appeciated. > > Regards, > Patrick > ___ > 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. > > >>> > > > > -- > > Andre > > > > > > > ___ > 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: [GNC] Selection with mouse doesn't work Gnucash 3.4 on MacOS 10.14
> On Jan 14, 2019, at 7:49 AM, Pierre-Louis Grangeon > wrote: > > Hello, > I have successfully used Gnucash 2.6 on MacOS 10.11 (El Capitan) for years. > In Gnucash 3.4 on MacOS 10.14 (Mojave), when I click on an item (line, > button...) the following item is highlighted and selected. > Same error with any pointing device (trackpad, wireless mouse, wired mouse). > It's impossible for me to use Gnucash 3.4. > Thank you for your help. A long standing problem that affects some users. See https://bugs.gnucash.org/show_bug.cgi?id=776602 for discussion and some possible work-arounds. 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.
[GNC] Selection with mouse doesn't work Gnucash 3.4 on MacOS 10.14
Hello, I have successfully used Gnucash 2.6 on MacOS 10.11 (El Capitan) for years. In Gnucash 3.4 on MacOS 10.14 (Mojave), when I click on an item (line, button...) the following item is highlighted and selected. Same error with any pointing device (trackpad, wireless mouse, wired mouse). It's impossible for me to use Gnucash 3.4. Thank you for your help. -- 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: [GNC] GNUCash fails to start on Windows 10 after windows update
Hi Same problem here. Compatibility mode wont help. I tried reinstalling, still not working. Tried with v2.6 too... PLS Help -- 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.
[GNC] Lost all my transactions on Gnu cash
Dear Gnu Cash information, I hope you can help. I have an Appl Mac laptop. I recently upgraded my working system to Mojavie, but then discovered my Gnu accounts package did not work. However, I was able to download a version of Gnu cash on an older computer, transferred the files to this older computer, and can now open the Gnu cash file. However, all the data appears to be lost. Do you have any idea how to recover the data? Many thanks, Georgina Hunter ___ 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.
[GNC] lost default budget template
Hello gnucash people I deleted all budget templates in Saved Report Configurations, not a good thing to do I now realize then I created a new budget template but it was saved only to the Select a Budget (via actons | budget | open budget) How might I go about restoring the default budget or any budget to Saved Report Configurations? I wish that file could not be so easily deleted. I now know that the proper way to create a new budget is modify an existing budget (which unfortunately have been deleted). thanks in advance ed ___ 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: [GNC] no entry point found (windows 7)
On Sat, Jan 12, 2019 at 11:57 AM Alan via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi, have used 2.6 version, then tried to update to 3.3, an 3.4. But when > try to open gnucash, I get the following;What do i need to do to get it to > work? This is on a laptop with windows 7 professional.thanks for the > help alan > For those who didn't see the screenshot of the message, it says: > "The procedure entry point InflateValidate could not be located in the > dynamic link library zlib1.dll." Did the installer remove the old version of GnuCash when you upgraded? Try uninstalling and then installing the new version. (Someone with more experience than I can weigh in on whether you should use an uninstall utility such as the free Revo Uninstaller.) Also go to http://www.gnucash.org/ and follow the link on the home page and be sure you're installing a good copy of the official application. Occasionally files can get corrupted while downloading. Also if it came from an unofficial source it's possible someone modified it. I rarely use Windows, so please be sure to reply to the list and let everyone know what worked (or not). - > 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: [GNC] Stock Quotes
On 03/01/2019 19:03, nvsoar wrote:
On 01/02/19 08:51, Dave Cooper via gnucash-user wrote:
Hi gnucash
I have returned to gnu-cash having not used it for several years so
please bear with me.
I have reloaded the system and set it up to get some UK stock prices
(LSE) using Alphavantage
Unfortunately I get poor results - only 25% - 50% prices are returned
- I assume this is caused by time outs
As a temporary fix I now use yahoo - json which gets results every
time so far, but I have to manually adjust these prices because the
return is in pence not pounds
Is there a parameter or easy way to fix this?
I note that yahoo are having problems due to their historical data for
UK is in pounds - not that I am going there.
Cheers
Dave
A solution to AlphaVantage limits is in Ameet Sengar's message;
available here.
https://lists.gnucash.org/pipermail/gnucash-user/2018-September/079698.html
It has been my experience that the AlphaVantage.pm file is read only.
Change file properties to read write to modify; then back to read
only. (Notepad++ worked well for me on a Win10 system.)
Because Quote.pm is hard coded to use Alphavantage for exchange rates it
is also useful to put a delay in there if you have more than a few
currencies.
..\perl\site\lib\Finance\Quote.pm
I put it in just before the call to the outside world
===
my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
return undef unless ( defined $ALPHAVANTAGE_API_KEY );
sleep(15);
my $reply = $ua->request(GET "${ALPHAVANTAGE_CURRENCY_URL}"
. "_currency=" . ${from}
. "_currency=" . ${to}
. "=" . ${ALPHAVANTAGE_API_KEY} );
===
Own risk, etc.
--
Wm
___
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.
