<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Thanks, <div class=""><br class=""></div><div class="">I will keep in mind the idea of making a plugin if I need to accomplish this task more often in the future. I don’t know if the Python console would work because there would need to be an interface for the user to manually select records that can not be matched exactly. Can that be written for code that goes into the Python console?</div><div class=""><br class=""></div><div class="">I did use that vlookup function in Excel which is great when the names match exactly. But the close match algorithm is not good because it is more likely than not to find the wrong country name. What you need to do when a record does not match is to manually correct it. This is tedious when there are a lot of names that don’t match.</div><div class=""><br class=""><div class="">
<span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div class="">-Joe</div><br class="Apple-interchange-newline"></span></span>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On Nov 6, 2016, at 10:21 AM, Nicolas Cadieux <<a href="mailto:nicolas.cadieux@archeotec.ca" class="">nicolas.cadieux@archeotec.ca</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="content-type" content="text/html; charset=utf-8" class=""><div class=""></div><div class="">Hi,</div><div class="">Stick to Excel for now. Keep in mind that Python can be used in the Python console. Building a for al plugin may not be necessary. Have you tried the vlookup function? It has a "close match algorithm " by default. That may help.</div><div class="">Nicolas</div><div class=""><br class="">Le 5 nov. 2016 à 22:30, Joe Lertola [via <a href="http://osgeo.org/" target="_top" rel="nofollow" link="external" class="">OSGeo.org</a>] <<a href="x-msg://38/user/SendEmail.jtp?type=node&node=5294502&i=0" target="_top" rel="nofollow" link="external" class="">[hidden email]</a>> a écrit :<br class=""><br class=""></div><blockquote style="border-left:2px solid #CCCCCC;padding:0 1em" type="cite" class=""><div class="">
<meta http-equiv="Content-Type" content="text/html charset=utf-8" class="">I used to program in my youth so I am familiar with programming concepts. But I would have to learn python and how to create plugins for Qgis from scratch. So that is not a project that will happen very fast if I do it. If it turns out that I have to create a lot of maps like this I might start looking into it. For now I will stick to Excel.<br class=""><div class="">
<span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px;"><div class="">-Joe</div><br class="Apple-interchange-newline"></span>
</div>
<br class=""><div class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><br class=""></div><div class="">Thanks,</div><div class="">-Joe</div><div class=""><br class=""></div><div apple-content-edited="true" class="">
</div>
<br class=""><div class=""><blockquote style="border-left:2px solid #CCCCCC;padding:0 1em" type="cite" class=""><div class="">On Nov 5, 2016, at 9:57 AM, Nicolas Cadieux <<a href="x-msg://38/user/SendEmail.jtp?type=node&node=5294475&i=0" target="_top" rel="nofollow" link="external" class="">[hidden email]</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="content-type" content="text/html; charset=utf-8" class=""><div class=""></div><div class="">Very interesting Nyall </div><div class=""><br class=""></div><div class="">That makes me remember that the vlookup in excel also has a "bests match" by default. I always turn it off because it uses the first found possible match. I wonder if it uses the same type of "Fuzzy" logic...? </div><div class=""><br class=""></div><div class="">Nicolas</div><div class=""><br class="">Le 4 nov. 2016 à 23:22, Nyall Dawson [via <a href="http://osgeo.org/" target="_top" rel="nofollow" link="external" class="">OSGeo.org</a>] <<a href="<a href="x-msg://34/user/SendEmail.jtp?type=node&node=5294431&i=0" class="">x-msg://34/user/SendEmail.jtp?type=node&node=5294431&i=0</a>" target="_top" rel="nofollow" link="external" class="">[hidden email]> a écrit :<br class=""><br class=""></div><blockquote style="border-left:2px solid #CCCCCC;padding:0 1em" type="cite" class=""><div class=""><div class=""><br class="webkit-block-placeholder"></div><p dir="ltr" class="">On 5 Nov 2016 12:13 PM, "Joe Lertola" <<a href="<a href="x-msg://34/user/SendEmail.jtp?type=node&node=5294406&i=0" class="">x-msg://34/user/SendEmail.jtp?type=node&node=5294406&i=0</a>" target="_top" rel="nofollow" link="external" class="">[hidden email]> wrote:<br class="">
><br class="">
> Hello.<br class="">
><br class="">
> Today I made a thematic map by joining a list of data that had country names to a shape file of world countries. I had to spend a lot of time working in Excel to make my data names match the names in the shape file. A lot of them already matched but there were many that didn’t. For example the the shape file had Ivory Coast and the data had Cte d’Ivoire as the name. Is there any way to do this in Qgis instead of Excel? Years ago I recall doing this in ArcMap. There was a tool that matched up the data where it could and then for each record that wasn’t matched you could choose the matching record manually. Any help would be greatly appreciated.</p><p dir="ltr" class="">How good are your python skills? Sounds like a perfect candidate for a new processing algorithm. QgsStringUtils has methods for performing "fuzzy" matching of strings, so a lot of the hard work is already done.<br class=""></p><p dir="ltr" class="">Nyall</p><p dir="ltr" class="">><br class="">
> Thanks,<br class="">
> -Joe<br class="">
><br class="">
><br class="">
> _______________________________________________<br class="">
> Qgis-user mailing list<br class="">
> <a href="<a href="x-msg://34/user/SendEmail.jtp?type=node&node=5294406&i=1" class="">x-msg://34/user/SendEmail.jtp?type=node&node=5294406&i=1</a>" target="_top" rel="nofollow" link="external" class="">[hidden email]<br class="">
> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external" class="">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class="">
> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external" class="">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class=""></p>
<br class="">_______________________________________________
<br class="">Qgis-user mailing list
<br class=""><a href="<a href="x-msg://34/user/SendEmail.jtp?type=node&node=5294406&i=2" class="">x-msg://34/user/SendEmail.jtp?type=node&node=5294406&i=2</a>" target="_top" rel="nofollow" link="external" class="">[hidden email]
<br class="">List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external" class="">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class="">Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external" class="">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br class="">
<br class="">
<hr noshade="noshade" size="1" class="">
<div style="color:#444; font: 12px tahoma,geneva,helvetica,arial,sans-serif;" class="">
<div style="font-weight:bold" class="">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/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294406.html" target="_top" rel="nofollow" link="external" class="">http://osgeo-org.1560.x6.nabble.com/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294406.html</a>
</div>
<div style="color:#666; font: 11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em" class="">
To start a new topic under Quantum GIS - User, email <a href="<a href="x-msg://34/user/SendEmail.jtp?type=node&node=5294431&i=1" class="">x-msg://34/user/SendEmail.jtp?type=node&node=5294431&i=1</a>" target="_top" rel="nofollow" link="external" class="">[hidden email] <br class="">
To unsubscribe from Quantum GIS - User, <a href="" target="_top" rel="nofollow" link="external" class="">click here</a>.<br class="">
<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" rel="nofollow" style="font:9px serif" target="_top" link="external" class="">NAML</a>
</div></div></blockquote>
<br class=""><hr align="left" width="300" class="">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294431.html" class="" target="_top" rel="nofollow" link="external">Re: Joining data to a shape file by country name when the names don't match exactly</a><br class="">
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html" class="" target="_top" rel="nofollow" link="external">Quantum GIS - User mailing list archive</a> at <a href="http://nabble.com/" class="" target="_top" rel="nofollow" link="external">Nabble.com</a>.<br class="">_______________________________________________<br class="">Qgis-user mailing list<br class=""><a href="x-msg://38/user/SendEmail.jtp?type=node&node=5294475&i=1" target="_top" rel="nofollow" link="external" class="">[hidden email]</a><br class="">List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" class="" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class="">Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" class="" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div></blockquote></div><br class=""></div></div><br class=""><br class="">_______________________________________________
<br class="">Qgis-user mailing list
<br class=""><a href="x-msg://38/user/SendEmail.jtp?type=node&node=5294475&i=2" target="_top" rel="nofollow" link="external" class="">[hidden email]</a>
<br class="">List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external" class="">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class="">Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external" class="">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br class="">
<br class="">
<hr noshade="noshade" size="1" class="">
<div style="color:#444; font: 12px tahoma,geneva,helvetica,arial,sans-serif;" class="">
<div style="font-weight:bold" class="">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/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294475.html" target="_top" rel="nofollow" link="external" class="">http://osgeo-org.1560.x6.nabble.com/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294475.html</a>
</div>
<div style="color:#666; font: 11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em" class="">
To start a new topic under Quantum GIS - User, email <a href="x-msg://38/user/SendEmail.jtp?type=node&node=5294502&i=1" target="_top" rel="nofollow" link="external" class="">[hidden email]</a> <br class="">
To unsubscribe from Quantum GIS - User, <a href="" target="_top" rel="nofollow" link="external" class="">click here</a>.<br class="">
<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" rel="nofollow" style="font:9px serif" target="_top" link="external" class="">NAML</a>
</div></div></blockquote>
<br class=""><hr align="left" width="300" class="">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294502.html" class="">Re: Joining data to a shape file by country name when the names don't match exactly</a><br class="">
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html" class="">Quantum GIS - User mailing list archive</a> at <a href="http://Nabble.com" class="">Nabble.com</a>.<br class="">_______________________________________________<br class="">Qgis-user mailing list<br class=""><a href="mailto:Qgis-user@lists.osgeo.org" class="">Qgis-user@lists.osgeo.org</a><br class="">List info: http://lists.osgeo.org/mailman/listinfo/qgis-user<br class="">Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user</div></blockquote></div><br class=""></div></body></html>