The Great Migration: Part 2g, The Explore Updater


Explore is a searchable and filterable list of attractions, accommodation, restaurants, venues, events and associated things on our main consumer website.

As discussed in part 2a the event data mostly comes from the Press Association, the other data mostly comes from our Partners and their products. 

This is entered in to CRM by the users and then sent to the Content Management System that powers the website.

vNext Explore Process - Current

If this looks familiar its because it is almost the exact same process as used by the PA Event Importer from part 2a, as such it also suffers from the same issues of duplicate entry creation and slowness.

Unsurprisingly the planed replacement is also very similar

vNext Explore Process - vNext

Instead of relying on CRM to send messages to a plugin to push to the website we will use a WebJob in Azure to query CRM for updates on a schedule.

The Great Migration: Part 2f, PCA Predict


Well damn, we missed one.

dynamics-crm-us-screen

The Account and Contact Entities are integrated with PCA Predict. We use their Global Address Validation for Microsoft Dynamics integration to lookup UK addresses by postcode through their API – http://www.pcapredict.com/en-us/dynamics/.

We have used this service since around 2012 and have never had any issues with it and using the Pay-Per-Lookup pricing costs us almost nothing – for reference, we are currently doing around 300 lookups per year.

At least this is trivial to migrate, they have prebuilt all the JavaScript and have really nice documentation on how to add the files and hook up the parts.