Home NHSBSA dictionary of medicines and devices

dm+d XML transformation tool

Use this tool to read the dm+d weekly-released XML files (under item ‘NHSBSA dm+d’ in this category) and convert the content to both Microsoft Excel and comma-separated value (CSV) files.

The tool:

runs on Microsoft Windows (fully tested on Windows 7)
runs from the C: drive - you might need local administrator permissions
requires Microsoft Excel (fully tested with Excel 2010)
uses a Microsoft Excel macro-enabled spreadsheet

No dm+d releases are included with the tool and must be downloaded separately.

Releases of this item

Release 2.0.2

A change to the dm+d XML files to remove interesting excipient data linked to AMP caused the dm+d XML transformation tool to fail. This release of the tool prevents that failure.

Released on 31 October 2022.

Release 2.0.1

A change to the dm+d XML files to remove BNF codes for AMPs caused the dm+d XML transformation tool to fail. This release of the tool prevents that failure.

Released on 6 May 2022.

Release 2.0.0

This release adds functionality to transform the GTIN file and support for dm+d Supplementary files. It also resolves an issue with Excel 2013 / Office 365.

Released on 23 September 2015.

Release 1.0.0

Released on 12 February 2015.