Import from csv is missing some transactions

Andy's Avatar

Andy

04 May, 2022 08:37 AM

Hi, I'm importing csv files using the import function. For some reason, several of the transactions are not imported. It seems to be completely random. The import process just skips some transactions (about 10 out of 45). These are not sequential.
I then have to enter these manually.

Any help gratefully accepted

  1. 1 Posted by stashu.pub on 05 May, 2022 10:27 PM

    stashu.pub's Avatar

    if you use my mdcsvimporter extension, it does transaction matching so if you try to import trans. that you did before it will ignore them after that.
    https://github.com/stant/mdcsvimporter2015

    it matches on these fields it looks like:
    getDateInitiatedInt, getAmount, getName, getCheckNum, getMemo

    if those are all the same as another txn, it will not import it.

    otherwise I don't know.

  2. Support Staff 2 Posted by Ethan on 07 May, 2022 02:33 PM

    Ethan's Avatar

    I think we would need more information to evaluate this. If you would be willing to post a selection of this CSV file, which contained at least some transactions that imported correctly, and some that appear to be skipped, we could look at the data structure more closely. Keep in mind this is a public thread. You can also start a private one if you only want our support staff to see it.

    Ethan
    Infinite Kind Support

  3. System closed this discussion on 06 Aug, 2022 02:40 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac