Feature request #4212
Data types for csv
|Pull Request or Patch supplied:||No||Resolution:|
|Easy fix?:||No||Copied to github as #:||14176|
It would be nice if you inside Qgis could handle the data type selection when opening a csv file by "Add vector layer".
As it is now all will be interpretated as text unless you by hand adds a .csvt file to the folder containing the .csv file.
#8 Updated by Johannes Kroeger over 1 year ago
This is a problem that comes up all the time when dealing with users from data analysis, journalism and similar backgrounds. For example when joining geographic data and tabular data from official records. In Germany we have a seemingly numeric key for municipalities (AGS) that can have a leading zero. QGIS right now will turn it into an integer and subsequent joins will fail.
That one can manually fiddle around with an additional file is neither obvious nor user-friendly. A related issue would be that the CSV import form shows the fields without the automagical type conversion so what you see is not what you get.
Fixing this might turn those people into happy QGIS users and advocates. It would be awesome! :)