wish: index for importing csv files

[Teodor Neagu]

WISH:

When you import the transactions from the bank account statement in csv format and you have several transactions on the same day, they are not imported in the same order from the bank statement. For this reason "Balance" is not the same as the one in the bank statement. I know that in HomeBank there is the option to arrange the individual transactions, but when you import account statements from several years ago, it is painful to arrange hundreds of transactions.
The problem can be solved by adding an index and importing according to indexing.

I know you hear this many times, but I feel the need to say it myself: You are doing an extraordinary job with HomeBank!

Thank you!

[AyesC (ayesc)]

Hello,

I would like to add that I have experienced the same issue from the statements generated by my bank in the Intuit Quicken format (and with CSV as well). If there are multiple transactions in a single day, they are often not in the correct order, and I must manually re-order them so that the balance is correct.

This wish would save me about an hour of time when I am importing my statements from my bank, and would thus be very beneficial.

Thank you again for your awesome work.

[Maxime DOYEN (mdoyen)]

index pos exist for txn but was not when I coded import, so should be easy

[Teodor Neagu (x4zj94a97mta)]

I tested the version sent by you

how I tested - I exported a file in csv format from version 5.7.4 and imported it into version 58rc_fix3.

in version 5.7.4 when importing csv files it has the following structure: date, payment, info, payee, memo, amount, category, tags

In the version you sent me HomeBank-58rc_fix3 the structure is as follows:
date, memo, amount, Pay./Number - and the column contains what was before in the "info" column, payee, category

I don't see the index column. If the index column is Pay./Number it should not allow the input of text only numbers and should not allow the import of text data related to the "info" column.

I replaced some lines that contained text in the Pay./Number column with numbers (eg 3,5,2,4,1) I imported the file but the order remains the same regardless of the index. I tried with transactions that have the same date and transactions from different dates.

The only way I found is by sorting on the column, but the following problems appear

allows a number to be repeated (example 1,1,5,5,5). An index column should not allow duplicate numbers.

and also allows a later date to be in front of a previous date.

am i wrong somewhere?

[Maxime DOYEN (mdoyen)]

what I did is preserve the order lines of the same date from the imported file. the index is internal

so if you have
may 12, D 5$
may 12, B 100$
may 12, A 200$
may 12, C 54$

they should be imported in that order

[Teodor Neagu (x4zj94a97mta)]

OK. Now I understand

please now help me understand what is with the column "Pay./Number" because it is a bit confusing. Did it replace the "info" column from previous versions?

Thank you

[Maxime DOYEN (mdoyen)]

yes Info was renamed like it was to be at first:

https://www.gethomebank.org/ChangeLog

 * change: the Info field is named as it should have originally: Number