CiviCRM Community Forums (archive)

Hi gang,

So the UK Phone Number Validator is growing rapidly, and now contains filters! 

But it turns out that people don't want to sit and clean up thousands of phone numbers!

Consequently, I have grand plans for a newer version, which in addition to facilitating this kind of semi-automated data cleaning, will come with several buttons for automated data cleaning.

1) Removing duplicate phone records that belong to the same contact. 
2) Reassign all valid mobile numbers to be landline numbers if they look like a mobile number. 
3) The same as 2, but the other way round. 
4) (possibly even) remove a phone number if it has been assigned to two contacts.   

The problem is that our AJAX API doesn't seem to allow for these kind of complex queries.

I particularly want to use AJAX here, instead of say a URL that includes this request, as it'd be useful to display the results to the users afterwards: 1899 records adjusted.

What is the best way to do this inside a CiviCRM extension?

Thanks,

I think what X is saying is that if your extension defines a new api, then it will be magically available via CRM.api ajax.
Within your api code you can do absolutely anything you want.