After you import MDM SaaS assets, import reference data code values in bulk from CSV files into reference data assets. Product 360 for Life Sciences uses reference data from sources, such as Fast Healthcare Interoperability Resources (FHIR) and Substances, Products, Organisations, and Referentials (SPOR) - Referentials Management System (RMS).
The following table describes the files and folders in the extracted reference data directory:
File or Folder Name
Description
FHIR Based Reference Data
The folder that contains the FHIR lookup code values folders.
The FHIR Based Reference Data folder contains the following folders:
- _1. Contains the parent lookup code values.
- _2. Contains the child lookup code values.
- LoadReferenceData.py. Python script to import FHIR based reference data.
SPOR Based Reference Data
The folder that contains the SPOR lookup code values folders.
The SPOR Based Reference Data folder contains the following folders:
- _1. Contains the parent lookup code values.
- _2. Contains the child lookup code values.
- LoadReferenceData.py. Python script to import SPOR based reference data.
Based on your requirements, you can import the FHIR or SPOR based reference data. You can also use code values from both FHIR and SPOR based reference data to customize reference data for your requirements. After you update the required code values in the CSV files that are available in the extracted reference data directory, you can import the code values in bulk. To import code values in bulk, run the LoadReferenceData.py Python script.
Due to licensing permission restrictions, Product 360 for Life Sciences also includes the following reference data sets for which there are no reference data values in the package:
•infap360ls_Comorbidity
•infap360ls_DiseasesSymptomProcedure
•infap360ls_DiseaseStatus
•infap360ls_InteractionEffect
•infap360ls_ProdClassCodeSystem
•infap360ls_StatusVal
•infap360ls_Substance
Use your internal resources to load reference data for the reference data sets that don't include reference data values.
Product 360 for Life Sciences includes reference data from sources, such as FHIR and SPOR-RMS with distribution licenses.
•To support EU-wide regulatory activities, Product 360 for Life Sciences uses the RMS data of the European Medicines Agency (EMA). The RMS data enables stakeholders in the European medicines regulatory network to uniquely identify medicinal products. For more information about SPOR-RMS, see SPOR-RMS.
The extension uses reference data from SPOR-RMS with distribution licences. For more information about the distribution license for SPOR-RMS, see About RMS.
•To exchange electronic healthcare data, Product 360 for Life Sciences uses reference data from the FHIR standard resources for medicinal products. For more information on FHIR standard resources for medicinal products, see MedicinalProductDefinition.
The extension uses reference data from FHIR with distribution licences. For more information about the distribution license for FHIR resources, see FHIR License and Legal Terms.
Prerequisites
Before you import reference data into your system, ensure that you meet the prerequisites.
Complete the following prerequisite tasks:
•Ensure that you have permission to import reference data.
•Install Python version 3 or later on your machine.
•To verify whether the cURL library files are pre-installed and to check the cURL library version, run the following command from a command prompt:
curl --version
Note: If cURL isn't available in your operating system, ensure that you install it.
You can download the cURL library for your operating system from the cURL website:
http://curl.haxx.se/download.html
Importing the reference data
To import all the reference data in bulk, run the Python script.
1Open a command prompt, and navigate to the following directory: