Re: [GNC] Error importing quicken 2017 qif / qfx

[cicko]

You may want to subscribe to this issue and add any extra information you
find useful:
https://bugs.gnucash.org/show_bug.cgi?id=788474




--
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: [GNC] Omission from help manual: formulas

[Frank H. Ellenberger]

Hi Stan,
Am 15.09.18 um 15:37 schrieb Stan Brown:
> Though I have 2.6.19, I looked on line at the 3.2 manuals, and they are
> the same in this respect.

You missed one important place, the FAQ:
https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_use_variables_and_formula_in_scheduled_transactions.3F
that leads to
https://wiki.gnucash.org/wiki/Scheduled_Transactions


> There doesn't seem to be any documentation of formulas for scheduled
> transactions. I'm talking about the "debit formula" and "credit formula"
> columns in the template transaction pane of the Edit Scheduled
> Transaction window.
> 
> There are specific formulas for things like mortgages and payroll, but I
> was unable to find the general rules for constructing formulas, neither
> in the Help Manual nor in the Tutorial and Concept Guide.
> 
> Can this be added, please?

Yes it should be added to the docs, so as David already said, raise a
bug report.

> -- Regards, Stan Brown

Regards
Frank

___
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] Error importing quicken 2017 qif / qfx

[David Cousens]

Diego,

I have just imported an example file given in the W3C article on QIF format
(https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm) without any
problem using the Import QIF wizard  ( have to cut off the comments on the
end of the lines).A copy of the file is attached example1.qif
  . I don't
use qif files or Quicken so it was the only qif files I could dig up
quickly.  You may want to check your file out against the format description
given in that article.

There is also a QFX file viewer available on this page you can check the 
.qfx file with (https://fileinfo.com/extension/qfx).  that file vewer should
also be able to open the QIF file as well.

the manual entry for QIF importer is here 
https://www.gnucash.org/docs/v3/C/gnucash-help/import-qif.html


And  migration from Quicken is covered here  
https://wiki.gnucash.org/wiki/Quicken_Migration

David Cousens



-
David Cousens
--
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: [GNC] Omission from help manual: formulas

[Stan Brown]

Thank you for the reply, Frank, but I read that before I posted. That's quite 
inadequate to tell people how to create formulas. 

The first three omissions that occur to me are: how do we use the value of one 
split in computing the value for a different split?  How do we use values from 
a specific other transaction to compute values for this one? How do we do 
exponentiation, for goodness sake?

-- 
Stan Brown
the_stan_br...@fastmail.fm
https://BrownMath.com
http://OakRoadSystems.com/

On Mon, Sep 17, 2018, at 5:06 AM, Frank H. Ellenberger wrote:
> Hi Stan,
> Am 15.09.18 um 15:37 schrieb Stan Brown:
> > Though I have 2.6.19, I looked on line at the 3.2 manuals, and they are
> > the same in this respect.
> 
> You missed one important place, the FAQ:
> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_use_variables_and_formula_in_scheduled_transactions.3F
> that leads to
> https://wiki.gnucash.org/wiki/Scheduled_Transactions
> 
> 
> > There doesn't seem to be any documentation of formulas for scheduled
> > transactions. I'm talking about the "debit formula" and "credit formula"
> > columns in the template transaction pane of the Edit Scheduled
> > Transaction window.
> > 
> > There are specific formulas for things like mortgages and payroll, but I
> > was unable to find the general rules for constructing formulas, neither
> > in the Help Manual nor in the Tutorial and Concept Guide.
> > 
> > Can this be added, please?
> 
> Yes it should be added to the docs, so as David already said, raise a
> bug report.
> 
> > -- Regards, Stan Brown
> 
> Regards
> Frank
> 
___
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] Error importing quicken 2017 qif / qfx

[David T. via gnucash-user]

I think it’s a little premature to refer to this bug. 

It’s not clear that the OP has determined that the content of their QIF file is 
properly structured and being properly interpreted by the GnuCash importer—and 
that is a more profitable avenue for them to explore at this time.

The bug to which you refer addresses a very particular aspect of QIF import, 
while the OP is having troubles importing their Quicken data for the first time.

> On Sep 17, 2018, at 3:16 AM, cicko  wrote:
> 
> You may want to subscribe to this issue and add any extra information you
> find useful:
> https://bugs.gnucash.org/show_bug.cgi?id=788474
> 
> 
> 
> 
> --
> 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.

___
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] Error importing quicken 2017 qif / qfx

[David T. via gnucash-user]

Hello,

In fact, the error is quite clear: something in the QIF file is not as the 
importer expects. As another David has noted, the QIF importer itself is 
functional, and has worked for many users before you. Unfortunately, in this 
case, that erro message is not particularly helpful, as your QIF file probably 
has a lot of transactions in it, any one of which could have caused the error. 
Locating such errors is, quite simply, a challenge. 

You might open your QIF file and try to determine whether anything looks out of 
order there, although that is difficult.

You don’t say where you are located, but one of the most common situations that 
causes this error is date formatting. GnuCash attempts to guess whether you 
follow US-style date (MM-DD-) or European-style (DD-MM-), but often it 
fails to guess correctly. I believe it defaults to US-style (but I am sure the 
experts will correct me on this).

One way forward for you at this time would be to try using a subset of your 
data to test the import first; if you can figure out how to get a smaller file 
to import, it will make additional imports easier. Many actually recommend 
using this piece-by-piece approach for import for this very reason.

David


> On Sep 16, 2018, at 12:19 PM, Diogo Maciel  wrote:
> 
> Hi, hope someone can help me move out from Quicken
> 
> 
> 
> I tried exporting my data from Quicken in both qif and qfx. The qif importer
> gives me the error below
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Qfx will only show an empty window
> 
> 
> 
> 
> 
> 
> 
> My file has multiple securities and currencies, so this may be relevant. I
> understand that with such a generic error one may need more information,
> which I can surely provide.
> 
> 
> 
> Thanks!
> 
> ___
> 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-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] Omission from help manual: formulas

