Re: [GNC] crashing trying to do a simple split

2019-08-01 Thread David Carlson
Sorry, David, it is difficult to see who wrote what in the Gmail app.

Mark should look at his trace files to see if they have any useful
information.

David Carlson

On Fri, Aug 2, 2019, 12:19 AM David Cousens 
wrote:

> Hi David,
>
> That wasn't Mark. I was trying to duplicate what he had done first on my
> Linux Box and then on a Windows10 box. I didn't close the first before
> opening the second and didn't reopen the register after changing the
> register preferences in the first case.
>
> David Cousens
>
> On Fri, 2019-08-02 at 00:02 -0500, David Carlson wrote:
>
> Since Mark had the same file open simultaneously on two machines,  the
> first machine probably lost its work when the second machine closed the
> file.
>
> If one or both are still crashing, he should try to find the trace file as
> descibed in the gnucash wiki and paste it or part of it into a new message
> here.
>
> David Carlson
>
> On Thu, Aug 1, 2019, 8:25 PM David Cousens 
> wrote:
>
> Updated to 3.6 on the Windows 10 box and with the same preference setting
> the
> behavior is as expected and the same as for 3.5 and no crashing. Now we
> need
> to find out what Mark is doing that we are not.
>
> David
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> --
>
> Dr David R Cousens
> B.Sc, M.Prof. Acc., Ph.D., G.C.Ed
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] migration, aka gnucash-user Digest, Vol 196, Issue 61

2019-08-01 Thread David Carlson
Clint,

I use a home made spreadsheet to track lots if I really need to for tax
purposes, but here in the US brokers are supposed to do that for us, and we
just need to be confident that they are doing it correctly.  Also, they are
supposed to use an average cost method unless we told them to use a
different method, so lot tracking is almost a non-issue now.

GnuCash can do it, but it is awkward and very difficult to verify that it
is correct, especially for methods other than fifo or average cost.

David Carlson


On Thu, Aug 1, 2019, 5:03 PM David Cousens  wrote:

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


Re: [GNC] gnucash-user Digest, Vol 196, Issue 61

2019-08-01 Thread David T. via gnucash-user

Migrating investment transactions is particularly challenging because of the 
issue of capital gains and cost basis. I gave up trying, and instead rely on 
the broker-derived assessment of gain because of it. With individual stocks, 
GnuCash's lot features work pretty well, though. 

 
  On Fri, Aug 2, 2019 at 3:26, Clint Chaplin wrote:   In 
this case, DRIPs are not your friend

On Thu, Aug 1, 2019 at 2:53 PM David Cousens 
wrote:

> Clint,
>
> You canhandle existing investments in the same manner you handle an
> existing
> bank account which has a balance when you start. You will have a credit
> entry to Equity:Opening Balances to match the debit entry to the account in
> which you are maintaining the record of your investment (which would
> normally be created somewhere under Assets:Non Current Assets:...).
>
> This would assume you are going to be able to access your existing records
> to get the historical information.
>
> You can add historical information retrospectively, shifting the dates
> back
> and adjusting the amounts of the opening entries as you add data going
> further back.
>
> 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.
>


-- 
Clint (JOATMON) Chaplin
___
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] crashing trying to do a simple split

2019-08-01 Thread David Cousens
Hi David,
That wasn't Mark. I was trying to duplicate what he had done first on my Linux 
Box and then on a Windows10 box. I didn't
close the first before opening the second and didn't reopen the register after 
changing the register preferences in the
first case.
David Cousens
On Fri, 2019-08-02 at 00:02 -0500, David Carlson wrote:
> Since Mark had the same file open simultaneously on two machines,  the first 
> machine probably lost its work when the
> second machine closed the file.
> If one or both are still crashing, he should try to find the trace file as 
> descibed in the gnucash wiki and paste it
> or part of it into a new message here.
> 
> David Carlson 
> On Thu, Aug 1, 2019, 8:25 PM David Cousens  wrote:
> > Updated to 3.6 on the Windows 10 box and with the same preference setting 
> > the
> > 
> > behavior is as expected and the same as for 3.5 and no crashing. Now we need
> > 
> > to find out what Mark is doing that we are not.
> > 
> > 
> > 
> > David
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > -
> > 
> > David Cousens
> > 
> > --
> > 
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > 
> > ___
> > 
> > gnucash-user mailing list
> > 
> > gnucash-user@gnucash.org
> > 
> > To update your subscription preferences or to unsubscribe:
> > 
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > 
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > 
> > -
> > 
> > Please remember to CC this list on all your replies.
> > 
> > You can do this by using Reply-To-List or Reply-All.
> > 
-- 
Dr David R Cousens
B.Sc, M.Prof. Acc., Ph.D., G.C.Ed
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] crashing trying to do a simple split

2019-08-01 Thread David Carlson
Since Mark had the same file open simultaneously on two machines,  the
first machine probably lost its work when the second machine closed the
file.

If one or both are still crashing, he should try to find the trace file as
descibed in the gnucash wiki and paste it or part of it into a new message
here.

David Carlson

On Thu, Aug 1, 2019, 8:25 PM David Cousens  wrote:

