Search found 119 matches
- Wed Nov 18, 2015 10:14 pm
- Forum: PATSTAT Product Line
- Topic: Patstat 2015b - worst so far
- Replies: 2
- Views: 2125
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...
- 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: 2904
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...
- Thu Sep 03, 2015 3:28 pm
- Forum: PATSTAT Product Line
- Topic: Missing person address in Patstat online?
- Replies: 2
- Views: 2141
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...
- Wed Jul 15, 2015 4:37 pm
- Forum: PATSTAT Product Line
- Topic: "Meta strings" in Abstract Table TLS203
- Replies: 1
- Views: 1508
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....
- Tue Jul 07, 2015 10:35 am
- Forum: PATSTAT Product Line
- Topic: Cannot download result table_internal download error
- Replies: 4
- Views: 2182
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.
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.
- Sun Jun 28, 2015 1:44 pm
- Forum: PATSTAT Product Line
- Topic: Cannot download result table_internal download error
- Replies: 4
- Views: 2182
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.
- Wed Jun 17, 2015 12:19 pm
- Forum: PATSTAT Product Line
- Topic: question about join on multiple column
- Replies: 1
- Views: 1345
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...
- Tue Jun 16, 2015 7:29 am
- Forum: PATSTAT Product Line
- Topic: Questions regarding error message and citation query
- Replies: 1
- Views: 1593
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...
- Mon Jun 15, 2015 9:32 am
- Forum: PATSTAT Product Line
- Topic: Question about DATA CATALOG PATSTAT
- Replies: 3
- Views: 2456
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...
- Wed Jun 10, 2015 7:27 am
- Forum: PATSTAT Product Line
- Topic: Unavailability of PATSTAT Online May 26th - June 8th 2015
- Replies: 4
- Views: 2667
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
Martin Kracker / EPO PATSTAT