Search found 119 matches

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

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

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

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 Conven...
by mkracker
Fri Nov 03, 2017 8:18 am
Forum: PATSTAT Product Line
Topic: Bad character in tls201_part05.txt
Replies: 0
Views: 1527

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

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

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
by mkracker
Wed Jul 19, 2017 6:58 am
Forum: PATSTAT Product Line
Topic: Cpc classification
Replies: 2
Views: 4431

Re: Cpc classification

Hi, CPC classification codes are always used on the group level, like 'Y02E 20/16', so they contain 11 or more characters. Your code sample cpc_class_symbol in ('y02B', 'y02c', 'y02e') is equivalent to cpc_class_symbol = 'y02B' OR cpc_class_symbol = 'y02c' OR cpc_class_symbol = 'y02e' Strings of dif...
by mkracker
Sat Jun 24, 2017 8:40 am
Forum: PATSTAT Product Line
Topic: Searching for help concerning PATSTAT query
Replies: 7
Views: 4446

Re: Searching for help concerning PATSTAT query

Hi, in your second query of our previous post you are mixing ANDs and ORs. You can do that, but you have to be careful on how SQL interprets this (see https://docs.microsoft.com/en-us/sql/t-sql/language-elements/operator-precedence-transact-sql . Ist much safer to explicitely control the order of ev...
by mkracker
Fri Jun 23, 2017 4:59 pm
Forum: PATSTAT Product Line
Topic: Annual Amount of Pat Family Applications by Country of Origi
Replies: 7
Views: 3766

Re: Annual Amount of Pat Family Applications by Country of O

Hi deef, Your query looks fine. You are counting all families where first filings have an applicant of a certain country published by one of its publications. There is a slight difference to your earlier query, where you counted families which have family members (i.e. applications) whose most recen...
by mkracker
Tue Jun 20, 2017 3:45 pm
Forum: PATSTAT Product Line
Topic: Annual Amount of Pat Family Applications by Country of Origi
Replies: 7
Views: 3766

Re: Annual Amount of Pat Family Applications by Country of O

Hi, 1) To find the applicant who has filed the application in the first place: In PATSTAT Biblio applicants (and likewise inventors) are connected in 2 ways to an application: a) Most commonly, you use the latest applicants (as published). You get them by joining applicants with persons, i.e. TLS201...