> Updated to 3.6 on the Windows 10 box and with the same preference setting
> the
> behavior is as expected and the same as for 3.5 and no crashing. Now we
> need
> to find out what Mark is doing that we are not.
>
> David
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Migration

2019-08-01 Thread Mike Commissaris
>
>
> Date: Thu, 1 Aug 2019 11:09:27 -0700
> From: Clint Chaplin 
> To: Mike Commissaris 
> Cc: Gnucash Users 
> Subject: Re: [GNC] gnucash-user Digest, Vol 196, Issue 61
> Message-ID:
>  tuwx_oihoz_j1pa6bcy+...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> How did you handle your investments?  I can see starting afresh with
> standard transactions, but investments can live and have records for
> decades (capital gains/losses, etc.).
>
> On Wed, Jul 31, 2019 at 10:41 PM Mike Commissaris <
> commissaris.m...@gmail.com> wrote:
>
>

Sorry, not much help for you in that regard. I have a small number of
mutual funds and tend to buy and hold. I did, as you say,  just start fresh
at the beginning of the year, and just added the small amount of activity
throughout the year, without any import. Time allowing, I enter previous
data as I can.



> [GNC] Migration
> >
> > > Date: Wed, 31 Jul 2019 14:01:05 -0700
> > > From: Clint Chaplin 
> > > To: Gnucash Users 
> > > Subject: [GNC] Migration
> > > Message-ID:
> > >  > > ttfsqe4fpkot...@mail.gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > Hi all,
> > >
> > > I am looking for, well, some assurance here.
> > >
> > > How many of you migrated to GnuCash from another financial product?  If
> > you
> > > did, what did you migrate from?  How much data did you have to migrate?
> > > And would you do it again knowing what you know now?
> > >
> > > I am currently using MYM12 with 34 years of data, as well as Quicken5
> in
> > > parallel for the last 20 some odd years.  MYM12 is still plugging away,
> > but
> > > Quicken5 is showing signs of reaching its limits.  Thinking of next
> > steps.
> > > I have read through the GnuCash Guide, and done a little browsing
> through
> > > the last few months of messages here.
> > >
> > >
> > > --
> > > Clint (JOATMON) Chaplin
> > >
> > >
> > > --
> > >
> > >  I read most of the manuals and instructions while using GNC in
> parallel
> > with Quicken for a year. I was also learning Linux Mint. I do home
> > accounting and some investments. Also used AR a couple times.  I dumped
> > Quicken and migrated another previous years data on a month by month, by
> > account basis. I now only use Quicken for 10 plus year's of pre-GNC
> > history.
> >
> > I guess I have learned that migrating in smaller chunks is better and
> check
> > the quality of the files to be imported.
> >
>
___
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] crashing trying to do a simple split

2019-08-01 Thread David Cousens
Updated to 3.6 on the Windows 10 box and with the same preference setting the
behavior is as expected and the same as for 3.5 and no crashing. Now we need
to find out what Mark is doing that we are not.

David



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


Re: [GNC] crashing trying to do a simple split

2019-08-01 Thread David Cousens
John,

Can confirm after reopening the register after changing back to basic ledger
and double line it now works as expected when you enter the transfer account
and the amount of the first line on the Linux box. (File is now only open on
one computer at a time).

I am not however getting the problem Mark encountered when I perform the
same operations in v3.5 on Windows 10 (behavior is now the same as on the
Linux box as we would expect).

Basic Ledger and Double line mode were selected before opening the register
(my savings account)

Open a new transaction at current date , entered a description, tabbed to
the Account field and selected the transfer account (an expense account),
entered an amount in the Credit column.  This created a transaction with the
correct splits as expected - no crashing.

David



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


Re: [GNC] crashing trying to do a simple split

2019-08-01 Thread Adrien Monteleone
I just switched from my usual Transaction Journal to Basic. (I always have 
Double Line mode on)

I was able to enter a date, NUM, and description, then I clicked in the amount 
box (skipping over the ’transfer’ field) and entered an amount. I then hit the 
split *button* and assigned the second split to an account and committed the 
transaction. (first split defaulted to the current account)

So you *can* enter an amount here as you found out.

But I wasn’t able to trigger a crash like the OP, though I am using MacOS 
Mojave and not Win10. (also with 3.6, so 3.5< behavior might be different)

Regards,
Adrien

> On Aug 1, 2019, at 7:43 PM, David Cousens  wrote:
> 
> Hi John,
> 
> I did have both the Autosplit ledger and the Double Line options selected
> however the sequence of operations for creating a transaction is much the
> same with the Basic Ledger selected along with Double-line mode. You still
> can't enter an amount before you open the line for the first split which
> opens with the account selected to the account associated with the current
> register at least on the Linux box.
> 
> I just did the same thing in V3.5 on my wife's Windows 10 box and I seem to
> be getting a different behavior from V3.6 on  the Linux box. Hitting Enter
> after entering the date and description didn't open up a new line and I was
> able to enter the amount at the first line and it created the second splt to
> Imbalance by default.  It may be that I had the register open on the Linux
> box before changing the options and these didn't get passed through
> automatically. 
> 
> I also currently have the same file open on both boxes after overriding the
> lock which is an interesting situation but both are altering the file but
> obviously not reflecting changes to the other unless the file is reloaded.
> I'll check it out a bit more carefully with only one box connected to the
> file at a time.
> 
> David

