Format for import of entities

Options
BTh
BTh Contributor
in DSS

I need to import an entity list to make a report in the DSS GUI, but there is no hint as to what the file format should be ! Excel, csv, txt files are not accepted. What is accepted ?

Tagged:

Best Answer

  • Christiaan Meihsl
    Christiaan Meihsl LSEG
    Answer ✓

    @BTh,

    In a nutshell, the CSV format is the following:

    • Line 1 should contain this string: Company Id
    • All following lines should contain the identifier type as first element, followed by a comma (the separator) and the identifier. A 3rd optional element is the user defined ID. Example file contents:
    Company Id
    ORG,12286
    ORG,16364,ThisIsToshiba
    ORG,18228
    ORG,100445905
    RCP,300017142
    ISN,US097023AD79
    RIC,CARR.PA
    FLI,30002184

    For more details and supported identifier types, see page 52 of the DSS 13 user guide.

Answers

Categories