Re: [GNC] [GNC-dev] Launchpad

2019-01-03 Thread Andrew Ruthven
Given Gnucash is a compiled binary, it will need to be compiled against
specific major versions of shared libraries. You need to have the
matching libraries available.

Building the package against the required versions of Ubuntu will be
required to link against the available versions of the libraries.

Cheers,
Andrew

On Thu, 2019-01-03 at 21:51 +, Colin Law wrote:
> Managed to give
> http://mirrors.kernel.org/ubuntu/pool/universe/g/gnucash/gnucash_3.4-
> 1_amd64.deb
> a quick try on 18.10 and it fails to install with lots of missing
> packages, and apt install -f just says it is going to remove the
> partially install gnucash again, which I think means the packages are
> not available on 18.10.  I assume it will be the same or worse on
> 18.04.
> 
> Colin
> 
> On Thu, 3 Jan 2019 at 21:46, Stephen M. Butler 
> wrote:
> > 
> > Thanks.  I checked the trusty and others and they had older
> > versions.
> > So, maybe not so good news.
> > 
> > But, if I can get his debian folder
> > 
> > On 1/3/19 1:34 PM, Colin Law wrote:
> > > On Thu, 3 Jan 2019 at 21:28, Stephen M. Butler 
> > > wrote:
> > > > mirrors.kernel.org/ubuntu
> > > >  > > > sh_3.4-1_amd64.deb>
> > > > 
> > > > Colin, do you have a machine on which this can be tested?
> > > 
> > > Yes, on Ubuntu 18.10.  Note that I think this is intended for
> > > disco
> > > (19.04) so whether there will be problems with 18.10 or 18.04
> > > remains
> > > to be seen.  I can't try it till tomorrow though (it is late
> > > evening
> > > here in UK).
> > > 
> > > Colin
> > > 
> > 
> > --
> > 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
> > 
> 
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> 
-- 
Andrew Ruthven, Wellington, New Zealand
and...@etc.gen.nz  | linux.conf.au 2019, Christchurch, NZ
Catalyst Cloud:    |    https://lca2019.linux.org.au/
   https://catalystcloud.nz|
___
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] Trying to install GNUcash 3.4.1 on IMac

2019-01-03 Thread John Ralls
It’s a lot easier to find and review crash reports--and logs in general, though 
sadly not gnucash.trace--with /Applications/Utilities/Console.app.

Regards,
John Ralls


> On Jan 3, 2019, at 5:14 PM, Robert Ratliff  wrote:
> 
> Crash reports on mac can be found under your user folder, under
> "~/Library/Logs/DiagnosticReports". A way to get there in Finder is use the
> "go" menu -> Go to folder -> type in "~/Library/Logs/DiagnosticReports" If
> you see any starting with Gnucash those can be uploaded to provide more
> information to the developers.
> 
> The crash reports theoretically could contain sensitive information so
> consider that before sharing.
> 
> On Thu, Jan 3, 2019 at 1:02 AM Ronnie H  wrote:
> 
>> I’m running GNUcash 3.3.+ (2018-09-29) on the following:
>> 
>> IMac 2.7 GHz Intel Core i5
>> 8 GB Ram
>> MacOS Mojave Version 10.14.2
>> 
>> It has started crashing occasionally. Sometimes when I am starting it, and
>> sometimes when I am using it.
>> 
>> I have down loaded GNUcash 3.4.1 from sourceforge.net <
>> http://sourceforge.net/> 3 times but when I click open, it just stops and
>> quits running.
>> 
>> See attached screen shot
>> 
>> ___
>> 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.
> 
> 
> 
> -- 
> Bobby Ratliff
> blog: https://www.rratliff.com
> twitter: @_bobbyratliff
> ___
> 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] Trying to install GNUcash 3.4.1 on IMac

2019-01-03 Thread D via gnucash-user
Funny. On my Mac (Mojave as well), I have side by side dock icons for 2.6.19 
and 3.3. Both work.

David T.

On January 4, 2019, at 2:06 AM, Adrien Monteleone 
 wrote:

Interesting. There has been some issue with phantom dock icons in the past. 
This is the first I’ve seen of an older version’s icon interfering.

I’d say you might want to file a bug, but I suspect it would be a MacOS or GTK 
bug and not specific to GnuCash.

Glad you got it resolved.

Regards,
Adrien

> On Jan 3, 2019, at 6:45 AM, Ronnie H  wrote:
> 
> I believe my problem was the fact that I had GNUcash 3.3.1 setting on my 
> dock. 
> 
> I moved GNUcash 3.4.1 to my desktop, right click to open, then confirmed and 
> the 3.4.1 Icon that came up on the doc as running went away.
> 
> I removed the 3.3.1 Icon I use to start it with from the doc and then 3.4.1 
> came up and ran fine. To be clear, 3.3.1 was not running at the time I tried 
> to run 3.4.1.
> 
> Thanks for your help.
> 
> Ron
> 
> 
>> On Jan 3, 2019, at 3:58 AM, Adrien Monteleone 
>>  wrote:
>> 
>> The screenshot didn’t make it through.
>> 
>> To be sure, did you ‘install’ the application to your /Applications folder 
>> or some other folder *outside* of the .dmg and *onto* your hard drive or are 
>> you trying to simply run the app from inside the .dmg? (you can’t do that by 
>> the way)
>> 
>> Once copied to your /Applications folder, you’ll need to navigate there 
>> using Finder, right-click on the app and choose “Open” and then confirm in 
>> the pop-up dialog that you want to open the app. It should run, but if not, 
>> simply double left-click it and it should run fine from then on.
>> 
>> Regards,
>> Adrien
>> 
>>> On Jan 2, 2019, at 10:57 AM, Ronnie H  wrote:
>>> 
>>> I’m running GNUcash 3.3.+ (2018-09-29) on the following:
>>> 
>>> IMac 2.7 GHz Intel Core i5
>>> 8 GB Ram
>>> MacOS Mojave Version 10.14.2
>>> 
>>> It has started crashing occasionally. Sometimes when I am starting it, and 
>>> sometimes when I am using it.
>>> 
>>> I have down loaded GNUcash 3.4.1 from sourceforge.net 
>>>  3 times but when I click open, it just stops and 
>>> quits running.
>>> 
>>> See attached screen shot
>>> 
>>> ___
>>> 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.
> 
> 


___
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] Car loan with downpayment using a credit card

2019-01-03 Thread Adrien Monteleone
When you imported transactions, were the downpayment(s) not part of that 
download?

If so, how were they assigned on the other end of the transaction at import?

Something that might help, if you aren’t already using it, is to turn on 
Transaction Journal view in the View menu. You can also set this as a default 
setting from Preferences. This will show you all splits in all transactions at 
all times. One split will always be for the current account register you are 
viewing, the others will be for the other side(s) of the transaction.

For each downpayment, you should have something similar to:

Cr. Assets:Checking OR Liabilities:Credit Card
Dr. Liabilities:Car Loan

Thus the three credit card payments would offset the Car Loan liability with 
increases (credits) to the respective Credit Card liabilities, and the Cheque 
would reflect a decrease (credit) in your checking account.

Hope that helps.

Regards,
Adrien

> On Jan 3, 2019, at 7:06 PM, Taymour A. El Erian  wrote:
> 
> Hi,
> I am very new to GNUCash so bear with me. I have setup my assets (bank
> accounts, Car) and also my liabilities (Car loan, Credit Cards) and
> imported all the transactions from my banking institutions and credit cards
> too. I added the Car (asset and loan) later to the setup and now struggling
> to get the down payment made for the car to show under the asset.
> I made the down payment using 3 different cards and a cheque. As I said I
> added the car loan later after setting everything up and all accounts are
> balanced. Now I am trying to get those few months old down payment
> transactions to show as split under the asset so that my liability would be
> (total value - down payment - payments). Any help
> 
> 
> 
> *Taymour*
> ___
> 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] Car loan with downpayment using a credit card

2019-01-03 Thread Stephen M. Butler
On 1/3/19 5:06 PM, Taymour A. El Erian wrote:
> Hi,
> I am very new to GNUCash so bear with me. I have setup my assets (bank
> accounts, Car) and also my liabilities (Car loan, Credit Cards) and
> imported all the transactions from my banking institutions and credit cards
> too. I added the Car (asset and loan) later to the setup and now struggling
> to get the down payment made for the car to show under the asset.
> I made the down payment using 3 different cards and a cheque. As I said I
> added the car loan later after setting everything up and all accounts are
> balanced. Now I am trying to get those few months old down payment
> transactions to show as split under the asset so that my liability would be
> (total value - down payment - payments). Any help
>
>
>
> *Taymour
Car Transaction #1:

