tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/16984-demo-import-osx-transactions-many-duplicate-transactionsInfinite Kind: Discussion 2020-12-16T21:10:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/486272752020-09-14T04:54:08Z2020-09-14T04:54:08ZDemo - Import OSX transactions - Many duplicate transactions<div><p>just a user here.</p>
<p>Actually, you should have more confidence. The way import works (in any program - Quicken, MD, others) is that there is a unique ID saying something like "hey, you've imported me, so now you don't have to do it again".</p>
<p>When you delete that item - well - hey - neither the bank nor the program knows it has ever been imported, so - yeah - it gets imported again. Of course they reappear.</p>
<p>What do you WANT to happen? You need to describe more about what you mean by "duplicate data" and "beyond last imported file".</p>
<p>Hope this helps some.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/486272752020-09-14T05:23:14Z2020-09-14T05:23:15ZDemo - Import OSX transactions - Many duplicate transactions<div><p>OK, so let be more specific. From a fresh installation of MoneyDance, I imported a series of data files from a single bank account.<br>
- first, I exported/imported transactions in OFX file for 1 Jan 2020 to 12 Sept 2020. this seemed more transactions than necessary to test Moneydance. and I understand that auto-categorization applies only to similar transactions in subsequent imports (so better import in multiple small uploads). regardless, I deleted all transactions. - second, I exported/imported transactions in OFX file for default period (mid August to mid September 2020). Immediately following upload then all transactions from 1 Jan 2020 appeared, with transactions between mid-Aug to mid-Sept appearing twice. Presuming I had done something dumb, and reflecting on better approach of calendar month uploads, then I deleted all transactions. - Third, I exported/imported transactions in OFX file for calendar month of August. Following upload then all transactions from 1 Jan appeared. Transactions 1 Aug to mid Aug appeared three times. Those in Sept twice.</p>
<p>"What do I want to happen": - transactions deleted should remain deleted, rather than somehow be reactivated in an unrelated future action. reappearance of previously deleted data seems a data integrity dealbreaker. - ideally, import process would detect duplicate transactions - or at least flag likely duplicate transactions for user review</p>
<p>Hope this helps some.</p></div>Rtag:infinitekind.tenderapp.com,2009-01-14:Comment/486272752020-09-15T04:54:54Z2020-09-15T04:54:54ZDemo - Import OSX transactions - Many duplicate transactions<div><p>ok - i have no idea.</p>
<p>it seems like maybe you didn't delete the transactions, but that doesn't make sense if they went away before you did another import. So, I have no clue.</p>
<p>As for detecting duplicate transactions - that would be problematic. You said "I want to import these items" - if they are duplicates, or triplicates - you said you wanted them. Fixing this is what the merge transactions items is for.</p>
<p>I'm passing on this - I'm just a fellow user.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/486272752020-09-15T05:09:31Z2020-09-15T05:09:31ZDemo - Import OSX transactions - Many duplicate transactions<div><p>I'm a fellow user.</p>
<p>The main occasions that I have seen transactions reappearing is when the data set has been housed in a service like Dropbox, occasionally strange things have happened if there is a corrupted transactions file.</p>
<p>If you post your Moneydance error log it can be examined to see if there is anything in there that may point to an issue.</p>
<p>If you're using Mac OS, it should be located at one of these locations within your Home folder:</p>
<p>~/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt</p>
<p>or:</p>
<p>~/Library/Application Support/Moneydance/errlog.txt</p>
<p>If you have any trouble finding your Home Library folder you can open Finder and hold down the option key while selecting the Go menu and the Library folder option should occur or you can open Finder and select Go -> Go to Folder and copy and paste in the following:</p>
<p>~/Library</p>
<p>This should pull up your local Library folder.</p>
<p>If you're using Windows, it should be located under your login directory at:</p>
<p>C:\Users(yourusername).moneydance\errlog.txt</p>
<p>or</p>
<p>C:\Documents and Settings(yourusername).moneydance\errlog.txt</p>
<p>Depending on your version of Windows</p>
<p>If you're using Linux it should be located in your home folder at:<br>
~/.moneydance/errlog.txt</p>
<p>I would say that deleting transactions then trying a new technique is not optimum, this just adds data to the data set it does not remove it as such, the preferred technique is to instead create a new data set using the File --> New Menu command.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/486272752020-09-16T19:22:46Z2020-09-16T19:22:48ZDemo - Import OSX transactions - Many duplicate transactions<div><p>Appreciate efforts. Attached errlog but its content doesn't seem that interesting to my uneducated eyes.<br>
Understand final comment about New File. Sensible advice and certainly doable. Greater care on uploads would avoid repetition of challenges. I just uploaded one month OFX file for a different bank account - it was fine and previously deleted data on original account did not re-appear. Given context of software trial then reappearance of previously deleted data does raise data integrity concerns.</p></div>Rosstag:infinitekind.tenderapp.com,2009-01-14:Comment/486272752020-09-16T21:09:49Z2020-09-16T21:09:49ZDemo - Import OSX transactions - Many duplicate transactions<div><p>The error log is incomplete but it looks like there was something in the OFX transactions that the software did not like. There is not enough information to say much else.</p></div>dwg