CSV parser fails when trying to import XLSX

[funkybob]

Using 0.9.11 I get the following trying to import a XLSX file...

Traceback (most recent call last):
File "...", line 81, in parse
self.source_data = tablib.import_set(source)
File ".../site-packages/tablib/core.py", line 1006, in import_set
format.import_set(data, stream)
File ".../site-packages/tablib/formats/_csv.py", line 41, in import_set
for i, row in enumerate(rows):
File ".../site-packages/tablib/packages/unicodecsv/__init__.py", line 54, in next
row = self.reader.next()
Error: line contains NULL byte

[funkybob]

I just tried master, and it's now the yaml parser failing with:

File ".../site-packages/tablib/packages/yaml/reader.py", line 200, in update
exc.encoding, exc.reason)
ReaderError: 'utf8' codec can't decode byte #x8e: invalid start byte in "<string>", position 10

[funkybob]

So basically, it seems the parsers aren't failing cleanly when encoding is the reason they fail...

[djrobstep]

YAML parser also breaks when trying to import_set with a tsv.

yaml.scanner.ScannerError: while scanning for the next token
found character '\t' that cannot start any token

[funkybob]

Sadly, this and the pickling bug mean I've had to abandon my use of this library.

[kennethreitz]

This project is in a bit of a crisis state — it's really useful, and I use regularly. However, I wrote it several years ago and haven't touched it since. In order to get the project into a stable state I'm closing all issues and pull requests to get a "fresh slate"

Don't take this as aggressive — it's just necessary for the project to make any progress any time soon (it's pretty clear the project is effectively unmaintained at the moment). Great things to come! Please watch the GitHub logs and feel free to re-open this discussion soon. I just need to really it into a good state first.

✨ ❤️ ✨

[iurisilvio]

Reopening this issue because it is a real bug and should be fixed.

Should the import_set just ignore exceptions if any formatter accept the input?

[iurisilvio]

We have to ignore exceptions when we don't know the format.

[claudep]

I cannot say I solve all issues, but tablib should be a little more robust now wrt autodetection. Feel free to open new tickets if you can reproduce crashes on master.