[David T. via gnucash-user]

Stan, 

I neither use formulas nor scheduled transactions, so I can’t comment on the 
documentation. Since you do, maybe you could add some information on the wiki 
to assist others after you?

> On Sep 17, 2018, at 8:05 AM, Stan Brown  wrote:
> 
> Thank you for the reply, Frank, but I read that before I posted. That's quite 
> inadequate to tell people how to create formulas. 
> 
> The first three omissions that occur to me are: how do we use the value of 
> one split in computing the value for a different split?  How do we use values 
> from a specific other transaction to compute values for this one? How do we 
> do exponentiation, for goodness sake?
> 
> -- 
> Stan Brown
> the_stan_br...@fastmail.fm
> https://BrownMath.com
> http://OakRoadSystems.com/
> 
> On Mon, Sep 17, 2018, at 5:06 AM, Frank H. Ellenberger wrote:
>> Hi Stan,
>> Am 15.09.18 um 15:37 schrieb Stan Brown:
>>> Though I have 2.6.19, I looked on line at the 3.2 manuals, and they are
>>> the same in this respect.
>> 
>> You missed one important place, the FAQ:
>> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_use_variables_and_formula_in_scheduled_transactions.3F
>> that leads to
>> https://wiki.gnucash.org/wiki/Scheduled_Transactions
>> 
>> 
>>> There doesn't seem to be any documentation of formulas for scheduled
>>> transactions. I'm talking about the "debit formula" and "credit formula"
>>> columns in the template transaction pane of the Edit Scheduled
>>> Transaction window.
>>> 
>>> There are specific formulas for things like mortgages and payroll, but I
>>> was unable to find the general rules for constructing formulas, neither
>>> in the Help Manual nor in the Tutorial and Concept Guide.
>>> 
>>> Can this be added, please?
>> 
>> Yes it should be added to the docs, so as David already said, raise a
>> bug report.
>> 
>>> -- Regards, Stan Brown
>> 
>> Regards
>> Frank
>> 
> ___
> 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-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] Omission from help manual: formulas

[David T. via gnucash-user]

Stan, 

I will preface this by repeating that I don’t use formulas or SX, so my advice 
may be corrected by others. Addressing your questions in reverse order.

With regard to exponentiation, I note that the Bank Account Interest section 
shows the expt (exponent) function (which comes from the underlying Scheme). 
When I attempted to put this into a formula (“expt (tryme 2)”), however, I got 
no results. Reading further down the wiki section, however, yields this: "If 
the formula was simple, then you could just enter it directly in the template 
transaction; unfortunately, the basic compounding-interest formula involves 
exponentiation, which can't be handled in the current expression parser, so one 
must resort to defining it in scheme…” Therefore, you must place any formulas 
with exponentiation in a defined function in fin.scm.

As for computing one split based on another, the strong implication is that 
this cannot be done. The section “formulas or scripts for periodic savings” 
says two things. First, it starts by saying “if you can express the amounts of 
the splits in the transaction as a simple expression,” which sets the 
expectation that you will be using expressions (and not references) in 
formulas. Second, it says there that formulas cannot “sum or obtain the value 
from existing accounts,” which I interpret to mean that it cannot pull 
information from different transactions. This, when you consider it, makes 
sense: how would the formula evaluation process determine which split was to be 
used?

I think the question of calculating one split based on another is covered in 
the phone bill example, in which each split is derived independently, 
demonstrating by example that you can’t compute one split based on another.

HTH,
David

> On Sep 17, 2018, at 8:37 AM, David T. via gnucash-user 
>  wrote:
> 
> Stan, 
> 
> I neither use formulas nor scheduled transactions, so I can’t comment on the 
> documentation. Since you do, maybe you could add some information on the wiki 
> to assist others after you?
> 
>> On Sep 17, 2018, at 8:05 AM, Stan Brown  wrote:
>> 
>> Thank you for the reply, Frank, but I read that before I posted. That's 
>> quite inadequate to tell people how to create formulas. 
>> 
>> The first three omissions that occur to me are: how do we use the value of 
>> one split in computing the value for a different split?  How do we use 
>> values from a specific other transaction to compute values for this one? How 
>> do we do exponentiation, for goodness sake?
>> 
>> -- 
>> Stan Brown
>> the_stan_br...@fastmail.fm
>> https://BrownMath.com
>> http://OakRoadSystems.com/
>> 
>> On Mon, Sep 17, 2018, at 5:06 AM, Frank H. Ellenberger wrote:
>>> Hi Stan,
>>> Am 15.09.18 um 15:37 schrieb Stan Brown:
 Though I have 2.6.19, I looked on line at the 3.2 manuals, and they are
 the same in this respect.
>>> 
>>> You missed one important place, the FAQ:
>>> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_use_variables_and_formula_in_scheduled_transactions.3F
>>> that leads to
>>> https://wiki.gnucash.org/wiki/Scheduled_Transactions
>>> 
>>> 
 There doesn't seem to be any documentation of formulas for scheduled
 transactions. I'm talking about the "debit formula" and "credit formula"
 columns in the template transaction pane of the Edit Scheduled
 Transaction window.
 
 There are specific formulas for things like mortgages and payroll, but I
 was unable to find the general rules for constructing formulas, neither
 in the Help Manual nor in the Tutorial and Concept Guide.
 
 Can this be added, please?
>>> 
>>> Yes it should be added to the docs, so as David already said, raise a
>>> bug report.
>>> 
 -- Regards, Stan Brown
>>> 
>>> Regards
>>> Frank
>>> 
>> ___
>> 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-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-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/wi

Re: [GNC] Another sort field like 'Class' in Quicken?

[Paul Kinzelman]

Wow, I did not get that out of what I read at all.
It'd be very useful for people I think if you updated the documentation
to say that.

So would a good summary be that if the box is unchecked, if you fill in
the number field in a transaction, it automagically propagates
to the other corresponding account register to keep them in sync.

