Search found 119 matches

by mkracker
Wed Nov 18, 2015 10:14 pm
Forum: PATSTAT Product Line
Topic: Patstat 2015b - worst so far
Replies: 2
Views: 2112

Re: Patstat 2015b - worst so far

I'm sorry to hear that you have had troubles loading the data into your database. Among the many tests we do before shipping the disks, we load the csv files again in our DBMS (we are using MS SQL Server v2008). For 2015b we did not encounter any problems. To better understand your problem, could yo...
by mkracker
Sun Nov 01, 2015 10:34 pm
Forum: PATSTAT Product Line
Topic: Selecting a subset of results: equivalent to MySQL's LIMIT?
Replies: 2
Views: 2893

Re: Selecting a subset of results: equivalent to MySQL's LIM

You are right, the easiest way to do this is with the OFFSET ... FETCH clause, which is new in version 2012. Luckily PATSTAT Online is running on MS SQL Server 2012. An ORDER BY clause is mandatory for the OFFSET ... FETCH. So to conform to the syntax, you must append to your query these lines to sk...
by mkracker
Thu Sep 03, 2015 3:28 pm
Forum: PATSTAT Product Line
Topic: Missing person address in Patstat online?
Replies: 2
Views: 2128

Re: Missing person address in Patstat online?

Inventor address data is not available in PATSTAT Online. To facilitate the analysis on a micro-regional level despite missing addresses, we are currently investigating the possibilities of extending PATSTAT data with NUTS3/TL3 and other related information. In the meantime, you could have a look at...
by mkracker
Wed Jul 15, 2015 4:37 pm
Forum: PATSTAT Product Line
Topic: "Meta strings" in Abstract Table TLS203
Replies: 1
Views: 1501

Re: "Meta strings" in Abstract Table TLS203

Dear Jos, Due to a flaw in our source data files (DOCDB backfile of Jan 2015) the abstract text may contain one or more of these strange strings "#CMT#". They do not have any business relevance. I would simply ignore them or - if your research requires it - delete them in your database, e....
by mkracker
Tue Jul 07, 2015 10:35 am
Forum: PATSTAT Product Line
Topic: Cannot download result table_internal download error
Replies: 4
Views: 2177

Re: Cannot download result table_internal download error

Fixed again. Sorry for the inconvenience.

To report the non-working of features of PATSTAT Online, it is best to write directly to epal@epo.org. Posts in the forum might go unnoticed for some time.
by mkracker
Sun Jun 28, 2015 1:44 pm
Forum: PATSTAT Product Line
Topic: Cannot download result table_internal download error
Replies: 4
Views: 2177

Re: Cannot download result table_internal download error

Sorry for responding rather late. Thanks for reporting this issue, which has been fixed the following day. So you should have been able to download the retrieved data since then.
by mkracker
Wed Jun 17, 2015 12:19 pm
Forum: PATSTAT Product Line
Topic: question about join on multiple column
Replies: 1
Views: 1332

Re: question about join on multiple column

Hi liuxia0510, Your query is correct and should run on PATSTAT Online. We will analyse and correct this issue. As a work around, I reformulated your query. IMO it has a simpler structure now, returns the same result and runs on PATSTAT Raw Data as well as on PATSTAT Online. I also added the DISTINCT...
by mkracker
Tue Jun 16, 2015 7:29 am
Forum: PATSTAT Product Line
Topic: Questions regarding error message and citation query
Replies: 1
Views: 1580

Re: Questions regarding error message and citation query

Hi, Your first response is related to PATSTAT Online, the second to PATSTAT Raw Data. So I assume you are using both, right? 1) The error message you noted refers to an internal error of the application. It seems to have occurred first yesterday afternoon, and progressively got worse. Our developers...
by mkracker
Mon Jun 15, 2015 9:32 am
Forum: PATSTAT Product Line
Topic: Question about DATA CATALOG PATSTAT
Replies: 3
Views: 2427

Re: Question about DATA CATALOG PATSTAT

Renee, Thank you for reporting this typo. The paragraph you mentioned in section 4.3.1 in the PATSTAT's Data Catalog should correctly read (Change is marked in red): The advantage of a surrogate key is that it is generally easier and more efficient to identify entities or to join tables with a surro...
by mkracker
Wed Jun 10, 2015 7:27 am
Forum: PATSTAT Product Line
Topic: Unavailability of PATSTAT Online May 26th - June 8th 2015
Replies: 4
Views: 2653

Re: Unavailability of PATSTAT Online May 26th - June 8th 201

Yes, there was a slight delay. Since noon yesterday, PATSTAT Online is up and running again.

Martin Kracker / EPO PATSTAT