___
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] crashing trying to do a simple split

2019-08-01 Thread David Cousens
Hi John,

I did have both the Autosplit ledger and the Double Line options selected
however the sequence of operations for creating a transaction is much the
same with the Basic Ledger selected along with Double-line mode. You still
can't enter an amount before you open the line for the first split which
opens with the account selected to the account associated with the current
register at least on the Linux box.

I just did the same thing in V3.5 on my wife's Windows 10 box and I seem to
be getting a different behavior from V3.6 on  the Linux box. Hitting Enter
after entering the date and description didn't open up a new line and I was
able to enter the amount at the first line and it created the second splt to
Imbalance by default.  It may be that I had the register open on the Linux
box before changing the options and these didn't get passed through
automatically. 

I also currently have the same file open on both boxes after overriding the
lock which is an interesting situation but both are altering the file but
obviously not reflecting changes to the other unless the file is reloaded.
I'll check it out a bit more carefully with only one box connected to the
file at a time.

David



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


[GNC] Multiple Open Lots in AP dated 12-31-1969 with no data

2019-08-01 Thread Adrien Monteleone
I was checking lots on my AP account to make sure a split payment had recorded 
correctly and I discovered a large amount of open lots all dated 12-31-69. 
(presumably due to Epoch)

They are empty with no other data associated with them, save two of them have 
bills numbers associated. But investigating the lots for those two bills shows 
they are fully accounted for.

My guess is these might have been generated as a result of unposting and 
reposting bills, but I wanted to confirm.

Also, will the scrub button clean these up, or do I need to delete them 
individually to clean up?

I’m using 3.6 on Mojave, but likely these were generated using 3.4 or 3.5.

Regards,
Adrien
___
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] crashing trying to do a simple split

2019-08-01 Thread John Ralls
David,

I think you're confusing View>Double Line with View>Basic/Autosplit/Transaction 
Journal. View>Double Line just enables the second transaction line to display 
the Notes field. It also shows the contents of the Split Action field from the 
"anchor" split for the open account.

Regards,
John Ralls

> On Aug 1, 2019, at 1:52 PM, David Cousens  wrote:
> 
> Mark,
> 
> Your description of the process you are using doesn't sound correct to me. 
> 
> In Double line mode you would need to enter the date and description. There
> is no place to enter an amount and no Split command available here. At this
> point you would either have to hit Enter to open up the line for the first
> split (which will be to the account of the register you have created the new
> transaction in which will appear in the Account column. You could also reach
> this point by using the Tab key.You can then enter the amount in the
> appropriate column. You can also add appropriate information to the Memo
> field for that split if you wish
> 
> At this point you need to use the tab key to open the line for the second
> split. It is here that you select the account for the second split. Normally
> Gnucash will automatically place the amount you have entered in the first
> split in the other column. If you are not creating a transaction with more
> than two splits, you are done, just click anywhere in the rest of the window
> or in the line for entering another new transaction and your transaction
> will be recorded.
> 
> If your transaction has more than 2 splits, correct the amount for the
> second split and then tab or hit Enter. GnuCash will then open another line
> with the amount of the now third split in the appropriate column with an
> Ophan account displayed. Enter any Memo information and select the correct
> account. Again if you have further splits to add, correct the amount and
> repeat this procedure until your transaction is complete.
> 
> See the Help manual https://www.gnucash.org/docs/v3/C/gnucash-help/help.html 
> Chapter 6 for detail on entering transactions.
> 
> This is how it works in V3.6  on Linux and AFAIK in should be the same under
> Windows 10.
> 
> David Cousens
> 
> 
> 
> 
> 
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash-user Digest, Vol 196, Issue 61

2019-08-01 Thread David Cousens
DRIPS certainly won't make life easy for this sort of exercise.

David



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


Re: [GNC] gnucash-user Digest, Vol 196, Issue 61

2019-08-01 Thread Clint Chaplin
In this case, DRIPs are not your friend

On Thu, Aug 1, 2019 at 2:53 PM David Cousens 
wrote:

> Clint,
>
> You canhandle existing investments in the same manner you handle an
> existing
> bank account which has a balance when you start. You will have a credit
> entry to Equity:Opening Balances to match the debit entry to the account in
> which you are maintaining the record of your investment (which would
> normally be created somewhere under Assets:Non Current Assets:...).
>
> This would assume you are going to be able to access your existing records
> to get the historical information.
>
> You can add historical information retrospectively, shifting the dates
> back
> and adjusting the amounts of the opening entries as you add data going
> further back.
>
> 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.
>


-- 
Clint (JOATMON) Chaplin
___
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-user Digest, Vol 196, Issue 61

2019-08-01 Thread David Cousens
Clint,
 
You canhandle existing investments in the same manner you handle an existing
bank account which has a balance when you start. You will have a credit
entry to Equity:Opening Balances to match the debit entry to the account in
which you are maintaining the record of your investment (which would
normally be created somewhere under Assets:Non Current Assets:...). 

This would assume you are going to be able to access your existing records
to get the historical information.

You can add historical information retrospectively, shifting the dates back 
and adjusting the amounts of the opening entries as you add data going
further back.

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] crashing trying to do a simple split

