Re: [GNC] New report

2018-06-14 Thread Christopher Lam
Hi Stephen I cannot help with getting eguile reports loaded, but would be very interested in feedback from a trained accountant. What is wrong with the balance sheet, and how should it look like? Would you be kind to offer an annotated sample? The current reports can be fixed. Regards On 15 June 2

[GNC] CSV tool

2018-06-14 Thread Plutocrat
I recently came across this tool for manipulating CSV data. It allows you to query a CSV file with SQL-like syntax. I thought that as there's a lot of that sort of thing going on in this group, some of you might find is useful. http://harelba.github.io/q/ eg: q "SELECT COUNT(*) FROM ./clicks_f

Re: [GNC] QIF Import in GnuCash 3.1

2018-06-14 Thread GT-I9070 H
Em qui, 14 de jun de 2018 às 15:14, David Carlson < david.carlson@gmail.com> escreveu: > Daniel, > > ... GT-I9070 H, you are out of line. Do not insult the developers if you > want them to help you. > > David C > Where did you get this statement? F..K U DUDE. Are you crazy, are you looking

Re: [GNC] Dock Icon on Mac

2018-06-14 Thread John Ralls
Interesting. The dmg shouldn’t matter as the app itself is signed with an Apple Developer certificate. You can check that by running codesign -vvd /Applications/Gnucash.app which, if you’re using the latest Mac build, should return Executable=/Applications/Gnucash.app/Contents/MacOS/Gnucash

Re: [GNC] Dock Icon on Mac

2018-06-14 Thread Glen Byram (Gmail)
Partially solved! i.e. I think I know what is wrong, but not why it happened to this particular App. Short answer: Gnucash is in quarantine due to a Mac OS feature called Gatekeeper Path Randomization (GPR). Running the following command in a Terminal window removes the quarantine flag xattr -dr

Re: [GNC] Dock Icon on Mac

2018-06-14 Thread Glen Byram (Gmail)
Here is a bit more information. I looked directly at the dock plist (com.apple.dock.plist). The entry for Gnucash looks very strange. In the situation where the icon was created using "Keep In Dock" while Gnucash is executing, after quitting Gnucash and examining the Dock plist the entry for Gnu

Re: [GNC] New report

2018-06-14 Thread Stephen M. Butler
Yes. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/14/2018 03:45 PM, Derek Atkins wrote: > Did you change the report GUID as well as the na

Re: [GNC] Spinouts

2018-06-14 Thread Les
Thanks, David.  I will check it out. Les On 06/14/2018 04:57 PM, David Carlson wrote: Les there is a detailed section in the help about that. David C On Thu, Jun 14, 2018 at 1:57 PM, Les > wrote: I recently had a stock that spunout and equal number of shares

Re: [GNC] New report

2018-06-14 Thread Derek Atkins
Did you change the report GUID as well as the name? -derek Sent using my mobile device. Please excuse any typos. On June 14, 2018 6:20:01 PM "Stephen M. Butler" wrote: I modified /usr/share/gnucash/scm/gnucash/report/balsheet-eq.scm (and related files) and gave them a new name of balsheet-fmtd

[GNC] New report

2018-06-14 Thread Stephen M. Butler
I modified /usr/share/gnucash/scm/gnucash/report/balsheet-eq.scm (and related files) and gave them a new name of balsheet-fmtd.scm (etc). However, when I fire up GnuCash, the new report does not appear.  This seems to be consistent with the documentation shared with me earlier today.  However, I h

Re: [GNC] Spinouts

2018-06-14 Thread David Carlson
Les there is a detailed section in the help about that. David C On Thu, Jun 14, 2018 at 1:57 PM, Les wrote: > I recently had a stock that spunout and equal number of shares to a new > entity. How is this handled in GC? Do I use the Split Transaction feature? > > Thanks, > > Les > > __

Re: [GNC] Dock Icon on Mac