Asset:Car:  DR -- full price of car
Liability:CC(s) -- CR amt put on card that totals to down payment
Liability:Loans:Car -- CR loan amount.

Asset:Car value = Liability:CC(s) value + Liability:Loan:car (original
loan amt)

[I would expect some expense accounts for licensing and other fees that
would be part of this first transaction}

Monthly payment transaction(s):

Expense:Interest paid  -- DR interest amount of payment
Liability:Loans:Car -- DR payment principle amount
Asset:Checking -- CR loan payment amount

Credit card payoff transaction(s):

Liability:CC(s) -- DR amount paid to each CC
Asset:Checking -- CR amount paid to each CC

Without checking with the house accountant <>, that's how I would
set it up.

--Steve

-- 
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



pEpkey.asc
Description: application/pgp-keys
___
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] Getting the date order in a report ?

2019-01-03 Thread Christopher Lam
This set of options sounds about right. What's the output? You can attach a
screenshot, blanking out confidential data.
Don't forget to set General/Add options summary to 'always'

On Thu, 27 Dec 2018 at 17:47, Finbar Mahon  wrote:

> Thanks, but I am not too sure what options I should chose to get the
> registry sort order.
>
> I used the edit>report options and after bit of fiddling I have a result
> by month in 'proper' date order.
>
> That is OK, but I would like to get Source of Salary from Income >
> Salary and annual/by month, in date order.
>
> The selection I have under report options > sorting is -
>
> Primary Key - Account Name; Primary Subtotal clicked; Primary Sort order
> -  Ascending; Secondary Key - date; Secondary Subtotal for date key -
> monthly
>
> I am using 2.6.19 on Windows 10
>
> Barry
>
> On 24/12/2018 20:18, David Carlson wrote:
> > I am not sure if this will help.  Check that the register sort order
> > is set to date posted.  If that does not work please let us know which
> > GnuCash release you are using and your operating system.
> >
> > David C
> >
> > On Mon, Dec 24, 2018, 4:49 AM Finbar Mahon  >  wrote:
> >
> > Hello, this is not urgent, just so I don't forget.
> >
> > I am trying to print a listing of salary payments for the year.
> >
> > I have selected the description for the transaction report and the
> > data
> > I want appears, fine.
> >
> > However the dates are random, typically the output is date, the
> > description, the amount, but the sequence of the dates is all over
> > the
> > place.
> >
> > I've looked through and selected the various options I think I
> > need but
> > cannot find a way of getting things in date order.
> >
> > Ideas?
> >
> > Thanks, and best wishes of the season, Barry
> >
> > ___
> > 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.
___
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] Trying to install GNUcash 3.4.1 on IMac

2019-01-03 Thread Robert Ratliff
Crash reports on mac can be found under your user folder, under
"~/Library/Logs/DiagnosticReports". A way to get there in Finder is use the
"go" menu -> Go to folder -> type in "~/Library/Logs/DiagnosticReports" If
you see any starting with Gnucash those can be uploaded to provide more
information to the developers.

The crash reports theoretically could contain sensitive information so
consider that before sharing.

On Thu, Jan 3, 2019 at 1:02 AM Ronnie H  wrote:

> I’m running GNUcash 3.3.+ (2018-09-29) on the following:
>
>  IMac 2.7 GHz Intel Core i5
> 8 GB Ram
> MacOS Mojave Version 10.14.2
>
> It has started crashing occasionally. Sometimes when I am starting it, and
> sometimes when I am using it.
>
> I have down loaded GNUcash 3.4.1 from sourceforge.net <
> http://sourceforge.net/> 3 times but when I click open, it just stops and
> quits running.
>
> See attached screen shot
>
> ___
> 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.



-- 
Bobby Ratliff
blog: https://www.rratliff.com
twitter: @_bobbyratliff
___
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] Car loan with downpayment using a credit card

2019-01-03 Thread Taymour A. El Erian
Hi,
I am very new to GNUCash so bear with me. I have setup my assets (bank
accounts, Car) and also my liabilities (Car loan, Credit Cards) and
imported all the transactions from my banking institutions and credit cards
too. I added the Car (asset and loan) later to the setup and now struggling
to get the down payment made for the car to show under the asset.
I made the down payment using 3 different cards and a cheque. As I said I
added the car loan later after setting everything up and all accounts are
balanced. Now I am trying to get those few months old down payment
transactions to show as split under the asset so that my liability would be
(total value - down payment - payments). Any help



*Taymour*
___
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] [GNC-dev] Launchpad

2019-01-03 Thread Adrien Monteleone
I found this:

https://lists.gnucash.org/pipermail/gnucash-user/2019-January/081695.html

noting that the following needed to be installed:

libboost-filesystem1.65.1
libboost-date-time1.65.1
libboost-locale1.65.1
libboost-regex1.65.1

But my error was for 1.58, not 1.65 missing

I installed them anyway, with no effect on the error. (as expected)

After some investigation, it seems 1.58 was in Xenial. (this was the original 
OS installed in this VM and it has undergone two in-place upgrades to Bionic 
and now Cosmic) It seems the upgrade didn’t play nice and now my software is 
still looking for old versions of libraries. (or the Xenial version of GnuCash 
didn’t uninstall properly)

I downloaded the libboost-date-time1.58 deb but that gave me another 
dependency, which I downloaded and upon trying to install that, was hit with 
about 6 more dependencies.

I’m giving up.

Perhaps a fresh Cosmic install will play much nicer.

At this point, it would be much simpler just to build from source.

Sorry I couldn’t give you a definitive “It works!”

Regards,
Adrien

> On Jan 3, 2019, at 4:24 PM, Adrien Monteleone 
>  wrote:
> 
> I have a Cosmic VM handy so I tested the Disco .deb via “dpkg -i” and here 
> was the result:
> 
> 
> dpkg: dependency problems prevent configuration of gnucash:
> gnucash depends on gnucash-common (= 1:3.4-1); however:
>  Package gnucash-common is not installed.
> gnucash depends on libboost-regex1.67.0 (>= 1.67.0-10); however:
>  Package libboost-regex1.67.0 is not installed.
> gnucash depends on libicu63 (>= 63.1-1~); however:
>  Package libicu63 is not installed.
> gnucash depends on libpython3.7 (>= 3.7.0); however:
>  Package libpython3.7 is not installed.
> gnucash depends on libfinance-quote-perl; however:
>  Package libfinance-quote-perl is not installed.
> gnucash depends on libhtml-tableextract-perl; however:
>  Package libhtml-tableextract-perl is not installed.
> 
> dpkg: error processing package gnucash (--install):
> dependency problems - leaving unconfigured
> 
> I did an ‘apt search’ on the missing dependencies with the following results:
> 
> gnucash-common, libicu63 (“International Components for Unicode”) and the 
> required version of libboost-regex1.67.0 are not in Cosmic, you’ll need to 
> download them from Disco.
> 
> gnucash-common: https://packages.ubuntu.com/disco/gnucash-common
> 
> libicu63: https://packages.ubuntu.com/disco/libicu63
> 
> libboost-regex1.67.0: https://packages.ubuntu.com/disco/libboost-regex1.67.0
> 
> Download those files, but do not install them yet.
> 
> First, install these:
> 
> sudo apt libfinance-quote-perl libhtml-tableextract-perl libpython3.7 
> libpython3.7-minimal libpython3.7-stdlib
> 
> (those last two are dependencies of libpython3.7 and are in Cosmic)
> 
> 
> *adjust the following package names for your architecture:
> 
> 
> Then install libboost-regex1.67.0:
> 
> sudo dpkg -i libboost-regex1.67.0_1.67.0-11_amd64.deb
> 
> 
> 
> Then install libicu63:
> 
> sudo dpkg -i libicu63_63.1-5_amd64.deb
> 
> 
> 
> Then instal gnucash-common:
> 
> sudo dpkg -i gnucash-common_3.4-1_all.deb
> 
> 
> 
> Then finally, install gnucash:
> 
> sudo dpkg -i gnucash_3.4-1_amd64.deb
> 
> --
> 
> Note that I went in reverse as I was trying to find and then install the 
> dependencies, so at some point, I got the advice from apt to try ‘apt 
> --fix-broken install’ which pulled in libfinance-quote-perl 
> libhtml-tableextract-perl libpython3.7 libpython3.7-minimal 
> libpython3.7-stdlib as the rest was already installed but not completely 
> configured.
> 
> Now, GC still doesn’t run and I’m getting an error:
> 
> gnucash: error while loading shared libraries: libboost_date_time.so.1.58.0: 
> cannot open shared object file: No such file or directory
> 
> I recall someone encountered that in the *.deb thread, so I’ll go look there 
> to see if there was a resolution. This file doesn’t appear to be in any 
> ubuntu repos.
> 
> Regards,
> Adrien
> 
> 
> 
>> On Jan 3, 2019, at 3:46 PM, Stephen M. Butler  wrote:
>> 
>> Thanks.  I checked the trusty and others and they had older versions. 
>> So, maybe not so good news.
>> 
>> But, if I can get his debian folder
>> 
>> On 1/3/19 1:34 PM, Colin Law wrote:
>>> On Thu, 3 Jan 2019 at 21:28, Stephen M. Butler  wrote:
 mirrors.kernel.org/ubuntu
 
 
 Colin, do you have a machine on which this can be tested?
