Period End Accounts

[Mike Stillingfleet]

Dear All,

I have just been through the annual preparation of my accounts. I have a couple 
of questions as a result.

1. I am sure that GNU has 'lost' the reconciled status of transactions which I 
know I have previously reconciled. Is this my imagination or is this possible? 
Unfortunately this has demanded that I re-reconcile two bank accounts back to 
2014 which was a complete pain.

2. Reports which I created and saved have been completely 'lost' from the 
Reports \ Saved Report Configurations.   This definitely is not my imagination. 
I have several years worth of reports saved to PDF which have been submitted to 
my accountants in prior years. These reports have disappeared from GNU.

3. I think that I have asked this question previously but I will asked it 
again. Does GNU provided a mechanism by which it can do a period end. So that 
accruals can be recorded and current year transactions turned into prior year 
and 'set in stone'.

Thank you.

-- 
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk
___
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: info about action field in double-line view

[Jeff Abrahamson]

The num field[*] is for the check number or other accounting document.  
(In a business situation, you always need to have some unique identifier 
between accounting entries and the physical or electronic documents that 
justify them in case of control (=audit).



[*] I say this because it makes sense in the context of accounting, not 
because I actually know what was in the developers' minds when they 
implemented it.


Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255
https://www.p27.eu/jeff/

purple.com -> p27.eu


On 22/01/18 03:11, Dave H wrote:

Yes, if you use the Reconcile process it puts the "R" in for you :-)

Cheers Dave.

On 22 January 2018 at 11:47, Mark Hedges  wrote:


Oh so I should use the R column for checking against the bank web site
or statement, instead of putting a checkmark in the notes column like
I have been :-)

Still not sure what 'Action' is supposed to describe on an entry that
is not split, or even what it means on a split item, but thanks for
the reference.

Mark
--
Mark Hedges
CEO Weird Vibe Inc.
+1-310-487-7123
https://weirdvibe.media



On Sun, Jan 21, 2018 at 6:54 PM, Dave H  wrote:

Try clicking in the Action field - it displays a drop down for

transaction

type etdc.

R = Reconciled and has values of N (New ?) / C = Cleared / R =

Reconciled.

A dunno I only ever use "Basic Ledger" view :-)

Check out https://code.gnucash.org/docs/C/gnucash-guide/txns-

registers1.html

for a bit more detail...

Cheers Dave H.


On 22 January 2018 at 10:03, Mark Hedges 

wrote:

Hi.  I view my checking account ledger in Basic Ledger mode.  I choose
View > Double Line View.  This opens up the "Notes" line for each
entry, which is helpful.

It also shows an "Action" field underneath the "Num" field.  Where is
this described in the manual?  What is the purpose of the Action
field?

On that note what is the purpose of the Num field?  To enter check
numbers?

It also has R and A fields.  "R" field is automatically filled with
"n" for each transaction.  "A" field is blank.  What are these for?

Thanks.
Mark

--
Mark Hedges
CEO Weird Vibe Inc.
+1-310-487-7123
https://weirdvibe.media
___
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.


--

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255
https://www.p27.eu/jeff/

purple.com -> p27.eu

___
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: info about action field in double-line view

[Mark Hedges]

Oh so I should use the R column for checking against the bank web site
or statement, instead of putting a checkmark in the notes column like
I have been :-)

Still not sure what 'Action' is supposed to describe on an entry that
is not split, or even what it means on a split item, but thanks for
the reference.

Mark
--
Mark Hedges
CEO Weird Vibe Inc.
+1-310-487-7123
https://weirdvibe.media



On Sun, Jan 21, 2018 at 6:54 PM, Dave H  wrote:
> Try clicking in the Action field - it displays a drop down for transaction
> type etdc.
>
> R = Reconciled and has values of N (New ?) / C = Cleared / R = Reconciled.
>
> A dunno I only ever use "Basic Ledger" view :-)
>
> Check out https://code.gnucash.org/docs/C/gnucash-guide/txns-registers1.html
> for a bit more detail...
>
> Cheers Dave H.
>
>
> On 22 January 2018 at 10:03, Mark Hedges  wrote:
>>
>> Hi.  I view my checking account ledger in Basic Ledger mode.  I choose
>> View > Double Line View.  This opens up the "Notes" line for each
>> entry, which is helpful.
>>
>> It also shows an "Action" field underneath the "Num" field.  Where is
>> this described in the manual?  What is the purpose of the Action
>> field?
>>
>> On that note what is the purpose of the Num field?  To enter check
>> numbers?
>>
>> It also has R and A fields.  "R" field is automatically filled with
>> "n" for each transaction.  "A" field is blank.  What are these for?
>>
>> Thanks.
>> Mark
>>
>> --
>> Mark Hedges
>> CEO Weird Vibe Inc.
>> +1-310-487-7123
>> https://weirdvibe.media
>> ___
>> 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.

