[GNC] Debian package

[Stephen M. Butler]

Please try these before I take the next step of figuring out how to
populate a ppa up on Launchpad.

GnuCash-3.4  
https://drive.google.com/open?id=1fV_fURy6c77e7gf6S41lTacM7dFyy7VD


GnuCash-3.4-39 (current maint)   
https://drive.google.com/open?id=1SO2xkPICKEpSQCvJLW6CnBVrzgvTEyHQ


Thanks to all who stepped forward with suggestions.

And to preempt others -- Yes, I do have a kite.  And I use a dry suite
when jumping into lakes!  <>

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

___
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] Crash on startup MacOS Mojave. GnuCash version 3.3

[peter_cd.cn]

Environment:
GnuCash Version: 3.3,
Build ID: 3.3+(2018-09-29)
Using XML saving data.
File structure under my local saved data:
 
MacOS version: 10.14.2

Repo steps:
* New Gnucash user.  Heavily using it today, imported four QFX files today,
and used generic importer to choose transfer account.
* Edited a few account after import.
* Crashed while editing a transfer account in the register view
* reopen Gnucash and got warning says the LOC file exist, and chose "open
anyway".
* More editing and made sure I was able to save and quit.
* Click on online banking setup and was going to use aqofxdirect wizard.

Notice Gnucash crash.  Now it is just crash on startup.  No error message in
Console under user report.
Terminal error: 
/Applications/Gnucash/Gnucash.app/Contents/MacOS/Gnucash
Application Path /Applications/Gnucash/Gnucash.app/Contents/MacOS/Gnucash

(process:6855): gnc.gui-WARNING **: 18:56:48.605: [mac_set_languages()]
Language list: en:en_US:C:zh_CN:zh_TW
Found Finance::Quote version 1.47
[1]6855 segmentation fault 
/Applications/Gnucash/Gnucash.app/Contents/MacOS/Gnucash


More background.  When I first tried Gnucash in December last year I was
using previous major OS release - High Sierra.  It was doing crash on
startup.  I updated to Mojove and installed a newer version Gnucash.  Crash
stopped.

I only used a this software for a day and got myself familiar with it, it
crashes again.  I really hope this would work, I am trying to build a
solution for our family needs with open source solution instead of using
Quicken product.

How can I pass this crash on login?  Will I lose any of my data?  I spend a
lot time working on the input of the data.

Thanks,
-Peter





--
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] Importing QIF results into duplicate entry

[David Cousens]

Hi Chitresh,

Had a quick look at the QIF format in your attached file. It seems to be OK.
The QIF format is not all that well defined. Compare the w3c
definition(https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm) and that
in Wikipedia (https://en.wikipedia.org/wiki/Quicken_Interchange_Format) for
example. There are several difference which could cause problems with an
import parser. The QIF files I have imported (mainly from paypal) looked
more like the Wikipedia format description than the w3c.

Have you matched your account structure in GnuCash as closely as you can to
the Quicken categories? If accounts matching the categories don't exist, the
new account button in the account matching dialog will allow you to create
appropriate accounts on the fly. You can rearrange and rename accounts after
importing data but having a roughly matching heirarchy will make it easier.

Importing one account at a time (preferrably in small blocks until you have
the process working well) as David T suggested is a good process. 

Understanding the matcher operation and the meaning of the A, U and R flags
is also important. Sometimes the matcher will match to a transaction that is
not the same transaction and will reject import. This can happen with
frequent recurring transactions and you have to manually uncheck the R flag
in that case.

There are a number of threads in the archives like the following
https://lists.gnucash.org/pipermail/gnucash-user/2010-April/034615.html
where the operation of the matcher is discussed. Searching the archives with
Google for "site:lists.gnucash.org import match" will bring up appropriate
threads.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Date Completion - sliding 12 month window

[John Ralls]

> On Jan 20, 2019, at 1:48 PM, Colin Law  wrote:
> 
> On Sun, 20 Jan 2019 at 19:20, Parke  wrote:
>> ...
>> Come 2020, I may try switching to Lubuntu 20.04.
> 
> I don't think that will help, I think it will still need dconf, though
> I may be wrong.

Maybe. It seems that KDE uses a plain config-file backend for GSettings and 
Lubuntu may as well.

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] dpkg-builder

[Andrew Clark]

