bramtayl / cpe Goto Github PK

This repository contains the code I used to migrate the data for the Center for Popular Economics (CPE) to CiviCRM.

The old data was scattered across several sources: an Microsoft Access database, mailing lists in Rise Up and MailChimp, and supplemental spreadsheets. I have not made this data publicly available.

I used R to combine the data, clean it, and put it into a form to match the CiviCRM database. Finally, I directly uploaded the data to the MySQL backend for our website server.

The entry point is CPE.R, which will call all the other files. If you would like to delete everything and start again, run delete.R.

I used the mdb.get function from the Hmisc package to interface with Access. This was less than ideal; I had to create a patched version of it to fix a bug. A preferred option would have been to use ODBC with Microsoft Access, but I couldn't do that because I'm running Linux.