Re: [GNC] Unable to add prices to some securities

2019-03-19 Thread Alan Taylor
It is the latest MacOS. Apologies, I should have said MySQL Lite ... this is included with GnuCash I thought ? It was an option previously ... BRgds/Alan On Mar 20, 2019, 13:18 +0800, Adrien Monteleone , wrote: > What OS are you on? > > I think on Windows you have to install SQLite or MySQL sepa

Re: [GNC] Unable to add prices to some securities

2019-03-19 Thread Adrien Monteleone
What OS are you on? I think on Windows you have to install SQLite or MySQL separately. MacOS comes with SQLite and I think (don’t remember) most Linux distributions do as well. MySQL has to be installed separately for both MacOS and some Linux distributions, a few come with it already and some

Re: [GNC] Unable to add prices to some securities

2019-03-19 Thread Alan Taylor
Thanks Bucky but no joy, both with Yahoo and Apply. After testing I do have a clue. For the securities that are problematic, doing a manual ADD using the Price Database window appears to be normal (using apply and ok) but at conclusion nothing has been saved if looking for prices under the securi

Re: [GNC] Unable to add prices to some securities

2019-03-19 Thread Alan Taylor
More things not working properly … In the Save As dialogue there is no way to select sql - click on the displayed xml does not reveal any other possibilities Also the price editor dialogue does not allow selection of a namespace. There should be several, but it displays “All non-currency” with no

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

2019-03-19 Thread John Ralls
> On Mar 19, 2019, at 9:05 PM, suk wah Bernstein > wrote: > > tried moving icon from within Finder window to Dock. didn't work. Does that mean that you weren't able to get it to stay in the Dock? > > moved Gnucash icon onto desktop. > clicked icon. still cannot open after 'verification' Is

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

2019-03-19 Thread Chris Tsuji
HI, I am using Mac os 10.14.3 After I unstuffed GNUCash, I moved the entire folder, gnucash 3.3 into my application folder and then restared my computer. After the restart, i went to the application folder and opened the gnucash folder and double clicked on the gnucash icon. It

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

2019-03-19 Thread suk wah Bernstein
tried moving icon from within Finder window to Dock. didn't work. moved Gnucash icon onto desktop. clicked icon. still cannot open after 'verification' opened Applications/Utilities/Terminal. typed in /Applications/Gnucash.app/Contents/MacOS/Gnucash now what do i do? 'copy any output after that

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

2019-03-19 Thread John Ralls
Some users have found that dragging the GnuCash icon from Applications to to the Dock allows GnuCash to start. If that still fails, try opening /Applications/Utilities/Terminal. It will open a window with a command prompt. At that prompt type /Applications/Gnucash.app/Contents/MacOS/Gnucash c

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

2019-03-19 Thread suk wah Bernstein
thanks for reminder about copying the list. after "verifying gnucash" a window pops up, asking if i want to open this thing from internet, i click 'yes', then gnucash icon in dock disappears. i tried again. still doesn't work. thanks, love and respect suk wah On Tue, Mar 19, 2019 at 8:16 PM Jo

Re: [GNC] Still can't update price quotes

2019-03-19 Thread Elias K Gardner
I think I tracked it down. First gnc-fq-dump alphavantage APPL returns "This stock quote cannot be used by GnuCash!". Next I tried gnc-fq-dump yahoo-json APPL and go the same error, however if I use yahoo_json with a stock in my gnucash price database it correctly gives me the price. I have a numbe

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

2019-03-19 Thread John Ralls
Please remember to copy the list on all replies. Reply all (the double arrow icon) works well. A dmg is a MacOS disk image file. That's the kind of file that we use to distribute the GnuCash packages from Sourceforge and Github. After downloading most browsers will open it on their own, but if

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

2019-03-19 Thread John Ralls
> On Mar 19, 2019, at 5:19 PM, suk wah Bernstein > wrote: > > MacBook Pro > Intel core i5 > > please instruct. thanks so much. The process is to download the dmg, open it, and drag GnuCash somewhere; the Applications folder is popular. After the copy completes eject the dmg then double cl

Re: [GNC] Saved report configurations

