We need a simple visual force [url removed, login to view] app that fills in missing URLs for the website in the Account record.
For each Account, the application will look at all email addresses in Contacts, Leads, or Opportunities that are associated with that Account. Based on the domain part of the emails found, the application will pick the 3 most found, unique domains for each account. The first domain will be the most common. In addition, a simple match algorithm should be used to see if the domain found is similar to the company name (example XYZ Painting and [url removed, login to view]). We have built a list of 1000's of free email providers such as [url removed, login to view], msn and yahoo. If the domain is in our list of free email domains, it is skipped. The user will be presented with a view to select individual records or all records. Once the user is done selecting, there will be a button to "fill URL's".
We are open to comments on the design, but want to keep this very simple. One visual force screen to do everything.
You can build it in your org, but must deliver into our org before we sign off on the project.
The final delivery should include packaging.