PATSTAT Online 2020a is now available.

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

EPO / PATSTAT Support
Posts: 230
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

PATSTAT Online 2020a is now available.

Post by EPO / PATSTAT Support » Wed May 13, 2020 8:13 am

The spread of the coronavirus has led to many restrictions and has it made nearly impossible for colleagues and friends to physically meet.
Video conferencing, virtual team meetings, home-working and e-conferencing have become the norm and it is hard to believe that it ever will be business as usual.

At the PATSTAT helpdesk, we received some requests for special data sets from users who do not have access to their usual servers or IT infrastructure anymore because of homeworking restrictions. To accommodate these demands, the EPO has decided to provide all current PATSTAT Global and PATSTAT Register users access to PATSTAT Online for the remainder of 2020.
If you want to make use of this offer, kindly ask your users to send a short e-mail to patstat@epo.org and we will then provide access credentials to PATSTAT Online as soon as possible
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


RudiBekkers
Posts: 4
Joined: Fri Nov 06, 2015 4:59 pm

Re: PATSTAT Online 2020a is now available.

Post by RudiBekkers » Wed May 13, 2020 11:04 am

Hello all,

Very exited to access PATSTAT 2020a!

There is one request I have. EPO does provide the SHA-1 values for the ZIP files it distributes, but after that, there are still several steps of decompression, checking whether you have all files together, and so on. In fact, in the past, I experienced integrity problems when decompressing (blame WINZIP ?!?).

Would it be possible to share SHA values for the set of CSV files? It would allow for checking at the end of the workflow. Also, having this validates that one indeed has the complete set of CVS files.

Ideally, this would be a simple text file with all SHA values, like the below one created with the FCIV utility (here I stopped after 4 files, and ps_2020 is the directory where I had the files). One could then just do a compare between the distributed text file, and the one locally created.


D:\data_ps20s>fciv ps_2020 -sha1
//
// File Checksum Integrity Verifier version 2.05.
//
0577381a99a97daf1082c8881110e861fbf55478 ps_2020\tls201_part01.csv
a5daedd1930abdf28c8dd049b8968edcd3bf743c ps_2020\tls201_part02.csv
951135388c750480dc5485bb50d773a994352788 ps_2020\tls201_part03.csv
a121d447556235e7dd20ee010d699799b1c2fe95 ps_2020\tls202_part01.csv

[etc.]

Thanks and best regards, Rudi Bekkers


mkracker
Posts: 111
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: PATSTAT Online 2020a is now available.

Post by mkracker » Thu May 14, 2020 7:36 am

Dear Rudi,

Thanks for your suggestion. Please find in the attached file the requested check sum data.
SHA512_for_PATSTAT_files.zip
(7.97 KiB) Downloaded 36 times
BTW: I personally use the free 7zip tool (with command line interface) a lot to unzip archives.. Like WinZip, it sometimes has issues, but in some cases it is useful to have options.

Kind regards,
Martin
-------------------------------------------
Martin Kracker / EPO


RudiBekkers
Posts: 4
Joined: Fri Nov 06, 2015 4:59 pm

Re: PATSTAT Online 2020a is now available.

Post by RudiBekkers » Wed Jun 03, 2020 1:50 pm

Dear Martin, thanks a lot for sharing this checksum data.

It would be most useful for me (and others I guess) if EPO would share checksum data for the unpacked (CVS) files (instead of on the in-between ZIP files). This way, any potential problems with compression will show, and one also knows the final set is complete.

I also noted that you shared these in SHA-512 format (which I think is SHA-2 with a hash of 512 bit length. Previously, EPO used SHA-1 for the distribution files on the website. Any reason for this change?

Best, Rudi Bekkers

(PS I indeed recently changed to the 7zip tool, and that seemed to have less problems when unpacking PATSTAT distribution files than my paid copy of WINZIP...)


mkracker
Posts: 111
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: PATSTAT Online 2020a is now available.

Post by mkracker » Wed Jun 03, 2020 2:45 pm

Thank you, Rudi, for this proposal. I will consider in in the next version.

The SHA-1 you mentioned is created automatically by our Bulk Data Platform from which you can download EPO data. But generally, SHA-1 is used less and less. So for additional check sums we will utilize the more future-proof SHA-2 family, specifically the SHA-512 hash function.
-------------------------------------------
Martin Kracker / EPO


Post Reply