If the box is checked, you have to fill in the numbers in both places
manually (if you don't, the other one will be blank),
which allows them to be different.

On 9/16/2018 10:59 PM, Adrien Monteleone wrote:

Think of the option as more like either you have numbers for transactions, or 
you have numbers for splits.

With the option unset, a payment transaction for example will have the same 
number both in the asset/liability register used to make/accept the payment and 
in the AP/AR register.

With the option set, you could have different numbers depending on which 
register you are viewing.

This might be useful in some cases to keep paperwork in sync. Your internal 
paperwork might use one number for a transaction but the external entity might 
use a different one. The option allows you to record both AND see each number 
in its proper perspective and context in your books.

Regards,
Adrien


On Sep 16, 2018, at 10:07 PM, Paul Kinzelman  wrote:

I read the docs and don't really understand the "Use split Action field for 
Number" purpose.
It sounds like the Action field is moved to the Num field, and the Num is hidden
someplace else? And it's inaccessible?

Too bad the empty space can't be used for tag, that sounds like a great 
solution.
I'm surprised that it can't be.

However, it sounds like I can use the "Action" field for the Tag, and I
understand that I have to be careful to make sure the spelling is correct.
As long as I don't collide with one of the already populated items, seems
like I should be OK.

Thanks!

On 9/16/2018 10:24 AM, John Ralls wrote:

But don’t confuse an empty space on the grid for a field. There’s no “tag” 
field, and adding one is complicated.

There are already five free text fields in GnuCash, all searchable: Number, 
Description and Notes are part of transactions, Action and Memo are part of 
splits.  Action is a little weird in that it’s a combo pre-populated with some 
values associated with certain GnuCash features so using it as a 
class/tag/subcategory might require extra effort and might interfere with a 
feature that uses it.

There’s also the “Use split Action Field for Number” book option that displays 
the register account split’s action field in the Num column of the register, 
making the Number field inaccessible from the GUI.

Since the fields are free text it requires user discipline to use any of them 
for categorization: One must be careful to always spell the values the same. 
Many users who want tags complain that that makes it too hard to use free text 
fields for categorization, but a tweak to the Action combo so that all previous 
entries for an action in splits for a particular account are added to the list 
part or using a similar combo in the Memo would go a long way to resolving that 
objection.

Regards,
John Ralls


On Sep 16, 2018, at 8:19 AM, Derek Atkins  wrote:

Search the list archives for "Tags".
SIt's an oft requested feature.
Patches welcome.

-derek
Sent using my mobile device. Please excuse any typos.
On September 16, 2018 10:34:53 AM Paul Kinzelman  wrote:


Quicken normally specifies transactions into Categories for filtering
for reports and such.

But it also has a nice feature to allow a user to sort on a second field
called 'Class' which can be specified for each transaction.

Gnucash has what appears to be an unused field which could be
used for the same purpose. If you view "Double Line", there's a
space to the right of the "Notes" field which currently can't be
used.

Has anybody suggested or thought about using the unused field
for this extra filtering purpose?

___
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-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-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gn

Re: [GNC] Another sort field like 'Class' in Quicken?

[David T. via gnucash-user]

Paul,

This is a recent addition to the program. Since the documentation is also 
developed by volunteers (who are not necessarily the same as the people who 
write the program itself) documentation often lags behind the features. We rely 
on users like you to provide descriptions of features and how they get used. If 
you have a suggestion for this description, we’d welcome it.

As an aside, I will note that it is my understanding that this setting is 
supposedly a one-time option—i.e., that once you select it, you shouldn’t 
change it back. But your comment sounds as if you have tried it both ways in 
your file without negative consequence. If the setting can be changed at a 
later time without problem, that would be important to know. Can you give 
further information on this? 

What exact version are you using, and on which operating system? 

What is your file storage, SQL or XML? If XML, when you tried the different 
settings, did you save your file after each setting change? 

If you did save the file after changing the setting, did you in fact save the 
file with data in the affected fields?

David T.


> On Sep 17, 2018, at 10:00 AM, Paul Kinzelman  wrote:
> 
> Wow, I did not get that out of what I read at all.
> It'd be very useful for people I think if you updated the documentation
> to say that.
> 
> So would a good summary be that if the box is unchecked, if you fill in
> the number field in a transaction, it automagically propagates
> to the other corresponding account register to keep them in sync.
> 
> If the box is checked, you have to fill in the numbers in both places
> manually (if you don't, the other one will be blank),
> which allows them to be different.
> 
> On 9/16/2018 10:59 PM, Adrien Monteleone wrote:
>> Think of the option as more like either you have numbers for transactions, 
>> or you have numbers for splits.
>> 
>> With the option unset, a payment transaction for example will have the same 
>> number both in the asset/liability register used to make/accept the payment 
>> and in the AP/AR register.
>> 
>> With the option set, you could have different numbers depending on which 
>> register you are viewing.
>> 
>> This might be useful in some cases to keep paperwork in sync. Your internal 
>> paperwork might use one number for a transaction but the external entity 
>> might use a different one. The option allows you to record both AND see each 
>> number in its proper perspective and context in your books.
>> 
>> Regards,
>> Adrien
>> 
>>> On Sep 16, 2018, at 10:07 PM, Paul Kinzelman  wrote:
>>> 
>>> I read the docs and don't really understand the "Use split Action field for 
>>> Number" purpose.
>>> It sounds like the Action field is moved to the Num field, and the Num is 
>>> hidden
>>> someplace else? And it's inaccessible?
>>> 
>>> Too bad the empty space can't be used for tag, that sounds like a great 
>>> solution.
>>> I'm surprised that it can't be.
>>> 
>>> However, it sounds like I can use the "Action" field for the Tag, and I
>>> understand that I have to be careful to make sure the spelling is correct.
>>> As long as I don't collide with one of the already populated items, seems
>>> like I should be OK.
>>> 
>>> Thanks!
>>> 
>>> On 9/16/2018 10:24 AM, John Ralls wrote:
 But don’t confuse an empty space on the grid for a field. There’s no “tag” 
 field, and adding one is complicated.
 
 There are already five free text fields in GnuCash, all searchable: 
 Number, Description and Notes are part of transactions, Action and Memo 
 are part of splits.  Action is a little weird in that it’s a combo 
 pre-populated with some values associated with certain GnuCash features so 
 using it as a class/tag/subcategory might require extra effort and might 
 interfere with a feature that uses it.
 
 There’s also the “Use split Action Field for Number” book option that 
 displays the register account split’s action field in the Num column of 
 the register, making the Number field inaccessible from the GUI.
 
 Since the fields are free text it requires user discipline to use any of 
 them for categorization: One must be careful to always spell the values 
 the same. Many users who want tags complain that that makes it too hard to 
 use free text fields for categorization, but a tweak to the Action combo 
 so that all previous entries for an action in splits for a particular 
 account are added to the list part or using a similar combo in the Memo 
 would go a long way to resolving that objection.
 
 Regards,
 John Ralls
 
> On Sep 16, 2018, at 8:19 AM, Derek Atkins  wrote:
> 
> Search the list archives for "Tags".
> SIt's an oft requested feature.
> Patches welcome.
> 
> -derek
> Sent using my mobile device. Please excuse any typos.
> On September 16, 2018 10:34:53 AM Paul Kinzelman  
> wrote:
> 
>> Quicken normally specifies transac

Re: [GNC] Error importing quicken 2017 qif / qfx

[cicko]

GnuCash - User mailing list wrote
> It’s not clear that the OP has determined that the content of their QIF
> file is properly structured ...
> 
> The bug to which you refer addresses a very particular aspect of QIF
> import, while the OP is having troubles importing their Quicken data for
> the first time.

I hope you are not implying that a .qif file exported from Quicken, the
maker of the QIF standard, is "not properly structured". :)

The OP has indicated that he has "multiple securities and currencies" which
sounds pretty much with the scenario I had when the import failed. It could
very well be the exact same issue.

However, without a more comprehensive error message or a log we won't be
able to know more. One thing for the OP would be to check the GC log files,
which are generally placed in the Temp folder.

Not sure if that is convenient here, but I ended up manually entering all
the investment transactions for the financial year and not importing the
historical transactions due to this issue. 



--
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: [GNC] Error importing quicken 2017 qif / qfx

[David T. via gnucash-user]

> On Sep 17, 2018, at 10:17 AM, cicko  wrote:
> 
> GnuCash - User mailing list wrote
>> It’s not clear that the OP has determined that the content of their QIF
>> file is properly structured ...
>> 
>> The bug to which you refer addresses a very particular aspect of QIF
>> import, while the OP is having troubles importing their Quicken data for
>> the first time.
> 
> I hope you are not implying that a .qif file exported from Quicken, the
> maker of the QIF standard, is "not properly structured". :)

