Re: [GNC] GNC csv import not displaying letters correctly from original file

[Jim DeLaHunt]

On 2023-08-29 14:42, avigr...@juno.com wrote:

Version: 4.12
Build ID: 4.12+(2022-09-24)Windows 11 computer When I import a csv file that 
contains Hebrew letters in the Description field, the letters display as 
question marks.  I changed the Import Encoding to Hebrew (Windows-1255).  Is 
there something else I need to do?


Ah, text file encoding problems!

What is the character encoding of the CSV file?  Are the bytes in that 
file indeed in the Windows-1255 encoding? Or are they perhaps in UTF-8?


It is important that the Import Encoding which you select match the 
actual encoding of the file you are importing.


I hope this is helpful, and not too self-evident.

Best regards,
    —Jim DeLaHunt

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] GNC csv import not displaying letters correctly from original file

[avigr...@juno.com]

Version: 4.12
Build ID: 4.12+(2022-09-24)Windows 11 computer When I import a csv file that 
contains Hebrew letters in the Description field, the letters display as 
question marks.  I changed the Import Encoding to Hebrew (Windows-1255).  Is 
there something else I need to do?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[Stephen M. Butler]

I presume that you will not have 100s of expense accounts.  You would 
have to do the mapping once per code word.  Just once.


On 8/24/23 16:21, jackielou wong wrote:
You mean ill do it manual for 100s transaction. Is that correct? How 
can i transfer in fastest way


On Fri, Aug 25, 2023, 7:01 AM Stephen M. Butler  wrote:

I have used the CSV importer several times to great advantage.  At a
minimum you need the following columns:

1.  Date -- be sure that you set the importer to the date format you
used.  I use MM/DD/.
2.  Description -- What you want in the transaction description.
3.  Account Code -- Something that will uniquely identify the "other
account".  I tend to use 3-4 character (sometime just 2) codes
easy for
me to remember.  These will get mapped (by you) to the real GnC
account
during the import process.
4.  Amount -- I sometimes have to specify that this is a negative
amount
(even though the file has positive values).

During the import you will have to specify the base account. This
will
be the checking account.  This is a field on the import screen --
not in
your file.
At some point you will map the above fields to tell the imported
which
one is the date, which one is the Other Account, which one is the
description and which one is the amount (or negative amount).

Test this out in a test environment first.

Save all your mapping to a file name so you can pull it back up
for real
(or for future use).  It is there on the setup screen.

At some point you will have the setup all done and will go NEXT.  At
this point it will list all the codes you used and ask you to map
those
to the real accounts (I presume expenses).

Good luck.

On 8/24/23 15:00, Stan Brown (using GC 4.14) wrote:
> On 2023-08-24 14:15, jackielou wong wrote:
>> I have 500 transactions under checking account for importing
files... how
>> can i put this all in linked accounts...
>>
>> Everytime i do that they fall to imbalance usd.. can you help
to fix it. So
> Jackielou,
>
> This suggestion may seem inefficient, but I think you might get
the job
> done faster by just entering the 500 transactions manually, which I
> imagine you know how to do.
>
> I've never done an import myself, but as I understand it you have to
> teach GnuCash to recognize transactions the way you want. That takes
> time, which you could be using to enter transactions right into
GC, a
> process I assume you are comfortable with. And 500 is really not
many.
>
> That's what I did in early 2018 when I converted my 2011-2017
data to
> GC. It was over 15,000 transactions, but once I got going it
went very
> quickly. Sure, I had to deal with each transaction individually,
but I
> would have had to check each one anyway if I had tried an
import. And
> along the way, I noticed inconsistencies in how I had treated
similar
> events, and fixed them. For me, at least, the process was less
painful
> than spending a lot of time learning and tinkering with a batch
import
> process that I would probably never need to use again.
>
> If you still want to pursue importing, I think it would be
helpful if
> you could be a lot more specific about what process you are
following,
> what results you see in GC, and what error message you get (if any).
> Maybe import _one_ transaction, and provide that information?
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[jackielou wong]

You mean ill do it manual for 100s transaction. Is that correct? How can i
transfer in fastest way

On Fri, Aug 25, 2023, 7:01 AM Stephen M. Butler  wrote:

> I have used the CSV importer several times to great advantage.  At a
> minimum you need the following columns:
>
> 1.  Date -- be sure that you set the importer to the date format you
> used.  I use MM/DD/.
> 2.  Description -- What you want in the transaction description.
> 3.  Account Code -- Something that will uniquely identify the "other
> account".  I tend to use 3-4 character (sometime just 2) codes easy for
> me to remember.  These will get mapped (by you) to the real GnC account
> during the import process.
> 4.  Amount -- I sometimes have to specify that this is a negative amount
> (even though the file has positive values).
>
> During the import you will have to specify the base account.  This will
> be the checking account.  This is a field on the import screen -- not in
> your file.
> At some point you will map the above fields to tell the imported which
> one is the date, which one is the Other Account, which one is the
> description and which one is the amount (or negative amount).
>
> Test this out in a test environment first.
>
> Save all your mapping to a file name so you can pull it back up for real
> (or for future use).  It is there on the setup screen.
>
> At some point you will have the setup all done and will go NEXT.  At
> this point it will list all the codes you used and ask you to map those
> to the real accounts (I presume expenses).
>
> Good luck.
>
> On 8/24/23 15:00, Stan Brown (using GC 4.14) wrote:
> > On 2023-08-24 14:15, jackielou wong wrote:
> >> I have 500 transactions under checking account for importing files...
> how
> >> can i put this all in linked accounts...
> >>
> >> Everytime i do that they fall to imbalance usd.. can you help to fix
> it. So
> > Jackielou,
> >
> > This suggestion may seem inefficient, but I think you might get the job
> > done faster by just entering the 500 transactions manually, which I
> > imagine you know how to do.
> >
> > I've never done an import myself, but as I understand it you have to
> > teach GnuCash to recognize transactions the way you want. That takes
> > time, which you could be using to enter transactions right into GC, a
> > process I assume you are comfortable with. And 500 is really not many.
> >
> > That's what I did in early 2018 when I converted my 2011-2017 data to
> > GC. It was over 15,000 transactions, but once I got going it went very
> > quickly. Sure, I had to deal with each transaction individually, but I
> > would have had to check each one anyway if I had tried an import. And
> > along the way, I noticed inconsistencies in how I had treated similar
> > events, and fixed them. For me, at least, the process was less painful
> > than spending a lot of time learning and tinkering with a batch import
> > process that I would probably never need to use again.
> >
> > If you still want to pursue importing, I think it would be helpful if
> > you could be a lot more specific about what process you are following,
> > what results you see in GC, and what error message you get (if any).
> > Maybe import _one_ transaction, and provide that information?
> >
> > Stan Brown
> > Tehachapi, CA, USA
> > https://BrownMath.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
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[Stephen M. Butler]

I have used the CSV importer several times to great advantage.  At a 
minimum you need the following columns:


1.  Date -- be sure that you set the importer to the date format you 
used.  I use MM/DD/.

2.  Description -- What you want in the transaction description.
3.  Account Code -- Something that will uniquely identify the "other 
account".  I tend to use 3-4 character (sometime just 2) codes easy for 
me to remember.  These will get mapped (by you) to the real GnC account 
during the import process.
4.  Amount -- I sometimes have to specify that this is a negative amount 
(even though the file has positive values).


During the import you will have to specify the base account.  This will 
be the checking account.  This is a field on the import screen -- not in 
your file.
At some point you will map the above fields to tell the imported which 
one is the date, which one is the Other Account, which one is the 
description and which one is the amount (or negative amount).


Test this out in a test environment first.

Save all your mapping to a file name so you can pull it back up for real 
(or for future use).  It is there on the setup screen.


At some point you will have the setup all done and will go NEXT.  At 
this point it will list all the codes you used and ask you to map those 
to the real accounts (I presume expenses).


Good luck.

On 8/24/23 15:00, Stan Brown (using GC 4.14) wrote:

On 2023-08-24 14:15, jackielou wong wrote:

I have 500 transactions under checking account for importing files... how
can i put this all in linked accounts...

Everytime i do that they fall to imbalance usd.. can you help to fix it. So

Jackielou,

This suggestion may seem inefficient, but I think you might get the job
done faster by just entering the 500 transactions manually, which I
imagine you know how to do.

I've never done an import myself, but as I understand it you have to
teach GnuCash to recognize transactions the way you want. That takes
time, which you could be using to enter transactions right into GC, a
process I assume you are comfortable with. And 500 is really not many.

That's what I did in early 2018 when I converted my 2011-2017 data to
GC. It was over 15,000 transactions, but once I got going it went very
quickly. Sure, I had to deal with each transaction individually, but I
would have had to check each one anyway if I had tried an import. And
along the way, I noticed inconsistencies in how I had treated similar
events, and fixed them. For me, at least, the process was less painful
than spending a lot of time learning and tinkering with a batch import
process that I would probably never need to use again.

If you still want to pursue importing, I think it would be helpful if
you could be a lot more specific about what process you are following,
what results you see in GC, and what error message you get (if any).
Maybe import _one_ transaction, and provide that information?

Stan Brown
Tehachapi, CA, USA
https://BrownMath.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[Stan Brown (using GC 4.14)]

On 2023-08-24 14:15, jackielou wong wrote:
> I have 500 transactions under checking account for importing files... how
> can i put this all in linked accounts...
> 
> Everytime i do that they fall to imbalance usd.. can you help to fix it. So

Jackielou,

This suggestion may seem inefficient, but I think you might get the job
done faster by just entering the 500 transactions manually, which I
imagine you know how to do.

I've never done an import myself, but as I understand it you have to
teach GnuCash to recognize transactions the way you want. That takes
time, which you could be using to enter transactions right into GC, a
process I assume you are comfortable with. And 500 is really not many.

That's what I did in early 2018 when I converted my 2011-2017 data to
GC. It was over 15,000 transactions, but once I got going it went very
quickly. Sure, I had to deal with each transaction individually, but I
would have had to check each one anyway if I had tried an import. And
along the way, I noticed inconsistencies in how I had treated similar
events, and fixed them. For me, at least, the process was less painful
than spending a lot of time learning and tinkering with a batch import
process that I would probably never need to use again.

If you still want to pursue importing, I think it would be helpful if
you could be a lot more specific about what process you are following,
what results you see in GC, and what error message you get (if any).
Maybe import _one_ transaction, and provide that information?

Stan Brown
Tehachapi, CA, USA
https://BrownMath.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[jackielou wong]

I have 500 transactions under checking account for importing files... how
can i put this all in linked accounts...

Everytime i do that they fall to imbalance usd.. can you help to fix it. So
i can do it in faster way.

Thank you



On Fri, Aug 25, 2023, 5:08 AM jackielou wong  wrote:

> The file that i give to you what is the proper transfer fir "deposit, "
> its under checking account. Can u send it bank sample
>
> On Fri, Aug 25, 2023, 5:06 AM David Cousens 
> wrote:
>
>> Jackielou,
>>
>> The file looks ok.  You will need to have created the accounts in the
>> transfer
>> column before importing. You may have to experiment with the header to
>> apply to
>> the amount column. Assuming you are importing the transactions into an
>> account
>> of type Asset, e.g. a bank account then normally assigning the deposit
>> header to
>> the column with the Amounts should import OK. Try a small sample first
>> and if it
>> doesn't import with debit transactions for the +ve amounts in the Amount
>> column
>> of your import file switch the header assigned to Withdrawal. For the
>> other
>> columns assigning the header that matches the column name  should be ok.
>> Make
>> sure the date format is "mm-dd-yyy" in the CSV setup dialogue.
>> Unfortunately
>> with CSV importing it takes a bit of fiddling but once you have a correct
>> setup
>> for importing for a given source you can save the setup and recall it
>> next time
>> you have to import from the same source
>>
>>
>> You will need to either specify transfer accounts for all the entries and
>> the
>> accounts will have to have been created prior to the import or you will
>> need to
>> assign them at the import matcher dialogue of the import procedure. You
>> can
>> create new accounts from the account tab while in the import matcher
>> dialogue
>> (while keeping it open) if they do not exist and then assign them to the
>> transactions in the import matcher dialogue. In most cases these appear
>> to be
>> transfers to the account you are importing into from another asset
>> account most
>> likely a main bank account to cover salary expenses.
>>
>> If this doesn't work for you can you post some screenshots of the import
>> matching process for the above file.
>>
>> David Cousens
>>
>>
>> On Thu, 2023-08-24 at 22:06 +0800, jackielou wong wrote:
>> > Hello
>> > i tried to import and csv file.
>> > Can you help me to transfer all of this into proper account; Here is my
>> > sample
>> >
>> > On Thu, Aug 24, 2023 at 9:36 PM Murugan Muruganandam <
>> > m.muruganan...@hotmail.com> wrote:
>> >
>> > > hi Jack
>> > >
>> > > can you be more specific on what help you are looking for.  there are
>> > > quite a few knowlede base online
>> > >
>> > >
>> > >
>> > > Saludos Cordiales
>> > >
>> > >
>> > > Murugan
>> > > --
>> > > *From:* gnucash-user > > > hotmail@gnucash.org> on behalf of jackielou wong <
>> > > jcklcalim...@gmail.com>
>> > > *Sent:* Thursday, August 24, 2023 12:07 AM
>> > > *To:* john 
>> > > *Cc:* gnucash-user@gnucash.org 
>> > > *Subject:* Re: [GNC] get quotes via gnucash-cli for unknown quote
>> source
>> > >
>> > > Hello there
>> > >
>> > > Can i ask for importing 100 transactions using csv.
>> > >
>> > > On Thu, Aug 24, 2023, 12:00 PM john  wrote:
>> > >
>> > > >
>> > > >
>> > > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
>> > > > gnucash-user@gnucash.org> wrote:
>> > > > >
>> > > > > Hi,
>> > > > >
>> > > > > I've been trying to get quotes via gnucash-cli with the following
>> > > > command:
>> > > > >
>> > > > > gnucash-cli --quotes get mysql://
>> > > > >
>> > > > > However, I get the following message when executing the command
>> and no
>> > > > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch
>> called with
>> > > > no commodities.'
>> > > > >
>> > > > > All of my quote sources are of type 'Unknown' (tradegate,
>> fondsweb).
>> > > > >
>> > > > > When I get the quotes via 'Get Quotes' in the Price Database, the
>> > > quotes
>> > > > are fetched normally, so it seems to be a problem with the CLI.
>> > > > >
>> > > > > After some investigation, I found out 2 things:
>> > > > >
>> > > > > 1. When switching the quote source for a security to a source
>> that is
>> > > > not Unknown, the CLI is able to fetch that security's quote.
>> > > > >
>> > > > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add
>> the
>> > > > tradegate and fondsweb sources to the 'single_quote_sources'
>> variable
>> > > (thus
>> > > > making them known sources), the CLI is able to fetch all quotes, no
>> more
>> > > > errors.
>> > > > >
>> > > > > This leads me to believe that the CLI fetching ignores securities
>> where
>> > > > the quote source is Unknown, whereas the GUI fetches the quotes
>> > > regardless
>> > > > of the quote source. I was not able to pin down this behavior in the
>> > > > source, but maybe somebody can clarify whether this is the desired
>> > > behavior
>> > > > for the CLI.
>> > > > >

Re: [GNC] CSV Import

[jackielou wong]

The file that i give to you what is the proper transfer fir "deposit, " its
under checking account. Can u send it bank sample

On Fri, Aug 25, 2023, 5:06 AM David Cousens 
wrote:

> Jackielou,
>
> The file looks ok.  You will need to have created the accounts in the
> transfer
> column before importing. You may have to experiment with the header to
> apply to
> the amount column. Assuming you are importing the transactions into an
> account
> of type Asset, e.g. a bank account then normally assigning the deposit
> header to
> the column with the Amounts should import OK. Try a small sample first and
> if it
> doesn't import with debit transactions for the +ve amounts in the Amount
> column
> of your import file switch the header assigned to Withdrawal. For the other
> columns assigning the header that matches the column name  should be ok.
> Make
> sure the date format is "mm-dd-yyy" in the CSV setup dialogue.
> Unfortunately
> with CSV importing it takes a bit of fiddling but once you have a correct
> setup
> for importing for a given source you can save the setup and recall it next
> time
> you have to import from the same source
>
>
> You will need to either specify transfer accounts for all the entries and
> the
> accounts will have to have been created prior to the import or you will
> need to
> assign them at the import matcher dialogue of the import procedure. You can
> create new accounts from the account tab while in the import matcher
> dialogue
> (while keeping it open) if they do not exist and then assign them to the
> transactions in the import matcher dialogue. In most cases these appear to
> be
> transfers to the account you are importing into from another asset account
> most
> likely a main bank account to cover salary expenses.
>
> If this doesn't work for you can you post some screenshots of the import
> matching process for the above file.
>
> David Cousens
>
>
> On Thu, 2023-08-24 at 22:06 +0800, jackielou wong wrote:
> > Hello
> > i tried to import and csv file.
> > Can you help me to transfer all of this into proper account; Here is my
> > sample
> >
> > On Thu, Aug 24, 2023 at 9:36 PM Murugan Muruganandam <
> > m.muruganan...@hotmail.com> wrote:
> >
> > > hi Jack
> > >
> > > can you be more specific on what help you are looking for.  there are
> > > quite a few knowlede base online
> > >
> > >
> > >
> > > Saludos Cordiales
> > >
> > >
> > > Murugan
> > > --
> > > *From:* gnucash-user  > > hotmail@gnucash.org> on behalf of jackielou wong <
> > > jcklcalim...@gmail.com>
> > > *Sent:* Thursday, August 24, 2023 12:07 AM
> > > *To:* john 
> > > *Cc:* gnucash-user@gnucash.org 
> > > *Subject:* Re: [GNC] get quotes via gnucash-cli for unknown quote
> source
> > >
> > > Hello there
> > >
> > > Can i ask for importing 100 transactions using csv.
> > >
> > > On Thu, Aug 24, 2023, 12:00 PM john  wrote:
> > >
> > > >
> > > >
> > > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
> > > > gnucash-user@gnucash.org> wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > I've been trying to get quotes via gnucash-cli with the following
> > > > command:
> > > > >
> > > > > gnucash-cli --quotes get mysql://
> > > > >
> > > > > However, I get the following message when executing the command
> and no
> > > > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called
> with
> > > > no commodities.'
> > > > >
> > > > > All of my quote sources are of type 'Unknown' (tradegate,
> fondsweb).
> > > > >
> > > > > When I get the quotes via 'Get Quotes' in the Price Database, the
> > > quotes
> > > > are fetched normally, so it seems to be a problem with the CLI.
> > > > >
> > > > > After some investigation, I found out 2 things:
> > > > >
> > > > > 1. When switching the quote source for a security to a source that
> is
> > > > not Unknown, the CLI is able to fetch that security's quote.
> > > > >
> > > > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add
> the
> > > > tradegate and fondsweb sources to the 'single_quote_sources' variable
> > > (thus
> > > > making them known sources), the CLI is able to fetch all quotes, no
> more
> > > > errors.
> > > > >
> > > > > This leads me to believe that the CLI fetching ignores securities
> where
> > > > the quote source is Unknown, whereas the GUI fetches the quotes
> > > regardless
> > > > of the quote source. I was not able to pin down this behavior in the
> > > > source, but maybe somebody can clarify whether this is the desired
> > > behavior
> > > > for the CLI.
> > > > >
> > > > > Tested with most recent stable branch and Flatpak version 5.3, F::Q
> > > > versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
> > > >
> > > > Not desired behavior but not surprising either: In order to know
> about
> > > the
> > > > unknown quote source gnucash-cli -Q get needs to retrieve them from
> F::Q
> > > > and it doesn't do that. Shouldn't be too hard to fix, but please
> file a
> > > bug
> > > > so that the problem d

Re: [GNC] CSV Import

[David Cousens]

Jackielou,

The file looks ok.  You will need to have created the accounts in the transfer
column before importing. You may have to experiment with the header to apply to
the amount column. Assuming you are importing the transactions into an account
of type Asset, e.g. a bank account then normally assigning the deposit header to
the column with the Amounts should import OK. Try a small sample first and if it
doesn't import with debit transactions for the +ve amounts in the Amount column
of your import file switch the header assigned to Withdrawal. For the other
columns assigning the header that matches the column name  should be ok. Make
sure the date format is "mm-dd-yyy" in the CSV setup dialogue. Unfortunately
with CSV importing it takes a bit of fiddling but once you have a correct setup
for importing for a given source you can save the setup and recall it next time
you have to import from the same source


You will need to either specify transfer accounts for all the entries and the
accounts will have to have been created prior to the import or you will need to
assign them at the import matcher dialogue of the import procedure. You can
create new accounts from the account tab while in the import matcher dialogue
(while keeping it open) if they do not exist and then assign them to the
transactions in the import matcher dialogue. In most cases these appear to be
transfers to the account you are importing into from another asset account most
likely a main bank account to cover salary expenses.

If this doesn't work for you can you post some screenshots of the import
matching process for the above file.

David Cousens


On Thu, 2023-08-24 at 22:06 +0800, jackielou wong wrote:
> Hello
> i tried to import and csv file.
> Can you help me to transfer all of this into proper account; Here is my
> sample
> 
> On Thu, Aug 24, 2023 at 9:36 PM Murugan Muruganandam <
> m.muruganan...@hotmail.com> wrote:
> 
> > hi Jack
> > 
> > can you be more specific on what help you are looking for.  there are
> > quite a few knowlede base online
> > 
> > 
> > 
> > Saludos Cordiales
> > 
> > 
> > Murugan
> > --
> > *From:* gnucash-user  > hotmail@gnucash.org> on behalf of jackielou wong <
> > jcklcalim...@gmail.com>
> > *Sent:* Thursday, August 24, 2023 12:07 AM
> > *To:* john 
> > *Cc:* gnucash-user@gnucash.org 
> > *Subject:* Re: [GNC] get quotes via gnucash-cli for unknown quote source
> > 
> > Hello there
> > 
> > Can i ask for importing 100 transactions using csv.
> > 
> > On Thu, Aug 24, 2023, 12:00 PM john  wrote:
> > 
> > > 
> > > 
> > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
> > > gnucash-user@gnucash.org> wrote:
> > > > 
> > > > Hi,
> > > > 
> > > > I've been trying to get quotes via gnucash-cli with the following
> > > command:
> > > > 
> > > > gnucash-cli --quotes get mysql://
> > > > 
> > > > However, I get the following message when executing the command and no
> > > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with
> > > no commodities.'
> > > > 
> > > > All of my quote sources are of type 'Unknown' (tradegate, fondsweb).
> > > > 
> > > > When I get the quotes via 'Get Quotes' in the Price Database, the
> > quotes
> > > are fetched normally, so it seems to be a problem with the CLI.
> > > > 
> > > > After some investigation, I found out 2 things:
> > > > 
> > > > 1. When switching the quote source for a security to a source that is
> > > not Unknown, the CLI is able to fetch that security's quote.
> > > > 
> > > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add the
> > > tradegate and fondsweb sources to the 'single_quote_sources' variable
> > (thus
> > > making them known sources), the CLI is able to fetch all quotes, no more
> > > errors.
> > > > 
> > > > This leads me to believe that the CLI fetching ignores securities where
> > > the quote source is Unknown, whereas the GUI fetches the quotes
> > regardless
> > > of the quote source. I was not able to pin down this behavior in the
> > > source, but maybe somebody can clarify whether this is the desired
> > behavior
> > > for the CLI.
> > > > 
> > > > Tested with most recent stable branch and Flatpak version 5.3, F::Q
> > > versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
> > > 
> > > Not desired behavior but not surprising either: In order to know about
> > the
> > > unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q
> > > and it doesn't do that. Shouldn't be too hard to fix, but please file a
> > bug
> > > so that the problem doesn't get lost in mailing list entropy.
> > > 
> > > Regards,
> > > John Ralls
> > > 
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by usin

Re: [GNC] CSV Import

[jackielou wong]

Hello
i tried to import and csv file.
Can you help me to transfer all of this into proper account; Here is my
sample

On Thu, Aug 24, 2023 at 9:36 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> hi Jack
>
> can you be more specific on what help you are looking for.  there are
> quite a few knowlede base online
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of jackielou wong <
> jcklcalim...@gmail.com>
> *Sent:* Thursday, August 24, 2023 12:07 AM
> *To:* john 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] get quotes via gnucash-cli for unknown quote source
>
> Hello there
>
> Can i ask for importing 100 transactions using csv.
>
> On Thu, Aug 24, 2023, 12:00 PM john  wrote:
>
> >
> >
> > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> > >
> > > Hi,
> > >
> > > I've been trying to get quotes via gnucash-cli with the following
> > command:
> > >
> > > gnucash-cli --quotes get mysql://
> > >
> > > However, I get the following message when executing the command and no
> > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with
> > no commodities.'
> > >
> > > All of my quote sources are of type 'Unknown' (tradegate, fondsweb).
> > >
> > > When I get the quotes via 'Get Quotes' in the Price Database, the
> quotes
> > are fetched normally, so it seems to be a problem with the CLI.
> > >
> > > After some investigation, I found out 2 things:
> > >
> > > 1. When switching the quote source for a security to a source that is
> > not Unknown, the CLI is able to fetch that security's quote.
> > >
> > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add the
> > tradegate and fondsweb sources to the 'single_quote_sources' variable
> (thus
> > making them known sources), the CLI is able to fetch all quotes, no more
> > errors.
> > >
> > > This leads me to believe that the CLI fetching ignores securities where
> > the quote source is Unknown, whereas the GUI fetches the quotes
> regardless
> > of the quote source. I was not able to pin down this behavior in the
> > source, but maybe somebody can clarify whether this is the desired
> behavior
> > for the CLI.
> > >
> > > Tested with most recent stable branch and Flatpak version 5.3, F::Q
> > versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
> >
> > Not desired behavior but not surprising either: In order to know about
> the
> > unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q
> > and it doesn't do that. Shouldn't be too hard to fix, but please file a
> bug
> > so that the problem doesn't get lost in mailing list entropy.
> >
> > Regards,
> > John Ralls
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
Id,Date,Desc,transfer,Amount
1,06/27/2020,Deposit bofa,,3
2,06/30/2020, LLC : QUICKBOOKS ID: ,,1881.34
3,06/30/2020,LLC : QUICKBOOKS ID: 1722616653CO: ,,18000
4,06/30/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,0.82
5,07/21/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 7764315,,-0.56
6,07/21/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 7764314,,-0.94
7,07/28/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8116937,,0.56
8,07/28/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8116938,,0.94
9,07/28/2020, LLC : QUICKBOOKS ID: 1722616653CO:  LLC Entry Class Code: PPD ACH : 8223375,,2000.65
10,07/28/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8116939  (),Expenses:salary,-2002.4
11,07/30/2020, LLC : QUICKBOOKS ID: 1722616653CO:  LLC Entry Class Code: PPD ACH : 3946318,,2000.66
12,07/30/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 3220527 (),Expenses:salary,-2002.41
13,07/31/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,12.58
14,08/13/2020, LLC : QUICKBOOKS ID: 1722616653CO:  LLC Entry Class Code: PPD ACH : 9675915,,2000.66
15,08/13/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH 

[GNC] CSV Import

[Murugan Muruganandam]

hi Jack

can you be more specific on what help you are looking for.  there are quite a 
few knowlede base online




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
jackielou wong 
Sent: Thursday, August 24, 2023 12:07 AM
To: john 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] get quotes via gnucash-cli for unknown quote source

Hello there

Can i ask for importing 100 transactions using csv.

On Thu, Aug 24, 2023, 12:00 PM john  wrote:

>
>
> > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > Hi,
> >
> > I've been trying to get quotes via gnucash-cli with the following
> command:
> >
> > gnucash-cli --quotes get mysql://
> >
> > However, I get the following message when executing the command and no
> quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with
> no commodities.'
> >
> > All of my quote sources are of type 'Unknown' (tradegate, fondsweb).
> >
> > When I get the quotes via 'Get Quotes' in the Price Database, the quotes
> are fetched normally, so it seems to be a problem with the CLI.
> >
> > After some investigation, I found out 2 things:
> >
> > 1. When switching the quote source for a security to a source that is
> not Unknown, the CLI is able to fetch that security's quote.
> >
> > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add the
> tradegate and fondsweb sources to the 'single_quote_sources' variable (thus
> making them known sources), the CLI is able to fetch all quotes, no more
> errors.
> >
> > This leads me to believe that the CLI fetching ignores securities where
> the quote source is Unknown, whereas the GUI fetches the quotes regardless
> of the quote source. I was not able to pin down this behavior in the
> source, but maybe somebody can clarify whether this is the desired behavior
> for the CLI.
> >
> > Tested with most recent stable branch and Flatpak version 5.3, F::Q
> versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
>
> Not desired behavior but not surprising either: In order to know about the
> unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q
> and it doesn't do that. Shouldn't be too hard to fix, but please file a bug
> so that the problem doesn't get lost in mailing list entropy.
>
> Regards,
> John Ralls
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV import crash in 5.0+

[Geert Janssens]

Op vrijdag 21 april 2023 04:59:40 CEST schreef John Ralls:
> > On Apr 20, 2023, at 6:52 AM, Joseph Vernice  wrote:
> > 
> > I am using the nightly build 5.0.77 on Windows 11.  Ever since upgrading
> > to
> > 5.0 (and above nightly builds) I am unable to import transactions from
> > CSV.  The system crashes when I select the CSV import profile or when I
> > try
> > to create a new one.  The crash accors immediately after selecting the
> > profile OR after assigning the AMOUNT column. I have resorted to the
> > latest
> > pre-5.0 build in order to import from CSV.  Unfortunately, my Fidelity
> > checking account only allows for CSV export, so this is an essential means
> > for me to import into gnucash. Thank you everyone for all your help.
> 
> There are two open CSV crashers,
> https://bugs.gnucash.org/show_bug.cgi?id=798799 and
> https://bugs.gnucash.org/show_bug.cgi?id=798830. The first is about the CSV
> having fewer fields in the first line than in the second and while GnuCash
> shouldn't crash in that case IMO it should reject the file as ill-formed.
> The second involves entries having a '/' character.
> 
> If your problem file matches neither of those please file a new bug report.
> Be sure to attach the trace file[1] and if possible a stack trace[2].
> 
> Regards,
> John Ralls
> 
> [1] https://wiki.gnucash.org/wiki/Tracefile
> [2] https://wiki.gnucash.org/wiki/Stack_Trace
> 
> 
If GnuCash crashes then this is very likely the same issues as
https://bugs.gnucash.org/show_bug.cgi?id=798877
(https://bugs.gnucash.org/show_bug.cgi?id=798799 is a duplicate of this one)

That issue has now been fixed and will appear in tomorrow's nightly. You can 
try that one to 
test if you like.

Regards,

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV import crash in 5.0+

[R Losey]

Also speaking as a pro, this topic of error checking causes quite a lot of
debate at work.

We all agree that input from users (and other untrusted sources) should be
fully error-checked (and, for this case of CSV import data, I agree it
should be considered untrusted).

But when there is an agreed-upon machine interface from A to B, if A
violates the interface and crashes B, that is A's problem [this is my
position, and many support it; however, the other position is that B should
not crash and should always do sufficient checking so that it does not
crash]. Likewise, calls to system services are considered trustworthy, so
the results are not error-checked... (the status may be checked for a
problem, but the data is generally considered safe; for example, I don't
know of anyone who error-checks the call to get the current time.)