>>> Yes, on Ubuntu 18.10.  Note that I think this is intended for disco
>>> (19.04) so whether there will be problems with 18.10 or 18.04 remains
>>> to be seen.  I can't try it till tomorrow though (it is late evening
>>> here in UK).
>>> 
>>> Colin
>>> 
>> 
>> -- 
>> 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
>> 
>> 

Re: [GNC] Tutorial for moving stock between accounts?

2019-01-03 Thread Michael via gnucash-user
When I do a transfer I price the removal and addition transactions at cost.  
Then there is no gain/loss/ or orphan entry to deal with and the cost data is 
preserved.  Don't know where I got that idea, but it seems to work.  Mike


-Original Message-
From: David T. via gnucash-user 
To: oddh...@sonic.net ; Gnucash Users 

Sent: Wed, Jan 2, 2019 11:04 pm
Subject: Re: [GNC] Tutorial for moving stock between accounts?


Well, now that you have it mostly right, maybe go in to the second account 
register and see whether you can change the second split price to zero from 
there, using the same tabbing technique. 
 
 
  On Thu, Jan 3, 2019 at 12:23, Jon Leech wrote:  On Wed, 
Jan 02, 2019 at 05:38:13PM +0530, D wrote:
> Jon,
>
> I can't test this right now, since I'm not at my machine...
>
> Try this:
>
> Open your source account.
>
> Move to the entry point in the register.
>
> Click the 'Split' button. Enter your description.
>
> Tab to the Shares field in the first split and type -13.
>
> Tab to the price field and type 0.
>
> Now, use **tab** to move to the Transfer field on the second line, set it to 
> your destination account and tab to shares and type 13.
>
> Does that work?

    Thanks! This works, for the most part. The share counts in source
and destination accounts are altered correctly, which is enough to let
me do what I need. It does set a Price of 1 for the second line and a
Tot Buy of 13.00, and then creates a new Imbalance line in the split
with a Tot Sell of 13.00.

    I cannot change the Price to 0 on the second line, unlike the first.
Trying it results in it immediately being restored to 1, so the
Imbalance seems unavoidable. I can set the Price to a non-zero number
and make gnucash recalculate the Tot Buy / Imbalance fields, but that
seems pointless, since there is no actual Price or cash associated with
this transaction.

    Jon
___
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.
___
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] [GNC-dev] Launchpad

2019-01-03 Thread Adrien Monteleone
I have a Cosmic VM handy so I tested the Disco .deb via “dpkg -i” and here was 
the result:


dpkg: dependency problems prevent configuration of gnucash:
 gnucash depends on gnucash-common (= 1:3.4-1); however:
  Package gnucash-common is not installed.
 gnucash depends on libboost-regex1.67.0 (>= 1.67.0-10); however:
  Package libboost-regex1.67.0 is not installed.
 gnucash depends on libicu63 (>= 63.1-1~); however:
  Package libicu63 is not installed.
 gnucash depends on libpython3.7 (>= 3.7.0); however:
  Package libpython3.7 is not installed.
 gnucash depends on libfinance-quote-perl; however:
  Package libfinance-quote-perl is not installed.
 gnucash depends on libhtml-tableextract-perl; however:
  Package libhtml-tableextract-perl is not installed.

dpkg: error processing package gnucash (--install):
 dependency problems - leaving unconfigured

I did an ‘apt search’ on the missing dependencies with the following results:

gnucash-common, libicu63 (“International Components for Unicode”) and the 
required version of libboost-regex1.67.0 are not in Cosmic, you’ll need to 
download them from Disco.

gnucash-common: https://packages.ubuntu.com/disco/gnucash-common

libicu63: https://packages.ubuntu.com/disco/libicu63

libboost-regex1.67.0: https://packages.ubuntu.com/disco/libboost-regex1.67.0

Download those files, but do not install them yet.

First, install these:

sudo apt libfinance-quote-perl libhtml-tableextract-perl libpython3.7 
libpython3.7-minimal libpython3.7-stdlib

(those last two are dependencies of libpython3.7 and are in Cosmic)


*adjust the following package names for your architecture:


Then install libboost-regex1.67.0:

sudo dpkg -i libboost-regex1.67.0_1.67.0-11_amd64.deb



Then install libicu63:

sudo dpkg -i libicu63_63.1-5_amd64.deb



Then instal gnucash-common:

sudo dpkg -i gnucash-common_3.4-1_all.deb



Then finally, install gnucash:

sudo dpkg -i gnucash_3.4-1_amd64.deb

--

Note that I went in reverse as I was trying to find and then install the 
dependencies, so at some point, I got the advice from apt to try ‘apt 
--fix-broken install’ which pulled in libfinance-quote-perl 
libhtml-tableextract-perl libpython3.7 libpython3.7-minimal libpython3.7-stdlib 
as the rest was already installed but not completely configured.

Now, GC still doesn’t run and I’m getting an error:

gnucash: error while loading shared libraries: libboost_date_time.so.1.58.0: 
cannot open shared object file: No such file or directory

I recall someone encountered that in the *.deb thread, so I’ll go look there to 
see if there was a resolution. This file doesn’t appear to be in any ubuntu 
repos.

Regards,
Adrien



> On Jan 3, 2019, at 3:46 PM, Stephen M. Butler  wrote:
> 
> Thanks.  I checked the trusty and others and they had older versions. 
> So, maybe not so good news.
> 
> But, if I can get his debian folder
> 
> On 1/3/19 1:34 PM, Colin Law wrote:
>> On Thu, 3 Jan 2019 at 21:28, Stephen M. Butler  wrote:
>>> mirrors.kernel.org/ubuntu
>>> 
>>> 
>>> Colin, do you have a machine on which this can be tested?
>> Yes, on Ubuntu 18.10.  Note that I think this is intended for disco
>> (19.04) so whether there will be problems with 18.10 or 18.04 remains
>> to be seen.  I can't try it till tomorrow though (it is late evening
>> here in UK).
>> 
>> Colin
>> 
> 
> -- 
> 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
> 
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel


___
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] GNU generated report in HTML to XL

2019-01-03 Thread Adrien Monteleone
Sorry, I should have clarified, my tests were done on a Mac.

I don’t have a Windows setup to test.

I did find some forums concerning LO paste issues with respect to Windows 
however.

Regards,
Adrien

