[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] Antwort: Red and Publish Table



CAUTION: This e-mail originated outside the University of Southampton.

Hi James,

great work, thank you!

We added R&P contract information to our Journal Database JDB just very recently.
Example for a record: https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.jdb.uzh.ch%2Fid%2Feprint%2F36085%2F&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324852401%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=MfKZ0Um50RoHMk9rL99LLf51Wu4X5CT00TNhPUPyyCw%3D&reserved=0 (see at bottom of page).

Also, in our repository ZORA, we use a script that uses DOI / article title / contract year list to match the R & P contract data in JDB and add it to the repository record. This information also goes into our recently built Open Access Monitor (will be publicly accessible in June, see https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftube.switch.ch%2Fvideos%2FGzzsVOcMbU&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324852401%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=wnUZEW8ewh%2FuhYGLclDNA%2FIQIl0BMk1ZsuFOG8CiT7A%3D&reserved=0, demo starts at 9'09'').
The script has found some interesting things - for about 10% of the 2020 articles, the PDF was missing in the repo. For another 15% of the list, the repo item was completely missing. Requires workup by a librarian and also better information of the researchers / submitters will be necessary (R&P contracts are still very new at University of Zurich).

The missing puzzle piece will be a lookup component in the upload section of the repository that tells the submitter: "Hey, there is a R&P contract available for this journal. Please check if article is covered and if you can upload the published PDF." Your database would be of great value for this (at least for UK libraries).

Cheers,

Martin


[Inactive hide details for "James Kerwin via Eprints-tech" ---13/05/2021 16:14:13---CAUTION: This e-mail originated outside the]"James Kerwin via Eprints-tech" ---13/05/2021 16:14:13---CAUTION: This e-mail originated outside the University of Southampton. Hi All,

Von: "James Kerwin via Eprints-tech" <eprints-tech at ecs.soton.ac.uk>
An: eprints-tech at ecs.soton.ac.uk
Datum: 13/05/2021 16:14
Betreff: [EP-tech] Red and Publish Table
Gesendet von: <eprints-tech-bounces at ecs.soton.ac.uk>

________________________________



CAUTION: This e-mail originated outside the University of Southampton.
Hi All,

For once I offer something instead of asking for something.

I was tasked with gathering all of the journal info for those journals that are part of "read and publish" deals and create some sort of searchable table.

Here it is:

https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flivrepository.liverpool.ac.uk%2Fpublishers.html&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324852401%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=1nSW3sGQ6DuzeICbdBIOkgvDVILW93skjU84zzjH7TE%3D&amp;reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flivrepository.liverpool.ac.uk%2Fpublishers.html&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324862396%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=AD2X0mKXZMuXRhCBbzd5zaj3B0mNkNfDanrgs7EAoRY%3D&amp;reserved=0>

The hardest part, by far, has been the gathering of data. Lots of mini web scrapers etc. and far too much manual checking. To save somebody else the effort in future, the data I've found so far is here:

JSON: https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flivrepository.liverpool.ac.uk%2Fjson%2Freformatted_json.txt&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324862396%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=SWEhgohdzFzESjTa9KD3xY13nfbLZY9cyJvYlT0QoDk%3D&amp;reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flivrepository.liverpool.ac.uk%2Fjson%2Freformatted_json.txt&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324862396%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=SWEhgohdzFzESjTa9KD3xY13nfbLZY9cyJvYlT0QoDk%3D&amp;reserved=0>
Tab Delimited (e.g. open in excel if you like): https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flivrepository.liverpool.ac.uk%2Fjson%2Freformatted.txt&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324862396%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=TXFRLRO%2FKokkcERIV%2FsEOqZMNxE2bsJ6906McefhFWc%3D&amp;reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flivrepository.liverpool.ac.uk%2Fjson%2Freformatted.txt&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324862396%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=TXFRLRO%2FKokkcERIV%2FsEOqZMNxE2bsJ6906McefhFWc%3D&amp;reserved=0>

I used this to create the table:

https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdatatables.net%2Fexamples%2Fdata_sources%2Fajax.html&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324862396%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=7fbZlIIkwBkn3Q1n7qlx3koU7VuwTA6omcmeNK16xQo%3D&amp;reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdatatables.net%2Fexamples%2Fdata_sources%2Fajax.html&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324862396%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=7fbZlIIkwBkn3Q1n7qlx3koU7VuwTA6omcmeNK16xQo%3D&amp;reserved=0>

Specifically using Ajax/JSON to store/access the table data.

This comes with no guarantee that the data is correct, but most of it is. If anybody wants to try making this and needs any help, let me know, although I anticipate this would be a breeze for many members on the list.

Thanks,
James*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324872390%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=FkVbwVwsQzs8a97ygEnPnTasY%2Bb1NniN9oSo39i5p98%3D&amp;reserved=0
*** EPrints community wiki: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324872390%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=cNDZBE0%2F7MKXhKPlv37TrJgcKj2QP7sazMv2Tk0aeHg%3D&amp;reserved=0

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20210514/21d4dc37/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif
Size: 105 bytes
Desc: not available
Url : http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20210514/21d4dc37/attachment-0001.gif