<p><span style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">L'import des licences s'effectue à partir du fichier csv fourni par le secrétariat de la FFM.</span></p>
<p><span style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">Dans cette base il y a (édition 04/01/2017):</span></p>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">- 36 licenciés en double (cf ods joint)</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">- 172 licenciés avec un nom de ville non conforme au nom réel de la commune</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"> </div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">
<div><strong><span style="font-size: 12.8px;">Important, nomalise avant import</span></strong></div>
<div><strong><span style="font-size: 12.8px;"> - ne pas mettre le code postal dans le nom de la commune (il est dans le code postal) (PARIS,MARSEILLE) </span></strong></div>
<div><strong><span style="font-size: 12.8px;"> - 3 noms de villes corrigées (BENESSE-MAREMNE , CANNES, MANDELIEU-LA-NAPOULE </span></strong></div>
<div><strong><span style="font-size: 12.8px;"> - reste à traiter le cas des Belges (DAVE, ASSE, CHIMAY) </span></strong></div>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"> </div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">J'ai programmé le logiciel pour parer à ces deltas, à vérifier lors du chargement d'une nouvelle base pour les licenciés recensés dans le fichier ci-dessous :</span></span><br clear="all" />
<div style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"> </div>
<div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">300465 KEIL FRANCOIS 5100 DAVE X BELGIQUE ?</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">300465 KEIL FRANCOIS 5100 DAVE X BELGIQUE ?</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">267996 GALLIANI GERARD 84140 MONTFAVET X AVIGNON</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">235576 FREROT DIDIER 1730 ASSE X BELGIQUE</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">235577 VAN HERZEELE HILDE 1730 ASSE X BELGIQUE</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">298308 DONCQ JEAN-CHARLES 6460 CHIMAY X BELGIQUE</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">155944 DUPIN MIREILLE 40230 BANESSE MAREMNE X BENESSE-MAREMNE </span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">156451 PELLETIER ERIC 6150 CANNES LA BOCCA X CANNES</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">262539 BROCHERY BRIGITTE 6210 LA NAPOULE X MANDELIEU-LA-NAPOULE </span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">50268 PRESTREAU OLIVIER 13003 MARSEILLE 03 X MARSEILLE</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">55679 PRESTREAU RYAN 13003 MARSEILLE 03 X MARSEILLE</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">279301 FELGEIROLLES BRIGITTE 13003 MARSEILLE 03 X MARSEILLE</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">307579 MARTORELLTEST MARTORELLTEST 75011 PARIS 11 X PARIS</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">307718 SEBBAN JEAN-MARC 75020 PARIS 20 X PARIS</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">254705 GAULTIER DENIS 7500 GUILHERAND GRANGES X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">254707 GAULTIER PATRICIA 7500 GUILHERAND GRANGES X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">275679 DUNOYER PAUL 71400 LA CELLE EN MORVAN X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">148385 COUTARD MICKAEL 72160 LA CHAPELLE ST REMY X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">233260 LEGRAND YVES 44240 LA CHAPELLE SUR ERDRE X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">235575 LE GRAND LYDIA 44240 LA CHAPELLE SUR ERDRE X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">251566 LE GRAND AIMIE 44240 LA CHAPELLE SUR ERDRE X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">201609 BRIKI PASCAL 94450 LIMEIL BREVANNES X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">8530 DERRIEN DANIEL 80460 OUST MAREST X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">47058 DERRIEN MARIE HELENE 80460 OUST MAREST X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">8530 DERRIEN DANIEL 80460 OUST MAREST X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">47058 DERRIEN MARIE HELENE 80460 OUST MAREST X PROGRAMME corrigé</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">267996 GALLIANI   GERARD MONTFAVET AVIGNON</span></span></div>
<div><span style="color: #222222; font-family: arial, sans-serif;"><span style="font-size: 12.8px;">267999 GALLIANI   DANIELLE</span></span></div>
<div> </div>
<div> </div>
<p style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"> </p>
</div>
</div>