For many years I have been happily using GnuCash (unsure of which version)
on Linux Mint. I just reinstalled my OS, now using Arch Linux, and
installed GnuCash (5.10) from the package repositories with pacman.
The whole time I've been using GnuCash, I've also been using GnuCash
Android. I know this is a separate project that appears to have been
abandoned. But the app has worked well enough for my needs. Usually I enter
transactions in GnuCash Android. At the end of the the month I export the
transactions in QIF format, email them to myself, and then import them into
GnuCash on my linux computer.
My several attempts to do this today have failed at the point of importing
the QIF file into the new version of GnuCash (5.10) running on Arch Linux.
I tried importing 3 different QIF files (two of them with nearly a month
worth of transactions in them, and one test file with only a single
transaction in it).
Once I realized this simply is not working, I decided to install GnuCash
(5.10) on my Macbook Pro (Apple Silicon). Again, I tried to import the QIF
files, but the transactions that are in the QIF files are simply not loaded
into the application. I can't find them anywhere in the application.
GnuCash (5.10) is not reporting any errors. In fact, the GUI leads me to
think that everything is working just fine, except for the fact that I can
not see any of the transactions that should have been successfully imported.
I decided to try and debug this problem myself by creating a single test
transaction with my GnuCash Android application, and exporting that file
like I normally do. Here is the content of that file:
-------------------------------------------------------------------------
!Account
NAccrued Expenses:USBank Credit Card
^
!Type:CCard
D2025/3/1
PTest
M
SAccrued Expenses:Lessons:Piano
$-1.00
^
--------------------------------------------------------------------------
Then on my Arch Linux machine, after some googling, I found that I could
watch the trace logs of the application with this command:
tail -f /tmp/gnucash.trace
So I started to tail the trace and went through the process of importing
the transactions again:
1. Import QIF files
* click the Next button.
2. Select a QIF file to load
* select the file to import
* click the Next button
3. Load QIF files
* click the Start button
* GnuCash shows the "Loading completed" message
* trace log shows the following message:
* 20:13:45 WARN <gnc.scm> qif-parse:parse-date/format: format is y-d-m
but date is [2025/3/1].
* click the Next button
4. Set a date format for this QIF file
* select the "y-m-d" option in the date format select options
* click the Next button
5. QIF files you have loaded
* the file I selected is displayed in the list of files that have been
loaded
* click the Next button
6. Accounts and stock holdings
* click the Next button
7. Match QIF accounts with GnuCash accounts
* QIF account name displayed as "Accrued Expenses:USBank Credit Card"
* GnuCash account name displayed as "Accrued Expenses:USBank Credit
Card"
* click the Next button
8. Income and Expense categories
* click the Next button
9. Match QIF categories with GnuCash accounts
* QIF category name displayed as "Accrued Expenses:Lessons:Piano"
* GnuCash account name displayed as "Accrued Expenses:Lessons:Piano"
* click the Next button
10. Choose the QIF file currency
* select the "USD (US Dollar)" option in the currency select options
* click the Next button
11. QIF Import
* When you press the Start Button, GnuCash will import your QIF data.
If there are no errors or warnings, you will automatically proceed to the
next step. Otherwise, the details will be shown below for your review.
* click the "Start Import" button
* the trace log shows the following message:
* 20:27:48 WARN <gnc.scm> Probable error: the new account tree has no
transactions.
12. Update your GnuCash accounts
* No errors or warnings are displayed. The application shows the normal
3 sentences starting with 'Click "Apply" to ...', 'Click "Back" to ...',
'Click "Cancel" to ...'
* click the Apply button
13. Qif Import Summary
* click the Close button
At this point, GnuCash has an asterisk next to the file name in the title
in the application window, indicating there are unsaved changes. So, I
press CTRL+S to save the application state and the asterisk goes away,
indicated the file has been saved.
But then when I go to look for my test transaction, I can not find it
anywhere in either of the accounts: "Accrued Expenses:USBank Credit Card",
or "Accrued Expenses:Lessons:Piano".
The transaction is simply not imported correctly.
So to summarize the output of the trace file, here is what I see was tailed
to the logs during the test:
tail -f /tmp/gnucash.trace
* 20:13:45 WARN <gnc.scm> qif-parse:parse-date/format: format is y-d-m but
date is [2025/3/1].
* 20:27:48 WARN <gnc.scm> Probable error: the new account tree has no
transactions.
When I try the same test on MacOS, I get the same results with the
exception that nothing shows up at all in the trace logs. I don't know if
I'm watching the correct file on the Mac. I'm trying to trace the logs in
the file "/var/folders/w9/<some_apparent_hashing_directory>/T/gnucash.trace
Anyway, I'm really curious what I need to do to get this working again. I
don't know if I need to downgrade to some previous version of GnuCash, or
if I need to install some other packages on my Arch Linux machine.
If anyone can help me get things working again, I will really appreciate
your help. I don't know what I'm going to do if I can't import my
transactions in a QIF file anymore.
Thank you in advance,
Elliot
_______________________________________________
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.
