Re: [Qgis-user] Joining data to a shape file by country name when the names don't match exactly

2016-11-07 Thread Nicolas Cadieux
Hi, If you need a user interface, you're probably looking at a plugin. I have no experience for that. I am sorry to see that the excel function didi not work for you. I normally turn it off also as it gives rather funny results. I thought this could be one situation where it could work.

Re: [Qgis-user] Joining data to a shape file by country name when the names don't match exactly

2016-11-06 Thread Joe Lertola
Thanks, 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

Re: [Qgis-user] Joining data to a shape file by country name when the names don't match exactly

2016-11-06 Thread Nicolas Cadieux
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

Re: [Qgis-user] Joining data to a shape file by country name when the names don't match exactly

2016-11-05 Thread Joe Lertola
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

Re: [Qgis-user] Joining data to a shape file by country name when the names don't match exactly

2016-11-05 Thread Nicolas Cadieux
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