2019-08-01 Thread John Ralls



> On Aug 1, 2019, at 1:11 PM, Derek Atkins  wrote:
> 
> Hi,
> 
> On Thu, August 1, 2019 3:59 pm, Mark Hedges via gnucash-user wrote:
>> On Thu, Aug 1, 2019 at 12:44 PM Mark Hedges 
>> wrote:
>>> 
>>> I'm in double-line view on a checking ledger.
>>> 
>>> I enter the date, description, and amount.  Then I click split.
>>> 
>>> I enter the amount for one of the split items, and click to choose an
>>> account.
>>> 
>>> GnuCash completely stops and closes with no information.  This is
>>> reproducable.
>> 
>> BTW It's not *entirely* reproducible at the same point.  Sometimes it
>> happens when I choose the first split account.  Sometimes it happens
>> when I choose the second split account.  Usually it happens when I
>> open the accounts menu in the split line.
>> 
>> I will try again with another computer later, which has not been
>> touched for a while.  Thank you.
> 
> What version of Gnucash?
> What OS/Distro?

He says GnuCash 3.6 and Win10 in his original report.

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] crashing trying to do a simple split

2019-08-01 Thread Mark Hedges via gnucash-user
On Thu, Aug 1, 2019 at 12:44 PM Mark Hedges  wrote:
>
> I'm in double-line view on a checking ledger.
>
> I enter the date, description, and amount.  Then I click split.
>
> I enter the amount for one of the split items, and click to choose an account.
>
> GnuCash completely stops and closes with no information.  This is 
> reproducable.

BTW It's not *entirely* reproducible at the same point.  Sometimes it
happens when I choose the first split account.  Sometimes it happens
when I choose the second split account.  Usually it happens when I
open the accounts menu in the split line.

I will try again with another computer later, which has not been
touched for a while.  Thank you.

Mark
___
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] locked data base

2019-08-01 Thread Bob Sisk
That worked! I renamed the data file and "saved as", then closed on my 
desktop. I then opened the same file from Dropbox on my laptop and 
accessed ok from both computers with no problems now. (closed file on 
computer before opening on other of course).


Thanks so much for your help!

On 8/1/19 2:26 PM, Derek Atkins wrote:

Hi,

GnuCash will re-open the last file you used.  So that's not a problem.

But yes, it sounds like this started as a backup file.  So long as you
haven't noticed any data loss, then you can go from there.  I would
recommend that you File -> Save As and then change the name to the base
name instead of xxx.gnucash..gnucash..gnucash!

You're probably fine continuing to use DropBox, but there might be locking
issues if the lock file doesn't get properly deleted when you exit the
application.  I don't use DropBox so can't really explain that any better;
maybe someone else can.

If you are SURE that you don't have the file open on multiple devices then
you're safe using Open Anyways.  However, if you're not sure, then you
need to be careful.  If two copies get opened then the "last write wins"
and will overwrite all changes made on earlier writes.

Good Luck,

-derek

On Thu, August 1, 2019 3:08 pm, Bob Sisk wrote:

Thanks Derek - how do I designate Dropbox to be my main data file? Is it
stored somewhere by default within Gnucash? When I got my new laptop I
clicked into a data file in my home directory (it may have been a
backup?). When I clicked it Gnucash opened and I have been using that -
I transferred  it to Dropbox to use as my main data base. Evidently I
should not have done this. Any help appreciated ---

Thanks,

Bob

On 8/1/19 1:54 PM, Derek Atkins wrote:

HI,

First, please make sure you CC gnucash-user on all replies.

Second, you ARE using a backup file.  The fact that your file name is
FileName.gnucash.MMDDHHMMSS.gnucash means you are using a backup
file.

If you're using DROPBOX...  *THAT* could be the problem.  It could be
that
there is a problem creating or deleting the lock file.

-derek

On Thu, August 1, 2019 2:49 pm, Bob Sisk wrote:

That is not my backup. I am using Dropbox as my data base because I
sometimes post to Gnucash on my desktop and other times using my
laptop.
I store backups on both computers. Is there a better way to configure
if
I post from both machines?

On 8/1/19 1:32 PM, Derek Atkins wrote:

HI,

On Thu, August 1, 2019 2:25 pm, Bob Sisk wrote:

GnuCash could not obtain the lock for
file:///home/bob/Dropbox/gnucash_data/GreenGrillsData.gnucash.20180825170527.gnucash.20190706140712.gnucash.

First, why are you opening a backup file?  Specifically, this is a
backup
of a backup!  So at some point you opened the backup made on August
28,
2018...  And then on July 6th, 2019 you opened a new backup file...
And
have been using that as your data file.   Are you SURE that's what you
want to be doing?


I get the above message when trying to open Gnucash. I click "open
anyway" and it seems normal. What is causing this and what should I
do?
I am running Linux Mint 19.1.

Are you sure that there is not another GnuCash instance running?
Do you perhaps shutdown (or logout) without quitting GnuCash?

This pop-up comes up when GnuCash finds the lock file still there to
prevent two instances of the program from opening the same data file.


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-Derek


--
/Robert Sisk
sisk@gmail.com
(210)716-6400/


--
/Robert Sisk
sisk@gmail.com
(210)716-6400/




