https://bugs.kde.org/show_bug.cgi?id=406321
Bug ID: 406321
Summary: ERR-8/ERR-5 importing qfx file, "More than one object
returned in 'v_account' for 't_number='''"
Product: skrooge
Version: 2.18.0
Platform: Fedora RPMs
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: general
Assignee: guillaume.deb...@gmail.com
Reporter: skierp...@gmail.com
CC: steph...@mankowski.fr
Target Milestone: ---
SUMMARY
I tried to import a .qfx file of transactions from my credit card issuer. Two
different files (different date ranges) both fail.
But if I import the same qfx files into a new Skrooge file, there's no error.
One of the qfx files has transactions that match transactions I have already
imported, the other may have a few transactions that match ones I added to
Skrooge manually. If duplication is the problem I would expect to get the amber
"NN operations not imported because they already exist" message.
STEPS TO REPRODUCE
$ export SKGTRACE=15
$ export SKGTRACESQL=1
$ skrooge
File > Import > Import qfx file.
OBSERVED RESULT
Import quickly fails with
[ERR-5]: Import of file named 'file:///path/to.qfx' failed
in the trace output,
## executeSqliteOrder:SELECT * FROM v_account WHERE t_number='' TIME=1
ms, (with fetch):2 ms
## <static int
SKGImportPluginOfx::ofxStatementCallback(OfxStatementData, void*) RC=[ERR-8]:
More than one object returned in 'v_account' for 't_number='''
## >virtual SKGError SKGDocument::endTransaction(bool)
## >virtual int SKGDocument::getCurrentTransaction() const
## <virtual int SKGDocument::getCurrentTransaction() const
## <virtual SKGError SKGDocument::endTransaction(bool) RC=[SUC-0]
## <virtual SKGError SKGImportPluginOfx::importFile() RC=[ERR-8]: More
than one object returned in 'v_account' for 't_number='''
## >virtual SKGError SKGDocument::endTransaction(bool)
## >virtual int SKGDocument::getCurrentTransaction() const
## <virtual int SKGDocument::getCurrentTransaction() const
## <virtual SKGError SKGDocument::endTransaction(bool) RC=[SUC-0]
## <SKGError SKGImportExportManager::importFile() RC=[ERR-8]: More than one
object returned in 'v_account' for 't_number='''
...
EXPECTED RESULT
Successful import, or something more informative in Skrooge messages.
SOFTWARE/OS VERSIONS
Linux/KDE Plasma:
KDE Plasma Version: 5.14.5
KDE Frameworks Version: 5.55.0
Qt Version: 5.11.3
ADDITIONAL INFORMATION
Downloading transactions yourself from a bank is much more fiddly than Quicken
2012's "One Step Update" which almost never grabbed duplicate transactions.
--
You are receiving this mail because:
You are watching all bug changes.
