<p>Hi,<br>
I will suggest she uses PostGIS database. She can add all her data in there from Excel, modify them, add new ones and easily interact with QGIS. She can aslo perform SQL operations in PostGIS and display them in QGIS.</p>
<p>Yemi</p>
<div class="gmail_quote">On Apr 4, 2013 1:47 AM, "Andreas Neumann" <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
Actually an easy import from one table into the other, with the ability<br>
to map columns and avoid duplicates, is missing in my opinion. There are<br>
several ways to achieve what you want, Sarah (like merging shapefiles,<br>
loading from text and copy/paste). But there should be easier ways to<br>
achieve that.<br>
<br>
We are in feature freeze for QGIS 2.0 - so maybe something for QGIS 2.1 ;-)<br>
<br>
Andreas<br>
<br>
Am 03.04.2013 16:34, schrieb Albin Blaschka:<br>
> Hello!<br>
><br>
> Maybe a look into the manual would also help...<br>
><br>
> <a href="http://www.qgis.org/en/documentation.html" target="_blank">http://www.qgis.org/en/documentation.html</a><br>
><br>
> and the How-to pages (linked from the above mentioned page):<br>
> <a href="http://hub.qgis.org/projects/quantum-gis/wiki/How_do_I_do_that_in_QGIS" target="_blank">http://hub.qgis.org/projects/quantum-gis/wiki/How_do_I_do_that_in_QGIS</a><br>
><br>
> HTH,<br>
> Albin<br>
><br>
><br>
><br>
> Am 03.04.2013 16:04, schrieb Lynkos:<br>
>> Alexandre<br>
>> , thanks :-). I'll try your suggestion and let you know if I can make it<br>
>> work.<br>
>><br>
>><br>
>> 2013/4/3 Alexandre Neto <<a href="mailto:senhor.neto@gmail.com">senhor.neto@gmail.com</a><br>
>> <mailto:<a href="mailto:senhor.neto@gmail.com">senhor.neto@gmail.com</a>>><br>
>><br>
>> For each new record you need to add a new Point to your shapefile.<br>
>> If you need to enter the coordinates by hand, then you should take a<br>
>> look at the numerical digitalize plugin. After the point is added<br>
>> you can then edit the rest of your attributes.<br>
>><br>
>> If you have too many new observations already in a spreadsheet, then<br>
>> you can do in another way:<br>
>><br>
>> - Create a temporary shapefile from the new spreadsheet, making sure<br>
>> that its attributes are the same as you main shapefile;<br>
>> - Add it to map canvas;<br>
>> - Select that layer and copy all its features (points) using the<br>
>> select by rectangle or directly on attribute table and copy them to<br>
>> clipboard.<br>
>> - Select the main shapefile, star editing (the pencil icon), and<br>
>> paste the features from clipboars.<br>
>><br>
>> If everything went well, and the layers attributes match, you will<br>
>> get all the new bird sighting in the main shapefile.<br>
>><br>
>> Still, the best would be to directly input the sightings on the<br>
>> shapefile.<br>
>><br>
>> Hope it helps,<br>
>><br>
>> Alexandre Neto<br>
>><br>
>> On Wed, Apr 3, 2013 at 11:18 AM, Lynkos <<a href="mailto:lynkosmail@gmail.com">lynkosmail@gmail.com</a><br>
>> <mailto:<a href="mailto:lynkosmail@gmail.com">lynkosmail@gmail.com</a>>> wrote:<br>
>><br>
>> ... to modify the data, yes in fact that's what I'm doing. But<br>
>> to ADD a new record from the coordinate data? Am I missing an<br>
>> "add" button somewhere?<br>
>><br>
>><br>
>><br>
>> 2013/4/3 Paolo Cavallini <<a href="mailto:cavallini@faunalia.it">cavallini@faunalia.it</a><br>
>> <mailto:<a href="mailto:cavallini@faunalia.it">cavallini@faunalia.it</a>>><br>
>><br>
> Il 03/04/2013 12:05, Lynkos ha scritto:<br>
> > Thanks for answering so quickly Paolo.<br>
> > Adding the data directly to the imported shapefile is<br>
> exactly what I would like to<br>
> > do. I'm sure it's incredibly simple, but I just can't<br>
> figure out how, Sarah.<br>
><br>
> Just click on the Pen button, start editing.<br>
> All the best.<br>
>> _______________________________________________<br>
>> Qgis-user mailing list<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>
>> <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
>><br>
>><br>
>><br>
>><br>
>> --<br>
>> Con altri occhi - parole e immagini dalla parte della natura<br>
>> <a href="http://www.lynkos.net" target="_blank">www.lynkos.net</a> <<a href="http://www.lynkos.net" target="_blank">http://www.lynkos.net</a>><br>
>><br>
>> _______________________________________________<br>
>> Qgis-user mailing list<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>
>> <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> --<br>
>> Con altri occhi - parole e immagini dalla parte della natura<br>
>> <a href="http://www.lynkos.net" target="_blank">www.lynkos.net</a> <<a href="http://www.lynkos.net" target="_blank">http://www.lynkos.net</a>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> Qgis-user mailing list<br>
>> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
>> <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
>><br>
><br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote></div>