Quicken has been known to play fast and loose with its own “standard” on 
numerous occasions. Regardless, I thought that my further comments regarding 
date formats were a clear example of how ambiguities in the data set could 
result in errors on import. Perhaps I wasn’t clear enough on that point.

> 
> The OP has indicated that he has "multiple securities and currencies" which
> sounds pretty much with the scenario I had when the import failed. It could
> very well be the exact same issue.
> 
> However, without a more comprehensive error message or a log we won't be
> able to know more. One thing for the OP would be to check the GC log files,
> which are generally placed in the Temp folder.
> 
> Not sure if that is convenient here, but I ended up manually entering all
> the investment transactions for the financial year and not importing the
> historical transactions due to this issue. 
> 
> 
> 
> --
> 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.

___
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] Another sort field like 'Class' in Quicken?

[Adrien Monteleone]

David,

I have played with the setting back and forth. I’ve done so with both the XML 
and sqlite3 backend. (both cases using 3.2 on MacOS) I haven’t experienced any 
issues.

I think the caveat on changing the setting has to do with importing 
transactions. That was the context of the explanation I saw in a list thread 
and it had something to do with confusing the importer down the road.

I tested changing the setting, editing data, and saving the file (in the case 
of XML, since SQL is instant) closing and re-opening GnuCash and then changing 
the setting again. There were no issues, and everything always ended up were I 
expected it, save if I entered different numbers for each split with the option 
active, when I changed back to using the NUM field as default, each register 
did not have the same number. (I presume because there is no code to guess 
which of the two or more should ‘override’ the others) But the split’s number 
for *that* register moved to the NUM field as expected and could be edited as 
needed just like before.

Regards,
Adrien



