Search found 93 matches

by mkracker
Fri Aug 31, 2018 10:16 am
Forum: Linked open EP data
Topic: Kind of IPC and CPC for patents in LOD
Replies: 1
Views: 4844

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
Topic: Kind of citations in LOD
Replies: 2
Views: 950

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: 1049

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: 1049

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: 980

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: 846

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: 1026

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: 665

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: 683

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...
by mkracker
Fri Oct 27, 2017 11:50 am
Forum: PATSTAT Product Line
Topic: PATSTAT Online version 2.3.4
Replies: 2
Views: 1105

Re: PATSTAT Online version 2.3.4

Dear Björn,

Bad timing! The document you are looking for is right now being replaced by an updated version.

Please try again a little later (today).

Sorry for the inconvenience,
Martin
EPO / PATSTAT