> On Jan 3, 2019, at 3:59 PM, David Carlson  wrote:
> 
> Hello All,
> 
> Happy New Year.
> 
> I am sending this from an Android tablet that sometimes makes really 
> punctuation and language errors, including dropping words like stupid from in 
> front of the word errors.
> 
> I have yet to solve my strange GMAIL problem in Firefox on my laptop, but I 
> did succeed in copying the message that was stuck in the drafts folder before 
> it crashed to a different machine and send it to the Gnucash user maillist,
>  Where it currently resides in the archive and in my sent folder of some of 
> my devices, but I am not sure if it was sent to others on the list.
> 
> I see that Adrien reports that he performed several tests with the current 
> versions of LibreOffice. And Gnucash in a windows environment without 
> encountering the problems that Barry has seen.  Not knowing exactly why he 
> wants to use that mix, it is hard to say whether certain rough edges are of 
> concern to him.  
> 
> Hopefully we are giving him clues that he will find helpful, and if he is 
> still having issues, more details about his situation.
> 
> David C 
> 
> 
> On Thu, Jan 3, 2019, 3:15 PM Adrien Monteleone 
>  I just tested the following using LibreOffice 6.1.0.3 and GnuCash 3.4:
> 
> 1. ctrl+a (select-all) and ctrl+c (copy) from the report within the GnuCash 
> report tab (not a saved file), then ctrl+v (paste) on a blank Calc 
> spreadsheet.
> 
> I was given a dialog to choose import coding, select my delimiters, and 
> otherwise fine-tune the import (paste) with a preview of my actual data.
> 
> The result is the data was imported without formatting into their respective 
> cells, except that ’Totals’ somehow had a newline character before the 
> figures which would necessitate some additional copy/paste to align them 
> correctly.
> 
> 2. Save the report to an .html file, open that file with Firefox and then 
> repeat the above select/copy/paste commands.
> 
> This gave me a less useful dialog box with little control over the end 
> result. I was able to only select the import language and asked if I wanted 
> to detect ’special numbers’ like dates.
> 
> I ended up with a formatted version of the report as it appeared in Firefox 
> but with each respective title or figure in a proper cell
> 
> 3. File > Open the .html file from within Calc as suggested by Chris Lam.
> 
> Without a dialog box, this resulted in a similar situation to #2, but with no 
> grid lines within the report. (like a sheet of paper overlaying the grid)
> 
> 4. Sheets > Insert Sheet from File (or Insert Sheet and then choose ‘From 
> File’ radio button)
> 
> I chose to ‘insert’ the .html file. This gave me the same dialog box as #2, 
> but the result was the same as #3. I could choose to insert before or after 
> the current sheet.
> 
> 
> Note, options 1-2 place the data on the current Calc notebook sheet.
> 
> Option 3 opens an entirely new workbook with only 1 sheet as your report. 
> (unless you’ve set default # of sheets higher)
> 
> Option 4 is *adding* a sheet to the notebook, so you can only place it before 
> or after the current one.
> 
> In every case, the data came through just fine, though I’d probably find 3 or 
> 4 most useful as everything is already lined up. If you wanted no empty 
> columns between your account titles and the values, 1 or 2 would work best, 
> but as noted, you’ll have to do some adjusting if you included parent account 
> total lines.
> 
> Though I used the keyboard shortcuts, Edit > Paste was always available. 
> Perhaps there is an issue with the workbook or the sheet itself that is 
> disabling it? Try a websearch on ‘Edit > Paste not available, just Paste 
> Only’ for LibreOffice.
> 
> A cursory search turns up possibilities of a protected sheet, a read-only 
> workbook, and a long-standing bug on the Windows platform that doesn’t seem 
> to be easily reproducible. However, for those first two possibilities, I 
> would think none of the paste functions would be available.
> 
> I also see a suggestion that 3rd party clipboard managers sometimes don’t 
> play nice with LO.
> 
> 
> Regards,
> Adrien
> 
> 
> > On Jan 3, 2019, at 6:09 AM, Finbar Mahon  wrote:
> > 
> > Thanks both, but I still seem to be having a problem.
> > 
> > I have a file -
> > 
> >  /gnu p
> > 
> > If I try to cut and paste the data to a new libreoffice calc file I get 
> > only 'paste only' as an option under >edit, and nothing else recognisable 
> > from >insert.
> > 
> > I have tried 'insert sheet' under >insert but only get the option to insert 
> > before or after and then cannot copy the 'new' sheet into an existing one, 
> > if I add 'after'
> > 
> > There doesn't seem to be a method of cut and paste directly, afaics.
> > 
> > Thanks, 

Re: [GNC] GNU generated report in HTML to XL

2019-01-03 Thread David Carlson
Hello All,

Happy New Year.

I am sending this from an Android tablet that sometimes makes really
punctuation and language errors, including dropping words like stupid from
in front of the word errors.

I have yet to solve my strange GMAIL problem in Firefox on my laptop, but I
did succeed in copying the message that was stuck in the drafts folder
before it crashed to a different machine and send it to the Gnucash user
maillist,
 Where it currently resides in the archive and in my sent folder of some of
my devices, but I am not sure if it was sent to others on the list.

I see that Adrien reports that he performed several tests with the current
versions of LibreOffice. And Gnucash in a windows environment without
encountering the problems that Barry has seen.  Not knowing exactly why he
wants to use that mix, it is hard to say whether certain rough edges are of
concern to him.

Hopefully we are giving him clues that he will find helpful, and if he is
still having issues, more details about his situation.

David C


On Thu, Jan 3, 2019, 3:15 PM Adrien Monteleone <
adrien.montele...@lusfiber.net wrote:

> I just tested the following using LibreOffice 6.1.0.3 and GnuCash 3.4:
>
> 1. ctrl+a (select-all) and ctrl+c (copy) from the report within the
> GnuCash report tab (not a saved file), then ctrl+v (paste) on a blank Calc
> spreadsheet.
>
> I was given a dialog to choose import coding, select my delimiters, and
> otherwise fine-tune the import (paste) with a preview of my actual data.
>
> The result is the data was imported without formatting into their
> respective cells, except that ’Totals’ somehow had a newline character
> before the figures which would necessitate some additional copy/paste to
> align them correctly.
>
> 2. Save the report to an .html file, open that file with Firefox and then
> repeat the above select/copy/paste commands.
>
> This gave me a less useful dialog box with little control over the end
> result. I was able to only select the import language and asked if I wanted
> to detect ’special numbers’ like dates.
>
> I ended up with a formatted version of the report as it appeared in
> Firefox but with each respective title or figure in a proper cell
>
> 3. File > Open the .html file from within Calc as suggested by Chris Lam.
>
> Without a dialog box, this resulted in a similar situation to #2, but with
> no grid lines within the report. (like a sheet of paper overlaying the grid)
>
> 4. Sheets > Insert Sheet from File (or Insert Sheet and then choose ‘From
> File’ radio button)
>
> I chose to ‘insert’ the .html file. This gave me the same dialog box as
> #2, but the result was the same as #3. I could choose to insert before or
> after the current sheet.
>
>
> Note, options 1-2 place the data on the current Calc notebook sheet.
>
> Option 3 opens an entirely new workbook with only 1 sheet as your report.
> (unless you’ve set default # of sheets higher)
>
> Option 4 is *adding* a sheet to the notebook, so you can only place it
> before or after the current one.
>
> In every case, the data came through just fine, though I’d probably find 3
> or 4 most useful as everything is already lined up. If you wanted no empty
> columns between your account titles and the values, 1 or 2 would work best,
> but as noted, you’ll have to do some adjusting if you included parent
> account total lines.
>
> Though I used the keyboard shortcuts, Edit > Paste was always available.
> Perhaps there is an issue with the workbook or the sheet itself that is
> disabling it? Try a websearch on ‘Edit > Paste not available, just Paste
> Only’ for LibreOffice.
>
> A cursory search turns up possibilities of a protected sheet, a read-only
> workbook, and a long-standing bug on the Windows platform that doesn’t seem
> to be easily reproducible. However, for those first two possibilities, I
> would think none of the paste functions would be available.
>
> I also see a suggestion that 3rd party clipboard managers sometimes don’t
> play nice with LO.
>
>
> Regards,
> Adrien
>
>
> > On Jan 3, 2019, at 6:09 AM, Finbar Mahon  wrote:
> >
> > Thanks both, but I still seem to be having a problem.
> >
> > I have a file -
> >
> >  /gnu p
> >
> > If I try to cut and paste the data to a new libreoffice calc file I get
> only 'paste only' as an option under >edit, and nothing else recognisable
> from >insert.
> >
> > I have tried 'insert sheet' under >insert but only get the option to
> insert before or after and then cannot copy the 'new' sheet into an
> existing one, if I add 'after'
> >
> > There doesn't seem to be a method of cut and paste directly, afaics.
> >
> > Thanks, Barry
> >
> > On 02/01/2019 17:51, David Carlson wrote:
> >> Finbar,
> >>
> >> You may need to first open a new blank spreadsheet then cut and paste
> from the html document into the spreadsheet rather than trying to directly
> open HTML with Calc.
> >>
> >> My experience with LibreOffice Calc is that it will import several
> different kinds of files.  I 

Re: [GNC] [GNC-dev] Launchpad

2019-01-03 Thread Stephen M. Butler
Shucks!  I had High Hopes:  https://www.youtube.com/watch?v=Buq40brGDTY


On 1/3/19 1:51 PM, Colin Law wrote:
> Managed to give
> http://mirrors.kernel.org/ubuntu/pool/universe/g/gnucash/gnucash_3.4-1_amd64.deb
> a quick try on 18.10 and it fails to install with lots of missing
> packages, and apt install -f just says it is going to remove the
> partially install gnucash again, which I think means the packages are
> not available on 18.10.  I assume it will be the same or worse on
> 18.04.
>
> Colin
>
> On Thu, 3 Jan 2019 at 21:46, Stephen M. Butler  wrote:
>> Thanks.  I checked the trusty and others and they had older versions.
>> So, maybe not so good news.
>>
>> But, if I can get his debian folder
>>
>> On 1/3/19 1:34 PM, Colin Law wrote:
>>> On Thu, 3 Jan 2019 at 21:28, Stephen M. Butler  wrote:
 mirrors.kernel.org/ubuntu
 

 Colin, do you have a machine on which this can be tested?
>>> Yes, on Ubuntu 18.10.  Note that I think this is intended for disco
>>> (19.04) so whether there will be problems with 18.10 or 18.04 remains
>>> to be seen.  I can't try it till tomorrow though (it is late evening
>>> here in UK).
>>>
>>> Colin
>>>
>> --
>> 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
>>

-- 
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



pEpkey.asc
Description: application/pgp-keys
___
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] [GNC-dev] Launchpad