Re: info about action field in double-line view

[Dave H]

Try clicking in the Action field - it displays a drop down for transaction
type etdc.

R = Reconciled and has values of N (New ?) / C = Cleared / R = Reconciled.

A dunno I only ever use "Basic Ledger" view :-)

Check out https://code.gnucash.org/docs/C/gnucash-guide/txns-registers1.html
for a bit more detail...

Cheers Dave H.


On 22 January 2018 at 10:03, Mark Hedges  wrote:

> Hi.  I view my checking account ledger in Basic Ledger mode.  I choose
> View > Double Line View.  This opens up the "Notes" line for each
> entry, which is helpful.
>
> It also shows an "Action" field underneath the "Num" field.  Where is
> this described in the manual?  What is the purpose of the Action
> field?
>
> On that note what is the purpose of the Num field?  To enter check numbers?
>
> It also has R and A fields.  "R" field is automatically filled with
> "n" for each transaction.  "A" field is blank.  What are these for?
>
> Thanks.
> Mark
>
> --
> Mark Hedges
> CEO Weird Vibe Inc.
> +1-310-487-7123
> https://weirdvibe.media
> ___
> 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.

info about action field in double-line view

[Mark Hedges]

Hi.  I view my checking account ledger in Basic Ledger mode.  I choose
View > Double Line View.  This opens up the "Notes" line for each
entry, which is helpful.

It also shows an "Action" field underneath the "Num" field.  Where is
this described in the manual?  What is the purpose of the Action
field?

On that note what is the purpose of the Num field?  To enter check numbers?

It also has R and A fields.  "R" field is automatically filled with
"n" for each transaction.  "A" field is blank.  What are these for?

Thanks.
Mark

--
Mark Hedges
CEO Weird Vibe Inc.
+1-310-487-7123
https://weirdvibe.media
___
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]

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  wrote:

> site is csvconverter.biz
>
> it is an online converter.
>
>
> --
> *From:* david amaral via gnucash-user 
> *To:* jeffrey black ; David T. <
> sunfis...@yahoo.com>; Paul Konnersman 
> *Cc:* Gnucash Users 
> *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 
> To: David T. ; Paul Konnersman 
>
> Cc: Gnucash Users 
> 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 
> 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. > 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  >
> >>> 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 <(781)%20639-0616> 
> >*
>  ___
>  gnucash-user mailing list
>  gnucash-user@gnucash.org 
>  https://lists.gnucash.org/mailman/listinfo/gnucash-user <
> 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 <
> 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 
> >> 781-639-0616 <(781)%20639-0616>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > 

Keyboard Shortcuts Additions in Linux

[Roger Miskowicz]

I wanted to add ctrl-b to reconcile and discovered that in:

https://wiki.gnucash.org/wiki/Keyboard_Shortcuts#Modifying_
Keyboard_Shortcuts

The following text is incorrect in that it doesn't work on my Linux:

Linux Kilo 4.10.1-041001-generic #201702260735 SMP Sun Feb 26 12:36:48 UTC
2017 x86_64 x86_64 x86_64 GNU/Linux

Ubuntu 16.04.3 LTS

"Accelerators

Under *Linux* hot keys can be created or reassignated. Open a terminal and
type:

gsettings set org.gnome.desktop.interface can-change-accels true"


However, editing

*~/.gnucash/accelerator-map*

did work by changing a line to:

 (gtk_accel_path
"/GncPluginPageRegisterActions/ActionsReconcileAction"
"b")
___
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.

Inserting a split line

[aegross]

Greetings,

When entering a split is there a method for inserting a split line before an
existing split line?  I usually add new split lines to the end of my list of
splits but for a particular recurring transactions it's grown a little messy
over time with similar items not grouped together. 

Thanks,
AEG





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