I don't have an Ubuntu machine to test on, and this probably isn't the
cleanest way to build a package (it's been a while for me) but under buster
to build the package from source and make a deb:

sudo apt install fakeroot quilt
sudo apt build-deps gnucash
apt source gnucash
cd gnucash-3.4
export QUILT_PATCHES=debian/patches
export QUILT_REFRESH_ARGS="-p ab --no-timestamps --no-index"
quilt push -a
vi debian/rules and add fakeroot to the start of line 31
./debian/rules binary

That basic build process should be fairly similar under Ubuntu to get the
existing package. Once you can built the package as distributed by the
Ubuntu folks you can then pull down whatever source you want to and use a
similar process to build a package The version numbers used to build the
packages are stored in files named debian/[package]/DEBIAN/control


On Mon, 21 Jan 2019 at 05:33, Stephen M. Butler  wrote:

> On 1/20/19 2:36 AM, Andrew Clark wrote:
> > There's a GnuCash 3.4 Debian package in buster/testing
> > already? https://tracker.debian.org/pkg/gnucash
> >
> >
> >
> > On Sat, 19 Jan 2019 at 07:36, Stephen M. Butler  > > wrote:
> >
> > Anybody a wizard with dpkg-builder?  Still trying to get a debian
> > package ready for folks.  I'm in over my head.
> >
> > Private mail me -- so we don't use up the bandwidth on either of
> these
> > mailing lists.--
> >
> >
> > Cheers,
> >
> > Andrew.
>
> That has the following problems:
>
> 1.  It is for Buster.  At least one person on these mailing lists has
> tried to load it up under Ubuntu 18.10 and ran into a slew of dependency
> problems.
>
> 2.  It is in the mainstream and won't make it to the releasable public
> for months.
>
> 3.  There is no "daily" for those who want to live on the bleeding edge.
>
> I have no interest in feeding into the mainline of major distributions.
> In fact, I can compile the source for my own utilization on my Ubuntu
> 18.04 box.  However, there are some who would like to have the more
> recent releases available on their distro without having to compile the
> source.
>
> If possible, I would like to build a debian style package that is
> available for the older distros.  I see interest for two such packages
> that could be made available via a ppa.
>
> 1.  The latest general release such as 3.4. Available for any distro
> rather than just Buster.
>
> 2.  A "daily" or "weekly" build of the latest set of patches to that
> release.  This morning (USA-Pacific Coast), there have been 38 commits
> since 3.4.  Others, in addition to myself, may have interest in having
> those available.
>
> Your welcome!
>
> --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
>
>
>

-- 
Cheers,

Andrew.
___
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] Date Completion - sliding 12 month window

[Colin Law]

On Sun, 20 Jan 2019 at 19:20, Parke  wrote:
> ...
> Come 2020, I may try switching to Lubuntu 20.04.

I don't think that will help, I think it will still need dconf, though
I may be wrong.


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] dpkg-builder

[Colin Law]

On Sun, 20 Jan 2019 at 19:03, Mechtilde  wrote:
>
> Hello
>
> unter debian Buster you can use GnuCash version 3.4 from the Debian repo.

Yes, but not in Ubuntu 18.10.

Colin

>
> Kind regards
>
>
> --
> Mechtilde Stehmann
> ## Apache OpenOffice
> ## Freie Office Suite für Linux, MacOSX, Windows
> ## Debian Developer
> ## PGP encryption welcome
> ## F0E3 7F3D C87A 4998 2899  39E7 F287 7BBA 141A AD7F
>
> ___
> 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] Windows/Ubuntu Transportable Data File?

[Larry Long]

Thank you, Stephen, Adrien and David, for your thoughtful and helpful responses!
Larry Long

On Friday, January 18, 2019, 3:34:09 PM EST, Larry Long  
wrote:  
 I have two general questions. 
   
   - How well supported is GnuCash on the Ubuntu OS?
   - How transportable would the GnuCash DB be between a computer running 
Ubuntu and another one that is running Windows 10?
...[snip]...

Larry


___
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] Date Completion - sliding 12 month window

[Parke]

Hello,

Thank you David and Greet for your answers.

On Sat, Jan 19, 2019 at 1:55 AM Geert Janssens
 wrote:
> Are you able to change any of the other preferences ? If not, there may be a
> problem with the settings backend (which on linux systems is dconf).

I am not able to change any of the preferences.

It seems very likely that I have intentionally disabled dconf on my system.

Ubuntu keeps on adding more and more... (how shall I say it...)
layers... and I have taken steps to disable as many of them as
possible.

> Does the trace file [1]  show warnings if you try to change this date option ?

