[GNC] Difficulty importing CSV transactions

[joe.davis at carouselschool.com]

Still on version 5.12. 

During import preview, I have no errors. As soon as I go to Match import and
GnuCash and select the account, I get Not all fields could be parsed. If I
go back to import preview and select the account there I can proceed but the
results are Amount is loaded into Withdrawal and Amount (negative) loaded
into deposit and missing the dollar value.  



-----Original Message-----
From: gnucash-user
<gnucash-user-bounces+joe.davis=carouselschool.com at gnucash.org> On Behalf Of
Angus King
Sent: Monday, October 6, 2025 6:42 PM
To: gnucash-user at gnucash.org
Subject: [GNC] Where does gnucash put the lock file on Linux?

This is to provide further detail for Linux users from a post in January
2021 (for those using and SQL backend such as sqlite). The lock table is
called 'gnclock'. To manually reset the lock you delete the records (rows)
in that table.

--

Angus King

On Wed, Jan 20, 2021 at 05:20:16PM -0800, John Ralls wrote:
>/Do I remember correctly that you're using the SQL backend? That works 
>a />/bit differently because there's no way to have a lock file if 
>you're
connected />/to a DB server. Instead of a lock file it has a lock table
inside the database. />/If you copy the database (and with SQLite3 it looks
just like a file) when />/there's a lock record in the lock table then
GnuCash will put up the "unable />/to obtain the lock" dialog box.
/>//You're absolutely right, I'm using sqlite, the above would exactly
explain what I'm seeing, thank you.

With sqlite it would, of course, be OK to use a lock file as it's not a
client/server system but I suppose it just shares the way things work with
mySql/postgresql.


--
Chris Green

_______________________________________________
gnucash-user mailing list
gnucash-user at 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.


-- 

*Carousel School deems this email and any files transmitted with it are 
confidential and intended solely for the use of the individual or entity to 
whom they are addressed. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately by e-mail if you have received this e-mail by mistake and 
delete this e-mail from your system. If you are not the intended recipient 
you are notified that disclosing, copying, distributing or taking any 
action in reliance on the contents of this information is strictly 
prohibited.*