2019-01-03 Thread Colin Law
Managed to give
http://mirrors.kernel.org/ubuntu/pool/universe/g/gnucash/gnucash_3.4-1_amd64.deb
a quick try on 18.10 and it fails to install with lots of missing
packages, and apt install -f just says it is going to remove the
partially install gnucash again, which I think means the packages are
not available on 18.10.  I assume it will be the same or worse on
18.04.

Colin

On Thu, 3 Jan 2019 at 21:46, Stephen M. Butler  wrote:
>
> Thanks.  I checked the trusty and others and they had older versions.
> So, maybe not so good news.
>
> But, if I can get his debian folder
>
> On 1/3/19 1:34 PM, Colin Law wrote:
> > On Thu, 3 Jan 2019 at 21:28, Stephen M. Butler  wrote:
> >> mirrors.kernel.org/ubuntu
> >> 
> >>
> >> Colin, do you have a machine on which this can be tested?
> > Yes, on Ubuntu 18.10.  Note that I think this is intended for disco
> > (19.04) so whether there will be problems with 18.10 or 18.04 remains
> > to be seen.  I can't try it till tomorrow though (it is late evening
> > here in UK).
> >
> > Colin
> >
>
> --
> 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
>
___
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] [GNC-dev] Launchpad

2019-01-03 Thread Stephen M. Butler
Thanks.  I checked the trusty and others and they had older versions. 
So, maybe not so good news.

But, if I can get his debian folder

On 1/3/19 1:34 PM, Colin Law wrote:
> On Thu, 3 Jan 2019 at 21:28, Stephen M. Butler  wrote:
>> mirrors.kernel.org/ubuntu
>> 
>>
>> Colin, do you have a machine on which this can be tested?
> Yes, on Ubuntu 18.10.  Note that I think this is intended for disco
> (19.04) so whether there will be problems with 18.10 or 18.04 remains
> to be seen.  I can't try it till tomorrow though (it is late evening
> here in UK).
>
> Colin
>

-- 
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



pEpkey.asc
Description: application/pgp-keys
___
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] [GNC-dev] Launchpad

2019-01-03 Thread Colin Law
On Thu, 3 Jan 2019 at 21:28, Stephen M. Butler  wrote:
>
> mirrors.kernel.org/ubuntu
> 
>
> Colin, do you have a machine on which this can be tested?

Yes, on Ubuntu 18.10.  Note that I think this is intended for disco
(19.04) so whether there will be problems with 18.10 or 18.04 remains
to be seen.  I can't try it till tomorrow though (it is late evening
here in UK).

Colin
___
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] [GNC-dev] Launchpad

2019-01-03 Thread Stephen M. Butler
I have cleaned up this thread quite a bit.

The summary is, it looks like Dmitry Smirnovis is doing the work!  Just
hard to find.
And, he's not behind (well, maybe a day or two).

On 1/1/19 3:25 PM, Andrew Ruthven wrote:
> Perhaps worth getting in touch with Dmitry Smirnov, the Debian
> Developer who looks after gnucash in Debian?
>
> Looking at:
>   https://packages.ubuntu.com/disco/gnucash
> Ubuntu is just taking the package from Debian.
>
> It does seem reasonable to have a PPA to make newer versions of Gnucash
> available in Ubuntu, and uploading it to the relevant -backports repos
> for Debian.

> I've been happily using Gnucash from Debian for ... many years.
>
> Cheers,
> Andrew
>
So I went there and discovered that


  Package: gnucash (1:3.4-1) [*universe*]

was already waiting to be downloaded.  Scroll down toward the bottom of
the page and find:


Download gnucash

ArchitecturePackage SizeInstalled Size  Files
amd64 
3,288.9 kB  21,952.0 kB [list of files
]
arm64 
3,091.5 kB  21,764.0 kB [list of files
]
armhf 
2,996.7 kB  18,365.0 kB [list of files
]
i386 
3,462.5 kB  21,876.0 kB [list of files
]
ppc64el 
3,365.1 kB  24,893.0 kB [list of files
]
s390x 
3,055.1 kB  22,220.0 kB [list of files
]


I clicked on the amd64 link and it took me to: 
https://packages.ubuntu.com/disco/amd64/gnucash/download


Download Page for gnucash_3.4-1_amd64.deb on AMD64 machines

I went to this mirror and am downloading the deb file now. 
mirrors.kernel.org/ubuntu


Perhaps I've researched myself out of a job!!!  We just have to know
where to look.

Colin, do you have a machine on which this can be tested?

-- 
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



pEpkey.asc
Description: application/pgp-keys
___
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] GNU generated report in HTML to XL

2019-01-03 Thread Adrien Monteleone
I just tested the following using LibreOffice 6.1.0.3 and GnuCash 3.4:

1. ctrl+a (select-all) and ctrl+c (copy) from the report within the GnuCash 
report tab (not a saved file), then ctrl+v (paste) on a blank Calc spreadsheet.

I was given a dialog to choose import coding, select my delimiters, and 
otherwise fine-tune the import (paste) with a preview of my actual data.

The result is the data was imported without formatting into their respective 
cells, except that ’Totals’ somehow had a newline character before the figures 
which would necessitate some additional copy/paste to align them correctly.

2. Save the report to an .html file, open that file with Firefox and then 
repeat the above select/copy/paste commands.

This gave me a less useful dialog box with little control over the end result. 
I was able to only select the import language and asked if I wanted to detect 
’special numbers’ like dates.

I ended up with a formatted version of the report as it appeared in Firefox but 
with each respective title or figure in a proper cell

3. File > Open the .html file from within Calc as suggested by Chris Lam.

Without a dialog box, this resulted in a similar situation to #2, but with no 
grid lines within the report. (like a sheet of paper overlaying the grid)

4. Sheets > Insert Sheet from File (or Insert Sheet and then choose ‘From File’ 
radio button)

I chose to ‘insert’ the .html file. This gave me the same dialog box as #2, but 
the result was the same as #3. I could choose to insert before or after the 
current sheet.


Note, options 1-2 place the data on the current Calc notebook sheet.

