We (our research team) will use the open data by the Companies House for academic purposes. To facilitate processing of the company director appointments and company profiles, I tried to develop an importer program. The intention is the store the records into a highly structured database with tables for company profiles, directors, and appointments. However, things didn't really work out as intended.
Has anyone else struggled with the documentation and inconsistencies in the bulk snapshots and daily updates?
I would more than appreciate it if I could have a quick look at your code, to find out where I made a mistake!