Search found 94 matches

by mkracker
Wed Jun 26, 2019 4:26 pm
Forum: PATSTAT Product Line
Topic: Now available: EP full-text data for analytics
Replies: 2
Views: 382

Re: Now available: EP full-text data for analytics

Hi, The data set is open (CC-BY) and free. You do not need to request it. Detailed information is on the product page https://www.epo.org/searching-for-patents/data/bulk-data-sets/text-analytics . The user manual (accessible from bottom of the product page of tab "Getting started") on page 6 describ...
by mkracker
Fri Aug 31, 2018 10:16 am
Forum: Linked open EP data/open EP bulk data
Topic: Kind of IPC and CPC for patents in LOD
Replies: 1
Views: 5633

Re: Kind of IPC and CPC for patents in LOD

The LOD data set contains all IPC and CPC classifications of EP patents. "Inventive" and "Additional" (= non-inventive) classifications are distinguished. IPC and CPC classifications are in the newest version (so e.g. IPC is always the newest version of IPC8) and re-classified (= updated in case the...
by mkracker
Wed Aug 29, 2018 10:57 am
Forum: Linked open EP data/open EP bulk data
Topic: Kind of citations in LOD
Replies: 2
Views: 1771

Re: Kind of citations in LOD

No, the origin of the citation (from search, from examination, opposition, third party observation etc.) is not in the data. However, citations provided by the applicant himself have been excluded from the data, because their value is typically very poor. Consequently, the citations which are left i...
by mkracker
Wed Mar 21, 2018 5:00 pm
Forum: PATSTAT Product Line
Topic: tls231_part01
Replies: 5
Views: 1338

Re: tls231_part01

Hi Leo,

So - in short - the file is corrupted on your USB Memory stick. I suggest you send your email address to the PATSTAT help desk (patstat@epo.org). I will then send you a link from where you can download the missing file.

Sorry for the inconvenience and best regards,
Martin
by mkracker
Wed Mar 21, 2018 8:22 am
Forum: PATSTAT Product Line
Topic: tls231_part01
Replies: 5
Views: 1338

Re: tls231_part01

Hi Leo,

Which version of PATSTAT data are you using? 2017 Autumn Edition?
To check whether the downloading introduced some error:
- After downloading, have you compared the SHA values?
- Or have you tried to download that particular file again?

Best regards,
Martin
by mkracker
Mon Mar 05, 2018 2:57 pm
Forum: PATSTAT Product Line
Topic: Retrieving patents with inventors spread across multiple countries
Replies: 3
Views: 1137

Re: Retrieving patents with inventors spread across multiple countries

PATSTAT Online is a read-only database. You cannot create your own database views (CREATE VIEW ...). To create views, you have to set up your own local database and import PATSTAT data from its CSV files. But in almost all cases you can just work around database views: Here is a query which returns ...
by mkracker
Thu Feb 15, 2018 10:44 am
Forum: PATSTAT Product Line
Topic: PATSTAT 2017 Autumn - text search operators and non full-text Index table error
Replies: 1
Views: 946

Re: PATSTAT 2017 Autumn - text search operators and non full-text Index table error

I suppose you are using PATSTAT Online. PATSTAT Online is powered by MS SQL Server, which is using the T-SQL dialect of SQL. There are some more wildcards than just the %-character. Please see the full Microsoft documentation here: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-tr...
by mkracker
Sat Dec 30, 2017 8:51 pm
Forum: PATSTAT Product Line
Topic: EPO patents designated in single European countries
Replies: 2
Views: 1104

Re: EPO patents designated in single European countries

Dear Carmen, There probably is a misconception about the meaning of "designated states". Article 79 of the European Patent Convention (http://www.epo.org/law-practice/legal-texts/html/epc/2016/e/ar79.html) specifies since late 2000 that "All the Contracting States party to this Convention at the tim...
by mkracker
Fri Nov 03, 2017 8:18 am
Forum: PATSTAT Product Line
Topic: Bad character in tls201_part05.txt
Replies: 0
Views: 731

Bad character in tls201_part05.txt

Dear subscriber of PATSTAT Biblio, In case you have downloaded the files of the 2017 Autumn Edition before the noon of Nov 2nd, 2017: File tls201_part05.txt contains a bad character (marked red in the middle line below) in one of its lines, which may cause issues when you import the data into your d...
by mkracker
Wed Nov 01, 2017 5:32 pm
Forum: PATSTAT Product Line
Topic: NPL_BIBLIO value may be longer than expected
Replies: 0
Views: 760

NPL_BIBLIO value may be longer than expected

Please note that in the current 2017 Autumn Edition values in attribute NPL_BIBLIO of table TLS214_NPL_PUBLN can be up to 3 800 characters long. If your DB schema is not prepared to hold such longs strings, then you might experience problems when loading the data into your database. To avoid similar...