Option 3 opens an entirely new workbook with only 1 sheet as your report. 
(unless you’ve set default # of sheets higher)

Option 4 is *adding* a sheet to the notebook, so you can only place it before 
or after the current one.

In every case, the data came through just fine, though I’d probably find 3 or 4 
most useful as everything is already lined up. If you wanted no empty columns 
between your account titles and the values, 1 or 2 would work best, but as 
noted, you’ll have to do some adjusting if you included parent account total 
lines.

Though I used the keyboard shortcuts, Edit > Paste was always available. 
Perhaps there is an issue with the workbook or the sheet itself that is 
disabling it? Try a websearch on ‘Edit > Paste not available, just Paste Only’ 
for LibreOffice.

A cursory search turns up possibilities of a protected sheet, a read-only 
workbook, and a long-standing bug on the Windows platform that doesn’t seem to 
be easily reproducible. However, for those first two possibilities, I would 
think none of the paste functions would be available.

I also see a suggestion that 3rd party clipboard managers sometimes don’t play 
nice with LO.


Regards,
Adrien


> On Jan 3, 2019, at 6:09 AM, Finbar Mahon  wrote:
> 
> Thanks both, but I still seem to be having a problem.
> 
> I have a file -
> 
>  /gnu p
> 
> If I try to cut and paste the data to a new libreoffice calc file I get only 
> 'paste only' as an option under >edit, and nothing else recognisable from 
> >insert.
> 
> I have tried 'insert sheet' under >insert but only get the option to insert 
> before or after and then cannot copy the 'new' sheet into an existing one, if 
> I add 'after'
> 
> There doesn't seem to be a method of cut and paste directly, afaics.
> 
> Thanks, Barry
> 
> On 02/01/2019 17:51, David Carlson wrote:
>> Finbar,
>> 
>> You may need to first open a new blank spreadsheet then cut and paste from 
>> the html document into the spreadsheet rather than trying to directly open 
>> HTML with Calc.
>> 
>> My experience with LibreOffice Calc is that it will import several different 
>> kinds of files.  I use it regularly to convert transaction detail exports 
>> from a certain department store website to a form from which I can manually 
>> extract data to enter into GnuCash, although I have not figured out how to 
>> restructure it to use the CSV importer for that case.
>> 
>> David C
>> 
>> On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon > > wrote:
>> 
>>Hello,
>> 
>>I exported a GNUCash report to HTMl, but I don't seem to be able to
>>import it to LibreOffice Calc, the LibreOffice xl equivalent.
>> 
>>Does anybody know if I must use 'real' MS XL to receive the HTML
>>file?
>>In LibreOffice you can save calc files in MS format. Are there any
>>special tricks for importing?
>> 
>>I am using 3.3 on Windows 10.
>> 
>>Thanks, Barry
>> 
>>___
>>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 

Re: [GNC] Trying to install GNUcash 3.4.1 on IMac

2019-01-03 Thread Adrien Monteleone
Interesting. There has been some issue with phantom dock icons in the past. 
This is the first I’ve seen of an older version’s icon interfering.

I’d say you might want to file a bug, but I suspect it would be a MacOS or GTK 
bug and not specific to GnuCash.

Glad you got it resolved.

Regards,
Adrien

> On Jan 3, 2019, at 6:45 AM, Ronnie H  wrote:
> 
> I believe my problem was the fact that I had GNUcash 3.3.1 setting on my 
> dock. 
> 
> I moved GNUcash 3.4.1 to my desktop, right click to open, then confirmed and 
> the 3.4.1 Icon that came up on the doc as running went away.
> 
> I removed the 3.3.1 Icon I use to start it with from the doc and then 3.4.1 
> came up and ran fine. To be clear, 3.3.1 was not running at the time I tried 
> to run 3.4.1.
> 
> Thanks for your help.
> 
> Ron
> 
> 
>> On Jan 3, 2019, at 3:58 AM, Adrien Monteleone 
>>  wrote:
>> 
>> The screenshot didn’t make it through.
>> 
>> To be sure, did you ‘install’ the application to your /Applications folder 
>> or some other folder *outside* of the .dmg and *onto* your hard drive or are 
>> you trying to simply run the app from inside the .dmg? (you can’t do that by 
>> the way)
>> 
>> Once copied to your /Applications folder, you’ll need to navigate there 
>> using Finder, right-click on the app and choose “Open” and then confirm in 
>> the pop-up dialog that you want to open the app. It should run, but if not, 
>> simply double left-click it and it should run fine from then on.
>> 
>> Regards,
>> Adrien
>> 
>>> On Jan 2, 2019, at 10:57 AM, Ronnie H  wrote:
>>> 
>>> I’m running GNUcash 3.3.+ (2018-09-29) on the following:
>>> 
>>> IMac 2.7 GHz Intel Core i5
>>> 8 GB Ram
>>> MacOS Mojave Version 10.14.2
>>> 
>>> It has started crashing occasionally. Sometimes when I am starting it, and 
>>> sometimes when I am using it.
>>> 
>>> I have down loaded GNUcash 3.4.1 from sourceforge.net 
>>>  3 times but when I click open, it just stops and 
>>> quits running.
>>> 
>>> See attached screen shot
>>> 
>>> ___
>>> 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.
> 
> 


___
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] *.deb package for GnuCash 3.4 Released

2019-01-03 Thread Stephen M. Butler
On 1/2/19 10:44 PM, Liz wrote:
> On Wed, 2 Jan 2019 15:10:01 -0800
> nvsoar  wrote:
>
>> Do you think that 'sudo apt -f install' would work to get the
>> libboost packages?
> This depends on what Stephen has marked as "depends" when he built the
> package.
>
> Liz

And that would depend on what checkinstall did.  I'm doubtful!


-- 
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



pEpkey.asc
Description: application/pgp-keys
___
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

2019-01-03 Thread nvsoar

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.)

nvsoar
___
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

2019-01-03 Thread luca
Though, I did get it to work now by using Compatibility mode and setting it
to Windows 8.



--
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] *.deb package for GnuCash 3.4 Released

2019-01-03 Thread nvsoar

On 01/03/19 00:09, Colin Law wrote:

On Wed, 2 Jan 2019 at 23:12, nvsoar  wrote:

...
Do you think that 'sudo apt -f install' would work to get the libboost
packages?

No, as Liz said that would only help if the deb said that it needs
those packages, in which case dpkg would have complained that they
were not installed.  They probably cannot be included as "depends" as
the deb is aimed principally at 18.04 and the packages may have
different names there.

Colin

Thank you both, nvsoar
___
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] Fw: Installation of Gnu Cash 3.3 Correction to Message.

2019-01-03 Thread David Smith

Hello Geert,

Thank you for your help.

The program has since worked. I have also now upgraded to 3.4 which 
continues to work.


Regards,

David

-Original Message- 
From: Geert Janssens

Sent: Monday, December 3, 2018 9:24 AM
To: gnucash-user@gnucash.org
Cc: David Smith
Subject: Re: [GNC] Fw: Installation of Gnu Cash 3.3

Op maandag 3 december 2018 09:53:46 CET schreef David Smith:

This happens when I try to install GNUCash on to my computer using Windows
10. Please see image of screenshot.

Please can anyone help?

Regards,

David


You can disregard my previous mail. I hadn't seen this one yet.

The error message is very hard to read as the image has been scaled down. 
For

others I'll transliterate it here. It goes more or less like this:
The procedure entry point "inflateValidate" could not be located in the
dynamic link library C:\Program Files (x86)\gnucash\bin\libpng16-16.dll

That message suggests gnucash finds a bad libpng dll.
Did you have gnucash installed before trying to install gnucash 3.3 ?

What you can try to fix this:
1. Uninstall gnucash
2. After the uninstaller has run, remove directory C:\Program Files (x86)
\gnucash should it still exist
3. Reinstall gnucash

Regards,

Geert

___
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] Fw: Installation of Gnu Cash 3.3

2019-01-03 Thread David Smith

Hello Geert,

Thank you for your help.

The program now but I have since updated to 3.4.

Regards,

David

-Original Message- 
From: Geert Janssens

Sent: Monday, December 3, 2018 9:24 AM
To: gnucash-user@gnucash.org
Cc: David Smith
Subject: Re: [GNC] Fw: Installation of Gnu Cash 3.3

Op maandag 3 december 2018 09:53:46 CET schreef David Smith:

This happens when I try to install GNUCash on to my computer using Windows
10. Please see image of screenshot.

Please can anyone help?

Regards,

David


You can disregard my previous mail. I hadn't seen this one yet.

The error message is very hard to read as the image has been scaled down. 
For

others I'll transliterate it here. It goes more or less like this:
The procedure entry point "inflateValidate" could not be located in the
dynamic link library C:\Program Files (x86)\gnucash\bin\libpng16-16.dll

That message suggests gnucash finds a bad libpng dll.
Did you have gnucash installed before trying to install gnucash 3.3 ?

What you can try to fix this:
1. Uninstall gnucash
2. After the uninstaller has run, remove directory C:\Program Files (x86)
\gnucash should it still exist
3. Reinstall gnucash

Regards,

Geert

___
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] GNU generated report in HTML to XL

2019-01-03 Thread David Carlson
I had to paste this message into a different computer that is able send
G-Mail, so I hope I got all the good parts...

I was able to run a quick test using release 2.6.17 in Ubuntu 16.04 and
found that first, when I tried to save a P report in HTML format GnuCash
did not append a .html suffix.  In Linux this did not create a problem, but
Windows did not recognize the file as html.  Appending ".html" to the
filename solved that problem.

Once I had appended ".html" to the filename I could open it in Firefox or
whichever browser and I could get a nice printout directly or select all
[ctrl-A, ctrl-C] and paste [ctrl-V] into a waiting new LibreOffice 6.0.7.3
Calc doc in WIN 7.

Actually, I was unable to find a method that failed.  I cannot test WIN 10
or GnuCash 3.3 directly, so others will need to test those environments.

David C
___
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] GNU generated report in HTML to XL

2019-01-03 Thread David Carlson
I have a message composed on a different computer but it does not wish to
talk to G-Mail.  When I get that fixed I will get it sent.  The problem
seems to be local to that computer as this computer is on the same network.

On Thu, Jan 3, 2019 at 9:04 AM Christopher Lam 
wrote:

