Search found 216 matches

by EPO / PATSTAT Support
Tue Mar 20, 2018 4:02 pm
Forum: PATSTAT Product Line
Topic: tls231_part01
Replies: 5
Views: 2965

Re: tls231_part01

Hello Leo,
we will look into that.
I don't think it is a problem with regards to the files, because all our users get the data from the platform, and we haven't heard anything on shifts of data.
But we will investigate it.
by EPO / PATSTAT Support
Mon Mar 05, 2018 5:30 pm
Forum: PATSTAT Product Line
Topic: Retrieving patents with inventors spread across multiple countries
Replies: 3
Views: 2390

Re: Retrieving patents with inventors spread across multiple countries

Hello Rooster25, although it might look like a simple question, doing such aggregation in PATSTAT Online is not straightforward, and the only possibility is to use a sub query that defines applications that have more then 2 inventors from different countries (not being blank neither). On a local ins...
by EPO / PATSTAT Support
Fri Feb 16, 2018 4:21 pm
Forum: PATSTAT Product Line
Topic: Import data from excel - PATSTAT 2017 Autumn
Replies: 2
Views: 2580

Re: Import data from excel - PATSTAT 2017 Autumn

Hello Pardeep, It depends a bit how your publication numbers are formatted. In pure SQL you could use the "IN" function in the WHERE clause. Something like this: select publn_auth, publn_nr, publn_nr_original,ipc_class_symbol from tls211_pat_publn join tls209_appln_ipc on tls211_pat_publn.appln_id =...
by EPO / PATSTAT Support
Mon Feb 12, 2018 9:18 am
Forum: PATSTAT Product Line
Topic: Update of TLS224_appln_cpc?
Replies: 1
Views: 1974

Re: Update of TLS224_appln_cpc?

Hello Jos, The Y02A codes (“Technologies for adaptation to climate change”) have been put on-line in Espacenet and were done in time to make it into the back file for production of the Spring 2018 vesion. It currently gathers 405.011 documents, split as follows: Y02A10/CCA: Adaptation at costal zone...
by EPO / PATSTAT Support
Mon Jan 29, 2018 5:08 pm
Forum: PATSTAT Product Line
Topic: date of party change
Replies: 1
Views: 1850

Re: date of party change

@detlef, most countries do not have legal requirement to register ownership changes after the patent was/is granted. Whatever information that is available will be in the TLS231_INPADOC_LEGAL_EVENT table. Different countries use different codes, so you will need to look for the relevant event_codes ...
by EPO / PATSTAT Support
Mon Jan 29, 2018 4:11 pm
Forum: PATSTAT Product Line
Topic: PATSTAT Register: event codes & text
Replies: 0
Views: 1440

PATSTAT Register: event codes & text

Quite some PATSTAT Register users have asked for extra information on the event codes and event text data which you can find in the reference table REG402_EVENT_TEXT . Factum is that we do not have much extra information then wat is available in the event_text field. But it might look a bit strange ...