--
/Robert Sisk
sisk@gmail.com
(210)716-6400/
___
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] crashing trying to do a simple split

2019-08-01 Thread Mark Hedges via gnucash-user
I'm in double-line view on a checking ledger.

I enter the date, description, and amount.  Then I click split.

I enter the amount for one of the split items, and click to choose an account.

GnuCash completely stops and closes with no information.  This is reproducable.

I upgraded from 3.5 to 3.6 just now, but no luck.  I tried save-as a
new file, didn't help.  Tried full shutdown and restart.

I see errors in the Windows 10 Event Viewer, Event ID 1000, Task
Category (100), no OpCode:

Faulting application name: gnucash.exe, version: 3.6.0.0, time stamp: 0x5d18e904
Faulting module name: libgncmod-register-gnome.dll, version: 0.0.0.0,
time stamp: 0x5d18e833
Exception code: 0xc005
Fault offset: 0x00015055
Faulting process id: 0x6ac
Faulting application start time: 0x01d5489ed2f08fe4
Faulting application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe
Faulting module path: C:\Program Files
(x86)\gnucash\bin\libgncmod-register-gnome.dll
Report Id: 441a44f6-f5f0-4e26-9173-554a8d0b7ab2
Faulting package full name:
Faulting package-relative application ID:

Faulting application name: gnucash.exe, version: 3.5.0.0, time stamp: 0x5ca00e01
Faulting module name: libgncmod-register-gnome.dll, version: 0.0.0.0,
time stamp: 0x5ca00d82
Exception code: 0xc005
Fault offset: 0x00015381
Faulting process id: 0x1038
Faulting application start time: 0x01d5489debc7aa79
Faulting application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe
Faulting module path: C:\Program Files
(x86)\gnucash\bin\libgncmod-register-gnome.dll
Report Id: 9380260e-5b8b-40b6-8897-c68a4ae3b6e1
Faulting package full name:
Faulting package-relative application ID:

What now?  I can't do any more work.

--
Mark Hedges
CEO Weird Vibe Inc.
+1-310-487-7123
https://weirdvibe.media
___
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] locked data base

2019-08-01 Thread Derek Atkins
Hi,

GnuCash will re-open the last file you used.  So that's not a problem.

But yes, it sounds like this started as a backup file.  So long as you
haven't noticed any data loss, then you can go from there.  I would
recommend that you File -> Save As and then change the name to the base
name instead of xxx.gnucash..gnucash..gnucash!

You're probably fine continuing to use DropBox, but there might be locking
issues if the lock file doesn't get properly deleted when you exit the
application.  I don't use DropBox so can't really explain that any better;
maybe someone else can.

If you are SURE that you don't have the file open on multiple devices then
you're safe using Open Anyways.  However, if you're not sure, then you
need to be careful.  If two copies get opened then the "last write wins"
and will overwrite all changes made on earlier writes.

Good Luck,

-derek

On Thu, August 1, 2019 3:08 pm, Bob Sisk wrote:
> Thanks Derek - how do I designate Dropbox to be my main data file? Is it
> stored somewhere by default within Gnucash? When I got my new laptop I
> clicked into a data file in my home directory (it may have been a
> backup?). When I clicked it Gnucash opened and I have been using that -
> I transferred  it to Dropbox to use as my main data base. Evidently I
> should not have done this. Any help appreciated ---
>
> Thanks,
>
> Bob
>
> On 8/1/19 1:54 PM, Derek Atkins wrote:
>> HI,
>>
>> First, please make sure you CC gnucash-user on all replies.
>>
>> Second, you ARE using a backup file.  The fact that your file name is
>> FileName.gnucash.MMDDHHMMSS.gnucash means you are using a backup
>> file.
>>
>> If you're using DROPBOX...  *THAT* could be the problem.  It could be
>> that
>> there is a problem creating or deleting the lock file.
>>
>> -derek
>>
>> On Thu, August 1, 2019 2:49 pm, Bob Sisk wrote:
>>> That is not my backup. I am using Dropbox as my data base because I
>>> sometimes post to Gnucash on my desktop and other times using my
>>> laptop.
>>> I store backups on both computers. Is there a better way to configure
>>> if
>>> I post from both machines?
>>>
>>> On 8/1/19 1:32 PM, Derek Atkins wrote:
 HI,

 On Thu, August 1, 2019 2:25 pm, Bob Sisk wrote:
> GnuCash could not obtain the lock for
> file:///home/bob/Dropbox/gnucash_data/GreenGrillsData.gnucash.20180825170527.gnucash.20190706140712.gnucash.
 First, why are you opening a backup file?  Specifically, this is a
 backup
 of a backup!  So at some point you opened the backup made on August
 28,
 2018...  And then on July 6th, 2019 you opened a new backup file...
 And
 have been using that as your data file.   Are you SURE that's what you
 want to be doing?

> I get the above message when trying to open Gnucash. I click "open
> anyway" and it seems normal. What is causing this and what should I
> do?
> I am running Linux Mint 19.1.
 Are you sure that there is not another GnuCash instance running?
 Do you perhaps shutdown (or logout) without quitting GnuCash?

 This pop-up comes up when GnuCash finds the lock file still there to
 prevent two instances of the program from opening the same data file.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
 -Derek