> You may open the .html from Libreoffice Calc (not Libreoffice writer).
>
> File > Open, and click on the exported .html file.
>
> On 3/1/19 8:09 pm, Finbar Mahon wrote:
> > Thanks both, but I still seem to be having a problem.
> >
> > I have a file -
> >
> >  /gnu p
> >
> > If I try to cut and paste the data to a new libreoffice calc file I
> > get only 'paste only' as an option under >edit, and nothing else
> > recognisable from >insert.
> >
> > I have tried 'insert sheet' under >insert but only get the option to
> > insert before or after and then cannot copy the 'new' sheet into an
> > existing one, if I add 'after'
> >
> > There doesn't seem to be a method of cut and paste directly, afaics.
> >
> > Thanks, Barry
> >
> > On 02/01/2019 17:51, David Carlson wrote:
> >> Finbar,
> >>
> >> You may need to first open a new blank spreadsheet then cut and paste
> >> from the html document into the spreadsheet rather than trying to
> >> directly open HTML with Calc.
> >>
> >> My experience with LibreOffice Calc is that it will import several
> >> different kinds of files.  I use it regularly to convert transaction
> >> detail exports from a certain department store website to a form from
> >> which I can manually extract data to enter into GnuCash, although I
> >> have not figured out how to restructure it to use the CSV importer
> >> for that case.
> >>
> >> David C
> >>
> >> On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon  >> > wrote:
> >>
> >> Hello,
> >>
> >> I exported a GNUCash report to HTMl, but I don't seem to be able to
> >> import it to LibreOffice Calc, the LibreOffice xl equivalent.
> >>
> >> Does anybody know if I must use 'real' MS XL to receive the HTML
> >> file?
> >> In LibreOffice you can save calc files in MS format. Are there any
> >> special tricks for importing?
> >>
> >> I am using 3.3 on Windows 10.
> >>
> >> Thanks, Barry
> >>
> >> ___
> >> 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.
> ___
> 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] GNUCash fails to start on Windows 10 after windows update

2019-01-03 Thread John Ralls
Have either of you checked in with the Portable Apps folks to see if there’s an 
issue with their environment on the latest Windows10 update?

Regards,
John Ralls


> On Jan 3, 2019, at 6:58 AM, Floris van Nee  wrote:
> 
> This looks like exactly the same issue I am having. Unfortunately I haven't
> been able to find a solution..
> 
> -Floris
> 
> On Tue, Dec 25, 2018, 15:44 luca  
>> The loading screen and the tip of the day show up for a fraction of a
>> second
>> and both disappear again. Nothing in the task list.
>> 
>> Log is empty.
>> 
>> If run with --debug --extra:
>> * 15:38:12  INFO  [main] System locale returned C
>> * 15:38:12  INFO  [main] Effective locale set to C.
>> * 15:38:12  INFO  [gnc_load_app_icons] The icon theme search path
>> has 10 elements.
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 0:
>> C:\Users\LucaBernstein\AppData\Local\icons
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 1:
>> C:\Users\LucaBernstein\.icons
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 2:
>> 
>> C:\Users\LucaBernstein\Documents\Synced\PortableApps\GnuCashPortable_3.2.0\App\Gnucash/share\icons
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 3:
>> /usr/local/share/icons
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 4: /usr/share/icons
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 5:
>> 
>> C:\Users\LucaBernstein\Documents\Synced\PortableApps\GnuCashPortable_3.2.0\App\Gnucash/share\pixmaps
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 6:
>> /usr/local/share/pixmaps
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 7: /usr/share/pixmaps
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 8:
>> 
>> C:\Users\LucaBernstein\Documents\Synced\PortableApps\GnuCashPortable_3.2.0\App\Gnucash\share\gnucash\icons
>> * 15:38:12  INFO  [gnc_load_app_icons] Path 9:
>> 
>> C:\Users\LucaBernstein\Documents\Synced\PortableApps\GnuCashPortable_3.2.0\App\Gnucash\share\icons
>> * 15:38:13  INFO  [gnc_hook_lookup] no hook lists
>> 
>> 
>> 
>> --
>> 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.

___
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] Currencies not being converted

2019-01-03 Thread John Ralls



> On Jan 2, 2019, at 9:43 AM, salmichaels  wrote:
> 
> I have just returned from overseas with laptop and now gnucash does not
> convert currencies. I have some accounts in a foreign currency, others in
> USD. In making reports or having a Total (USD) column, GC doesn't convert
> the accts in foreign currency to USD, but just lists the amounts as if they
> are US dollars. If I change the report currency to the foreign currency, it
> handles it fine; it converts the USD accounts to the foreign currency, no
> issues. 
> 
> The program is set to default to local (US) currency, and was even when I
> was overseas as far as I know. Now it is also set to local US. My local
> settings on my computer are also set for the US. So yeah, I cannot for the
> life of me figure this out. 
> 
> thanks in advance! 

Check the price database for both USD->??? and ???->USD and make sure that the 
most recent price is correct in both directions.

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.


Re: [GNC] GNU generated report in HTML to XL

2019-01-03 Thread Christopher Lam

You may open the .html from Libreoffice Calc (not Libreoffice writer).

File > Open, and click on the exported .html file.

On 3/1/19 8:09 pm, Finbar Mahon wrote:

Thanks both, but I still seem to be having a problem.

I have a file -

 /gnu p

If I try to cut and paste the data to a new libreoffice calc file I 
get only 'paste only' as an option under >edit, and nothing else 
recognisable from >insert.


I have tried 'insert sheet' under >insert but only get the option to 
insert before or after and then cannot copy the 'new' sheet into an 
existing one, if I add 'after'


There doesn't seem to be a method of cut and paste directly, afaics.

Thanks, Barry

On 02/01/2019 17:51, David Carlson wrote:

Finbar,

You may need to first open a new blank spreadsheet then cut and paste 
from the html document into the spreadsheet rather than trying to 
directly open HTML with Calc.


My experience with LibreOffice Calc is that it will import several 
different kinds of files.  I use it regularly to convert transaction 
detail exports from a certain department store website to a form from 
which I can manually extract data to enter into GnuCash, although I 
have not figured out how to restructure it to use the CSV importer 
for that case.


David C

On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon > wrote:


    Hello,

    I exported a GNUCash report to HTMl, but I don't seem to be able to
    import it to LibreOffice Calc, the LibreOffice xl equivalent.

    Does anybody know if I must use 'real' MS XL to receive the HTML
    file?
    In LibreOffice you can save calc files in MS format. Are there any
    special tricks for importing?

    I am using 3.3 on Windows 10.

    Thanks, Barry

    ___
    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.

___
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

2019-01-03 Thread Floris van Nee
This looks like exactly the same issue I am having. Unfortunately I haven't
been able to find a solution..

-Floris

On Tue, Dec 25, 2018, 15:44 luca  The loading screen and the tip of the day show up for a fraction of a
> second
> and both disappear again. Nothing in the task list.
>
> Log is empty.
>
> If run with --debug --extra:
> * 15:38:12  INFO  [main] System locale returned C
> * 15:38:12  INFO  [main] Effective locale set to C.
> * 15:38:12  INFO  [gnc_load_app_icons] The icon theme search path
> has 10 elements.
> * 15:38:12  INFO  [gnc_load_app_icons] Path 0:
> C:\Users\LucaBernstein\AppData\Local\icons
> * 15:38:12  INFO  [gnc_load_app_icons] Path 1:
> C:\Users\LucaBernstein\.icons
> * 15:38:12  INFO  [gnc_load_app_icons] Path 2:
>
> C:\Users\LucaBernstein\Documents\Synced\PortableApps\GnuCashPortable_3.2.0\App\Gnucash/share\icons
> * 15:38:12  INFO  [gnc_load_app_icons] Path 3:
> /usr/local/share/icons
> * 15:38:12  INFO  [gnc_load_app_icons] Path 4: /usr/share/icons
> * 15:38:12  INFO  [gnc_load_app_icons] Path 5:
>
> C:\Users\LucaBernstein\Documents\Synced\PortableApps\GnuCashPortable_3.2.0\App\Gnucash/share\pixmaps
> * 15:38:12  INFO  [gnc_load_app_icons] Path 6:
> /usr/local/share/pixmaps
> * 15:38:12  INFO  [gnc_load_app_icons] Path 7: /usr/share/pixmaps
> * 15:38:12  INFO  [gnc_load_app_icons] Path 8:
>
> C:\Users\LucaBernstein\Documents\Synced\PortableApps\GnuCashPortable_3.2.0\App\Gnucash\share\gnucash\icons
> * 15:38:12  INFO  [gnc_load_app_icons] Path 9:
>
> C:\Users\LucaBernstein\Documents\Synced\PortableApps\GnuCashPortable_3.2.0\App\Gnucash\share\icons
> * 15:38:13  INFO  [gnc_hook_lookup] no hook lists
>
>
>
> --
> 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] Trying to install GNUcash 3.4.1 on IMac

