Autodetect delimiter in CSV files

[jeanferri]

Currently the import_from_csv method have the parameter 'delimiter' that assumes ',' as default, but sometimes we don't know what is the delimiter and need it autodetect. Specially usefull in case of CSV files generated in MS Excell that uses ';' as delimiter.

A quick and dirty possibility to make this works is counting the number of times ',', ';' and 'tab' is used in the file and assumes as delimiter the most used.

[turicas]

Good one, @jeanferri! :-)
We can use csv.Sniffer to detect it (it implements what you suggested already).
Feel free to send a PR if you have time available for this task.

[turicas]

Note that you can pass delimiter and quotechar manually to import_from_csv.

[jeanferri]

Ok, I'll try it tomorrow and in case of success I will send you a PR...

[turicas]

@jeanferri, did you have time to work on this issue?

[jeanferri]

Not yet but will... First I have to fix some urgent bugs in Portal Modelo transparency module...

[turicas]

Ok. If I may help in any way, please ask. ;)