Salesforce has a handy tool to insert, update, and delete bulk data from CSV, XML, or JSON files. Salesforce says the tool only works on Windows and MacOS.
This can only be for lack of a QA team because not only is the tool written in platform-independent Java, but the download includes all the code you need to run it on Linux including a secret install script.
Here’s how to get it working in a few easy steps.
Following this year’s review by the Boundary Commissions for England, Wales, Scotland, and Northern Ireland, the next General Election will be fought on new constituencies for the first time since 2010.
Full data isn’t published by the ONS yet. But the Lib Dems use our well-loved online interface to Salesforce, Lighthouse, to manage selection processes for election candidates and need to have the new constituency data to plan for the next GE, in addition to the existing constituencies on which any by-elections before the next GE will still be fought.
In order to import the new data into Salesforce, they naturally turned to Prater Raines for our expertise in political geography and API and database design.
If you work with political geography data and Salesforce, need your own organisation structure mapped, or your online campaign would benefit from enabling supporters to email MPs based on their geographic location, get in touch.