peakshift/fovea

Create a conversion script to transform bank transaction statements into the correct format for the Xero accounting platform

Opened this issue · 2 comments

Create a conversion script to transform bank transaction statements into the correct format for the Xero accounting platform

@selimira we need your expertise in languages here!

Could you provide the mapping of Cyrillic to latin characters to be used this script @esc758 is working on. We can use this in a function to transcribe the Bulgarian bank statement to latin letters.

The problem we are having is when the report is uploaded to Xero, all the Cyrillic letters display as the "Ð" (the Dogecoin symbol? 🤔). So we want to romanise all the text in the report text before we upload it.

@esc758 I pushed a file (romanise.py) I created today that has the transliteration for the bulgarian letters to latin that you can use to romanisation the text in the report. I just want to point out that the letter strings are converted to unicode data types as the capital letters were not getting lower by using the string.lower() method. Let me know if you have any questions