2019-01-03 Thread Ronnie H
I believe my problem was the fact that I had GNUcash 3.3.1 setting on my dock. 

I moved GNUcash 3.4.1 to my desktop, right click to open, then confirmed and 
the 3.4.1 Icon that came up on the doc as running went away.

I removed the 3.3.1 Icon I use to start it with from the doc and then 3.4.1 
came up and ran fine. To be clear, 3.3.1 was not running at the time I tried to 
run 3.4.1.

Thanks for your help.

Ron


> On Jan 3, 2019, at 3:58 AM, Adrien Monteleone 
>  wrote:
> 
> The screenshot didn’t make it through.
> 
> To be sure, did you ‘install’ the application to your /Applications folder or 
> some other folder *outside* of the .dmg and *onto* your hard drive or are you 
> trying to simply run the app from inside the .dmg? (you can’t do that by the 
> way)
> 
> Once copied to your /Applications folder, you’ll need to navigate there using 
> Finder, right-click on the app and choose “Open” and then confirm in the 
> pop-up dialog that you want to open the app. It should run, but if not, 
> simply double left-click it and it should run fine from then on.
> 
> Regards,
> Adrien
> 
>> On Jan 2, 2019, at 10:57 AM, Ronnie H  wrote:
>> 
>> I’m running GNUcash 3.3.+ (2018-09-29) on the following:
>> 
>> IMac 2.7 GHz Intel Core i5
>> 8 GB Ram
>> MacOS Mojave Version 10.14.2
>> 
>> It has started crashing occasionally. Sometimes when I am starting it, and 
>> sometimes when I am using it.
>> 
>> I have down loaded GNUcash 3.4.1 from sourceforge.net 
>>  3 times but when I click open, it just stops and 
>> quits running.
>> 
>> See attached screen shot
>> 
>> ___
>> 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.

___
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] GNU generated report in HTML to XL

2019-01-03 Thread Finbar Mahon

Thanks both, but I still seem to be having a problem.

I have a file -

 /gnu p

If I try to cut and paste the data to a new libreoffice calc file I get 
only 'paste only' as an option under >edit, and nothing else 
recognisable from >insert.


I have tried 'insert sheet' under >insert but only get the option to 
insert before or after and then cannot copy the 'new' sheet into an 
existing one, if I add 'after'


There doesn't seem to be a method of cut and paste directly, afaics.

Thanks, Barry

On 02/01/2019 17:51, David Carlson wrote:

Finbar,

You may need to first open a new blank spreadsheet then cut and paste 
from the html document into the spreadsheet rather than trying to 
directly open HTML with Calc.


My experience with LibreOffice Calc is that it will import several 
different kinds of files.  I use it regularly to convert transaction 
detail exports from a certain department store website to a form from 
which I can manually extract data to enter into GnuCash, although I 
have not figured out how to restructure it to use the CSV importer for 
that case.


David C

On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon > wrote:


Hello,

I exported a GNUCash report to HTMl, but I don't seem to be able to
import it to LibreOffice Calc, the LibreOffice xl equivalent.

Does anybody know if I must use 'real' MS XL to receive the HTML
file?
In LibreOffice you can save calc files in MS format. Are there any
special tricks for importing?

I am using 3.3 on Windows 10.

Thanks, Barry

___
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] GnuCash won't open

2019-01-03 Thread Adrien Monteleone
Ruth,

The first time you run GnuCash, you may need to right-click and choose “Open”, 
then confirm in the pop-up dialog that you want to open the app. After that, 
left double-clicking should work fine, or you can launch it from your dock like 
any other app. You’ll have to repeat this right-click process each time you 
install a new version.

The wiki should probably updated to reflect this. I’m headed to bed now, but 
can get to it later if no one else has beat me to it.

Regards,
Adrien

> On Jan 3, 2019, at 3:16 AM, Colin Law  wrote:
> 
> On Thu, 3 Jan 2019 at 07:10, Ruth L. Mazur  wrote:
>> 
>> I have downloaded GnuCash 3.4-Intel to my Mac OS10.11.6  a dozen times but I 
>> can not get it to open. For Privacy I’m set to sites that I visit.  Once I 
>> set it to Anyone and that didn’t work either.
> 
> Did you carefully follow the installation instructions for Mac?
> https://wiki.gnucash.org/wiki/Installation
> 
> Colin
> 
>> 
>> This has been very frustrating.  I’m disillusioned with Quicken and want 
>> something else, and free is good! What do I need to know to get this app?
>> 
>> Thanks for any help,
>> 
>> Ruth Mazur
>> Grass Valley, CA
>> 
>> 
>> 
>> ___
>> 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.


___
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] Trying to install GNUcash 3.4.1 on IMac

2019-01-03 Thread Adrien Monteleone
The screenshot didn’t make it through.

To be sure, did you ‘install’ the application to your /Applications folder or 
some other folder *outside* of the .dmg and *onto* your hard drive or are you 
trying to simply run the app from inside the .dmg? (you can’t do that by the 
way)

Once copied to your /Applications folder, you’ll need to navigate there using 
Finder, right-click on the app and choose “Open” and then confirm in the pop-up 
dialog that you want to open the app. It should run, but if not, simply double 
left-click it and it should run fine from then on.

Regards,
Adrien

> On Jan 2, 2019, at 10:57 AM, Ronnie H  wrote:
> 
> I’m running GNUcash 3.3.+ (2018-09-29) on the following:
> 
> IMac 2.7 GHz Intel Core i5
> 8 GB Ram
> MacOS Mojave Version 10.14.2
> 
> It has started crashing occasionally. Sometimes when I am starting it, and 
> sometimes when I am using it.
> 
> I have down loaded GNUcash 3.4.1 from sourceforge.net 
>  3 times but when I click open, it just stops and 
> quits running.
> 
> See attached screen shot
> 
> ___
> 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] Tutorial for moving stock between accounts?

2019-01-03 Thread Fred Bone
On Wednesday, January 2, 2019 at 5:58, Jon Leech said:

> On Wed, Jan 02, 2019 at 05:38:13PM +0530, D wrote:
> > Jon,
> >
> > I can't test this right now, since I'm not at my machine...
> >
> > Try this:
> >
> > Open your source account.
> >
> > Move to the entry point in the register.
> >
> > Click the 'Split' button. Enter your description.
> >
> > Tab to the Shares field in the first split and type -13.
> >
> > Tab to the price field and type 0.
> >
> > Now, use **tab** to move to the Transfer field on the second line, set
> > it to your destination account and tab to shares and type 13.
> >
> > Does that work?
> 
> Thanks! This works, for the most part. The share counts in source and
> destination accounts are altered correctly, which is enough to let me do
> what I need. It does set a Price of 1 for the second line and a Tot Buy of
> 13.00, and then creates a new Imbalance line in the split with a Tot Sell
> of 13.00.
> 
> I cannot change the Price to 0 on the second line, unlike the first.
> Trying it results in it immediately being restored to 1, so the Imbalance
> seems unavoidable. I can set the Price to a non-zero number and make
> gnucash recalculate the Tot Buy / Imbalance fields, but that seems
> pointless, since there is no actual Price or cash associated with this
> transaction.

Oh yes there is.

If you started with 100 shares and transferred 50 from A to B, the 
account wiith A is now worth half what it was and the account with B is 
worth the other half. If you don't tell Gnucash what the transfer value 
is, you can't expect it to make the relevant calculations when the time 
comes (e.g. you sell one and want to know your capital gain).

___
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 won't open

2019-01-03 Thread Colin Law
On Thu, 3 Jan 2019 at 07:10, Ruth L. Mazur  wrote:
>
> I have downloaded GnuCash 3.4-Intel to my Mac OS10.11.6  a dozen times but I 
> can not get it to open. For Privacy I’m set to sites that I visit.  Once I 
> set it to Anyone and that didn’t work either.

Did you carefully follow the installation instructions for Mac?
https://wiki.gnucash.org/wiki/Installation

Colin

>
> This has been very frustrating.  I’m disillusioned with Quicken and want 
> something else, and free is good! What do I need to know to get this app?
>
> Thanks for any help,
>
> Ruth Mazur
> Grass Valley, CA
>
>
>
> ___
> 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] *.deb package for GnuCash 3.4 Released

2019-01-03 Thread Colin Law
On Wed, 2 Jan 2019 at 23:12, nvsoar  wrote:
> ...
> Do you think that 'sudo apt -f install' would work to get the libboost
> packages?

No, as Liz said that would only help if the deb said that it needs
those packages, in which case dpkg would have complained that they
were not installed.  They probably cannot be included as "depends" as
the deb is aimed principally at 18.04 and the packages may have
different names there.

Colin
___
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.