NHSBT Import

A script for importing NHSBT data and creating an audit file

Getting Started

You will need to create a directory on the shared data drive, under NHSBT, typically labelled using the date on which you commenced the process

Prerequisites

You will need python 3.11 and poetry installed.

Installation

Clone the repo

git clone https://github.com/renalreg/nhsbt_import.git

Setup the environment

poetry install

Usage

There are two modes for running the script. You can run the script without committing any changes to the database by running the following command, pointing at the directory you created

poetry run import.py -d /path/to/the/directory

This command will create an audit and error file in the declared directory. The error file holds any errors encountered during the run to aid with debugging.The audit file will be an excel sheet that tracks new and updated data as well as highlighting missing or deleted patient.

Running this command

poetry run import.py -c -d /path/to/the/directory

will do the same thing as above but with the addition of committing the changes to the live database.