Skip to content

微信更改了账单文件格式和内容格式导致无法正确转化账单 #172

@bldq

Description

@bldq

微信更改了账单文件格式和内容格式导致无法正确转化账单

由csv文件改为了xlsx文件
文件的内容虽然看起来没啥变化,但是xlsx导出csv文件后运行报错
报错内容:
Failed to translate: Failed to translate bill: line 18: Failed to get the tx type ת��-�˿�:
如果是直接读取xlsx文件则报错内容:
Failed to translate: Failed to translate bill: line 18: parse create time (H�qEP�B2J�G&�%s4�g�zJ����:��]�v�j�&AդG5ҭ���G��Pc���QPq�D@DQM��P�8��@W� error: parsing time "(H\xb2q\x1dEP\xf8B2\x1eJ\xf6G&\xfe%\x1fs4\xa3g\x9czJ\xf4\xb7\x1c\xab\x05\xed:\xb7\xd1]\x17\xbdv\x9d\x12\x14j\x8e\&A\xd5\xa4G5\x14\xd2\xad\xc0\xb8\x90G\x80\xb7\x18Pc\xa5\xca\xddQPq\x06\xd9D@DQM\xc4\x04\xebP\xee\x02\x1d\x04\x05\x1d8\x92\x0f\xb3@W\xd8 +0800 CST" as "2006-01-02 15:04:05 -0700 CST": cannot parse "(H\xb2q\x1dEP\xf8B2\x1eJ\xf6G&\xfe%\x1fs4\xa3g\x9czJ\xf4\xb7\x1c\xab\x05\xed:\xb7\xd1]\x17\xbdv\x9d\x12\x14j\x8e\&A\xd5\xa4G5\x14\xd2\xad\xc0\xb8\x90G\x80\xb7\x18Pc\xa5\xca\xddQPq\x06\xd9D@DQM\xc4\x04\xebP\xee\x02\x1d\x04\x05\x1d8\x92\x0f\xb3@W\xd8 +0800 CST" as "2006"
测试平台:windows11
测试版本:2.10.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workinghelp wantedExtra attention is needed

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions