[GNC] gnucash-user Digest, Vol 226, Issue 58
Heide Wang
heidew99 at gmail.com
Wed Jan 19 13:59:20 EST 2022
How can I get the “Note” column to show up?
> On Jan 19, 2022, at 9:00 AM, gnucash-user-request at gnucash.org wrote:
>
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: gnucash-user Digest, Vol 226, Issue 48 (Liz)
> 2. Re: OneDrive and GnuCash (Edward Doolittle)
> 3. Re: Exiting gnucash Lock file Vol 226, Issue 57 (Peter)
> 4. Re: Exiting gnucash Lock file Vol 226, Issue 57 (David Carlson)
> 5. Re: OneDrive (jim at billinghurst.net)
> 6. Re: OneDrive (Chris Green)
> 7. Re: Exiting gnucash Lock file Vol 226, Issue 57 (Peter)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 19 Jan 2022 09:53:08 +1100
> From: Liz <edodd at billiau.net>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] gnucash-user Digest, Vol 226, Issue 48
> Message-ID: <20220119095308.2b432e89 at billiau.net>
> Content-Type: text/plain; charset=US-ASCII
>
> On Tue, 18 Jan 2022 14:17:10 -0800
> Heide Wang <heidew99 at gmail.com> wrote:
>
>> after I recorded the split transaction, the furniture account shows
>> 250.00 but did not show it is for a chair. Did I do something wrong?
>> why on the split transaction it shows a chair but not on the
>> furniture account ledge?
>
> I think you have put the "chair" on the notes for the payment to the
> credit card company, rather than on the note in the split for the
> furniture.
>
> The long answer is to make the credit card account another account in
> Gnucash and enter the two transactions separately into the credit card
> account, then pay the credit card from the cheque account.
>
> Liz
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 18 Jan 2022 23:01:21 +0000
> From: Edward Doolittle <edward.doolittle at gmail.com>
> To: David Carlson <david.carlson.417 at gmail.com>, Gnucash Users
> <gnucash-user at gnucash.org>
> Subject: Re: [GNC] OneDrive and GnuCash
> Message-ID:
> <DM6PR05MB67640E108B4D307F6BC6BEC2F6589 at DM6PR05MB6764.namprd05.prod.outlook.com>
>
> Content-Type: text/plain; charset="Windows-1252"
>
> I tried OneDrive with gc for a while. It worked until it didn?t. I?m still not sure what happened, but I think MS unilaterally decided to reorganize my OneDrive setup. Gc just did not like what it did and starting one day gc would not open the file. I?m not sure what was wrong, and I couldn?t find out, because I don?t get the Windows file system at all (Unix guy here) and I just could not figure it out even with Google?s help. My hypothesis was that somewhere along the line something like a symlink was being used and gc didn?t like it. But I still don?t have a clue, and I don?t need the aggravation, so I just moved my gc files out of OneDrive.
>
> I?ve not (yet) had any problems with Office apps and OneDrive which led me to believe the problem is that gc accesses the Windows file system at too low a level, but I?m sorry, I just don?t have time these days to help debug this problem.
>
> Aside from that, I was always sweating over race conditions. Once a long time ago I lost some work because it wasn?t uploaded by OneDrive and then I force opened the file on another computer overriding the lock (bad habit cuz I had to do it fairly regularly). The work was in the cloud somewhere but it was less trouble in that case for me to retype it. So my fault, really, but I really really don?t need to expend a chunk of my brain mentally modelling the cloud sync and lock behaviour every time I use gc.
>
> Other cloud file services might provide better warnings, and might allow you to wrap the call to gc in a test that will pop a warning until the file is up-to-date in the cloud. Heck, OneDrive might provide such a wrapper too but I don?t know the system well enough.
>
> One piece of advice for everyone: when transferring data from paper to gc, keep the paper with potentially unsynced data in a separate pile until you know it?s ok (for whatever sense of ok is relevant to you ? cloud synced or hard drive synced or backed up to external hd, e.g.). When you know it is synced or otherwise backed up, then file it. In addition to losing data to the cloud issue described above, I?ve also lost data the old fashioned way (power failure on a desktop without battery backup), and both times I had more trouble than necessary re-running my transactions because I managed all those slips of paper poorly.
>
> Edward
> ________________________________
> From: gnucash-user <gnucash-user-bounces+edward.doolittle=gmail.com at gnucash.org> on behalf of David Carlson <david.carlson.417 at gmail.com>
> Sent: Tuesday, January 18, 2022 12:52 PM
> To: Gnucash Users
> Subject: [GNC] OneDrive and GnuCash
>
> Are there any GnuCash users that store their data files in One Drive?
>
> Are there any issues slow response or keeping a few weeks of backup and log
> files?
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 19 Jan 2022 13:01:33 +0800
> From: Peter <pandem at iinet.net.au>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Exiting gnucash Lock file Vol 226, Issue 57
> Message-ID: <693e324d-b2a9-10ea-a2ab-29d4caebd84f at iinet.net.au>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> This is interesting.
>
> I have had this problem of gnucash intermittently not removing the LOCK
> file for some time.
> My method of closing gnucash is firstly to save the data and the close
> using the menu. I always follow this process and never use the 'X' method.
>
> August 24, 2021 gnucash ver 4.6, I investigated using SQLlite instead of
> the compressed XML for data storage.
> SQLite worked but the resultant file(s) were much larger than the XML
> compressed version so I decided to continue to use the compressed XML.
>
> From that date (August 24, 2021) to today I still get gnucash
> intermittently not removing the LOCK file.
> This includes ver4.7, ver4.8 and ver4.9. It may happen ver4.6 but unsure.
> Ever time I updated I hoped it would resolve the issue but it still happens.
> About 20 days ago I deleted the SQL subdirectory and files from my local
> data disk. This seemed to make no difference to the issue.
>
>
>
> On 19/01/2022 06:17, gnucash-user-request at gnucash.org wrote:
>> Send gnucash-user mailing list submissions to
>> gnucash-user at gnucash.org
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> or, via email, send a message with subject or body 'help' to
>> gnucash-user-request at gnucash.org
>>
>> You can reach the person managing the list at
>> gnucash-user-owner at gnucash.org
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnucash-user digest..."
>>
>> Today's Topics:
>>
>> 1. Re: Exiting GNUCash (D.)
>> 2. Re: Exiting GNUCash (David Carlson)
>> 3. OneDrive (menace at fastmail.fm)
>> 4. Re: gnucash-user Digest, Vol 226, Issue 48 (Heide Wang)
>> 5. Re: OneDrive and GnuCash (davidcousens49 at gmail.com)
>>
>> _______________________________________________
>>
>> gnucash-user mailing list
>> gnucash-user at 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.
>
> --
>
>
>
> ------------------------------
>
> Message: 4
> Date: Wed, 19 Jan 2022 00:32:22 -0600
> From: David Carlson <david.carlson.417 at gmail.com>
> To: Peter <pandem at iinet.net.au>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Exiting gnucash Lock file Vol 226, Issue 57
> Message-ID:
> <CADYgSbkzd3huEteFkLuHtnmGoLZS_Cy4g+7-DeF8ePPfopENPQ at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Peter,
>
> Your message has gotten detached from the thread..
>
> We need more information to hazard a guess whether your issue is the same
> as that of Gyle or if it is just similar.
>
> Do you save your data file on a hard drive? Do you encrypt it?
>
> Do you use cloud storage for backup?
>
> Do you use Windows or another OS?
>
> Can you think of any other commonality when the lock file is not deleted?
>
>
>
> On Tue, Jan 18, 2022, 11:05 PM Peter <pandem at iinet.net.au> wrote:
>
>> This is interesting.
>>
>> I have had this problem of gnucash intermittently not removing the LOCK
>> file for some time.
>> My method of closing gnucash is firstly to save the data and the close
>> using the menu. I always follow this process and never use the 'X' method.
>>
>> August 24, 2021 gnucash ver 4.6, I investigated using SQLlite instead of
>> the compressed XML for data storage.
>> SQLite worked but the resultant file(s) were much larger than the XML
>> compressed version so I decided to continue to use the compressed XML.
>>
>> From that date (August 24, 2021) to today I still get gnucash
>> intermittently not removing the LOCK file.
>> This includes ver4.7, ver4.8 and ver4.9. It may happen ver4.6 but unsure.
>> Ever time I updated I hoped it would resolve the issue but it still
>> happens.
>> About 20 days ago I deleted the SQL subdirectory and files from my local
>> data disk. This seemed to make no difference to the issue.
>>
>>
>>
>> On 19/01/2022 06:17, gnucash-user-request at gnucash.org wrote:
>>> Send gnucash-user mailing list submissions to
>>> gnucash-user at gnucash.org
>>>
>>> To subscribe or unsubscribe via the World Wide Web, visit
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> or, via email, send a message with subject or body 'help' to
>>> gnucash-user-request at gnucash.org
>>>
>>> You can reach the person managing the list at
>>> gnucash-user-owner at gnucash.org
>>>
>>> When replying, please edit your Subject line so it is more specific
>>> than "Re: Contents of gnucash-user digest..."
>>>
>>> Today's Topics:
>>>
>>> 1. Re: Exiting GNUCash (D.)
>>> 2. Re: Exiting GNUCash (David Carlson)
>>> 3. OneDrive (menace at fastmail.fm)
>>> 4. Re: gnucash-user Digest, Vol 226, Issue 48 (Heide Wang)
>>> 5. Re: OneDrive and GnuCash (davidcousens49 at gmail.com)
>>>
>>> _______________________________________________
>>>
>>> gnucash-user mailing list
>>> gnucash-user at 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 at 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.
>>
>
>
> ------------------------------
>
> Message: 5
> Date: Wed, 19 Jan 2022 09:20:51 -0000
> From: <jim at billinghurst.net>
> To: <gnucash-user at gnucash.org>
> Subject: Re: [GNC] OneDrive
> Message-ID: <002901d80d15$dacb71f0$906255d0$@billinghurst.net>
> Content-Type: text/plain; charset="us-ascii"
>
> I have been using One Drive for over a year for a local community business
> and had no problems.
> I also have another set of accounts for a charity that uses SharePoint to
> save the files, again no problems.
>
> Regards
>
> James Billinghurst
>
>
>
>
> Message: 3
> Date: Tue, 18 Jan 2022 15:59:35 -0600
> From: menace at fastmail.fm
> To: gnucash-user at gnucash.org
> Subject: [GNC] OneDrive
> Message-ID: <784a2c4f-cf86-47f6-9de9-4fe755413ab4 at www.fastmail.com>
> Content-Type: text/plain
>
> Hi, I began using GnuCash at the beginning of 2021. Since the onset, I've
> had it in a OneDrive folder. I've had no problems with it syncing between
> my computers.
>
> From: David Carlson <david.carlson.417 at gmail.com>
>
> Good. I would still like to hear from others about their experience with
> using GnuCash and OneDrive together.
>
>
> gnucash-user mailing list
> gnucash-user at 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.
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 226, Issue 57
> *********************************************
>
>
>
> ------------------------------
>
> Message: 6
> Date: Wed, 19 Jan 2022 10:13:35 +0000
> From: Chris Green <cl at isbd.net>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] OneDrive
> Message-ID: <YefkT/cqgRKOJEAr at esprimo>
> Content-Type: text/plain; charset=us-ascii
>
> On Wed, Jan 19, 2022 at 09:20:51AM -0000, jim at billinghurst.net wrote:
>> I have been using One Drive for over a year for a local community business
>> and had no problems.
>> I also have another set of accounts for a charity that uses SharePoint to
>> save the files, again no problems.
>>
> I simply use Syncthing to synchronise the GnuCash files between my
> laptop and my desktop machines, it works perfectly. Obviously I need
> to be sure I don't run GnuCash on both machines at the same time but
> that's not difficult. Systems don't have to be on the same network
> for Syncthing to work and it will re-synchronise after a total
> disconnection.
>
> It means I don't rely on 'the cloud' for any backups and everything is
> kept on hardware that's mine. Syncthing is available for MS, Apple,
> Linux and Android systems and can synchronise files across all of them
> if you want.
>
> I do keep (off site) incremental backups as well. You do need to be
> able to go back in time to recover from your own errors which GnuCash
> (or whatever) has faithfully saved for you! :-)
>
> --
> Chris Green
>
>
> ------------------------------
>
> Message: 7
> Date: Wed, 19 Jan 2022 20:45:56 +0800
> From: Peter <pandem at iinet.net.au>
> To: David Carlson <david.carlson.417 at gmail.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Exiting gnucash Lock file Vol 226, Issue 57
> Message-ID: <b1bad35d-f53f-8cd5-4ab2-e48c38079dcb at iinet.net.au>
> Content-Type: text/plain; charset="UTF-8"
>
> Oh dear,
> In the excitement of finding out that someone else possibly had the
> problem I forgot to add.
>>> Your message has gotten detached from the thread..
> NFI
>>> Do you save your data file on a hard drive? Do you encrypt it?
> Storage: Local disk separate from the OS drive. Has separate
> directory d:public\data\...........
> Storage method: XML and compressed
>>> Do you use Windows or another OS?
> OS: Windows 10 and kept up to date as per MS demands
> Version of gnucash: 4.6, 4.7, 4.8 and 4.9 all exhibit the problem.
>>> Do you use cloud storage for backup?
> NO defiantly NO
>>> Can you think of any other commonality when the lock file is not
> deleted?
> Whats common? - Started after a SQLite test gnu version 4.6 . SQL
> directory was set to be different to the XML directory.
> - since gnucash 4.9 that SQL directory has
> been deleted but issue still remains
>
> I follow the standard process of installing the newest version directly
> on top of the previous version. (Seems to be the standard process.)
> I have tried to uninstall the previous version but no different. I
> suspect that there is something that I cannot find or that are hidden
> that I cannot remove as I don't know where.
> It would be nice if the uninstall process did give the option of delete
> anything that was hidden from normal beings view. i.e do a clean
> install.
>
> On 19/01/2022 14:32, David Carlson wrote:
>
> Peter,
> Your message has gotten detached from the thread..
> We need more information to hazard a guess whether your issue is the
> same as that of Gyle or if it is just similar.
> Do you save your data file on a hard drive? Do you encrypt it?
> Do you use cloud storage for backup?
> Do you use Windows or another OS?
> Can you think of any other commonality when the lock file is not
> deleted?
>
> On Tue, Jan 18, 2022, 11:05 PM Peter <[1]pandem at iinet.net.au> wrote:
>
> This is interesting.
> I have had this problem of gnucash intermittently not removing the
> LOCK
> file for some time.
> My method of closing gnucash is firstly to save the data and the
> close
> using the menu. I always follow this process and never use the 'X'
> method.
> August 24, 2021 gnucash ver 4.6, I investigated using SQLlite
> instead of
> the compressed XML for data storage.
> SQLite worked but the resultant file(s) were much larger than the
> XML
> compressed version so I decided to continue to use the compressed
> XML.
> From that date (August 24, 2021) to today I still get gnucash
> intermittently not removing the LOCK file.
> This includes ver4.7, ver4.8 and ver4.9. It may happen ver4.6 but
> unsure.
> Ever time I updated I hoped it would resolve the issue but it still
> happens.
> About 20 days ago I deleted the SQL subdirectory and files from my
> local
> data disk. This seemed to make no difference to the issue.
> On 19/01/2022 06:17, [2]gnucash-user-request at gnucash.org wrote:
>> Send gnucash-user mailing list submissions to
>> [3]gnucash-user at gnucash.org
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>> [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> or, via email, send a message with subject or body 'help' to
>> [5]gnucash-user-request at gnucash.org
>>
>> You can reach the person managing the list at
>> [6]gnucash-user-owner at gnucash.org
>>
>> When replying, please edit your Subject line so it is more
> specific
>> than "Re: Contents of gnucash-user digest..."
>>
>> Today's Topics:
>>
>> 1. Re: Exiting GNUCash (D.)
>> 2. Re: Exiting GNUCash (David Carlson)
>> 3. OneDrive ([7]menace at fastmail.fm)
>> 4. Re: gnucash-user Digest, Vol 226, Issue 48 (Heide Wang)
>> 5. Re: OneDrive and GnuCash ([8]davidcousens49 at gmail.com)
>>
>> _______________________________________________
>>
>> gnucash-user mailing list
>> [9]gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> [10]https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
> [11]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
> [12]gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> [13]https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> [14]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.
>
> References
>
> 1. mailto:pandem at iinet.net.au
> 2. mailto:gnucash-user-request at gnucash.org
> 3. mailto:gnucash-user at gnucash.org
> 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 5. mailto:gnucash-user-request at gnucash.org
> 6. mailto:gnucash-user-owner at gnucash.org
> 7. mailto:menace at fastmail.fm
> 8. mailto:davidcousens49 at gmail.com
> 9. mailto:gnucash-user at gnucash.org
> 10. https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 11. https://wiki.gnucash.org/wiki/Mailing_Lists
> 12. mailto:gnucash-user at gnucash.org
> 13. https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 14. https://wiki.gnucash.org/wiki/Mailing_Lists
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
>
> gnucash-user mailing list
> gnucash-user at 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.
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 226, Issue 58
> *********************************************
More information about the gnucash-user
mailing list