Hey Tommy,
thanks, just filed a bug: https://bugs.gnucash.org/show_bug.cgi?id=799448
On 23/10/2024 23:11, Tommy Trussell wrote:
Sorry I've been away from the list
It sounds like your particular issue was not addressed in the updates.
Have you yet opened a bug on Bugzilla?
https://bugs.gnuca
Sorry I've been away from the list
It sounds like your particular issue was not addressed in the updates. Have
you yet opened a bug on Bugzilla?
https://bugs.gnucash.org/
Be sure to include your test case you described at the beginning of this
thread.
If you have never filed a bug before, you m
Hi Tommy!
So I'm using version 5.9 (Build ID: 5.9+(2024-09-28)) on MacOS ---
that's the
latest available one in brew. I had the same issue on Linux though, also
in the
latest version available from flathub.
On 2024-10-19 20:17, Tommy Trussell wrote:
On Sat, Oct 19, 2024 at 4:38 AM Dmitry Zoti
On Sat, Oct 19, 2024 at 4:38 AM Dmitry Zotikov
wrote:
> has anyone else noticed issues with CSV imports / exports in GnuCash 5.x?
>
Apparently some have -- see the thread from yesterday titled "[GNC]
duplicate transactions exported"
You did not specify which version 5.x or operating system you
Hi all,
has anyone else noticed issues with CSV imports / exports in GnuCash 5.x?
When using "Trading accounts", no transactions under Trading:CURRENCY are
included in the CSV export. Additionally, when importing the exported
file back,
I get this message: "No new transaction were found in thi
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
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?
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
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 -- Someth
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 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 t
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 impor
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
> quit
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@g
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
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
> 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 creat
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
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 E5D
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
profi
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
profi
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
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 d
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 Exce
> 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
> characte
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
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
gt;>>> 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 reconci
during the month.
>>>
>>> Thank You,
>>> *Gyle McCollam*
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326 Mobile
>>>
>>> gmccol...@live.comemail
>>> --
>&g
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 pri
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
eing 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
&g
;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+y
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
>
>
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
...@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
$ lsb_releas
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
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 Struct
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
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 *
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,Descriptio
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 h
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 Gn
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
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/d
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 Reg
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
unfo
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 w
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
O
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 simi
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
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." Eve
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:>
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 mappe
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 --> Wit
60 matches
Mail list logo
