ISTI Open Access

@leonardo.candela@isti.cnr.it

What do you intend with figure, an image?

Otherwise the totals can be obtained through the SOLR API:

curl "https://backend-openportal.isti.cnr.it/solr/PMF_index_isti_shard1_replica1/select?q=date%3A%5B2005+TO+2020%5D&rows=0&wt=json&indent=true&facet=true&facet.field=date&facet.mincount=1&facet.sort=index"

We need to make available a method that returns a JSON that for every year contains a list of pairs "publication type, number of publications".

This method is expected to be used by the forthcoming ISTI website.

Dunno whether the SOLR API are "open" to every client, to me the only client expected to use them should be OpenPortal ... anyway if opening SOLR API to everyone is not harmful we can proceed as you prefer.

The Solr Index Service is not OPEN to every client, but it was configured to be accessible from OpenPortal server, my ip address and some Volpini's machines.

Some months ago I sent to Federico a mail with some preconfigured queries.

I think that a beta version of the ISTI website already performs some queries to the Solr Index.

Hi,

we tried to use the curl command from the machine that hosts the new website (ut6.isti.cnr.it - ip:146.48.80.156) and this is the response:

curl: (7) couldn't connect to host

Giuseppe also tried with my ip address (146.48.84.238) and this is another response:

[1] 12409
[2] 12410
[3] 12411
[4] 12412
[5] 12413
[6] 12414
[7] 12415
curl: (7) Failed to connect to backend-openportal.isti.cnr.it port 443: Nessun instradamento per l'host
facet.sort=index: comando non trovato
facet.mincount=1: comando non trovato
facet.field=date: comando non trovato
[2] Completato rows=0
[3] Completato wt=json
[2] Completato rows=0
[3] Completato wt=json
[4] Completato indent=true
[5] Completato facet=true
[1] Uscita 7 curl https://backend-openportal.isti.cnr.it/solr/PMF_index_isti_shard1_replica1/select?q=date%3A%5B2005+TO+2020%5D
[2] Completato rows=0
[3] Completato wt=json
[4] Completato indent=true
[5] Completato facet=true
[6]- Uscita 127 facet.field=date
[7]+ Uscita 127 facet.mincount=1

@andrea.dellamico@isti.cnr.it Can you verify which addresses can access backend-openportal.isti.cnr.it via HTTPS ?

Access is limited to the web portal, and your desktop IP address (that one should be removed).
I'm going to allow the two IP aaddresses listed in #19414#note-5

To me you can limit the access only to ut6 (146.48.80.156).

Thanks :)

OK, I remembered that we had this kind of discussion in the past, here: #16846. I suppose you changed your mind?

Anonymous wrote:

To me you can limit the access only to ut6 (146.48.80.156).

Done.

Tested from ut6, now it works.

Just one question: the now we have the result of all publications per year.

Is it possible to have the number of publications by typology per year?

Thank you very much in advance

output:
{
"responseHeader":{
"status":0,
"QTime":54,
"params":{
"q":"date:[2005 TO 2020]",
"facet.field":"date",
"indent":"true",
"facet.mincount":"1",
"rows":"0",
"wt":"json",
"facet":"true",
"facet.sort":"index"}},
"response":{"numFound":7597,"start":0,"docs":[]
},
"facet_counts":{
"facet_queries":{},
"facet_fields":{
"date":[
"2005",441,
"2006",514,
"2007",649,
"2008",494,
"2009",454,
"2010",488,
"2011",490,
"2012",441,
"2013",570,
"2014",594,
"2015",570,
"2016",546,
"2017",439,
"2018",399,
"2019",434,
"2020",74]},
"facet_dates":{},
"facet_ranges":{},
"facet_intervals":{},
"facet_heatmaps":{}}}

It is possible using the SOLR facet API, in particular using the facet.pivot parameter.

for example:

curl "https://backend-openportal.isti.cnr.it/solr/PMF_index_isti_shard1_replica1/select?q=date%3A%5B2005+TO+2020%5D&rows=0&wt=json&indent=true&facet=true&facet.pivot=date,type&facet.mincount=1&facet.sort=index"

Hi, thanks for all.

You can see the result here: https://ut6.isti.cnr.it/sitoisti/en/research/publications

Just another question, if possible.

In agreement with the Director, we'd like to insert another tab, containing this graph: https://openportal.isti.cnr.it/statistics/year-rights

It's possible, using the same SOLR service, to have access to the raw data?

Thanks in advice

You can use a similar query, in particular replacing

facet.pivot=date,type

with

facet.pivot=date,rights

The complete url is: https://backend-openportal.isti.cnr.it/solr/PMF_index_isti_shard1_replica1/select?q=date%3A%5B2005+TO+2020%5D&rows=0&wt=json&indent=true&facet=true&facet.pivot=date,rights&facet.mincount=1&facet.sort=index