reubano / csv2ofx

A Python library and command line tool for converting csv to ofx and qif files

MIT License

192 stars 111 forks source link

I'm getting the following errors:

Traceback (most recent call last): File "/usr/local/lib/python3.10/dist-packages/meza/fntools.py", line 635, in byte bytes_ = content.encode(ENCODING) AttributeError: 'itertools.islice' object has no attribute 'encode'

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 470, in _read_any for num, line in enumerate(reader(f, *args, **kwargs)): File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 825, in reader first_line = StringIO(str(next(f))) StopIteration

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/usr/local/lib/python3.10/dist-packages/csv2ofx/main.py", line 266, in run res = write(dest, IterStringIO(content), kwargs) File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 1503, in write return sum(read_any(filepath, writer, mode, content, kwargs)) File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 545, in read_any for line in _read_any(filepath, reader, args, *kwargs): File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 470, in _read_any for num, line in enumerate(reader(f, args, kwargs)): File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 1481, in writer for chunk in ft.chunk(content, chunksize): File "/usr/local/lib/python3.10/dist-packages/meza/fntools.py", line 671, in generator = (content.read(chunksize) for _ in it.count()) File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 148, in read return self._read(self.iter, num, newline=False) File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 132, in read byte = ft.byte(content) File "/usr/local/lib/python3.10/dist-packages/meza/fntools.py", line 640, in byte bytes = b"".join(map(encode, content)) File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 65, in encode = lambda iterable: (s.encode(ENCODING) for s in iterable) File "/usr/local/lib/python3.10/dist-packages/csv2ofx/ofx.py", line 445, in gen_body for datum in data: File "/usr/local/lib/python3.10/dist-packages/csv2ofx/utils.py", line 175, in gen_data for group, main_pos, sorted_trxns in groups: File "/usr/local/lib/python3.10/dist-packages/csv2ofx/init.py", line 309, in clean_trxns for grp, trxns in groups: File "/usr/local/lib/python3.10/dist-packages/csv2ofx/init.py", line 295, in gen_trxns for grp, transactions in groups: File "/usr/local/lib/python3.10/dist-packages/csv2ofx/ofx.py", line 480, in gengroups for chnk in chunk(records, chunksize): File "/usr/local/lib/python3.10/dist-packages/meza/fntools.py", line 686, in generator = (list(it.islice(i, chunksize)) for in it.count()) File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 545, in read_any for line in _read_any(filepath, reader, args, kwargs): RuntimeError: generator raised StopIteration

This is when I run the '-d' option:

{'account_type': None, 'chunksize': 16384, 'collapse': None, 'custom': None, 'dayfirst': False, 'debug': True, 'dest': 'monthly-statement_01-Jun-2024_24-Jun-2024.ofx', 'encoding': 'utf-8', 'end': '2024-06-24 16:18:39.101245', 'first_col': 0, 'first_row': 0, 'language': 'ENG', 'last_row': inf, 'list_mappings': False, 'mapping': 'default', 'overwrite': False, 'qif': False, 'server_date': None, 'source': 'monthly-statement_01-Jun-2024_24-Jun-2024.csv', 'start': None, 'verbose': False, 'version': False}

Montly Statement Revolut

I have a Ubuntu 22.04.4 LTS Server runnig, I have installed the csv2ofx tool.
But when I run the tool I get the following messages:

zoran@unifisrv:~/csv2oxf$ csv2ofx monthly-statement_01-Jun-2024_04-Jul-2024.csv monthly-statement_01-Jun-2024_04-Jul-2024.ofx
No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option.

If I try again with the -coption I get the following result:

zoran@unifisrv:~/csv2oxf$ csv2ofx -c monthly-statement_01-Jun-2024_04-Jul-2024.csv monthly-statement_01-Jun-2024_04-Jul-2024.ofx
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/meza/fntools.py", line 635, in byte
    bytes_ = content.encode(ENCODING)
AttributeError: 'itertools.islice' object has no attribute 'encode'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 470, in _read_any
    for num, line in enumerate(reader(f, *args, **kwargs)):
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 825, in reader
    first_line = StringIO(str(next(f)))