On Thu, Apr 20, 2023 at 6:12 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> However, speaking as a retired pro, I would consider a program crashing
> on ANY bad input to be a bug << a failure of its "input editing" >>
>
> It is (should be) the responsibility of a program to check incoming data
> and reject any data that is bad (preferably with a meaningful error
> message). Programs should NOT trust that they will always be given good
> input.
>
>
> Michael D Novack
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV import crash in 5.0+

[John Ralls]

> On Apr 20, 2023, at 6:52 AM, Joseph Vernice  wrote:
> 
> I am using the nightly build 5.0.77 on Windows 11.  Ever since upgrading to
> 5.0 (and above nightly builds) I am unable to import transactions from
> CSV.  The system crashes when I select the CSV import profile or when I try
> to create a new one.  The crash accors immediately after selecting the
> profile OR after assigning the AMOUNT column. I have resorted to the latest
> pre-5.0 build in order to import from CSV.  Unfortunately, my Fidelity
> checking account only allows for CSV export, so this is an essential means
> for me to import into gnucash. Thank you everyone for all your help.

There are two open CSV crashers, 
https://bugs.gnucash.org/show_bug.cgi?id=798799 and 
https://bugs.gnucash.org/show_bug.cgi?id=798830. The first is about the CSV 
having fewer fields
in the first line than in the second and while GnuCash shouldn't crash in that 
case IMO it should
reject the file as ill-formed. The second involves entries having a '/' 
character.

If your problem file matches neither of those please file a new bug report. Be 
sure to attach
the trace file[1] and if possible a stack trace[2].

Regards,
John Ralls

[1] https://wiki.gnucash.org/wiki/Tracefile
[2] https://wiki.gnucash.org/wiki/Stack_Trace


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV import crash in 5.0+

[Michael or Penny Novack]

On 4/20/2023 6:58 PM, Stephen M. Butler wrote:
I have been running 5.0.77 on Ubuntu and importing CSV transactions 
without problems.  So this may be tied to Windows. 


However, speaking as a retired pro, I would consider a program crashing 
on ANY bad input to be a bug << a failure of its "input editing" >>


It is (should be) the responsibility of a program to check incoming data 
and reject any data that is bad (preferably with a meaningful error 
message). Programs should NOT trust that they will always be given good 
input.



Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV import crash in 5.0+

[Stephen M. Butler]

I have been running 5.0.77 on Ubuntu and importing CSV transactions 
without problems.  So this may be tied to Windows.



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

On 4/20/23 06:52, Joseph Vernice wrote:

I am using the nightly build 5.0.77 on Windows 11.  Ever since upgrading to
5.0 (and above nightly builds) I am unable to import transactions from
CSV.  The system crashes when I select the CSV import profile or when I try
to create a new one.  The crash accors immediately after selecting the
profile OR after assigning the AMOUNT column. I have resorted to the latest
pre-5.0 build in order to import from CSV.  Unfortunately, my Fidelity
checking account only allows for CSV export, so this is an essential means
for me to import into gnucash. Thank you everyone for all your help.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] CSV Import Crash in GNC 5.0+

[Joseph Vernice]

I am using the nightly build 5.0.77 on Windows 11.  Ever since upgrading to
5.0 (and above nightly builds) I am unable to import transactions from
CSV.  The system crashes when I select the CSV import profile or when I try
to create a new one.  The crash occurs immediately after selecting the
profile OR after assigning the AMOUNT column when creating a new one.
I have resorted to the latest
pre-5.0 build (4.14) in order to import from CSV.  Unfortunately, my Fidelity
checking account only allows for CSV export, so this is an essential means
for me to import into gnucash. Thank you everyone for all your help.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] CSV import crash in 5.0+

[Joseph Vernice]

I am using the nightly build 5.0.77 on Windows 11.  Ever since upgrading to
5.0 (and above nightly builds) I am unable to import transactions from
CSV.  The system crashes when I select the CSV import profile or when I try
to create a new one.  The crash accors immediately after selecting the
profile OR after assigning the AMOUNT column. I have resorted to the latest
pre-5.0 build in order to import from CSV.  Unfortunately, my Fidelity
checking account only allows for CSV export, so this is an essential means
for me to import into gnucash. Thank you everyone for all your help.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import Problem

[David Cousens]

Charles,

If you look at the Withdrawal and Deposit columns in the Import Wizard, you will
notice that the entries in the Withdrawal column  are negative while those in
the Deposit column are positive quantities. 

GnuCash can import data in a single column format where both the Withdrawal and
Deposit Amounts are in the same colum but they have different signs. Where they
are separate columns for the Withdrawals and Deposits from an account GnuCash
reasonably expects both columns to be positive quantities. 

This is generally the default format for a bank which will normally record
deposits to your bank account as Credits and withdrawals fromn your account as
Debits. This is because the bank treats your accounmt in their hands as a
liability to them, whereas in your accounts it is an asset and debit and credit
amounts are normally recorded in accounting practice as positive quantities.

What has happened is that when GnuCash has imported the data, it has treated
both the Withdrawal and Deposit column entries as Debit entries to the account
in GnuCash which is why you have the incorrect positive balance.

To fix this you can either change the negative quantities in the Withdrawal
column to positive numbers and then try re importing or you can combine the
numbers in those two columns into a single column into a single column and
retain the signs. 

If you create a single column assigning the Deposit header to that column should
give you a correct import. If it doesn't give you the correct balance then you
may need to assign the Withdrawal headerbut it has always worked for me
assigning the Deposit header.


David Cousens


On Thu, 2022-09-15 at 16:12 +1000, cav...@bigpond.net.au wrote:
> Hello David,
> 
>  
> 
> Thank you for responding and I appreciate your assistance.
> 
>  
> 
> I took your advice and reduce the CSV file down from 304 transactions and a
> large number of accounts to just one account and 21 transaction.  I have
> attached this CSV file to this email.  Below you will see the import mapping
> in GNUcash.
> 
>  
> 
> The account number 2000 is a current asset bank account in GNUcash and after
> the CSV import the balance should be zero dollars.  I have attached a print of
> account 2000 transaction file and you will see the transaction total is
> $176,836.38 and the account total is $177,661.76 and should be zero. 
> 
>  
> 
>  
> 
> Screen shots of the mapping for the CSV file import:
> 
>  
> 
> 
> 
>  
> 
> 
> 
>  
> 
> 
> 
>  
> 
> Kind regards
> 
> Charles Avery
> 
>  
> 
> Mob: 0404 242 278
> 
>  
> 
> From: David Carlson  
> Sent: Wednesday, 14 September 2022 10:56 PM
> To: cav...@bigpond.net.au
> Cc: mailman-requ...@gnucash.org; gnucash-user@gnucash.org
> Subject: Re: [GNC] CSV Import Problem
> 
>  
> 
> There is a huge amount of flexibility in the CSV importer, and it has been
> working well for a long time.
> 
>  
> 
> It is far more likely that there is an error in your configuration or the
> source file.  Did you start with a small test file with just enough
> transactions to verify that your configuration is doing what you expect?  I am
> not familiar with Moneyspire so I don't know if you have many accounts,
> perhaps a mix of assets and liabilities that could provide further
> complication.
> 
>  
> 
> We would need more specific details to help you further.
> 
>  
> 
> On Wed, Sep 14, 2022 at 6:05 AM
> mailto:cav...@bigpond.net.au> > wrote:
> 
> Hi,
> 
> 
> 
> I am running GNUcash version 4.11 on Windows 11.
> 
> 
> 
> I have created a CSV file from Moneyspire and I want to import this into
> GNUcash however many of the credits to the bank accounts are treated as
> debits and debits treated as credits but not always.  I have inspected the
> CSV file with Excel and also Wordpad and it looks fine.  It would appear
> GNUcash has a problem with CSV files.
> 
> 
> 
> Regards
> 
> Charles Avery
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import Problem

[David Carlson]

There is a huge amount of flexibility in the CSV importer, and it has been
working well for a long time.

It is far more likely that there is an error in your configuration or the
source file.  Did you start with a small test file with just enough
transactions to verify that your configuration is doing what you expect?  I
am not familiar with Moneyspire so I don't know if you have many accounts,
perhaps a mix of assets and liabilities that could provide further
complication.

We would need more specific details to help you further.

On Wed, Sep 14, 2022 at 6:05 AM  wrote:

> Hi,
>
>
>
> I am running GNUcash version 4.11 on Windows 11.
>
>
>
> I have created a CSV file from Moneyspire and I want to import this into
> GNUcash however many of the credits to the bank accounts are treated as
> debits and debits treated as credits but not always.  I have inspected the
> CSV file with Excel and also Wordpad and it looks fine.  It would appear
> GNUcash has a problem with CSV files.
>
>
>
> Regards
>
> Charles Avery
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] CSV Import Problem

[cavery]

Hi,

 

I am running GNUcash version 4.11 on Windows 11.

 

I have created a CSV file from Moneyspire and I want to import this into
GNUcash however many of the credits to the bank accounts are treated as
debits and debits treated as credits but not always.  I have inspected the
CSV file with Excel and also Wordpad and it looks fine.  It would appear
GNUcash has a problem with CSV files.

 

Regards

Charles Avery

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] csv import not displaying letters correctly from original file

[John Ralls]

> On Jul 24, 2022, at 3:31 PM, avigr...@juno.com wrote:
> 
> I am using Version: 4.10 Build ID: 4.10+(2022-03-26) on a Windows 10 
> computer. When I import a csv file that contains Hebrew letters in a field, 
> the letters display as question marks.  Is there an option to import the 
> characters and have them display just like they appear or is there a 
> translate option into English?

You have to set the import encoding to match the csv file's encoding on the 
third page of the import assistant, the one where you mapped your import 
columns to the corresponding GnuCash fields. See the attached screenshot.

You probably want the Windows-1255 one.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] csv import not displaying letters correctly from original file

[avigr...@juno.com]

I am using Version: 4.10 Build ID: 4.10+(2022-03-26) on a Windows 10 computer. 
When I import a csv file that contains Hebrew letters in a field, the letters 
display as question marks.  Is there an option to import the characters and 
have them display just like they appear or is there a translate option into 
English?
___
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] CSV Import Reconciled field

[Kalpesh Patel]

I joined up later in the 3.X releases so likely missed the earlier notes and 
didn’t go in the past version to catch-up on it. 

 

I also was looking for much easier way to import, similar to importing bank 
debit/credit transactions, as my format looks like this:

 


Date

Investment

Transaction Type

Amount

Shares/Unit


4/28/2020

JPM EQUITY INCOME R6

DIVIDEND

3.23

0.2


4/2/2020

JPM EQUITY INCOME R6

REALIZED G/L

-0.36

0


4/2/2020

JPM EQUITY INCOME R6

ADVISOR / CONSULTANT FEE

-1.66

-0.116


3/13/2020

JPM EQUITY INCOME R6

CONTRIBUTION

53.96

   3.448


 

 

 

 

 

 

But I assume that I am not going to succeed without some preprocessing to get 
aligned what csv importer is expecting.

 

From: David Carlson  
Sent: Tuesday, November 16, 2021 1:00 PM
To: Kalpesh Patel 
Cc: Ove Grunnér ; Gnucash Users 
Subject: Re: [GNC] CSV Import Reconciled field

 

Kalpesh,

 

When the CSV importer was upgraded early in the release 3.x series, it was 
intended to work with investment transactions.  It is designed to import the 
majority of variations available in split transactions with more than two 
splits.  

 

I am starting to test it with my investment accounts in release 3.8 in Ubuntu, 
and finding that I need to do some fine tuning, but I need to do more testing 
for my case.  However, I think that the reconciliation flag code may be working 
in that release, but I simply accepted the standard treatment. 

 

On Tue, Nov 16, 2021 at 11:31 AM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

Hi Ove - 



I was curious what types of Stock Transactions you are importing properly
via CSV format into GNC.



I was under the belief that purchase/sale of securities/commodities was not
supported via CSV import process in GNC (or I was mistaken) so if it is
possible then I wouldn't mind learning how to accomplish that.



I have always fallen back with QIF import for importing stocks/securities
transactions if OFX/QFX isn't supported by the broker as QIF format provided
much better control of transactions being imported. I can also export from
Quicken, manipulate, and then import to keep GNC up-to-date if need be.



--



Message: 7

Date: Tue, 16 Nov 2021 09:00:35 -0600

From: David Carlson mailto:david.carlson@gmail.com> 
<mailto:david.carlson@gmail.com <mailto:david.carlson@gmail.com> > >

To: Ove Grunn?r mailto:write2...@gmail.com>  
<mailto:write2...@gmail.com <mailto:write2...@gmail.com> > >

Cc: gnucash-user mailto:gnucash-user@gnucash.org>  
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >
>

Subject: Re: [GNC] CSV Import Reconciled field

Message-ID:


mailto:cadygsbk2db66tmfy_nuec%2bytnfdjjvrvpiqxjpisyaobtx0...@mail.gmail.com> 
<mailto:cadygsbk2db66tmfy_nuec+ytnfdjjvrvpiqxjpisyaobtx0...@mail.gmail.com 
<mailto:cadygsbk2db66tmfy_nuec%2bytnfdjjvrvpiqxjpisyaobtx0...@mail.gmail.com> >
>

Content-Type: text/plain; charset="UTF-8"



Hello Ove,



Your procedure is very creative and I hope we can solve your problem.  I
believe that the CSV importer should respect the desired state of the
reconciliation flag, so the fact that it does not is a problem in my
opinion.



First, your problem may be the result of a recent bug in the CSV import that
may or may not be resolved in the current GnuCash release 4.8.

However, to help track it down, please tell us what release you are using,
your operating system, and the installation type(e.g. Distro, Flatpak,

compiled) .



Second, technically, credit cards are always considered to be liabilities in
accounting applications.  I realize that you are not following technically
correct accounting procedures, and your procedure works for you (at least it
did earlier), but you may run into problems if you try to balance bank
account payments against credit card bills later.  Thus, I suggest trying to
modify your procedure to follow accounting conventions.



We look forward to hearing from you.







On Tue, Nov 16, 2021 at 6:19 AM Ove Grunn?r mailto:write2...@gmail.com> 
<mailto:write2...@gmail.com <mailto:write2...@gmail.com> > > wrote:



>  Hello, all

> 

> I am in the process of changing from QIF import to CSV import of data 

> and have encountered a difference in the functionality that I am 

> trying to understand better in order to make it compatible with my own 

> process, or change my own process to suit the functionality.

> 

> 

> My Account Structure is in principle:

> 

> Asset:Credit Card

> Asset:Card Receipts

> Expenses:Various Expense accounts

> 

> 

> My process to date have been to Scan all receipts and based on the 

> file names of each receipt, [ e.g. 20211231_VISA 

> CARD_09.99_EUR_Place of Sale_Category or Transfer Account_Note ] I 

> then generate a QIF file and import all re

Re: [GNC] CSV Import Reconciled field

[Ove Grunnér]

I was considering raising a bug but I found that as David suspected it
already existed. bug 796890
<https://bugs.gnucash.org/show_bug.cgi?id=796890>

Kind regards Ove.


On Wed, 17 Nov 2021 at 14:23, Ove Grunnér  wrote:

> Hi David, I did some more testing on Flatpack
> Version: 4.8
> Build ID: Flathub 4.8-1
> Finance Quote: 1.49
> "Edit > Preferences > Online Banking > QIF import > default transaction
> status" is set to "Not cleared".
>
> It has the same behaviour as on distro version 4.4
> "Edit > Preferences > Online Banking > QIF import > default transaction
> status" is set to "Not cleared".
>
> I also noted that it is only the sub-transaction that correspond to the
> first line in the multi line csv file that is set to "c", all other
> sub-transactions get set to "n" as expected.
> I may therefore be able to work around my specific issue by never having
> the Asset:Card Receipts account as the first line in the csv import file.
>
>
>
>
>
> Thanks also to Geert for his suggestions,
>
> I included an example of an import file below, I hope the html table
> survives any email conversions...
> When I go through the import pages, there is a page called "Match
> Transactions" I think you refer to this page.
> here I can override any matching, by selecting one of the 3 options
>
>1. A (New, Already Balanced)
>2. U+C (Match Missing)
>3. C (Match Missing)
>
> Assuming there is not already a matching transaction.
> In either case, I always need to select "A" as I need to create a new
> transaction.
>
> Date Transaction_ID Number Description Notes Commodity_Currency
> Void_Reason GnuCash_Action Memo Account_Name
>
> Amount Reconciled Reconcile_Date Rate_Price
> 2021-11-12 A26155857301
> text more text CURRENCY::SEK
> Link Memo Text Stock Alpha Account
>
> 0 n
> 1
>
>
>
>
>
>
>
> Payment Memo Text Investment Account
>
> -780 n
> 1
>
>
>
>
>
>
>
> Dividend Memo Text Dividend for Alpha Stock
>
> 780 n
> 1
>
>
> kind regards Ove.
>
>
> On Wed, 17 Nov 2021 at 12:51, Ove Grunnér  wrote:
>
>> Hi David,
>>
>> "Edit > Preferences > Online Banking > QIF import > default transaction
>> status" is set to "Not cleared".
>>
>> Ove.
>>
>>
>> On Wed, 17 Nov 2021 at 09:30, David Carlson 
>> wrote:
>>
>>> Ove,
>>>
>>> I think one thing to check regarding the reconciliation status for newly
>>> imported transactions with the CSV importer would be the Edit > Preferences
>>> > Online Banking > QIF import > default transaction status to see if it is
>>> still set to Cleared.  I know that should (I think) be ignored for CSV
>>> imports, but there is no equivalent setting for CSV imports, at least as of
>>> the 3.8 GnuCash release.  I am surprised no one has confirmed whether or
>>> not it is broken in release 4.6 or 4.8.
>>>
>>> On Tue, Nov 16, 2021 at 9:58 AM Gyle McCollam 
>>> wrote:
>>>
>>>>
>>>> I just wanted to confirm what David told you, credit cards are always a
>>>> liability because it is money you owe to someone.  Being an accountant, I
>>>> can tell you that is always the correct way to record the transaction.  You
>>>> should debit the expanse account (Groceries, Gas (Fuel), etc.) and credit
>>>> the credit card account.  Then when you get the credit card statement, you
>>>> can reconcile that to the liability account (credit card) and record any
>>>> receipts you may have missed during the month.
>>>>
>>>> Thank You,
>>>> *Gyle McCollam*
>>>>
>>>> Gyle McCollam
>>>>
>>>> 609.680.2326 Mobile
>>>>
>>>> gmccol...@live.comemail
>>>> --
>>>> *From:* gnucash-user 
>>>> on behalf of David Carlson 
>>>> *Sent:* Tuesday, November 16, 2021 10:00 AM
>>>> *To:* Ove Grunnér 
>>>> *Cc:* gnucash-user 
>>>> *Subject:* Re: [GNC] CSV Import Reconciled field
>>>>
>>>> Hello Ove,
>>>>
>>>> Your procedure is very creative and I hope we can solve your problem.  I
>>>> believe that the CSV importer should respect the desired state of the
>>>> reconciliation flag, so the fact that it does not is a problem in my
>>>> opinion.
>>>>
>

Re: [GNC] CSV Import Reconciled field

[Ove Grunnér]

Hi David, I did some more testing on Flatpack
Version: 4.8
Build ID: Flathub 4.8-1
Finance Quote: 1.49
"Edit > Preferences > Online Banking > QIF import > default transaction
status" is set to "Not cleared".

It has the same behaviour as on distro version 4.4
"Edit > Preferences > Online Banking > QIF import > default transaction
status" is set to "Not cleared".

I also noted that it is only the sub-transaction that correspond to the
first line in the multi line csv file that is set to "c", all other
sub-transactions get set to "n" as expected.
I may therefore be able to work around my specific issue by never having
the Asset:Card Receipts account as the first line in the csv import file.





Thanks also to Geert for his suggestions,

I included an example of an import file below, I hope the html table
survives any email conversions...
When I go through the import pages, there is a page called "Match
Transactions" I think you refer to this page.
here I can override any matching, by selecting one of the 3 options

   1. A (New, Already Balanced)
   2. U+C (Match Missing)
   3. C (Match Missing)

Assuming there is not already a matching transaction.
In either case, I always need to select "A" as I need to create a new
transaction.

Date Transaction_ID Number Description Notes Commodity_Currency Void_Reason
GnuCash_Action Memo Account_Name

Amount Reconciled Reconcile_Date Rate_Price
2021-11-12 A26155857301
text more text CURRENCY::SEK
Link Memo Text Stock Alpha Account

0 n
1







Payment Memo Text Investment Account

-780 n
1







Dividend Memo Text Dividend for Alpha Stock

780 n
1


kind regards Ove.


On Wed, 17 Nov 2021 at 12:51, Ove Grunnér  wrote:

> Hi David,
>
> "Edit > Preferences > Online Banking > QIF import > default transaction
> status" is set to "Not cleared".
>
> Ove.
>
>
> On Wed, 17 Nov 2021 at 09:30, David Carlson 
> wrote:
>
>> Ove,
>>
>> I think one thing to check regarding the reconciliation status for newly
>> imported transactions with the CSV importer would be the Edit > Preferences
>> > Online Banking > QIF import > default transaction status to see if it is
>> still set to Cleared.  I know that should (I think) be ignored for CSV
>> imports, but there is no equivalent setting for CSV imports, at least as of
>> the 3.8 GnuCash release.  I am surprised no one has confirmed whether or
>> not it is broken in release 4.6 or 4.8.
>>
>> On Tue, Nov 16, 2021 at 9:58 AM Gyle McCollam  wrote:
>>
>>>
>>> I just wanted to confirm what David told you, credit cards are always a
>>> liability because it is money you owe to someone.  Being an accountant, I
>>> can tell you that is always the correct way to record the transaction.  You
>>> should debit the expanse account (Groceries, Gas (Fuel), etc.) and credit
>>> the credit card account.  Then when you get the credit card statement, you
>>> can reconcile that to the liability account (credit card) and record any
>>> receipts you may have missed during the month.
>>>
>>> Thank You,
>>> *Gyle McCollam*
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326 Mobile
>>>
>>> gmccol...@live.comemail
>>> --
>>> *From:* gnucash-user 
>>> on behalf of David Carlson 
>>> *Sent:* Tuesday, November 16, 2021 10:00 AM
>>> *To:* Ove Grunnér 
>>> *Cc:* gnucash-user 
>>> *Subject:* Re: [GNC] CSV Import Reconciled field
>>>
>>> Hello Ove,
>>>
>>> Your procedure is very creative and I hope we can solve your problem.  I
>>> believe that the CSV importer should respect the desired state of the
>>> reconciliation flag, so the fact that it does not is a problem in my
>>> opinion.
>>>
>>> First, your problem may be the result of a recent bug in the CSV import
>>> that may or may not be resolved in the current GnuCash release 4.8.
>>> However, to help track it down, please tell us what release you are
>>> using,
>>> your operating system, and the installation type(e.g. Distro, Flatpak,
>>> compiled) .
>>>
>>> Second, technically, credit cards are always considered to be liabilities
>>> in accounting applications.  I realize that you are not following
>>> technically correct accounting procedures, and your procedure works for
>>> you
>>> (at least it did earlier), but you may run into problems if you try to
>>> balance bank account payments against credi

Re: [GNC] CSV Import Reconciled field

[Geert Janssens]

Op dinsdag 16 november 2021 13:17:43 CET schreef Ove Grunnér:
> So the question is, without completely changing my process, is there a way
> to force csv imports to show up as Not-Reconciled after import?


You don't show an example of the csv file you make so I'll be generic in my 
reply.


In principle if you don't assign a reconcile column in the CSV import preview 
page, the code 
specific to csv importing won't clear or reconcile any of your splits. Same if 
that column has 
"n" as reconcile value.


However at the end of the import assistant there's another page that allow for 
transaction 
matching (this bit is generic and shared across importers). GnuCash uses 
heuristics to 
attempt to match your imported data to pre-existing transactions. Depending on 
the 
outcome of that algorithm and manual manipulations by you, your transactions 
may still be 
marked as cleared. I can't give you much more details there as I haven't used 
that bit very 
much.


Regards,


Geert
___
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] CSV Import Reconciled field

[Ove Grunnér]

Hi David,

"Edit > Preferences > Online Banking > QIF import > default transaction
status" is set to "Not cleared".

Ove.


On Wed, 17 Nov 2021 at 09:30, David Carlson 
wrote:

> Ove,
>
> I think one thing to check regarding the reconciliation status for newly
> imported transactions with the CSV importer would be the Edit > Preferences
> > Online Banking > QIF import > default transaction status to see if it is
> still set to Cleared.  I know that should (I think) be ignored for CSV
> imports, but there is no equivalent setting for CSV imports, at least as of
> the 3.8 GnuCash release.  I am surprised no one has confirmed whether or
> not it is broken in release 4.6 or 4.8.
>
> On Tue, Nov 16, 2021 at 9:58 AM Gyle McCollam  wrote:
>
>>
>> I just wanted to confirm what David told you, credit cards are always a
>> liability because it is money you owe to someone.  Being an accountant, I
>> can tell you that is always the correct way to record the transaction.  You
>> should debit the expanse account (Groceries, Gas (Fuel), etc.) and credit
>> the credit card account.  Then when you get the credit card statement, you
>> can reconcile that to the liability account (credit card) and record any
>> receipts you may have missed during the month.
>>
>> Thank You,
>> *Gyle McCollam*
>>
>> Gyle McCollam
>>
>> 609.680.2326 Mobile
>>
>> gmccol...@live.comemail
>> --------------
>> *From:* gnucash-user 
>> on behalf of David Carlson 
>> *Sent:* Tuesday, November 16, 2021 10:00 AM
>> *To:* Ove Grunnér 
>> *Cc:* gnucash-user 
>> *Subject:* Re: [GNC] CSV Import Reconciled field
>>
>> Hello Ove,
>>
>> Your procedure is very creative and I hope we can solve your problem.  I
>> believe that the CSV importer should respect the desired state of the
>> reconciliation flag, so the fact that it does not is a problem in my
>> opinion.
>>
>> First, your problem may be the result of a recent bug in the CSV import
>> that may or may not be resolved in the current GnuCash release 4.8.
>> However, to help track it down, please tell us what release you are using,
>> your operating system, and the installation type(e.g. Distro, Flatpak,
>> compiled) .
>>
>> Second, technically, credit cards are always considered to be liabilities
>> in accounting applications.  I realize that you are not following
>> technically correct accounting procedures, and your procedure works for
>> you
>> (at least it did earlier), but you may run into problems if you try to
>> balance bank account payments against credit card bills later.  Thus, I
>> suggest trying to modify your procedure to follow accounting conventions.
>>
>> We look forward to hearing from you.
>>
>>
>>
>> On Tue, Nov 16, 2021 at 6:19 AM Ove Grunnér  wrote:
>>
>> >  Hello, all
>> >
>> > I am in the process of changing from QIF import to CSV import of data
>> and
>> > have encountered a difference in the functionality that I am trying to
>> > understand better in order to make it compatible with my own process, or
>> > change my own process to suit the functionality.
>> >
>> >
>> > My Account Structure is in principle:
>> >
>> > Asset:Credit Card
>> > Asset:Card Receipts
>> > Expenses:Various Expense accounts
>> >
>> >
>> > My process to date have been to Scan all receipts and based on the file
>> > names of each receipt, [ e.g. 20211231_VISA CARD_09.99_EUR_Place of
>> > Sale_Category or Transfer Account_Note ] I then generate a QIF file and
>> > import all receipts this way to [Asset:Card Receipts] in gnucash.
>> >
>> > For bank and credit card statements I have then converted the
>> statements I
>> > download from Online to QIF format, and then I import these QIF files to
>> > GnuCash, where the Account is always [Asset:Credit Card], and the
>> transfer
>> > account is always [Asset:Card Receipts]
>> >
>> > As such, "Card Receipts" should always be Zero in the long run,
>> > if it is positive I am missing a receipt, and if it is negative the
>> > purchase has not yet showed up on my Credit Card.
>> >
>> > I then have a report that shows all Non-Reconciled transactions in
>> > [Asset:Card Receipts]
>> > When Card statement and Receipts match, I manually click the R column to
>> > set state to Reconciled.
>> > I find this 

Re: [GNC] CSV Import Reconciled field

[David Carlson]

Ove,

I think one thing to check regarding the reconciliation status for newly
imported transactions with the CSV importer would be the Edit > Preferences
> Online Banking > QIF import > default transaction status to see if it is
still set to Cleared.  I know that should (I think) be ignored for CSV
imports, but there is no equivalent setting for CSV imports, at least as of
the 3.8 GnuCash release.  I am surprised no one has confirmed whether or
not it is broken in release 4.6 or 4.8.

On Tue, Nov 16, 2021 at 9:58 AM Gyle McCollam  wrote:

