[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 Thomas Baumgart changed: What|Removed |Added Status|NEEDSINFO |RESOLVED Version Fixed In||5.0.5 Latest Commit||https://commits.kde.org/kmy ||money/ab628d659ebcbea9265b6 ||2e8dc419c3bb20bbcb7 Resolution|WAITINGFORINFO |FIXED -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 Thomas Baumgart changed: What|Removed |Added Resolution|--- |WAITINGFORINFO Status|REPORTED|NEEDSINFO --- Comment #20 from Thomas Baumgart --- Clear out the BANKID field as well. Only if both fields are empty you will be asked for a manual account assignment. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #19 from Dominique Dumont --- Hi I've been testing kmymoney from 5.0 branch. The only change I've seen (although I might be wrong) is ofx importer proposes a different account when is present or not: - with importer proposes "cartes de crédit" - without , importer proposes main account Unfortunately, the ofx importer ignores the target account choice and imports data in the wrong (or right) account depending on whether is present or not. All the best -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #18 from Thomas Baumgart --- Git commit ab628d659ebcbea9265b62e8dc419c3bb20bbcb7 by Thomas Baumgart. Committed on 29/06/2019 at 12:16. Pushed by tbaumgart into branch '5.0'. Use mapped account only if information is present Using the OFX (file) importer may not provide information about the account the imported data relates to. In this case, it does not make sense to search for an online mapping. Doing so leads to false results, as without values for account or routing number the first mapped account will be selected which is wrong. This change does not try the mapping if both values are empty and allows the user to select the account as part of the process. M +4-1kmymoney/plugins/ofx/import/ofximporter.cpp https://commits.kde.org/kmymoney/ab628d659ebcbea9265b62e8dc419c3bb20bbcb7 -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #17 from Thomas Baumgart --- This sounds very similar to a problem we had with the AqBanking importer. This was handled in bug #408494. In fact, this could be the identical problem. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #16 from Dominique Dumont --- And now I have the opposite problem: once tag is removed, all transactions go the main bank account. I cannot import in the Credit card account. Assuming there's something wrong with my kmy file, do you have an idea how I can get out of this mess ? All the best -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #15 from Dominique Dumont --- Hello Yes, the "StatementKey" also appears in the context of "Cartes de Credits La Poste": $ zgrep -B 3 0048775Z028 domi-v5.kmy -- Jack, Yes, the statements are imported manually with ofx files. And I've created manually the accounts. Thomas, It's possible that I've created the "Cartes de Credits La Poste" account using the same number as the main account: On "labanquepostale" site, the credit card transactions are associated to the main account and I did not realize that this number is key in kmymoney internal data structure. Should I manually change this number in my .kmy file ? All the best -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 Jack changed: What|Removed |Added Status|NEEDSINFO |REPORTED Resolution|WAITINGFORINFO |--- --- Comment #14 from Jack --- As I follow this, all imports have been of downloaded files, and not direct connect. Is it possible a file was once imported to the wrong account, and the statement key was associated with that account? Is there any way to clear this pair through the GUI? (I'm changing status to be sure Thomas notices, since I suspect Dominique doesn't have an answer to the question of how the info got associated with the "wrong" account.) -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 Thomas Baumgart changed: What|Removed |Added Status|REPORTED|NEEDSINFO Resolution|--- |WAITINGFORINFO --- Comment #13 from Thomas Baumgart --- I fully understand your privacy concerns. Thanks for providing the information in obfuscated form, which is helpful. The problem seems to be that shows up twice. I looks to me that the second occurrence in your output contains to the element of the account in question. Does the second one show up in the context of the account "Cartes de Credits La Poste"? This would explain what is happening. I wonder how it got there, though? -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 Dominique Dumont changed: What|Removed |Added Resolution|WAITINGFORINFO |--- Status|NEEDSINFO |REPORTED --- Comment #12 from Dominique Dumont --- Well, the information provided by is my bank account number which I'm quite reluctant to post on a public forum :-). So this number is replaced with a dummy value. Hopefully, this will not impact your investigation of this issue. And the zgrep command provides 2 other real account numbers which are also masked (with 1234567b and 1234567c). This information provided by is replaced with 1234567a $ zgrep StatementKey domi-v5.kmy $ zgrep 1234567a domi-v5.kmy All the best -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 Thomas Baumgart changed: What|Removed |Added Resolution|--- |WAITINGFORINFO Status|REPORTED|NEEDSINFO --- Comment #11 from Thomas Baumgart --- This is really strange. Can you provide us with the output of the following commands, please: zgrep StatementKey domi-v5.kmy zgrep ### domi-v5.kmy where your replace ### with the information following that you remove when things work. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #10 from Dominique Dumont --- I've found that the right account is selected if tag (with its data) is removed from the OFX file before import. Hope this helps -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #9 from Dominique Dumont --- BTW, ofx import begins with: OfxImporterPlugin::slotImportFile setup callback routines process data LibOFX INFO: libofx_proc_file(): File format not specified, autodetecting... LibOFX INFO: libofx_proc_file(): Detected file format: OFX (Open Financial eXchange (OFX or QFX)) LibOFX STATUS: find_dtd():DTD found: /usr/share/libofx7/libofx/dtd/opensp.dcl LibOFX STATUS: find_dtd():DTD found: /usr/share/libofx7/libofx/dtd/ofx160.dtd LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate SIGNONMSGSRSV1 LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate SONRS LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate BANKMSGSRSV1 LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate STMTTRNRS process data done OfxImporterPlugin::storeStatements() with 1 statements called OfxImporterPlugin::importStatement start KMyMoneyPlugin::KMMStatementInterface::import start Importing statement for 'Cartes de Credits La Poste' Processing transactions (Cartes de Credits La Poste) I've no idea why the import is done on 'Cartes de Credits La Poste' even though I've selected another account in the import menu that shows account list. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #8 from Thomas Baumgart --- Good, since the parameter is normally only provided when using OFX direct connect but might have caused interference in this case. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 Dominique Dumont changed: What|Removed |Added Status|NEEDSINFO |REPORTED Resolution|WAITINGFORINFO |--- --- Comment #7 from Dominique Dumont --- ok, I've used a copy of a v4 file and imported an ofx file with kmymoney 5.0.3. But the result of the grep command is empty: $ ll domi-v5.kmy -rw--- 1 domi domi 227885 Mar 29 19:00 domi-v5.kmy $ zgrep kmmofx-acc-ref domi-v5.kmy $ zgrep -i kmmofx-acc-ref domi-v5.kmy $ All the best -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #6 from Thomas Baumgart --- Sorry, did not see your answer because the status did not change. Can you do a zgrep kmmofx-acc-ref and check if the value assigned to this key resembles information in your OFX file (should by BANKID and ACCTID)? -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #5 from Bug Janitor Service --- Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please mark the bug as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone! -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #4 from Dominique Dumont --- Hi I hope you meant to grep the OFX file I get from the bank. All transaction of the OFX file are stored on one line, so the grep command is pretty much useless. However, I hope this (formatted and redacted) extract from the OFX file contains the information you need: EUR 20041 01xxx 00 CHECKING xx The "Cartes de Credits La Poste" account is not mapped to an online account. All transactions were imported from OFX files with kmymoney 4 All the best -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 Thomas Baumgart changed: What|Removed |Added Resolution|--- |WAITINGFORINFO Status|REPORTED|NEEDSINFO --- Comment #3 from Thomas Baumgart --- Setup ticket state -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #2 from Thomas Baumgart --- What is the output of the following command run on your grep ACCT Is your "Cartes de Credits La Poste" mapped to an online OFX account? -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405206] OFX import targets the wrong account
https://bugs.kde.org/show_bug.cgi?id=405206 --- Comment #1 from Dominique Dumont --- Note: this is the first time I use kmyney 5. The kmy file I'm using was written by kmymoney 4.8.1.1. IIRC, the last import operation was using account "Cartes de Credits La Poste". HTH -- You are receiving this mail because: You are watching all bug changes.
