Data types for csv

[qgib]

Author Name: magerlin - (magerlin -)
Original Redmine Issue: 4212

Redmine category:data_provider

---

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 issue(s): #15179 (duplicates), #21113 (duplicates)
Redmine related issue(s): 5606, 13038

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• fixed_version_id was configured as Version 1.7.4

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• fixed_version_id was changed from Version 1.7.4 to Version 2.0.0

[qgib]

Author Name: Pirmin Kalberer (Pirmin Kalberer)

---

• fixed_version_id was changed from Version 2.0.0 to Future Release - Nice to have

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0

[qgib]

Author Name: Håvard Tveite (@havatv)

---

Feature request #15179 ("Defining column types for CSV imports") has much in common with this one.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• duplicated was configured as Add ability to choose field type in CSV plugin provider import #21113

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• duplicated was configured as Defining column types for CSV imports #15179

[qgib]

Author Name: Johannes Kroeger (Johannes Kroeger)

---

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! :)

[haubourg]

Closed duplicate of #21113