Support for automation

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

Rachie
Posts: 14
Joined: Mon Nov 16, 2015 2:13 am

Support for automation

Post by Rachie » Sun Dec 02, 2018 6:50 pm

For me, retrieving the full patstat dataset is quite a chore. Once I found the download page (this took me fully 30 minutes), there is no easy way to download everything. Clicking on each link in a web browser is both tedious and unreliable. The server only seems to support five or so simultaneous downloads. I'd like to script the downloads, but the actual links are wrapped in layers of javascript. The result is I must sit and babysit the web browser.

Patstat authors, please, please provide a better method of obtaining the full dataset. Something like SFTP would be nice. SFTP is easily scriptable, and is well suited for large unattended downloads.

The bittorrent protocol would be even better. It is inherently well suited for multiple large files, has built-in checksum verification, and greatly reduces the load on your servers.

Also, it would be very useful if the checksums were easier to use. There is absolutely no reason to have separate files for each ZIP file. A single file containing the checksums of all ZIP files is preferable. It would be far simpler, easier to download, and easier to verify. The ideal format is explained in a previous forum post:
patstat-autumn-2016-checksums-5524#p16720

Thanks!


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

Re: Support for automation

Post by EPO / PATSTAT Support » Tue Dec 04, 2018 11:55 am

Hello Rachie,
the download platform is indeed not the most user-friendly one.
The link to the download page is included in the e-mail when we announce the uploading of the new PATSTAT release.
For the purpose of scripting, we offer you to make use of our REST interface. The attached PDF explains detailed steps on how to access and use that platform. I hope you find this useful.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


jarenas
Posts: 1
Joined: Mon Feb 28, 2022 9:12 pm

Re: Support for automation

Post by jarenas » Mon Feb 28, 2022 9:21 pm

Hi,

In case anyone finds this interesting, I wrote a simple Python script to download the last available version of PATSTAT Global. It can easily be modified to download other products. You can find it here: https://github.com/IntelCompH2020/getPATSTAT

Instructions on how to use the script are included in the Readme file of the repo.

Regards,
Jerónimo.


Post Reply