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....@gnucash.org>  On 
Behalf ofgnucash-user-requ...@gnucash.org
Sent: Tuesday, June 28, 2022 9:00 AM
To:gnucash-user@gnucash.org
Subject: gnucash-user Digest, Vol 231, Issue 70

Send gnucash-user mailing list submissions to
        gnucash-user@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-requ...@gnucash.org

You can reach the person managing the list at
        gnucash-user-ow...@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"<scami...@fastmail.fm>
To: "David H"<hell...@gmail.com>
Cc: "Gnucash Users"<gnucash-user@gnucash.org>
Subject: Re: [GNC] Saved Reports
Message-ID:<35680993-2d87-4910-9673-1b00cadfa...@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<scami...@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<scami...@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@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....@gmail.com>
To: "Stephen C. Camidge"<scami...@fastmail.fm>
Cc: David H<hell...@gmail.com>, Gnucash Users
        <gnucash-user@gnucash.org>
Subject: Re: [GNC] Saved Reports
Message-ID:
        <cadygsbkn7g-avujk6g6wexyhjvguso78s35tm-ujgvkyrdk...@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<scami...@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
<scami...@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
<scami...@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@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.


------------------------------

Message: 3
Date: Tue, 28 Jun 2022 07:12:41 -0700
From: Fred Tydeman<tydeman.f...@gmail.com>
To: Gnucash Users<gnucash-user@gnucash.org>
Subject: Re: [GNC] Split ownership
Message-ID:
        <CAK1r+o0=-gU++cfnr=0jyx6uslfj0rjmoixvq1m7byu03rg...@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.f...@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.montele...@lusfiber.net>
To:gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Split ownership
Message-ID:<t9f2s1$158p$1...@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@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@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.

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

Reply via email to