search

stant / mdcsvimporter2015

GNU Lesser General Public License v3.0
13 stars 5 forks source link

Sometimes deletes unwanted double transactions #6

Closed OscarvanDijk closed 8 years ago

OscarvanDijk commented 8 years ago

I import a 205 row file to the Import account. The import account is empty. Sometimes the status reports 205 rows found, found 2 double 203 rows imported. I would like to know what the classification for the double transaction is.

Br. Oscar

stant commented 8 years ago

Hello Oscar, I use original transaction values, not what you may have edited them to. I concatenate: DateInitiated:Amount:PayeeName[Description]:CheckNumber [without leading zeros]:Memo Stan -------- Original message --------From: OscarvanDijk notifications@github.com Date: 4/30/2016 10:34 AM (GMT-05:00) To: stant/mdcsvimporter2015 mdcsvimporter2015@noreply.github.com Subject: [stant/mdcsvimporter2015] Sometimes deletes unwanted double transactions (#6) I import a 205 row file to the Import account. The import account is empty. Sometimes the status reports 205 rows found, found 2 double 203 rows imported.

I would like to know what the classification for the double transaction is.

Br. Oscar

— You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub

OscarvanDijk commented 8 years ago

Hi Stan,

Thanks, I have found the reason for the double in my CSV file. My bank does not use the CheckNumber, Some of the entries had everything the same including the amount and the Payee. I have now changed my CSV file a little. This has solved the problem. Oscar

stant commented 8 years ago

Is that valid, what the bank gives you?

What do you change in your file and will you have to do that all the time to import it?

Stan On May 1, 2016 3:21 PM, "OscarvanDijk" notifications@github.com wrote:

Closed #6 https://github.com/stant/mdcsvimporter2015/issues/6.

— You are receiving this because you commented. Reply to this email directly or view it on GitHub https://github.com/stant/mdcsvimporter2015/issues/6#event-646965860

OscarvanDijk commented 8 years ago

The data from the bank is valid, I have checked this. The issue is that I have a payment split over 2 separate accounts. The split is 50/50 so these showed up as doubles. The strange thing is that some of the entries were OK while others were marked as double and not processed. Since I have to modify the CSV file anyway, I have now added the account number to the Payee. This solved the problem. And yes, I need to do this all the time. It might not be that big issue in the future but I imported 4 months of data this time.

Oscar