Importing reference data assets
After you import Securities 360 assets, 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 |
|---|
Reference Data | The Reference Data folder that contains the lookup code values folders. The 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 based reference data.
|
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.