[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #14 from skierpage --- (In reply to Stephane MANKOWSKI from comment #13) > Git commit 600a94a733a4bb32b29e97329a36d9f34dc88b72 by Stephane MANKOWSKI. If I rebuild with this, run with the buggy libofx 0.9.13 and import my original troublesome file, * there is no crash (good!) * the trace still has accountNumber=[blank] (OK, the libofx bug) * No Skrooge message about import, neither green, orange, nor red. There is just a "1 file successfully imported" in the footer (hmmm) * all transactions import as operations on wallet "credit card" with no account number (expected) * all the transactions have date 12/31/69 (BUG!) I think this last regression is known bug 406741. I'll try the fixed version. -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 Stephane MANKOWSKI changed: What|Removed |Added Resolution|--- |FIXED Latest Commit|https://commits.kde.org/skr |https://commits.kde.org/skr |ooge/2471a3eadff09f3754e02f |ooge/600a94a733a4bb32b29e97 |9e2745213c68ccb298 |329a36d9f34dc88b72 Status|REOPENED|RESOLVED --- Comment #13 from Stephane MANKOWSKI --- Git commit 600a94a733a4bb32b29e97329a36d9f34dc88b72 by Stephane MANKOWSKI. Committed on 19/04/2019 at 17:06. Pushed by smankowski into branch 'master'. M +3-3plugins/import/skrooge_import_ofx/skgimportpluginofx.cpp A +12 -0tests/input/skgtestimportofx/406321_2.ofx M +14 -0tests/skgbankmodelertest/skgtestimportofx.cpp https://commits.kde.org/skrooge/600a94a733a4bb32b29e97329a36d9f34dc88b72 -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #12 from skierpage --- While reducing the test case, I discovered WORKAROUND: problem goes away if I insert linebreaks between the SGML tags of the qfx file, which output all its SGML tags (...) on one line. The problem is in the LibOFX library that skrooge and other programs use to read OFX/QFX files, reported against GnuCash https://bugs.gnucash.org/show_bug.cgi?id=797081 , and fixed in LibOFX release 0.9.14: * Fix proprietary tags striping eating the content of the previous tag if proprietary tag is in the middle of the line. Fedora 29 has version 0.9.13 of this library, hence Skrooge exhibits the bug. If you install the 'ofx' package you can see that its `ofxdump` utility prints "Account ID: " in version 0.9.13, but if I build 0.9.14 it prints the correct account number from the OFX file. So this bug is in a supporting library, and is fixed in a newer version of that library. Skrooge's behavior isn't ideal in that it doesn't warn about no account number and only fails if I have existing accounts in my .skg file, but the bug isn't its fault. -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321
--- Comment #11 from skierpage ---
(In reply to Stephane MANKOWSKI from comment #10)
> Do you have an answer?
Sorry I was busy doing taxes (with Skrooge, *love* the Group by > Category and
Bookmarks > Bookmark current page > Rename). The trace now contains (I'll send
the full trace separately):
##>virtual SKGError SKGImportPluginOfx::importFile()
## >static SKGError SKGImportPluginOfx::getAccount(OfxAccountData*,
SKGDocumentBank*, SKGAccountObject&)
##>static QString SKGImportPluginOfx::getAccountName(OfxAccountData*)
##accountNumber=
##static SKGError SKGImportPluginOfx::getAccount(OfxAccountData*,
SKGDocumentBank*, SKGAccountObject&)
##>static QString SKGImportPluginOfx::getAccountName(OfxAccountData*)
##accountNumber=
## and <{bankname}.BASICACCT>; these SGML tags are within the CCACCTFROM
tag.
--
You are receiving this mail because:
You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #10 from Stephane MANKOWSKI --- Do you have an answer? -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #9 from Stephane MANKOWSKI --- Hi, What you did seems to be OK! Just to be sure, when you launch: skrooge --version do you have this ? skrooge 2.19.0BETA I did a new commit with more traces. Could you do that? 1- build and install this new version 2- export SKGTRACE=3 3- skrooge > traces.txt 2>&1 4- do the import 5- Send me the generated traces by email (you can find it in the "About" of Skrooge). Regards. -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #8 from skierpage --- (In reply to Stephane MANKOWSKI from comment #7) > Did you install the new version (sudo make install) ? I rebuilt the Skrooge 2.18 packages for Fedora 29 from Git master, which produced $ ls -1 ~/rpmbuild/RPMS/x86_64 skrooge-debuginfo-master-0.fc29.x86_64.rpm skrooge-debugsource-master-0.fc29.x86_64.rpm skrooge-libs-debuginfo-master-0.fc29.x86_64.rpm skrooge-libs-master-0.fc29.x86_64.rpm skrooge-master-0.fc29.x86_64.rpm and then I did `sudo dnf install ~/rpmbuild/RPMS/x86_64/skrooge-*.rpm` to install all of these. > If NO, the plugins used are the system ones, so the old ones. I think I only have my newly-built plugins, is there a way to check that they are the latest code? (Is there a version string in each one?). $ ls -s -l `locate skrooge_import_ofx.so` -rwxr-xr-x. 1 spage spage 2011968 Apr 10 19:13 /home/spage/rpmbuild/BUILD/skrooge-master/x86_64-redhat-linux-gnu/lib/skrooge_import_ofx.so -rwxr-xr-x. 1 root root 114208 Apr 10 19:14 /usr/lib64/qt5/plugins/skrooge_import_ofx.so -rw-r--r--. 1 root root 1510928 Apr 10 19:14 /usr/lib/debug/usr/lib64/qt5/plugins/skrooge_import_ofx.so-master-0.fc29.x86_64.debug so I'm pretty sure this is entirely the new 2.19.0BETA code, but this is the first time I've done this ;-) . -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #7 from Stephane MANKOWSKI --- (In reply to skierpage from comment #6) > I think I managed to build skrooge git master from source \o/ (`skrooge -v` > reports "skrooge 2.19.0BETA"), and importing those two .qfx files gives me > the same error and similar trace output. Did you install the new version (sudo make install) ? If NO, the plugins used are the system ones, so the old ones. You must install the new version if you want to be able to test it. Regards. Thank you for your donation. -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 skierpage changed: What|Removed |Added Resolution|FIXED |--- Status|RESOLVED|REOPENED --- Comment #6 from skierpage --- I think I managed to build skrooge git master from source \o/ (`skrooge -v` reports "skrooge 2.19.0BETA"), and importing those two .qfx files gives me the same error and similar trace output. -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #5 from skierpage --- (In reply to Stephane MANKOWSKI from comment #3) > The issue it due to empty value is in your qfx file. There is an ACCTID in both qfx files, and it matches the Number field of one of the existing Credit card account in my Skrooge file. They're in the OFXSGML format VERSION 102 with many tags missing a matching closing tag, including ACCTID. There's also a tag with the same number. I tried changing the Number of the existing credit card account in a copy of my Skrooge file so that it wouldn't match, and import still failed with the same SQL error (and then Skrooge crashed with a double-free, I filed DrKonqi bug). I have one account without any Number, a cash wallet. I could try to delete stuff from my Skrooge file until import succeeds (again, importing the .qfx files into an empty file succeeded), but I'm not sure where to start. > I will try to find a solution. (... then FIXED?) Your are awesome, thanks so much! (I donated €10 to KDE e.V.) -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 Stephane MANKOWSKI changed: What|Removed |Added Latest Commit||https://commits.kde.org/skr ||ooge/2471a3eadff09f3754e02f ||9e2745213c68ccb298 Status|ASSIGNED|RESOLVED Resolution|--- |FIXED --- Comment #4 from Stephane MANKOWSKI --- Git commit 2471a3eadff09f3754e02f9e2745213c68ccb298 by Stephane MANKOWSKI. Committed on 09/04/2019 at 18:34. Pushed by smankowski into branch 'master'. ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''" M +1-0CHANGELOG M +17 -4plugins/import/skrooge_import_ofx/skgimportpluginofx.cpp M +1-0plugins/import/skrooge_import_ofx/skgimportpluginofx.h A +92 -0tests/input/skgtestimportofx/406321.ofx A +---tests/input/skgtestimportofx/406321.skg M +13 -0tests/skgbankmodelertest/skgtestimportofx.cpp https://commits.kde.org/skrooge/2471a3eadff09f3754e02f9e2745213c68ccb298 -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #3 from Stephane MANKOWSKI --- Hi, The issue it due to empty value is in your qfx file. I will try to find a solution. -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #2 from Stephane MANKOWSKI --- Hi, Forget my previous request, I'm able to reproduce the issue. -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 --- Comment #1 from Stephane MANKOWSKI --- Hi, Skrooge tries to find the most appropriate existing account to import the operation. In you case, 2 accounts are already existing and without account number set. In the imported file, the account_id seems to be empty, so Skrooge finds the 2 existing accounts as candidates. In the doubts, I prefer to raise an error. Could you send me a qfx sample file (anonymized) to reproduce the error (I tried to build it manually but without success)? Regards. -- You are receiving this mail because: You are watching all bug changes.
[skrooge] [Bug 406321] ERR-8/ERR-5 importing qfx file, "More than one object returned in 'v_account' for 't_number='''"
https://bugs.kde.org/show_bug.cgi?id=406321 Stephane MANKOWSKI changed: What|Removed |Added Status|REPORTED|ASSIGNED Ever confirmed|0 |1 Assignee|guillaume.deb...@gmail.com |steph...@mankowski.fr -- You are receiving this mail because: You are watching all bug changes.
