<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
After a few selections, you may have to close and reopen qgis to
purge the memory as well. Importing a csv is memory intensive so
another approach is to try saving as a spatial database (SQLite) or
even a shapefile. Once written, you can load the spatial file and
you should have lots of memory to keep selecting points. <br>
<br>
Kirk<br>
<br>
<div class="moz-cite-prefix">On 1/9/2018 4:58 PM, Ramon Andinach
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:80A4A1E8-07E4-4AFB-BDBF-6D3E3D8AE4B5@westnet.com.au">
<meta http-equiv="Context-Type" content="text/html; charset=utf-8">
I’m not sure what the problem is, but if I were doing that
repeatedly, I’d probably use Layer -> Save As, tick the Save
Only Selected Features box and save it to CSV. Then muck about
with excel later.
<div class=""><br class="">
</div>
<div class="">This way ought to be a bit lighter on the memory. </div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">Ramon.</div>
<div class="">
<div>
<blockquote type="cite" class="">
<div class="">On 10 Jan 2018, at 04:25, Jeroen Hovens <<a
href="mailto:mail@groenebij.nl" class=""
moz-do-not-send="true">mail@groenebij.nl</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="WordSection1">
<div class=""><span class="" lang="EN-US">Hi,</span></div>
<div class=""><span class="" lang="EN-US"> </span></div>
<div class=""><span class="" lang="EN-US">Using qgis
2.14.18 I have been working today with a large csv
file (7.5 mln objects). I just need selections of
this database which I can then modify in excel. So I
opened the attribute table and made a selection
based on a specific value for an attribute, and
copied that selection (about 30.000 objects) via the
clipboard (ctrl-c) to a new Microsoft Excel file,
then saved the excel file and repeated the process
for another selection. This worked perfect for some
time. However, some selections won’t copy: when I
press the copy button the programs turn to ‘not
responding’ and won’t snap out of it anymore.
Selection size when this happens is about the same
(about 20k to 35k objects).</span></div>
<div class=""><span class="" lang="EN-US"> </span></div>
<div class=""><span class="" lang="EN-US">What could be
the problem? Could the data be corrupted? How can I
check what is wrong?</span></div>
<div class=""><span class="" lang="EN-US"> </span></div>
<div class=""><span class="" lang="EN-US">Thank you</span></div>
<div class=""><span class="" lang="EN-US">Gr.</span></div>
<div class=""><span class="" lang="EN-US">Jeroen<span
class="Apple-converted-space"> </span></span></div>
<div class=""> </div>
</div>
<span class="">_______________________________________________</span><br
class="">
<span class="">Qgis-user mailing list</span><br class="">
<a href="mailto:Qgis-user@lists.osgeo.org" class=""
moz-do-not-send="true">Qgis-user@lists.osgeo.org</a><br
class="">
<span class="">List info:<span
class="Apple-converted-space"> </span></span><a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
class="" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br
class="">
<span class="">Unsubscribe:<span
class="Apple-converted-space"> </span></span><a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
class="" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote>
</div>
<br class="">
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Kirk Schmidt, MScF, BScF, RPF
General Manager
Nortek Resource Solutions Inc.
RR # 1
Thorburn, NS
B0K 1W0
Tel (902) 922.3607
Email: <a class="moz-txt-link-abbreviated" href="mailto:kirk@nortekresources.com">kirk@nortekresources.com</a>
Web: <a class="moz-txt-link-abbreviated" href="http://www.nortekreources.com">www.nortekreources.com</a></pre>
</body>
</html>