Yes, simply opening the preferences window causes multiple lines (all
the same) to appear in the trace file:

* 11:06:21  WARN  failed to commit changes to dconf: Could not
connect: Connection refused

Also, when I create a new set of books, the following is printed to
stdout/stderr:

Found Finance::Quote version 1.47
Error creating proxy: Could not connect: Connection refused
(g-io-error-quark, 39)

Come 2020, I may try switching to Lubuntu 20.04.

Many thanks,

Parke
___
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] Reconciliation is not adding up correctly - what to do??

[Stephen M. Butler]

On 1/20/19 10:39 AM, Mike Stillingfleet wrote:
> I absolutely cannot account for this. But I repeated my tests after
> your post. I set up another new dummy cc account and tested a
> reconciliation. It worked!!!
>
> I then went back to my cc account. It still didn't work. 
>
> I then set up another cc account and transferred a months worth of
> data from old to new and reconciled it. It worked!
>
> I have now transferred a years worth a month at a time the new cc
> account reconciles. 
>
> Just to prove i wasn't mad I then went back to the original account
> and tried a dummy reconciliation.  It failed. So I have no clue as the
> why that account is messed up. But it is.
>
> I have now moved 2 years worth of data over to the new account. It has
> taken about 10 hours but I am now back on track.
>
> On Sat, Jan 19, 2019, at 5:48 PM, stephen.m.butler51 wrote:
>> My CC is set up as a straight liability account.  Reconciliation
>> works fine with it.
<>
> -- 
>   Mike Stillingfleet
>   mikestillingfl...@fastmail.co.uk
>
>
Good to know that it's that account and not something for the credit
card type.

Thanks for letting folks know.

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

___
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] Reconciliation is not adding up correctly - what to do??

[Mike Stillingfleet]

I absolutely cannot account for this. But I repeated my tests after your post. 
I set up another new dummy cc account and tested a reconciliation. It worked!!!

I then went back to my cc account. It still didn't work. 

I then set up another cc account and transferred a months worth of data from 
old to new and reconciled it. It worked!

I have now transferred a years worth a month at a time the new cc account 
reconciles. 

Just to prove i wasn't mad I then went back to the original account and tried a 
dummy reconciliation. It failed. So I have no clue as the why that account is 
messed up. But it is.

I have now moved 2 years worth of data over to the new account. It has taken 
about 10 hours but I am now back on track.

On Sat, Jan 19, 2019, at 5:48 PM, stephen.m.butler51 wrote:
> My CC is set up as a straight liability account. Reconciliation works fine 
> with it.
> 
> 
> 
> Sent from my Verizon, Samsung Galaxy smartphone
> 
>  Original message 
> From: john_mike 
> Date: 1/19/19 09:38 (GMT-08:00)
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Reconciliation is not adding up correctly - what to do??
> 
> I have done several tests today.
> 
> I have set number various fake accounts with type credit card. 
> 
> I all cases the reconciliation does not work. In every case the opening
> balance, ending balance, in's and outs have been correctly entered and very
> carefully checked. But in each case it was necessary to create a balancing
> entry to close out the reconciliation.
> 
> I have read up on the GNUcash help regarding reconciliation of a credit card
> account. I have followed this to the letter and it make no difference.
> 
> I conclude that reconciling a credit card type account is not possible.
> 
> I have therefore looked and moving all the transaction to a normal asset
> account where I know the reconciliation does work.
> 
> I did some tests using the delete and move transaction to a new account -
> unfortunately this does not work as you are only allowed to move a credit
> card type to another credit card type.
> 
> I am therefore starting the process of cut and paste to move from a credit
> card type to and asset type account. It is several 1000 entries so it is
> going to take a little while.
> 
> It would be nice if someone could explain why reconciling a credit card type
> of account cannot be reconciled. 
> 
> I hope this post stops someone else falling into this trap.
> 
> 
> 
> 
> 
> --
> 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.

-- 
 Mike Stillingfleet
 mikestillingfl...@fastmail.co.uk

___
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] dpkg-builder

[Stephen M. Butler]

On 1/20/19 2:36 AM, Andrew Clark wrote:
> There's a GnuCash 3.4 Debian package in buster/testing
> already? https://tracker.debian.org/pkg/gnucash
>
>
>
> On Sat, 19 Jan 2019 at 07:36, Stephen M. Butler  > wrote:
>
> Anybody a wizard with dpkg-builder?  Still trying to get a debian
> package ready for folks.  I'm in over my head.
>
> Private mail me -- so we don't use up the bandwidth on either of these
> mailing lists.--
>
>
> Cheers,
>
> Andrew.