>
> I just wanted to confirm what David told you, credit cards are always a
> liability because it is money you owe to someone.  Being an accountant, I
> can tell you that is always the correct way to record the transaction.  You
> should debit the expanse account (Groceries, Gas (Fuel), etc.) and credit
> the credit card account.  Then when you get the credit card statement, you
> can reconcile that to the liability account (credit card) and record any
> receipts you may have missed during the month.
>
> Thank You,
> *Gyle McCollam*
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.comemail
> --
> *From:* gnucash-user 
> on behalf of David Carlson 
> *Sent:* Tuesday, November 16, 2021 10:00 AM
> *To:* Ove Grunnér 
> *Cc:* gnucash-user 
> *Subject:* Re: [GNC] CSV Import Reconciled field
>
> Hello Ove,
>
> Your procedure is very creative and I hope we can solve your problem.  I
> believe that the CSV importer should respect the desired state of the
> reconciliation flag, so the fact that it does not is a problem in my
> opinion.
>
> First, your problem may be the result of a recent bug in the CSV import
> that may or may not be resolved in the current GnuCash release 4.8.
> However, to help track it down, please tell us what release you are using,
> your operating system, and the installation type(e.g. Distro, Flatpak,
> compiled) .
>
> Second, technically, credit cards are always considered to be liabilities
> in accounting applications.  I realize that you are not following
> technically correct accounting procedures, and your procedure works for you
> (at least it did earlier), but you may run into problems if you try to
> balance bank account payments against credit card bills later.  Thus, I
> suggest trying to modify your procedure to follow accounting conventions.
>
> We look forward to hearing from you.
>
>
>
> On Tue, Nov 16, 2021 at 6:19 AM Ove Grunnér  wrote:
>
> >  Hello, all
> >
> > I am in the process of changing from QIF import to CSV import of data and
> > have encountered a difference in the functionality that I am trying to
> > understand better in order to make it compatible with my own process, or
> > change my own process to suit the functionality.
> >
> >
> > My Account Structure is in principle:
> >
> > Asset:Credit Card
> > Asset:Card Receipts
> > Expenses:Various Expense accounts
> >
> >
> > My process to date have been to Scan all receipts and based on the file
> > names of each receipt, [ e.g. 20211231_VISA CARD_09.99_EUR_Place of
> > Sale_Category or Transfer Account_Note ] I then generate a QIF file and
> > import all receipts this way to [Asset:Card Receipts] in gnucash.
> >
> > For bank and credit card statements I have then converted the statements
> I
> > download from Online to QIF format, and then I import these QIF files to
> > GnuCash, where the Account is always [Asset:Credit Card], and the
> transfer
> > account is always [Asset:Card Receipts]
> >
> > As such, "Card Receipts" should always be Zero in the long run,
> > if it is positive I am missing a receipt, and if it is negative the
> > purchase has not yet showed up on my Credit Card.
> >
> > I then have a report that shows all Non-Reconciled transactions in
> > [Asset:Card Receipts]
> > When Card statement and Receipts match, I manually click the R column to
> > set state to Reconciled.
> > I find this very easy to work with, as I decide the Expense category
> when I
> > name the receipt, and I can very easily reconcile it to make sure All
> Card
> > Expenses are tracked this way.
> >
> > Recently in order to get Stock Transactions to import properly I had to
> use
> > CSV format to import transactions, and in order not to have to import
> both
> > QIF and CSV files, I decided to change receipts and Card Statements to
> CSV
> > also.
> >
> > The problem I have now is that when I import any transaction using CSV it
> > always is set to "Re

Re: [GNC] CSV Import Reconciled field

[john]

Where the CSV importer--along with most of the rest of GnuCash--works poorly is 
when there are 3 or more commodities/currencies involved. The most common 
example is when one trades in stock denominated in a different currency from 
your own, for example a Canadian whose books are in CAD buying US stock 
denominated in USD. 

Regards,
John Ralls

> On Nov 16, 2021, at 9:59 AM, David Carlson  
> wrote:
> 
> Kalpesh,
> 
> When the CSV importer was upgraded early in the release 3.x series, it was
> intended to work with investment transactions.  It is designed to import
> the majority of variations available in split transactions with more than
> two splits.
> 
> I am starting to test it with my investment accounts in release 3.8 in
> Ubuntu, and finding that I need to do some fine tuning, but I need to do
> more testing for my case.  However, I think that the reconciliation flag
> code may be working in that release, but I simply accepted the standard
> treatment.
> 
> On Tue, Nov 16, 2021 at 11:31 AM Kalpesh Patel 
> wrote:
> 
>> Hi Ove -
>> 
>> 
>> 
>> I was curious what types of Stock Transactions you are importing properly
>> via CSV format into GNC.
>> 
>> 
>> 
>> I was under the belief that purchase/sale of securities/commodities was not
>> supported via CSV import process in GNC (or I was mistaken) so if it is
>> possible then I wouldn't mind learning how to accomplish that.
>> 
>> 
>> 
>> I have always fallen back with QIF import for importing stocks/securities
>> transactions if OFX/QFX isn't supported by the broker as QIF format
>> provided
>> much better control of transactions being imported. I can also export from
>> Quicken, manipulate, and then import to keep GNC up-to-date if need be.
>> 
>> 
>> 
>> --
>> 
>> 
>> 
>> Message: 7
>> 
>> Date: Tue, 16 Nov 2021 09:00:35 -0600
>> 
>> From: David Carlson > <mailto:david.carlson@gmail.com> >
>> 
>> To: Ove Grunn?r mailto:write2...@gmail.com> >
>> 
>> Cc: gnucash-user > gnucash-user@gnucash.org>
>>> 
>> 
>> Subject: Re: [GNC] CSV Import Reconciled field
>> 
>> Message-ID:
>> 
>> 
>> > <mailto:cadygsbk2db66tmfy_nuec+ytnfdjjvrvpiqxjpisyaobtx0...@mail.gmail.com
>>> 
>>> 
>> 
>> Content-Type: text/plain; charset="UTF-8"
>> 
>> 
>> 
>> Hello Ove,
>> 
>> 
>> 
>> Your procedure is very creative and I hope we can solve your problem.  I
>> believe that the CSV importer should respect the desired state of the
>> reconciliation flag, so the fact that it does not is a problem in my
>> opinion.
>> 
>> 
>> 
>> First, your problem may be the result of a recent bug in the CSV import
>> that
>> may or may not be resolved in the current GnuCash release 4.8.
>> 
>> However, to help track it down, please tell us what release you are using,
>> your operating system, and the installation type(e.g. Distro, Flatpak,
>> 
>> compiled) .
>> 
>> 
>> 
>> Second, technically, credit cards are always considered to be liabilities
>> in
>> accounting applications.  I realize that you are not following technically
>> correct accounting procedures, and your procedure works for you (at least
>> it
>> did earlier), but you may run into problems if you try to balance bank
>> account payments against credit card bills later.  Thus, I suggest trying
>> to
>> modify your procedure to follow accounting conventions.
>> 
>> 
>> 
>> We look forward to hearing from you.
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> On Tue, Nov 16, 2021 at 6:19 AM Ove Grunn?r > <mailto:write2...@gmail.com> > wrote:
>> 
>> 
>> 
>>> Hello, all
>> 
>>> 
>> 
>>> I am in the process of changing from QIF import to CSV import of data
>> 
>>> and have encountered a difference in the functionality that I am
>> 
>>> trying to understand better in order to make it compatible with my own
>> 
>>> process, or change my own process to suit the functionality.
>> 
>>> 
>> 
>>> 
>> 
>>> My Account Structure is in principle:
>> 
>>> 
>> 
>>> Asset:Credit Card
>> 
>>> Asset:Card Receipts
>> 
>>> Expenses:Various Expense accounts
>> 
>>> 
>> 
>>> 
>> 
>>> My process to date have been t

Re: [GNC] CSV Import Reconciled field

[David Carlson]

Kalpesh,

When the CSV importer was upgraded early in the release 3.x series, it was
intended to work with investment transactions.  It is designed to import
the majority of variations available in split transactions with more than
two splits.

I am starting to test it with my investment accounts in release 3.8 in
Ubuntu, and finding that I need to do some fine tuning, but I need to do
more testing for my case.  However, I think that the reconciliation flag
code may be working in that release, but I simply accepted the standard
treatment.

On Tue, Nov 16, 2021 at 11:31 AM Kalpesh Patel 
wrote:

> Hi Ove -
>
>
>
> I was curious what types of Stock Transactions you are importing properly
> via CSV format into GNC.
>
>
>
> I was under the belief that purchase/sale of securities/commodities was not
> supported via CSV import process in GNC (or I was mistaken) so if it is
> possible then I wouldn't mind learning how to accomplish that.
>
>
>
> I have always fallen back with QIF import for importing stocks/securities
> transactions if OFX/QFX isn't supported by the broker as QIF format
> provided
> much better control of transactions being imported. I can also export from
> Quicken, manipulate, and then import to keep GNC up-to-date if need be.
>
>
>
> --
>
>
>
> Message: 7
>
> Date: Tue, 16 Nov 2021 09:00:35 -0600
>
> From: David Carlson  <mailto:david.carlson@gmail.com> >
>
> To: Ove Grunn?r mailto:write2...@gmail.com> >
>
> Cc: gnucash-user  gnucash-user@gnucash.org>
> >
>
> Subject: Re: [GNC] CSV Import Reconciled field
>
> Message-ID:
>
>
>  <mailto:cadygsbk2db66tmfy_nuec+ytnfdjjvrvpiqxjpisyaobtx0...@mail.gmail.com
> >
> >
>
> Content-Type: text/plain; charset="UTF-8"
>
>
>
> Hello Ove,
>
>
>
> Your procedure is very creative and I hope we can solve your problem.  I
> believe that the CSV importer should respect the desired state of the
> reconciliation flag, so the fact that it does not is a problem in my
> opinion.
>
>
>
> First, your problem may be the result of a recent bug in the CSV import
> that
> may or may not be resolved in the current GnuCash release 4.8.
>
> However, to help track it down, please tell us what release you are using,
> your operating system, and the installation type(e.g. Distro, Flatpak,
>
> compiled) .
>
>
>
> Second, technically, credit cards are always considered to be liabilities
> in
> accounting applications.  I realize that you are not following technically
> correct accounting procedures, and your procedure works for you (at least
> it
> did earlier), but you may run into problems if you try to balance bank
> account payments against credit card bills later.  Thus, I suggest trying
> to
> modify your procedure to follow accounting conventions.
>
>
>
> We look forward to hearing from you.
>
>
>
>
>
>
>
> On Tue, Nov 16, 2021 at 6:19 AM Ove Grunn?r  <mailto:write2...@gmail.com> > wrote:
>
>
>
> >  Hello, all
>
> >
>
> > I am in the process of changing from QIF import to CSV import of data
>
> > and have encountered a difference in the functionality that I am
>
> > trying to understand better in order to make it compatible with my own
>
> > process, or change my own process to suit the functionality.
>
> >
>
> >
>
> > My Account Structure is in principle:
>
> >
>
> > Asset:Credit Card
>
> > Asset:Card Receipts
>
> > Expenses:Various Expense accounts
>
> >
>
> >
>
> > My process to date have been to Scan all receipts and based on the
>
> > file names of each receipt, [ e.g. 20211231_VISA
>
> > CARD_09.99_EUR_Place of Sale_Category or Transfer Account_Note ] I
>
> > then generate a QIF file and import all receipts this way to [Asset:Card
> Receipts] in gnucash.
>
> >
>
> > For bank and credit card statements I have then converted the
>
> > statements I download from Online to QIF format, and then I import
>
> > these QIF files to GnuCash, where the Account is always [Asset:Credit
>
> > Card], and the transfer account is always [Asset:Card Receipts]
>
> >
>
> > As such, "Card Receipts" should always be Zero in the long run, if it
>
> > is positive I am missing a receipt, and if it is negative the purchase
>
> > has not yet showed up on my Credit Card.
>
> >
>
> > I then have a report that shows all Non-Reconciled transactions in
>
> > [Asset:Card Receipts] When Card statement and Receipts match, I
>
> > m

Re: [GNC] CSV Import Reconciled field - Sideline question

[Ove]

Hello Patel,

[I changed the title of the email so hopefully it will create a separate 
trail and not mix up with my initial query ]



I can do most things with both QIF and Multi line CVS in regards to 
Stock/securities (that  I need to do)


e.g.

 * Stock Purchase with commission
 * Stock Sell with commission
 * Dividend with tax and with fee and zero buy stock to align the
   dividend with the stock
 * Stock Split or more precisely Add Stock at zero cost

the one thing I was not able to do with QIF was to align the Dividend 
with the Stock, so that the "Advanced Portfolio" report would correctly 
recognise the Dividend to the Stock.


Since I have trading accounts active, I also add a line for each trading 
account transaction when required. I am not sure if I have to do this, 
but it is easy to do when I create the export CSV file programmatically.


I find the CSV multi-line format very easy to work with because you can 
add any combination of lines to a transaction.


What in particular are you having a problem with importing using CSV?


kind regards Ove.





On 16/11/2021 17:28, Kalpesh Patel wrote:


Hi Ove –

I was curious what types of Stock Transactions you are importing 
properly via CSV format into GNC.


I was under the belief that purchase/sale of securities/commodities 
was not supported via CSV import process in GNC (or I was mistaken) so 
if it is possible then I wouldn’t mind learning how to accomplish that.


I have always fallen back with QIF import for importing 
stocks/securities transactions if OFX/QFX isn’t supported by the 
broker as QIF format provided much better control of transactions 
being imported. I can also export from Quicken, manipulate, and then 
import to keep GNC up-to-date if need be.


--

Message: 7

Date: Tue, 16 Nov 2021 09:00:35 -0600

From: David Carlson 

To: Ove Grunn?r 

Cc: gnucash-user 

Subject: Re: [GNC] CSV Import Reconciled field

Message-ID:

    



Content-Type: text/plain; charset="UTF-8"

Hello Ove,

Your procedure is very creative and I hope we can solve your problem.  
I believe that the CSV importer should respect the desired state of 
the reconciliation flag, so the fact that it does not is a problem in 
my opinion.


First, your problem may be the result of a recent bug in the CSV 
import that may or may not be resolved in the current GnuCash release 4.8.


However, to help track it down, please tell us what release you are 
using, your operating system, and the installation type(e.g. Distro, 
Flatpak,


compiled) .

Second, technically, credit cards are always considered to be 
liabilities in accounting applications.  I realize that you are not 
following technically correct accounting procedures, and your 
procedure works for you (at least it did earlier), but you may run 
into problems if you try to balance bank account payments against 
credit card bills later.  Thus, I suggest trying to modify your 
procedure to follow accounting conventions.


We look forward to hearing from you.

On Tue, Nov 16, 2021 at 6:19 AM Ove Grunn?r  wrote:

>  Hello, all

>

> I am in the process of changing from QIF import to CSV import of data

> and have encountered a difference in the functionality that I am

> trying to understand better in order to make it compatible with my own

> process, or change my own process to suit the functionality.

>

>

> My Account Structure is in principle:

>

> Asset:Credit Card

> Asset:Card Receipts

> Expenses:Various Expense accounts

>

>

> My process to date have been to Scan all receipts and based on the

> file names of each receipt, [ e.g. 20211231_VISA

> CARD_09.99_EUR_Place of Sale_Category or Transfer Account_Note ] I

> then generate a QIF file and import all receipts this way to 
[Asset:Card Receipts] in gnucash.


>

> For bank and credit card statements I have then converted the

> statements I download from Online to QIF format, and then I import

> these QIF files to GnuCash, where the Account is always [Asset:Credit

> Card], and the transfer account is always [Asset:Card Receipts]

