Create Microsoft Excel upload and download request
Create a Microsoft Excel upload and download request to upload and download the records from and into the Digital resilience third-party registers for auditing purposes.
Before you begin
Role required: sn_oper_res.admin
About this task
Use the Excel download/upload requests module in Digital resilience third-party registers to export and import the records in Microsoft Excel format. The European Union auditors and regulators can download these records for audit and reviewing purposes and take appropriate actions.
Procedure
- Navigate to Workspaces > Operational Resilience Workspace > Digital resilience third-party registers > Excel download/upload requests.
-
Select New.
The Create New Excel download/upload request form is displayed.
-
On the form, fill in the fields.
For more information, see Create New Excel download/upload request form.
- Select Save.
-
To create a download request, perform the following steps.
- In the Short description field, add information on the request.
- In the Request type field, select the request type as Download.
- In the Type field, select the type of the download, for example, downloading the Third-party information register record.
-
Enter additional details on the request form.
Enter details such as the name of the entity who is downloading the file, (you can provide the legal entity name), recipient to whom you are submitting the file, for example, "ACME authority", date for downloading the file, and so on.
-
Select Save.
Once saved, you can choose which contract you want to download.
-
Select the contract from the list and select Export info register.
-
To download the templates on the Upload request page, select Download template.
When you select the request type as Upload and the type as Assessment, the Download template button is displayed on the form.
After downloading the templates to add options on the reference fields, the upload templates are updated to a dynamic format with drop-downs for choice and reference fields, rather than hard-coding the values.
The dynamic templates automatically handle translations for headers and reference field options. They fetch these elements in real-time, ensuring they remain up-to-date without the need for manual updates. The default template stays up-to-date because the options are generated dynamically.
-
Add name for the Microsoft Excel file and select Save.
It generates a Microsoft Excel sheet that you can submit directly to your regulatory authority. The file strictly adheres to the format of the template issued by the regulatory authority and includes all necessary details for reporting your third-party engagements.
Starting with version 20.x.x of Digital Operational Resilience Management, you can see choice or reference values in the downloaded Microsoft Excel files. For example, Departments can be created in the system as 'Research and Development'. When the functions are downloaded, department values are displayed as options in the Microsoft Excel template for selection. The template includes drop-down lists for departments, business units, and other yes or no questions (as seen in the Branch template). Additional drop-downs are added for countries, currencies, etc.
The application also handles translations for meta data, including headers and drop-down options.
Ensure that no duplicate records are present after downloading data for Legal entities, Functions, etc. When downloading the template, ensure that there are no duplicate Third party rows. For example, creating one DORA Third party and two DORA entities, then creating DORA contracts for the same vendor using the same entity, result in only one Third party row in the downloaded template and not two duplicate rows. You can add new entities and enter their LEI (even if not in the drop-down list) in the downloaded contract file without needing to download the contract records again. You can upload the modified contract records back to the application.
-
To edit the request, select the record from the list and select Edit.
Step Description Update the fields Edit the fields as desired. Select Update. Update the record. -
To export the record, select Export.
Step Description Select File Type. File type selected for the export. Available choices are: - Excel
- CSV
- JSON
Select Delivery Type. Delivery type selected for the export. Available choices are: - Download
Select Export. Action to export the record.