Re: [GNC] Transferring data from one set of books to another

2023-04-18 Thread Rich Shepard
On Tue, 18 Apr 2023, david whiting wrote: Ah, I sent this before I saw your other reply that got separated from this thread. David, No harm done. The SQLite info is useful. Regards, Rich ___ gnucash-user mailing list gnucash-user@gnucash.org To up

Re: [GNC] Transferring data from one set of books to another

2023-04-18 Thread Rich Shepard
On Tue, 18 Apr 2023, david whiting wrote: One way you can do this is to save your gnucash file in sqlite format (if you don't use that already)... David, I've been using SQLite for a very long time so I can easily work with single tables. Now, I'm using the default database. It won't be in

Re: [GNC] Transferring data from one set of books to another

2023-04-18 Thread david whiting
Ah, I sent this before I saw your other reply that got separated from this thread. David On Tue, 18 Apr 2023 at 20:17, david whiting wrote: > You can import customers as csv file, so you just need to get a way of > exporting customers. One way you can do this is to save your gnucash file > in s

Re: [GNC] Transferring data from one set of books to another

2023-04-18 Thread david whiting
You can import customers as csv file, so you just need to get a way of exporting customers. One way you can do this is to save your gnucash file in sqlite format (if you don't use that already) and then open the file in something like sqlitebrowser https://sqlitebrowser.org/ Here you can view the c

Re: [GNC] Transferring data from one set of books to another [RESOLVED]

2023-04-18 Thread Rich Shepard
On Tue, 18 Apr 2023, Rich Shepard wrote: I have two sets of books: business and personal; still running gnucash-3.11 on my Slackware64-14.2 desktop; it does all I need it to do. I updated my customer list in the personal book rather than the busienss book by mistake. Is there a way for me to tra

Re: [GNC] Transferring data from one set of books to another

2023-04-18 Thread Rich Shepard
On Tue, 18 Apr 2023, Gyle McCollam wrote: I don't know if it is possible, but have you checked out whether you can export this information? Then you can import into your business system. I don't use for business, but it seems like you should be able to do this. Gyle, Not according to the gnuc

Re: [GNC] Transferring data from one set of books to another

2023-04-18 Thread Gyle McCollam
.@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of Rich Shepard Sent: Tuesday, April 18, 2023 10:46 AM To: gnucash-user@gnucash.org Subject: [GNC] Transferring data from one set of books to another I have two sets of boo

[GNC] Transferring data from one set of books to another

2023-04-18 Thread Rich Shepard
I have two sets of books: business and personal; still running gnucash-3.11 on my Slackware64-14.2 desktop; it does all I need it to do. I updated my customer list in the personal book rather than the busienss book by mistake. Is there a way for me to transform those data from person to business w