>

> As such, "Card Receipts" should always be Zero in the long run, if it

> is positive I am missing a receipt, and if it is negative the purchase

> has not yet showed up on my Credit Card.

>

> I then have a report that shows all Non-Reconciled transactions in

> [Asset:Card Receipts] When Card statement and Receipts match, I

> manually click the R column to set state to Reconciled.

> I find this very easy to work with, as I decide the Expense category

> when I name the receipt, and I can very easily reconcile it to make

> sure All Card Expenses are tracked this way.

>

> Recently in order to get Stock Transactions to import properly I had

> to use CSV format to import transactions, and in order not to have to

> imp

Re: [GNC] CSV Import Reconciled field

[Kalpesh Patel]

Hi Ove - 

 

I was curious what types of Stock Transactions you are importing properly
via CSV format into GNC.

 

I was under the belief that purchase/sale of securities/commodities was not
supported via CSV import process in GNC (or I was mistaken) so if it is
possible then I wouldn't mind learning how to accomplish that.

 

I have always fallen back with QIF import for importing stocks/securities
transactions if OFX/QFX isn't supported by the broker as QIF format provided
much better control of transactions being imported. I can also export from
Quicken, manipulate, and then import to keep GNC up-to-date if need be.

 

--

 

Message: 7

Date: Tue, 16 Nov 2021 09:00:35 -0600

From: David Carlson mailto:david.carlson@gmail.com> >

To: Ove Grunn?r mailto:write2...@gmail.com> >

Cc: gnucash-user mailto:gnucash-user@gnucash.org>
>

Subject: Re: [GNC] CSV Import Reconciled field

Message-ID:

 
mailto:cadygsbk2db66tmfy_nuec+ytnfdjjvrvpiqxjpisyaobtx0...@mail.gmail.com>
>

Content-Type: text/plain; charset="UTF-8"

 

Hello Ove,

 

Your procedure is very creative and I hope we can solve your problem.  I
believe that the CSV importer should respect the desired state of the
reconciliation flag, so the fact that it does not is a problem in my
opinion.

 

First, your problem may be the result of a recent bug in the CSV import that
may or may not be resolved in the current GnuCash release 4.8.

However, to help track it down, please tell us what release you are using,
your operating system, and the installation type(e.g. Distro, Flatpak,

compiled) .

 

Second, technically, credit cards are always considered to be liabilities in
accounting applications.  I realize that you are not following technically
correct accounting procedures, and your procedure works for you (at least it
did earlier), but you may run into problems if you try to balance bank
account payments against credit card bills later.  Thus, I suggest trying to
modify your procedure to follow accounting conventions.

 

We look forward to hearing from you.

 

 

 

On Tue, Nov 16, 2021 at 6:19 AM Ove Grunn?r mailto:write2...@gmail.com> > wrote:

 

>  Hello, all

> 

> I am in the process of changing from QIF import to CSV import of data 

> and have encountered a difference in the functionality that I am 

> trying to understand better in order to make it compatible with my own 

> process, or change my own process to suit the functionality.

> 

> 

> My Account Structure is in principle:

> 

> Asset:Credit Card

> Asset:Card Receipts

> Expenses:Various Expense accounts

> 

> 

> My process to date have been to Scan all receipts and based on the 

> file names of each receipt, [ e.g. 20211231_VISA 

> CARD_09.99_EUR_Place of Sale_Category or Transfer Account_Note ] I 

> then generate a QIF file and import all receipts this way to [Asset:Card
Receipts] in gnucash.

> 

> For bank and credit card statements I have then converted the 

> statements I download from Online to QIF format, and then I import 

> these QIF files to GnuCash, where the Account is always [Asset:Credit 

> Card], and the transfer account is always [Asset:Card Receipts]

> 

> As such, "Card Receipts" should always be Zero in the long run, if it 

> is positive I am missing a receipt, and if it is negative the purchase 

> has not yet showed up on my Credit Card.

> 

> I then have a report that shows all Non-Reconciled transactions in 

> [Asset:Card Receipts] When Card statement and Receipts match, I 

> manually click the R column to set state to Reconciled.

> I find this very easy to work with, as I decide the Expense category 

> when I name the receipt, and I can very easily reconcile it to make 

> sure All Card Expenses are tracked this way.

> 

> Recently in order to get Stock Transactions to import properly I had 

> to use CSV format to import transactions, and in order not to have to 

> import both QIF and CSV files, I decided to change receipts and Card 

> Statements to CSV also.

> 

> The problem I have now is that when I import any transaction using CSV 

> it always is set to "Reconciled" on import.

> I tried to set the "Reconciled" field in the CSV Importer dialog, but 

> it seems it is ignoring the reconsoiled information on import.

> Quote from GnuCash documentation: "Note that "reconciled" in this 

> context does not mean the same as "reconciled" in the process of 

> reconciling an account to an external statement. The reconciliation 

> status of an imported transaction is set to cleared (c) on import of a new
transaction "

> 

> So the question is, without completely changing my process, is there a 

> way to force csv imports to

Re: [GNC] CSV Import Reconciled field

[Gyle McCollam]

I just wanted to confirm what David told you, credit cards are always a 
liability because it is money you owe to someone.  Being an accountant, I can 
tell you that is always the correct way to record the transaction.  You should 
debit the expanse account (Groceries, Gas (Fuel), etc.) and credit the credit 
card account.  Then when you get the credit card statement, you can reconcile 
that to the liability account (credit card) and record any receipts you may 
have missed during the month.

Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on 
behalf of David Carlson 
Sent: Tuesday, November 16, 2021 10:00 AM
To: Ove Grunnér 
Cc: gnucash-user 
Subject: Re: [GNC] CSV Import Reconciled field

Hello Ove,

Your procedure is very creative and I hope we can solve your problem.  I
believe that the CSV importer should respect the desired state of the
reconciliation flag, so the fact that it does not is a problem in my
opinion.

First, your problem may be the result of a recent bug in the CSV import
that may or may not be resolved in the current GnuCash release 4.8.
However, to help track it down, please tell us what release you are using,
your operating system, and the installation type(e.g. Distro, Flatpak,
compiled) .

Second, technically, credit cards are always considered to be liabilities
in accounting applications.  I realize that you are not following
technically correct accounting procedures, and your procedure works for you
(at least it did earlier), but you may run into problems if you try to
balance bank account payments against credit card bills later.  Thus, I
suggest trying to modify your procedure to follow accounting conventions.

We look forward to hearing from you.



On Tue, Nov 16, 2021 at 6:19 AM Ove Grunnér  wrote:

>  Hello, all
>
> I am in the process of changing from QIF import to CSV import of data and
> have encountered a difference in the functionality that I am trying to
> understand better in order to make it compatible with my own process, or
> change my own process to suit the functionality.
>
>
> My Account Structure is in principle:
>
> Asset:Credit Card
> Asset:Card Receipts
> Expenses:Various Expense accounts
>
>
> My process to date have been to Scan all receipts and based on the file
> names of each receipt, [ e.g. 20211231_VISA CARD_09.99_EUR_Place of
> Sale_Category or Transfer Account_Note ] I then generate a QIF file and
> import all receipts this way to [Asset:Card Receipts] in gnucash.
>
> For bank and credit card statements I have then converted the statements I
> download from Online to QIF format, and then I import these QIF files to
> GnuCash, where the Account is always [Asset:Credit Card], and the transfer
> account is always [Asset:Card Receipts]
>
> As such, "Card Receipts" should always be Zero in the long run,
> if it is positive I am missing a receipt, and if it is negative the
> purchase has not yet showed up on my Credit Card.
>
> I then have a report that shows all Non-Reconciled transactions in
> [Asset:Card Receipts]
> When Card statement and Receipts match, I manually click the R column to
> set state to Reconciled.
> I find this very easy to work with, as I decide the Expense category when I
> name the receipt, and I can very easily reconcile it to make sure All Card
> Expenses are tracked this way.
>
> Recently in order to get Stock Transactions to import properly I had to use
> CSV format to import transactions, and in order not to have to import both
> QIF and CSV files, I decided to change receipts and Card Statements to CSV
> also.
>
> The problem I have now is that when I import any transaction using CSV it
> always is set to "Reconciled" on import.
> I tried to set the "Reconciled" field in the CSV Importer dialog, but it
> seems it is ignoring the reconsoiled information on import.
> Quote from GnuCash documentation: "Note that "reconciled" in this context
> does not mean the same as "reconciled" in the process of reconciling an
> account to an external statement. The reconciliation status of an imported
> transaction is set to cleared (c) on import of a new transaction "
>
> So the question is, without completely changing my process, is there a way
> to force csv imports to show up as Not-Reconciled after import?
> Some other way of achieving the definition of each receipts expense
> category separate to the import process and an easy way of ensuring all
> transactions on the statement has a receipt or similar confirmation of
> correctness.
>
> Many thanks in advance for any suggestions or advice.
>
> Kind regards Ove.
> 

Re: [GNC] CSV Import Reconciled field

[Ove Grunnér]

Thanks David,


First the SW Details:
Gnucash version: 4.4
Build ID: 4.4+(2020-12-28)
Finance::Quote: 1.51
Type: Distro

Installed by "sudo apt install gnucash"
$ uname -a
Linux Conf-VirtualBox 5.13.0-21-generic #21-Ubuntu SMP Tue Oct 19 08:59:28
UTC 2021 x86_64 x86_64 x86_64 GNU/Linux
$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 21.10
Release: 21.10
Codename: impish

Running on VirtualBox on CentOS on Ryzen AMD.

Then, the Account structure, thanks for the info on Credit Card being
liability, it makes sense.
Asset:Credit Card [the "Account Type" is actually set to "Credit Card" but
the parent directory is set to "Asset", and the Name of the toplevel
account is "Asset" which is why I had shown Asset:]
Asset:Card Receipts [ this "Account Type" is set to "Asset"]

I hope having a Credit Card as a child to an Asset Account is OK???

Happy to raise a bug if it helps.

kind regards Ove.





On Tue, 16 Nov 2021 at 15:00, David Carlson 
wrote:

> Hello Ove,
>
> Your procedure is very creative and I hope we can solve your problem.  I
> believe that the CSV importer should respect the desired state of the
> reconciliation flag, so the fact that it does not is a problem in my
> opinion.
>
> First, your problem may be the result of a recent bug in the CSV import
> that may or may not be resolved in the current GnuCash release 4.8.
> However, to help track it down, please tell us what release you are using,
> your operating system, and the installation type(e.g. Distro, Flatpak,
> compiled) .
>
> Second, technically, credit cards are always considered to be liabilities
> in accounting applications.  I realize that you are not following
> technically correct accounting procedures, and your procedure works for you
> (at least it did earlier), but you may run into problems if you try to
> balance bank account payments against credit card bills later.  Thus, I
> suggest trying to modify your procedure to follow accounting conventions.
>
> We look forward to hearing from you.
>
>
>
> On Tue, Nov 16, 2021 at 6:19 AM Ove Grunnér  wrote:
>
>>  Hello, all
>>
>> I am in the process of changing from QIF import to CSV import of data and
>> have encountered a difference in the functionality that I am trying to
>> understand better in order to make it compatible with my own process, or
>> change my own process to suit the functionality.
>>
>>
>> My Account Structure is in principle:
>>
>> Asset:Credit Card
>> Asset:Card Receipts
>> Expenses:Various Expense accounts
>>
>>
>> My process to date have been to Scan all receipts and based on the file
>> names of each receipt, [ e.g. 20211231_VISA CARD_09.99_EUR_Place of
>> Sale_Category or Transfer Account_Note ] I then generate a QIF file and
>> import all receipts this way to [Asset:Card Receipts] in gnucash.
>>
>> For bank and credit card statements I have then converted the statements I
>> download from Online to QIF format, and then I import these QIF files to
>> GnuCash, where the Account is always [Asset:Credit Card], and the transfer
>> account is always [Asset:Card Receipts]
>>
>> As such, "Card Receipts" should always be Zero in the long run,
>> if it is positive I am missing a receipt, and if it is negative the
>> purchase has not yet showed up on my Credit Card.
>>
>> I then have a report that shows all Non-Reconciled transactions in
>> [Asset:Card Receipts]
>> When Card statement and Receipts match, I manually click the R column to
>> set state to Reconciled.
>> I find this very easy to work with, as I decide the Expense category when
>> I
>> name the receipt, and I can very easily reconcile it to make sure All Card
>> Expenses are tracked this way.
>>
>> Recently in order to get Stock Transactions to import properly I had to
>> use
>> CSV format to import transactions, and in order not to have to import both
>> QIF and CSV files, I decided to change receipts and Card Statements to CSV
>> also.
>>
>> The problem I have now is that when I import any transaction using CSV it
>> always is set to "Reconciled" on import.
>> I tried to set the "Reconciled" field in the CSV Importer dialog, but it
>> seems it is ignoring the reconsoiled information on import.
>> Quote from GnuCash documentation: "Note that "reconciled" in this context
>> does not mean the same as "reconciled" in the process of reconciling an
>> account to an external statement. The reconciliation status of an imported
>> transaction is set to cleared (c) on import of a new transaction "
>>
>> So the question is, without completely changing my process, is there a way
>> to force csv imports to show up as Not-Reconciled after import?
>> Some other way of achieving the definition of each receipts expense
>> category separate to the import process and an easy way of ensuring all
>> transactions on the statement has a receipt or similar confirmation of
>> correctness.
>>
>> Many thanks in advance for any suggestions or advice.
>>
>> Kind regards Ove.
>> _

Re: [GNC] CSV Import Reconciled field

[David Carlson]

Hello Ove,

Your procedure is very creative and I hope we can solve your problem.  I
believe that the CSV importer should respect the desired state of the
reconciliation flag, so the fact that it does not is a problem in my
opinion.

First, your problem may be the result of a recent bug in the CSV import
that may or may not be resolved in the current GnuCash release 4.8.
However, to help track it down, please tell us what release you are using,
your operating system, and the installation type(e.g. Distro, Flatpak,
compiled) .

Second, technically, credit cards are always considered to be liabilities
in accounting applications.  I realize that you are not following
technically correct accounting procedures, and your procedure works for you
(at least it did earlier), but you may run into problems if you try to
balance bank account payments against credit card bills later.  Thus, I
suggest trying to modify your procedure to follow accounting conventions.

We look forward to hearing from you.



On Tue, Nov 16, 2021 at 6:19 AM Ove Grunnér  wrote:

