leolabs/you-need-a-parser

Format Request - Piraeus Bank, Greece

Closed this issue · 9 comments

Hello! Would it be possible for you to add the parser for the Greek Piraeus Bank .csv format? I am attaching an example file, let me know if you need anything else.

Thank you!

Piraeus Bank - Greece Example File.zip

Could you tell me the original file name of the exported CSV file? YNAP primarily uses the file's name to determine which parser to use, only falling back on other methods when the file name isn't clear.

I'll try to implement it tomorrow if I get the time :)

The original file name is AccountStatement.csv

However, I don't know if thats relevant but I don't export it directly from my bank, I request it via e-mail because the e-banking only provides .xlsx files.

Thank you very much!

YNAP can also handle XLSX files. If it's easier to export your statements as XLSX, then I can implement that instead of the CSV parser. Could you provide an example file for the export?

Both are fine for me since I get my transactions via e-mail anyway.

I am attaching also the .xlsx file in case you find it easier to implement.

Account Transactions_20190601.xlsx

I've implemented the parser for XLSX now in 0ef7ce3. You can try it out now if you'd like to :)

Please reload the browser once or twice to make sure the newest version of YNAP has been loaded.

Perfect!

Thank you!

Hello!

Recently Piraeus bank changed its export xlsx format and the parser is running into problems. The data now start in row 5 instead of row 7 and also the payee information is in column B instead of column D. I have the new export file attached.

I would appreciate it if you could make the corrections in the parser whenever you get the time.

Thank you very much again, your script is very useful for me!

Account Transactions_20200725.xlsx

A fix should be online in a few minutes :)

Thank you!