fitnr/SublimeDataConverter

does not work at all in sublime text 3083

Closed this issue · 6 comments

DataConverter had trouble sniffing: Could not determine delimiter
DataConverter: Using the default delimiter: ","
DataConverter: You can change the default delimiter in the settings file.
DataConverter: using dialect excel
DataConverter: CSV module had trouble sniffing for headers. Assuming they exist.
DataConverter: Set 'headers = false' in the settings to disable.
Traceback (most recent call last):
  File "C:\Program Files\Sublime Text 3\sublime_plugin.py", line 550, in run_
    return self.run(edit, **args)
  File "DataConverter in C:\Users\cotne\AppData\Roaming\Sublime Text 3\Installed Packages\DataConverter.sublime-package", line 105, in run
  File "DataConverter in C:\Users\cotne\AppData\Roaming\Sublime Text 3\Installed Packages\DataConverter.sublime-package", line 293, in import_csv
  File "DataConverter in C:\Users\cotne\AppData\Roaming\Sublime Text 3\Installed Packages\DataConverter.sublime-package", line 55, in parse
  File "DataConverter in C:\Users\cotne\AppData\Roaming\Sublime Text 3\Installed Packages\DataConverter.sublime-package", line 31, in get_type
TypeError: int() argument must be a string or a number, not 'NoneType'
fitnr commented

What's the CSV you're trying to convert?

Serial  Name    Gender  Organization    Function    Nationality ID number   Event   Photo
1   bla bla Male    National Olympic Committee of Lithuania Athlete Lithuania   11111111    Artistic Gymnastics Have
2   bla bla Female  National Olympic Committee of Lithuania Athlete Lithuania   111111  Tennis  Have

this is coped from excel 2013 i think it's valid csv

fitnr commented

HTML automatically converts the tabs in your snippet to spaces. When I converted back to tabs, I didn't have an issue.

I've pushed a release that addresses the area around the issue you saw. Can you install that (when it's available) and try again?

issue still exists

https://gist.github.com/thecotne/81d1f56eb9b85a2771e4

(i created gist to keep tabs)

DataConverter: using sniffed dialect with delimiter: [tab character]
DataConverter: using dialect sniffed
DataConverter: CSV Sniffer found headers
fitnr commented

I can't reproduce this on OS X, and I don't have a WIndows machine handy at the moment. Are you selecting any part of the file when you run the command?

i have tried with and without selecting text both ways it does not work

i will try to fix this when i get home

BTW it's good practice to add labels to issues
so this issue should have bug and windows label