fix_vats.py

import vatnumber
partners = O.ResPartner.search_reader([('vat', '!=', False)], ['vat'])
for p in partners:
    if not vatnumber.check_vat(p['vat']):
        new_vat = ''.join([x for x in p['vat'] if x.isalnum()])
        if not vatnumber.check_vat(new_vat):
            print new_vat
        else:
            #O.ResPartner.write([p['id']], {'vat': new_vat})
            print "Ara es valid"