Moneymanagerex: Tinkoff bank import

[vomikan]

It's a csv file provided by bank

"Дата операции";"Дата платежа";"Номер карты";"Статус";"Сумма операции";"Валюта операции";"Сумма платежа";"Валюта платежа";"Кэшбэк";"Категория";"MCC";"Описание";"Бонусы (включая кэшбэк)"
"24.10.2018 17:04:25";"24.10.2018";"*8305";"OK";"-882,04";"RUB";"-882,04";"RUB";"";"Переводы/иб";"";"Пополнение счета Тинькофф Брокер";"0,00"
"24.10.2018 16:29:51";"";"*1140";"OK";"-1053,77";"RUB";"-1053,77";"RUB";"";"Супермаркеты";"5411";"Пятерочка";"0,00"
"24.10.2018 12:43:25";"";"*8305";"OK";"-350,00";"RUB";"-350,00";"RUB";"";"Рестораны";"5812";"KAFE DEDUSHKA KHO";"0,00"
"21.10.2018 18:33:22";"24.10.2018";"*1140";"OK";"-1222,29";"RUB";"-1222,29";"RUB";"12";"Супермаркеты";"5411";"О'КЕЙ";"12,00"

Here is 'MMC' field. It seems something like POS ID. If this field is not empty the next value became payee name. If MMC is empty the next value became transaction description.
Current csv import too simple to satisfy this logic.

[slodki]

https://en.wikipedia.org/wiki/Merchant_category_code - MMC can be used as a category

[slodki]

My bank uses CSV with different line format depending on transaction type - there can be a different number of fields in the file. It's easy to create an external parser for such files using awk/perl/python script.
It's more complicated to implement GUI for it in MMEX - there must be defined and implemented a condition language for defining the conditions for fields' mapping.

[ichesnokov]

@slodki I just recently started playing with MMEX and had the same idea - there needs to be a way to assign values to fields (deposit, credit, payee, etc) using a script - possibly written in Lua, like it's done for reports.

For example, one of issuers of the cards I'm using only shows the type of operation in a separate field, while the amount is always a positive number in the same column for deposits and credits.

[vomikan]

2352