Bug report #18789

Import of CSV-Data

Added by Christian Brechler almost 6 years ago. Updated about 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Attribute table
Affected QGIS version:3.0.1 Regression?:No
Operating System:windows 10 Easy fix?:No
Pull Request or Patch supplied:No Resolution:worksforme
Crashes QGIS or corrupts data:No Copied to github as #:26676

Description

Hello everyone,
I'm not sure if it's actually a bug or just me.
Yesterday I tried to import a csv-file with numerous Data into Qgis to join it to an geospatial layer.
The joining worked perfectly but the Data was defined as string value but should be integer.
I switched to version 2.18.16 and it worked as it should. Maybe I just could convert it (I don't know how yet) but I think it shouldn't naturally be that way.

If there's someone interested in focussing the problem and needs more information I'd be glad to help.

regards,
Christian


Related issues

Related to QGIS Application - Bug report #18601: QGIS3: texts with leading zero get integers Closed 2018-03-31
Related to QGIS Application - Bug report #12783: Import CSV via "add delimited text layer" ignores Date fi... Closed 2015-05-20

History

#1 Updated by Richard Duivenvoorde almost 6 years ago

Not sure on what basis QGIS decides the column type, but you could use a csvt file:

https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/

#2 Updated by Jürgen Fischer almost 6 years ago

#3 Updated by Jürgen Fischer almost 6 years ago

  • Related to Bug report #12783: Import CSV via "add delimited text layer" ignores Date fields in CSVT added

#4 Updated by Alberto Grava about 5 years ago

Can you provide csv-file so we can test it?
Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

#5 Updated by Giovanni Manghi about 5 years ago

  • Status changed from Open to Feedback

Alberto Grava wrote:

Can you provide csv-file so we can test it?
Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

Please set status to "feedback" if necessary.

#6 Updated by Christian Brechler about 5 years ago

Alberto Grava wrote:

Can you provide csv-file so we can test it?
Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

I think with the next Version the problem was fixed so there's nothing to handle anymore. Sorry I should have closed the issue.

#7 Updated by Christian Brechler about 5 years ago

ok I'm not able to close it.

#8 Updated by Jürgen Fischer about 5 years ago

  • Resolution set to worksforme
  • Status changed from Feedback to Closed

Also available in: Atom PDF