<div dir='ltr'>Hi,<div>"My first issue is the CVS file has both the lat/long in one column separated by a comma. I see that the import process requires them to be in separate columns."</div><div><br></div><div>Import the file in Excel or Libre Office calc. Use the text to column to split the data. I qgis, I think the data will need to be decimal degrees. If you don't have other commas, you may be able to import it in Qgis by using both comma and space (or tab or whatever field separator you have) in the csv import window.</div><div><br></div><div>"Second when collecting the pole numbers, it cannot be a dropdown box, as there are thousands of poles to scroll through on the app."</div><div><br></div><div>If your pole are georeferenced, you can use that to link both files. If not, you could join one file to another using the "layer property/ join" option. Expand more if this is not the answer you are looking for.</div><div> </div><div>"<span style="font-size: 12pt;">My goal is to create a process that imports the data from the Canvas app and creates a visual status of the lines – different colors for each status type. I would have to “link” my data to the current data received from the client."</span></div><div><span style="font-size: 12pt;"><br></span></div><div><span style="font-size: 12pt;">You can create visual style based on a column or a function. layer property/style/rule based. The style will be updated when the file is saved. </span></div><div><span style="font-size: 12pt;"><br></span></div><div><span style="font-size: 12pt;">Hope this helps.</span></div><div><span style="font-size: 12pt;">Nicolas Cadieux</span></div><div><br><br><div><hr id="stopSpelling">From: <a href="/user/SendEmail.jtp?type=node&node=5275475&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a><br>To: <a href="/user/SendEmail.jtp?type=node&node=5275475&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a><br>Date: Fri, 8 Jul 2016 11:51:36 -0600<br>Subject: Data import and export<br><br>
<div dir="ltr">
<p class="ecxMsoNormal">I have a process that I would like to create using QGIS. I
am just a beginner in this program/process, but know just enough to get into
trouble. I work for a vegetation control company and want a way to manage my
data. I have data from my client (power company) – points of the poles and
lines for the power lines. I need to collect data in the filed using Canvas app
– customizable and can export into a CVS file. What I want to do is collect location
(pole number), status (applied not needed, application completed, customer
refusal, federal land), time, date, employee, photo and some details if the
application was applied. </p>
<p class="ecxMsoNormal">My first issue is the CVS file has both the lat/long in one
column separated by a comma. I see that the import process requires them to be
in separate columns. </p>
<p class="ecxMsoNormal">Second when collecting the pole numbers, it cannot be a
dropdown box, as there are thousands of poles to scroll through on the app. </p>
<p class="ecxMsoNormal">My goal is to create a process that imports the data from
the Canvas app and creates a visual status of the lines – different colors for
each status type. I would have to “link” my data to the current data received from
the client. </p>
<p class="ecxMsoNormal">Any thoughts, applications/ programs or resources would be
greatly appreciated.</p>
<br clear="all"><br>-- <br><div class="ecxgmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr">Jonathon Roberts<br>503-798-1917<br></div></div></div></div>
</div>
<br>_______________________________________________
<br>Qgis-user mailing list
<br><a href="https:///user/SendEmail.jtp?type=node&node=5275470&i=0" rel="nofollow" target="_blank" link="external">[hidden email]</a>
<br>List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
<br>
<hr noshade="noshade" size="1" color="#cccccc">
<div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif;">
<div style="font-weight:bold;">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/Data-import-and-export-tp5275470.html" target="_blank" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/Data-import-and-export-tp5275470.html</a>
</div>
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;line-height:1.5em;">
To start a new topic under Quantum GIS - User, email <a href="/user/SendEmail.jtp?type=node&node=5275475&i=2" target="_top" rel="nofollow" link="external">[hidden email]</a> <br>
To unsubscribe from Quantum GIS - User, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble:email.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble:email.naml-instant_emails%21nabble:email.naml-send_instant_email%21nabble:email.naml" rel="nofollow" style="font:9px serif;" target="_blank" link="external">NAML</a>
</div></div></div> </div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Data-import-and-export-tp5275470p5275475.html">RE: Data import and export</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br/>