Re: [GNC] Accounting for a pre-paid electronic toll card
Thank you all for the information that has cleared my brain fog. :-) On Tue, Oct 18, 2022 at 11:26 PM Fred Bone wrote: > On 18 October 2022 at 22:54, Tony Vanson said: > > > I'm hoping that someone on this list can aid my befuddled brain to get to > > grips with my problem. The tolling system here is not the automated ones > > I'm used to. Here one needs to obtain an electronic card and, once done, > > must be charged with a cash value prior to travelling and topped up with > > cash on a regular basis. My question is what category is this card and > how > > do I treat additions and subtractions from it? I initially thought it > > might be treated as a credit card but the way it operates it's obviously > > not. Any advice would be much appreciated *Tony Vanson* > > I have > Assets:Current Assets:Prepaid:Dart-Charge > to which I move funds from (usually) a credit card > and from which I subtract the charges as I incur them. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- *Tony Vanson* *The older I get,* *the better I was* ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
Hi all, I’m running Windows 11. I was running Gnucash 2.3.4 for years and finally decided to upgrade to the latest stable release of 4.12 so I can export to a spreadsheet. The setup needed to uninstall 2.3.4 which went fine and then 4.12 finished installing. I opened Gnucash 4.12 and opened my Gnucash database. It notified me I needed to upgrade the database to the new version which worked fine and I was able to access all my data. I made a few entries and closed Gnucash without any issues. Later I opened Gnucash again but this time it didn’t auto open the database and I'm left with a blank screen. I proceed to locate and open the database but after waiting for it to load, nothing appears. I try to load it manually in other ways but eventually Gnucash crashes. If it helps, the database is 30MB in size. Please help. I have 13 years of data here. Thanks for looking! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
First, you need to locate your last backup before your upgrade. As has been described here before, you need to start in the FAQ at 3.5 ( https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade) and read the precautions. Depending on your specific data it is usually a good idea to go through the intermediate major versions and run check and repair at each step, keeping backups at each step. In some cases that can take a very long time (hours) and GnuCash may appear to be frozen when it is still cranking, so it behooves you to use a task manager to verify that it is still working before concluding that it is stuck. There is more specific information somewhere else but I don't recall where it is. Perhaps another user remembers where the more detailed instructions reside. Good luck! On Wed, Oct 19, 2022 at 7:12 AM Rosepetals wrote: > Hi all, > > I’m running Windows 11. > > I was running Gnucash 2.3.4 for years and finally decided to upgrade to the > latest stable release of 4.12 so I can export to a spreadsheet. > > The setup needed to uninstall 2.3.4 which went fine and then 4.12 finished > installing. > > I opened Gnucash 4.12 and opened my Gnucash database. It notified me I > needed to upgrade the database to the new version which worked fine and I > was able to access all my data. I made a few entries and closed Gnucash > without any issues. > > Later I opened Gnucash again but this time it didn’t auto open the database > and I'm left with a blank screen. I proceed to locate and open the database > but after waiting for it to load, nothing appears. I try to load it > manually in other ways but eventually Gnucash crashes. > > If it helps, the database is 30MB in size. > > Please help. I have 13 years of data here. > > Thanks for looking! > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] CSV transaction import settings
Geoff,
I finally found time to fire up the other computer that has the CSV import
settings for that data file and the needed GCM file. I didn't want the
rest of the settings copied to the other computer, so I just copied out the
three import configurations and pasted them into the GCM in the other
computer. Then I found them when I tried to import CSV files from those
financial institutions.
Again, thanks for your help.
On Thu, Oct 6, 2022 at 7:28 PM Geoff wrote:
> Hi David
>
> On Windows 10**, there is a directory called:
>
> C:\Users\{YOUR_NAME}\AppData\Roaming\GnuCash\books\
>
> Which contains a file for each set of books called:
>
> {BOOK_NAME}.gnucash.gcm
>
> In that file, there are, inter alia, sections for your saved CSV Import
> configurations that look like this:
>
> [Import csv,transaction - {BLAH BLAH}]
> Name={BLAH BLAH}
> SkipStartLines=1
> SkipEndLines=0
> SkipAltLines=false
> CsvFormat=true
> Separators=,
> DateFormat=1
> CurrencyFormat=0
> Encoding=UTF-8
> MultiSplit=true
> ColumnTypes=Date;Num;Description;Transaction
> Commodity;Action;Account;Deposit;Price;
>
>
> ** So, on Linux you will need to find that file using something like this:
>
> sudo find / -name {BOOK_NAME}.gnucash.gcm -print
>
>
> Hope this helps.
>
> Regards
>
> Geoff
> =
>
> On 7/10/2022 12:49 am, David Carlson wrote:
> > Where are the settings stored? I thought I copied all the GnuCash stuff
> > from one computer to another Ubuntu machine. I got my memorized reports
> > but not the CSV Transactions import settings.
> >
>
--
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
Indeed, if you were truly running 2.3.4, you'll need to step to a 2.4.x version, then a 2.6.x version, then 3.x, then 4.12, running Actions > Check & Repair > Check & Repair All when first opening the file after each upgrade, and of course ideally, keeping backup versions each step along the way in case something goes wrong and you have to take a step back rather than starting over from the original file. Regards, Adrien On 10/19/22 7:55 AM, David Carlson wrote: First, you need to locate your last backup before your upgrade. As has been described here before, you need to start in the FAQ at 3.5 ( https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade) and read the precautions. Depending on your specific data it is usually a good idea to go through the intermediate major versions and run check and repair at each step, keeping backups at each step. In some cases that can take a very long time (hours) and GnuCash may appear to be frozen when it is still cranking, so it behooves you to use a task manager to verify that it is still working before concluding that it is stuck. There is more specific information somewhere else but I don't recall where it is. Perhaps another user remembers where the more detailed instructions reside. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement request: multi-currency accounts
I use Sterling and Euros but like to know what the total Sterling value of
all accounts is.
I have the nominals set up in the two currencies, like has been explained
in others posts: 'Food£', 'Food€' etc.,
and have set up in the 'Price Database' Sterling and Euro securities as
'Currencies', which converts the Euros to Sterling,and this shows up in a
separate column ('Total GPB' in this case),
and also in the P&L and BS reports the Euro amounts and converted to
Sterling amounts also show. I don't know if this is the way the Price
Database should be used, but it works for me.
On Wed, 19 Oct 2022 at 01:45, R Losey wrote:
> For me, since my salary, bank, and credit cards are in USD, even when I
> spend EUR or CAN or AUS, I normally wait until the credit card expense
> shows up in USD and enter the USD value. Often, I will put the actual
> local expense on the 2nd line (I don't remember if that is called
> Description or Memo in Gnucash).
>
> I said that to say that I think the proposal would generally be useful only
> if you actually have bank accounts, credit cards in multiple currencies.
>
>
> On Tue, Oct 18, 2022 at 4:19 PM David Carlson >
> wrote:
>
> > This is interesting and it might be an optional configuration for the
> > automatic account creation wizard, but not for most users who use a
> single
> > currency in their accounting. Also, this is not the usual place to
> propose
> > enhancements, but it would be a good place to refine a concept prior to
> > making an actual proposal.
> >
> > What do others think?
> >
> > On Tue, Oct 18, 2022 at 3:54 PM Anton Tsyganenko <
> > anton-tsygane...@yandex.ru>
> > wrote:
> >
> > > Let's take a look on accounts that are created in gnucash by default.
> > > Generally most of the accounts may be multi-currency, i. e. not bond to
> > > a specific currency: you may have cash in multiple currencies, your
> > > opening balances may be in multiple currencies, you may have incomes
> and
> > > expenses in multiple currencies. Bank accounts generally have only one
> > > currency, but there are some banks that offer multi-currency cards and
> > > deposits. These surely can be considered as just a few different
> > > accounts, but it may be more convenient to group them together.Now I
> > > solve that by creating sub-accounts for each currency I need for each
> > > account where I need it. It looks like:
> > > Expenses:Dining:USD
> > > Expenses:Dining:EUR
> > > Expenses:Dining:CAD
> > > Expenses:Transport:USD
> > > Expenses:Transport:EUR
> > > Expenses:Transport:CAD
> > >
> > > It's very painful to create all of them. I know that I may have only
> one
> > > account in my _main_ currency, but I prefer all currencies to be equal
> > > and not perform redundant currency conversions, for example when I
> spend
> > > CAD cash for dining in Canada.
> > >
> > > So my proposal is:
> > >
> > > All accounts that user creates are "multi-currency", like placeholder
> > > accounts without any specific currency. Sub-accounts for each currency
> > > are created automatically, when the first operation in this currency in
> > > this account is made. If a multi-currency account is deleted and
> > > operations are moved to another account, operations in all the
> > > subaccounts are moved to the corresponding subaccounts of the second
> > > account. Balances can be shown as a sum of (non-null) amounts in
> > > different currencies (but sometimes can be converted to one currency).
> > > In a multi-currency account's view (basic ledger) there should be just
> > > an additional column -- currency of an operation (editable as a
> > > drop-down menu). So user opens account "cash" and sees something like:
> > >
> > > Date | Description | Transfer | Debit | Credit | Currency | Balance
> > >
> > > 2022-10-18 | Dinner in a restaurant | Expenses:Dining | | 25 | EUR |
> 100
> > > USD + 55 EUR
> > >
> > > That operation is a transfer of 25 EUR from Assets:Cash:EUR to
> > > Expenses:Dining:EUR.
> > >
> > > I would be happy to discuss the concept.
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > >
> >
> >
> > --
> > David Carlson
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
Thank you both for your advice. I don’t have a backup of the 2.3.4 database. Is there a way to recover data from the current 4.12 database? Also why does Gnucash work fine after the database upgrade but then develop a fault afterwards? Thank you On Thu, 20 Oct 2022 at 2:28 am, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Indeed, if you were truly running 2.3.4, you'll need to step to a 2.4.x > version, then a 2.6.x version, then 3.x, then 4.12, running Actions > > Check & Repair > Check & Repair All when first opening the file after > each upgrade, and of course ideally, keeping backup versions each step > along the way in case something goes wrong and you have to take a step > back rather than starting over from the original file. > > Regards, > Adrien > > On 10/19/22 7:55 AM, David Carlson wrote: > > First, you need to locate your last backup before your upgrade. As has > > been described here before, you need to start in the FAQ at 3.5 ( > > > https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade > ) > > and read the precautions. Depending on your specific data it is usually > a > > good idea to go through the intermediate major versions and run check and > > repair at each step, keeping backups at each step. In some cases that > can > > take a very long time (hours) and GnuCash may appear to be frozen when it > > is still cranking, so it behooves you to use a task manager to verify > that > > it is still working before concluding that it is stuck. There is more > > specific information somewhere else but I don't recall where it is. > > Perhaps another user remembers where the more detailed instructions > reside. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
As Adrien pointed out anytime you do an upgrade of GNuCash you should ALWAYS make a backup copy of the data file before starting the upgrade and keep it at least until everything is working. It is a good practice to regularly make a backup copy of your data file in any case, preferrably to another computer, network storage or a cloud (online) storage, usb stick etc. If you have problems then you can always copy (not move) the file from your backup to your data directory and start again. Are you using the xml file (a text file) or an actual database backend? The datafile format sometimes has to be changed to accomodate new features and fix some bugs. If such changes occur it is usually when changing from the last version of a major series to the first version of the next. Version 4.x will assume that the file has already been upgraded from version 2 to version 3. Each new major version of GnuCash includes a procedure for updating the datafile the first time it is run with a higher version. As well as changes in the datafile itself, there are sometimes changes in the locations where stored reports and user preference data etc are located. These are usually translated by the installation procedure for the first install of a higher major version (2->3->4). The locations are also different on different operating systems.https://wiki.gnucash.org/wiki/Configuration_Locations has details of the locations for various versions on Linux/Windows/Mac. The page can be hard to read but there are some diagrams accessed form links about halfway down the page Not sure how you can recover without a backup of the original file. With a 30Mb file it may take some time to convert the datafile at startup. GnuCash will be unresponsive while this is taking place so don't assume it has stopped/crashed - use the task manager (https://www.howtogeek.com/405806/windows-task-manager-the-complete-guide/) to check that it is no longer runnning as Adrien suggested and if so let it run to completion or until it actually crashes. If GnuCash is actually crashing, i.e. it stops running completely, then generating a trace file and stack trace file as described in https://wiki.gnucash.org/wiki/Tracefile and posting them here may help in working out if your file can be fixed and how. If you can get your datafile to open, before doing anything else run the Actions->Check & Repair->All transactions from the menu. Hope this helps. On Wed, 2022-10-19 at 23:11 +1100, Rosepetals wrote: > Hi all, > > I’m running Windows 11. > > I was running Gnucash 2.3.4 for years and finally decided to upgrade to the > latest stable release of 4.12 so I can export to a spreadsheet. > > The setup needed to uninstall 2.3.4 which went fine and then 4.12 finished > installing. > > I opened Gnucash 4.12 and opened my Gnucash database. It notified me I > needed to upgrade the database to the new version which worked fine and I > was able to access all my data. I made a few entries and closed Gnucash > without any issues. > > Later I opened Gnucash again but this time it didn’t auto open the database > and I'm left with a blank screen. I proceed to locate and open the database > but after waiting for it to load, nothing appears. I try to load it > manually in other ways but eventually Gnucash crashes. > > If it helps, the database is 30MB in size. > > Please help. I have 13 years of data here. > > Thanks for looking! > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
Unlikely, but you might get lucky. (You really don't have *any* backup at all? Really? You've been using a decades old version of GnuCash and you never make backups?) Note, the GnuCash file, by default unless you changed it, is a compressed XML file. Uncompressed, it is just plain text and human readable. (albeit in a markup language) How the file is arranged has changed over the years, but the raw data should still be there. As for 'developing a problem afterwards' it could be that GnuCash is proceeding with data migration in the background, but it may have gotten hung up on something, or it is just really taking a long time. As David noted, running from the command line, or getting a Trace File might shed some light as to what is going on. You *might* get lucky by removing 4.12, going back to 2.3.4, then proceeding as I outlined, *but* be darned sure to MAKE A COPY of your file before doing so! Honestly, I'd go the route David suggested first to get some output and then report back here what you get. Also, what do you mean by 'blank screen'? Can you take a screenshot and attach it in a reply? (do not paste in-line, it needs to be attached) Maybe do that FIRST, and then once we see what you see, we can advise further. Regards, Adrien On 10/19/22 10:13 PM, Rosepetals wrote: I don’t have a backup of the 2.3.4 database. Is there a way to recover data from the current 4.12 database? Also why does Gnucash work fine after the database upgrade but then develop a fault afterwards? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
