Feature request #4212
Data types for csv
| Status: | Open | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Data Provider | ||
| Pull Request or Patch supplied: | No | Resolution: | |
| Easy fix?: | No | Copied to github as #: | 14176 |
Description
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.
Related issues
History
#1
Updated by Giovanni Manghi almost 13 years ago
- Target version set to Version 1.7.4
#2
Updated by Giovanni Manghi over 12 years ago
- Target version changed from Version 1.7.4 to Version 2.0.0
#3
Updated by Pirmin Kalberer about 12 years ago
- Target version changed from Version 2.0.0 to Future Release - Nice to have
#4
Updated by Giovanni Manghi over 7 years ago
- Easy fix? set to No
#5
Updated by Håvard Tveite over 6 years ago
Feature request #5606 ("Defining column types for CSV imports") has much in common with this one.
#6
Updated by Jürgen Fischer over 6 years ago
- Duplicated by Feature request #13038: Add ability to choose field type in CSV plugin provider import added
#7
Updated by Jürgen Fischer over 6 years ago
- Duplicated by Feature request #5606: Defining column types for CSV imports added
#8
Updated by Johannes Kroeger over 6 years 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! :)