Hi; An issues log has been created a couple of months ago. https://issues.qgis.org/issues/16805
I too fell for the same trap… I'm encouraging my end users to stick to double click not drag-drop until this can be resolved… Regards Steve From: Qgis-user [mailto:[email protected]] On Behalf Of Alessandro Pasotti Sent: Tuesday, 5 September 2017 7:33 PM To: Richard Duivenvoorde Cc: [email protected]; Shaun Goodenough Subject: Re: [Qgis-user] Browser Panel Import On Tue, Sep 5, 2017 at 9:14 AM, Richard Duivenvoorde <[email protected]<mailto:[email protected]>> wrote: While it's nice to impress new users to use this 'drag a file into a database' feature :-) .... I think it's also a 'shoot and run' solution: either OK or nothing... Would it be an idea to (sorry dialog haters) have a summary/confirmation dialog in between this action? Telling the user that 'this file/table with such columns be copied/moved to that file/table with these columns'? In this case, it would also have made it possible to stop this overwrite action? I don't think it's a good design: if the result of the action is reversible a confirm dialog is unnecessary, and we are trying to elminate all unnecessary modals. I'd stick to the confirm dialog for all potentially destructive actions. I recommend to follow the new geopackage implementation behavior: - if the drop is on self: abort - if the drop overrides an existing table: confirm - if the drop does not override and hence creates a new table: notify on success or error If you've done a wrong drop, you can easily delete the imported layer (at least now it's implemented for geopackage and all ogr/gdal, provided it's supported by the gdal/ogr provider) Regards. Regards, Richard Duivenvoorde On 05-09-17 09<tel:05-09-17%2009>:04, Alessandro Pasotti wrote: > It looks like a bug. > > Did you file a ticket? > > The expected behavior is that the layer you are dragging is imported > (without overwriting!) into the destination DB (the drop target). > > In case of overwriting, a confirm dialog should appear. > > I've recently worked on that for geopackage and I've also added some > logic to prevent dropping onto itself (that could lead to data loss). > > Cheers > > > > On Tue, Sep 5, 2017 at 8:39 AM, Martin Bain > <[email protected]<mailto:[email protected]> > <mailto:[email protected]<mailto:[email protected]>>> > wrote: > > Hi List,____ > > I just discovered a brutal feature of the Browser Panel.____ > > __ __ > > When browsing SQL Server if you happen to click and drag on a table > then when you release the mouse button a dialog box will pop up > saying “Import Competed”.____ > > __ __ > > The table under the cursor when mouse button is released gets > overwritten with an empty table, without any sort of prompt!____ > > __ __ > > Within SQL Server I have now revoked DDL permissions from the user > that did this (and myself).____ > > __ __ > > But was wondering, Is there a way to prevent or modify this > behaviour in QGIS?____ > > __ __ > > Thanks,____ > > Martin.____ > > > This email is intended for the named recipient only. The information > it contains may be confidential. If you are not the intended > recipient you must not reproduce or distribute any part of this > email, disclose its contents to any other party or take any action > in reliance on it. If you have received this email in error, please > contact the sender immediately and delete the message. > > _______________________________________________ > Qgis-user mailing list > [email protected]<mailto:[email protected]> > <mailto:[email protected]<mailto:[email protected]>> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > <https://lists.osgeo.org/mailman/listinfo/qgis-user> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > <https://lists.osgeo.org/mailman/listinfo/qgis-user> > > > > > -- > Alessandro Pasotti > w3: www.itopen.it<http://www.itopen.it> <http://www.itopen.it> > > > _______________________________________________ > Qgis-user mailing list > [email protected]<mailto:[email protected]> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > -- Alessandro Pasotti w3: www.itopen.it<http://www.itopen.it>
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
