<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Glad you've got it working.<br>
<br>
Frank.<br>
<br>
On 11/08/2017 13:13, Barnett, Kevin wrote:<br>
</div>
<blockquote type="cite"
cite="mid:A82A343131ED2E419AEAC538E9A7FF80504E6B6E@server-44.bigenafrica.com">
<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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 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;
color:black;}
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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
p.style1, li.style1, div.style1
{mso-style-name:style1;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle22
{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]-->
<style type="text/css">.style1 {font-family: "Times New Roman";}</style>
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Just
tested … it worked … Thank You<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
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="EN-US">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="EN-US"> Barnett, Kevin
<br>
<b>Sent:</b> Friday, 11 August 2017 12:26 PM<br>
<b>To:</b> '<a class="moz-txt-link-abbreviated" href="mailto:sokolic@worldonline.co.za">sokolic@worldonline.co.za</a>'
<a class="moz-txt-link-rfc2396E" href="mailto:sokolic@worldonline.co.za"><sokolic@worldonline.co.za></a><br>
<b>Subject:</b> RE: [QGIS-ZA-user] links between nodes
as feature lines, data from CSV files<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;mso-fareast-language:EN-US">Thanks
Frank, lengthy gooooogling results in the same recommended
solution; I was hoping for a “quick fix” … this is the
button you need right here; oh well … makes sense… thx
again.<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
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="EN-US">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="EN-US"> Frank Sokolic
[<a class="moz-txt-link-freetext" href="mailto:sokolic@worldonline.co.za">mailto:sokolic@worldonline.co.za</a>]
<br>
<b>Sent:</b> Friday, 11 August 2017 11:25 AM<br>
<b>To:</b> South Africa QGIS user group
<a class="moz-txt-link-rfc2396E" href="mailto:qgis-za-user@lists.osgeo.org"><qgis-za-user@lists.osgeo.org></a><br>
<b>Cc:</b> Barnett, Kevin
<a class="moz-txt-link-rfc2396E" href="mailto:Kevin.Barnett@bigenafrica.com"><Kevin.Barnett@bigenafrica.com></a><br>
<b>Subject:</b> Re: [QGIS-ZA-user] links between nodes
as feature lines, data from CSV files<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Kevin,<br>
<br>
Just off the top of my head, maybe you could try the Points
to Path tool in the processing toolbox. You'd first have to
create point features for the PIPEDATA and then run them
through the Points to Path tool using the PIPE_ID as the
group field.<br>
<br>
Regards, Frank.<br>
<br>
On 11/08/2017 09:55, Barnett, Kevin via qgis-za-user wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-bottom:12.0pt">Hello,<br>
The attached COORD columns are all in SID:2053 (metres) I
can easily import the MANHOLEDATA and display as nodes:<br>
COORD1 column =X, COORD2 column = Y<br>
<br>
But how do I create line features using the PIPEDATA
txt(csv)?<br>
<br>
PIPEDATA has two node columns: "Upstream_MH","Downstream_MH"<br>
A line feature is needed between those nodes, the
coordinates provided by MANHOLEDATA.<br>
<br>
Start of line, PIPEDATA: Upstream_MH = MANHOLEDATA:
Manhole_No <br>
<br>
End of line, PIPEDATA: Downstream_MH = MANHOLEDATA:
Manhole_No<br>
<br>
Note:<br>
Even though the PIPEDATA includes COORD columns, these need
to be ignored - only use the node positions provided by
MANHOLEDATA.<br>
<br>
Thanks for reading and helping,<br>
<br>
Kevin.<o:p></o:p></p>
<p><b><span
style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#666666">Disclaimer</span></b><span
style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#666666"><o:p></o:p></span></p>
<p><span
style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#666666">The
information contained in this communication from the
sender is confidential. It is intended solely for use by
the recipient and others authorized to receive it. If you
are not the recipient, you are hereby notified that any
disclosure, copying, distribution or taking action in
relation of the contents of this information is strictly
prohibited and may be unlawful.<br>
<br>
This email has been scanned for viruses and malware, and
may have been automatically archived by
<b>Mimecast Ltd</b>, an innovator in Software as a Service
(SaaS) for business. Providing a
<b>safer</b> and <b>more useful</b> place for your human
generated data. Specializing in; Security, archiving and
compliance. To find out more
<a href="http://www.mimecast.com/products/"
target="_blank" moz-do-not-send="true">Click Here</a>.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>qgis-za-user mailing list<o:p></o:p></pre>
<pre><a href="mailto:qgis-za-user@lists.osgeo.org" moz-do-not-send="true">qgis-za-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre><a href="https://lists.osgeo.org/mailman/listinfo/qgis-za-user" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-za-user</a><o:p></o:p></pre>
</blockquote>
<p><o:p> </o:p></p>
</div>
<br>
<br>
<p style="font-family: Verdana; font-size:10pt; color:#666666;"><b>Disclaimer</b></p>
<p style="font-family: Verdana; font-size:8pt; color:#666666;">The
information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and
others authorized to receive it. If you are not the recipient,
you are hereby notified that any disclosure, copying,
distribution or taking action in relation of the contents of
this information is strictly prohibited and may be unlawful.<br>
<br>
This email has been scanned for viruses and malware, and may
have been automatically archived by <b>Mimecast Ltd</b>, an
innovator in Software as a Service (SaaS) for business.
Providing a <b>safer</b> and <b>more useful</b> place for your
human generated data. Specializing in; Security, archiving and
compliance. To find out more <a
href="http://www.mimecast.com/products/" target="_blank"
moz-do-not-send="true">Click Here</a>.</p>
</blockquote>
<p><br>
</p>
</body>
</html>