>>> --
>>> /Robert Sisk
>>> sisk@gmail.com
>>> (210)716-6400/
>>>
>>
> --
> /Robert Sisk
> sisk@gmail.com
> (210)716-6400/
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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] locked data base

2019-08-01 Thread Bob Sisk
Thanks Derek - how do I designate Dropbox to be my main data file? Is it 
stored somewhere by default within Gnucash? When I got my new laptop I 
clicked into a data file in my home directory (it may have been a 
backup?). When I clicked it Gnucash opened and I have been using that - 
I transferred  it to Dropbox to use as my main data base. Evidently I 
should not have done this. Any help appreciated ---


Thanks,

Bob

On 8/1/19 1:54 PM, Derek Atkins wrote:

HI,

First, please make sure you CC gnucash-user on all replies.

Second, you ARE using a backup file.  The fact that your file name is
FileName.gnucash.MMDDHHMMSS.gnucash means you are using a backup file.

If you're using DROPBOX...  *THAT* could be the problem.  It could be that
there is a problem creating or deleting the lock file.

-derek

On Thu, August 1, 2019 2:49 pm, Bob Sisk wrote:

That is not my backup. I am using Dropbox as my data base because I
sometimes post to Gnucash on my desktop and other times using my laptop.
I store backups on both computers. Is there a better way to configure if
I post from both machines?

On 8/1/19 1:32 PM, Derek Atkins wrote:

HI,

On Thu, August 1, 2019 2:25 pm, Bob Sisk wrote:

GnuCash could not obtain the lock for
file:///home/bob/Dropbox/gnucash_data/GreenGrillsData.gnucash.20180825170527.gnucash.20190706140712.gnucash.

First, why are you opening a backup file?  Specifically, this is a
backup
of a backup!  So at some point you opened the backup made on August 28,
2018...  And then on July 6th, 2019 you opened a new backup file...  And
have been using that as your data file.   Are you SURE that's what you
want to be doing?


I get the above message when trying to open Gnucash. I click "open
anyway" and it seems normal. What is causing this and what should I do?
I am running Linux Mint 19.1.

Are you sure that there is not another GnuCash instance running?
Do you perhaps shutdown (or logout) without quitting GnuCash?

This pop-up comes up when GnuCash finds the lock file still there to
prevent two instances of the program from opening the same data file.


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-Derek


--
/Robert Sisk
sisk@gmail.com
(210)716-6400/




--
/Robert Sisk
sisk@gmail.com
(210)716-6400/
___
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] locked data base

2019-08-01 Thread Derek Atkins
HI,

First, please make sure you CC gnucash-user on all replies.

Second, you ARE using a backup file.  The fact that your file name is
FileName.gnucash.MMDDHHMMSS.gnucash means you are using a backup file.

If you're using DROPBOX...  *THAT* could be the problem.  It could be that
there is a problem creating or deleting the lock file.

-derek

On Thu, August 1, 2019 2:49 pm, Bob Sisk wrote:
> That is not my backup. I am using Dropbox as my data base because I
> sometimes post to Gnucash on my desktop and other times using my laptop.
> I store backups on both computers. Is there a better way to configure if
> I post from both machines?
>
> On 8/1/19 1:32 PM, Derek Atkins wrote:
>> HI,
>>
>> On Thu, August 1, 2019 2:25 pm, Bob Sisk wrote:
>>> GnuCash could not obtain the lock for
>>> file:///home/bob/Dropbox/gnucash_data/GreenGrillsData.gnucash.20180825170527.gnucash.20190706140712.gnucash.
>> First, why are you opening a backup file?  Specifically, this is a
>> backup
>> of a backup!  So at some point you opened the backup made on August 28,
>> 2018...  And then on July 6th, 2019 you opened a new backup file...  And
>> have been using that as your data file.   Are you SURE that's what you
>> want to be doing?
>>
>>> I get the above message when trying to open Gnucash. I click "open
>>> anyway" and it seems normal. What is causing this and what should I do?
>>> I am running Linux Mint 19.1.
>> Are you sure that there is not another GnuCash instance running?
>> Do you perhaps shutdown (or logout) without quitting GnuCash?
>>
>> This pop-up comes up when GnuCash finds the lock file still there to
>> prevent two instances of the program from opening the same data file.
>>
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> -Derek
>>
> --
> /Robert Sisk
> sisk@gmail.com
> (210)716-6400/
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] locked data base

2019-08-01 Thread Derek Atkins
HI,

On Thu, August 1, 2019 2:25 pm, Bob Sisk wrote:
> GnuCash could not obtain the lock for
> file:///home/bob/Dropbox/gnucash_data/GreenGrillsData.gnucash.20180825170527.gnucash.20190706140712.gnucash.

First, why are you opening a backup file?  Specifically, this is a backup
of a backup!  So at some point you opened the backup made on August 28,
2018...  And then on July 6th, 2019 you opened a new backup file...  And
have been using that as your data file.   Are you SURE that's what you
want to be doing?

> I get the above message when trying to open Gnucash. I click "open
> anyway" and it seems normal. What is causing this and what should I do?
> I am running Linux Mint 19.1.

