wish list2: import old transaction first

[Hello World]

Hi Stan

My transactions in csv files have new records on top and old records
on the bottom.
I think most csv files from banks are like that.

I would get incorrect balance often if the transactions are not
imported in the orderly fashion from old to new.

Example transaction (Credit Card)

Date,Description,Debit/Credit,Balance
12/02/2012,"TFR TO: testing,$1.60,,$0.00
11/02/2012,"TFR testing",5187560832827148,,$60.00,$1.60
11/02/2012,"Testing purchased",some thing,$59.00,,-$58.40

It would be great if mdcsvimporter can sort the transactions first
from bottoms to tops.

Thanks for your work.

[stashu pub]

Hmmm. Does MD care what order they are imported? in MD do you have your columns ordered by date, and does that fix your problem?

Thanks,
Stan Towianski

--
You received this message because you are subscribed to the Google Groups "mdcsvimporter" group.
To post to this group, send email to mdcsvi...@googlegroups.com.
To unsubscribe from this group, send email to mdcsvimporte...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/mdcsvimporter?hl=en.

[Hello World]

Hey;

The date sort column in MD, it does only sort transaction by date, it
doesn't do any thing else.

The balance column in MD for each transaction, MD calculates
automatically, base on what comes first.

Let me make an other sample, will be a bit more clear.

Let say I have two transactions, first I deposit $500.00, then I spent
$500.00.
I expect first transaction has balance of $500.00, second transaction
balance should be $0.00

Here csv file:

Date, Description, Account, Debit, Credit,Balance
14/07/2011,"Spent",20250743,500,,0.00
14/07/2011,"Deposit",20250743,,500,500

MD imported the top transaction first of Spent $500.00 and the balance
in MD column was -$500.00 (Wrong)
Then
MD imported the second transaction of Deposit $500.00 and the balance
in MD column was $0.00 (correct)

As you can see, the first transaction balance in MD column was not
correct.

But If I sort the transactions above with the following would be
correct.

Date, Description, Account, Debit, Credit,Balance
14/07/2011,"Deposit",20250743,,500,500
14/07/2011,"Spent",20250743,500,,0.00

That was an example of a credit card account.

I also have a saving account which displayed many transactions with
negative balances.
Which not possible because I can't spend what I don't have.

On Feb 12, 10:59 am, stashu pub <stashu....@gmail.com> wrote:
> Hmmm. Does MD care what order they are imported? in MD do you have your
> columns ordered by date, and does that fix your problem?
>
> Thanks,
> Stan Towianski

[stashu pub]

Ok. But I don't think your actually want sorting, because my guess is that your problem only happens with transactions on the same date?

You really just want to be able to import them in reverse order?

Can you create an enhancement request for this at:

http://code.google.com/p/mdcsvimporter/issues/list

Thanks,
Stan Towianski

[Hello World]

Hi Stan

You were right, the problem was only when more than one transactions
in the same date.

Cheer.

On Feb 13, 1:26 am, stashu pub <stashu....@gmail.com> wrote:
> Ok. But I don't think your actually want sorting, because my guess is that
> your problem only happens with transactions on the same date?
>
> You really just want to be able to import them in reverse order?
>
> Can you create an enhancement request for this at:
>
> http://code.google.com/p/mdcsvimporter/issues/list
>
> Thanks,
> Stan Towianski

[stashu.pub]

Hi,

15.7.4
--- enhancements: ---

added 'ignore rest' field type
added Import in Reverse Order Flag for custom reader.   <---

--- Fixes: ---

skip footer line count was not working for custom reader. I assume a footer line
could be a different line format than the data lines but I was still parsing them
in the canParse() method so I made it simply skip them there like I do when using the data. This error would have made it think the custom reader would not work.

Thanks,
Stan Towianski

[Hello World]

Hi Stan;

Just to say thank you.

[stashu pub]

You're welcome.

Stan

On Feb 18, 2012 2:56 AM, "Hello World" <disg...@gmail.com> wrote:

Hi Stan;

Just to say thank you.