Re: Manually entering historic records

2018-01-15 Thread Liz 
On Tue, 16 Jan 2018 15:03:04 +1000
Dave H  wrote:

> I use Dropbox however I maintain my gnucash data file on my local
> drive rather than directly in Dropbox.  I think from memory the lock
> file hangs around in Dropbox so when you try to re-open your data
> file the LCK file is still the and triggers the warning dialog.  As
> others have said you can just click on open anyway if you're sure no
> one else has it open..
> 
> Keep your data file locally and depending on your OS use something
> like FreeFileSync / Create Synchronicity / etc to sync it to Dropbox
> when you are good and ready.
> 
> Cheers Dave H.


I use Dropbox a little differently. 
My gnucash folder is not part of my dropbox folder, but I rsync certain
changed files to the folder which syncs. They are the data files, and
none of the backups or lock files. cron runs the rsync at specific
intervals.

Gnucash folder > intermediate folder > cloud storage

It's a backup system only.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Manually entering historic records

2018-01-15 Thread Dave H 
I use Dropbox however I maintain my gnucash data file on my local drive
rather than directly in Dropbox.  I think from memory the lock file hangs
around in Dropbox so when you try to re-open your data file the LCK file is
still the and triggers the warning dialog.  As others have said you can
just click on open anyway if you're sure no one else has it open..

Keep your data file locally and depending on your OS use something like
FreeFileSync / Create Synchronicity / etc to sync it to Dropbox when you
are good and ready.

Cheers Dave H.


On 16 January 2018 at 14:39, David Carlson 
wrote:

> Trevor,
>
> Have you tried making a copy of the file on your local drive and working on
> it there.  I have never worked with dropbox so I have no idea if it could
> confused by the way GnuCash makes backups, for example.
>
> David C
>
> On Mon, Jan 15, 2018 at 9:39 PM, Chris Smith  wrote:
>
> > If you don't have it open elsewhere you can click "Open anyway"
> >
> > Depending on how it shutdown the lock file may be there.
> >
> >
> > On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" <
> > gnucash-user@gnucash.org> wrote:
> >
> > I'm not making much progress... I see I got some replies to my manual
> entry
> > issues but now unable to investigate further... see attached
> screen-prints.
> >
> >
> >
> > On Sunday, 14 January 2018, 19:27:21 GMT+8, Trevor Richards <
> > tr...@yahoo.co.uk> wrote:
> >
> >  I'll bet I'm doing something dumb... but even with date drop-down menu,
> I
> > am unable to insert any date before 11Jan. See attached.
> >
> >
> > On Sunday, 14 January 2018, 16:43:58 GMT+8, Rick Copple <
> > r...@copplecleaningservice.com> wrote:
> >
> >  Hi Trevor,
> >
> > What exactly is it doing to prevent you from entering past dates? I enter
> > them all the time. You do have to enter the / dividers. Like instead of
> > 11418 you would have to enter 1/14/18 to get the date to come out right.
> > --Rick Copple
> >
> >
> > On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:
> >
> >
> > I've been following the user group for years but still not started the
> move
> > from 20yrs of MSmoney... all looks too hard with an MSM file with records
> > back to 1997.
> > I thought I could test the water with a new business and associated bank
> > account that started in 2016.I've been managing this with a spreadsheet
> as
> > very few transactions.
> > So I set up a business set of accounts and tried entering manually, the
> > historic records... I'm immediately stumped. It does not let me enter
> past
> > dates. Clearly I'm going about this in the wrong way.Advice
> > appreciated.Trevor
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Manually entering historic records

2018-01-15 Thread David Carlson 
Trevor,

Have you tried making a copy of the file on your local drive and working on
it there.  I have never worked with dropbox so I have no idea if it could
confused by the way GnuCash makes backups, for example.

David C

On Mon, Jan 15, 2018 at 9:39 PM, Chris Smith  wrote:

> If you don't have it open elsewhere you can click "Open anyway"
>
> Depending on how it shutdown the lock file may be there.
>
>
> On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" <
> gnucash-user@gnucash.org> wrote:
>
> I'm not making much progress... I see I got some replies to my manual entry
> issues but now unable to investigate further... see attached screen-prints.
>
>
>
> On Sunday, 14 January 2018, 19:27:21 GMT+8, Trevor Richards <
> tr...@yahoo.co.uk> wrote:
>
>  I'll bet I'm doing something dumb... but even with date drop-down menu, I
> am unable to insert any date before 11Jan. See attached.
>
>
> On Sunday, 14 January 2018, 16:43:58 GMT+8, Rick Copple <
> r...@copplecleaningservice.com> wrote:
>
>  Hi Trevor,
>
> What exactly is it doing to prevent you from entering past dates? I enter
> them all the time. You do have to enter the / dividers. Like instead of
> 11418 you would have to enter 1/14/18 to get the date to come out right.
> --Rick Copple
>
>
> On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:
>
>
> I've been following the user group for years but still not started the move
> from 20yrs of MSmoney... all looks too hard with an MSM file with records
> back to 1997.
> I thought I could test the water with a new business and associated bank
> account that started in 2016.I've been managing this with a spreadsheet as
> very few transactions.
> So I set up a business set of accounts and tried entering manually, the
> historic records... I'm immediately stumped. It does not let me enter past
> dates. Clearly I'm going about this in the wrong way.Advice
> appreciated.Trevor
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Manually entering historic records

2018-01-15 Thread Adrien Monteleone 
I’d choose “Open Anyway” as well, but you could also delete that LCK file. 
That’s the one causing the problem. (Note, it is supposed to be there if you 
have the file already open, but since you know for a fact you don’t, you can 
delete it. Normally, this file is deleted when you close the application, or 
open a different book.)


> On Jan 15, 2018, at 9:39 PM, Chris Smith  wrote:
> 
> If you don't have it open elsewhere you can click "Open anyway"
> 
> Depending on how it shutdown the lock file may be there.
> 
> 
> On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" <
> gnucash-user@gnucash.org> wrote:
> 
> I'm not making much progress... I see I got some replies to my manual entry
> issues but now unable to investigate further... see attached screen-prints.
> 
> 
> 
>On Sunday, 14 January 2018, 19:27:21 GMT+8, Trevor Richards <
> tr...@yahoo.co.uk> wrote:
> 
> I'll bet I'm doing something dumb... but even with date drop-down menu, I
> am unable to insert any date before 11Jan. See attached.
> 
> 
>On Sunday, 14 January 2018, 16:43:58 GMT+8, Rick Copple <
> r...@copplecleaningservice.com> wrote:
> 
> Hi Trevor,
> 
> What exactly is it doing to prevent you from entering past dates? I enter
> them all the time. You do have to enter the / dividers. Like instead of
> 11418 you would have to enter 1/14/18 to get the date to come out right.
> --Rick Copple
> 
> 
> On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:
> 
> 
> I've been following the user group for years but still not started the move
> from 20yrs of MSmoney... all looks too hard with an MSM file with records
> back to 1997.
> I thought I could test the water with a new business and associated bank
> account that started in 2016.I've been managing this with a spreadsheet as
> very few transactions.
> So I set up a business set of accounts and tried entering manually, the
> historic records... I'm immediately stumped. It does not let me enter past
> dates. Clearly I'm going about this in the wrong way.Advice
> appreciated.Trevor
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Manually entering historic records

2018-01-15 Thread Chris Smith 
If you don't have it open elsewhere you can click "Open anyway"

Depending on how it shutdown the lock file may be there.


On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" <
gnucash-user@gnucash.org> wrote:

I'm not making much progress... I see I got some replies to my manual entry
issues but now unable to investigate further... see attached screen-prints.



On Sunday, 14 January 2018, 19:27:21 GMT+8, Trevor Richards <
tr...@yahoo.co.uk> wrote:

 I'll bet I'm doing something dumb... but even with date drop-down menu, I
am unable to insert any date before 11Jan. See attached.


On Sunday, 14 January 2018, 16:43:58 GMT+8, Rick Copple <
r...@copplecleaningservice.com> wrote:

 Hi Trevor,

What exactly is it doing to prevent you from entering past dates? I enter
them all the time. You do have to enter the / dividers. Like instead of
11418 you would have to enter 1/14/18 to get the date to come out right.
--Rick Copple


On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:


I've been following the user group for years but still not started the move
from 20yrs of MSmoney... all looks too hard with an MSM file with records
back to 1997.
I thought I could test the water with a new business and associated bank
account that started in 2016.I've been managing this with a spreadsheet as
very few transactions.
So I set up a business set of accounts and tried entering manually, the
historic records... I'm immediately stumped. It does not let me enter past
dates. Clearly I'm going about this in the wrong way.Advice
appreciated.Trevor
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Manually entering historic records

2018-01-14 Thread Colin Law 
On 14 January 2018 at 09:59, Gregory L. Davis  wrote:
> Trevor:
>
> It sounds to me like you have to increase the number of days for "Read only"
> transactions.  Try clicking on the file menu, then preferences. In the
> "Accounts" tab, increase "Day Threshold for Read-Only Transactions (red
> line):".  You can set the number of days to to something like 800 to include
> all of 2016.

Is that a new feature? I don't see it in 2.6.17.
I think it is Edit > Preferences rather than File, but I still don't have it.

Colin

>
> Hope this helps,
>
> greg
>
>
>
>
> I've been following the user group for years but still not started the move
> from 20yrs of MSmoney... all looks too hard with an MSM file with records
> back to 1997.
> I thought I could test the water with a new business and associated bank
> account that started in 2016.I've been managing this with a spreadsheet as
> very few transactions.
> So I set up a business set of accounts and tried entering manually, the
> historic records... I'm immediately stumped. It does not let me enter past
> dates. Clearly I'm going about this in the wrong way.Advice
> appreciated.Trevor
>
>
> --
> Gregory L. Davis
> g...@centurytel.net
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Manually entering historic records

2018-01-14 Thread Gregory L. Davis 

Trevor:

It sounds to me like you have to increase the number of days for "Read 
only" transactions.  Try clicking on the file menu, then preferences. 
In the "Accounts" tab, increase "Day Threshold for Read-Only 
Transactions (red line):".  You can set the number of days to to 
something like 800 to include all of 2016.


Hope this helps,

greg




I've been following the user group for years but still not started the 
move from 20yrs of MSmoney... all looks too hard with an MSM file with 
records back to 1997.
I thought I could test the water with a new business and associated bank 
account that started in 2016.I've been managing this with a spreadsheet 
as very few transactions.
So I set up a business set of accounts and tried entering manually, the 
historic records... I'm immediately stumped. It does not let me enter 
past dates. Clearly I'm going about this in the wrong way.Advice 
appreciated.Trevor



--
Gregory L. Davis
g...@centurytel.net
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Manually entering historic records

2018-01-14 Thread Rick Copple 
Hi Trevor,

What exactly is it doing to prevent you from entering past dates? I enter them 
all the time. You do have to enter the / dividers. Like instead of 11418 you 
would have to enter 1/14/18 to get the date to come out right. 

--
Rick Copple


On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:

> I've been following the user group for years but still not started the move 
> from 20yrs of MSmoney... all looks too hard with an MSM file with records 
> back to 1997.
> I thought I could test the water with a new business and associated bank 
> account that started in 2016.I've been managing this with a spreadsheet as 
> very few transactions.
> So I set up a business set of accounts and tried entering manually, the 
> historic records... I'm immediately stumped. It does not let me enter past 
> dates. Clearly I'm going about this in the wrong way.Advice appreciated.Trevor
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.