That has the following problems:

1.  It is for Buster.  At least one person on these mailing lists has
tried to load it up under Ubuntu 18.10 and ran into a slew of dependency
problems.

2.  It is in the mainstream and won't make it to the releasable public
for months.

3.  There is no "daily" for those who want to live on the bleeding edge.

I have no interest in feeding into the mainline of major distributions. 
In fact, I can compile the source for my own utilization on my Ubuntu
18.04 box.  However, there are some who would like to have the more
recent releases available on their distro without having to compile the
source.

If possible, I would like to build a debian style package that is
available for the older distros.  I see interest for two such packages
that could be made available via a ppa. 

1.  The latest general release such as 3.4. Available for any distro
rather than just Buster.

2.  A "daily" or "weekly" build of the latest set of patches to that
release.  This morning (USA-Pacific Coast), there have been 38 commits
since 3.4.  Others, in addition to myself, may have interest in having
those available.

Your welcome!

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


___
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] Cant get online quotes to work

[John Ralls]

> On Jan 20, 2019, at 2:05 AM, Kevin Thorne  wrote:
> 
> 
> OS: Win 10
> GnuCash 3.4 
> F:Q 1.47
> Perl 5 v26.1
> 
> Have set the Alphavantage key in GnuCash under preferences
> 
> Trying to get stock updates from Australia and USA
> 
> ANZ.AX - ASX
> BRK-B  - NYSE
> 
> Seems all is working from CMD and alphavantage outside GnuCash.
> 
> I have tried to follow all suggestions but cant get this working, is anyone 
> able to assist?
> 
> 

Are those the only quotes that you have configured for retrieval? If not, it’s 
most likely Alphavantage's throttling that has been discussed ad nauseam here 
for the last 9 months.

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] Importing QIF results into duplicate entry

[David T. via gnucash-user]

Hi,

Welcome to GnuCash. 

Getting your data into GnuCash always seems to be a challenge; many threads on 
the lists over the years attest to it. 

Given your particular problem—that is, your exported data is producing overlaps 
in the results—you might be advised to revisit the export piece and separate 
the accounts into different QIF files. Beginning with the account with the most 
transactions, perform an import into GnuCash. Then, **in separate passes**, 
import the other files, and be sure to use the assignment window to link your 
incoming transactions to those that already exist in the file. In this way, you 
can tell GnuCash to connect the transactions together in the final file.

Cheers,
David T.

> On Jan 20, 2019, at 10:16 PM, Chitresh Bhushan  wrote:
> 
> Hi all,
> 
> I am trying to switch to gnucash. I have exported all my data in QIF format
> from the old software I was using, moneyguru (
> https://github.com/hsoft/moneyguru). However, when I import the exported
> QIF file in gnucash, I see a lot of duplicate entries in gnucash, resulting
> to incorrect balances. Moneyguru also uses double-entry accounting, so I
> was hoping this transition would be easy.
> 
> To reproduce the behavior, I have linked below a sample (tiny) QIF file
> exported from moneyguru. Can someone take a look and check if the file
> format is correct? Or am I doing something wrong during the import? I am
> new to gnucash and using gnucash 2.6.19 on Ubuntu.
> 
> The sample file generates duplicates in checking and credit-card accounts
> (for $980 entry) on importing. My actual data has more than 8 yrs of
> entries.. so its quite big with a lot of duplicates.
> 
> Sample QIF file exported from moneyguru:
> https://peep.updog.co/shared/tiny_export.qif (381 bytes)
> 
> Any help is highly appreciated!
> 
> Thanks,
> CB
> ___
> 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.

[GNC] Importing QIF results into duplicate entry

[Chitresh Bhushan]

Hi all,

I am trying to switch to gnucash. I have exported all my data in QIF format
from the old software I was using, moneyguru (
https://github.com/hsoft/moneyguru). However, when I import the exported
QIF file in gnucash, I see a lot of duplicate entries in gnucash, resulting
to incorrect balances. Moneyguru also uses double-entry accounting, so I
was hoping this transition would be easy.

To reproduce the behavior, I have linked below a sample (tiny) QIF file
exported from moneyguru. Can someone take a look and check if the file
format is correct? Or am I doing something wrong during the import? I am
new to gnucash and using gnucash 2.6.19 on Ubuntu.

The sample file generates duplicates in checking and credit-card accounts
(for $980 entry) on importing. My actual data has more than 8 yrs of
entries.. so its quite big with a lot of duplicates.

Sample QIF file exported from moneyguru:
https://peep.updog.co/shared/tiny_export.qif (381 bytes)

Any help is highly appreciated!

Thanks,
CB
___
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] Budget Total Anomalies

[Peter Jackson]

 I use Gnucash 3.4 on Windows 10.

I have just noticed that the budget total figures are no longer correct.
Thus for example, in ExpensesBudget , the displayed  Monthly total for each
month does not equal the sum of the individual account budgets.

This imbalance then reflects across all budget reports.

I am pretty certain that this is a new issue, as I tend to balance
regularly with a spreadsheet.

Any suggestions

Thanks

Peter
___
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] profit & Loss

