Feature request #4212

Data types for csv

Added by magerlin - about 8 years ago. Updated over 1 year ago.

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

Duplicated by QGIS Application - Feature request #13038: Add ability to choose field type in CSV plugin provider i... Open 2015-06-26
Duplicated by QGIS Application - Feature request #5606: Defining column types for CSV imports Open 2012-05-16

History

#1 Updated by Giovanni Manghi almost 8 years ago

  • Target version set to Version 1.7.4

#2 Updated by Giovanni Manghi over 7 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

#3 Updated by Pirmin Kalberer about 7 years ago

  • Target version changed from Version 2.0.0 to Future Release - Nice to have

#4 Updated by Giovanni Manghi over 2 years ago

  • Easy fix? set to No

#5 Updated by Håvard Tveite over 1 year ago

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

#6 Updated by Jürgen Fischer over 1 year ago

#7 Updated by Jürgen Fischer over 1 year ago

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

Also available in: Atom PDF