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]
> <[email protected]> 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&node=5294431&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&node=5294406&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&node=5294406&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&node=5294406&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&node=5294431&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
> [email protected]
> 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
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
