skip to navigation
skip to content

bcompiler 1.3.10

Program to migrate data for DfT BICC reporting process.

Latest Version: 1.3.19

Quick Start

  • Ensure Python 3.6.2 or later is installed on your system.
  • Ensure git is installed on your system.
  • pip install bcompiler
  • bcompiler-init
  • bcompiler --help


bcompiler is a tool to manage data involved in the BICC reporting process at the UK Department for Transport.

bcompiler processes data held in Excel files, either compiling similar data from many Excel files into a single master spreadsheet, or populating many Excel files using the data from a master spreadsheet.

“Auxiliary” files are required to map data in each direction, and to templates. These files are contained in a DfT reporitory on GitHub. bcompiler can be used to obtain/update these files.


Full documentation for the project can be found at


30 October 2017

  • Fix bug where not all columns in master are being processed during swimlane analyser.

17 October 2017

  • Changed ERROR log message to WARNING to accommodate dates mixed with free text.

16 October 2017

  • Fix bug where cell value in string and datetime value would try to compare arithmetically.

11 October 2017

  • Fix bug where .xlsx files not being picked up.
  • Improved exception handling and bug fixes.

10 October 2017

  • Handling cp1252 encoding coming through from Windows
  • Added CHANGES.txt
  • Minor bugfixes
File Type Py Version Uploaded on Size
bcompiler-1.3.10-py3-none-any.whl (md5) Python Wheel py3 2017-12-07 78KB
bcompiler-1.3.10.tar.gz (md5) Source 2017-12-07 60KB