Hi,
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.
Nicolas

> Le 5 nov. 2016 à 22:30, Joe Lertola [via OSGeo.org] 
> <ml-node+s1560n5294475...@n6.nabble.com> a écrit :
> 
> 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.
> -Joe
> 
> 
> 
> Thanks,
> -Joe
> 
> 
>> On Nov 5, 2016, at 9:57 AM, Nicolas Cadieux <[hidden email]> wrote:
>> 
>> Very interesting Nyall 
>> 
>> 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...?  
>> 
>> Nicolas
>> 
>>> Le 4 nov. 2016 à 23:22, Nyall Dawson [via OSGeo.org] <<a 
>>> href="x-msg://34/user/SendEmail.jtp?type=node&amp;node=5294431&amp;i=0" 
>>> target="_top" rel="nofollow" link="external" class="">[hidden email]> a 
>>> écrit :
>>> 
>>> 
>>> On 5 Nov 2016 12:13 PM, "Joe Lertola" <<a 
>>> href="x-msg://34/user/SendEmail.jtp?type=node&amp;node=5294406&amp;i=0" 
>>> target="_top" rel="nofollow" link="external" class="">[hidden email]> wrote:
>>> >
>>> > Hello.
>>> >
>>> > 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.
>>> 
>>> 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.
>>> 
>>> Nyall
>>> 
>>> >
>>> > Thanks,
>>> > -Joe
>>> >
>>> >
>>> > _______________________________________________
>>> > Qgis-user mailing list
>>> > <a 
>>> > href="x-msg://34/user/SendEmail.jtp?type=node&amp;node=5294406&amp;i=1" 
>>> > target="_top" rel="nofollow" link="external" class="">[hidden email]
>>> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>> 
>>> 
>>> _______________________________________________ 
>>> Qgis-user mailing list 
>>> <a href="x-msg://34/user/SendEmail.jtp?type=node&amp;node=5294406&amp;i=2" 
>>> target="_top" rel="nofollow" link="external" class="">[hidden email] 
>>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user 
>>> 
>>> If you reply to this email, your message will be added to the discussion 
>>> below:
>>> 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
>>> To start a new topic under Quantum GIS - User, email <a 
>>> href="x-msg://34/user/SendEmail.jtp?type=node&amp;node=5294431&amp;i=1" 
>>> target="_top" rel="nofollow" link="external" class="">[hidden email] 
>>> To unsubscribe from Quantum GIS - User, click here.
>>> NAML
>> 
>> View this message in context: Re: Joining data to a shape file by country 
>> name when the names don't match exactly
>> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
>> _______________________________________________
>> Qgis-user mailing list
>> [hidden email]
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> 
> 
> _______________________________________________ 
> Qgis-user mailing list 
> [hidden email] 
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user 
> 
> If you reply to this email, your message will be added to the discussion 
> below:
> 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
> To start a new topic under Quantum GIS - User, email 
> ml-node+s1560n4125267...@n6.nabble.com 
> To unsubscribe from Quantum GIS - User, click here.
> NAML




--
View this message in context: 
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
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to