Drag and Drop CSV file

[qgib]

Author Name: Antonio Locandro (Antonio Locandro) Original Redmine Issue: 10024

Redmine category:unknown

---

It would be nice if one can Drag and Drop CSV files either directly from system or from Browser and QGIS would try to detect all the required fields in the Create a Layer from Delimited text File, that way one would only need to review things before pressing OK

[qgib]

Author Name: Regis Haubourg (@haubourg)

---

+1 for the feature request.
that means dropping ogr csv support and use only csv delimiter c++ provider.. and that would remove a bad redondancy in QGIS providers. ogr csv support is too limited compared to plugin's one.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0

[qgib]

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

---

• category_id was configured as Unknown

[qgib]

Author Name: Antonio Locandro (Antonio Locandro)

---

Checked and although I can drag and drop it, I was expecting the behaviour to be similar to when you add the csv through the dedicated tool and open the parameters to have a spatial layer from CSV

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Antonio Locandro wrote:

Checked and although I can drag and drop it, I was expecting the behaviour to be similar to when you add the csv through the dedicated tool and open the parameters to have a spatial layer from CSV

I really think that the correct behavior is the actual one: d&d you gets a geometryless table, using the delimited text provider button you get a spatial table.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Antonio Locandro (Antonio Locandro)

---

I see why this would be good, I think we can close then this

[qgib]

Author Name: Andy Harfoot (Andy Harfoot)

---

From http://www.gdal.org/drv_csv.html

"Starting with GDAL 2.1, it is possible to directly specify the potential names of the columns that can contain X/longitude and Y/latitude with the X_POSSIBLE_NAMES and Y_POSSIBLE_NAMES open option."

These could be hard coded into the QGIS OGR CSV load function, or set via a preference, meaning that for CSVs containing appropriately named spatial columns, the geometry would be read automatically on drag and drop.

Alternatively, a context menu command could be added for text files 'Open as spatial delimited text', routing the load via the dialog.

I would like to keep this request open - the current behaviour of CSV drag and drop lags behind that of other formats

[kgjenkins]

I've often wished that dragging a CSV onto QGIS would open the data source manager - delimited text dialog. From that point, the user can choose whether to load as a points from coordinate fields, or just a plain table, and whether to automatically detect field types. Is there a reason not to open that dialog when dragging and dropping a CSV?

[haubourg]

I've often wished that dragging a CSV onto QGIS would open the data source manager - delimited text dialog. From that point, the user can choose whether to load as a points from coordinate fields, or just a plain table, and whether to automatically detect field types. Is there a reason not to open that dialog when dragging and dropping a CSV?

Ooh yes, that would be nice. Still looking for someone to support this. If you know of someone able to fund here, please mp ;-)

[nyalldawson]

@haubourg I'm currently working through a contract which includes a similar functionality. Fingers crossed this will get accepted and be implemented in 3.18!

[haubourg]

@haubourg I'm currently working through a contract which includes a similar functionality. Fingers crossed this will get accepted and be implemented in 3.18!

\o/ wiin, thanks for letting us know and kudos to the funder !

[antoniolocandro]

Was going to write another feature request and decided to search first, don't know if this is similar but also in the browser would be nice to have a context menu to add as XY geometry or different wording and trigger the delimited text menu with the file name of course pre-populated

I do think it would be nice t

[github-actions[bot]]

The QGIS project highly values your report and would love to see it addressed. However, this issue has been left in feedback mode for the last 14 days and is being automatically marked as "stale". If you would like to continue with this issue, please provide any missing information or answer any open questions. If you could resolve the issue yourself meanwhile, please leave a note for future readers with the same problem and close the issue. In case you should have any uncertainty, please leave a comment and we will be happy to help you proceed with this issue. If there is no further activity on this issue, it will be closed in a week.

[esnyder-rve]

This is mostly a bump, but with some added feedback. A frequent QGIS issue/question that appears in various communities, is that csv files don't come in properly via drag-and-drop. The problem is the geometry definition settings are incorrect. The answer to all of these problems is to use the Data Source Manager to import them. It would be nice if when a csv file (or any other standard delimited text file) were drag-and-dropped into QGIS, the Delimited Text import widget shows up, auto-filled for the user to check and apply the various settings (much like how a layer selection window appears when a multi-layer vector data source such as a gpkg is drag-and-dropped). It doesn't have to be the entire Data Source Manager, but just the Delimited Text widget (much like how the layer styling settings are separate in the Layer Styling Panel from the entire Layer Properties window).