StopIteration

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/csv2ofx/main.py", line 266, in run
    res = write(dest, IterStringIO(content), **kwargs)
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 1503, in write
    return sum(read_any(filepath, writer, mode, content, **kwargs))
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 545, in read_any
    for line in _read_any(filepath, reader, args, **kwargs):
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 470, in _read_any
    for num, line in enumerate(reader(f, *args, **kwargs)):
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 1481, in writer
    for chunk in ft.chunk(content, chunksize):
  File "/usr/local/lib/python3.10/dist-packages/meza/fntools.py", line 671, in <genexpr>
    generator = (content.read(chunksize) for _ in it.count())
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 148, in read
    return self._read(self.iter, num, newline=False)
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 132, in _read
    byte = ft.byte(content)
  File "/usr/local/lib/python3.10/dist-packages/meza/fntools.py", line 640, in byte
    bytes_ = b"".join(map(encode, content))
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 65, in <genexpr>
    encode = lambda iterable: (s.encode(ENCODING) for s in iterable)
  File "/usr/local/lib/python3.10/dist-packages/csv2ofx/ofx.py", line 445, in gen_body
    for datum in data:
  File "/usr/local/lib/python3.10/dist-packages/csv2ofx/utils.py", line 175, in gen_data
    for group, main_pos, sorted_trxns in groups:
  File "/usr/local/lib/python3.10/dist-packages/csv2ofx/__init__.py", line 309, in clean_trxns
    for grp, trxns in groups:
  File "/usr/local/lib/python3.10/dist-packages/csv2ofx/__init__.py", line 295, in gen_trxns
    for grp, transactions in groups:
  File "/usr/local/lib/python3.10/dist-packages/csv2ofx/ofx.py", line 480, in gen_groups
    for chnk in chunk(records, chunksize):
  File "/usr/local/lib/python3.10/dist-packages/meza/fntools.py", line 686, in <genexpr>
    generator = (list(it.islice(i, chunksize)) for _ in it.count())
  File "/usr/local/lib/python3.10/dist-packages/meza/io.py", line 545, in read_any
    for line in _read_any(filepath, reader, args, **kwargs):
RuntimeError: generator raised StopIteration
zoran@unifisrv:~/csv2oxf$

Could you please help me out?

Regards

Zoran

zoran@unifisrv:~/csv2oxf$ csv2ofx -m default monthly-statement_01-Jun-2024_04-Jul-2024.csv No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m rabobank monthly-statement_01-Jun-2024_04-Jul-2024.csv Field 'IBAN/BBAN' is missing from file. Check `mapping` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m n26 monthly-statement_01-Jun-2024_04-Jul-2024.csv No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m abnamro monthly-statement_01-Jun-2024_04-Jul-2024.csv Field 'field_0' is missing from file. Check `mapping` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m bnp monthly-statement_01-Jun-2024_04-Jul-2024.csv No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m boursorama monthly-statement_01-Jun-2024_04-Jul-2024.csv Field 'accountNum' is missing from file. Check `mapping` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m capitalone monthly-statement_01-Jun-2024_04-Jul-2024.csv Field 'Card No.' is missing from file. Check `mapping` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m creditunion monthly-statement_01-Jun-2024_04-Jul-2024.csv No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m custom monthly-statement_01-Jun-2024_04-Jul-2024.csv Field 'Field' is missing from file. Check `mapping` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m yodlee monthly-statement_01-Jun-2024_04-Jul-2024.csv Field 'Transaction Id' is missing from file. Check `mapping` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m xero monthly-statement_01-Jun-2024_04-Jul-2024.csv Field 'JournalNumber' is missing from file. Check `mapping` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m ubs monthly-statement_01-Jun-2024_04-Jul-2024.csv No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m stripe monthly-statement_01-Jun-2024_04-Jul-2024.csv No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m starling monthly-statement_01-Jun-2024_04-Jul-2024.csv No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m split_account monthly-statement_01-Jun-2024_04-Jul-2024.csv No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m mint monthly-statement_01-Jun-2024_04-Jul-2024.csv Field 'Account Name' is missing from file. Check `mapping` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m exim monthly-statement_01-Jun-2024_04-Jul-2024.csv No data to write. Parser must be a string or character stream, not NoneType. Try again with `-c` option. zoran@unifisrv:~/csv2oxf$ csv2ofx -m outbank monthly-statement_01-Jun-2024_04-Jul-2024.csv Field 'Account' is missing from file. Check `mapping` option.

reubano / csv2ofx

Getting Parser Erros While Trying to Convert from CSV to OFX #120

Montly Statement Revolut

I have tried severl different mappings with different output results. Only none of them worked.