<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.gmail-
{mso-style-name:gmail-;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thank you Alessandro and Richard for your replies, I didn’t know what the expected behaviour was.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thank you Steven for alerting me to the already logged ticket.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Steven Evans [mailto:steven.evans@parkes.nsw.gov.au]
<br>
<b>Sent:</b> Wednesday, 6 September 2017 8:55 AM<br>
<b>To:</b> Alessandro Pasotti <apasotti@gmail.com>; Richard Duivenvoorde <richard@duif.net>; Martin Bain <Martin.Bain@lismore.nsw.gov.au><br>
<b>Cc:</b> qgis-user@lists.osgeo.org; Shaun Goodenough <Shaun.Goodenough@lismore.nsw.gov.au><br>
<b>Subject:</b> RE: [Qgis-user] Browser Panel Import<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hi;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">An issues log has been created a couple of months ago.<o:p></o:p></span></p>
<p class="MsoNormal"><a href="https://issues.qgis.org/issues/16805">https://issues.qgis.org/issues/16805</a><span style="color:#1F497D">
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I too fell for the same trap…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I'm encouraging my end users to stick to double click not drag-drop until this can be resolved…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Steve<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif"> Qgis-user [<a href="mailto:qgis-user-bounces@lists.osgeo.org">mailto:qgis-user-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Alessandro Pasotti<br>
<b>Sent:</b> Tuesday, 5 September 2017 7:33 PM<br>
<b>To:</b> Richard Duivenvoorde<br>
<b>Cc:</b> <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>; Shaun Goodenough<br>
<b>Subject:</b> Re: [Qgis-user] Browser Panel Import<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal">On Tue, Sep 5, 2017 at 9:14 AM, Richard Duivenvoorde <<a href="mailto:rdmailings@duif.net" target="_blank">rdmailings@duif.net</a>> wrote:<o:p></o:p></p>
<p class="MsoNormal"><br>
While it's nice to impress new users to use this 'drag a file into a<br>
database' feature :-) .... I think it's also a 'shoot and run' solution:<br>
either OK or nothing...<br>
<br>
Would it be an idea to (sorry dialog haters) have a summary/confirmation<br>
dialog in between this action? Telling the user that 'this file/table<br>
with such columns be copied/moved to that file/table with these columns'?<br>
<br>
In this case, it would also have made it possible to stop this overwrite<br>
action?<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I'd stick to the confirm dialog for all potentially destructive actions.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I recommend to follow the new geopackage implementation behavior:<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">- if the drop is on self: abort<o:p></o:p></p>
</div>
<p class="MsoNormal">- if the drop overrides an existing table: confirm<o:p></o:p></p>
</div>
<p class="MsoNormal">- if the drop does not override and hence creates a new table: notify on success or error<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Regards.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<p class="MsoNormal"><br>
Regards,<br>
<br>
Richard Duivenvoorde<br>
<br>
<span class="gmail-">On <a href="tel:05-09-17%2009">05-09-17 09</a>:04, Alessandro Pasotti wrote:</span><br>
<span class="gmail-">> It looks like a bug.</span><br>
<span class="gmail-">></span><br>
<span class="gmail-">> Did you file a ticket?</span><br>
<span class="gmail-">></span><br>
<span class="gmail-">> The expected behavior is that the layer you are dragging is imported</span><br>
<span class="gmail-">> (without overwriting!) into the destination DB (the drop target).</span><br>
<span class="gmail-">></span><br>
<span class="gmail-">> In case of overwriting, a confirm dialog should appear.</span><br>
<span class="gmail-">></span><br>
<span class="gmail-">> I've recently worked on that for geopackage and I've also added some</span><br>
<span class="gmail-">> logic to prevent dropping onto itself (that could lead to data loss).</span><br>
<span class="gmail-">></span><br>
<span class="gmail-">> Cheers</span><br>
<span class="gmail-">></span><br>
<span class="gmail-">></span><br>
<span class="gmail-">></span><br>
<span class="gmail-">> On Tue, Sep 5, 2017 at 8:39 AM, Martin Bain</span><br>
> <<a href="mailto:Martin.Bain@lismore.nsw.gov.au">Martin.Bain@lismore.nsw.gov.au</a> <mailto:<a href="mailto:Martin.Bain@lismore.nsw.gov.au">Martin.Bain@lismore.nsw.gov.au</a>>><br>
> wrote:<br>
><br>
> Hi List,____<br>
><br>
> I just discovered a brutal feature of the Browser Panel.____<br>
><br>
> __ __<br>
<span class="gmail-">></span><br>
<span class="gmail-">> When browsing SQL Server if you happen to click and drag on a table</span><br>
<span class="gmail-">> then when you release the mouse button a dialog box will pop up</span><br>
> saying “Import Competed”.____<br>
><br>
> __ __<br>
<span class="gmail-">></span><br>
<span class="gmail-">> The table under the cursor when mouse button is released gets</span><br>
> overwritten with an empty table, without any sort of prompt!____<br>
><br>
> __ __<br>
<span class="gmail-">></span><br>
<span class="gmail-">> Within SQL Server I have now revoked DDL permissions from the user</span><br>
> that did this (and myself).____<br>
><br>
> __ __<br>
<span class="gmail-">></span><br>
<span class="gmail-">> But was wondering, Is there a way to prevent or modify this</span><br>
> behaviour in QGIS?____<br>
><br>
> __ __<br>
><br>
> Thanks,____<br>
><br>
> Martin.____<br>
<span class="gmail-">></span><br>
<span class="gmail-">></span><br>
<span class="gmail-">> This email is intended for the named recipient only. The information</span><br>
<span class="gmail-">> it contains may be confidential. If you are not the intended</span><br>
<span class="gmail-">> recipient you must not reproduce or distribute any part of this</span><br>
<span class="gmail-">> email, disclose its contents to any other party or take any action</span><br>
<span class="gmail-">> in reliance on it. If you have received this email in error, please</span><br>
<span class="gmail-">> contact the sender immediately and delete the message.</span><br>
<span class="gmail-">></span><br>
<span class="gmail-">> _______________________________________________</span><br>
<span class="gmail-">> Qgis-user mailing list</span><br>
> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a> <mailto:<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>><br>
<span class="gmail-">> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br>
<span class="gmail-">> <<a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>></span><br>
<span class="gmail-">> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br>
<span class="gmail-">> <<a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>></span><br>
<span class="gmail-">></span><br>
<span class="gmail-">></span><br>
<span class="gmail-">></span><br>
<span class="gmail-">></span><br>
<span class="gmail-">> --</span><br>
<span class="gmail-">> Alessandro Pasotti</span><br>
> w3: <a href="http://www.itopen.it" target="_blank">www.itopen.it</a> <<a href="http://www.itopen.it" target="_blank">http://www.itopen.it</a>><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">><br>
><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <o:p></o:p></p>
<div>
<p class="MsoNormal">Alessandro Pasotti<br>
w3: <a href="http://www.itopen.it" target="_blank">www.itopen.it</a><o:p></o:p></p>
</div>
</div>
</div>
</div>
<br clear="both">
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.<BR>
</body>
</html>