[GNC] How to start fresh [was: Re: gnucash-user Digest, Vol 231, Issue 70]
list+gnucash at jdlh.com
list+gnucash at jdlh.com
Thu Jun 30 01:05:43 EDT 2022
Eric:
Welcome to the gnucash-users list!
On 2022-06-29 17:00, Eric Hammond wrote:
> Resending to proper group....
>
> I set up GnuCash as best possible by extracting what I could from my crashed Quicken, and many Excel spreadsheets. And 6 months of work.
> I got all the info in, but not working properly.
> I want to start fresh, almost.
> I have created clean CSV files for the AR and AP; and transaction files to fill in the bank ledgers.
> What I need is to clean GnuCash of everything Except the account tree, vendor and customer database.
> (Maybe I missed something, but the exported version of vendor and customer data has only name and ID number.)
>
> Any ideas on how to do this, or how to not need to do this are appreciated.
One approach is to not start fresh, but to incrementally converge on
your desired state. Remember, you can rename accounts, and rearrange
them in the hierarchy. All the transactions stay in the same account
even as the account name and hierarchy change around them. It might be
easier to improve in place than to start fresh.
One approach to consider is to take the GnuCash file you wish to
"clean", and export only what you want to save. Then create a new, empty
GnuCash file, and import the files with data you wanted to save. In
particular, I understand it is possible to export the account tree: see
the menu item File… Export… Export Accounts . As it says in the GnuCash
Help
<https://www.gnucash.org/docs/v4/C/gnucash-help/gui-acct-tree.html#AccTree-FileMenu>,
this "Exports your account hierarchy to a new *|GnuCash|*file. Does not
export data."
One approach to consider, and I only mention this because you mention
that you have programming experience, is to quit GnuCash, then
uncompress the .gnucash book file as XML, and edit the XML using XSLT
and the like. There are a few things that are practical to do directly
on the XML. For instance, I rearranged the paths to all my transaction
attachments this way. Just be aware that, because many entities are
identified by UUID, and there are many many cross-references from one
entity to another entity's UUID, there are many changes that are hard to
get right. You know, of course, the golden rules: 1. work on a copy of
your data, not the original, and 2. you survive by your own wits at this
level; the -user list cannot help you.
Another approach to consider is to recompile GnuCash with the Python
bindings included, then write Python code which calls GnuCash through
these bindings to make your changes.
Will some of these work for you?
Best regards,
—Jim DeLaHunt
P.S. I second what John Ralls said about starting a new topic with a new
message. And, be sure your message has an appropriate Subject: line.
They can be edited, as I have done here.
> Thanks,
> Eric
>
> -----Original Message-----
> From: gnucash-user<gnucash-user-bounces+eric=jehammond.net at gnucash.org> On Behalf Ofgnucash-user-request at gnucash.org
> Sent: Tuesday, June 28, 2022 9:00 AM
> To:gnucash-user at gnucash.org
> Subject: gnucash-user Digest, Vol 231, Issue 70
>
> 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: Saved Reports (Stephen C. Camidge)
> 2. Re: Saved Reports (David Carlson)
> 3. Re: Split ownership (Fred Tydeman)
> 4. Re: Split ownership (Adrien Monteleone)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 27 Jun 2022 20:54:20 -0400
> From: "Stephen C. Camidge"<scamidge at fastmail.fm>
> To: "David H"<hellvee at gmail.com>
> Cc: "Gnucash Users"<gnucash-user at gnucash.org>
> Subject: Re: [GNC] Saved Reports
> Message-ID:<35680993-2d87-4910-9673-1b00cadfaf4b at www.fastmail.com>
> Content-Type: text/plain
>
> Interesting. That location did work.
>
> Further, some data went to /home/steve/.var/app/org.gnucash.GnuCash/data/<http://org.gnucash.gnucash/data/>
>
> But /home/steve/.var/app/org.gnucash.GnuCash/data/gnucash/<http://org.gnucash.gnucash/data/gnucash/> is more complete.
>
> Thank you very much for your help.
> Steve
>
>
>
>
> On Mon, Jun 27, 2022, at 8:43 PM, David H wrote:
>> Just rebooted into Mint Linux and mine are in $HOME/.var/app/org.gnucash.GnuCash/data/gnucash - did you drill down far enough ? I seem to recall I would have manually copied my saved-reports-2.8 file into that directory as Flatpak obviously doesn't know about them initially...
>>
>> Cheers David H.
>>
>> On Tue, 28 Jun 2022 at 10:34, Stephen C. Camidge<scamidge at fastmail.fm> wrote:
>>> __
>>> Thank you, but I do not have any entries here:
>>> $HOME/.local/share/flatpak/app/org.gnucash.GnuCash/
>>>
>>> and the other is where I was looking, but the saved reports was not
>>> updated for 4.11 $HOME/.var/app/org.gnucash.GnuCash/
>>>
>>>
>>>
>>> On Mon, Jun 27, 2022, at 3:34 PM, David H wrote:
>>>> The wiki is your friend -https://wiki.gnucash.org/wiki/Flatpak
>>>>
>>>> Cheers David H.
>>>>
>>>>
>>>> On Tue, 28 Jun 2022 at 04:05, Stephen C. Camidge<scamidge at fastmail.fm> wrote:
>>>>> When using gnucash 4.10 installed from Linux Manjaro repository, my saved reports are stored here:
>>>>> /home/steve/.local/share/gnucash/
>>>>>
>>>>> I installed gnucash 4.11 from flathub and saved a newly created report. I cannot find where the report is stored on my hard drive. My plan was to move my old settings over to the flatbed version so I could properly test the latest version.
>>>>>
>>>>> How do I find where 4.11 is storing the preferences?
>>>>> _______________________________________________
>>>>> 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 seehttps://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: 2
> Date: Tue, 28 Jun 2022 06:48:50 -0500
> From: David Carlson<david.carlson.417 at gmail.com>
> To: "Stephen C. Camidge"<scamidge at fastmail.fm>
> Cc: David H<hellvee at gmail.com>, Gnucash Users
> <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Saved Reports
> Message-ID:
> <CADYgSbkn7G-avujk6g6WeXyHjVguso78s35TM-uJgVKyrdkasQ at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> For certain cases the migration to 4.11 has " lost " some information, this is a known issue . Check other messages for more information.
>
> On Mon, Jun 27, 2022, 7:55 PM Stephen C. Camidge<scamidge at fastmail.fm>
> wrote:
>
>> Interesting. That location did work.
>>
>> Further, some data went to
>> /home/steve/.var/app/org.gnucash.GnuCash/data/< http://org.gnucash.gnucash/data/>
>>
>> But /home/steve/.var/app/org.gnucash.GnuCash/data/gnucash/< http://org.gnucash.gnucash/data/gnucash/> is more complete.
>>
>> Thank you very much for your help.
>> Steve
>>
>>
>>
>>
>> On Mon, Jun 27, 2022, at 8:43 PM, David H wrote:
>>> Just rebooted into Mint Linux and mine are in
>> $HOME/.var/app/org.gnucash.GnuCash/data/gnucash - did you drill down
>> far enough ? I seem to recall I would have manually copied my
>> saved-reports-2.8 file into that directory as Flatpak obviously
>> doesn't know about them initially...
>>> Cheers David H.
>>>
>>> On Tue, 28 Jun 2022 at 10:34, Stephen C. Camidge
>>> <scamidge at fastmail.fm>
>> wrote:
>>>> __
>>>> Thank you, but I do not have any entries here:
>>>> $HOME/.local/share/flatpak/app/org.gnucash.GnuCash/
>>>>
>>>> and the other is where I was looking, but the saved reports was not
>> updated for 4.11
>>>> $HOME/.var/app/org.gnucash.GnuCash/
>>>>
>>>>
>>>>
>>>> On Mon, Jun 27, 2022, at 3:34 PM, David H wrote:
>>>>> The wiki is your friend -https://wiki.gnucash.org/wiki/Flatpak
>>>>>
>>>>> Cheers David H.
>>>>>
>>>>>
>>>>> On Tue, 28 Jun 2022 at 04:05, Stephen C. Camidge
>>>>> <scamidge at fastmail.fm>
>> wrote:
>>>>>> When using gnucash 4.10 installed from Linux Manjaro repository,
>>>>>> my
>> saved reports are stored here:
>>>>>> /home/steve/.local/share/gnucash/
>>>>>>
>>>>>> I installed gnucash 4.11 from flathub and saved a newly created
>> report. I cannot find where the report is stored on my hard drive. My
>> plan was to move my old settings over to the flatbed version so I
>> could properly test the latest version.
>>>>>> How do I find where 4.11 is storing the preferences?
>>>>>> _______________________________________________
>>>>>> 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: 3
> Date: Tue, 28 Jun 2022 07:12:41 -0700
> From: Fred Tydeman<tydeman.fred at gmail.com>
> To: Gnucash Users<gnucash-user at gnucash.org>
> Subject: Re: [GNC] Split ownership
> Message-ID:
> <CAK1r+o0=-gU++cfnr=0JYx6USLFj0rJMOixvq1M7byu03RGC_A at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> I see I was not clear in my description of the transactions.
>
> I wrote a check for the full price of a golf cart to a dealer.
> The next day, a friend gave me their half of the cost.
> Some years later, I sold the golf cart and I got the full selling price from the buyer.
> A few days later, I gave half of the selling price to my friend.
>
> I guess I could record the purchase as 1/2 to golf cart asset and 1/2 to short term loan to friend. And that loan is paid back the next day.
>
> And the same idea would be used for the sale.
>
> On Mon, Jun 27, 2022 at 4:01 PM Fred Tydeman<tydeman.fred at gmail.com> wrote:
>
>> A friend and I bought a golf cart, each paying 1/2 of the price.
>> Some years later, we sold that golf cart (for less than we paid,
>> splitting what we got).
>> How should all of that be recorded?
>>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 28 Jun 2022 09:22:55 -0500
> From: Adrien Monteleone<adrien.monteleone at lusfiber.net>
> To:gnucash-user at lists.gnucash.org
> Subject: Re: [GNC] Split ownership
> Message-ID:<t9f2s1$158p$1 at ciao.gmane.io>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> Sounds reasonable.
>
> You'd need a liability (or contra-asset) account to handle the parts of the transaction to facilitate owing and paying your friend.
>
> This is similar to the example in the Guide (or is it the Wiki) concerning shared household expenses or trip expenses between roommates/friends.
>
> Regards,
> Adrien
>
> On 6/28/22 9:12 AM, Fred Tydeman wrote:
>> I see I was not clear in my description of the transactions.
>>
>> I wrote a check for the full price of a golf cart to a dealer.
>> The next day, a friend gave me their half of the cost.
>> Some years later, I sold the golf cart and I got the full selling
>> price from the buyer.
>> A few days later, I gave half of the selling price to my friend.
>>
>> I guess I could record the purchase as 1/2 to golf cart asset and 1/2
>> to short term loan to friend. And that loan is paid back the next
>> day.
>>
>> And the same idea would be used for the sale.
>
>
> ------------------------------
>
> 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 seehttps://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 231, Issue 70
> *********************************************
> _______________________________________________
> 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 seehttps://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.
>
More information about the gnucash-user
mailing list