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
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
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 --
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,
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
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
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
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
>
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
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
> 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
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
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
>
>
>
> 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
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
> 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
>
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
tant, 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
>>>> ca
during the month.
>>>
>>> Thank You,
>>> *Gyle McCollam*
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326 Mobile
>>>
>>> gmccol...@live.comemail
>>> --
&
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
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-u
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 f
ted. 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
>>
&g
vid.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+ytnfdjjvrvp
te 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
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>
>
...@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 i
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
$
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
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
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.
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
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
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
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
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
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
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
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
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
40 matches
Mail list logo