<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi,</p>
<p>It appears that the join attributes table found in the 2.18
processing joins tables but not like the "Joins" found in the
layer property. You are right, there is no option to save as a
shp file!!!!! Only database formats. <br>
</p>
<p>Your best option is to use the field calculator in the point shp
file and to create a new column with the geometries x and y.
Then you can join the table and save as a csv. Then, reimport the
csv and use the x and y to recreate the points geometry.<br>
</p>
<p>OR</p>
<p>The problem is solved by using Qgis 3 where you can save as a
.shp.</p>
<p>Nicolas <br>
</p>
<p><br>
</p>
<p> <br>
</p>
<br>
<div class="moz-cite-prefix">On 2018-05-28 1:44 PM, Samuel Williams
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<div>Hi Nicolas,</div>
<br>
<div>Thanks! Here are two matching files - I would be interested
to know if it gives you other options.</div>
<br>
<div><a
href="https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/0?redirect=https%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1bM6qGYaNmm93sEbwE4x4aoQSAZMtEIvH&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
title="https://drive.google.com/open?id=1bM6qGYaNmm93sEbwE4x4aoQSAZMtEIvH"
moz-do-not-send="true">https://drive.google.com/open?id=1bM6qGYaNmm93sEbwE4x4aoQSAZMtEIvH</a><br>
</div>
<div>Let me know if you need anything else.</div>
<br>
<div>Sam</div>
<br>
<div class="gmail_quote_attribution">On May 28 2018, at 4:15 pm,
Nicolas Cadieux <a class="moz-txt-link-rfc2396E" href="mailto:nicolas.cadieux@archeotec.ca"><nicolas.cadieux@archeotec.ca></a> wrote:</div>
<blockquote><br>
<div><br>
<div>Hi,</div>
<br>
<div>Can you send me a sample of the files? I have more
options on my computer but is may be that I am not testing
with a .csv.</div>
<br>
<div>
<div>Nicolas</div>
</div>
<br>
<div>
<div>On 2018-05-28 6:35 AM, Samuel Williams wrote:</div>
</div>
<blockquote><br>
<div><span style="color:rgb(35, 31, 32)"><font
style="font-size:14.5px"><font
style="font-family:Nylas-Pro, Helvetica,
"Lucidia Grande", sans-serif">Bonjour
Nicolas,</font></font></span></div>
<br>
<div><span style="color:rgb(35, 31, 32)"><font
style="font-size:14.5px"><font
style="font-family:Nylas-Pro, Helvetica,
"Lucidia Grande", sans-serif">Thanks for
taking the time to answer my email.</font></font></span></div>
<div><span style="color:rgb(35, 31, 32)"><font
style="font-size:14.5px"><font
style="font-family:Nylas-Pro, Helvetica,
"Lucidia Grande", sans-serif">Unfortunately
the only options that I have for saving the joined
files are all table based - see the screenshot that
I have uploaded here:</font></font></span></div>
<br>
<div><a
href="https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/1?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F0%3Fredirect%3Dhttps%253A%252F%252Fdrive.google.com%252Ffile%252Fd%252F1x0ADTag8xk85Ty3Vx6Wyb0FQCXfKDyBQ%252Fview%253Fusp%253Dsharing%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
title="https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/0?redirect=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F1x0ADTag8xk85Ty3Vx6Wyb0FQCXfKDyBQ%2Fview%3Fusp%3Dsharing&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
moz-do-not-send="true">https://drive.google.com/file/d/1x0ADTag8xk85Ty3Vx6Wyb0FQCXfKDyBQ/view?usp=sharing</a></div>
<br>
<div><span style="color:rgb(35, 31, 32)"><font
style="font-size:14.5px"><font
style="font-family:Nylas-Pro, Helvetica,
"Lucidia Grande", sans-serif">If I do the
joins one by one, then yes it is easy to save the
point dataset as a shapefile after it has been
joined with the csv file, but I can't find a way of
doing this in batch mode.</font></font></span></div>
<br>
<div><span style="color:rgb(35, 31, 32)"><font
style="font-size:14.5px"><font
style="font-family:Nylas-Pro, Helvetica,
"Lucidia Grande", sans-serif">Any
suggestions?</font></font></span></div>
<br>
<div><span style="color:rgb(35, 31, 32)"><font
style="font-size:14.5px"><font
style="font-family:Nylas-Pro, Helvetica,
"Lucidia Grande", sans-serif">Thanks,</font></font></span></div>
<br>
<div><span style="color:rgb(35, 31, 32)"><font
style="font-size:14.5px"><font
style="font-family:Nylas-Pro, Helvetica,
"Lucidia Grande", sans-serif">Sam</font></font></span></div>
<br>
<br>
<br>
<br>
<br>
<div>On May 28 2018, at 2:16 am, Nicolas Cadieux <a
href="https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/2?redirect=mailto%3Anicolas.cadieux%40archeotec.ca&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
title="mailto:nicolas.cadieux@archeotec.ca"
moz-do-not-send="true"><nicolas.cadieux@archeotec.ca></a>
wrote:</div>
<blockquote><br>
<div>
<div>Hi,</div>
<div>Once you have joined the geometry file to the
matching attribute file, you should be able to save
that as a shape file. If you can’t figure it out, put
a sample on the next email.</div>
<div>Nicolas</div>
<div><br>
<div>Le 27 mai 2018 à 17:10, Samuel Williams <<a
href="https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/3?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F1%3Fredirect%3Dmailto%253Asam.williams%2540sineenvironmental.com%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
title="https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/1?redirect=mailto%3Asam.williams%40sineenvironmental.com&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
moz-do-not-send="true">sam.williams@sineenvironmental.com</a>>
a écrit :</div>
<br>
</div>
<blockquote>
<div>
<div>Hello,</div>
<br>
<div>I've hit a issue in Qgis that I'm struggling to
resolve, and I'm hoping that someone might be able
to point me in the right direction.</div>
<br>
<div>I have 12 point geometry data sets and 12 csv
files. Each csv file contain the attributes for
one of the point data sets - there are exactly the
same number of records in each point / csv pair:</div>
<br>
<div>Points1.shp:</div>
<div>-- point 1 UID</div>
<div>-- point 2 UID</div>
<div>..</div>
<div>-- point 980 UID</div>
<br>
<div>Attributes1.csv:</div>
<div>-- record 1 (Point 1 UID, blah, blah, whatever)</div>
<div>-- record 2 (Point 2 UID, blah, blah, whatever)</div>
<div>...</div>
<div>-- record 980 (Point 980 UID, blah, blah,
whatever)</div>
<br>
<div>I've loaded them all into Qgis and was hoping
that I could join them as a batch process, so that
I end up with 12 point geometry shapefiles, with
each point associated with the equivalent record
from the matching csv file.... I've had some
success, in that the batch interface to join
allows me to list the input layers, fields for the
joins and the output file names very easily, but I
can't work out how to preserve the geometry of the
points. The only file type listed that I can save
are DBF / XLSX / CSV / ODS files, which will only
preserve the joined tables not the geometry.</div>
<br>
<div>Am I approaching this whole problem in the
wrong way, or is there something very obvious that
I've missed?</div>
<br>
<div>I'm using:</div>
<div>
<div>
<div>
<table style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;" cellspacing="2"
cellpadding="0" align="center" width="100%"
border="0">
<tbody>
<tr>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">QGIS version</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">2.18.17</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">QGIS code branch</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;"><a
href="https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/4?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F2%3Fredirect%3Dhttps%253A%252F%252Flink.getmailspring.com%252Flink%252F1527454204.local-f62ddf4d-2b7e-v1.2.1-7e7447b6%2540getmailspring.com%252F0%253Fredirect%253Dhttps%25253A%25252F%25252Fgithub.com%25252Fqgis%25252FQGIS%25252Ftree%25252Frelease-2_18%2526recipient%253DcWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%25253D%25253D%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
moz-do-not-send="true"><span
style=" text-decoration:
underline; color:#0000ff;">Release
2.18</span></a></p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">Compiled against
Qt</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">4.8.7</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">Running against Qt</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">4.8.7</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">Compiled against
GDAL/OGR</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">2.2.3</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">Running against
GDAL/OGR</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">2.2.3</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">Compiled against
GEOS</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">3.6.2-CAPI-1.10.2</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">Running against
GEOS</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">3.6.2-CAPI-1.10.2
4d2925d6</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">PostgreSQL Client
Version</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">10.2 (Ubuntu
10.2-1)</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">SpatiaLite Version</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">4.3.0a</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">QWT Version</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">6.1.3</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">PROJ.4 Version</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">493</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">QScintilla2
Version</p>
</td>
<td>
<p style=" margin-top:0px;
margin-bottom:0px; margin-left:0px;
margin-right:0px;
-qt-block-indent:0;
text-indent:0px;">2.10.2</p>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div>This particular workstation is running Ubuntu
18.04 on amd64 hardware.</div>
<br>
<div>Any suggestions welcomed - I know that for just
12 data sets I could probably have done the joins
manually in the time it has taken to type this
out, but I'm really curious as to whether there is
a better way.</div>
<br>
<div>Cheers,</div>
<br>
<div>Sam</div>
<br>
<div>
<div><img alt="Open Tracking" style="border:0;
width:0; height:0;"
src="https://link.getmailspring.com/open/1527454204.local-f62ddf4d-2b7e-v1.2.1-7e7447b6@getmailspring.com?recipient=cWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%3D%3D"
moz-do-not-send="true" height="0" width="0"></div>
</div>
</div>
</blockquote>
<blockquote>
<div>
<div>_______________________________________________</div>
<div>Qgis-user mailing list</div>
<div><a
href="https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/5?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F3%3Fredirect%3Dmailto%253AQgis-user%2540lists.osgeo.org%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
title="https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/3?redirect=mailto%3AQgis-user%40lists.osgeo.org&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
moz-do-not-send="true">Qgis-user@lists.osgeo.org</a></div>
<div>List info: <a
href="https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/6?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F4%3Fredirect%3Dhttps%253A%252F%252Flists.osgeo.org%252Fmailman%252Flistinfo%252Fqgis-user%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
title="https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/4?redirect=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
<div>Unsubscribe: <a
href="https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/7?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F5%3Fredirect%3Dhttps%253A%252F%252Flists.osgeo.org%252Fmailman%252Flistinfo%252Fqgis-user%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
title="https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/5?redirect=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</div>
</blockquote>
</div>
</blockquote>
<div><img alt="Open Tracking" style="border:0; width:0;
height:0;"
src="https://link.getmailspring.com/open/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com?recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
moz-do-not-send="true" height="0" width="0"></div>
</blockquote>
</div>
</blockquote>
<img class="mailspring-open" alt="Open Tracking" style="border:0;
width:0; height:0;"
src="https://link.getmailspring.com/open/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com?recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D"
moz-do-not-send="true" height="0" width="0">
</blockquote>
<br>
</body>
</html>