Test1

From E-fileWiki
Revision as of 09:41, 18 December 2019 by User (talk | contribs)
Jump to navigation Jump to search

Introduction

Please be informed that we are working on a new e-file version of the Static Data Management (SDM) application that will be delivered in the first quarter of 2020.

This modernized e-file version will introduce a new design and improved ergonomics for a better user experience.

Please find below our Before - After User Guide where we will explain all important changes.



Select Test or Production environment

Production environment : https://www.e-file.lu/e-file/

Homologation environment (Test) : https://homologation.e-file.lu/e-file/



E-file login

Enter your e-file login credentials (user name and password) and click the ACCESS button.

BeforAfterLogin.png

IMPORTANT: If you do not have an e-file user account, you might contact your e-file administrator of your company.

=>for more detailed information please click the link e-file Administration



Launchpad

The e-file launchpad opens.

Click on the Static Data Management icon.

3Launchpad.png



Select template - Before

The Export screen opens.

3BeforeServiceSelection.png

BeforePoint1.png Open the drop-down list to select the SERVICE



Select template - After

5After SelectTemplate.png

AfterPoint1.png Click on the arrow highlighted in yellow in the top left hand corner of the page to open the drop-down list to select the TEMPLATE AfterPoint2.png



Filter functions - Before

2Before FilterFunctions.png

BeforePoint1.png Click on the FILTER button on the left side of the screen. A window opens where you can specify your search criteria.

BeforePoint2.png Narrow your search criteria by selecting the PROMOTER/LIBRARY OWNER, FUNDS, SUB-FUND, SHARE CLASS.

BeforePrint3.png Narrow your search criteria by selecting the STATUS of your instrument (e.g. active and public).

BeforePrint4.png RESET button to clear all fields and start a new search.

BeforePrint5.png SEARCH button to start the search.

BeforePrint6.png EXPAND/COLLAPSE button to display the whole fund tree (fund, sub-funds and share classes) (EXPAND) or to display only the fund level (COLLAPSE).

BeforePrint7.png Narrow your search criteria by entering the ISIN, CSSF CODE or INTERNAL CODE in the appropriate search field.

BeforePrint8.png REFRESH button to make available the most updated version of the page you are viewing.

BeforePrint9.png Specify your display options: SHOW SELECTED instruments, SELECT ALL instruments, UNCHECK ALL boxes.

BeforePrint10.png Specify your SELECTION option. STANDARD: each box of the fund tree has to be selected either manually or through the SELECT ALL button. BeforePrint11.png SPREAD: the checked box of the fund will be automatically spread to the whole fund tree.

BeforePrint12.png EXPORT button: all selected instruments (with checked boxes) will be exported in the file.



Filter functions - After

2AfterSDMExport.png

AfterPoint1.png Click on the FILTER button AfterSDMFilter.png on the right side of the screen. A toolbar (highlighted in yellow) opens where you can narrow your search options by specifying the AfterPoint2.png STATUS of the instrument (e.g. active and public).

AfterPoint3.png Click inside the toolbar highlighted in yellow. A drop-down list DATA FILTERS pops up where you can narrow your search criteria by selecting e.g. ISIN, CSSF CODE. Enter your ISIN, CSSF CODE in the dedicated search field (3a, 3b) and

AfterPoint4.png Press the SEARCH button or press ENTER.

AfterPoint5.png Press the RESET button AfterSDMResetButton.png to clear all fields and reset filters.

AfterPoint6.png If the SELECT ALL box is checked, all instruments of all management companies that are linked in our database to the ACTOR are selected.

AfterPoint7.png Display options

If the SHOW ONLY SELECTED button is green, only the selected instruments are displayed on the screen.
If the EXPAND ALL button is green, the whole tree structure (fund, sub-fund, share class) of the instrument is displayed.
If the SPREAD SELECTION TO RELATED INSTRUMENTS button is green and you select an instrument at fund level, the whole tree structure of the fund will be automatically selected.

AfterPoint8.png If you press the EXPORT button, all selected instruments with checked boxes will be exported in the file.



Export a file - Before

2BeforeSDMExport.png

Press the EXPORT button.