2019-03-19 Thread Roger Oliver
That worked. Thanks. You are correct, my intention was to experiment with 3.4. I thought I would try copying the stylesheet file to the test computer as well. That did not work, I suspect because the picture file is not in the test computer. I take it that 3.4 will install with the Spanish account

[GNC] macOS Mojave 10.14.3 cannot open GNUCASH

2019-03-19 Thread suk wah Bernstein
MacBook Pro Intel core i5 please instruct. thanks so much. love suk wah ___ 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

Re: [GNC] Almost ready to give up

2019-03-19 Thread WestTown55
Hi, I'm having the exact same issue trying to connect GnuCash with Chase. From what I gather from this post, it's no longer possible to connect Chase with GnuCash to automatically download the transactions. Is that correct? Is the auto-download online banking setup easier with other banks? I have

Re: [GNC] Saved report configurations

2019-03-19 Thread Adrien Monteleone
Roger, just for reference, while the computer in question could certainly be named ’TOSHIBA’ the file path you gave indicated this is the name of the current user. (they may have been given the same name) If you had created a user called ‘Roger’ then the path would be C:/Users/Roger/.gnucash an

Re: [GNC] Example of multi-split feature of CSV importer?

2019-03-19 Thread Adrien Monteleone
I never understood the need or benefit to differentiate simple vs. split transactions since *all* transactions are split into two entries at least once. Perhaps dropping that distinction is in order, or does it serve some purpose that isn’t outweighed by the confusion it causes? Regards, Adrien

[GNC] Saving visible Accounts columns between GnuCash runs

2019-03-19 Thread James Walker
Hello all, I'm very new to GnuCash and enjoying the program so far. I've got a particular issue which I can't find a solution to after extensive searching of the manual. In the chart of accounts, I want many more columns to be visible than are displayed by default: [cid:image001.jpg@01D4DE4E.

Re: [GNC] Saved report configurations

2019-03-19 Thread Geert Janssens
Op dinsdag 19 maart 2019 20:33:32 CET schreef rmom...@gmail.com: > Thanks Geert, > > Windows 7. I found the file in C:/Users/TOSHIBA/.gnucash/saved-reports-2.4. > Out of curiosity, I looked for it on my Windows 10 computer and didn't find > it. I didn't see anything special for Windows 10 in the w

Re: [GNC] Saved report configurations

2019-03-19 Thread rmomxtx
Thanks Geert, Windows 7. I found the file in C:/Users/TOSHIBA/.gnucash/saved-reports-2.4. Out of curiosity, I looked for it on my Windows 10 computer and didn't find it. I didn't see anything special for Windows 10 in the wiki. Not important really as long as the update takes care of that. You sa

Re: [GNC] Saved report configurations

2019-03-19 Thread rmomxtx
Thanks John, I stumbled on the file on the computer we use for accounting in C:/Users/TOSHIBA/.gnucash. By $HOME do you mean the name of the computer, this case TOSHIBA? I looked for it on my Windows 10 PC but didn't find it. Not important. I only want to play with version 3.4 on the other compu

Re: [GNC] Saved report configurations

2019-03-19 Thread Geert Janssens
Op dinsdag 19 maart 2019 18:08:29 CET schreef rmom...@gmail.com: > Version 2.6.17 > > I looked at the wiki and am not sure where to start. If possible, just need > to know: > > What is the name of the file where the saved report configurations are > stored? > Should those saved configurations be

Re: [GNC] Saved report configurations

2019-03-19 Thread John Ralls
The filename is "saved-reports-2.6" in 2.6.17 and unless you're on a Mac it will be in $HOME/.gnucash. Running GnuCash will migrate everything in that directory to its new home and make any necessary format upgrades (for example, that file's name gets changed to "saved-reports-2.8") as long as t

Re: [GNC] Saved report configurations

2019-03-19 Thread Maf. King
On Tuesday, 19 March 2019 17:08:29 GMT rmom...@gmail.com wrote: > Version 2.6.17 > > I looked at the wiki and am not sure where to start. If possible, just need > to know: > > What is the name of the file where the saved report configurations are > stored? saved-reports-2.4 ( I think) In a fol

Re: [GNC] Saved report configurations

2019-03-19 Thread rmomxtx
Version 2.6.17 I looked at the wiki and am not sure where to start. If possible, just need to know: What is the name of the file where the saved report configurations are stored? Should those saved configurations be available when I update versions? Thanks, Roger -Original Message- Fro

