Search found 232 matches

by EPO / PATSTAT Support
Wed May 16, 2018 11:19 am
Forum: PATSTAT Product Line
Topic: Impact of Legal Event
Replies: 2
Views: 4927

Re: Impact of Legal Event / INPADOC data

Hello Leo, somewhere in cyberspace, your question was not picked up. The event_impact indicator (also called influence indicator ) is a remainder inherited from an older grouping system that indicates whether the "impact" was positive or negative from the point of view of the applicant (or owner). H...
by EPO / PATSTAT Support
Tue May 15, 2018 9:20 am
Forum: PATSTAT Product Line
Topic: appln_auth in PATSTAT2017b versus PATSTAT2018a
Replies: 0
Views: 1512

appln_auth in PATSTAT2017b versus PATSTAT2018a

Keep in mind that the domain of the appln_auth attribute has changed. PCT applications will have "WO" in combination with a value in the receiving_office in PATSTAT2018a. This can lead to un-expected results when using "old queries". You might need to adapt them. Take the following query: SELECT dis...
by EPO / PATSTAT Support
Tue May 08, 2018 12:35 pm
Forum: PATSTAT Product Line
Topic: Is it possible to load sql server with the help of Talend application
Replies: 1
Views: 2841

Re: Is it possible to load sql server with the help of Talend application

Hello Sarajohnm
yes, it is possible to do it with Talend, but we can not help you to get the scripts to work.
Our information is that it is best to create the data base and tables outside the Talend tool, and then only use Talend to load the data into the created tables.
by EPO / PATSTAT Support
Tue May 08, 2018 10:49 am
Forum: Linked open EP data/open EP bulk data
Topic: EPO begins publishing linked open data
Replies: 4
Views: 11916

Re: EPO begins publishing linked open data

Dear Frank, You are right: http://www.epo.org/searching-for-patent ... html#tab-1 refers you to a web page, where at the very bottom you will find a link to the User Guide. We did not link directly to the User Guide document because it is managed by a content management system and the document link ...
by EPO / PATSTAT Support
Fri Apr 27, 2018 1:13 pm
Forum: PATSTAT Product Line
Topic: Help with counting backward citation
Replies: 5
Views: 2835

Re: Help with counting backward citation

Hello Angel, the problem with your IPC criteria is that each citing and cited application can have multiple IPC classification codes. So if you want to do this very strict, I fear you will exclude most of the citations. The fact that they are cited, mostly means that there is "some" kind of technica...
by EPO / PATSTAT Support
Wed Apr 25, 2018 10:35 am
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 13
Views: 11253

Re: PATSTAT - ORACLE loading scripts

Many thanks.
:)
by EPO / PATSTAT Support
Tue Apr 24, 2018 11:46 am
Forum: PATSTAT Product Line
Topic: Patents Application and Patents Granted per year (firm level)
Replies: 2
Views: 2198

Re: Patents Application and Patents Granted per year (firm level)

Hello Julia, a count can be fairly easily done with a query similar to the one below. SELECT psn_name, count(distinct((case when appln_filing_year < 1995 then tls201_appln.appln_id end))) as "<1995", count(distinct((case when appln_filing_year = 1995 then tls201_appln.appln_id end))) as "1995", coun...
by EPO / PATSTAT Support
Mon Apr 23, 2018 1:50 pm
Forum: PATSTAT Product Line
Topic: Error message: Query Killed
Replies: 1
Views: 1573

Re: Error message: Query Killed

Hello Pardeep, from a computational point of view, using wildcards alongside words in title and abstract is a nightmare for the back end servers. When a query takes too much time to execute, then it is automatically aborted. That is what is happening here. Searching for '%rhamnolipid% takes longer t...
by EPO / PATSTAT Support
Thu Apr 12, 2018 11:55 am
Forum: PATSTAT Product Line
Topic: Upcoming PATSTAT 2018 spring release
Replies: 0
Views: 1473

Upcoming PATSTAT 2018 spring release

Dear PATSTAT user, we would like to inform you that we are currently uploading the new PATSTAT 2018 spring release. If everything goes as planned, you should receive next week an e-mail informing you on the effective date the PATSTAT raw data files will be available on the download platform. The lin...