Getting Parser Erros While Trying to Convert from CSV to OFX

[SlowFox72]

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 gen_groups
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}

[SlowFox72]

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

[SlowFox72]

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

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.