Are you sure that there is not another GnuCash instance running?
Do you perhaps shutdown (or logout) without quitting GnuCash?

This pop-up comes up when GnuCash finds the lock file still there to
prevent two instances of the program from opening the same data file.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-Derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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] locked data base

2019-08-01 Thread Bob Sisk
GnuCash could not obtain the lock for 
file:///home/bob/Dropbox/gnucash_data/GreenGrillsData.gnucash.20180825170527.gnucash.20190706140712.gnucash.


I get the above message when trying to open Gnucash. I click "open 
anyway" and it seems normal. What is causing this and what should I do? 
I am running Linux Mint 19.1.


--
/Robert Sisk
sisk@gmail.com
(210)716-6400/
___
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] Migration

2019-08-01 Thread Clint Chaplin
Thanks!

MYM, unfortunately, does not rigidly enforce the double entry aspects of
financial recording.  As a for instance, 401(k) contributions from my
paycheck would not automatically transfer to the account; I've had to
manually adjust the cash balance of the investment to record the
contribution.

On Thu, Aug 1, 2019 at 1:20 AM David Carlson 
wrote:

> Hi,
>
> Welcome to GnuCash!
>
> I found the user group called "MYM users" on Facebook and the forum on
> https://www.starkeysoftware.com/MYM/.  I recall that MYM was very nice
> when
> I used it, and I think it was rather rigidly double-entry, so it should
> import into GnuCash rather easily if it can make good QIF exports.  Since
> it basically is limited to one or two years' data in a data file, you would
> probably want to convert one file at a time and keep them separate rather
> than concatenating them into a "huge" single data file.  While GnuCash
> doesn't have the DOS limits, from personal experience I can tell you that
> it still gets slow with a decade long data file.
>
> I have some old MYM data files on some old hard drive if I ever have time
> to fire it up, or really old floppies but I can't find them right now.
>
> GnuCash is rigidly double-entry but it can keep basic investment records as
> well as checkbook records.  It is limited as a budgeting tool, tho.
>
> It does have a bit of a learning curve, but I like it better than the
> others that I have tried.
>
> David Carlson
>
> On Thu, Aug 1, 2019 at 12:21 AM Dennis Powless 
> wrote:
>
> > I can say the migration process wasn't easy, but wasn't too hard.  I was
> > able to do it and got it up and running with all my old quicken data.  I
> > can't remember the number of years of quicken data, maybe 5-10 years or
> > more.  I've probably been with gnucash for about 10 years maybe.
> >
> > After all is said and done, I'd NEVER go back to quicken.  Gnucash has
> done
> > everything I need (I don't have complicated stocks or investments).  I
> only
> > use it for my personal finances, not a business, so can't comment on
> that.
> >
> >
> > I'm not familiar with MYM12, so don't know about that migration.
> >
> > Gnucash is a great program and open source, the devs work very hard on
> > keeping it up to date and are making improvements all the time.
> >
> > d
> >
> > On Wed, Jul 31, 2019 at 11:04 PM David T. via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> > > I won't comment on whether the migration process has become simpler
> over
> > > the years, as I haven't done it in about as long.
> > >
> > > There has been a huge amount of discussion over the years on the
> question
> > > of migration from Quicken (usually tied either to the beginning of a
> new
> > > calendar year, or the imposition of a new fee structure by Intuit).
> > >
> > > A search of the mailing list archives will turn these up.
> > >
> > > Additionally, the wiki includes a summary of many of the points that
> have
> > > been raised on the topic.
> > > wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data
> > >
> > > I can't comment on the ease of migration from the other application,
> but
> > I
> > > can say that the strict enforcement of double entry accounting in
> gnucash
> > > causes most Quicken refugees some discomfort. People with complicated
> > stock
> > > holdings also encounter special challenges typically.
> > >
> > > David
> > >
> > >
> > >   On Thu, Aug 1, 2019 at 6:54, Jean-David Beyer via gnucash-user<
> > > gnucash-user@gnucash.org> wrote:   On 7/31/19 5:01 PM, Clint Chaplin
> > > wrote:
> > > > Hi all,
> > > >
> > > > I am looking for, well, some assurance here.
> > > >
> > > > How many of you migrated to GnuCash from another financial product?
> If
> > > you
> > > > did, what did you migrate from?  How much data did you have to
> migrate?
> > > > And would you do it again knowing what you know now?
> > > >
> > >
> > > I ran Quicken for a few years, but I could not stand Windows 95
> (current
> > > at the time), so I switched to Red Hat Linux 5 in about mid 1998. A
> > > little later, I started using GnuCash. It could presumably convert from
> > > Quicken, but it made such a mess of mine that I just dropped all the
> old
> > > data and started afresh.
> > >
> > > I suppose in the decade or more since than, Gnucash has improved the
> > > behavior of the conversions.
> > >
> > >
> > > --
> > >   .~.  Jean-David Beyer
> > >   /V\  PGP-Key:166D840A 0C610C8B
> > >  /( )\ Shrewsbury, New Jersey
> > >  ^^-^^ 21:15:01 up 6 days, 6:07, 2 users, load average: 5.41, 5.02,
> 4.87
> > > ___
> > > 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 

Re: [GNC] Postgresql backend setup

2019-08-01 Thread Derek Atkins
Steve Riley via gnucash-user  writes:

> I am using Manjaro Linux as an operating system.
>
> I installed gnucash 3.5-1 using either pacman or Octopi (did it a while ago)
>
> I used the default build, it may have been a binary.
>
> I will investigate the possibility that the the build did not include
> Postgresql by default. I just assumed this all came built in

Make sure you have the PG libdbi-dbd installed.

> Thanks

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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] Postgresql backend setup

