In this section, you will find information on how to retrieve data directly, a series of user manuals to help with data retrieval and downloading, including processing of data after download, and documents explaining the structure of the Registry database. 

The EBMT realises how important it can be for centres to have access to the data they submit and has ensured that centres can always do this.  The best way is to access the data directly using the same system used for data entry. This ensures centres can retrieve their data how and when they want. If centres are unable or unwilling to do so, they can request that a copy of their data be forwarded to them by the Registry. 

Retrieving data directly 

Users can run columnar reports on their own data filtering the output by data items such as year of the HSCT, type of donor, diagnosis, etc. They can also run reports on aggregated data in the form of frequency tables or cross-tabulations. Centres that are members of the EBMT can also run reports on aggregated data from the whole database.

Any user with Data entry access automatically has access to data retrieval. 

If the user does not have data entry access, personal, non-transferable usernames and passwords can be requested for data retrieval only. As for Data Entry access, the request for Data retrieval must be made to the Registry Office by faxing the ProMIse personal password request - data download. All individuals must be authorised by the Principal Investigator (PI) of the centre where they work. We will check the name of the PI against the EBMT membership list. Data Download access gives the user access to: Reporting and downloading centre’s data. 

User guides for Data retrieval

A series of guides are available to users to help with data retrieval and downloading, including processing of data after download. 

Guide to retrieving data from the EBMT Med-AB Database

Guide to obtaining statistical summaries from the complete EBMT Med-AB database

Catalogue of pre-programmed data retrieval queries available within the EBMT Registry database

Guide to producing data quality reports in the EBMT Registry database using ProMIse 

Data processing after download 

Excel file processing

Data that is downloaded in Excel format can be further processed using macros incorporated in the download.  

The documents below provide explanations on how to obtain the best from the macros.

User Guide to Excel Macros as used by ProMISe Exports in Excel Format

Click here to access a help guide on BSBMT Study Spreadsheets using Excel Macros. 

MED-A paper form merging 

MED-A Merge program (MS Office 2007)
MED-A Merge program (MS Office 2003)

This zip file contains the necessary files and information to obtain a paper copy of each Med-A submitted to the EBMT, with or without the missing items highlighted. While for some users obtaining a missing data report is the main reason to use this procedure, other users may want to use the program to print Med-As which may be required for accreditation or auditing.  

Linking of a local database with the EBMT centre database

Centres may wish to store information which is not reflected in the current EBMT database structure, such as administrative or personal data.

In this document we provide step by step instructions on how to set up an updatable link between a local database and the downloaded backup of the centre’s Registry data.

Database structure

The EBMT Registry Database: provides a visual presentation of the various levels and tables used in the relational structure.

The EBMT Registry Database for registration of Allogeneic or Autologous Stem Cell Transplantation: gives a written definition of the levels and tables in the structure and should be read in conjunction with the above document.