BeforePoint1.png A message on the top of the screen informs you that Currently 1 report(s) is generated.

BeforePoint2.png Once the file is generated, a window pops up indicating The following report has been generated. Press the OK button to open the file.



Export a file - After

2AfterSDMEportFDF.png

AfterPoint1.png Press the EXPORT button

AfterPoint2.png The red notification indicates that one file is being generated or has been generated.

AfterPoint3.png Once that file is generated, a window pops up indicating The following report was generated.

AfterPoint4.png Open the file that is available at the bottom of the page.



Import a file - Before

3BeforeSDMImport.png

BeforePoint1.png Open the IMPORT tab on the top of the screen.

BeforePoint2.png Select the SERVICE.

BeforePrint3.png Press the button ADD a FILE and select the file you want to import.

BeforePrint4.png Press the IMPORT button.

BeforePrint5.png A window REQUEST FOR UPDATE WITHIN THE FUNDSQUARE STATIC DATA REFERENTIAL pops up. Complete the fields and press the VALIDATE button.

BeforePrint6.png A window opens indicating that Your document has been successfully uploaded. Within 72 hours you will receive a confirmation on its processing.



Import a file - After

3AfterSDMImport.png

AfterPoint1.png Press the FLOW-CHART button AfterSDMFlowChartButton.png. A small window pops up with two options: EXPORT and IMPORT. Select IMPORT.

AfterPoint2.png You have two options to upload your file:

- either you BROWSE your file system and select the file you want to upload
- or you DRAG & DROP your file directly onto the appropriate area AfterSDMDragDrop.png
NEW: Please be informed that new features have been added to the new e-file version of the Static Data Management application. You have now the possibility to upload several files at the same time.
In our example we uploaded two files:
ABC_2019_12_17_FDF.xlsx (cf. 2b)
XYZ_2019_12_17_FDF.xlsx (cf. 2a)

AfterPoint3.png You have two options to add the mandatory parameters TEMPLATE, ACTION, COMMENT

- either you select each parameter for each single file
- or you set all parameters via the SET BULK PARAMETERS AfterPoint4.png funcionality cf. screen below


VERY IMPORTANT INFORMATION

Please ensure that you always follow the Fundsquare naming convention of the templates. The respective acronyms at the end of the file name are mandatory and they have to be preceded by an underscore. Please note that only .xlsx files are allowed to be imported.

FDF template: nnnnnnn_FDF.xlsx

MIFID template: nnnnnnn_MIFID.xlsx

PRIIPS template: nnnnnnn_PRIIPS.xlsx





Set bulk parameters

2AfterSDMBulkImport.png

AfterPoint1.png If you check the SELECT ALL box and complete all mandatory fields in this sections, all mandatory fields of the two files we imported, will be populated automatically with the same parameters.

AfterPoint2.png Press the VALIDATE IMPORT PARAMETERS button.



Import confirmation

NewSDM.png

AfterPoint1.png Press the IMPORT DATA button.

AfterPoint2.png A window pops up indicating Your documents were received and

AfterPoint3.png another window pops up confirming that the import was successful.

AfterPoint4.png The red notification with number 2 inside, shows you that 2 files have been imported.

AfterPoint5.png If you click on the EXCLAMATION MARK, a drop down list with all imported files opens.


Furthermore, please be informed, that you will receive a notification by email with detailed information on your files you imported.

ConfirmationMail.png



How to use FSQ IDs in the Fundamental Data Form (FDF)

In the following we would like to explain you how to use Fundsquare's internal identification numbers of instruments which are available in column 45, 46, 47 of the Fundamental Data Form (Id Fund, Id Sub-Fund, Id Share-Class).

1 FSQ ID FDF.png


(1) Modification of an instrument

If you modify an instrument the three FSQ Id must not be changed under no circomstances.

For example, if you want to change a Sub-fund name, the new name must be reported in the appropriate cell. DO NOT CHANGE the FSQ IDs.


(2) Closure of an instrument

If you want to close an instrument, the appropriate cells in column 13, 24, 34 have to be completed with the closure date. DO NOT CHANGE the FSQ IDs.