2019-08-01 Thread Colin Law
Which version of GC are you using and on what operating system. How
did you install gnucash?  It is possible the build you used does not
include Postgresql.

Colin

On Thu, 1 Aug 2019 at 13:46, Steve Riley via gnucash-user
 wrote:
>
> Greetings,
>
> Trying to set up a brand new set of accounts to use postgresql as the
> backend.
>
> Following the new file instructions in the tutorial, when I use SaveAs,
> my only option in the dropdown box is 'xml'.
>
> What do I need to do to have gnucash add a postresql option to this
> dropdown?
>
> Are there any permissions/initial setup instructions for use with
> gnucash? I have set up a superuser for my login username. Per the
> postgresql setup instructions, access to the data directory for
> databases is limited to owner/group postgres, but I was able to create a
> test database using my login username.
>
> My apologies if this topic has been covered ad nauseum previously. I
> have not figured out yet how to search for a particular topic on the
> mailing list
>
> Steve
>
>
> ___
> 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] Migration

2019-08-01 Thread David Carlson
Hi,

Welcome to GnuCash!

I found the user group called "MYM users" on Facebook and the forum on
https://www.starkeysoftware.com/MYM/.  I recall that MYM was very nice when
I used it, and I think it was rather rigidly double-entry, so it should
import into GnuCash rather easily if it can make good QIF exports.  Since
it basically is limited to one or two years' data in a data file, you would
probably want to convert one file at a time and keep them separate rather
than concatenating them into a "huge" single data file.  While GnuCash
doesn't have the DOS limits, from personal experience I can tell you that
it still gets slow with a decade long data file.

I have some old MYM data files on some old hard drive if I ever have time
to fire it up, or really old floppies but I can't find them right now.

GnuCash is rigidly double-entry but it can keep basic investment records as
well as checkbook records.  It is limited as a budgeting tool, tho.

It does have a bit of a learning curve, but I like it better than the
others that I have tried.

David Carlson

On Thu, Aug 1, 2019 at 12:21 AM Dennis Powless 
wrote:

> I can say the migration process wasn't easy, but wasn't too hard.  I was
> able to do it and got it up and running with all my old quicken data.  I
> can't remember the number of years of quicken data, maybe 5-10 years or
> more.  I've probably been with gnucash for about 10 years maybe.
>
> After all is said and done, I'd NEVER go back to quicken.  Gnucash has done
> everything I need (I don't have complicated stocks or investments).  I only
> use it for my personal finances, not a business, so can't comment on that.
>
>
> I'm not familiar with MYM12, so don't know about that migration.
>
> Gnucash is a great program and open source, the devs work very hard on
> keeping it up to date and are making improvements all the time.
>
> d
>
> On Wed, Jul 31, 2019 at 11:04 PM David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > I won't comment on whether the migration process has become simpler over
> > the years, as I haven't done it in about as long.
> >
> > There has been a huge amount of discussion over the years on the question
> > of migration from Quicken (usually tied either to the beginning of a new
> > calendar year, or the imposition of a new fee structure by Intuit).
> >
> > A search of the mailing list archives will turn these up.
> >
> > Additionally, the wiki includes a summary of many of the points that have
> > been raised on the topic.
> > wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data
> >
> > I can't comment on the ease of migration from the other application, but
> I
> > can say that the strict enforcement of double entry accounting in gnucash
> > causes most Quicken refugees some discomfort. People with complicated
> stock
> > holdings also encounter special challenges typically.
> >
> > David
> >
> >
> >   On Thu, Aug 1, 2019 at 6:54, Jean-David Beyer via gnucash-user<
> > gnucash-user@gnucash.org> wrote:   On 7/31/19 5:01 PM, Clint Chaplin
> > wrote:
> > > Hi all,
> > >
> > > I am looking for, well, some assurance here.
> > >
> > > How many of you migrated to GnuCash from another financial product?  If
> > you
> > > did, what did you migrate from?  How much data did you have to migrate?
> > > And would you do it again knowing what you know now?
> > >
> >
> > I ran Quicken for a few years, but I could not stand Windows 95 (current
> > at the time), so I switched to Red Hat Linux 5 in about mid 1998. A
> > little later, I started using GnuCash. It could presumably convert from
> > Quicken, but it made such a mess of mine that I just dropped all the old
> > data and started afresh.
> >
> > I suppose in the decade or more since than, Gnucash has improved the
> > behavior of the conversions.
> >
> >
> > --
> >   .~.  Jean-David Beyer
> >   /V\  PGP-Key:166D840A 0C610C8B
> >  /( )\ Shrewsbury, New Jersey
> >  ^^-^^ 21:15:01 up 6 days, 6:07, 2 users, load average: 5.41, 5.02, 4.87
> > ___
> > 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.
> >
> ___