[alan camina]

Sent a question eraleir but I have now understood the issue:)

Sorry for any unnecessary work

Alan

___
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] PDF filenames for reports

[Geert Janssens]

Op zondag 20 januari 2019 12:32:34 CET schreef Matthijs Kooijman:
> Hi folks,
> 
> I'm replying to this old thread, adding a bit more info for anyone
> searching for this on Google (hopefully the mailing list archive will
> add this post to the existing thread...).
> 
> > Ok, in dconf you will want to look for
> > /org/gnucash/general/report/pdf-export/(filename-format and filename-
> > date-format)
> 
> I've found these dconf values and changing them works (gnucash 2.6.15).
> 
> However, I wanted to use just the invoice number as the filename, so I
> changed the value from the default "%1$s-%2$s-%3$s" to "%2$s". Clicking
> PDF export on an invoice then crashed Gnucash, with an assertion
> failure: *** invalid %N$ use detected ***
> 
> This is because printf does not support skipping arguments (when there
> is no format string for an argument, printf has no idea how big it is on
> the stack, so it cannot tell where the next argument begins).
> 
> In this case, I found a simple workaround in the "precision" specifier
> of printf format strings. For string arguments, the precision is used as
> the maximum string width, truncating any longer strings. So you can add
> a zero-width specifier for any arguments that you want to skip. E.g. it
> works with "%1$.0s%2$s" (note that argument 3 can be left out, since it
> is at the end).
> 
> Just in case anyone else runs into this :-)
> 
> Gr.
> 
> Matthijs

Cool tip :)

Thanks!

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] PDF filenames for reports

[Matthijs Kooijman]

Hi folks,

I'm replying to this old thread, adding a bit more info for anyone
searching for this on Google (hopefully the mailing list archive will
add this post to the existing thread...).

> Ok, in dconf you will want to look for
> /org/gnucash/general/report/pdf-export/(filename-format and filename-
> date-format)

I've found these dconf values and changing them works (gnucash 2.6.15).

However, I wanted to use just the invoice number as the filename, so I
changed the value from the default "%1$s-%2$s-%3$s" to "%2$s". Clicking
PDF export on an invoice then crashed Gnucash, with an assertion
failure: *** invalid %N$ use detected ***

This is because printf does not support skipping arguments (when there
is no format string for an argument, printf has no idea how big it is on
the stack, so it cannot tell where the next argument begins).

In this case, I found a simple workaround in the "precision" specifier
of printf format strings. For string arguments, the precision is used as
the maximum string width, truncating any longer strings. So you can add
a zero-width specifier for any arguments that you want to skip. E.g. it
works with "%1$.0s%2$s" (note that argument 3 can be left out, since it
is at the end).

Just in case anyone else runs into this :-)

Gr.

Matthijs


signature.asc
Description: PGP signature
___
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] Cant get online quotes to work

[Chris Good]