2018-06-14 Thread Adrien Monteleone
On this note, Are you installing to “/Applications” or “/Users/your-user/Applications”? Either should be fine, but if you do have some corruption in your user profile, installing to /Applications might help. Regards, Adrien > On Jun 14, 2018, at 2:28 PM, Adrien Monteleone > wrote: > > Try c

Re: [GNC] Dock Icon on Mac

2018-06-14 Thread Adrien Monteleone
It does happen when running from the dmg and then eject it, but the OP specifically noted they were running it from Applications. Regards, Adrien > On Jun 14, 2018, at 3:33 PM, Eric Sokolowsky wrote: > > I have seen this behavior with gimp. I believe it happens because the > application is ru

Re: [GNC] Dock Icon on Mac

2018-06-14 Thread Eric Sokolowsky
I have seen this behavior with gimp. I believe it happens because the application is run from the dmg. If you copy it to applications or the desktop from the dmg the problem might go away. I'm going to try this with gimp too. Eric On Thu, Jun 14, 2018, 3:30 PM Adrien Monteleone < adrien.montele..

Re: [GNC] Dock Icon on Mac

2018-06-14 Thread Adrien Monteleone
Try creating another user account on the Mac. Add GnuCash to dock and see if the problem persists. It might be an issue with prefs files for your user account. If you don’t want to go that route, or in conjunction with doing so, when the question mark appears, try either Force Quitting (technica

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. > > David C > > On Thu,

Re: [GNC] Dock Icon on Mac

2018-06-14 Thread Glen Byram (Gmail)
Yes, it certainly is annoying. As we speak, Gnucash has just got its grey question mark. The machine has been woken up for about the 10th time since I last did "Keep in Dock". No full restart in that time (I rarely do with the mac). No issue at all the previous 9 or so "wake-ups. I am starting t

Re: [GNC] QIF Import in GnuCash 3.1

2018-06-14 Thread David Carlson
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. David C On Thu, Jun 14, 2018 at 11:42 AM, GT-I9070 H wrote: > Yes Daniel, > This always happens after a major update of GnuCash and it happene

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 > after 2.6.20 to

[GNC] Spinouts

2018-06-14 Thread Les
I recently had a stock that spunout and equal number of shares to a new entity.  How is this handled in GC?  Do I use the Split Transaction feature? Thanks, Les ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription prefer

Re: [GNC] Report updates

2018-06-14 Thread Stephen M. Butler
Aha!  Thank you. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/14/2018 11:54 AM, John Ralls wrote: > >> On Jun 14, 2018, at 11:24 AM, Steph

Re: [GNC] Report updates

2018-06-14 Thread John Ralls
> On Jun 14, 2018, at 11:24 AM, Stephen M. Butler wrote: > > What is the general policy on changes to reports? Create a new one with > a new name or update the existing one? > > My wife is an accountant and she liked the formatting of the Balance > Sheet eguile over the standard Balance Shee

[GNC] Report updates

2018-06-14 Thread Stephen M. Butler
What is the general policy on changes to reports?  Create a new one with a new name or update the existing one? My wife is an accountant and she liked the formatting of the Balance Sheet eguile over the standard Balance Sheet report.  But she felt it was too busy with the totals and sub-totals bei

Re: [GNC] QIF Import in GnuCash 3.1

2018-06-14 Thread GT-I9070 H
Yes Daniel, This always happens after a major update of GnuCash and it happened again after 2.6.20 to 3.0 and it's not just with your language. Now it is to wait for the developers to solve this. Regards Em qui, 14 de jun de 2018 às 03:48, Daniel Rosenberg escreveu: > Hi, > > I recently upgr

Re: [GNC] QIF Import in GnuCash 3.1

2018-06-14 Thread John Ralls
> On Jun 14, 2018, at 7:01 AM, John Ralls wrote: > > > >> On Jun 14, 2018, at 12:48 AM, Daniel Rosenberg wrote: >> >> Hi, >> >> I recently upgraded from GnuCash 2.6.19 to 3.1 (Windows 10). >> I use the Gnucash app for Android to record transactions on the go and >> later import them to the

Re: [GNC] Updated to 3.1 - lost lots & report

2018-06-14 Thread Adrien Monteleone
If you are using one of the database backends there have been some issues with reading data on startup. Your data is probably still there, just not being read in and displayed. You may have discovered another case of this. (the previous case was business feature related) Saved Report Configurat

Re: [GNC] Gnucash won't open?

2018-06-14 Thread John Ralls
> On Jun 14, 2018, at 1:44 AM, Maf. King wrote: > > On Thursday, 14 June 2018 01:11:14 BST Gyle McCollam wrote: >> I tried opening gnucash, I have been using for over 2 years, and it tells me >> it can’t get a lock. I select open anyway and it shows on the windows 10 >> taskbar, show a preview

Re: [GNC] Dock Icon on Mac

2018-06-14 Thread Adrien Monteleone
I don’t think a second executable is the issue. I frequently see this problem with Firefox. Occasionally after it updates and re-launches, it will drop a new icon on the far right of my dock for that updated instance. I just close it and relaunch it as normal with the original icon. (which uses

Re: [GNC] QIF Import in GnuCash 3.1

2018-06-14 Thread John Ralls
> On Jun 14, 2018, at 12:48 AM, Daniel Rosenberg wrote: > > Hi, > > I recently upgraded from GnuCash 2.6.19 to 3.1 (Windows 10). > I use the Gnucash app for Android to record transactions on the go and > later import them to the desktop version. The exported QIF file is in UTF-8 > format and i

Re: [GNC] UNABLE TO RUN GNU-CASH

2018-06-14 Thread Adrien Monteleone
Did you not get a Mac crash report when it disappeared? Check Console.app usually under User Reports. You could try running from the command line to see if there are any errors reported: Open Terminal.app (from launchpad or using spotlight) Type the following: /Applications/Gnucash.app/Content

Re: [GNC] Autofill with Open Date?

2018-06-14 Thread Adrien Monteleone
Not sure how a customer report relates to your credit card expenses (did you mean Vendor report?), but you can run transaction reports and key off of Description (your payee/vendor). A/P is for situations where the payment and expense are not at the same time. That’s not the case with a charge

Re: [GNC] Updated to 3.1 - lost lots & report

2018-06-14 Thread Ken Schneider
On 06/14/2018 04:37 AM, John Bonnett wrote: From: Ethan Swint Date: 14/06/2018 3:18 PM Hi - I just made the jump from 2.6 to 3.1, but I found that I lost all of my lot info for stocks and my saved report configurations. My google-fu is not good WRT scanning the list, so if any have encount

Re: [GNC] Gnucash won't open?

2018-06-14 Thread Maf. King
On Thursday, 14 June 2018 01:11:14 BST Gyle McCollam wrote: > I tried opening gnucash, I have been using for over 2 years, and it tells me > it can’t get a lock. I select open anyway and it shows on the windows 10 > taskbar, show a preview when hovered over the icon, but will not open for > use.

[GNC] Updated to 3.1 - lost lots & report

2018-06-14 Thread John Bonnett
From: Ethan Swint Date: 14/06/2018 3:18 PM Hi - I just made the jump from 2.6 to 3.1, but I found that I lost all of my lot info for stocks and my saved report configurations. My google-fu is not good WRT scanning the list, so if any have encountered similar situation, I'd be much obliged. T

[GNC] Gnucash won't open?

2018-06-14 Thread Gyle McCollam
I tried opening gnucash, I have been using for over 2 years, and it tells me it can’t get a lock. I select open anyway and it shows on the windows 10 taskbar, show a preview when hovered over the icon, but will not open for use. I tried shutting down the computer and restarting, but that didn’

[GNC] QIF Import in GnuCash 3.1

2018-06-14 Thread Daniel Rosenberg
Hi, I recently upgraded from GnuCash 2.6.19 to 3.1 (Windows 10). I use the Gnucash app for Android to record transactions on the go and later import them to the desktop version. The exported QIF file is in UTF-8 format and includes some german language special characters (ü, ö, ä, ß) which are cor