Search found 16 matches

by Fr3dY
Mon Jul 08, 2019 8:08 am
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 10
Views: 5405

Re: PATSTAT - ORACLE loading scripts

Hi,

Those scripts are already available in the main post, could you take a look again? :)




Regards,
by Fr3dY
Wed Jun 26, 2019 12:34 pm
Forum: PATSTAT Product Line
Topic: Now available: EP full-text data for analytics
Replies: 2
Views: 3595

Re: Now available: EP full-text data for analytics

Hi,

Where's the free dataset, available for download from Google Cloud Platform? Couldn't find the link, do I have to specifically request it? And what about these Google fees?



Regards,
by Fr3dY
Fri May 17, 2019 3:49 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 10
Views: 5405

Re: PATSTAT - ORACLE loading scripts

Update: Added scripts for PATSTAT 2019 Spring Edition
by Fr3dY
Thu Feb 21, 2019 9:11 am
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 10
Views: 5405

Re: PATSTAT - ORACLE loading scripts

Good Mornings, There is a different way to receive PATSTAT 2018 AUTUMN Edition - Oracle Script , such as e-mail? It is impossible for me to download it from tinyupload for security reasons. The TinyUpload.com site is blocked by our proxy due to its poor reputation. Regards. Hi, Send me a private me...
by Fr3dY
Mon Nov 12, 2018 5:16 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 10
Views: 5405

Re: PATSTAT - ORACLE loading scripts

Update: Added scripts for Patstat 2018 Autumn Edition
by Fr3dY
Wed Sep 19, 2018 9:14 am
Forum: PATSTAT Product Line
Topic: retrieve results of a custom sql query from a database connection
Replies: 3
Views: 1404

Re: retrieve results of a custom sql query from a database connection

Hi Sarah,

I don't have any experience with Talend myself, but this link might help you:
https://help.talend.com/reader/Dx4Xf8yk ... zg9k_R4d6w





Regards,
by Fr3dY
Fri Jun 08, 2018 2:47 pm
Forum: PATSTAT Product Line
Topic: Only 30% person_address available?
Replies: 2
Views: 1179

Re: Only 30% person_address available?

OK, thanks!!
by Fr3dY
Fri May 18, 2018 9:42 am
Forum: PATSTAT Product Line
Topic: Only 30% person_address available?
Replies: 2
Views: 1179

Only 30% person_address available?

Hi, Just wanted to verify if only about 30% of person addresses are available (for RAW data): select count(*) from patstat2018a.tls206_person where psn_sector='INDIVIDUAL' and person_address is not null; 3.653.560 select count(*) from patstat2018a.tls206_person where psn_sector='INDIVIDUAL' and pers...
by Fr3dY
Tue Apr 24, 2018 3:22 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 10
Views: 5405

Re: PATSTAT - ORACLE loading scripts

Update: Added scripts for Patstat 2018 Spring Edition
by Fr3dY
Tue Feb 20, 2018 9:56 am
Forum: PATSTAT Product Line
Topic: Import data from excel - PATSTAT 2017 Autumn
Replies: 2
Views: 1502

Re: Import data from excel - PATSTAT 2017 Autumn

Hi all, I am using PATSTAT 2017 Autumn version. I have a list of publication number kept in excel file and I want to extract IPC codes associated with those publication numbers. But the problem is that this list contains approximate 8000 unique publication numbers. Its very time consuming for me to...