>
>
> Message: 1
> Date: Sun, 20 Jan 2019 18:05:32 +0800
> From: Kevin Thorne 
> To: "gnucash-user@gnucash.org" 
> Subject: Re: [GNC] Cant get online quotes to work
> Message-ID: <5c4447ef.1c69fb81.7de3f.a...@mx.google.com>
> Content-Type: text/plain; charset="utf-8"
>
>
> OS: Win 10
> GnuCash 3.4
> F:Q 1.47
> Perl 5 v26.1
>
> Have set the Alphavantage key in GnuCash under preferences
>
> Trying to get stock updates from Australia and USA
>
> ANZ.AX - ASX
> BRK-B? - NYSE
>
> Seems all is working from CMD and alphavantage outside GnuCash.
>
> I have tried to follow all suggestions but cant get this working, is
> anyone able to assist?
>
> Thanks you
>
> Kevin
>
> Sent from Mail for Windows 10
>
>
> -- next part --
> A non-text attachment was scrubbed...
> Name: FQ2.PNG
> Type: image/png
> Size: 20835 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190120/bb0ad161/attachment.png
> >
> -- next part --
> A non-text attachment was scrubbed...
> Name: FQ3.PNG
> Type: image/png
> Size: 20420 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190120/bb0ad161/attachment-0001.png
> >
> -- next part --
> A non-text attachment was scrubbed...
> Name: FQ1.PNG
> Type: image/png
> Size: 5522 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190120/bb0ad161/attachment-0002.png
> >
> -- next part --
> A non-text attachment was scrubbed...
> Name: fq4.GIF
> Type: image/gif
> Size: 16596 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190120/bb0ad161/attachment.gif
> >
>
> Hi Kevin,


GnuCash always uses AlphaVantage as source for all currency exchange rates.
You'll notice there is nowhere to specify source for exchange rates. Do all
your exchange rates work using  using alphavantage from the commandline?

Do all your stocks work from the commandline using the source that is
specified?

It is a good idea to use the down arrow in the top right hand corner of the
security editor to show extra fields like the source to ensure you have the
correct source and symbol for all stocks.

Regards, Chris Good
___
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] Transfer Saved Report Configuration to Another Computer

[Patrick]

Thank you, John and Geert, for this helpful information.

Regards,
Patrick

On Sun, Jan 20, 2019 at 4:55 AM Geert Janssens 
wrote:

> Op zaterdag 19 januari 2019 23:50:10 CET schreef John Ralls:
> > > On Jan 19, 2019, at 11:02 AM, Patrick  wrote:
> > >
> > > Hello,
> > >
> > > I noticed that if I save my GnuCash folder containing my .gnucash files
> > > and
> > > move it to another machine, my saved report configurations don't get
> > > transferred. Where are the report configurations saved, so that I can
> > > transfer them also?
> >
> > https://wiki.gnucash.org/wiki/Configuration_Locations
> >
> > Regards,
> > John Ralls
> >
>
> And this page may be helpful as well:
> https://wiki.gnucash.org/wiki/Backup
>
> 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] Transfer Saved Report Configuration to Another Computer

[Geert Janssens]

Op zaterdag 19 januari 2019 23:50:10 CET schreef John Ralls:
> > On Jan 19, 2019, at 11:02 AM, Patrick  wrote:
> > 
> > Hello,
> > 
> > I noticed that if I save my GnuCash folder containing my .gnucash files
> > and
> > move it to another machine, my saved report configurations don't get
> > transferred. Where are the report configurations saved, so that I can
> > transfer them also?
> 
> https://wiki.gnucash.org/wiki/Configuration_Locations
> 
> Regards,
> John Ralls
> 

And this page may be helpful as well:
https://wiki.gnucash.org/wiki/Backup

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] dpkg-builder

[Andrew Clark]

There's a GnuCash 3.4 Debian package in buster/testing already?
https://tracker.debian.org/pkg/gnucash



On Sat, 19 Jan 2019 at 07:36, Stephen M. Butler  wrote:

> Anybody a wizard with dpkg-builder?  Still trying to get a debian
> package ready for folks.  I'm in over my head.
>
> Private mail me -- so we don't use up the bandwidth on either of these
> mailing lists.
>
> --
> 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.



-- 
Cheers,

Andrew.
___
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] Cant get online quotes to work

[Kevin Thorne]

OS: Win 10
GnuCash 3.4 
F:Q 1.47
Perl 5 v26.1

Have set the Alphavantage key in GnuCash under preferences

Trying to get stock updates from Australia and USA

ANZ.AX - ASX
BRK-B  - NYSE

Seems all is working from CMD and alphavantage outside GnuCash.

I have tried to follow all suggestions but cant get this working, is anyone 
able to assist?




Thanks you 

Kevin

Sent from Mail for Windows 10


___
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] Budget Totalling Anomalies

[Peter Jackson]

I use Gnucash 3.4 on Windows 10.

I have just noticed that the budget total figures are no longer correct.
That is for example in ExpensesBudget , the displayed  Monthly total for
each month does not equal the sum of the individual account budgets.

This imbalance then reflects across all budget reports.

I am pretty certain that this is a new issue, as I tend to balance
regularly with a spreadsheet.

Any suggestions

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