FS - 41222167 - Formatting Referentials Source Data
Description
The user can format their Referentials Source Data in SPORIFY using Excel or CSV.
Procedure
Login to SPORIFY.
Click Referentials on the navigation menu.
Select Source Lists.
Click the Templates button.
There are different versions and formats available:
Standard template:
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
Term Description
Advanced template:
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)
RMS Term ID (map respective source term to SPOR RMS TERM-ID)
Term Name (Mandatory)
Term Short Name
Term Other Name
Term Description
Save the spreadsheet.
Note:
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.
Acceptance Criteria
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.
Related / Alternative Procedure
N/A
GUI Specification
Purpose of these GUI elements.
The purpose of these GUI elements is to enable the user to format their source data using SPORIFY templates.
Mockups and Screenshots
![](../../__attachments/858751652/image-20210908-114012.png?inst-v=5cb0ba68-9758-4e0e-9e70-a685a146f630)
Source Lists screen
![](../../__attachments/858751652/image-20210908-114049.png?inst-v=5cb0ba68-9758-4e0e-9e70-a685a146f630)
Referentials template
GUI Elements
Mockup of GUI Element | Title | Default | Enabled | Type | Data | Description |
---|---|---|---|---|---|---|
![]() | Referentials | N/A | Always | Menu item | String | Reveals Referentials sub-menu item when clicked |
![]() | Source Lists | N/A | Always | Menu item | String | Navigates to the Referentials Source Lists screen |
Available Actions And Commands
Mockup of GUI Element | Title | Shortcut | Enabled | Type | Role/Permission | Action | Tooltip | Audit Trail |
---|---|---|---|---|---|---|---|---|
![]() | Templates | N/A | Always | Button | Referentials - Source Lists | Brings up the options: CSV and Excel | N/A | No |
Related Documentation and Sources
N/A