[david amaral via gnucash-user]

site is csvconverter.biz
it is an online converter.

  From: david amaral via gnucash-user 
 To: jeffrey black ; David T. 
; Paul Konnersman  
Cc: Gnucash Users 
 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 
 To: David T. ; Paul Konnersman  
Cc: Gnucash Users 
 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  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. > > 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 >> > 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 >> >
>>> 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  >*
 *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 
>> 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.

Paul:

I can not speak for the OS you are running, GnuCash may look a little 
different.  As will your Quicken program.  I am still running Windoze.

My version (2014), of quicken, will not export to .csv, only .qif and 
.qfx.  I would recommend exporting to .qif instead.  The qif exported 
file will allow for multiple split transactions, I do not know about the 

Re: Gnucash freezes while loading data

[david amaral via gnucash-user]

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 
 To: David T. ; Paul Konnersman  
Cc: Gnucash Users 
 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  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. > > 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 >> > 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 >> >
>>> 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  >*
 *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 
>> 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.

Paul:

I can not speak for the OS you are running, GnuCash may look a little 
different.  As will your Quicken program.  I am still running Windoze.

My version (2014), of quicken, will not export to .csv, only .qif and 
.qfx.  I would recommend exporting to .qif instead.  The qif exported 
file will allow for multiple split transactions, I do not know about the 
csv export.  If I remember correctly I exported all of my quicken data 
in one shot and imported it.

Sometimes GnuCash has to "chew" on an import for a while.  I frequently 
get a message in the top title bar that Gnucash is "not responding".  
Wait a few minutes and see if it finishes.  I gave up on .csv imports 
because I could never assign the right fields. All I use is 

Re: Gnucash freezes while loading data

[jeffrey black]

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

Paul:

I can not speak for the OS you are running, GnuCash may look a little 
different.  As will your Quicken program.  I am still running Windoze.

My version (2014), of quicken, will not export to .csv, only .qif and 
.qfx.  I would recommend exporting to .qif instead.  The qif exported 
file will allow for multiple split transactions, I do not know about the 
csv export.  If I remember correctly I exported all of my quicken data 
in one shot and imported it.

Sometimes GnuCash has to "chew" on an import for a while.  I frequently 
get a message in the top title bar that Gnucash is "not responding".  
Wait a few minutes and see if it finishes.  I gave up on .csv imports 
because I could never assign the right fields. All I use is .qif and .ofx.

If csv is your only choice, try loading one of your csv files into a 
spreadsheet program, it makes it easier to see the layout. If it is a 
layout problem the spreadsheet program will complain. Then look for 
inconsistency's  in the data fields.

If that doesn't work then you will have to look at your csv file the 
hard way, with a text editor.

--JEffrey Black M.B.A.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-

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.  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  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.  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 
>> 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 
>> > 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 *
>> >> *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 *
> *781-639-0616 <(781)%20639-0616>*
>
>
>


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

Re: [MAINT] Network/Server downtime TODAY at 1500-1600 US/EST

[Derek Atkins]

Thanks. I'll take a look.
Amusingly your email came around the same time I saw an ovirt engine 
restart implying a network blip.


-derek
Sent using my mobile device. Please excuse any typos.



On January 21, 2018 1:36:29 AM "David T."  wrote:


Derek,

The wiki doesn’t seem to be operational at this time.

David



On Jan 21, 2018, at 2:37 AM, Derek Atkins  wrote:

And now everything is back online.
Please let me know if you see any issues.

-derek


On Sat, January 20, 2018 2:08 pm, Derek Atkins wrote:

Hi,

I'm going to be taking my network down (including code, wiki, lists) at
around 12n today in order to relocate the equipment.  I suspect the
downtime will be a couple hours or so, assuming everything goes
smoothly.

I will be taking the server down around 2:30pm, give or take.

I'll email again when it's back online.

Sorry for the short notice for this move; I have to coordinate with
someone else and I got a short-term window from them.

Thanks!

-derek
--
  Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
  Member, MIT Student Information Processing Board  (SIPB)
  URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
  warl...@mit.eduPGP key available
___
gnucash-devel mailing list
gnucash-de...@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel




--
  Derek Atkins 617-623-3745
  de...@ihtfp.com www.ihtfp.com
  Computer and Internet Security Consultant

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

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

[David T. via gnucash-user]

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