ETSI IPR Reporting Solutions: Difference between revisions
Belchankova (talk | contribs) No edit summary |
Belchankova (talk | contribs) mNo edit summary |
||
| Line 19: | Line 19: | ||
Both files are updated daily. | Both files are updated daily. | ||
[[File:Image csv files .png|left|thumb|702x702px]] | |||
==== Below is an explanation on the columns which are displayed on the "GD-export.csv" tab: ==== | |||
'''IPRD_ID''' = unique IPRD id number. | |||
'''IPR_COMP_ID''' = id of the company provided by the declarer to identify the declarant company. | |||
'''IPRD_REFERENCE''' = reference of the IPR declaration. | |||
'''Reflected Date''' = date/time of ISLD declaration reflection (i.e. it corresponds to the date when the respective declaration was made publicly available via the IPR online database at <nowiki>https://ipr.etsi.org/</nowiki>). | |||
'''IPRD_SIGNATURE_DATE''' = date of the IPR declaration submission to ETSI. | |||
'''IPRD_CREATION_DATE''' = date of the IPR declaration creation. | |||
'''COMP_LEGAL_NAME''' = legal name provided by the declarer to identify the declarant company. | |||
'''GEND_APP_TO_ALL_FLAG''' = whenever the specified option is with reference to all ETSI STANDARDS AND TECHNICAL SPECIFICATIONS. | |||
'''ETPR_ACRONYM''' = acronym of a project included in the disclosure identified by DIPG_ID. | |||
'''Standard''' = work item or Standard number. | |||
'''LICD_REC_CONDI_FLAG''' = whether the declarant is prepared to grant licenses (cf. LICD_DEC_PREP_TO_GRANT_FLAG) and specified the option "undertaking subject to reciprocate conditions". This information is filled in by the declarant, on the first page of the ISLD declaration. | |||
Revision as of 11:19, 23 September 2025
ETSI IPR Reporting Solutions User guides
The following page describes in further detail the reporting features of the ETSI IPR database. All reporting features rely on the public content of the IPR database, which is updated daily.
ETSI is pleased to offer the following IPR Reporting solutions:
- Power BI Report
- IPR CSV export file
- SQL Generic Query access
IPR CSV export file
ETSI provides publicly available IPR reporting data in CSV file format.
A CSV file (Comma-Separated Values) is a simple text file used to store data in a table format. Each line is a row, and commas separate the values (columns). It is often used to move data between programs, like from Excel to a database.
Two separate files are available for download:
- GD-export, containing reporting data regarding General Declarations (GDs);
- ISLD-export, containing reporting data regarding Information Statement and Licencing Declarations (ISLDs).
Both files are updated daily.
Below is an explanation on the columns which are displayed on the "GD-export.csv" tab:
IPRD_ID = unique IPRD id number.
IPR_COMP_ID = id of the company provided by the declarer to identify the declarant company.
IPRD_REFERENCE = reference of the IPR declaration.
Reflected Date = date/time of ISLD declaration reflection (i.e. it corresponds to the date when the respective declaration was made publicly available via the IPR online database at https://ipr.etsi.org/).
IPRD_SIGNATURE_DATE = date of the IPR declaration submission to ETSI.
IPRD_CREATION_DATE = date of the IPR declaration creation.
COMP_LEGAL_NAME = legal name provided by the declarer to identify the declarant company.
GEND_APP_TO_ALL_FLAG = whenever the specified option is with reference to all ETSI STANDARDS AND TECHNICAL SPECIFICATIONS.
ETPR_ACRONYM = acronym of a project included in the disclosure identified by DIPG_ID.
Standard = work item or Standard number.
LICD_REC_CONDI_FLAG = whether the declarant is prepared to grant licenses (cf. LICD_DEC_PREP_TO_GRANT_FLAG) and specified the option "undertaking subject to reciprocate conditions". This information is filled in by the declarant, on the first page of the ISLD declaration.