Importing reference data assets

After you import the assets for the source systems that you plan to use, import reference data code values in bulk from CSV files into reference data assets.

The following table describes the files and folders in the extracted reference data directory:

File or Folder Name	Description
Healthcare	The folder that contains the code values folder with the name _1.
Life Sciences	The folder that contains the lookup code values folders. Lookup code values are in the following folders: - _1. Contains the parent lookup code values. - _2. Contains the child lookup code values. - Crosswalk. Contains the reference data set crosswalks.
LoadReferenceData.py	Python script to import reference data.

The following table lists the reference data assets and the corresponding code lists, crosswalks, and crosswalk location:

Reference Data Asset	Code List	Crosswalk	Crosswalk Location
AlternateIdType	AlternateIdType-Nppes AlternateIdType	AlternateIdType-Nppes AlternateIdType to Enterprise AlternateIdType	<Extracted extension package>/Reference Data/Life Science/Crosswalk
AlternateNameType	AlternateNameType-Nppes HCO_alternateNameType	AlternateNameType-Nppes HCO_alternateNameType to Enterprise AlternateNameType	<Extracted extension package>/Reference Data/Life Science/Crosswalk
AlternateNameType	AlternateNameType-Nppes HCP_alternateNameType	AlternateNameType-Nppes HCP_alternateNameType to Enterprise AlternateNameType	<Extracted extension package>/Reference Data/Life Science/Crosswalk
IdentifierStatus	IdentifierStatus-Medpro IdentifierStatus	IdentifierStatus-Medpro IdentifierStatus to Enterprise IdentifierStatus	<Extracted extension package>/Reference Data/Life Science/Crosswalk
State	State-Medpro State	State-Medpro State to Enterprise State	<Extracted extension package>/Reference Data/Life Science/Crosswalk
State	State-Nppes State	State-Nppes State to Enterprise State	<Extracted extension package>/Reference Data/Life Science/Crosswalk

To import code values in bulk from CSV files that are available in the extracted reference data directory, run the LoadReferenceData.py Python script.

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:

<Extracted extension package>/Reference Data

2Run the following command:

- On Windows.

python LoadReferenceData.py --podHostName <POD host name>.informaticacloud.com --userName <user name> --password <password> --region <POD region>

- On Linux.

python3 LoadReferenceData.py --podHostName <POD host name>.informaticacloud.com --userName <user name> --password <password> --region <POD region>

The jobs to import reference data code values run.

3To monitor the status of a job, click My Jobs in Reference 360.

The My Jobs page lists the job instances that are currently running, failed, and successfully completed.