Add ability to choose field type in CSV plugin provider import

[qgib]

Author Name: Regis Haubourg (@haubourg)
Original Redmine Issue: 13038

Redmine category:data_provider/delimited_text_
Assignee: Chris Crook

---

Hi,
when importing CSV, we often have text identifiers that are similar to numerics, ie: "09123". CSV plugin auto types this filed to numeric 9123 when we need to keep it as it should be.
It would be nive to be able to choose field type destination and have an automatic cast to this.
Currently, we need to switch to ods / xslx to keep those types, but that is not straightforward
Cheers
Régis

---

Related issue(s): #14176 (duplicates), #15179 (duplicates)
Redmine related issue(s): 4212, 5606

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0

[qgib]

Author Name: Johannes Kroeger (Johannes Kroeger)

---

This is a dupe of #14176 and #15179

[qgib]

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

---

• duplicates was configured as Data types for csv #14176

[qgib]

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

---

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

[Sallagispo]

• 1 promotion for this. I would love to see in QGIS 3.18 an ability to manually choose field types for .csv when importing it to QGIS! I work with statistical data joined to vector areas (municipalities, zip code areas, etc.) and they often have these area codes that might start with 0. If I choose "detect field types", they are converted to numbers and beginning zeros disappear -> join doesn't work. If I don't choose "detect field types", all my statistical data is converted to strings -> extra work converting them back to numerical data. And in my country, decimal separator is comma, and it seems that to_real operator can not understand this. So I needed to edit the data in excel, save it again to .csv and import again to QGIS.
  I'm using QGIS 3.16.1 with Windows 10.

[alexbruy]

Fixed in #46236.