>  Hello, all
>
> I am in the process of changing from QIF import to CSV import of data and
> have encountered a difference in the functionality that I am trying to
> understand better in order to make it compatible with my own process, or
> change my own process to suit the functionality.
>
>
> My Account Structure is in principle:
>
> Asset:Credit Card
> Asset:Card Receipts
> Expenses:Various Expense accounts
>
>
> My process to date have been to Scan all receipts and based on the file
> names of each receipt, [ e.g. 20211231_VISA CARD_09.99_EUR_Place of
> Sale_Category or Transfer Account_Note ] I then generate a QIF file and
> import all receipts this way to [Asset:Card Receipts] in gnucash.
>
> For bank and credit card statements I have then converted the statements I
> download from Online to QIF format, and then I import these QIF files to
> GnuCash, where the Account is always [Asset:Credit Card], and the transfer
> account is always [Asset:Card Receipts]
>
> As such, "Card Receipts" should always be Zero in the long run,
> if it is positive I am missing a receipt, and if it is negative the
> purchase has not yet showed up on my Credit Card.
>
> I then have a report that shows all Non-Reconciled transactions in
> [Asset:Card Receipts]
> When Card statement and Receipts match, I manually click the R column to
> set state to Reconciled.
> I find this very easy to work with, as I decide the Expense category when I
> name the receipt, and I can very easily reconcile it to make sure All Card
> Expenses are tracked this way.
>
> Recently in order to get Stock Transactions to import properly I had to use
> CSV format to import transactions, and in order not to have to import both
> QIF and CSV files, I decided to change receipts and Card Statements to CSV
> also.
>
> The problem I have now is that when I import any transaction using CSV it
> always is set to "Reconciled" on import.
> I tried to set the "Reconciled" field in the CSV Importer dialog, but it
> seems it is ignoring the reconsoiled information on import.
> Quote from GnuCash documentation: "Note that "reconciled" in this context
> does not mean the same as "reconciled" in the process of reconciling an
> account to an external statement. The reconciliation status of an imported
> transaction is set to cleared (c) on import of a new transaction "
>
> So the question is, without completely changing my process, is there a way
> to force csv imports to show up as Not-Reconciled after import?
> Some other way of achieving the definition of each receipts expense
> category separate to the import process and an easy way of ensuring all
> transactions on the statement has a receipt or similar confirmation of
> correctness.
>
> Many thanks in advance for any suggestions or advice.
>
> Kind regards Ove.
> ___
> 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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] CSV Import Reconciled field

[Ove Grunnér]

 Hello, all

I am in the process of changing from QIF import to CSV import of data and
have encountered a difference in the functionality that I am trying to
understand better in order to make it compatible with my own process, or
change my own process to suit the functionality.


My Account Structure is in principle:

Asset:Credit Card
Asset:Card Receipts
Expenses:Various Expense accounts


My process to date have been to Scan all receipts and based on the file
names of each receipt, [ e.g. 20211231_VISA CARD_09.99_EUR_Place of
Sale_Category or Transfer Account_Note ] I then generate a QIF file and
import all receipts this way to [Asset:Card Receipts] in gnucash.

For bank and credit card statements I have then converted the statements I
download from Online to QIF format, and then I import these QIF files to
GnuCash, where the Account is always [Asset:Credit Card], and the transfer
account is always [Asset:Card Receipts]

As such, "Card Receipts" should always be Zero in the long run,
if it is positive I am missing a receipt, and if it is negative the
purchase has not yet showed up on my Credit Card.

I then have a report that shows all Non-Reconciled transactions in
[Asset:Card Receipts]
When Card statement and Receipts match, I manually click the R column to
set state to Reconciled.
I find this very easy to work with, as I decide the Expense category when I
name the receipt, and I can very easily reconcile it to make sure All Card
Expenses are tracked this way.

Recently in order to get Stock Transactions to import properly I had to use
CSV format to import transactions, and in order not to have to import both
QIF and CSV files, I decided to change receipts and Card Statements to CSV
also.

The problem I have now is that when I import any transaction using CSV it
always is set to "Reconciled" on import.
I tried to set the "Reconciled" field in the CSV Importer dialog, but it
seems it is ignoring the reconsoiled information on import.
Quote from GnuCash documentation: "Note that "reconciled" in this context
does not mean the same as "reconciled" in the process of reconciling an
account to an external statement. The reconciliation status of an imported
transaction is set to cleared (c) on import of a new transaction "

So the question is, without completely changing my process, is there a way
to force csv imports to show up as Not-Reconciled after import?
Some other way of achieving the definition of each receipts expense
category separate to the import process and an easy way of ensuring all
transactions on the statement has a receipt or similar confirmation of
correctness.

Many thanks in advance for any suggestions or advice.

Kind regards Ove.
___
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] CSV import of Credit Card Transaction Data

[David Cousens]

Paul,

The headings should include a columns for  Deposit  and Withdrawal. If you
have a single column of signed data one of these should work. You may have
to experiment to get the right header for your bank's data. From memory I
used the Deposit header on a bank account CSV import. 

The importer has different headers to cope with banks proclivity not to
stick with any particular standard way of presenting CSV data. Some have
separate columns for deposits and Withdrawals, some use a single unsigned
column with another column which has Debit/Credit entries. GnuCash has to be
able to cope with all of these variations.

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.

[GNC] CSV import of Credit Card Transaction Data

[Paul Konnersman]

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


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


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


Paul

-- 
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV import of fund transactions

[Alaeddin Aydiner via gnucash-user]

Hi Geert,

You are right. The solution involves just adding a "Transaction 
Commodity" column and entering USD (in my case) for both lines. I feel 
this is a documentation issue, which this email thread is already 
fixing; so I will personally not bother to file a ticket on this.


Date,Description,Transaction Commodity,Account,Deposit,Price

04/5/2020,Fund Dividend REINVESTMENT @ 31.5244,USD,Brokerage 
Account:Mutual Fund:Fund,0.03902,31.522296258329064


,,USD,Income:Dividend Income,-1.23,1.0

Thanks & regards,

Alaeddin.

On 4/10/20 2:02 AM, Geert Janssens wrote:


Ok, I see.

The problem is likely your csv file doesn't provide a transaction 
currency. In that case the currency of the first split will be used as 
transaction currency. That would not work correctly in your case as 
the first line is actually in the foreign currency (with exchange rate).


I haven't tested yet, but you could try two things:

- Either add a column that sets the transaction currency

- Or swap the split data such that the split in the native currency is 
the first in the transaction.


I vaguely remember this issue was mentioned in the past, but I don't 
know if there is a bug report for this already. Can you please file 
one in bugzilla [1] ?


Thank you.

Regards,

Geert

[1] Refer to http://wiki.gnucash.org/wiki/Bugzilla on how to use our 
bug tracker


Op vrijdag 10 april 2020 09:25:05 CEST schreef Alaeddin Aydiner:

> I just compiled 3.9 from its sources as you suggested. The GUI's about

> window confirms that:

>

> Version: 3.9 Build ID: 3.9+(2020-03-28) Finance::Quote: 1.47

>

> But I am afraid the bug is still not fixed. With the 3-lines of CSV

> below, the fund is still priced as $1 and its price on the order of $31

> is ignored. Everything else is properly handled in the multi-split 
import.


>

> Regards,

>

> Alaeddin.

>

> On 4/9/20 1:27 AM, Geert Janssens wrote:

> > Hi,

> >

> > I have fixed a bug wrt to this for gnucash 3.9. Can you retry with

> > that version and report back whether it works now ?

> >

> > Regards,

> >

> > Geert

> >

> > Op donderdag 9 april 2020 08:04:07 CEST schreef Alaeddin Aydiner via

> >

> > gnucash-user:

> > > Hello,

> > >

> > >

> > >

> > > I could not get the price of a mutual fund imported to GnuCash 
3.6 and


> > >

> > > 3.7 through a CSV. Everything else seems to get imported just 
fine. Has


> > >

> > > anyone managed to achieve this?

> > >

> > >

> > >

> > > The CSV looks like the following for a mini dividend reinvestment:

> > >

> > >

> > >

> > > Date,Description,Account,Deposit,Price

> > >

> > > 04/5/2020,Fund Divident REINVESTMENT @ 31.5244,Brokerage 
Account:Mutual


> > >

> > > Fund:Fund,0.03902,31.522296258329064

> > >

> > > ,,Income:Dividend Income,-1.23,1.0

> > >

> > >

> > >

> > > When this is imported, the split transaction is imported 
correctly but


> > >

> > > the price of the fund is not. I tried the fractional form of the 
price


> > >

> > > as well. I can put it in any required format as the CSV is 
generated by


> > >

> > > a script already. BTW, if there is a GnuCash python example, I'd 
be fine


> > >

> > > with that too.

> > >

> > >

> > >

> > > Thanks in advance!

> > >

> > >

> > >

> > > ___

> > >

> > > 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] CSV import of fund transactions

[Geert Janssens]

Ok, I see.

The problem is likely your csv file doesn't provide a transaction currency. In 
that case the 
currency of the first split will be used as transaction currency. That would 
not work correctly in 
your case as the first line is actually in the foreign currency (with exchange 
rate).

I haven't tested yet, but you could try two things:
- Either add a column that sets the transaction currency
- Or swap the split data such that the split in the native currency is the 
first in the transaction.

I vaguely remember this issue was mentioned in the past, but I don't know if 
there is a bug 
report for this already. Can you please file one in bugzilla [1] ?

Thank you.

Regards,

Geert

[1] Refer to http://wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker

Op vrijdag 10 april 2020 09:25:05 CEST schreef Alaeddin Aydiner:
> I just compiled 3.9 from its sources as you suggested. The GUI's about
> window confirms that:
> 
> Version: 3.9 Build ID: 3.9+(2020-03-28) Finance::Quote: 1.47
> 
> But I am afraid the bug is still not fixed. With the 3-lines of CSV
> below, the fund is still priced as $1 and its price on the order of $31
> is ignored. Everything else is properly handled in the multi-split import.
> 
> Regards,
> 
> Alaeddin.
> 
> On 4/9/20 1:27 AM, Geert Janssens wrote:
> > Hi,
> > 
> > I have fixed a bug wrt to this for gnucash 3.9. Can you retry with
> > that version and report back whether it works now ?
> > 
> > Regards,
> > 
> > Geert
> > 
> > Op donderdag 9 april 2020 08:04:07 CEST schreef Alaeddin Aydiner via
> > 
> > gnucash-user:
> > > Hello,
> > > 
> > > 
> > > 
> > > I could not get the price of a mutual fund imported to GnuCash 3.6 and
> > > 
> > > 3.7 through a CSV. Everything else seems to get imported just fine. Has
> > > 
> > > anyone managed to achieve this?
> > > 
> > > 
> > > 
> > > The CSV looks like the following for a mini dividend reinvestment:
> > > 
> > > 
> > > 
> > > Date,Description,Account,Deposit,Price
> > > 
> > > 04/5/2020,Fund Divident REINVESTMENT @ 31.5244,Brokerage Account:Mutual
> > > 
> > > Fund:Fund,0.03902,31.522296258329064
> > > 
> > > ,,Income:Dividend Income,-1.23,1.0
> > > 
> > > 
> > > 
> > > When this is imported, the split transaction is imported correctly but
> > > 
> > > the price of the fund is not. I tried the fractional form of the price
> > > 
> > > as well. I can put it in any required format as the CSV is generated by
> > > 
> > > a script already. BTW, if there is a GnuCash python example, I'd be fine
> > > 
> > > with that too.
> > > 
> > > 
> > > 
> > > Thanks in advance!
> > > 
> > > 
> > > 
> > > ___
> > > 
> > > 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] CSV import of fund transactions

[Alaeddin Aydiner via gnucash-user]

I just compiled 3.9 from its sources as you suggested. The GUI's about 
window confirms that:


Version: 3.9 Build ID: 3.9+(2020-03-28) Finance::Quote: 1.47

But I am afraid the bug is still not fixed. With the 3-lines of CSV 
below, the fund is still priced as $1 and its price on the order of $31 
is ignored. Everything else is properly handled in the multi-split import.


Regards,

Alaeddin.

On 4/9/20 1:27 AM, Geert Janssens wrote:


Hi,

I have fixed a bug wrt to this for gnucash 3.9. Can you retry with 
that version and report back whether it works now ?


Regards,

Geert

Op donderdag 9 april 2020 08:04:07 CEST schreef Alaeddin Aydiner via 
gnucash-user:


> Hello,

>

> I could not get the price of a mutual fund imported to GnuCash 3.6 and

> 3.7 through a CSV. Everything else seems to get imported just fine. Has

> anyone managed to achieve this?

>

> The CSV looks like the following for a mini dividend reinvestment:

>

> Date,Description,Account,Deposit,Price

> 04/5/2020,Fund Divident REINVESTMENT @ 31.5244,Brokerage Account:Mutual

> Fund:Fund,0.03902,31.522296258329064

> ,,Income:Dividend Income,-1.23,1.0

>

> When this is imported, the split transaction is imported correctly but

> the price of the fund is not. I tried the fractional form of the price

> as well. I can put it in any required format as the CSV is generated by

> a script already. BTW, if there is a GnuCash python example, I'd be fine

> with that too.

>

> Thanks in advance!

>

> ___

> 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] CSV import of fund transactions

[Geert Janssens]

Hi,

I have fixed a bug wrt to this for gnucash 3.9. Can you retry with that version 
and report back 
whether it works now ?

Regards,

Geert

Op donderdag 9 april 2020 08:04:07 CEST schreef Alaeddin Aydiner via 
gnucash-user:
> Hello,
> 
> I could not get the price of a mutual fund imported to GnuCash 3.6 and
> 3.7 through a CSV. Everything else seems to get imported just fine. Has
> anyone managed to achieve this?
> 
> The CSV looks like the following for a mini dividend reinvestment:
> 
> Date,Description,Account,Deposit,Price
> 04/5/2020,Fund Divident REINVESTMENT @ 31.5244,Brokerage Account:Mutual
> Fund:Fund,0.03902,31.522296258329064
> ,,Income:Dividend Income,-1.23,1.0
> 
> When this is imported, the split transaction is imported correctly but
> the price of the fund is not. I tried the fractional form of the price
> as well. I can put it in any required format as the CSV is generated by
> a script already. BTW, if there is a GnuCash python example, I'd be fine
> with that too.
> 
> Thanks in advance!
> 
> ___
> 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.

[GNC] CSV import of fund transactions

[Alaeddin Aydiner via gnucash-user]

Hello,

I could not get the price of a mutual fund imported to GnuCash 3.6 and 
3.7 through a CSV. Everything else seems to get imported just fine. Has 
anyone managed to achieve this?


The CSV looks like the following for a mini dividend reinvestment:

Date,Description,Account,Deposit,Price
04/5/2020,Fund Divident REINVESTMENT @ 31.5244,Brokerage Account:Mutual 
Fund:Fund,0.03902,31.522296258329064

,,Income:Dividend Income,-1.23,1.0

When this is imported, the split transaction is imported correctly but 
the price of the fund is not. I tried the fractional form of the price 
as well. I can put it in any required format as the CSV is generated by 
a script already. BTW, if there is a GnuCash python example, I'd be fine 
with that too.


Thanks in advance!

___
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] CSV Import error.

[David Cousens]

Anand,

>From your description it is not very clear what steps you are taking in
setting up the import nad what is happening when you import the file. 

The importer has a variety of options. The multiline import capability in
particular may still have some issues. I started some detailed
testing/documenting earlier in the year but overseas travel interrupted my
efforts and I am yet to get back to it.

Where does your CSV file come from?  Is it an exported GnuCash file or a
file produced by your bank?

If it is the latter, then you are likely to be importing transactions into
one specific account.  What import settings did you choose before trying to
import the file?  Common problems can occur with the date format and it is
oftenbest to select this to match the date format in the input file.

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.

[GNC] CSV Import error.

[Anand Pal]

Hi Team,

I am facing a problem while importing CSV file in GnuCash ‘Version: 3.5 Build 
ID: 3.5+(2019-03-30)’. As successful import of data some of transaction line 
getting mismatched in serial order therefore getting the wrong Sum of 
transaction. 

