The user can format their Referentials Source Data in SPORIFY using Excel or CSV.
Login to SPORIFY.
Click Referentials on the navigation menu.
Select Source Lists.
Click the Templates button.
There are different versions and formats available:
Select CSV or Excel to download the relevant template.
When the template has downloaded, open it and fill in the provided fields.
The presented fields are:
Term Id (Mandatory)
Term Name (Mandatory)
Term Short Name
Term Other Name
RMS Term ID (map respective source term to SPOR RMS TERM-ID)
Save the spreadsheet.
If using Excel and your workbook has multiple worksheets, you will be required to select the required worksheet to import from.
If using CSV, each column of data should be delimited with a comma.
If your column text contains the delimiter character, the text should be wrapped in quotes “” e.g. Capsule, Soft is formatted as “Capsule, Soft” to correctly import the delimiter character.
CSV files should be saved with UTF-8 encoding to preserve special characters.
To succeed, the user must be able to format their source data using a template provided within SPORIFY.
Verify that the user can format their source data via CSV and Excel.
Verify that Term Id and Term Name are mandatory.
Verify that Term Short Name, Term Other Name and Term Description are optional.
Purpose of these GUI elements.
The purpose of these GUI elements is to enable the user to format their source data using SPORIFY templates.
Source Lists screen
Mockup of GUI Element
Reveals Referentials sub-menu item when clicked
Navigates to the Referentials Source Lists screen
Referentials - Source Lists
Brings up the options: CSV and Excel
UC - Referentials
FS - 432046087 - Referentials
FS - 41156625 - Referentials Source Lists
Please note, these errors can depend on your browser setup.
If this problem persists, please contact our support.