[GNC] New computer to set up gnucash and migrate from old.
Bruce Irving
eaglebruce2003 at yahoo.com
Mon Jun 17 18:20:25 EDT 2019
I was running GC 2.6.19 on to win10 PCs. The hard drive started to fail and the shop was able to save the files before replacing the drive and installing Win10 one the new one. Since I have two clubs plus my own files, I've always started by double-clicking the data file which was located in a folder called qnucash where my other files for this entity was located. Then I installed GC (I believe 3.?) and copied the file that ended with .gnucash to the appropriate folder and double clicked to start it. Of course, I had to set GC up the way I wanted but it had all of my transactions.
Unfortunately, it wasn't until later that I discovered that the configuration files:
09/30/2018 05:04 PM <DIR> .
09/30/2018 05:04 PM <DIR> ..
06/12/2019 05:43 AM 21,415 accelerator-map
12/26/2018 01:13 PM <DIR> books
02/09/2018 06:59 PM <DIR> checks
06/12/2019 05:43 AM 0 expressions-2.0
05/20/2019 10:03 AM 13,241 saved-reports-2.4
05/20/2019 10:03 AM 13,225 saved-reports-2.4-backup
06/12/2019 05:43 AM 1,345 stylesheets-2.0
02/09/2018 06:59 PM <DIR> translog
5 File(s) 49,226 byteslocated in C:\users/[user name].Hope this helps.Oh! My compliments to the developers. The new version corrects a couple of issues that the old one had. Thanks.
Bruce Preach the Gospel wherever you go. If necessary, use words.
From: Randy Rosebrock <rhrosebr at gmail.com>
To: stepbystepfarm at comcast.net
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] New computer to set up gnucash and migrate from
old.
Message-ID:
<CA+iQKJkVtBrMCBYwQRuAKZZ0W=hzTKNscapVPq-crUUmLEwKMQ at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Under normal default install where are these files location I need to copy
from?
On Mon, Jun 17, 2019 at 8:49 AM Mike or Penny Novack <
stepbystepfarm at comcast.net> wrote:
> On 6/16/2019 5:41 PM, Adrien Monteleone wrote:
> > Randy,
> >
> > If the old computer still runs at all, you can network them together and
> use the Windows User Migration feature. (not certain of the exact name, but
> that term should get you close in a search engine) It will move all of your
> data and settings as part of your user account. (you get to fine tune what
> it migrates as well)
> >
> > Regards,
> > Adrien
> >
> << I often leave things out >>
>
> I did not describe this for the simple reason that even if you do not
> make regular backups THIS is a situation where you would want a full
> backup. In other words, when migrating to a new computer you would
> almost always want to copy ALL your user data to an external device
> (your external backup drive) and then you would copy from that to where
> user data goes on your new computer.
>
> Michael D Novack
> _______________________________________________
> 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.
>
--
Randy
----- Forwarded Message ----- From: gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org>To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>Sent: Monday, June 17, 2019, 1:56:41 PM MDTSubject: gnucash-user Digest, Vol 195, Issue 26
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: Switch to Account that a Transfer is from by Keyboard
(Fred Bone)
2. Re: CSV to QIF for Citibank (Greg Feneis)
3. Re: New computer to set up gnucash and migrate from old.
(Randy Rosebrock)
4. Re: CSV to QIF for Citibank (Michael DeBusk)
5. Re: CSV to QIF for Citibank (Stephen M. Butler)
6. Re: CSV to QIF for Citibank (Greg Feneis)
7. Re: New computer to set up gnucash and migrate from old.
(Mike or Penny Novack)
8. Re: CSV to QIF for Citibank (Michael DeBusk)
9. Re: CSV to QIF for Citibank (Michael DeBusk)
10. Re: New computer to set up gnucash and migrate from old.
(Randy Rosebrock)
11. Re: Could a new report be added (Adrien Monteleone)
12. Re: Switch to Account that a Transfer is from by Keyboard
(Adrien Monteleone)
----------------------------------------------------------------------
Message: 1
Date: Mon, 17 Jun 2019 17:21:23 +0100
From: "Fred Bone" <Fred.Bone at dial.pipex.com>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Switch to Account that a Transfer is from by
Keyboard
Message-ID: <5D07BE03.861.18BD32C4 at Fred.Bone.dial.pipex.com>
Content-Type: text/plain; charset=US-ASCII
On 17 June 2019 at 9:27, David Carlson said:
> I thought there was already a keyboard shortcut for that. In Windows
> release 2.6.19, the letter *J* is underlined in the word *J*ump in the
> *A*ctions menu, which is supposed to indicate a keyboard shortcut.
> However, when I tried it today, I couldn't make it work.
Works fine for me in 2.6.21 on Windows10.
------------------------------
Message: 2
Date: Mon, 17 Jun 2019 09:46:47 -0700
From: Greg Feneis <mfeneis at gmail.com>
To: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] CSV to QIF for Citibank
Message-ID:
<CAJdmZ-X-98gJBhKfCeMKO0KZqBy=q99ShQQ5uemHpFpEJJUA0g at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Is it too late to download the records of interest in QFX or OFX format?
GnuCash will import these formats as well.
Kind regards, Greg Feneis
(Pixel 3)
On Mon, Jun 17, 2019, 06:51 Michael DeBusk <mdebusk at gmail.com> wrote:
> On Mon, Jun 17, 2019, 09:39 Kenneth Marshall <ktm at rice.edu> wrote:
>
> I think you need to subscribe to their business service to get anything
> > other than the CSV file type. Please correct me if I am mistaken because
> > that would be great news.
> >
>
> I don't subscribe to their business service, and I'm offered multiple file
> formats. Perhaps it's because I'm using their Costco card.
> _______________________________________________
> 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: Mon, 17 Jun 2019 12:58:38 -0400
From: Randy Rosebrock <rhrosebr at gmail.com>
To: stepbystepfarm at comcast.net
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] New computer to set up gnucash and migrate from
old.
Message-ID:
<CA+iQKJkVtBrMCBYwQRuAKZZ0W=hzTKNscapVPq-crUUmLEwKMQ at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Under normal default install where are these files location I need to copy
from?
On Mon, Jun 17, 2019 at 8:49 AM Mike or Penny Novack <
stepbystepfarm at comcast.net> wrote:
> On 6/16/2019 5:41 PM, Adrien Monteleone wrote:
> > Randy,
> >
> > If the old computer still runs at all, you can network them together and
> use the Windows User Migration feature. (not certain of the exact name, but
> that term should get you close in a search engine) It will move all of your
> data and settings as part of your user account. (you get to fine tune what
> it migrates as well)
> >
> > Regards,
> > Adrien
> >
> << I often leave things out >>
>
> I did not describe this for the simple reason that even if you do not
> make regular backups THIS is a situation where you would want a full
> backup. In other words, when migrating to a new computer you would
> almost always want to copy ALL your user data to an external device
> (your external backup drive) and then you would copy from that to where
> user data goes on your new computer.
>
> Michael D Novack
> _______________________________________________
> 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.
>
--
Randy
------------------------------
Message: 4
Date: Mon, 17 Jun 2019 13:09:52 -0400
From: Michael DeBusk <mdebusk at gmail.com>
To: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] CSV to QIF for Citibank
Message-ID:
<CAMr=pcfP3eQoD+=L5RgZ=9-pOC731z0-bHa4HC83ZZoE52hvnw at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
On Mon, Jun 17, 2019 at 12:49 PM Greg Feneis <mfeneis at gmail.com> wrote:
> Is it too late to download the records of interest in QFX or OFX format?
> GnuCash will import these formats as well.
>
It's not too late, but I never learned to appreciate QFX or OFX.
--
Home: http://nlphilia.com * Blog: http://nlphilia.net
Registered Linux User #450983 * Ubuntu Counter Project #10548
------------------------------
Message: 5
Date: Mon, 17 Jun 2019 10:39:43 -0700
From: "Stephen M. Butler" <kg7je at arrl.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] CSV to QIF for Citibank
Message-ID: <65842945-d297-bc61-6347-a9c0eddfd5ad at gmail.com>
Content-Type: text/plain; charset=utf-8
On 6/17/19 6:48 AM, Michael DeBusk wrote:
> On Mon, Jun 17, 2019, 09:39 Kenneth Marshall <ktm at rice.edu> wrote:
>
> I think you need to subscribe to their business service to get anything
>> other than the CSV file type. Please correct me if I am mistaken because
>> that would be great news.
>>
> I don't subscribe to their business service, and I'm offered multiple file
> formats. Perhaps it's because I'm using their Costco card.
I use their Costco card and only get CSV and TXT (tab delimited).
--
Stephen M Butler, PMP, PSM
Stephen.M.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
------------------------------
Message: 6
Date: Mon, 17 Jun 2019 10:52:12 -0700
From: Greg Feneis <mfeneis at gmail.com>
To: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] CSV to QIF for Citibank
Message-ID:
<CAJdmZ-UNo=5tQBd_KyMFYr4-y5zYXcJoi3Jn3RhBum62N82USA at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
With no rational explanation, over the years I have tended to favor OFX
(perhaps because it's an open standard), and QFX (I think QuickBooks'
proprietary variation on OFX, because I used to use QuickBooks?) Anyway,
QFX and OFX is what I've been importing into GnuCash for the last several
years.
But I do enjoy a good challenge now and then, so I can also understand the
desire to write a file conversion script.
Kind regards, Greg Feneis
(Pixel 3)
On Mon, Jun 17, 2019, 10:13 Michael DeBusk <mdebusk at gmail.com> wrote:
> On Mon, Jun 17, 2019 at 12:49 PM Greg Feneis <mfeneis at gmail.com> wrote:
>
> > Is it too late to download the records of interest in QFX or OFX format?
> > GnuCash will import these formats as well.
> >
>
> It's not too late, but I never learned to appreciate QFX or OFX.
> --
> Home: http://nlphilia.com * Blog: http://nlphilia.net
> Registered Linux User #450983 * Ubuntu Counter Project #10548
> _______________________________________________
> 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: 7
Date: Mon, 17 Jun 2019 13:55:41 -0400
From: Mike or Penny Novack <stepbystepfarm at comcast.net>
To: Randy Rosebrock <rhrosebr at gmail.com>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] New computer to set up gnucash and migrate from
old.
Message-ID: <c328df83-212e-a1e3-d5a4-cc29cb1b2f50 at comcast.net>
Content-Type: text/plain; charset=utf-8; format=flowed
On 6/17/2019 12:58 PM, Randy Rosebrock wrote:
> Under normal default install where are these files location I need to
> copy from?
>
> On Mon, Jun 17, 2019 at 8:49 AM Mike or Penny Novack
> <stepbystepfarm at comcast.net <mailto:stepbystepfarm at comcast.net>> wrote:
Since you did not tell us the operating system of the old computer (and
I do not know for Windows 10) I can't tell you where your user data lives.
Pretty much all modern operating systems (last decade or two) support
multiple users (multiple SEQUENTIAL users) and each would have his or
her own data area. Probably something like ..../users/username/
(that's the name you log in as) So if you are doing a full data backup
for a user, that is the directory (aka "file folder") you would copy
into something like ../backups/backup20190617 on your backup drive (say
a large USB drive)
You DO make backups? On some regular basis? Yes? << remember, it is
not IF a computer will fail but WHEN? >>
Michael D Novack
------------------------------
Message: 8
Date: Mon, 17 Jun 2019 14:09:13 -0400
From: Michael DeBusk <mdebusk at gmail.com>
To: Gnucash userlist <gnucash-user at gnucash.org>
Cc: "Stephen M. Butler" <kg7je at arrl.net>
Subject: Re: [GNC] CSV to QIF for Citibank
Message-ID:
<CAMr=pce4tPZE-oCrjdg2_+qWz+GiiGmo77TYgWWxtMWWNmLpOg at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
On Mon, Jun 17, 2019 at 1:46 PM Stephen M. Butler via gnucash-user <
gnucash-user at gnucash.org> wrote:
> I use their Costco card and only get CSV and TXT (tab delimited).
Perhaps a call to customer service would be to your advantage.
--
Home: http://nlphilia.com * Blog: http://nlphilia.net
Registered Linux User #450983 * Ubuntu Counter Project #10548
------------------------------
Message: 9
Date: Mon, 17 Jun 2019 14:12:33 -0400
From: Michael DeBusk <mdebusk at gmail.com>
To: Greg Feneis <mfeneis at gmail.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] CSV to QIF for Citibank
Message-ID:
<CAMr=pcdqANU9maiK-79xprOi73J7KgtF0e=YduS5H+byALw=Jg at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
On Mon, Jun 17, 2019 at 1:55 PM Greg Feneis <mfeneis at gmail.com> wrote:
> With no rational explanation, over the years I have tended to favor OFX
> (perhaps because it's an open standard), and QFX (I think QuickBooks'
> proprietary variation on OFX, because I used to use QuickBooks?) Anyway,
> QFX and OFX is what I've been importing into GnuCash for the last several
> years.
>
I've tried to figure out OFX and found it too complicated. I don't know how
to edit it.
--
Home: http://nlphilia.com * Blog: http://nlphilia.net
Registered Linux User #450983 * Ubuntu Counter Project #10548
------------------------------
Message: 10
Date: Mon, 17 Jun 2019 15:03:49 -0400
From: Randy Rosebrock <rhrosebr at gmail.com>
To: stepbystepfarm at comcast.net
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] New computer to set up gnucash and migrate from
old.
Message-ID:
<CA+iQKJkrbGQKYgPjxj8jswW1wKRO5OY_Jp+MHafCrAaqu4qgsA at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Sorry, win 10, it appears somehow when I initially setup gnucash I named
the company and told it to store the files in a directory called LLC. I've
installed the latest version on new pc (did a comparison on new pc and it
matchs the old pc dates and sizes) . copied the LLC folder to new pc. So
how do I tell GNU to use the files in LLC folders?
Randy
On Mon, Jun 17, 2019 at 1:55 PM Mike or Penny Novack <
stepbystepfarm at comcast.net> wrote:
> On 6/17/2019 12:58 PM, Randy Rosebrock wrote:
>
> Under normal default install where are these files location I need to copy
> from?
>
> On Mon, Jun 17, 2019 at 8:49 AM Mike or Penny Novack <
> stepbystepfarm at comcast.net> wrote:
>
>
> Since you did not tell us the operating system of the old computer (and I
> do not know for Windows 10) I can't tell you where your user data lives.
>
> Pretty much all modern operating systems (last decade or two) support
> multiple users (multiple SEQUENTIAL users) and each would have his or her
> own data area. Probably something like ..../users/username/ (that's the
> name you log in as) So if you are doing a full data backup for a user,
> that is the directory (aka "file folder") you would copy into something
> like ../backups/backup20190617 on your backup drive (say a large USB drive)
>
> You DO make backups? On some regular basis? Yes? << remember, it is not
> IF a computer will fail but WHEN? >>
>
> Michael D Novack
>
--
Randy
------------------------------
Message: 11
Date: Mon, 17 Jun 2019 14:27:06 -0500
From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
To: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Could a new report be added
Message-ID: <9EA50858-CFDD-48F4-9139-3D0610BA014A at lusfiber.net>
Content-Type: text/plain; charset=utf-8
That would be an ideal report and there have been many requests for it on this list over the years. (I was one of those) I think something like this is in the works and might even be available for further testing in the next release. (If I remember the thread correctly)
For now, you can use the Budget Report and simply not show the budget amounts, just show the actuals. You can even get your YTD column as the ?Totals? column if you like.
You can then export this to a spreadsheet for further manipulation and formatting as desired.
Alternatively, you can run each period separately and export to a spreadsheet and then combine them. If you choose to always show all accounts, even those with a zero balance so that the rows match, you can pull in the individual periods and have the ?master report? on its own sheet tab that simply is a set of references to the individual period reports that are in their own sheets. It would of course take some time to set up but then would be a fairly quick process after that. (you can also set up a single period on your master report with the cell references, then ?fill? across to the next 11 columns. Some spreadsheet apps are smart enough to update the relative references. Others, you simply select each column at a time and do a Find/Replace on the referenced sheet name.)
Regards,
Adrien
> On Jun 17, 2019, at 10:32 AM, Jimmy R via gnucash-user <gnucash-user at gnucash.org> wrote:
>
> Sorry for posting her, I tried Dev but never showed up
>
> A yearly report selectable by year or range of the year
> 13 columns 1 for accounts and 12 for Jan thru Dec
>
> Be able to export to csv
>
> I know there is a basic layout is in budgets but we don't need the budget
> amounts
>
> No graphics needed we can use Libreoffice or Excell if we need it
>
> No grand totals needed can be done in Libreoffice or Excell
>
> Thank You
------------------------------
Message: 12
Date: Mon, 17 Jun 2019 14:54:12 -0500
From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
To: gnucash-user <gnucash-user at gnucash.org>
Subject: Re: [GNC] Switch to Account that a Transfer is from by
Keyboard
Message-ID: <4A9A2FC5-40D2-411A-A7C3-60FDE306D50E at lusfiber.net>
Content-Type: text/plain; charset=utf-8
David,
The underlines you are referring to are called mnemonics. They are not visible by default. Once you press the activator key (`Alt` on Windows/Linux `Command` on Mac) you will see them. On Mac, I noticed the menu does not redraw while being displayed, so I had to click elsewhere to close the menu and then right-click again, and the underlines were then visible.
This is a shame because it makes them less discoverable.
Note, I don?t see any mnemonics in the main menus, probably because most of those entries have their own accelerators. (which are faster to use than opening a menu and then using a mnemonic)
Here is some more info: https://wiki.gnucash.org/wiki/GTK3#Restoring_Visible_Mnenomics
I just did a search of the Help file and I do not see any documentation on the context menu or any mnemonics.
Regards,
Adrien
> On Jun 17, 2019, at 9:27 AM, David Carlson <david.carlson.417 at gmail.com> wrote:
>
> I thought there was already a keyboard shortcut for that. In Windows
> release 2.6.19, the letter *J* is underlined in the word *J*ump in the
> *A*ctions
> menu, which is supposed to indicate a keyboard shortcut. However, when I
> tried it today, I couldn't make it work. If it is broken, a bug report
> should be filed. I could not find the proper list of shortcuts in the
> documentaation to see if it is documented.
>
> Curiously, in GnuCash 2.6.19 in Ubuntu 18.04, there are no underlines in
> the menus at all.
>
> David Carlson
>
------------------------------
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 195, Issue 26
*********************************************
More information about the gnucash-user
mailing list