Please suggest the resolution.

Thanks and Regards,
Anand Pal 

Sent from Mail for Windows 10

___
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] CSV import lags and burns CPU; can't report bug

[Geert Janssens]

GnuCash 3 is using a different way to store import matcher heuristics 
internally. The first time the csv importer is run, any heuristics in the old 
format are converted to the newer format. Depending on how large this 
heuristics database is, this can take a considerable amount of time. And 
unfortunately there is no visual indication this process is running - an 
unfortunate omission. The dev that implemented the conversion probably didn't 
expect this to be an issue (and I wouldn't have either tbh).

So maybe this internal conversion is what you experienced. As it should only 
run once (if you let it complete) subsequent imports should be faster.

Regards,

Geert

Op donderdag 11 april 2019 01:12:53 CEST schreef Mark Hedges via gnucash-user:
> It was super super slow... until it wasn't.  I tried the import over again
> with the descriptions modified with an "x" so they don't stomp on
> autocomplete for previously filed transactions.  It imported 160
> transactions in about 2 seconds today.  So I don't know what was up.  Evil
> gnomes?
> 
> Mark
> 
> On Mon, Apr 8, 2019 at 3:55 PM John Ralls  wrote:
> > Huh. Another corner of the Windows Installer I hadn't noticed before.
> > 
> > Fixed, will be in the next nightly build.
> > 
> > Regards,
> > John Ralls
> > 
> > > On Apr 8, 2019, at 12:57 PM, Adrien Monteleone <
> > 
> > adrien.montele...@lusfiber.net> wrote:
> > > GnuCash’s Bugzilla database moved to bugs.gnucash.com several moons ago.
> > > 
> > > I can’t find any similar shortcut for bug filing on MacOS, so this is
> > 
> > probably for the Windows version only. (I don’t ever recall seeing it with
> > Linux versions either)
> > 
> > > You should file a bug on that as well, since it needs to point to the
> > 
> > correct location.
> > 
> > > Regards,
> > > Adrien
> > > 
> > >> On Apr 8, 2019, at 1:51 PM, Mark Hedges via gnucash-user <
> > 
> > gnucash-user@gnucash.org> wrote:
> > >> Hi.  I'm trying to import transactions from a very simple CSV file,
> > 
> > using a
> > 
> > >> default account and a single transfer account in a CSV field.  I get to
> > 
> > the
> > 
> > >> stage to go from "Transaction Information" where it says "On the
> > 
> > following
> > 
> > >> page you will be able to associate each transaction to a category."
> > 
> > Even a
> > 
> > >> 1-line CSV test file takes about 10 or 15 seconds to get to the next
> > 
> > page.
> > 
> > >> With 160 transactions, the program stops responding, though it is
> > 
> > burning
> > 
> > >>> 30% CPU.  I assume it will finish eventually, but this process seems
> > 
> > to be
> > 
> > >> very inefficient.
> > >> 
> > >> I can't seem to report a bug anymore.  I just installed GnuCash 3.5.
> > 
> > When
> > 
> > >> I go to Start > GnuCash > Report a GnuCash Bug (Online), this takes me
> > 
> > to
> > 
> > >> bugzilla.gnome.org.  It says that most projects have migrated to
> > 
> > GitLab,
> > 
> > >> but for GnuCash I should NOT go to GitLab.  When I try to log into
> > >> bugzilla, it says "Sorry, entering a bug into the product GnuCash has
> > 
> > been
> > 
> > >> disabled."  However, the GitLab site linked from the BugZilla page does
> > 
> > not
> > 
> > >> seem to have a GnuCash project.  Where should we report bugs these
> > >> days?
> > >> 
> > >> Thanks.
> > >> 
> > >> Mark Hedges
> > > 
> > > ___
> > > 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 Na

Re: [GNC] CSV import lags and burns CPU; can't report bug

[cicko]

Mark, please report issues with CSV importer as you run into them. Either
here or in Bugzilla.
One thing that's hindering my CSV import efforts is exactly the length of
time it takes to complete. I'm not sure what exactly is taking the time -
I'm suspecting it's the search for duplicates - but it would be interesting
to pinpoint. In which case, I'd file a request to have the ability to skip
that part during import.
Normally, the CSV records I'm generating don't need to be checked against
the existing transactions as they are completely new and I'd like to have
control over that decision, taking the full responsibility for the
correctness of data. I'm not downloading any statements from 3rd parties.
>From the implementation standpoint, it should be as simple as adding a
checkbox on the import form, a bool parameter that is checked before the
duplicate match (or whatever else it is) operation. 
I'm generating CSV files from transactions recorded on my mobile phone and
would really appreciate if the import was as quick as possible.
Your findings may also contribute to ironing out any other quirks with the
new CSV importer.



--
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] CSV import lags and burns CPU; can't report bug

[Mark Hedges via gnucash-user]

It was super super slow... until it wasn't.  I tried the import over again
with the descriptions modified with an "x" so they don't stomp on
autocomplete for previously filed transactions.  It imported 160
transactions in about 2 seconds today.  So I don't know what was up.  Evil
gnomes?

Mark



On Mon, Apr 8, 2019 at 3:55 PM John Ralls  wrote:

> Huh. Another corner of the Windows Installer I hadn't noticed before.
>
> Fixed, will be in the next nightly build.
>
> Regards,
> John Ralls
>
> > On Apr 8, 2019, at 12:57 PM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> >
> > GnuCash’s Bugzilla database moved to bugs.gnucash.com several moons ago.
> >
> > I can’t find any similar shortcut for bug filing on MacOS, so this is
> probably for the Windows version only. (I don’t ever recall seeing it with
> Linux versions either)
> >
> > You should file a bug on that as well, since it needs to point to the
> correct location.
> >
> > Regards,
> > Adrien
> >
> >> On Apr 8, 2019, at 1:51 PM, Mark Hedges via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >>
> >> Hi.  I'm trying to import transactions from a very simple CSV file,
> using a
> >> default account and a single transfer account in a CSV field.  I get to
> the
> >> stage to go from "Transaction Information" where it says "On the
> following
> >> page you will be able to associate each transaction to a category."
> Even a
> >> 1-line CSV test file takes about 10 or 15 seconds to get to the next
> page.
> >> With 160 transactions, the program stops responding, though it is
> burning
> >>> 30% CPU.  I assume it will finish eventually, but this process seems
> to be
> >> very inefficient.
> >>
> >> I can't seem to report a bug anymore.  I just installed GnuCash 3.5.
> When
> >> I go to Start > GnuCash > Report a GnuCash Bug (Online), this takes me
> to
> >> bugzilla.gnome.org.  It says that most projects have migrated to
> GitLab,
> >> but for GnuCash I should NOT go to GitLab.  When I try to log into
> >> bugzilla, it says "Sorry, entering a bug into the product GnuCash has
> been
> >> disabled."  However, the GitLab site linked from the BugZilla page does
> not
> >> seem to have a GnuCash project.  Where should we report bugs these days?
> >>
> >> Thanks.
> >>
> >> Mark Hedges
> >
> > ___
> > 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.

Re: [GNC] CSV import lags and burns CPU; can't report bug

[John Ralls]

Huh. Another corner of the Windows Installer I hadn't noticed before.

Fixed, will be in the next nightly build.

Regards,
John Ralls

> On Apr 8, 2019, at 12:57 PM, Adrien Monteleone 
>  wrote:
> 
> GnuCash’s Bugzilla database moved to bugs.gnucash.com several moons ago.
> 
> I can’t find any similar shortcut for bug filing on MacOS, so this is 
> probably for the Windows version only. (I don’t ever recall seeing it with 
> Linux versions either)
> 
> You should file a bug on that as well, since it needs to point to the correct 
> location.
> 
> Regards,
> Adrien
> 
>> On Apr 8, 2019, at 1:51 PM, Mark Hedges via gnucash-user 
>>  wrote:
>> 
>> Hi.  I'm trying to import transactions from a very simple CSV file, using a
>> default account and a single transfer account in a CSV field.  I get to the
>> stage to go from "Transaction Information" where it says "On the following
>> page you will be able to associate each transaction to a category."  Even a
>> 1-line CSV test file takes about 10 or 15 seconds to get to the next page.
>> With 160 transactions, the program stops responding, though it is burning
>>> 30% CPU.  I assume it will finish eventually, but this process seems to be
>> very inefficient.
>> 
>> I can't seem to report a bug anymore.  I just installed GnuCash 3.5.  When
>> I go to Start > GnuCash > Report a GnuCash Bug (Online), this takes me to
>> bugzilla.gnome.org.  It says that most projects have migrated to GitLab,
>> but for GnuCash I should NOT go to GitLab.  When I try to log into
>> bugzilla, it says "Sorry, entering a bug into the product GnuCash has been
>> disabled."  However, the GitLab site linked from the BugZilla page does not
>> seem to have a GnuCash project.  Where should we report bugs these days?
>> 
>> Thanks.
>> 
>> Mark Hedges
> 
> ___
> 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] CSV import lags and burns CPU; can't report bug

[Adrien Monteleone]

GnuCash’s Bugzilla database moved to bugs.gnucash.com several moons ago.

I can’t find any similar shortcut for bug filing on MacOS, so this is probably 
for the Windows version only. (I don’t ever recall seeing it with Linux 
versions either)

You should file a bug on that as well, since it needs to point to the correct 
location.

Regards,
Adrien

> On Apr 8, 2019, at 1:51 PM, Mark Hedges via gnucash-user 
>  wrote:
> 
> Hi.  I'm trying to import transactions from a very simple CSV file, using a
> default account and a single transfer account in a CSV field.  I get to the
> stage to go from "Transaction Information" where it says "On the following
> page you will be able to associate each transaction to a category."  Even a
> 1-line CSV test file takes about 10 or 15 seconds to get to the next page.
> With 160 transactions, the program stops responding, though it is burning
>> 30% CPU.  I assume it will finish eventually, but this process seems to be
> very inefficient.
> 
> I can't seem to report a bug anymore.  I just installed GnuCash 3.5.  When
> I go to Start > GnuCash > Report a GnuCash Bug (Online), this takes me to
> bugzilla.gnome.org.  It says that most projects have migrated to GitLab,
> but for GnuCash I should NOT go to GitLab.  When I try to log into
> bugzilla, it says "Sorry, entering a bug into the product GnuCash has been
> disabled."  However, the GitLab site linked from the BugZilla page does not
> seem to have a GnuCash project.  Where should we report bugs these days?
> 
> Thanks.
> 
> Mark Hedges

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] CSV import lags and burns CPU; can't report bug

[Mark Hedges via gnucash-user]

Hi.  I'm trying to import transactions from a very simple CSV file, using a
default account and a single transfer account in a CSV field.  I get to the
stage to go from "Transaction Information" where it says "On the following
page you will be able to associate each transaction to a category."  Even a
1-line CSV test file takes about 10 or 15 seconds to get to the next page.
With 160 transactions, the program stops responding, though it is burning
>30% CPU.  I assume it will finish eventually, but this process seems to be
very inefficient.

I can't seem to report a bug anymore.  I just installed GnuCash 3.5.  When
I go to Start > GnuCash > Report a GnuCash Bug (Online), this takes me to
bugzilla.gnome.org.  It says that most projects have migrated to GitLab,
but for GnuCash I should NOT go to GitLab.  When I try to log into
bugzilla, it says "Sorry, entering a bug into the product GnuCash has been
disabled."  However, the GitLab site linked from the BugZilla page does not
seem to have a GnuCash project.  Where should we report bugs these days?

Thanks.

Mark Hedges
___
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] CSV Import

[stephen.m.butler51]

Thanks Geert.  Apologies for top posting and typos.   I'm in Taipei on the way 
to Manilla and thence to the north end of Luzon Island.  I'll file an 
enhancement request once I'm back home in a couple of weeks.  For those wishing 
TMI, please look at www.ihsamission.comSent from my Verizon, Samsung Galaxy 
smartphone
 Original message From: Geert Janssens 
 Date: 3/18/19  18:14  (GMT+08:00) To: 
gnucash-user@gnucash.org Cc: "Stephen M. Butler"  Subject: Re: 
[GNC] CSV Import Op donderdag 14 maart 2019 17:22:48 CET schreef Stephen M. 
Butler:> For some reason my Citi Visa account has lost the ability to export 
file> in non-CSV formats.  So, running the CSV importer on the file that had> 
fields:> > Status, Date, Description, Debit, Credit, MemberName> > I mapped 
Date --> Date,  Description --> Description, Debit -->> Deposit,  Credit --> 
Withdrawl> > Noticed that there were three rows with amounts in the Credit 
column and> all said values where negative!> > Ran the importer and saw that 
those three rows were treated as charges. > What should I have done?  
Especially since Citi put negative values in> the Credit column.> > Could I map 
both columns as Deposit?  Counter-intuitive but so is Citi> Cards right now!> > 
--SteveUnfortunately you can't map both columns to Deposit. We may have to 
improve this (as well as disambiguating the names). I couldn't find an 
enhancement request for this yet in bugzilla. Feel free to add one so this 
issue won't get lost.As a workaround you can preprocess your csv files to* 
either merge the Debit and Credit columns (so you have one column with both 
positive and negative numbers and you map this column to "Deposit")* or make 
the numbers in the Credit column positive (so you have two columns with all 
positive numbers and then map Debit to Deposit and Credit to Withdrawal)Geert
___
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] CSV Import

[Geert Janssens]

Op donderdag 14 maart 2019 17:22:48 CET schreef Stephen M. Butler:
> For some reason my Citi Visa account has lost the ability to export file
> in non-CSV formats.  So, running the CSV importer on the file that had
> fields:
> 
> Status, Date, Description, Debit, Credit, MemberName
> 
> I mapped Date --> Date,  Description --> Description, Debit -->
> Deposit,  Credit --> Withdrawl
> 
> Noticed that there were three rows with amounts in the Credit column and
> all said values where negative!
> 
> Ran the importer and saw that those three rows were treated as charges. 
> What should I have done?  Especially since Citi put negative values in
> the Credit column.
> 
> Could I map both columns as Deposit?  Counter-intuitive but so is Citi
> Cards right now!
> 
> --Steve

Unfortunately you can't map both columns to Deposit. We may have to improve 
this (as well as disambiguating the names). I couldn't find an enhancement 
request for this yet in bugzilla. Feel free to add one so this issue won't get 
lost.

As a workaround you can preprocess your csv files to
* either merge the Debit and Credit columns (so you have one column with both 
positive and negative numbers and you map this column to "Deposit")
* or make the numbers in the Credit column positive (so you have two columns 
with all positive numbers and then map Debit to Deposit and Credit to 
Withdrawal)

Geert



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] CSV Import

[Stephen M. Butler]

For some reason my Citi Visa account has lost the ability to export file
in non-CSV formats.  So, running the CSV importer on the file that had
fields:

    Status, Date, Description, Debit, Credit, MemberName

I mapped Date --> Date,  Description --> Description, Debit -->
Deposit,  Credit --> Withdrawl

Noticed that there were three rows with amounts in the Credit column and
all said values where negative!

Ran the importer and saw that those three rows were treated as charges. 
What should I have done?  Especially since Citi put negative values in
the Credit column.

Could I map both columns as Deposit?  Counter-intuitive but so is Citi
Cards right now!

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