Re: [GNC] Saved report configurations

2019-03-19 Thread John Ralls
> On Mar 19, 2019, at 9:33 AM, wrote: > > Where are the saved report configurations kept. Apparently they are not part > of the GnuCash data file. I installed vs 3.4 on another computer to test it > and opened the data file transferred via USB. The saved report > configurations are not there.

[GNC] Saved report configurations

2019-03-19 Thread rmomxtx
Where are the saved report configurations kept. Apparently they are not part of the GnuCash data file. I installed vs 3.4 on another computer to test it and opened the data file transferred via USB. The saved report configurations are not there. Found one file that may be where they are stored, sam

Re: [GNC] Order of transactions

2019-03-19 Thread Derek Atkins
Adrien Monteleone writes: > I understood that already, but thanks for the detail. > > What doesn’t work is sorting off the part, because the sorting > stops at “.”, correct? Correct. > That’s why you can’t use “:” in the faux timestamp as the sorting will > stop before it gets to the minut

Re: [GNC] Unable to add prices to some securities

2019-03-19 Thread Bucky Carr
Forgot to mention. For the Online Price update, I switched from Alphavantage to Yahoo_JSON and it seems to be working fine. On 3/19/2019 8:47 AM, Alan Taylor wrote: And of course the Online Price update does not work, I have updated Perl etc. as per the WIKI.

Re: [GNC] Unable to add prices to some securities

2019-03-19 Thread Bucky Carr
This might not be what you are seeing, but I found that I need to press the "Apply" button after entering each security's info and when done, then press "OK" button. If I skipped the "Apply" step, the info was not saved / updated. HTH... On 3/19/2019 8:47 AM, Alan Taylor wrote: Hello, I a

[GNC] Unable to add prices to some securities

2019-03-19 Thread Alan Taylor
Hello, I am running the latest GnuCash on the latest MacOS. In Price Database | Add , I can add prices to some securities but not others. On the ones that won’t update, the dialogue box appears normal but nothing gets saved (no prices saved under the security name). Nothing obvious linking the f

Re: [GNC] no printer to select in print dialog

2019-03-19 Thread Geert Janssens
Op maandag 11 maart 2019 04:48:03 CET schreef Chris Roy-Smith: > On 10/3/19 7:45 pm, Colin Law wrote: > > Thanks Chris. That could indeed be useful. One should always > > remember, though, that with a ppa one is reliant on the integrity of > > the packager to build what you are expecting. There

Re: [GNC] Example of multi-split feature of CSV importer?

2019-03-19 Thread David Carlson
There are many places in GnuCash where the presently selected account determines the definition of which account is not presently selected, and two line vs three or more lines in transactions is definitely one where I was confused for a long time. Another place where this is incredibly confusing i

Re: [GNC] End of year rollover

2019-03-19 Thread Adrien Monteleone
Welcome to GnuCash! There is a ‘close books’ procedure you can use that zeros expenses and income to equity as ‘retained earnings/losses’ but you don’t have to use it. GnuCash does not require that you clear anything out at the end of the year. (and doing so can impact your ability to run repor

Re: [GNC] Example of multi-split feature of CSV importer?

2019-03-19 Thread Michael Hendry
> On 19 Mar 2019, at 01:19, D via gnucash-user wrote: > > Michael, Adrien, > > Section 4.3 in the Guide is titled "Simple vs. Split Transactions" and > explains in some detail what is meant. Perhaps the language there is not > clear enough (improvements always welcome!), but it's not true tha

[GNC] End of year rollover

2019-03-19 Thread garage cowboy
Hi - I am a new gnucash user ( just a few weeks). First of all, congratulations and thanks to all those who have contributed to this great product. My question is about EOFY processes - I am used to products which have an end of year rollover process which clears reconciled transactions

Re: [GNC] Example of multi-split feature of CSV importer?

2019-03-19 Thread Geert Janssens
Op maandag 18 maart 2019 23:43:34 CET schreef Michael Hendry: > Michael Hendry > (my email address has my surname and first name in that order because > michael.hendry… was already taken when I signed up!) Oops, sorry for missing this. Probably I'm still a bit jetlagged. Geert