[GNC] Button1 & Button2

[Paul Konnersman]

On pages 75 & 76 (87 & 88 of the printer dialog) of the Help Manual there
are references to "Button1" and "Button.2" I have not been able to
identify either of these buttons.

Paul
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
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.

[GNC] CSV import of Credit Card Transaction Data

[Paul Konnersman]

MacOS Version Catalina 10.15.7 (19H2) and   GnuCash Version: 4.2 Build ID:
4.2+(2020-09-26)


I’m attempting to import a CSV Credit Card transaction file. In the import
Preview window I have the following fields mapped to the import data:
“Date,” Num,” “Description,” “Memo,” but there seems to be *no appropriate
mapping for the fields that I might call “Debit/Credit,” and “Amount.”*


I don’t see a need for Debit/Credit since that can be handled with the
minus sign on amount. But certainly, I need “Amount.” But I can’t find any
reference to it in the docs. What have I missed?


Paul

-- 
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
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.

[GNC] New User

[Paul Konnersman]

I am a new user trying to run GnuCash 4.2 on a Mac PowerBook running MacOS
10.15.7. I did manage to get it running briefly, put my chart of accounts
in manually and then tried to instal OSF using the OSF installation tool. I
succeeded only in corrupting the file.


I I wiped all GnuCash files from my PowerBook, ran disk utility twice and
am now staring at the instructions in Read Me which is making my eyes
cross. Any guidance would be greatly appreciated.


Paul
___
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.

Re: [GNC] Problem with column mapping in Import preview window

[Paul Konnersman]

It seems to be a bug in GC 3.3. I have gone back to GC 2.6 and the problem is
gone.
Paul



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

[GNC] Problem with column mapping in Import preview window

[Paul Konnersman]

I’m a very new user, trying to import transaction data in CSV format. I am
running GC 3.3 on a Mac Powerbook with High Sierra (10.13.6).


I imported two files with a minimum of problems using GC 2.6, then found
out that the current version was now 3.3 and upgraded.


I am having problems with the import preview Window—trying to map columns.
It is difficult to get the cursor to move appropriately, it suddenly
disappears just when you are about to make selection, once you make a
selection it reverts back to “NONE”, eventually I get “do not enter” icons
to the right of the dates and the lines all turn red.


Any suggestions? I am thinking of trying to export what I have and then go
back to GC 2.6.

-- 
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
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.

[GNC] Importing csv transactions

[Paul Konnersman]

I'm new to Gnucash and trying to get set up. I successfully imported a
couple of years worth of transactions into one account a few months ago
when I was evaluating Gnucash. Now I'm trying to import more transactions
into that same account without success.

My process:
1) Menu Bar> File> Input> Import Transactions from CSV
2) Navigate to CSV file to be imported
3) Set Date format to y-m-d
4) Set currency format to "period"
5) Map columns in imported file to columns in Gnucash

   1. Date -> Date
   2. Num -> Num
   3. Description -> Action
   4. Account -> Transfer
   5. Notes -> C
   6. Deposit -> Debit Amount
   7. None -> Credit Amount
   8. None -> Balance

6) I get a notice repeated three times that reads, "Date Column could not
be understood."

Any suggestions will be appreciated.

Paul

--
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
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.

Date Change

[Paul Konnersman]

My earlier reply was addressed to the wrong person.

I think that you will find what you're looking for here:

*MenuBar> File> Accounts> "Day Threshold to Read-Only Transactions (red*
* line)*



*If you enter zero in"Day Threshold" field all transactions will be
available in Read/Write,*
*If you enter the numeral "n" in "Day Threshold" field all transactions
will be available in Read/Write for the last "n" days, but read only if
the transaction date is more than "n" in the past. .And you will only be
able to back-date a transaction "n" days*

Hope this is helpful.

Paul

-- 
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
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 aberent behavior

[Paul Konnersman]

I am currently trying to set up Gnucash and am encountering a great deal of
aberrant behavior.


1. Using the cursor in pull down lists selects the item below the cursor
which can be overcome with the up/down arrow keys


2. Currency selection shifts from default (USD) to Andorian Franc (ADF)


3. Entry in “Account Name” field is transferred into “Account Code” field


4. Apple Pages files have the gnu cash file identifier appended to the file
name with it’s “Pages” file identifier


5. The new account window is slightly too short to permit selection of
“Cancel/OK”


6. Clicking on GC window during what appears to be a launch hang-up results
in a “Unsaved Book” with no data in it and notification that "The
file/URI/Users/PMK/Desktop/SEP 2018 Itinerary.pages.gnucash could not be
found. the referenced file is a pages file with ".gnucash" appended to it.


Any diagnostic or solution suggestions will be appreciated.


Paul

Mac OSX High Sierra 10.13.3
GnuCash 2.6.19
___
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.

Re: Transaction locking after a specified interval

[Paul Konnersman]

Thank you David C. and Adrien.

I'm embarrassed to find that it was already answered and I didn't find the
thread.

"File>Properties>Accounts: Day Threshold" does what I needed (OSX). 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: Gnucash freezes while loading data

[Paul Konnersman]

