<p dir="ltr">Hi,<br>
You could trouble shoot by changing the E to another letter to see if that changes anything...<br>
Nicolas</p>
<div class="gmail_quote">On Jun 7, 2016 5:46 AM, "Chris Berens [via OSGeo.org]" <<a href="/user/SendEmail.jtp?type=node&node=5270380&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br type='attribution'><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div>Hi Nicolas,<br /><br /></div>The fields are both TEXT.<br /><br /></div>Regards,<br /></div>Chris<br /></div><div><br clear="all" /><div><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Chris Berens, GISc<br /></div><div><a href="http://www.mapland.co.za" target="_top" rel="nofollow" link="external">www.mapland.co.za</a><br /></div><div>+27 (0)82 567 9322<br /></div></div></div></div></div></div></div></div></div></div>
<br /><div class="elided-text">On 6 June 2016 at 16:17, Nicolas Cadieux <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=5270344&i=0">[hidden email]</a>></span> wrote:<br /><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' style="border-left:2px solid #cccccc;padding:0 1em">
Hi,<br />
My guess is that the value where imported from a csv with no field
type value. Therefore, text values could have been imported as
float values in the shape file. What is the field type for both
your files?<br />
Nicolas<br />
<br />
<a href="https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/" target="_top" rel="nofollow" link="external">https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/</a><div><div><br />
<br />
<div>Le 2016-06-06 06:13, Chris Berens [via
OSGeo.org] a écrit :<br />
</div>
</div></div><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' style="border-left:2px solid #cccccc;padding:0 1em"><div><div>
<div dir="ltr">
<div>Hi there,</div>
<div><br />
</div>
<div>I have a layer of homes (roofs) and a list of residents who
are linked to a home by the roof number. The homes are
attributed via a re-blocking exercise running 1-31 and A-J,
eg. 18G is a block. Within each block there may be up to 100
homes, eg. 18G-47.</div>
<div><br />
</div>
<div>So under Project Properties I set up a relation called
'households' and using the Identify Features tool I can view
the members of a household by clicking on the roof. Works
great, most of the time.</div>
<div><br />
</div>
<div>When I click on an E block roof (eg 18E-23) it returns all
291 XXE-XX residents on the list. It appears to me as if the
relation is reading the values as scientific notation numeric
values instead of the declared text status in both files.</div>
<div><br />
</div>
<div>I have an <i>Attribute table</i> in the a <i>Composer</i>
window in the same <i>project</i> that references the same
relation perfectly, ie it only returns the residents
particular to eg 18E23. So is the <i>Identify Features</i>
tool using a different select rule set or parameters?</div>
<div><br />
</div>
<div>I have tried to search for a previous thread on this topic
without success. The pain would appear to be for me alone, but
can anyone suggest a way of defining a relation to avoid this?</div>
<div><br />
</div>
<div>FWIW I'm using 2.14.3-64bit on Win7, this behaviour is true
for sqlite and shp formats.</div>
<div><br />
</div>
<div>Thank you for your attention,</div>
<div>Chris</div>
<br />
Chris Berens, GISc<br />
<a href="http://www.mapland.co.za" target="_top" rel="nofollow" link="external">www.mapland.co.za</a><br />
<a href="tel:%2B27%20%280%2982%20567%209322" value="+27825679322" target="_blank">+27 (0)82 567 9322</div>
<br /></div></div>
_______________________________________________
<br />
Qgis-user mailing list
<br />
<a href="http:///user/SendEmail.jtp?type=node&node=5270096&i=0">[hidden email]</a>
<br />
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br />
<br />
<hr noshade="noshade" size="1" />
<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/Project-relation-sci-notation-tp5270096.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096.html</a>
</div>
<div style="color:#666;font:11px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif;margin-top:0.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email
<a href="http:///user/SendEmail.jtp?type=node&node=5270145&i=0">[hidden email]</a> <br />
To unsubscribe from Quantum GIS - User, click
here.<br />
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML</a> </div>
</blockquote>
<br />
<br /><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270145.html" target="_top" rel="nofollow" link="external">Re: Project relation - sci. notation</a><br />
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html" target="_top" rel="nofollow" link="external">Quantum GIS - User mailing list archive</a> at Nabble.com.<br /><br />_______________________________________________<br />
Qgis-user mailing list<br />
<a href="/user/SendEmail.jtp?type=node&node=5270344&i=1">[hidden email]</a><br />
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br /></blockquote></div><br /></div>
<br />_______________________________________________
<br />Qgis-user mailing list
<br /><a href="/user/SendEmail.jtp?type=node&node=5270344&i=2">[hidden email]</a>
<br />List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br />
<br />
<hr noshade="noshade" size="1" />
<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/Project-relation-sci-notation-tp5270096p5270344.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270344.html</a>
</div>
<div style="color:#666;font:11px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif;margin-top:0.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com <br />
To unsubscribe from Quantum GIS - User, <a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click here</a>.<br />
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML</a>
</div></blockquote></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270380.html">Re: Project relation - sci. notation</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/>