> On Sep 17, 2018, at 9:16 AM, David T. via gnucash-user 
>  wrote:
> 
> Paul,
> 
> This is a recent addition to the program. Since the documentation is also 
> developed by volunteers (who are not necessarily the same as the people who 
> write the program itself) documentation often lags behind the features. We 
> rely on users like you to provide descriptions of features and how they get 
> used. If you have a suggestion for this description, we’d welcome it.
> 
> As an aside, I will note that it is my understanding that this setting is 
> supposedly a one-time option—i.e., that once you select it, you shouldn’t 
> change it back. But your comment sounds as if you have tried it both ways in 
> your file without negative consequence. If the setting can be changed at a 
> later time without problem, that would be important to know. Can you give 
> further information on this? 
> 
> What exact version are you using, and on which operating system? 
> 
> What is your file storage, SQL or XML? If XML, when you tried the different 
> settings, did you save your file after each setting change? 
> 
> If you did save the file after changing the setting, did you in fact save the 
> file with data in the affected fields?
> 
> David T.
> 
> 
>> On Sep 17, 2018, at 10:00 AM, Paul Kinzelman  wrote:
>> 
>> Wow, I did not get that out of what I read at all.
>> It'd be very useful for people I think if you updated the documentation
>> to say that.
>> 
>> So would a good summary be that if the box is unchecked, if you fill in
>> the number field in a transaction, it automagically propagates
>> to the other corresponding account register to keep them in sync.
>> 
>> If the box is checked, you have to fill in the numbers in both places
>> manually (if you don't, the other one will be blank),
>> which allows them to be different.
>> 
>> On 9/16/2018 10:59 PM, Adrien Monteleone wrote:
>>> Think of the option as more like either you have numbers for transactions, 
>>> or you have numbers for splits.
>>> 
>>> With the option unset, a payment transaction for example will have the same 
>>> number both in the asset/liability register used to make/accept the payment 
>>> and in the AP/AR register.
>>> 
>>> With the option set, you could have different numbers depending on which 
>>> register you are viewing.
>>> 
>>> This might be useful in some cases to keep paperwork in sync. Your internal 
>>> paperwork might use one number for a transaction but the external entity 
>>> might use a different one. The option allows you to record both AND see 
>>> each number in its proper perspective and context in your books.
>>> 
>>> Regards,
>>> Adrien
>>> 
 On Sep 16, 2018, at 10:07 PM, Paul Kinzelman  wrote:
 
 I read the docs and don't really understand the "Use split Action field 
 for Number" purpose.
 It sounds like the Action field is moved to the Num field, and the Num is 
 hidden
 someplace else? And it's inaccessible?
 
 Too bad the empty space can't be used for tag, that sounds like a great 
 solution.
 I'm surprised that it can't be.
 
 However, it sounds like I can use the "Action" field for the Tag, and I
 understand that I have to be careful to make sure the spelling is correct.
 As long as I don't collide with one of the already populated items, seems
 like I should be OK.
 
 Thanks!
 
 On 9/16/2018 10:24 AM, John Ralls wrote:
> But don’t confuse an empty space on the grid for a field. There’s no 
> “tag” field, and adding one is complicated.
> 
> There are already five free text fields in GnuCash, all searchable: 
> Number, Description and Notes are part of transactions, Action and Memo 
> are part of splits.  Action is a little weird in that it’s a combo 
> pre-populated with some values associated with certain GnuCash features 
> so using it as a class/tag/subcate

Re: [GNC] Another sort field like 'Class' in Quicken?

[Adrien Monteleone]

Not quite the case on the last point. It does propagate from a single entry of 
a transaction.

With the option checked, you enter the numbers in the Action field of *each* 
split and you can do this all in one entry from one register.  (the option 
locks the actual NUM field against editing) But when you view one of the other 
registers, the corresponding transaction will have *its* number in the NUM 
field instead of any of the others.

So if you enter a payment on a bill and use your check number on the payment 
split for the Checking register, then enter perhaps a sequential number on the 
AP split, when you view the Checking register you’ll see the check number in 
the NUM field, but in the AP register you’ll see the sequential transaction 
number there. (If you are in Transaction Journal view so you can see all 
splits, you’ll be able to see that check number in the Action field even from 
the AP register)

Although I don’t currently use this option, I may switch. I use the NUM field 
for a time stamp since GnuCash (while keeping it internally) doesn’t let me set 
a time in addition to the date for a transaction. This can result in erroneous 
negative balances, particularly where it is impossible to have a negative 
balance, like a Cash account. My current method is to enter 24 hour time, 
without a “:” separator but ending in “t” to denote it is not a regular 
transaction number—e.g., 1514t for 3:14pm. When a customer pays me however with 
a check, that means I can’t enter the check number in that field and have to 
place it somewhere else. With this option checked, I could continue to use NUM 
for time stamps where I need to, and also record actual document numbers for 
the other register(s) in the transaction.

Regards,
Adrien

> On Sep 17, 2018, at 9:00 AM, Paul Kinzelman  wrote:
> 
> Wow, I did not get that out of what I read at all.
> It'd be very useful for people I think if you updated the documentation
> to say that.
> 
> So would a good summary be that if the box is unchecked, if you fill in
> the number field in a transaction, it automagically propagates
> to the other corresponding account register to keep them in sync.
> 
> If the box is checked, you have to fill in the numbers in both places
> manually (if you don't, the other one will be blank),
> which allows them to be different.
> 
> On 9/16/2018 10:59 PM, Adrien Monteleone wrote:
>> Think of the option as more like either you have numbers for transactions, 
>> or you have numbers for splits.
>> 
>> With the option unset, a payment transaction for example will have the same 
>> number both in the asset/liability register used to make/accept the payment 
>> and in the AP/AR register.
>> 
>> With the option set, you could have different numbers depending on which 
>> register you are viewing.
>> 
>> This might be useful in some cases to keep paperwork in sync. Your internal 
>> paperwork might use one number for a transaction but the external entity 
>> might use a different one. The option allows you to record both AND see each 
>> number in its proper perspective and context in your books.
>> 
>> Regards,
>> Adrien
>> 
>>> On Sep 16, 2018, at 10:07 PM, Paul Kinzelman  wrote:
>>> 
>>> I read the docs and don't really understand the "Use split Action field for 
>>> Number" purpose.
>>> It sounds like the Action field is moved to the Num field, and the Num is 
>>> hidden
>>> someplace else? And it's inaccessible?
>>> 
>>> Too bad the empty space can't be used for tag, that sounds like a great 
>>> solution.
>>> I'm surprised that it can't be.
>>> 
>>> However, it sounds like I can use the "Action" field for the Tag, and I
>>> understand that I have to be careful to make sure the spelling is correct.
>>> As long as I don't collide with one of the already populated items, seems
>>> like I should be OK.
>>> 
>>> Thanks!
>>> 
>>> On 9/16/2018 10:24 AM, John Ralls wrote:
 But don’t confuse an empty space on the grid for a field. There’s no “tag” 
 field, and adding one is complicated.
 
 There are already five free text fields in GnuCash, all searchable: 
 Number, Description and Notes are part of transactions, Action and Memo 
 are part of splits.  Action is a little weird in that it’s a combo 
 pre-populated with some values associated with certain GnuCash features so 
 using it as a class/tag/subcategory might require extra effort and might 
 interfere with a feature that uses it.
 
 There’s also the “Use split Action Field for Number” book option that 
 displays the register account split’s action field in the Num column of 
 the register, making the Number field inaccessible from the GUI.
 
 Since the fields are free text it requires user discipline to use any of 
 them for categorization: One must be careful to always spell the values 
 the same. Many users who want tags complain that that makes it too hard to 
 use free text fields for categorization, but a tweak

Re: [GNC] Omission from help manual: formulas

[Adrien Monteleone]

David & Stan,

From my experimentation, I think your descriptions are correct.

Exponents aren’t supported. (yet)

All formulas must be simple, but nesting/precedence parenthesis are allowed.

While you can’t calculate using other splits or transactions as 
references/variables, you *can* use variables.

For example, while in a discussion a few months ago on envelope budgeting, I 
decided to set up an SX to allocate my pay to my envelopes based on the 
percentages I chose for each. (this was still a very simple exercise since 
there was no way to ‘cap’ the allocation and have the excess flow elsewhere)

I set my Cash split in the SX template to ‘received * 1’
Then I set each envelope split to ‘received *’ the percentage I wanted to 
allocate there. (each ‘envelope’ was a subaccount of ‘envelopes’ which was a 
current asset account)

I couldn’t set the SX to fire only on entering a payment transaction, but I 
could schedule it weekly. (a use case for ’template’ transactions that can be 
fired on command, *not* just a schedule)

When it fired, I was asked for the value of ‘received’ and GnuCash then created 
the transaction with the appropriate splits and the proper allocations. (I seem 
to recall if rounding created an imbalance, it created an Orphan-USD split that 
I could correct or leave as is)

It was an interesting exercise, though I don’t use it due to various 
limitations for the intended purpose. But it is an illustration of using 
variables in SX templates and GnuCash will prompt you for those values, then 
use those values to finish the calculations.

Regards,
Adrien

> On Sep 17, 2018, at 8:50 AM, David T. via gnucash-user 
>  wrote:
> 
> Stan, 
> 
> I will preface this by repeating that I don’t use formulas or SX, so my 
> advice may be corrected by others. Addressing your questions in reverse order.
> 
> With regard to exponentiation, I note that the Bank Account Interest section 
> shows the expt (exponent) function (which comes from the underlying Scheme). 
> When I attempted to put this into a formula (“expt (tryme 2)”), however, I 
> got no results. Reading further down the wiki section, however, yields this: 
> "If the formula was simple, then you could just enter it directly in the 
> template transaction; unfortunately, the basic compounding-interest formula 
> involves exponentiation, which can't be handled in the current expression 
> parser, so one must resort to defining it in scheme…” Therefore, you must 
> place any formulas with exponentiation in a defined function in fin.scm.
> 
> As for computing one split based on another, the strong implication is that 
> this cannot be done. The section “formulas or scripts for periodic savings” 
> says two things. First, it starts by saying “if you can express the amounts 
> of the splits in the transaction as a simple expression,” which sets the 
> expectation that you will be using expressions (and not references) in 
> formulas. Second, it says there that formulas cannot “sum or obtain the value 
> from existing accounts,” which I interpret to mean that it cannot pull 
> information from different transactions. This, when you consider it, makes 
> sense: how would the formula evaluation process determine which split was to 
> be used?
> 
> I think the question of calculating one split based on another is covered in 
> the phone bill example, in which each split is derived independently, 
> demonstrating by example that you can’t compute one split based on another.
> 
> HTH,
> David
> 
>> On Sep 17, 2018, at 8:37 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> Stan, 
>> 
>> I neither use formulas nor scheduled transactions, so I can’t comment on the 
>> documentation. Since you do, maybe you could add some information on the 
>> wiki to assist others after you?
>> 
>>> On Sep 17, 2018, at 8:05 AM, Stan Brown  wrote:
>>> 
>>> Thank you for the reply, Frank, but I read that before I posted. That's 
>>> quite inadequate to tell people how to create formulas. 
>>> 
>>> The first three omissions that occur to me are: how do we use the value of 
>>> one split in computing the value for a different split?  How do we use 
>>> values from a specific other transaction to compute values for this one? 
>>> How do we do exponentiation, for goodness sake?
>>> 
>>> -- 
>>> Stan Brown
>>> the_stan_br...@fastmail.fm
>>> https://BrownMath.com
>>> http://OakRoadSystems.com/
>>> 
>>> On Mon, Sep 17, 2018, at 5:06 AM, Frank H. Ellenberger wrote:
 Hi Stan,
 Am 15.09.18 um 15:37 schrieb Stan Brown:
> Though I have 2.6.19, I looked on line at the 3.2 manuals, and they are
> the same in this respect.
 
 You missed one important place, the FAQ:
 https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_use_variables_and_formula_in_scheduled_transactions.3F
 that leads to
 https://wiki.gnucash.org/wiki/Scheduled_Transactions
 
 
> There doesn't seem to be any documentation of formulas for scheduled
> transactions. I'm talking

Re: [GNC] Omission from help manual: formulas

[David T. via gnucash-user]

> On Sep 17, 2018, at 11:29 AM, Adrien Monteleone 
>  wrote:
> 
> David & Stan,
> 
> From my experimentation, I think your descriptions are correct.
> 
> Exponents aren’t supported. (yet)

Since the email explanations date from 2005, I don’t think this will be added 
any time soon.

> 
> All formulas must be simple, but nesting/precedence parenthesis are allowed.
> 
> While you can’t calculate using other splits or transactions as 
> references/variables, you *can* use variables.
> 
> For example, while in a discussion a few months ago on envelope budgeting, I 
> decided to set up an SX to allocate my pay to my envelopes based on the 
> percentages I chose for each. (this was still a very simple exercise since 
> there was no way to ‘cap’ the allocation and have the excess flow elsewhere)
> 
> I set my Cash split in the SX template to ‘received * 1’
> Then I set each envelope split to ‘received *’ the percentage I wanted to 
> allocate there. (each ‘envelope’ was a subaccount of ‘envelopes’ which was a 
> current asset account)

This mirrors the examples in the wiki.

David

___
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] Compiling and Installing Gnucash 2.6.12

[Paul Schwartz]

the contents of ld.so.conf

paul@paul-Satellite-S855:/etc$ cat ld.so.conf
include /etc/ld.so.conf.d/*.conf

I have not run ld.conf ever. Should it have been part of make install?

Paul

On Sun, Sep 16, 2018 at 8:48 PM John Ralls  wrote:

> Is /usr/local/lib in /etc/ld.so.conf? Have you run ldconfig since building
> GnuCash?
>
> Regards,
> John Ralls
>
>
> > On Sep 16, 2018, at 6:52 PM, Paul Schwartz  wrote:
> >
> > here is the file/files in question
> >
> > paul@paul-Satellite-S855:/usr/local/lib$ ls -l libgnc-gnome*
> > -rwxr-xr-x 1 root root1939 Sep 12 09:11 libgnc-gnome.la
> > lrwxrwxrwx 1 root root  21 Sep 12 09:11 libgnc-gnome.so ->
> > libgnc-gnome.so.0.0.0
> > lrwxrwxrwx 1 root root  21 Sep 12 09:11 libgnc-gnome.so.0 ->
> > libgnc-gnome.so.0.0.0
> > -rwxr-xr-x 1 root root 3192456 Sep 12 09:11 libgnc-gnome.so.0.0.0
> >
> > Seem to be links to a real file in the same directory that is 3.2 MB
> > Paul
> >
> > On Sun, Sep 16, 2018 at 11:03 AM Geert Janssens <
> geert.gnuc...@kobaltwit.be>
> > wrote:
> >
> >> Op donderdag 13 september 2018 04:10:35 CEST schreef Paul Schwartz:
> >>> libgnc-gnome.so.0 is in /usr/local/lib
> >>>
> >> Is that a real file or a soft link ? If it's a softlink, does the file
> it
> >> points to exist ?
> >>
> >> How about file permissions ? Does the user you use to run gnucash have
> >> read
> >> access to this file or the file it points at ?
> >>
> >> Geert
> >>
> >>> How do I adjust the command so it is found?
> >>>
> >>> Paul
> >>>
> >>> On Wed, Sep 12, 2018 at 11:36 AM Stephen M. Butler 
> >> wrote:
>  On 09/12/2018 10:11 AM, Geert Janssens wrote:
> > Op woensdag 12 september 2018 17:50:23 CEST schreef Paul Schwartz:
> >> I have made some progress. Uninstalled and removed previous gnucash
> 
>  2.6.19
> 
> >> which is the default installed in Ubuntu 18.04. Successfully did
> >> ./configure && make followed by sudo make install.
> >>
> >> Executing gnucash produces
> >>
> >> /usr/local/bin/gnucash: error while loading shared libraries:
> >> libgnc-gnome.so.0: cannot open shared object file: No such file or
> 
>  directory
> 
> >> Did I miss an argument for install or ??
> >> Thanks for the help
> >> Paul
> >
> > Is the file really there ? It should be somewhere in /usr/local/lib
> >
> > Regards,
> >
> > Geert
> 
>  Since I had also compiled under Ubuntu, I looked on my system to see
>  where it was located.  Here are my findings:
>  steve@stevelaptop:~$ sudo su
>  [sudo] password for steve:
>  root@stevelaptop:/home/steve# cd /usr
>  root@stevelaptop:/usr# find . -name libgnc-gnome.so.0
>  root@stevelaptop:/usr# find . -name 'libgnc-gnome.*'
>  ./local/lib/libgnc-gnome.so
> 
>  See if that is on your system.
> 
>  --Steve
> 
>  --
>  Stephen M Butler, PMP, PSM
>  stephen.m.butle...@gmail.com
>  kg...@arrl.net
>  253-350-0166
>  ---
>  GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
> 
>  ___
>  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-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-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-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 l

Re: [GNC] Omission from help manual: formulas

[Stan Brown]

On Mon, Sep 17, 2018, at 8:37 AM, David T. wrote:

> I neither use formulas nor scheduled transactions, so I can’t comment on 
> the documentation. Since you do, maybe you could add some information on 
> the wiki to assist others after you?

If I had the knowledge I would, but I don't. That's why I was searching for 
documentation.

-- 
Stan Brown
the_stan_br...@fastmail.fm
https://BrownMath.com
http://OakRoadSystems.com/

___
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] Omission from help manual: formulas

[David T. via gnucash-user]

OK. Here’s the thing, I looked at the same information that you had, and I 
provided some explanations for your questions based on that information, so 
obviously something clicked for me that didn’t for you. It would be a help if 
you could try to figure out how the wiki could be better written so that 
someone coming along after you could better understand the limits and 
capabilities of formulas.

David

> On Sep 17, 2018, at 1:49 PM, Stan Brown  wrote:
> 
> On Mon, Sep 17, 2018, at 8:37 AM, David T. wrote:
> 
>> I neither use formulas nor scheduled transactions, so I can’t comment on 
>> the documentation. Since you do, maybe you could add some information on 
>> the wiki to assist others after you?
> 
> If I had the knowledge I would, but I don't. That's why I was searching for 
> documentation.
> 
> -- 
> Stan Brown
> the_stan_br...@fastmail.fm
> https://BrownMath.com
> http://OakRoadSystems.com/
> 

___
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] Another sort field like 'Class' in Quicken?

[Paul Kinzelman]

On 9/17/2018 8:16 AM, David T. wrote:

Paul,

This is a recent addition to the program. Since the documentation is also 
developed by volunteers (who are not necessarily the same as the people who 
write the program itself) documentation often lags behind the features. We rely 
on users like you to provide descriptions of features and how they get used. If 
you have a suggestion for this description, we’d welcome it.
I understand the issues with volunteer efforts. I did provide my 
understanding

of what you told me, perhaps that could be put into the docs. Is it a wiki?
Can I just go in there and do it?
But more importantly, is my summary correct? :-)


As an aside, I will note that it is my understanding that this setting is 
supposedly a one-time option—i.e., that once you select it, you shouldn’t 
change it back. But your comment sounds as if you have tried it both ways in 
your file without negative consequence. If the setting can be changed at a 
later time without problem, that would be important to know. Can you give 
further information on this?

No - I just saw the box and was trying to understand what it was for.
I haven't tried turning it on, I'm still just trying to understand what 
it does.

And that happened in my search for a Class/Tag field so I don't think I
even need to try to turn it on. It does look like the
Action field can be used for what I want.

So if my summary of what it does is correct, I'd update the wiki if it 
will allow

me to do that.


What exact version are you using, and on which operating system?

The latest download 3.2 on Windoz 10.


What is your file storage, SQL or XML? If XML, when you tried the different 
settings, did you save your file after each setting change?

default everything - XML. Didn't try it so I can't answer that question.


If you did save the file after changing the setting, did you in fact save the 
file with data in the affected fields?

David T.



On Sep 17, 2018, at 10:00 AM, Paul Kinzelman  wrote:

Wow, I did not get that out of what I read at all.
It'd be very useful for people I think if you updated the documentation
to say that.

So would a good summary be that if the box is unchecked, if you fill in
the number field in a transaction, it automagically propagates
to the other corresponding account register to keep them in sync.

If the box is checked, you have to fill in the numbers in both places
manually (if you don't, the other one will be blank),
which allows them to be different.

On 9/16/2018 10:59 PM, Adrien Monteleone wrote:

Think of the option as more like either you have numbers for transactions, or 
you have numbers for splits.

With the option unset, a payment transaction for example will have the same 
number both in the asset/liability register used to make/accept the payment and 
in the AP/AR register.

With the option set, you could have different numbers depending on which 
register you are viewing.

This might be useful in some cases to keep paperwork in sync. Your internal 
paperwork might use one number for a transaction but the external entity might 
use a different one. The option allows you to record both AND see each number 
in its proper perspective and context in your books.

Regards,
Adrien


On Sep 16, 2018, at 10:07 PM, Paul Kinzelman  wrote:

I read the docs and don't really understand the "Use split Action field for 
Number" purpose.
It sounds like the Action field is moved to the Num field, and the Num is hidden
someplace else? And it's inaccessible?

Too bad the empty space can't be used for tag, that sounds like a great 
solution.
I'm surprised that it can't be.

However, it sounds like I can use the "Action" field for the Tag, and I
understand that I have to be careful to make sure the spelling is correct.
As long as I don't collide with one of the already populated items, seems
like I should be OK.

Thanks!

On 9/16/2018 10:24 AM, John Ralls wrote:

But don’t confuse an empty space on the grid for a field. There’s no “tag” 
field, and adding one is complicated.

There are already five free text fields in GnuCash, all searchable: Number, 
Description and Notes are part of transactions, Action and Memo are part of 
splits.  Action is a little weird in that it’s a combo pre-populated with some 
values associated with certain GnuCash features so using it as a 
class/tag/subcategory might require extra effort and might interfere with a 
feature that uses it.

There’s also the “Use split Action Field for Number” book option that displays 
the register account split’s action field in the Num column of the register, 
making the Number field inaccessible from the GUI.

Since the fields are free text it requires user discipline to use any of them 
for categorization: One must be careful to always spell the values the same. 
Many users who want tags complain that that makes it too hard to use free text 
fields for categorization, but a tweak to the Action combo so that all previous 
entries for an action in spli

Re: [GNC] Error importing quicken 2017 qif / qfx

[Diogo Maciel]

I think it's a bug in the 3.2 version. Installed the 2.6 version and it
imported without problems

On Mon, Sep 17, 2018, 20:24 David T.,  wrote:

> Hello,
>
> In fact, the error is quite clear: something in the QIF file is not as the
> importer expects. As another David has noted, the QIF importer itself is
> functional, and has worked for many users before you. Unfortunately, in
> this case, that erro message is not particularly helpful, as your QIF file
> probably has a lot of transactions in it, any one of which could have
> caused the error. Locating such errors is, quite simply, a challenge.
>
> You might open your QIF file and try to determine whether anything looks
> out of order there, although that is difficult.
>
> You don’t say where you are located, but one of the most common situations
> that causes this error is date formatting. GnuCash attempts to guess
> whether you follow US-style date (MM-DD-) or European-style
> (DD-MM-), but often it fails to guess correctly. I believe it defaults
> to US-style (but I am sure the experts will correct me on this).
>
> One way forward for you at this time would be to try using a subset of
> your data to test the import first; if you can figure out how to get a
> smaller file to import, it will make additional imports easier. Many
> actually recommend using this piece-by-piece approach for import for this
> very reason.
>
> David
>
>
> > On Sep 16, 2018, at 12:19 PM, Diogo Maciel 
> wrote:
> >
> > Hi, hope someone can help me move out from Quicken
> >
> >
> >
> > I tried exporting my data from Quicken in both qif and qfx. The qif
> importer
> > gives me the error below
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Qfx will only show an empty window
> >
> >
> >
> >
> >
> >
> >
> > My file has multiple securities and currencies, so this may be relevant.
> I
> > understand that with such a generic error one may need more information,
> > which I can surely provide.
> >
> >
> >
> > Thanks!
> >
> >
> ___
> > 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-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] Error importing quicken 2017 qif / qfx

[Maf. King]

On Monday, 17 September 2018 17:10:10 BST Diogo Maciel wrote:
> I think it's a bug in the 3.2 version. Installed the 2.6 version and it
> imported without problems
> 

Or, logically, it could be a bug in 2.6.x to allow something bogus into GC 
(that has been fixed in 3.x)? 

0.02
Maf.



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