Thanks Jeffery, I'll save that sight for future reference.

It turned out that all I needed was a quick search and replace (replace "/"
in the date field with "-") and everything then went smoothly.

Paul

On Sun, Jan 21, 2018 at 12:50 PM, david amaral <dejama...@yahoo.com> wrote:

> site is csvconverter.biz
>
> it is an online converter.
>
>
> --
> *From:* david amaral via gnucash-user <gnucash-user@gnucash.org>
> *To:* jeffrey black <beastmaster...@hotmail.com>; David T. <
> sunfis...@yahoo.com>; Paul Konnersman <konners...@gmail.com>
> *Cc:* Gnucash Users <gnucash-user@gnucash.org>
> *Sent:* Sunday, January 21, 2018 10:23 AM
> *Subject:* Re: Gnucash freezes while loading data
>
> Here is a free converter you might want to try for your csv file.
>  CSV Converter
>
>
>
> |
> |
> |
> |  ||
>
>   |
>
>   |
> |
> |  |
> CSV Converter
> Free online CSV converter. Save your bank/institution statement as QIF or
> OFX to then import into your accountin...  |  |
>
>   |
>
>   |
>
>
>   From: jeffrey black <beastmaster...@hotmail.com>
> To: David T. <sunfis...@yahoo.com>; Paul Konnersman <konners...@gmail.com>
>
> Cc: Gnucash Users <gnucash-user@gnucash.org>
> Sent: Sunday, January 21, 2018 9:41 AM
> Subject: Re: Gnucash freezes while loading data
>
> On 1/21/2018 8:50 AM, David T. via gnucash-user wrote:
> > Those don’t sound like large files, so it sounds like there might be
> something wrong. Do they ALL hang, or only some of them?
> >
> > I will admit that I am not one to advise on importing, as I don’t do it
> much. That being said, I would take a close look at the source
> files—especially the date fields, as GnuCash can be somewhat finicky around
> variably-formed dates.
> >
> > David T.
> >
> >> On Jan 21, 2018, at 6:59 PM, Paul Konnersman <konners...@gmail.com>
> wrote:
> >>
> >> Thank you for the suggestions David T.
> >>
> >> Each of the files that I have been trying to import contains three
> weeks of transactions from one bank account. They are all between 1kb and
> 3kb.
> >>
> >> Paul
> >>
> >> On Sun, Jan 21, 2018 at 1:15 AM, David T. <sunfis...@yahoo.com  sunfis...@yahoo.com>> wrote:
> >> Moreover, any import process can take a long time to complete (with no
> indication of progress). If you are importing a large csv file (as you
> might be doing if you are migrating in to GnuCash), it can be especially
> time consuming. Five or ten minutes is not unheard of.
> >>
> >> Try again and wait it out, as David C. suggests.
> >>
> >> If it really gets hung up, you would be well-advised to break the
> import up into smaller portions, thus reducing the time to process any
> given subset, and also increasing the likelihood of finding any erroneous
> data that might be causing a glitch. Heck, you may want to do this anyway.
> >>
> >> David T.
> >>
> >>> On Jan 21, 2018, at 4:45 AM, David Carlson <
> david.carlson@gmail.com <mailto:david.carlson@gmail.com>> wrote:
> >>>
> >>> Not sure how you know it is 'frozen' after such a short time.  GnuCash
> does
> >>> not have any 'activity' indicator. Try giving it several minutes.
> >>>
> >>> David C
> >>>
> >>> On Sat, Jan 20, 2018 at 4:19 PM, Paul Konnersman <konners...@gmail.com
> <mailto:konners...@gmail.com>>
> >>> wrote:
> >>>
> >>>> I have just made the decision to use Gnucash. So far I have
> successfully
> >>>> imported my chart of accounts from a csv-file and attempted to import
> a
> >>>> csv-file of transaction data. After 20-30 seconds of the transaction
> import
> >>>> Gnucash freezes and I have to force quit. Any suggestions will be
> >>>> appreciated.
> >>>>
> >>>> Paul
> >>>> Running Gnucash 2.6.19 with OSX High Sierra on a Macbook Pro
> >>>> --
> >>>> *Paul M. Konnersman*
> >>>> *konners...@gmail.com <mailto:konners...@gmail.com> <
> konners...@gmail.com <mailto:konners...@gmail.com>>*
> >>>> *781-639-0616 <(781)%20639-0616> 
> >*
> >>>> ___
> >>>> gnucash-user mailing list
> >>>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> >>>> https://lists.gnucash.

Re: Gnucash freezes while loading data

[Paul Konnersman]

David T. you nailed it.

I put the file in a word processor and changed all of the dates from
MM/DD/ to MM-DD- and it worked beautifly. Thanks much.

Paul

On Sun, Jan 21, 2018 at 9:50 AM, David T. <sunfis...@yahoo.com> wrote:

> Those don’t sound like large files, so it sounds like there might be
> something wrong. Do they ALL hang, or only some of them?
>
> I will admit that I am not one to advise on importing, as I don’t do it
> much. That being said, I would take a close look at the source
> files—especially the date fields, as GnuCash can be somewhat finicky around
> variably-formed dates.
>
> David T.
>
> On Jan 21, 2018, at 6:59 PM, Paul Konnersman <konners...@gmail.com> wrote:
>
> Thank you for the suggestions David T.
>
> Each of the files that I have been trying to import contains three weeks
> of transactions from one bank account. They are all between 1kb and 3kb.
>
> Paul
>
> On Sun, Jan 21, 2018 at 1:15 AM, David T. <sunfis...@yahoo.com> wrote:
>
>> Moreover, any import process can take a long time to complete (with no
>> indication of progress). If you are importing a large csv file (as you
>> might be doing if you are migrating in to GnuCash), it can be especially
>> time consuming. Five or ten minutes is not unheard of.
>>
>> Try again and wait it out, as David C. suggests.
>>
>> If it really gets hung up, you would be well-advised to break the import
>> up into smaller portions, thus reducing the time to process any given
>> subset, and also increasing the likelihood of finding any erroneous data
>> that might be causing a glitch. Heck, you may want to do this anyway.
>>
>> David T.
>>
>> > On Jan 21, 2018, at 4:45 AM, David Carlson <david.carlson@gmail.com>
>> wrote:
>> >
>> > Not sure how you know it is 'frozen' after such a short time.  GnuCash
>> does
>> > not have any 'activity' indicator. Try giving it several minutes.
>> >
>> > David C
>> >
>> > On Sat, Jan 20, 2018 at 4:19 PM, Paul Konnersman <konners...@gmail.com>
>> > wrote:
>> >
>> >> I have just made the decision to use Gnucash. So far I have
>> successfully
>> >> imported my chart of accounts from a csv-file and attempted to import a
>> >> csv-file of transaction data. After 20-30 seconds of the transaction
>> import
>> >> Gnucash freezes and I have to force quit. Any suggestions will be
>> >> appreciated.
>> >>
>> >> Paul
>> >> Running Gnucash 2.6.19 with OSX High Sierra on a Macbook Pro
>> >> --
>> >> *Paul M. Konnersman*
>> >> *konners...@gmail.com <konners...@gmail.com>*
>> >> *781-639-0616*
>> >> ___
>> >> gnucash-user mailing list
>> >> gnucash-user@gnucash.org
>> >> 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
>> > 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.
>>
>>
>
>
> --
> *Paul M. Konnersman*
> *konners...@gmail.com <konners...@gmail.com>*
> *781-639-0616 <(781)%20639-0616>*
>
>
>


-- 
*Paul M. Konnersman*
*konners...@gmail.com <konners...@gmail.com>*
*781-639-0616*
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Gnucash freezes while loading data

[Paul Konnersman]

Thank you for the suggestions David T.

Each of the files that I have been trying to import contains three weeks of
transactions from one bank account. They are all between 1kb and 3kb.

Paul

On Sun, Jan 21, 2018 at 1:15 AM, David T. <sunfis...@yahoo.com> wrote:

> Moreover, any import process can take a long time to complete (with no
> indication of progress). If you are importing a large csv file (as you
> might be doing if you are migrating in to GnuCash), it can be especially
> time consuming. Five or ten minutes is not unheard of.
>
> Try again and wait it out, as David C. suggests.
>
> If it really gets hung up, you would be well-advised to break the import
> up into smaller portions, thus reducing the time to process any given
> subset, and also increasing the likelihood of finding any erroneous data
> that might be causing a glitch. Heck, you may want to do this anyway.
>
> David T.
>
> > On Jan 21, 2018, at 4:45 AM, David Carlson <david.carlson@gmail.com>
> wrote:
> >
> > Not sure how you know it is 'frozen' after such a short time.  GnuCash
> does
> > not have any 'activity' indicator. Try giving it several minutes.
> >
> > David C
> >
> > On Sat, Jan 20, 2018 at 4:19 PM, Paul Konnersman <konners...@gmail.com>
> > wrote:
> >
> >> I have just made the decision to use Gnucash. So far I have successfully
> >> imported my chart of accounts from a csv-file and attempted to import a
> >> csv-file of transaction data. After 20-30 seconds of the transaction
> import
> >> Gnucash freezes and I have to force quit. Any suggestions will be
> >> appreciated.
> >>
> >> Paul
> >> Running Gnucash 2.6.19 with OSX High Sierra on a Macbook Pro
> >> --
> >> *Paul M. Konnersman*
> >> *konners...@gmail.com <konners...@gmail.com>*
> >> *781-639-0616*
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> 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
> > 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.
>
>


-- 
*Paul M. Konnersman*
*konners...@gmail.com <konners...@gmail.com>*
*781-639-0616*
___
gnucash-user mailing list
gnucash-user@gnucash.org
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 freezes while loading data

[Paul Konnersman]

I have just made the decision to use Gnucash. So far I have successfully
imported my chart of accounts from a csv-file and attempted to import a
csv-file of transaction data. After 20-30 seconds of the transaction import
Gnucash freezes and I have to force quit. Any suggestions will be
appreciated.

Paul
Running Gnucash 2.6.19 with OSX High Sierra on a Macbook Pro
-- 
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.