tag:blogger.com,1999:blog-91316305742657019642024-03-05T02:34:25.960-05:00RefinePro Knowledge Base for OpenRefineBuild over time, the RefinePro knowledge base list tutorials, how to and tips for OpenRefine (formerly Google Refine)magdmartinhttp://www.blogger.com/profile/02680536297206242029noreply@blogger.comBlogger142125tag:blogger.com,1999:blog-9131630574265701964.post-90384143898626648842023-06-06T21:06:00.002-04:002023-06-06T21:06:20.260-04:00OpenRefine May 2023 Review<p><span style="font-family: arial;"><span>We wish you a very happy June! </span><span>This month, we decided to share the most relevant and helpful OpenRefine May 2023 community announcement, videos, and academic publications with you. Read on to discover them.</span></span></p><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-weight: normal;"><span style="font-family: arial; font-size: small;"></span></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-weight: normal;"><span style="font-family: arial; font-size: small;"></span></span></h3><h3><br /></h3><div><span style="color: #3b3f44;"><span style="font-family: arial;"><b>English Videos:</b></span></span></div><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><ul style="background-color: white; text-align: center;"><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Segmenting categorical cell by OpenRefine"}" style="font-weight: 400; text-align: center;"><a href="https://www.youtube.com/watch?v=2iLp1z1_SJ4" target="_blank"><span style="font-family: arial; font-size: small;">Segmenting categorical cell by OpenRefine</span></a></span></li><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Segmenting categorical cell by OpenRefine"}" style="font-weight: 400; text-align: center;"><a href="https://www.youtube.com/watch?v=2Wxrdn7yIFw" target="_blank"><span style="font-family: arial; font-size: small;">Querying Art History Data on the Web (5/7): Modelling Data with OpenRefine</span></a></span></li><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Segmenting categorical cell by OpenRefine"}" style="font-weight: 400; text-align: center;"><a href="https://www.youtube.com/watch?v=1Nu_CQWmpYA" target="_blank"><span style="font-family: arial; font-size: small;">R : Best way to parse a big and intricated Json file with OpenRefine (or R)</span></a></span></li><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Segmenting categorical cell by OpenRefine"}" style="font-weight: 400; text-align: center;"><a href="https://www.youtube.com/watch?v=2iLp1z1_SJ44" target="_blank"><span style="font-family: arial; font-size: small;">Segmenting categorical cell by OpenRefine</span></a></span></li><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Segmenting categorical cell by OpenRefine"}" style="font-weight: 400; text-align: center;"><a href="https://www.youtube.com/watch?v=fRBRUpvS5Cs" target="_blank"><span style="font-family: arial; font-size: small;">Converting JSON to Excel in OpenRefine</span></a></span></li></ul><div><span style="font-family: arial; font-size: small;">Spanish Video:</span></div><div><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"¿Cómo subir imágenes con OpenRefine?"}" style="font-weight: 400; text-align: center;"><a href="https://www.youtube.com/watch?v=b8cpE7kWUiY" target="_blank"><span style="font-family: arial; font-size: small;">¿Cómo subir imágenes con OpenRefine?</span></a></span></li></ul></div></h3><h3 style="background-color: white; color: #3b3f44;"><span style="font-family: arial; font-size: small;">Academic Publications:</span></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><div style="background-color: white;"><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Data Wrangling from Socio-Academic Web-Space: Designing a Meta Model\""}" style="font-weight: 400; text-align: center;"><a href="https://srels.org/index.php/sjim/article/view/170971" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "Data Wrangling from Socio-Academic Web-Space: Designing a Meta Model"</span></a></span></li></ul><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Automatic Indexing for Agriculture: Designing a Framework by Deploying Agrovoc, Agris and Annif\""}" style="font-weight: 400;"><a href="https://www.srels.org/index.php/sjim/article/view/170966" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "Automatic Indexing for Agriculture: Designing a Framework by Deploying Agrovoc, Agris and Annif"</span></a></span></li></ul><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Digital handlungsfähige Erinnerungskultur - Neue Ansätze für forschendes Lernen vor Ort\""}" style="font-weight: 400; text-align: center;"><a href="https://opus4.kobv.de/opus4-bib-info/frontdoor/index/index/docId/18420" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "Digital handlungsfähige Erinnerungskultur - Neue Ansätze für forschendes Lernen vor Ort"</span></a></span></li></ul><div><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Digital handlungsfähige Erinnerungskultur - Neue Ansätze für forschendes Lernen vor Ort\""}" style="font-weight: 400; text-align: center;"><a href="https://opus4.kobv.de/opus4-bib-info/frontdoor/index/index/docId/18434" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "SkoHub - Das Potential kontrollierter Vokabulare nutzen"</span></a></span></li></ul></div><div><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Digital handlungsfähige Erinnerungskultur - Neue Ansätze für forschendes Lernen vor Ort\""}" style="font-weight: 400; text-align: center;"><a href="https://bibliothecae.unibo.it/article/view/16785" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "The application of Linked Open Data to the creation of book numbers"</span></a></span></li></ul></div></div></h3></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-35094302691269093912023-04-28T14:14:00.000-04:002023-04-30T06:11:55.751-04:00OpenRefine April 2023 Review<p><span style="font-family: arial;"><span>We wish you a very happy May!</span><span> </span><span>This month, we decided to share the most relevant and helpful OpenRefine April 2023 release, videos, and academic publications with you. Read on to discover them.</span></span></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both;"><div class="separator" style="clear: both;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD5wXF-KcnILpglG67A6t1nH8LqIHTfJyBlGt5QXZ-qNXwi7wRw_9v1etLQxL2siZ9nA6dfmqBXZURdMzgQBZNU6DuKOSU0a4ulutoDtE0lfk8pzMcky_l8rKPOQh6-CL69XbZXVNVcTguJTz-Lb-E_fiako0_CxtNvYNCqtHJ_ONbWFfn_wVTsF1Z/s1024/April%202023%20Review.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD5wXF-KcnILpglG67A6t1nH8LqIHTfJyBlGt5QXZ-qNXwi7wRw_9v1etLQxL2siZ9nA6dfmqBXZURdMzgQBZNU6DuKOSU0a4ulutoDtE0lfk8pzMcky_l8rKPOQh6-CL69XbZXVNVcTguJTz-Lb-E_fiako0_CxtNvYNCqtHJ_ONbWFfn_wVTsF1Z/s320/April%202023%20Review.jpg" width="320" /></a></div><span style="font-family: arial;"><br /></span></div></div></div><div class="separator" style="clear: both; text-align: center;"><span style="background-color: white; text-align: left;"><span style="font-family: arial;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></span></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-weight: normal;"><span style="font-family: arial; font-size: small;"></span></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-weight: normal;"><span style="font-family: arial; font-size: small;"></span></span></h3><h3><span style="color: #0f1419; font-family: arial;"><span style="background-color: white; font-size: small; white-space: pre-wrap;">Release</span></span></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><span style="font-family: arial;"><span style="font-family: arial;"><span style="background-color: white; font-size: small; font-weight: normal;"><ul><li><span style="color: #1f2328;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.7.2#sq_hcparldktw" target="_blank">OpenRefine v3.7.2</a> by wetneb</span></li></ul><div></div></span></span></span></h3><h3><span style="color: #0f1419; font-family: arial;"><span style="background-color: rgba(0, 0, 0, 0.008); font-size: small; white-space: pre-wrap;">Videos</span></span></h3><div><span style="color: #3b3f44;"><span style="font-family: arial;"><b>English Video:</b></span></span></div><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><ul style="background-color: white; text-align: center;"><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Using OpenRefine t find duplicates and errors"}" style="font-weight: normal; text-align: center;"><a href="https://www.youtube.com/watch?v=pcuF8zMDEaw&pp=ygUKb3BlbnJlZmluZQ%3D%3D&ab_channel=salgo60" target="_blank"><span style="font-family: arial; font-size: small;">Using OpenRefine to find duplicates and errors</span></a></span></li></ul><div><span style="font-family: arial; font-size: small;">Russian Video:</span></div><div><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Урок по основным функциям OpenRefine"}" style="font-weight: normal; text-align: center;"><a href="https://www.youtube.com/watch?v=Mj75Doxus-g" target="_blank"><span style="font-family: arial; font-size: small;">Урок по основным функциям OpenRefine</span></a></span></li></ul></div><span style="font-family: arial; font-size: small;">Indonesian Video:</span></h3><div><ul><li><span data-sheets-userformat="{"2":1049537,"3":{"1":0},"9":1,"10":1,"11":4,"12":0,"23":1}" data-sheets-value="{"1":2,"2":"Tools-tools dalam Pemrosesan Big Data (Hadoop, Openrefine, Gephi, Deck.gl, Kepler.gl)"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=qabrq7rpthk" target="_blank"><span style="font-family: arial;">Tools-tools dalam Pemrosesan Big Data (Hadoop, Openrefine, Gephi, Deck.gl, Kepler.gl)</span></a></span></li></ul></div><h3 style="background-color: white; color: #3b3f44;"><span style="font-family: arial; font-size: small;">Academic Publications:</span></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><div style="background-color: white;"><ul><li><span style="font-family: arial; font-size: small; font-weight: normal;"><a href="https://jurnal.biounwir.ac.id/index.php/mangiferaedu/article/view/159" target="_blank">Use of OpenRefine in "Apis Mellifera Animal Study in a Role Perspective Using the Bibliometrix Tools (SLNA Method Application)"</a><br /><br /></span></li><li><a href="https://www.erem.ktu.lt/index.php/erem/article/view/32424" target="_blank"><span style="font-family: arial; font-size: small; font-weight: normal;">Use of OpenRefine in "Research Development on Carbon Capture, Utilization and Storage as a Climate Change Mitigation Technology"</span></a><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Αξιολόγηση Ελλήνων ερευνητών με τη χρήση βιβλιομετρικών δεδομένων από τις βάσεις αναφορών Google Scholar και Scopus\""}" style="font-size: 10pt; font-weight: normal; text-align: center;"></span></li></ul></div></h3></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-78404023637092808892023-03-31T15:09:00.000-04:002023-04-03T15:20:52.374-04:00OpenRefine March 2023 Review<p><span style="font-family: arial;"><span>Happy April to you all</span><span>!</span><span> </span><span>This month, we decided to share the most relevant and helpful OpenRefine March 2023 releases, tutorials, videos, and academic publications with you. Read on to discover them.</span></span></p><p></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both;"><div class="separator" style="clear: both;"><span style="font-family: arial;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbj7Skfkw9tR8xa0gcMwWxgPiN328vchhr09TChl2WddCKHLigyvRiWNzMnFQTFB_qYp-F8HbN_OOKurEo2rbTMCqW2yn9mpHPHFmLd-JfzE4zVIE36_RXu7x1IAw9XFu31y0XUlrvSTmTJBfCuRY8fv2LSNcJa0bLR2eeD_6xlWjrowRNsCOuv77d/s1024/March%202023%20Review.jpg" style="font-family: "Times New Roman"; margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="187" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbj7Skfkw9tR8xa0gcMwWxgPiN328vchhr09TChl2WddCKHLigyvRiWNzMnFQTFB_qYp-F8HbN_OOKurEo2rbTMCqW2yn9mpHPHFmLd-JfzE4zVIE36_RXu7x1IAw9XFu31y0XUlrvSTmTJBfCuRY8fv2LSNcJa0bLR2eeD_6xlWjrowRNsCOuv77d/w374-h187/March%202023%20Review.jpg" width="374" /></a></span></div><div class="separator" style="clear: both;"><br /></div></div></div><div class="separator" style="clear: both; text-align: center;"><span style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></span></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-weight: normal;"><span style="font-family: arial; font-size: small;"></span></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-weight: normal;"><span style="font-family: arial; font-size: small;"></span></span></h3><h3><span style="color: #0f1419; font-family: arial;"><span style="background-color: white; white-space: pre-wrap;">Releases </span></span></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><span style="font-family: arial;"><span style="font-family: arial;"><span style="background-color: white;"><ul style="color: black; font-weight: normal; white-space: normal;"><li><span style="color: #0f1419; font-size: x-small; white-space: pre-wrap;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.7.1#sq_hbv1fk1ytg" target="_blank">OpenRefine v3.7.1</a></span></li><li><span style="color: #0f1419; font-size: x-small; white-space: pre-wrap;"><a href="https://github.com/codeforkjeff/conciliator/releases/tag/v3.1.1#sq_hc9jziwszt" target="_blank">Conciliator: v3.1.1</a></span></li></ul><div><span style="font-size: medium;">Community Announcement</span></div><div style="font-weight: normal;"><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"OpenRefine is looking for a part time project manager\r"}" style="font-size: 10pt; text-align: center;"><a href="https://openrefine.org/blog/2023/03/17/project-coordinator" target="_blank">OpenRefine is looking for a part time project manager</a></span></li></ul></div></span></span></span></h3><h3><span style="color: #0f1419; font-family: arial;"><span style="background-color: rgba(0, 0, 0, 0.008); font-size: medium; white-space: pre-wrap;">Video and Tutorials</span></span></h3><div><span style="font-family: arial; font-size: small;"><b>English Tutorials:</b></span></div><div><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Getting Familiar with OpenRefine"}" style="font-size: 10pt; text-align: center;"><a href="https://lydiaofficial.substack.com/p/getting-familiar-with-openrefine?utm_source=twitter&utm_campaign=auto_share&r=1yumeu" target="_blank"><span style="font-family: arial;">Getting Familiar with OpenRefine</span></a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Open Refine: A Beginners Guide"}" style="font-size: 10pt; text-align: center;"><a href="https://lib.usf.edu/news/open-refine-a-beginners-guide/" target="_blank"><span style="font-family: arial;">Open Refine: A Beginners Guide</span></a></span></li></ul></div><h3 style="background-color: white; border: 0px solid rgb(0, 0, 0); box-sizing: border-box; color: #3b3f44; margin: 0px;"><span style="background-color: transparent;"><span style="font-family: arial; font-size: small;">English Videos:</span></span></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><ul style="background-color: white; text-align: center;"><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"CU Digital Scholarship Workshops [Spring 2023]: Using OpenRefine for Cleaning Data\r"}" style="font-weight: normal; text-align: center;"><a href="https://www.youtube.com/watch?v=JLlyKeZ7Zq8&ab_channel=CatholicUUniversityLibraries" target="_blank"><span style="font-family: arial; font-size: x-small;">CU Digital Scholarship Workshops [Spring 2023]: Using OpenRefine for Cleaning Data</span></a></span></li><li style="text-align: left;"><span style="font-family: arial; font-size: x-small; font-weight: normal;"><a href="https://www.youtube.com/watch?v=K-yGVp6Nlho&ab_channel=TheAlliance%7CL%E2%80%99Alliance" target="_blank">HSS Winter Series 2023: Introduction to OpenRefine</a><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"10: OpenRefine for Collections Data"}" style="text-align: center;"></span></span></li><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"The Beginner's Guide to OpenRefine by Fathima Ibrahimkunju"}" style="font-weight: normal; text-align: center;"><a href="https://www.youtube.com/watch?v=yAh9BubQtmE&ab_channel=KnowHive" target="_blank"><span style="font-family: arial; font-size: x-small;">The Beginner's Guide to OpenRefine by Fathima Ibrahimkunju</span></a></span></li></ul><div><span style="font-family: arial; font-size: small;">French Videos:</span></div><div><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"VIDEO 1 : 10 raisons d'utiliser OpenRefine"}" style="font-size: 10pt; font-weight: normal; text-align: center;"><a href="https://www.youtube.com/watch?v=COcwJChUANQ&ab_channel=stefangaget" target="_blank"><span style="font-family: arial;">VIDEO 1 : 10 raisons d'utiliser OpenRefine</span></a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"École d’hiver des SHS 2023 : Introduction à OpenRefine\r"}" style="font-size: 10pt; font-weight: normal; text-align: center;"><a href="https://www.youtube.com/watch?v=ByP9qHav9Gw&ab_channel=TheAlliance%7CL%E2%80%99Alliance" target="_blank"><span style="font-family: arial;">École d’hiver des SHS 2023 : Introduction à OpenRefine</span></a></span></li></ul></div><span style="font-family: arial; font-size: small;">Indonesian Video:</span></h3><div><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Melengkapi kata kunci dataset Google Scholar menggunakan Openrefine\r"}" style="font-size: 10pt; text-align: center;"><a href="https://www.youtube.com/watch?v=pa3HoS_teZc&ab_channel=PerpustakaanFTUGM" target="_blank"><span style="font-family: arial;">Melengkapi kata kunci dataset Google Scholar menggunakan Openrefine</span></a></span></li></ul></div><h3 style="background-color: white; color: #3b3f44;"><span style="font-family: arial; font-size: medium;">Academic Publications:</span></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><div style="background-color: white;"><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Tracing East Asian Librarianship in Correspondence: A Data Analysis of Eastlib Messages from 1995 to 2020\""}" style="font-size: 10pt; font-weight: normal; text-align: center;"><a href="https://scholarsarchive.byu.edu/jeal/vol2023/iss176/2/" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Tracing East Asian Librarianship in Correspondence: A Data Analysis of Eastlib Messages from 1995 to 2020"</span></a></span></li></ul><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Network analysis using cytoscape\""}" style="font-size: 10pt; font-weight: normal; text-align: center;"><a href="https://assets.researchsquare.com/files/rs-2487773/v1_covered.pdf?c=1678214471" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Network analysis using cytoscape"</span></a></span></li></ul><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Nor da nor Lur Hiztegi Entziklopedikoan?\r\neuskarazko lehenengo entziklopediaren demografia digital alderatua\""}" style="font-size: 10pt; font-weight: normal; text-align: center;"><a href="https://dialnet.unirioja.es/servlet/articulo?codigo=8865245" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Nor da nor Lur Hiztegi Entziklopedikoan? euskarazko lehenengo entziklopediaren demografia digital alderatua"</span></a></span></li></ul><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Αξιολόγηση Ελλήνων ερευνητών με τη χρήση βιβλιομετρικών δεδομένων από τις βάσεις αναφορών Google Scholar και Scopus\""}" style="font-size: 10pt; font-weight: normal; text-align: center;"><a href="https://polynoe.lib.uniwa.gr/xmlui/handle/11400/3885" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Αξιολόγηση Ελλήνων ερευνητών με τη χρήση βιβλιομετρικών δεδομένων από τις βάσεις αναφορών Google Scholar και Scopus"</span></a></span></li></ul></div></h3></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-76044394663767364512023-03-04T13:44:00.000-05:002023-03-04T13:44:03.907-05:00OpenRefine February 2023 Review<p></p><span style="font-family: arial;"><span>Happy March!</span><span> </span><span>This month, we decided to share the most relevant and helpful OpenRefine February 2023 releases, tutorials, videos, and academic publications with you. Read on to discover them.</span><br /></span><p></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUwmqRe1l2sgE6lhqke3TZZfPp_L9IYstEn43ZGB_drGhhuSWT1C40lYIk3IqMkJj6j3c9ogZ5_4iE4fS_H9pMXUnUf2b2x_g6Fu4Xqw0cMOIok0FuOhrLAkLyrNPvZq1M-ThB_XZqcOOULuV9gglQgYruwGKbFYeCP1Sk13lQD7jQX8bx_jViAtpN/s1024/February%202023%20Review.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUwmqRe1l2sgE6lhqke3TZZfPp_L9IYstEn43ZGB_drGhhuSWT1C40lYIk3IqMkJj6j3c9ogZ5_4iE4fS_H9pMXUnUf2b2x_g6Fu4Xqw0cMOIok0FuOhrLAkLyrNPvZq1M-ThB_XZqcOOULuV9gglQgYruwGKbFYeCP1Sk13lQD7jQX8bx_jViAtpN/s320/February%202023%20Review.jpg" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div></div></div><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; border: 0px solid rgb(0, 0, 0); box-sizing: border-box; color: #3b3f44; margin: 0px;"><span style="font-family: arial; font-size: small;"><h3 style="color: black; font-family: "Times New Roman"; font-weight: 400; text-align: left;"><span style="color: #0f1419; font-family: arial;"><span style="background-color: rgba(0, 0, 0, 0.008); white-space: pre-wrap;"><b>Releases </b></span></span></h3><div><span style="color: #0f1419; font-family: arial;"><span style="background-color: rgba(0, 0, 0, 0.008); white-space: pre-wrap;"><ul style="background-color: white; color: black; white-space: normal;"><li><span style="color: #24292f; font-weight: normal;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.7.0#sq_hb4ggrjfn3" target="_blank">OpenRefine v3.7.0</a></span></li></ul></span></span></div><h3 style="color: black; font-family: "Times New Roman"; font-weight: 400; text-align: left;"><span style="color: #0f1419; font-family: arial;"><span style="background-color: rgba(0, 0, 0, 0.008); white-space: pre-wrap;"><b>Video and Tutorials</b></span></span></h3></span></h3><div><span style="font-family: arial; font-size: small;"><b>English Tutorial:</b></span></div><div><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Using OpenRefine to assess open research at your organization"}" style="text-align: center;"><a href="https://www.gofair.us/news/using-openrefine-to-assess-open-research-at-your-organization" target="_blank"><span style="font-family: arial;">Using OpenRefine to assess open research at your organization</span></a></span></li></ul></div><h3 style="background-color: white; border: 0px solid rgb(0, 0, 0); box-sizing: border-box; color: #3b3f44; margin: 0px;"><strong style="background-color: transparent;"><span style="font-family: arial; font-size: small;">English Videos:</span></strong></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><ul style="background-color: white; text-align: center;"><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Introduction to data cleaning with OpenRefine & word clouds"}" style="font-weight: 400; text-align: center;"><a href="https://www.youtube.com/watch?v=KLuDe38muQI&ab_channel=UniversityofManitobaLibraries" target="_blank"><span style="font-family: arial; font-size: small;">Introduction to data cleaning with OpenRefine & word clouds</span></a></span></li><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Introduction to data cleaning with OpenRefine & word clouds"}" style="font-weight: 400; text-align: center;"><span style="font-family: arial; font-size: small;"><a href="https://www.youtube.com/watch?v=8seGL3YaWn8&ab_channel=AlexNovichkov" target="_blank">Google Sheets: unpivot, pivot, export, import, csv. OpenRefine: facet, cluster</a><br /></span></span></li><li style="text-align: left;"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"10: OpenRefine for Collections Data"}" style="font-weight: 400; text-align: center;"><a href="https://www.youtube.com/watch?v=UOFrBxsAAIA&ab_channel=SUNYLibrariansAssociationTDG" target="_blank"><span style="font-family: arial; font-size: small;">10: OpenRefine for Collections Data</span></a></span></li></ul><span style="font-family: arial; font-size: small;">Indonesian Video:</span></h3><div><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Melengkapi kata kunci menggunakan OpenRefine: penting untuk bibliometrik"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=BnN7-OUp56Y&ab_channel=PerpustakaanFTUGM" target="_blank"><span style="font-family: arial;">Melengkapi kata kunci menggunakan OpenRefine: penting untuk bibliometrik</span></a></span></li></ul><div><span style="font-family: arial;"><b>German Videos:</b></span></div></div><div><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"OpenRefine och Wikidata hub"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=tQImJvM_1Pk&ab_channel=MagnusS%C3%A4lg%C3%B6" target="_blank"><span style="font-family: arial;">OpenRefine och Wikidata hub</span></a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"OpenRefine och Wikidata hub"}" style="text-align: center;"><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=tCdluPq5GkA&ab_channel=MichaelMarkert" target="_blank">Abgleich 'unsauberer' Ortsnamen mit der GND in OpenRefine (Tutorial)</a><br /></span></span></li></ul></div><h3 style="background-color: white; color: #3b3f44;"><strong><span style="font-family: arial; font-size: small;">Academic Publications:</span></strong></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><div style="background-color: white;"><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Mention of OpenRefine in \"Tratamiento de datos de investigación\""}" style="font-weight: 400; text-align: center;"><a href="https://rio.upo.es/xmlui/handle/10433/15611" target="_blank"><span style="font-family: arial; font-size: small;">Mention of OpenRefine in "Tratamiento de datos de investigación"</span></a></span></li></ul><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Die Migration der Bibliographia Cartographica: Daten aufräumen mit OpenRefine\""}" style="font-weight: 400; text-align: center;"><a href="https://www.degruyter.com/document/doi/10.1515/bd-2023-0016/html" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "Die Migration der Bibliographia Cartographica: Daten aufräumen mit OpenRefine"</span></a></span></li></ul><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Global research on dental polymers and their\r\napplication: A bibliometric analysis and knowledge\r\nmapping\""}" style="font-weight: 400; text-align: center;"><a href="https://www.researchgate.net/profile/Saqib-Ali-5/publication/366910165_Global_research_on_dental_polymers_and_their_application_A_Bibliometric_analysis_and_knowledge_mapping/links/63de00b862d2a24f92f7c7f1/Global-research-on-dental-polymers-and-their-application-A-Bibliometric-analysis-and-knowledge-mapping.pdf" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "Global research on dental polymers and their application: A bibliometric analysis and knowledge mapping"</span></a></span></li></ul></div></h3></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-50208613596844974022023-01-30T18:23:00.000-05:002023-02-10T20:20:22.193-05:00OpenRefine January 2023 Review<p><span style="font-family: arial;">Happy February<span>! </span><span>This month, we decided to share the most relevant and helpful OpenRefine January 2023 videos and academic publications with you. Read on to discover them.</span></span></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNS8PF9opQEfEKpHBdagUm3D0kBvMRxZaesT9eKfivjsidfOXlAuk1GLdqhchgYB_Hi0LzGhS4EPwkXfl2D9oOOskaF9aqMtQySfLpLTRj6jXA574rkdg7mK-J8pTXISyxgh6KCgjKCdWHKwLMC7h2UaPDHE1Qg2iWPXqgKGbQMF9zugZJd8mEsnuO/s1024/January%202023%20Blogger.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNS8PF9opQEfEKpHBdagUm3D0kBvMRxZaesT9eKfivjsidfOXlAuk1GLdqhchgYB_Hi0LzGhS4EPwkXfl2D9oOOskaF9aqMtQySfLpLTRj6jXA574rkdg7mK-J8pTXISyxgh6KCgjKCdWHKwLMC7h2UaPDHE1Qg2iWPXqgKGbQMF9zugZJd8mEsnuO/s320/January%202023%20Blogger.jpg" width="320" /></a></div></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; border: 0px solid rgb(0, 0, 0); box-sizing: border-box; color: #3b3f44; margin: 0px;"><strong style="background-color: transparent;"><span style="font-family: arial; font-size: small;">English Videos:</span></strong></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><ul style="background-color: white; text-align: center;"><li style="text-align: left;"><span style="color: #0000ee; font-family: arial; font-size: small;"><span style="font-weight: 400;"><u><a href="https://www.youtube.com/watch?v=xhQD4SShjuw&ab_channel=DEWANGOLAMMORTOZA" target="_blank">Cleaning Data Using OpenRefine</a></u></span></span></li><li style="text-align: left;"><span style="color: #0000ee; font-family: arial; font-size: small;"><span style="font-weight: 400;"><u><a href="https://www.youtube.com/watch?v=CZGtjjTuviM&ab_channel=Connaissance" target="_blank">Part 4: Exploring the Geolexica Knowledge Graph with OpenRefine</a></u></span></span></li><li style="text-align: left;"><span style="color: #0000ee; font-family: arial; font-size: small;"><span style="font-weight: 400;"><u><a href="https://www.youtube.com/watch?v=pNJ22MaMGY0&ab_channel=OpenContext-TheAlexandriaArchiveInstitute" target="_blank">Overview of Using OpenRefine to Clean Archaeological Data</a></u></span></span></li><li style="text-align: left;"><span style="color: #0000ee; font-family: arial; font-size: small;"><span style="font-weight: 400;"><u><a href="https://www.youtube.com/watch?v=qRdgrmx-Blk&ab_channel=Connaissance" target="_blank">Part 6: OpenRefine Analysis on the Chord-Scale Knowledge Graph</a></u></span></span></li></ul><span style="font-family: arial; font-size: small;">Indonesian Video:</span></h3><div><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Menambang Komentar InstaGram, dan Membersihkan dan Menstrukturkannya dengan OpenRefine"}" style="font-family: arial; text-align: center;"><a href="https://www.youtube.com/watch?v=LU15vEc530E&ab_channel=IkbalMaulana" target="_blank">Menambang Komentar InstaGram, dan Membersihkan dan Menstrukturkannya dengan OpenRefine</a></span></li></ul><div><span style="font-family: arial;"><b>French Video:</b></span></div></div><div><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":1049537,"3":{"1":0},"9":1,"10":1,"11":4,"12":0,"23":1}" data-sheets-value="{"1":2,"2":"Réconciliation avec Open Refine (Humanités Numériques)"}" style="font-family: arial; text-align: center;"><a href="https://www.youtube.com/watch?v=RitCOQPPt8A&ab_channel=GeraldKembellec" target="_blank">Réconciliation avec Open Refine (Humanités Numériques)</a></span></li></ul></div><h3 style="background-color: white; color: #3b3f44;"><strong><span style="font-family: arial; font-size: small;">Academic Publications:</span></strong></h3><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"><div style="background-color: white;"><ul><li><span style="color: #0000ee; font-family: arial; font-size: small;"><span style="font-weight: 400;"><u><a href="https://pesquisa.bvsalud.org/portal/resource/pt/biblio-1408136" target="_blank">Use of OpenRefine in "Antifungals from plants: a bibliometric analysis of the last two decades (2000-2020)"</a></u></span></span></li></ul><ul><li><span style="color: #0000ee; font-family: arial; font-size: small;"><span style="font-weight: 400;"><u><a href="https://www.srels.org/index.php/sjim/article/view/170677" target="_blank">Fetching Automatic Authority Data in ILS from Wikidata via OpenRefine</a></u></span></span></li></ul><ul><li><u style="color: #0000ee; font-weight: 400;"><a href="http://op.niscpr.res.in/index.php/ALIS/article/view/67478" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "Retraction in India since independence: a multifaceted analysis for 75 years through data carpentry"</span></a></u></li></ul><ul><li><u style="color: #0000ee; font-weight: 400;"><a href="https://www.sciencedirect.com/science/article/pii/S1013905223000056" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "Global research on dental polymer and its application: A bibliometric analysis and knowledge mapping"</span></a></u></li></ul><ul><li><u style="color: #0000ee; font-weight: 400;"><a href="https://swop.bsz-bw.de/frontdoor/deliver/index/docId/2564/file/GNDForumArchiv_OpenRefine_VMack_2022-10-05.pdf" target="_blank"><span style="font-family: arial; font-size: small;">Use of OpenRefine in "MIT DER GND ARBEITEN DATENABGLEICH UND -ANREICHERUNG MITHILFE VON OPEN REFINE""</span></a></u></li></ul></div></h3></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-140141332147370022023-01-26T11:57:00.000-05:002023-01-26T11:57:11.472-05:00OpenRefine December 2022 Review<p><span style="font-family: arial;">Happy January and Happy New Year! <span>This month, we decided to share the most relevant and helpful OpenRefine December 2022 videos and academic publications with you. Read on to discover them.</span></span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSw8m9oijc9-z_9z0f3HJYiqhpAKWww3ghqoOD7McHfxMcoce2faw5S8ipA7Qgb0cirMOAN8uUvu2y4yN5HVGpZG4EhTW_3XHqfKMGOHM9yN3BTt1bx6ZdpZByAgStbYcm5LFvnQ7yHQU8049y99occtshpuil-RAhpdJFxORKm6r6QpDpr5tNzs2D/s1024/December%202022%20Blogger.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSw8m9oijc9-z_9z0f3HJYiqhpAKWww3ghqoOD7McHfxMcoce2faw5S8ipA7Qgb0cirMOAN8uUvu2y4yN5HVGpZG4EhTW_3XHqfKMGOHM9yN3BTt1bx6ZdpZByAgStbYcm5LFvnQ7yHQU8049y99occtshpuil-RAhpdJFxORKm6r6QpDpr5tNzs2D/s320/December%202022%20Blogger.jpg" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><div align="left" class="textNodeWrapper" data-node-type="text" data-unique-id="a3000812-6295-4f7e-8b2c-ef6cd73913ea" dom-tree="" draggable="false" ng-attr-align="{[{ node.attributes.align }]}" ng-class="{ 'node-isEmpty': isEmpty(node), 'node-isReadOnly': node.readOnly }" ng-style="{ 'width': (node.parent.type == 'column') ? ((node.parent.isResponsive && node['metadata'] && node['metadata']['layout'] && node['metadata']['layout']['320px'] && node['metadata']['layout']['320px']['width']) ? node['metadata']['layout']['320px']['width'] : node.styles['width']) : 'auto'}" style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; color: #3b3f44; font-weight: 400; position: relative; width: auto;" text-node="" view-in-browser="false"><text align="left" attributes="attributes(node)" class="textNode" dom-tree-frame="" ng-style="styles(node, node.__.parent.isResponsive)" style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; cursor: text; display: block; padding-bottom: 15px; padding-top: 15px; text-align: center; vertical-align: top; width: 540px;"><ckeditorelement style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box;"><span style="font-family: arial; font-size: small;"><h3 style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px; text-align: left;"><span style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box;"><span style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; font-weight: 700;">Community Annoucement:</span></span></h3><p style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px; text-align: left;"></p><ul style="text-align: left;"><li><span style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box;"><span style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; font-weight: 700;"><a href="https://openrefine.org/blog/2022/12/01/governance-changes" target="_blank">Governance changes</a></span></span></li></ul><div></div><p></p><strong><h3 style="text-align: left;"><strong>English Videos:</strong></h3></strong><ul><li style="text-align: left;"><a href="https://www.youtube.com/@owenpatel" target="_blank">Advent of Code 2022 Day 1 to Day 10 using OpenRefine by YouTube channel Owen Stephens (9 videos)</a></li><li style="text-align: left;"><a href="https://www.youtube.com/watch?v=YRSi2x3VSO4&ab_channel=Universit%C3%A4tsbibliothekBasel" target="_blank">OpenRefine</a></li><li style="text-align: left;"><a href="https://vimeo.com/user82369617" target="_blank">The Griffith University LibraryPRO released a series of 17 OpenRefine videos on Vimeo </a></li></ul><h3 style="text-align: left;"><strong>Academic Publications:</strong></h3><div style="text-align: left;"><ul><li><a href="https://ir.inflibnet.ac.in/handle/1944/2398" target="_blank">Use of OpenRefine in "Measuring the Open Access Friendliness of Indian Institutions through Data Carpentry"</a></li></ul><ul><li><a href="https://repository.escholarship.umassmed.edu/handle/20.500.14038/51387" target="_blank">Use of OpenRefine in "Zotero: Low-budget, high-power middleware for electronic theses and dissertation (ETD) repository workflows"</a></li></ul><ul><li><a href="https://repository.escholarship.umassmed.edu/handle/20.500.14038/51385" target="_blank">Mention of OpenRefine in "It gets worse before it gets better: The promises and pitfalls of automating IR workflows"</a></li></ul><ul><li><a href="https://repository.escholarship.umassmed.edu/handle/20.500.14038/51392" target="_blank">Mention of OpenRefine in "JavaScript as Your Assistant: How to Populate Batch Spreadsheets FAST using CrossRef API"</a></li></ul><ul><li><a href="https://drops.dagstuhl.de/opus/volltexte/2022/17439/pdf/dagrep-v012-i005-complete.pdf#page=10" target="_blank">Mention of OpenRefine in "Wikidata: empowering metabolomics research"</a></li></ul><ul><li><a href="https://academic.oup.com/ofid/article/9/Supplement_2/ofac492.1378/6903439" target="_blank">Use of OpenRefine in "1748. Epidemiology and resistance patterns of nursing home uropathogens in four states, 2018-2019"</a></li></ul></div></span></ckeditorelement></text></div><div align="left" class="textNodeWrapper" data-node-type="text" data-unique-id="1a69aee6-19e6-498f-817f-33bbb876ed31" dom-tree="" draggable="false" ng-attr-align="{[{ node.attributes.align }]}" ng-class="{ 'node-isEmpty': isEmpty(node), 'node-isReadOnly': node.readOnly }" ng-style="{ 'width': (node.parent.type == 'column') ? ((node.parent.isResponsive && node['metadata'] && node['metadata']['layout'] && node['metadata']['layout']['320px'] && node['metadata']['layout']['320px']['width']) ? node['metadata']['layout']['320px']['width'] : node.styles['width']) : 'auto'}" style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; color: #3b3f44; font-family: arial, helvetica, sans-serif; font-size: 16px; font-weight: 400; position: relative; width: auto;" text-node="" view-in-browser="false"><text align="left" attributes="attributes(node)" class="textNode" dom-tree-frame="" ng-style="styles(node, node.__.parent.isResponsive)" style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; cursor: text; display: block; vertical-align: top; width: 540px;"><ckeditorelement aria-label="Rich Text Editor, main" class="ck-blurred ck ck-content ck-editor__editable ck-rounded-corners ck-editor__editable_inline" dir="ltr" lang="en" role="textbox" style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box;"><ul style="border: 0px solid rgb(0, 0, 0); box-sizing: border-box; margin: 0px;"></ul></ckeditorelement></text></div></h3></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-28085716282245298672022-12-02T10:57:00.000-05:002022-12-02T10:57:29.810-05:00OpenRefine November 2022 Review<p><span style="font-family: arial;">Happy December! Wow, this year just flew by! This month, we decided to share the most relevant and helpful OpenRefine November 2022 videos and academic publications with you. Read on to discover them.</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0t41Gn2sKRR8MDlVJ9P2BwEAy_neu_NVwLPXK1mYFQeah8IFQpngp5cyNQUCnydRfCAkzXHKtdIJRonAcycRWjskUZfYEJ1_jj5-xph7gFtI5dQMfkiDYa1zreoJth8nMyKrRnGzodrhwX11wvkdQALVWGY97_8ZD3Zh-XQjjkaonzdxMl2xpRhDG/s1024/November%202022%20Blogger.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0t41Gn2sKRR8MDlVJ9P2BwEAy_neu_NVwLPXK1mYFQeah8IFQpngp5cyNQUCnydRfCAkzXHKtdIJRonAcycRWjskUZfYEJ1_jj5-xph7gFtI5dQMfkiDYa1zreoJth8nMyKrRnGzodrhwX11wvkdQALVWGY97_8ZD3Zh-XQjjkaonzdxMl2xpRhDG/s320/November%202022%20Blogger.jpg" width="320" /></a></div><p></p><p></p><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px; text-align: left;"><span style="font-family: arial; font-size: small;">Videos:</span></h3><div><ul style="background-color: white;"></ul></div></div><div style="box-sizing: border-box;"><span style="font-family: arial;"><div><ul style="background-color: white;"><li><span><b>English Videos:</b></span></li><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=RQCaJvEL_CU&ab_channel=ShohanurRahman" target="_blank">Data Cleaning with OpenRefine</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=oSXxraHgbLs&ab_channel=WikimediaPortugal" target="_blank">OpenRefine for Beginners, por Jan Ainali (Foundation for Public Code)</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=nTlTboXoGj4&ab_channel=Eng.AhmedSamy" target="_blank">How to install OpenRefine</a></span></li></ul></ul><ul style="background-color: white;"><li><b>Spanish Videos:</b></li><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"HERRAMIENTA ETL OPEN REFINE LEODAN"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=7jg1yKSJbVw&t=5s&ab_channel=LeodanH.Condori" target="_blank">HERRAMIENTA ETL OPEN REFINE LEODAN</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"HERRAMIENTA ETL OPEN REFINE LEODAN"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=zplDmokwjMM&ab_channel=OmarLuna" target="_blank">Limpieza de datos con OpenRefine</a></span></li></ul></ul><div><ul style="background-color: white;"></ul></div><div><ul style="background-color: white;"></ul></div></div><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-size: small;">Academic Publications</span></h3></div><div><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Data Visualization using External Data\""}" style="text-align: center;"><a href="https://scholars.unh.edu/faculty_pubs/1524/" target="_blank">Use of OpenRefine in "Data Visualization using External Data"</a></span></li></ul><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Modeling COVID-19 Transmission Dynamics: A Bibliometric Review\""}" style="text-align: center;"><a href="https://www.mdpi.com/1660-4601/19/21/14143" target="_blank">Use of OpenRefine in "Modeling COVID-19 Transmission Dynamics: A Bibliometric Review"</a></span></li></ul></div></span></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-29434820334105767882022-11-01T08:14:00.004-04:002022-11-02T11:32:56.091-04:00OpenRefine October 2022 Review<p><span style="font-family: arial;">Happy November! This month, we decided to share the most relevant and helpful OpenRefine October 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJ_UKfmA1v5KpNdmCxyhMAubpi-t7QklCS34IC4OaxFLTiLpWP_WICivflhKmK4d1_PZgFF1_XkLU0I80Wa0_v5DoGwcoq_BczXbzSd8n87EpD55DMePBnnF-rESUA3u0y5z9ZK0A7a1tPsNEsGG6VoHMegRLZFhJhUL-5lmmnsd7hfiyGl2wWt594/s1024/October%202022%20Blogger.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJ_UKfmA1v5KpNdmCxyhMAubpi-t7QklCS34IC4OaxFLTiLpWP_WICivflhKmK4d1_PZgFF1_XkLU0I80Wa0_v5DoGwcoq_BczXbzSd8n87EpD55DMePBnnF-rESUA3u0y5z9ZK0A7a1tPsNEsGG6VoHMegRLZFhJhUL-5lmmnsd7hfiyGl2wWt594/s320/October%202022%20Blogger.jpg" width="320" /></a></div><p></p><p></p><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><b style="color: #0f1419; font-family: arial; font-size: medium; white-space: pre-wrap;">Community Annoucement </b></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><ul style="text-align: left;"><li><a href="https://openrefine.org/blog/2022/09/30/windows-macos-packaging.html#sq_h7i0ca3ugq" style="font-weight: 400;" target="_blank"><span style="color: #24292f; font-family: arial; font-size: small;">Call for Proposal: OpenRefine is looking for help with Windows and MacOS packaging</span></a></li></ul></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><b style="color: #0f1419; font-family: arial; font-size: medium; white-space: pre-wrap;">Releases</b></h3><div><ul style="text-align: left;"><li><span style="font-family: arial;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.6.2#sq_h6spdbovvd" target="_blank"><span style="background-color: white; color: #24292f;">OpenRefine v3.6.2 by </span>wetneb</a></span></li><li><span style="font-family: arial;"><a href="https://github.com/codeforkjeff/conciliator/releases/tag/v3.1.0" target="_blank"><span style="background-color: white; color: #24292f;">Conciliator v3.1.0 release by </span><span style="background-color: white; box-sizing: border-box;">codeforkjeff</span><span style="background-color: white; color: #57606a;"> </span></a></span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;">Videos and Tutorials:</span></h3><div><div><ul style="background-color: white; text-align: left;"></ul></div></div></div><div style="box-sizing: border-box;"><span style="font-family: arial;"><div><ul style="background-color: white;"><li><span><b>English Videos:</b></span></li><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=bL1rhPFn1Rk&ab_channel=TARIKBINSHAMS" target="_blank">Data Cleaning with OpenRefine</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=PlexQ7GJ_ps&ab_channel=AlbertBoateng" target="_blank">Cleaning Data using OpenRefine</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=PUOiwCVSZCo&ab_channel=SABIHATAHSEEN" target="_blank">Cleaning data using OpenRefine</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=KaJi3PUqQGw&ab_channel=RezwanAhmed" target="_blank">OpenRefine Tutorial</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=iEchWEtyHHw&ab_channel=sadiatasnim" target="_blank">OpenRefine Tutorial Task 1</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=nUcKshT17CI&ab_channel=TAMZEEDURRAHMANPRITHUL" target="_blank">CSE 424 - Video Tutorial - OpenRefine</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Data Cleaning with OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=tStw_aeDDuA&ab_channel=ANANYARAHAMAN" target="_blank">OpenRefine workshop</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Clean Dataset with OpenRefine | OpenRefine Tutorial | Clean Dataset"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=BxbpWm9ye5g&ab_channel=FazleRabbiLinkon" target="_blank">Clean Dataset with OpenRefine | OpenRefine Tutorial | Clean Dataset</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Clean Dataset with OpenRefine | OpenRefine Tutorial | Clean Dataset"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=GLWik-wIJ6Y&ab_channel=accesslibcon" target="_blank">Access 2022 Jingjing Wu (Using OpenRefine to Retrieve Data Through APIs)</a></span></li></ul></ul><ul style="background-color: white;"><li><b>Dutch Video:</b></li><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Reconcilen met AAT mbv OpenRefine"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=CzGxlY4kNlY&ab_channel=NetwerkAdlibenAxiellCollections" target="_blank">Reconcilen met AAT mbv OpenRefine</a></span></li></ul></ul><ul style="text-align: left;"><li><b style="background-color: white;">German Tutorial:</b></li><ul><li><a href="https://www.computerweekly.com/de/tipp/Mit-OpenRefine-Daten-bereinigen-und-zusammenfuehren" style="background-color: white; text-align: center;" target="_blank">Mit OpenRefine Daten bereinigen und zusammenführen</a></li></ul><div></div></ul><div><ul style="background-color: white;"></ul></div><div><ul style="background-color: white;"></ul></div></div><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-size: small;">Academic Publications</span></h3></div><div><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="http://nopr.niscpr.res.in/handle/123456789/60544" target="_blank">Use of OpenRefine in "Measuring the open access friendliness of the state universities in India through data carpentry"</a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="http://csitjournal.khmnu.edu.ua/index.php/csit/article/view/161" target="_blank">Use of OpenRefine in "ОНТОЛОГІЧНИЙ АНАЛІЗ ПРИДАТНОСТІ ЗАЛІЗНИЧНИХ КОЛІЙ ДЛЯ ЗАБЕЗПЕЧЕННЯ ВИСОКОШВИДКОГО РУХУ ПОЇЗДІВ"</a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://arxiv.org/abs/2209.14907" target="_blank">Use of OpenRefine in "Patients' Severity States Classification based on Electronic Health Record (EHR) Data using Multiple Machine Learning and Deep Learning Approaches"</a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://asistdl.onlinelibrary.wiley.com/doi/abs/10.1002/pra2.609" target="_blank">Use of OpenRefine in "Entification of Metadata for Knowledge‐Graph‐Guided Discovery"</a></span></li></ul></div></span></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-537878859985454932022-09-30T12:45:00.003-04:002022-09-30T12:45:32.732-04:00OpenRefine September 2022 Review<p><span style="font-family: arial;">Happy October! This month, we decided to share the most relevant and helpful OpenRefine September 2022 announcements, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiINNavqukmJSuNLiPUG8vJ5x2N3tDNOI-bxKLcDGgxJE9wXJICnVJhU8ZJReozrhkjlHFTGyGHcELtB_7ufxapeRWp0l5RkVS94xXgJN5mOPbECzLU5MYAd0EsdKdk7C5D_yOWx7EDI6yt0Cbi4h06dRMgnZ4Px2HddjUF3m589GOk_QP37TP0-6Yg/s1024/September%202022%20Blogger.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiINNavqukmJSuNLiPUG8vJ5x2N3tDNOI-bxKLcDGgxJE9wXJICnVJhU8ZJReozrhkjlHFTGyGHcELtB_7ufxapeRWp0l5RkVS94xXgJN5mOPbECzLU5MYAd0EsdKdk7C5D_yOWx7EDI6yt0Cbi4h06dRMgnZ4Px2HddjUF3m589GOk_QP37TP0-6Yg/s320/September%202022%20Blogger.jpg" width="320" /></a></div></div><p></p><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial; font-size: small;">Community Announcement</span></h3><div><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://openrefine.org/blog/2022/09/20/discourse.html" target="_blank"><span style="font-family: arial;">From mailing lists and Gitter to a web-based Discourse forum: welcoming your feedback</span></a></span></li></ul></div></div><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;">Videos and Tutorials:</span></h3><div><span style="font-family: arial;"><div><ul style="background-color: white; text-align: left;"><li><span><b>English Videos:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=FkHIpSPj41o&ab_channel=SyafinaNurulAida" target="_blank">Tutorial Cleaning OpenRefine</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=9mdHlSx_iXM&ab_channel=WikiMentorAfrica" target="_blank">Introduction to OpenRefine day 1 by Sandra Fauconnier</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=WYS8fTjFVJ8&ab_channel=WikiMentorAfrica" target="_blank">Introduction to OpenRefine day 2 by Sandra Fauconnier</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=uX2qbQlFyjE&ab_channel=MoumitaKhandaker" target="_blank">CSE713, Individual Assignment Submission 1, OpenRefine, Moumita Khandaker</a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><b>Swedish Video:</b></li><ul><li><a href="https://www.youtube.com/watch?v=WaEpU0FCnK8&ab_channel=MagnusS%C3%A4lg%C3%B6" style="white-space: pre-wrap;" target="_blank">OpenRefine Lagstifftande utskott #riksdagen #wikidata #wikidataRiksdagen</a></li></ul></ul><ul style="background-color: white; text-align: left;"><li><b>French Video:</b></li><ul><li><a href="https://www.youtube.com/watch?v=pMJmZ-rwRhc&ab_channel=Wikim%C3%A9diaFrance" style="white-space: pre-wrap;" target="_blank">Atelier OpenRefine — Wiki, data et GLAM 2021</a></li></ul></ul><ul style="background-color: white;"><li><span><b>Portuguese Tutorial:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://escoladedados.org/tutoriais/faxina-de-dados-com-open-refine/" target="_blank">FAXINA DE DADOS COM OPEN REFINE</a></span></li></ul></ul><div><ul style="background-color: white;"><li><span><b>German Tutorial:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.bigdata-insider.de/daten-flexibel-transformieren-und-bereinigen-mit-openrefine-a-1801a63426fc0d4228f2821d05afb998/" target="_blank">Daten flexibel transformieren und bereinigen mit OpenRefine</a></span></li></ul></ul></div><div><ul style="background-color: white;"></ul></div></div><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-size: small;">Academic Publications</span></h3></div><div><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://serials.atla.com/tcb/article/view/3132/4038" target="_blank">Review of OpenRefine Software</a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://serials.atla.com/tcb/article/download/3128/4041" target="_blank">OpenAthens and OpenRefine</a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://web.archive.org/web/20220903164855id_/https://oa.tib.eu/renate/bitstream/123456789/10138/1/Collaborative_annotation_and.pdf" target="_blank">Use of OpenRefine in "Collaborative annotation and semantic enrichment of 3D media"</a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://biss.pensoft.net/article/91123/" target="_blank">Mention of OpenRefine in "Open science tools: Supporting hands-on creation of the "digital extended specimen""</a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="http://repository.unpas.ac.id/59279/" target="_blank">Use of OpenRefine in "KAJIAN HEWAN Apis mellifera DALAM PERSPEKTIF PERANAN DENGAN MENGGUNAKAN BIBLIOMETRIX TOOLS (APLIKASI METODE SLNA)"</a></span></li></ul></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-62693042988441972672022-08-30T16:06:00.003-04:002022-09-02T15:43:10.118-04:00OpenRefine August 2022 Review<p><span style="font-family: arial;">We wish you a very happy September! This month, we decided to share the most relevant and helpful OpenRefine August 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFX-hii7SCLTtF8qT9xldeBscgY3ZhU4o30f86r3oI3tXqMRUIy4zkOqW0cmiuivLuKfWIrmeNDeIKy2M089IAflMH_-3h28p02rVNk7SShOAEWVGMrURT3kIeIK5wLxdHxyGfXhoEVZFiButu_5x8TSTy_cokjjYltCVr8t5uLmYl6-Vcr3IIKvdK/s1024/August%202022%20Blogger.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFX-hii7SCLTtF8qT9xldeBscgY3ZhU4o30f86r3oI3tXqMRUIy4zkOqW0cmiuivLuKfWIrmeNDeIKy2M089IAflMH_-3h28p02rVNk7SShOAEWVGMrURT3kIeIK5wLxdHxyGfXhoEVZFiButu_5x8TSTy_cokjjYltCVr8t5uLmYl6-Vcr3IIKvdK/s320/August%202022%20Blogger.jpg" width="320" /></a></div><p></p><p></p><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><div style="text-align: left;"><span style="color: #0f1419; font-family: arial;"><span style="background-color: rgba(0, 0, 0, 0.008); white-space: pre-wrap;"><b>Releases</b></span></span></div><div><ul><li><span style="background-color: white; color: #24292f;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.6.1#sq_h5g5ccmfpz" target="_blank"><span style="font-family: arial;">OpenRefine v3.6.1 by wetneb</span></a></span></li><li><a href="https://github.com/AtesComp/rdf-transform/releases/tag/v2.2.0#sq_h5mz0lq19h" target="_blank"><span style="font-family: arial;">RDF Transform 2.2.0 by AtesComp</span></a></li><li><span style="background-color: white; color: #24292f;"><a href="https://github.com/stkenny/grefine-rdf-extension/releases/tag/v1.4.0#sq_h593kz6qa1" target="_blank"><span style="font-family: arial;">RDF Extension v1.4.0 by stkenny</span></a></span></li></ul></div></div><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;">Videos</span></h3><div><span style="font-family: arial;"><div><ul style="background-color: white;"><li><span><b>English Videos:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=OJSRJNF_cHM&ab_channel=NaturalScienceCollectionsFacility" target="_blank">GREL Statements in OpenRefine | By Dr Ian Engelbrecht</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=sc6aNNmsNCI&ab_channel=WikimediaFoundation" target="_blank">Tutorial Batch uploading to Wikimedia Commons with OpenRefine</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=4oJp0GxGyIA&ab_channel=MagnusS%C3%A4lg%C3%B6" target="_blank">Tutorial to use OpenRefine using Wikimedia hosting service</a></span></li></ul></ul><ul style="background-color: white;"><li><span><b>French Video:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=5BiHguUF-XQ&ab_channel=NicolasVIGNERON" target="_blank">OpenRefine (import des maires de Versailles</a></span></li></ul></ul><div><ul style="background-color: white;"><li><span><b>Swedish Video:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=Pm_BmdrQ4jU&ab_channel=MagnusS%C3%A4lg%C3%B6" target="_blank">#OpenRefine lagstiftande församling - #Riksdagen #wikidata</a></span></li></ul></ul></div><div><ul style="background-color: white;"></ul></div></div><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-size: small;">Academic Publications</span></h3></div><div><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://oa.upm.es/71432/" target="_blank">Use of OpenRefine in "Comprobación de calidad de los datos abiertos de distintas ciudades españolas"</a></span></li></ul><ul><li><a href="https://dialnet.unirioja.es/servlet/articulo?codigo=8527216" target="_blank">Use of OpenRefine in "Antifungals from plants: a bibliometric analysis of the last two decades (2000-2020)"</a></li></ul><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://e-journal.trisakti.ac.id/index.php/juara/article/view/13464" target="_blank">Use of OpenRefine in "PENINGKATAN PENGETAHUAN ORANG TUA TENTANG PERAN VITAMIN D BAGI KESEHATAN ANAK DI MASA PANDEMI COVID-19"</a></span></li></ul><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://scholar.google.com/scholar?hl=en&as_sdt=0,5&q=openrefine&scisbd=1#:~:text=Everything-,OpenAthens%20and%20OpenRefine,-B%20Michael%C2%A0%2D%20TCB" target="_blank">OpenAthens and OpenRefine</a></span></li></ul></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-48794464620875947762022-07-28T21:32:00.002-04:002022-07-28T21:32:35.719-04:00OpenRefine July 2022 Review<p><span style="font-family: arial;">We wish you a very happy August This month, we decided to share the most relevant and helpful OpenRefine July 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOHk6SdtiXJCMNwXlfRwxH3Ama_x8lRQqQDwOKCxvudaTBN8f31Yee6XhUJuVSSXW665ZKEtUEm3LX4sjXjxYMmGQheAf7WY9J1LKO7USrd3r6NlJLYP8ZhaPAKgLBd5J6R_OlNv_bIKwDaley4pkFMnH7AMlzzISZehNVc6dIgucKoS3onsEV7U35/s1024/August%202022%20Blogger%20(1).jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOHk6SdtiXJCMNwXlfRwxH3Ama_x8lRQqQDwOKCxvudaTBN8f31Yee6XhUJuVSSXW665ZKEtUEm3LX4sjXjxYMmGQheAf7WY9J1LKO7USrd3r6NlJLYP8ZhaPAKgLBd5J6R_OlNv_bIKwDaley4pkFMnH7AMlzzISZehNVc6dIgucKoS3onsEV7U35/s320/August%202022%20Blogger%20(1).jpg" width="320" /></a></div><p></p><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial; font-size: small;">Community Announcement</span></h3><div><ul><li><span style="background-color: rgba(0, 0, 0, 0.008); color: #0f1419; white-space: pre-wrap;"><a href="https://groups.google.com/g/openrefine-dev/c/sZ-fcGaTOX0/m/oLffwoo7AgAJ?pli=1#sq_h4fznp72ot" target="_blank"><span style="font-family: arial;">We are collecting ideas on how to diversify OpenRefine's community and eliminate cultural and linguistic biases in OpenRefine software</span></a></span></li></ul><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial; font-size: small;">Releases</span></h3></div></div><div><ul><li><span style="background-color: white; color: #24292f;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.6.0" target="_blank"><span style="font-family: arial;">OpenRefine v3.6</span></a></span></li><li><span style="background-color: white; color: #24292f;"><a href="https://www.ontotext.com/company/news/ontotext-refine-1-0-turns-things-to-things/" target="_blank"><span style="font-family: arial;">Ontotext Refine 1.0</span></a></span></li><li><span style="background-color: white; color: #24292f;"><a href="https://github.com/AtesComp/rdf-transform/releases/tag/v2.1.1-beta?utm_sq=h3gvnx45zr" target="_blank"><span style="font-family: arial;">RDF Transform 2.1.1-beta by AtesComp</span></a></span></li></ul></div></div><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;">Tutorials and Videos</span></h3><div><span style="font-family: arial;"><div><ul style="background-color: white;"><li><span><b>English Tutorials:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://outreach.wikimedia.org/wiki/GLAM/Newsletter/June_2022/Contents/Structured_Data_on_Wikimedia_Commons_report" target="_blank">GLAM/Newsletter/June 2022/Contents/Structured Data on Wikimedia Commons report</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://medium.com/metadata-learning-unlearning/words-matter-reconciling-museum-metadata-with-wikidata-61a75898bffb" target="_blank">Words Matter: Reconciling museum metadata with Wikidata</a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><span><b>English Videos:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=xztyyblIT5I&ab_channel=MOHAMMEDABRARAHASANCHOWDHURY" target="_blank">OpenRefine Tutorial</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=ypgY502pCwM&ab_channel=SoyelimRozaik" target="_blank">Openrefine Tutorial | Soyelim Al Rozaik | 19101602 | CSE 424</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://vimeo.com/727934444" target="_blank">Submitting to LUC (Learning with LOUIS: Presentation Readiness Part 1)</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=2EUNTDpm044&ab_channel=JeffTurner" target="_blank">Jethro CSV cleanups with OpenRefine</a></span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Using OpenRefine for Name Reconciliation"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=6z-_wxGaBrA" target="_blank">Using OpenRefine for Name Reconciliation</a></span></li><li><span data-sheets-userformat="{"2":707,"3":{"1":0},"4":{"1":3,"3":2},"9":1,"10":1,"12":0}" data-sheets-value="{"1":2,"2":"Revamping OpenRefine a reproducible data wrangler"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=mBT0yMmr8oA&ab_channel=AllHackingCons" target="_blank">Revamping OpenRefine a reproducible data wrangler</a> - Recording from FOSDEM 2020</span></li><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"OpenRefine Clustering"}" style="text-align: center;"><a href="https://www.youtube.com/watch?v=EBFIckKfxuU&ab_channel=FarhadulIslam" target="_blank">OpenRefine Clustering</a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><span><b>French Tutorial:</b></span></li><ul><li><a href="https://programminghistorian.org/fr/lecons/nettoyer-ses-donnees-avec-openrefine" target="_blank">Nettoyer ses données avec OpenRefine</a></li></ul></ul><div><ul style="background-color: white;"><li><span><b>German Tutorial:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://fdmlab.landesarchiv-bw.de/post/2022-07-probleme-mit-umlauten-in-openrefine/" target="_blank">Probleme mit Umlauten in OpenRefine</a></span></li></ul></ul></div><div><ul style="background-color: white;"></ul></div></div><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-size: small;">Academic Publications</span></h3></div><div><ul><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"From ELTeC Text Collection Metadata and Named Entities to Linked-data (and Back)\""}" style="text-align: center;"><a href="http://www.lrec-conf.org/proceedings/lrec2022/workshops/LDL/2022.ldl2022-1.0.pdf#page=15" target="_blank">Use of OpenRefine in "From ELTeC Text Collection Metadata and Named Entities to Linked-data (and Back)"</a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://www.srels.org/index.php/sjim/article/view/170100" target="_blank">Use of OpenRefine in "Measuring Open Access Friendliness of Indian Central Universities through Data Carpentry"</a></span></li></ul><ul style="text-align: left;"><li><a href="https://sonar.ch/documents/314887/files/Druey-M_moire-Vdef.pdf?download" target="_blank"><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Étude, conception, collecte, curation et\névaluation d’un scraping de sites web liés au\ntransport maritime pour améliorer la prédiction\ndu fret de matières premières\""}" style="text-align: center;">Use of OpenRefine in "Étude, conception, collecte, curation et </span>évaluation d’un scraping de sites web liés au transport maritime pour améliorer la prédiction du fret de matières premières"</a></li></ul><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"A DIVULGAÇÃO DO ACERVO DA PINACOTECA BARÃO DE SANTO ÂNGELO DO INSTITUTO DE ARTES DA\nUNIVERSIDADE FEDERAL DO RIO GRANDE DO SUL POR\nMEIO DA PLATAFORMA TAINACAN\""}" style="text-align: center;"><a href="https://www.lume.ufrgs.br/bitstream/handle/10183/242118/001143749.pdf?sequence=1" target="_blank">Use of OpenRefine in "A DIVULGAÇÃO DO ACERVO DA PINACOTECA BARÃO DE SANTO ÂNGELO DO INSTITUTO DE ARTES DA UNIVERSIDADE FEDERAL DO RIO GRANDE DO SUL POR MEIO DA PLATAFORMA TAINACAN"</a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://digitalcommons.unl.edu/libphilprac/7195/" target="_blank">Integration of Linked Open Data Authorities with OpenRefine : A Methodology for Libraries</a></span></li></ul><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Documenting a Move Using Archival Description: Tools for Bridging the Gaps Between Physical and Intellectual Control\""}" style="text-align: center;"><a href="https://digitalcommons.usu.edu/westernarchives/vol13/iss1/11/" target="_blank">Use of OpenRefine in "Documenting a Move Using Archival Description: Tools for Bridging the Gaps Between Physical and Intellectual Control"</a></span></li></ul><ul style="text-align: left;"><li><span data-sheets-userformat="{"2":961,"3":{"1":0},"9":1,"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Use of OpenRefine in \"Claves para analizar datos en Twitter. Recolección y procesamiento de corpus\""}" style="text-align: center;"><a href="https://revistas.uptc.edu.co/index.php/linguistica_hispanica/article/view/14283" target="_blank">Use of OpenRefine in "Claves para analizar datos en Twitter. Recolección y procesamiento de corpus"</a></span></li></ul></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-73160076862376294542022-07-04T11:06:00.000-04:002022-07-04T11:06:23.049-04:00OpenRefine June 2022 Review<p><span style="font-family: arial;">We wish you a very happy July! This month, we decided to share the most relevant and helpful OpenRefine June 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgluUuf47XVGn2EwnM2EKgTdWVc5s9v_G09BkkgIF2-0372m0B86aKMQMOq19x0Xx6ZhQ081zXNcpWcx6CL7Tk06QecmC6ibDWXXXep7JpH4jh9resStJkyZ5thyafOFT3NvuIxiFLl_wQYvftUteQ-xi9dpSiQ4VZk0grwbEGZfD0aCCp_3xxiAN8s/s1024/June%202022%20Blogger.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgluUuf47XVGn2EwnM2EKgTdWVc5s9v_G09BkkgIF2-0372m0B86aKMQMOq19x0Xx6ZhQ081zXNcpWcx6CL7Tk06QecmC6ibDWXXXep7JpH4jh9resStJkyZ5thyafOFT3NvuIxiFLl_wQYvftUteQ-xi9dpSiQ4VZk0grwbEGZfD0aCCp_3xxiAN8s/s320/June%202022%20Blogger.jpg" width="320" /></a></div></div><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial; font-size: small;">Community Announcements</span></h3><div><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://openrefine.org/blog/2022/06/19/outreachy.html" target="_blank"><span style="font-family: arial;">Welcome to our May 2022 Outreachy interns!</span></a></span></li><li><h1 class="post-title" style="background-color: white; box-sizing: border-box; color: #515151; line-height: 1.25; margin-bottom: 0.5rem; margin-top: 0px; text-rendering: optimizelegibility;"><a href="https://openrefine.org/blog/2022/06/28/2022-survey-results.html" target="_blank"><span style="font-family: arial; font-size: small; font-weight: normal;">OpenRefine's 2022 user survey: the results are in!</span></a></h1></li></ul><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial; font-size: small;">Releases</span></h3></div></div><div><ul><li><span style="background-color: white; color: #24292f;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.6-beta1?utm_sq=h2ytxt61zg" target="_blank"><span style="font-family: arial;">OpenRefine v3.6-beta1</span></a></span></li></ul></div></div><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;">Tutorials and Videos</span></h3><div><span><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>English Tutorials:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://spokenweb.ca/the-bad-batch-open-refine-as-a-batch-editing-method-in-swallow/" target="_blank"><span style="font-family: arial;">The Bad Batch: Open Refine as a Batch Editing Method in SWALLOW</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://blog.rockarch.org/dimes-agent-pages-enhanced" target="_blank"><span style="font-family: arial;">Using Wikidata Identifiers to Enhance Agent Discovery</span></a></span></li></ul></ul><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>German Tutorial:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://fnzkoeln.hypotheses.org/8270" target="_blank"><span style="font-family: arial;">OpenRefine als Tool für HistorikerInnen – Mise en Place in der Tabellen-Küche</span></a></span></li></ul></ul><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>Dutch Tutorial:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.wikimedia.nl/actueel/agenda/wikizaterdag-openrefine/" target="_blank"><span style="font-family: arial;">WikiZaterdag OpenRefine</span></a></span></li></ul></ul></div></div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>English Videos:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=kv8bDtO4cq8&ab_channel=WikiMovimentoBrasil" target="_blank"><span style="font-family: arial;">Wikidata Lab XXXIV: OpenRefine and Structured Data on Commons</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=qrgKs3htTzY" target="_blank"><span style="font-family: arial;">User Guide of Open Refine | #OpenRefine</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=MeMxuZkjkXQ&ab_channel=ParthasarathiMukhopadhyay" target="_blank"><span style="font-family: arial;">From CrossRef to OpenRefine: A case study</span></a></span></li></ul></ul><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>Dutch Video:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=rGjy_effssk&ab_channel=NicoAltink" target="_blank"><span style="font-family: arial;">02 Installeren OpenRefine</span></a></span></li></ul></ul><ul style="background-color: white;"><li><span style="font-family: arial;"><b>Italian Video:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=nyVh_jlF4Ms&ab_channel=Strumentiperlaricercabibliografica" target="_blank"><span style="font-family: arial;">Tutorial Installazione Openrefine</span></a></span></li></ul></ul></div></div><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;">Academic Publications</span></h3></div><div><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://dl.acm.org/doi/abs/10.1145/3529372.3530919" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Open refine to wikibase: a new data upload pipeline"</span></a></span></li></ul><ul><li><a href="https://dl.acm.org/doi/abs/10.1145/3529372.3533289" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Collaborative annotation and semantic enrichment of 3D media: a FOSS toolchain"</span></a><span style="background-color: white; white-space: pre-wrap;"></span></li></ul><div></div></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-34803600762595272942022-05-31T14:28:00.005-04:002022-05-31T14:28:50.695-04:00OpenRefine May 2022 Review<p><span style="font-family: arial;">We wish you a happy June! This month, we decided to share the most relevant and helpful OpenRefine May 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfusAfZUFrNQtHIq8_obAwJDesv-mGOcyjocQJzlA_Ym8TG8R0lmWa95TtIMb4hAcI9gMSAYgDD2cEQTHZoUY7TIStvtlbKHFcYy_pEQE2mwPycT0P1l43wuS0Cu8hyRL_Zi_l_YoDjx29MC8JkbxX4GDKQCedgX_IP8eQInJDfFfMAGZqdqkW4dpU/s1024/May%202022%20Blogger.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfusAfZUFrNQtHIq8_obAwJDesv-mGOcyjocQJzlA_Ym8TG8R0lmWa95TtIMb4hAcI9gMSAYgDD2cEQTHZoUY7TIStvtlbKHFcYy_pEQE2mwPycT0P1l43wuS0Cu8hyRL_Zi_l_YoDjx29MC8JkbxX4GDKQCedgX_IP8eQInJDfFfMAGZqdqkW4dpU/s320/May%202022%20Blogger.jpg" width="320" /></a></div><br /></div><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; text-align: left;"><span style="font-family: arial; font-size: x-small;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</span></b></div><p style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;"></span></h3><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial; font-size: small;">Community Announcements</span></h3><div><ul><li><a href="https://openrefine.org/blog/2022/05/05/jan-ainali-advisory-committee.html" target="_blank"><span style="font-family: arial;">Welcome to Jan Ainali, OpenRefine's new advisory committee member</span></a></li></ul><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial; font-size: small;">Releases</span></h3></div></div><div><ul><li><span style="background-color: white; color: #24292f;"><span style="font-family: arial;"><a href="https://github.com/AtesComp/rdf-transform/releases/tag/v2.0.5-alpha?utm_sq=h21dkf1o8u" target="_blank">RDF Transform 2.0.5-alpha</a></span></span></li></ul></div></div><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;">Tutorials and Videos</span></h3><div><span><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>English Tutorial:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://inside.mediahack.co.za/5-reasons-to-switch-to-openrefine-and-never-look-back-a23150080d1d" target="_blank"><span style="font-family: arial;">5 Reasons to switch to OpenRefine (and never look back)</span></a></span></li></ul></ul><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>French Tutorial:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.canal-u.tv/chaines/ad/integration-de-wikibase-dans-openrefine-et-protocole-de-reconciliation" target="_blank"><span style="font-family: arial;">Intégration de Wikibase dans OpenRe</span></a></span><a href="https://www.canal-u.tv/chaines/ad/integration-de-wikibase-dans-openrefine-et-protocole-de-reconciliation" style="white-space: pre-wrap;" target="_blank"><span style="font-family: arial;">fine et protocole de réconciliation</span></a></li></ul></ul></div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>Spanish Videos:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=WJPR1Hv5aAs&ab_channel=PaulaZermoglio" target="_blank"><span style="font-family: arial;">Limpieza de datos de biodiversidad con OpenRefine: Funciones básicas</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=N9Yp2_Quec8&ab_channel=PaulaZermoglio" target="_blank"><span style="font-family: arial;">Limpieza de datos de biodiversidad con OpenRefine: Funciones avanzadas</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=qsN6oott3ac&ab_channel=%23Yosigopublicando" target="_blank"><span style="font-family: arial;">Tratamiento de datos con Open Refine, con Yusnelkis Guisado</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=DEh9JgTdXbw&ab_channel=WikimediaChile" target="_blank"><span style="font-family: arial;">Taller de introducción a OpenRefine</span></a></span></li></ul></ul><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>English Video:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=6y42L-OBpio" target="_blank"><span style="font-family: arial;">Cleaning Data Using OpenRefine</span></a></span></li></ul></ul><ul style="background-color: white;"><li><span style="font-family: arial;"><b>Dutch Video:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=1K0vvcZuAdQ&ab_channel=WikimediaNederland" target="_blank"><span style="font-family: arial;">Open Refine tutorial voor Wikidata en Wikimedia Commons</span></a></span></li></ul></ul></div></div><div><h3 style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial; font-size: small;">Academic Publications</span></h3></div><div><ul><li><span style="background-color: white; white-space: pre-wrap;"><span style="font-family: arial;"><a href="https://digital.sandiego.edu/cgi/viewcontent.cgi?article=1382&context=symposium" target="_blank">Use of OpenRefine in "Evaluating Publisher Open Access Agreements"</a></span></span></li></ul><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://hildok.bsz-bw.de/frontdoor/index/index/docId/1378" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Linked Open Data-Strategien zum Identity Management in einer Fachontologie"</span></a></span></li></ul><div><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://repository.udistrital.edu.co/handle/11349/29016" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Manejo y calidad de datos de biodiversidad, y la implementación de estos en las colecciones del Instituto de Ciencias Naturales – ICN de la Universidad Nacional de Colombia"</span></a></span></li></ul></div><div><br /></div></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-37162729107668547552022-05-28T22:53:00.008-04:002022-10-02T15:04:21.007-04:00OpenRefine Community Metrics<p>Every year, I need to compile metrics regarding OpenRefine community, either for presentation or grant submission. Every year, I have to go back and check what I did and how I got those number. This year will be the last. Here are the metrics I track, and how I compile them. </p><p><br /></p><p></p><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjbDjK0LYr6e_1e6yavQj7gq63KlwjQxlVtbPIT9stM_0VGCHdgSJco9YJGhkFFdvOpx8oz6mZ-DxXiuMNJq8ztAv19elXAfv4bJEiOu-vJqdCTH8g4TNo8TmnIWgAc-mqvydH8a_6e-ASDFAtTeqViF3NTqLL4SCWfV14arizVni_k7pn3BsGc1geEig" style="margin-left: auto; margin-right: auto;"><img alt="" data-original-height="451" data-original-width="805" height="224" src="https://blogger.googleusercontent.com/img/a/AVvXsEjbDjK0LYr6e_1e6yavQj7gq63KlwjQxlVtbPIT9stM_0VGCHdgSJco9YJGhkFFdvOpx8oz6mZ-DxXiuMNJq8ztAv19elXAfv4bJEiOu-vJqdCTH8g4TNo8TmnIWgAc-mqvydH8a_6e-ASDFAtTeqViF3NTqLL4SCWfV14arizVni_k7pn3BsGc1geEig=w400-h224" width="400" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">Slide from a presentation from August 2020</td></tr></tbody></table><br /><br /><p></p><span><a name='more'></a></span><h3 style="text-align: left;"><b>Metrics</b></h3><p><b>1. Number of downloads per release</b></p><p>The following curl command returns the stats for each package. To know the total download for a release you need to add the windows, mac and linux package. </p><pre style="border-radius: var(--br-md); border: 0px; box-sizing: inherit; color: var(--highlight-color); font-family: var(--ff-mono); font-size: var(--fs-body1); font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: var(--lh-md); margin-bottom: calc(var(--s-prose-spacing) + 0.4em); margin-top: 0px; max-height: 600px; overflow-wrap: normal; overflow: auto; padding: var(--su12); vertical-align: baseline; width: auto;"><code style="border-radius: 0px; border: 0px; box-sizing: inherit; color: var(--black-800); font-family: var(--ff-mono); font-size: var(--fs-body1); font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"> curl -i https://api.github.com/repos/openrefine/openrefine/releases -H "Accept: application/vnd.github.manifold-preview+json"
</code></pre><div><br /></div><div>The number of downloads is not publicly available starting OpenRefine 3.6.0 - <a href="https://groups.google.com/g/openrefine-dev/c/5FehUCTKako" target="_blank">see discussion</a>. </div><div><b><br /></b></div><div><b>2. Number of contributors on Github </b></div><p>Now that OpenRefine documentation is also hosted in the same repo the count includes code contributor, translator and edit to OpenRefine documentation. </p><p>From this URL, update the start and end date of your period of analysis in the URL: <a href="https://github.com/OpenRefine/OpenRefine/graphs/contributors?from=2021-01-01&to=2022-01-01&type=c">https://github.com/OpenRefine/OpenRefine/graphs/contributors?from=2021-01-01&to=2022-01-01&type=c</a></p><p>In your browser do <i>ctrl +F </i> and search using the keyword <i>commit. </i>Subtract 4 to that result (excluding <i>dependabot</i>)</p><p><b>3. Number of Pull Requests and Issues</b></p><p>First search all all the PR here <a href="https://github.com/OpenRefine/OpenRefine/pulls">https://github.com/OpenRefine/OpenRefine/pulls</a> using </p><p><i>is:pr created:>2021-01-01</i></p><p>Then count how many are from <i>dependabot</i> so we can subtract them. </p><p><i>is:pr created:>2021-01-01 involves:dependabot </i></p><p>Do the same things from the <i>Issue </i>tab. </p><p>Note that I was not able to do a time period using <a href="https://docs.github.com/en/search-github/searching-on-github/searching-issues-and-pull-requests#search-by-when-an-issue-or-pull-request-was-created-or-last-updated" target="_blank">GitHub search parameters</a>, so it is county everything up to today. </p><p><b>4. Number of stars and forks on GitHub</b></p><p>From this page <a href="https://github.com/OpenRefine/OpenRefine ">https://github.com/OpenRefine/OpenRefine </a></p><p><b>5. Number of users on the mailing list </b></p><div>You need to be an admin on the mailing list.</div><div><ul style="text-align: left;"><li><a href="https://groups.google.com/g/openrefine/members">https://groups.google.com/g/openrefine/members</a></li><li><a href="https://groups.google.com/g/openrefine-dev/members">https://groups.google.com/g/openrefine-dev/members</a></li></ul><div>You can get the number of message between two date by using <i>after:2021-01-01 before:2022-01-01</i><br /> search parameters from the discussion home page: <a href="https://groups.google.com/g/openrefine/">https://groups.google.com/g/openrefine/</a></div><div><i> <span> </span></i><i> </i></div><div><b>6. Traffic on the GitHub main project </b></div></div><div><b><br /></b></div><div>You need to be admin to see the page <a href="https://github.com/OpenRefine/OpenRefine/graphs/traffic">https://github.com/OpenRefine/OpenRefine/graphs/traffic</a> </div><div><br /></div><div><b>7. Academic citations</b></div><div>From the result page, you can filter results by date: <a href="https://scholar.google.ca/scholar?hl=en&as_sdt=0%2C5&q=%22OpenRefine%22&btnG=">https://scholar.google.ca/scholar?hl=en&as_sdt=0%2C5&q=%22OpenRefine%22&btnG=</a></div><div><br /></div><h3 style="text-align: left;">References</h3><div>If you are interested in Open Source Metrics, there are a lot of new projects on that area:</div><div><ul style="text-align: left;"><li><a href="https://github.com/ossf/criticality_score" target="_blank">Open Source Project Criticality Score (Beta)</a></li><li><a href="https://chaoss.community/" target="_blank">Community Health Analytics Open Source Software (CHAOSS)</a></li></ul></div>magdmartinhttp://www.blogger.com/profile/02680536297206242029noreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-49876248952248671182022-05-02T13:28:00.003-04:002022-05-02T13:28:54.071-04:00OpenRefine April 2022 Review<p><span style="font-family: arial;">Happy May! For this month, we decided to share the most relevant and helpful OpenRefine April 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFGP9GZY4xeDDiIohRlTErpV9PnsUjlUL-Z9_iHMC56SqC8_0hjEsSy3py4y-eMNnENeAOuGInZgMIbcwDhxzbbMYMSSZkKl0NyBw4a03xsqaYwO8Z6fHd72SVLgybTj2JnyB3PZBl83g-AW1p2MamCdSmjgr1DCUXn-38Y3Ys4EvbAiS1XL9FoLbV/s1024/April%202022%20Blogger.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFGP9GZY4xeDDiIohRlTErpV9PnsUjlUL-Z9_iHMC56SqC8_0hjEsSy3py4y-eMNnENeAOuGInZgMIbcwDhxzbbMYMSSZkKl0NyBw4a03xsqaYwO8Z6fHd72SVLgybTj2JnyB3PZBl83g-AW1p2MamCdSmjgr1DCUXn-38Y3Ys4EvbAiS1XL9FoLbV/s320/April%202022%20Blogger.jpg" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; font-family: arial; font-size: 12px; text-align: left;"><br /></b></div><div class="separator" style="clear: both; text-align: center;"><b style="background-color: white; font-family: arial; font-size: 12px; text-align: left;">Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</b></div><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial;">Community Announcements</span></h3><div><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><span style="font-family: arial;"><a href="https://docs.google.com/forms/d/e/1FAIpQLScAfFLkcehxcbvWpjb5xPywOGsT1Djmp82k4wh81q14NDKVGA/viewform" target="_blank">Survey of media workflows for OpenRefine and Wikimedia Commons users</a></span></span></li></ul><ul style="text-align: left;"><li><span style="white-space: pre-wrap;"><span style="font-family: arial;"><a href="https://openrefine.limesurvey.net/155968?lang=en" target="_blank">OpenRefine's two-yearly user survey will run for approximately a month. We have the survey in three languages this year: English, Spanish and Dutch.</a></span><br /></span></li></ul><div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial;">Releases</span></h3></div></div><div><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://www.aarnet.edu.au/providing-more-flexibility-for-researchers-in-cloudstor-swan" target="_blank"><span style="font-family: arial;">Providing more flexibility for researchers in CloudStor SWAN by supporting OpenRefine #JupyterNotebooks </span></a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://github.com/preftech/reconciliation" target="_blank"><span style="font-family: arial;">OpenRefine Reconciliation Framework in Python and Flask</span></a></span></li></ul><ul style="text-align: left;"><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://github.com/AtesComp/rdf-transform" target="_blank"><span style="font-family: arial;">RDF Transform is an extension for OpenRefine to transform data into RDF formats.</span></a></span></li><ul><li><span style="background-color: white; color: #0f1419; white-space: pre-wrap;"><a href="https://github.com/AtesComp/rdf-transform/releases/tag/v2.0.4-beta?utm_sq=h1nv52etoa" target="_blank"><span style="font-family: arial;">RDF Transform 2.0.4-beta</span></a></span></li></ul></ul><ul style="text-align: left;"><li><span style="background-color: white; color: #24292f;"><span style="font-family: arial;"><a href="https://github.com/gitonthescene/csv-reconcile/releases/tag/v0.3.1?utm_sq=h1qktv525v" target="_blank">CSV Reconcile Release bygitonthescene v0.3.1</a></span></span></li><li><div><h3 style="background-color: white; color: #424242; line-height: 1; margin-bottom: 16px;"><span style="font-weight: normal;"><a href="https://github.com/RefinePro/OpenRefine_local_file_extension" rel="nofollow"><span style="font-family: arial; font-size: small;">OpenRefine File Extension: to access file hosted on an hosted instance of OpenRefine</span></a></span></h3></div></li></ul><ul style="text-align: left;"><li><a href="https://github.com/RefinePro/OpenRefine_Authenticator" target="_blank">OpenRefine Authenticator: to add authentication protocols for HTTP/HTTPS request.<br /><br /></a></li></ul></div></div><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Tutorials and Videos</span></h3><div><span><div><ul style="background-color: white; text-align: left;"><li><span style="font-family: arial;"><b>German Tutorials:</b></span></li><ul><li><span style="font-family: arial;"><a href="https://slides.lobid.org/2022-halle-reconcile/#/" target="_blank">Integration externer Normdatenquellen für Abgleich und Anreicherung lokaler Daten in OpenRefine</a></span></li><li><span style="font-family: arial;"><a href="https://fdmlab.landesarchiv-bw.de/post/2022-04-openrefine-workshop-veroeffentlicht/" target="_blank">OpenRefine Workshop für Einsteiger veröffentlicht</a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><span style="font-family: arial;"><b>English Tutorial:</b></span></li><ul><li><span style="white-space: pre-wrap;"><span style="font-family: arial;"><a href="https://openmethods.dariah.eu/2022/04/27/getting-started-with-openrefine-digital-humanities-201/" target="_blank">Getting started with OpenRefine – Digital Humanities 201</a></span></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><span style="font-family: arial;"><b>English Videos:</b></span></li><ul><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=WprFPkUqFek&ab_channel=FairData" target="_blank">Waiting list data openrefine reconciliation</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://vimeo.com/696188267" target="_blank">SNAC Cooperative: Community and Technology Update</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=evECRxT5gP4&ab_channel=GlobalInvestigativeJournalismNetwork" target="_blank">#GIJC21 - Tools to Clean Data</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=5SwRPOoZXgI&ab_channel=omnomdombomb" target="_blank">Programmatic Metadata Enhancement with OpenRefine DEGS 2022</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=6fm29SzaQ7g&ab_channel=RefinePro" target="_blank">OpenRefine Authenticator Demo</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/user/tgratgra1" target="_blank">The YouTube channel abc uploaded a series of videos on OpenRefine</a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><span style="font-family: arial;"><b>Italian Video:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=oEbzCICF4PY&ab_channel=ConvegnoStelline" target="_blank"><span style="font-family: arial;">Zotero, Mendeley, Endnote, Openrefine nelle attività di ricerca e nei flussi di lavoro in biblioteca</span></a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><span style="font-family: arial;"><b>Spanish Video:</b></span></li><ul><li><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=tIzkYUFRt5k&ab_channel=GRICUPRM" target="_blank">Introducción a OpenRefine Limpieza de datos previo al análisis (18 de marzo de 2022)</a></span></li></ul></ul></div><div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Academic Publications</span></h3></div><div><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://twitter.com/DigitizeUBC/status/1513555027385888774" target="_blank"><span style="font-family: arial;">Mention of OpenRefine in "Metadata Cleanup for the UBC Institute of Fisheries Field Records Collection"</span></a></span></li></ul><ul><li><span style="background-color: white; white-space: pre-wrap;"><span style="font-family: arial;"><a href="https://knowledge.e.southern.edu/cgi/viewcontent.cgi?article=1161&context=crd" target="_blank">Use of OpenRefine in "* Interactive Earthquake Visualization with Open Data"</a></span></span></li></ul><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://digitize.library.ubc.ca/digitizers-blog/metadata-cleanup-for-the-alma-mater-society-image-collection/" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Metadata Cleanup for the Alma Mater Society Image Collection"</span></a></span></li></ul></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-893640999138718832022-04-17T07:53:00.005-04:002023-07-21T03:00:15.075-04:00 Hosting OpenRefine in 2022<p>Hosting OpenRefine is a long-asked feature from the community. Natively, OpenRefine is designed to run on the user's local machine. Therefore, the software does not include user management, permission, or sharing the compute resources (CPU, RAM) with other users. </p><p>Hosting OpenRefine allows access to multiple users. Use cases include</p><p></p><ul style="text-align: left;"><li>Ease of access to the tool for users with limited permission on their computer or during events (training, hackathons, for example). </li><li>Allow working on larger dataset using more powerful online server - although OpenRefine 4.x with Spark is addressing this issue.</li><li>Collaboration with multiple user working on the same projects. </li><li>Enable hosting in a secured environment to process sensitive data (ie. the data does not go on the user machine)</li></ul><h3 style="text-align: left;">Hosted Instance with htpasswd </h3><div>or any other type of access control to the machine like RDP or shared user account on the machine. In that case OpenRefine is installed as a regular software on an machine that is access remotely. </div><p>Back in 2014, at RefinePro we built a service to manage users and instances of OpenRefine hosted using AWS EC2 instances. Our platform was basically</p><p></p><ul style="text-align: left;"><li>logging users</li><li>starting their EC2 instance</li><li>loading their project workspace on the EC2</li><li>shutting down the EC2 instance once the user finished their work. The goal is to not incurred unnecessary hosting cost. </li></ul><p></p><p>We used htpasswd to protect the instance from being publicly available. At the time, we found a way to hide the extra logging from our users, but things remained hacky and not suitable for the long run. Therefore, we<a href="https://refinepro.com/blog/sunset-for-refinepro-public-openrefine-hosting/ "> decided to stop the service in 2017</a>.</p><h3 style="text-align: left;">Hosting with JupyterHub</h3><p>In the last two years, we have seen an increasing number of hosted OpenRefine deployments based on Jupyter and JupyterHub (with Kubernetes). In those deployments, OpenRefine is one of the applications hosted via JupyterHub as part of a larger data science workbench. OpenRefine benefits from JupyterHub user and environments management. </p><p>As of April 2022, there are several publicly advertised JupytherHub deployments, including:</p><p></p><ul style="text-align: left;"><li><a href="https://wikitech.wikimedia.org/wiki/PAWS">Wikimedia PAWS</a></li><li><a href="https://www.aarnet.edu.au/providing-more-flexibility-for-researchers-in-cloudstor-swan">CloudStor SWAN</a></li><li>Tony Hirst is continuing his work on the <a href="https://github.com/innovationOUtside/nb_serverproxy_openrefine/">nb_serverproxy_openrefine </a></li><li>The <a href="https://github.com/betatim/openrefineder">MyBinder project</a> </li><li>We also heard of a few other private deployments. </li></ul><div>RefinePro also released in collaboration with FAIRPlus <a href="https://kb.refinepro.com/2022/04/introducing-openrefine-authenticator.html">one extension and docker customizable docker</a> to help with hosted instances. </div><p></p><h3 style="text-align: left;">Looking ahead </h3><p>Following on the idea from Felix Lohmeier and Tony Hirch on <a href="https://github.com/OpenRefine/OpenRefine/wiki/Jupyter ">OpenRefine wiki</a> ; I think it would be interesting to develop an official OpenRefine package for JupyterHub. Such package will include docker configuration specific to JupyterHub, dedicated OpenRefine extensions (like the <a href="https://github.com/RefinePro/OpenRefine_local_file_extension">local file extension</a>) along with best practices. </p><p>The creation and maintenance of the package will provide the community with an official way to host OpenRefine. It will also offer a point of contact for potential contributors to improve the package or OpenRefine itself. </p><p>I am interested in your thoughts and potential interest in building this package. </p>magdmartinhttp://www.blogger.com/profile/02680536297206242029noreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-68391522813888252082022-04-17T07:51:00.002-04:002022-04-19T09:19:35.301-04:00Introducing OpenRefine Authenticator and File Extensions<p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">The RefinePro team is thrilled to release under the Apache License 2.0 two new extensions for the OpenRefine ecosystem. The extensions have been funded and developed in partnership with Novartis, with the technical help of Aridhia Informatics. They are released under the </span><a class="editor-rtfLink" href="https://github.com/FAIRplus" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #4a6ee0; margin-bottom: 0pt; margin-top: 0pt;" target="_blank"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">FAIRplus</span></a><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"> program. </span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><br /></span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Thank you to Jiangbo Dang, </span><a class="editor-rtfLink" href="https://mobile.twitter.com/andsplend" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #4a6ee0; margin-bottom: 0pt; margin-top: 0pt;" target="_blank"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Andrea Splendiani</span></a><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">, and </span><a class="editor-rtfLink" href="https://twitter.com/rodrigobarnes" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #4a6ee0; margin-bottom: 0pt; margin-top: 0pt;" target="_blank"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Rodrigo Barnes</span></a><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"> for your help. </span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><br /></span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Feel free to <a href="https://refinepro.com/contact/" target="_blank">reach out if you have questions</a>. You can also open issue in each respective repository </span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><br /></span></p><h3 style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span><a name='more'></a></span></h3><h3 style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">OpenRefine Authenticator </span></h3><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><strong style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><br /></strong></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><strong style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Repository</strong><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">: </span><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><a href="https://github.com/RefinePro/OpenRefine_Authenticator">https://github.com/RefinePro/OpenRefine_Authenticator</a></span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><br /></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">OpenRefine's extension to add authentication protocols for HTTP/HTTPS request. Compatible with OpenRefine 3.3 and supporting:</span></p><ul style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><li style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; list-style-type: disc; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Custom applications with JWT tokens</span></li><li style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; list-style-type: disc; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Basic authentication (login password)</span></li></ul><div><span style="color: #0e101a;"><br /></span></div><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">The extension allows passing credentials when</span></p><ul style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><li style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; list-style-type: disc; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Creating a project from Web Addresses (URLs):</span></li><li style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; list-style-type: disc; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Adding a column by fetching URLs based on this column</span></li><li style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; list-style-type: disc; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Calling a reconciliation service via OpenRefine native interface</span></li><li style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; list-style-type: disc; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Calling an RDF endpoint using the </span><a class="editor-rtfLink" href="https://www.blogger.com/blog/post/edit/9131630574265701964/6839152281388825208#" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #4a6ee0; margin-bottom: 0pt; margin-top: 0pt;" target="_blank"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">RDF extension</span></a></li></ul><p><span style="color: #0e101a;">We recorded a brief demo (without sound) to create a project using a file behind a login/password. </span> </p><div><div><br /></div></div><div><iframe allowfullscreen="" class="BLOG_video_class" height="266" src="https://www.youtube.com/embed/6fm29SzaQ7g" width="320" youtube-src-id="6fm29SzaQ7g"></iframe></div><div><br /></div><h3 style="text-align: left;">OpenRefine File Extension</h3><p><b>Repository</b>: <a href="https://github.com/RefinePro/OpenRefine_local_file_extension">https://github.com/RefinePro/OpenRefine_local_file_extension</a></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">The File Extension addresses the challenges when a user tries to upload a large file into OpenRefine in a hosted environment. </span><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">When using </span><em style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Create a project from this computer</em><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">, OpenRefine needs to upload over an Internet connection the file with the risk of time out and network transmission error. Thanks to the </span><em style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">File Extension,</em><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"> the user can upload first the file on the instance before creating the project. </span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><br /></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">The </span><em style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">File Extension</em><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"> also lets administrators package OpenRefine docker images with preloaded datasets that users can access in a secure environment - when organizing training, for example. </span></p><h3>Docker Image</h3><p><b>Repository</b>: <a href="https://github.com/RefinePro/OpenRefine_Docker">https://github.com/RefinePro/OpenRefine_Docker</a></p><p><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;">During the </span><em style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;">docker build ...</em><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"> command, you can set the following arguments to disable any menus from the </span><em style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;">Create Project</em><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"> page. This option lets the system administrators control how users can import data into the OpenRefine instance. For example, in a secure, you can limit import to only what is available on the OpenRefine instance using </span><em style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;">Workspace Data </em><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;">and prevent users from importing new data into the instance.</span></p><h3 style="text-align: left;"><br /></h3>magdmartinhttp://www.blogger.com/profile/02680536297206242029noreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-30993435062446690392022-03-30T16:44:00.002-04:002022-03-31T09:12:36.303-04:00OpenRefine March 2022 Review<p><span style="font-family: arial;">Happy April! For this month, we decided to share the most relevant and helpful OpenRefine March 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhETR09UQmgpPqvBf38E7bmEUfSFKHpjf9OHwsKDYtAziKcWzAPpwM0XDvsk9pZY-r8Ba3An4dt1zIR0DqQgmRruH3GaprpERtwFX-65ZQk1TbDNBwoauyGlZoGR4Do5m8YBS9gJ1oplDyFautVIwUVbqY9uKxBJbh1ePhIW2XGCGKKH2gvoec7hxOB/s1024/March%202022%20Blogger%20(1).jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhETR09UQmgpPqvBf38E7bmEUfSFKHpjf9OHwsKDYtAziKcWzAPpwM0XDvsk9pZY-r8Ba3An4dt1zIR0DqQgmRruH3GaprpERtwFX-65ZQk1TbDNBwoauyGlZoGR4Do5m8YBS9gJ1oplDyFautVIwUVbqY9uKxBJbh1ePhIW2XGCGKKH2gvoec7hxOB/s320/March%202022%20Blogger%20(1).jpg" width="320" /></a></div><p></p><p></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</b></span></span></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial;">Community Announcements</span></h3><div><ul><li><span face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif" style="background-color: white; font-family: arial; white-space: pre-wrap;"><a href="https://openrefine.org/blog/2022/03/03/project-director.html" target="_blank">OpenRefine welcomes Sandra Fauconnier as project director</a></span></li></ul><ul><li><span face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif" style="background-color: white; font-family: arial; white-space: pre-wrap;"><a href="https://groups.google.com/g/openrefine/c/bvaPTSuZUd0?pli=1" target="_blank">Monthly office hours for OpenRefine users in the Wikimedia community</a></span></li></ul><ul><li><span face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif" style="background-color: white; font-family: arial; white-space: pre-wrap;"><a href="https://bit.ly/3tACRt3" target="_blank">Very soon 💎 @OpenRefine 💎 will do its two-yearly user survey again. Who wants to help translate the survey to their language</a>?</span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Video</span></h3><div><span><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>English Video:</b></span></li><ul><li><span face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif" style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=_PWmEBNQJ-o&ab_channel=MetropolitanNewYorkLibraryCouncil" target="_blank">Managing Messy Data, Part 1: Squirrely Data in OpenRefine</a></span></li></ul></ul></div><div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Academic Publications</span></h3></div><div><ul><li><span style="font-family: arial;"><a href="https://books.google.cl/books?hl=en&lr=&id=kPhiEAAAQBAJ&oi=fnd&pg=PR5&dq=openrefine&ots=SbnYNVZaoA&sig=KpPMNoExj_QE9WmeD7bQjvwnr2M&redir_esc=y#v=onepage&q=openrefine&f=false" target="_blank">Mention of OpenRefine in "Bibliometric Analysis using R for Non-Coders: A practical handbook in conducting bibliometric analysis studies using Biblioshiny for Bibliometrix R package."</a></span></li></ul><ul><li><a href="https://ojs.uwaterloo.ca/index.php/acmla/article/view/4873" target="_blank"><span style="font-family: arial;">OpenRefine: An Approachable Open Tool to Clean Research Data</span></a><span style="font-family: arial;"></span></li></ul></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-26387059246404831922022-03-04T13:49:00.001-05:002022-03-04T13:49:28.667-05:00OpenRefine February 2022 Review<p><span style="font-family: arial;">Happy March! For this month, we decided to share the most relevant and helpful OpenRefine February 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEj7MpRVweVdl7D_1-KLFclafWZ5jroesQE5IE49y5m0rA6BNEfnJrULtMcy1QEGz0RCDN7ZDLPIgGWoFnCE7YmKURV4r6rGpAbzkUHrcWuMcPPVMgtBM6LFSdHXvGDie2OZ3SFQ0EQsQ_xxle_cQrKwxjrT8NADLkgxL8QvuS3Iur4xc5O0p4XCWTRJ=s1024" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/a/AVvXsEj7MpRVweVdl7D_1-KLFclafWZ5jroesQE5IE49y5m0rA6BNEfnJrULtMcy1QEGz0RCDN7ZDLPIgGWoFnCE7YmKURV4r6rGpAbzkUHrcWuMcPPVMgtBM6LFSdHXvGDie2OZ3SFQ0EQsQ_xxle_cQrKwxjrT8NADLkgxL8QvuS3Iur4xc5O0p4XCWTRJ=s320" width="320" /></a></div><p></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</b></span></span></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="box-sizing: border-box; font-family: arial;">Community Announcements</span></h3><div><ul style="text-align: left;"><li><span style="box-sizing: border-box; font-family: arial;"><a href="https://www.outreachy.org/apply/project-selection/#openrefine" target="_blank">In May-August 2022, @OpenRefine welcomes @outreachy internships again! 💎💫💻🎉 Do you want to join us in making our popular, open-source data cleaning tool even better? Take a look at our proposed internship projects!</a>}</span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Tutorials and Videos</span></h3><div><span style="font-family: arial;"><ul style="background-color: white;"><li style="font-family: "Times New Roman";"><span style="font-family: arial;"><b>English Tutorial:</b></span></li><ul><li><span face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif" style="white-space: pre-wrap;"><a href="http://zbw.eu/labs/en/blog/how-to-matching-multilingual-thesaurus-concepts-with-openrefine" target="_blank">How-to: Matching multilingual thesaurus concepts with OpenRefine</a></span></li></ul></ul></span></div><div><span><div><ul style="background-color: white; text-align: left;"><li><span style="font-family: arial;"><b>English Videos:</b></span></li><ul><li><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=AN5_QAIyrvk&ab_channel=DublinCoreMetadataInitiative%28DCMI%29" target="_blank">DCMI Webinar: Introduction to OpenRefine</a></span></li><li><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=Xdul6Fue1jo&ab_channel=AnasMasum" target="_blank">CSE 424 submission1 OpenRefine</a></span></li></ul></ul></div><div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Academic Publications</span></h3></div><div><ul style="text-align: left;"><li><span style="font-family: arial;"><a href="https://www.acervodigital.ufpr.br/handle/1884/73334" target="_blank">Use of OpenRefine in "Desenvolvimento e comunicação midiática : a cobertura da Rede Paranaense de Comunicação (RPC) na discussão sobre a implantação da Zona Especial Portuária em Pontal do Paraná"</a></span></li><li><span style="font-family: arial;"><a href="https://infoteka.bg.ac.rs/ojs/index.php/Infoteka/article/view/2021.21.2.4_en/260" target="_blank"><span><google-sheets-html-origin>Use of OpenRefine in: </google-sheets-html-origin></span>"Serbian ELTeC Sub-collection in Wikidata"</a></span></li></ul></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-4232686480129517192022-02-02T09:54:00.007-05:002022-10-24T09:44:16.591-04:00Visual Web Ripper (VWR) End of Life <p> </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEg35c88HoSYk5SmLj3dBOXQTUxzNYbmw9Dh_fNVaMpwCF0LWJL0EOSDK5yrfNwG9SPU27FTGj1eMl9s0XjuoPDVrNgChsS2luL0Rtuia8FFyAS4a4Ki716EDOBO2cZGTPS18JdzWe34KmdEqtcoW7ih3267E_HWcdh7cF6ULd6ClttsQvfGeJF_rU3eAQ" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="50" data-original-width="173" height="92" src="https://blogger.googleusercontent.com/img/a/AVvXsEg35c88HoSYk5SmLj3dBOXQTUxzNYbmw9Dh_fNVaMpwCF0LWJL0EOSDK5yrfNwG9SPU27FTGj1eMl9s0XjuoPDVrNgChsS2luL0Rtuia8FFyAS4a4Ki716EDOBO2cZGTPS18JdzWe34KmdEqtcoW7ih3267E_HWcdh7cF6ULd6ClttsQvfGeJF_rU3eAQ" width="320" /></a></div><br /><p></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Visual Web Ripper was one of the first point-and-click web scraping software released over ten years ago and developed by </span><a class="editor-rtfLink" href="https://www.sequentum.com/" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #4a6ee0; margin-bottom: 0pt; margin-top: 0pt;" target="_blank"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">Sequentum</span></a><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">. Since June 30, 2022, Sequentum deprecated the license server for VWR. As a result, all Visual Web Ripper licenses are inactive, and users can no longer run their projects.</span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><br /></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">In this post, we highlight several key dates in VWR end of life. Sequentum provides a </span><a class="editor-rtfLink" href="https://support.sequentum.com/hc/en-us/articles/360018046373-Converting-Visual-Web-Ripper-Projects" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #4a6ee0; margin-bottom: 0pt; margin-top: 0pt;" target="_blank"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">migration path from VWR to its latest technology</span></a><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;">.</span></p><span><a name='more'></a></span><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><br /></p><h3 style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">Do you need help with your Visual Web Ripper Project? </h3><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><br /></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><a href="https://refinepro.com/contact/" target="_blank">Contact RefinePro</a> if you need help to </p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"></p><p></p><p></p><ul style="text-align: left;"><li><span style="color: #0e101a;">Migrate existing Visual Web Ripper projects to another web scraping solution</span></li><li><span style="color: #0e101a;">Convert your Visual Web Ripper projects to Sequentum’s latest technology and run your scrapers on RefinePro shared infrastructure.</span></li></ul><h3 style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">Visual Web Ripper Key Dates</h3><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><br /></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><b>In 2018</b>, Sequentum stopped maintaining the software and replaced it with Content Grabber as their technology evolved. </span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><br /></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><b>In December 2020,</b> the software was officially deprecated, and its official website is no longer active. </span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><br /></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><b>Around September 2021</b>, Sequentum updated its domain which has caused the Visual Web Ripper (VWR) license server to no longer be found when VWR agents startup. </span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><br /></span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;">It causes the following error in Visual Web Ripper: <i>unexpected error. The remote name could not be resolved </i></span><span style="color: #0e101a;"><i> lic.visualwebripper.com</i></span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><br /></span></p><p style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #0e101a; margin-bottom: 0pt; margin-top: 0pt; text-align: left;"><span data-preserver-spaces="true" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; margin-bottom: 0pt; margin-top: 0pt;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiJnbDENv6wpUPK3vna3ta8pZ5DrxMGLMrtDikjc0B3N5LlF5-sJ4XC7zgJaBTTDPjxA-wrP7fA-vxQUgCzVas_FKMukb9zckNGEuEi4liv-pOnnV6deo0_tj5krM3aCMmpeE_QRSKSIAYnPMe_rUqe3u9qB4MayheAVvFrPX8d1Da_LceeyrdvgoRgJQ" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img alt="" data-original-height="840" data-original-width="1122" height="297" src="https://blogger.googleusercontent.com/img/a/AVvXsEiJnbDENv6wpUPK3vna3ta8pZ5DrxMGLMrtDikjc0B3N5LlF5-sJ4XC7zgJaBTTDPjxA-wrP7fA-vxQUgCzVas_FKMukb9zckNGEuEi4liv-pOnnV6deo0_tj5krM3aCMmpeE_QRSKSIAYnPMe_rUqe3u9qB4MayheAVvFrPX8d1Da_LceeyrdvgoRgJQ=w396-h297" width="396" /></a></span></p><p>Sequentum issued a quick software update to remove VWR's dependency on our domain. Please install this update to all machines where Visual Web Ripper is running: https://download.sequentum.com/vwr_fix.zip</p><p>Sequentum has also set up the following portal to provide you immediate access to your Visual Web Ripper User Account: http://support.vwr.sequentum.com/Login.aspx?st=</p><p><span style="color: #0e101a;"><b>On June 30, 2022,</b> Sequentum deprecated the license server for VWR. Visual Web Ripper stopped working, and projects cannot be executed.</span></p><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><p></p>magdmartinhttp://www.blogger.com/profile/02680536297206242029noreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-54155978170375582782022-01-31T17:16:00.000-05:002022-01-31T17:16:33.106-05:00OpenRefine January 2022 Review<p><span style="font-family: arial;">Happy February! For this month, we decided to share the most relevant and helpful OpenRefine January 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEh3LmlEVojDIJEiBjdoTiZkXslSGsG_5LxBdL7y652WMYz8fBhsAN8ChXUMDt8pVSW5Av1jJpeRQJFOrQ41YKsL_n-Bl4Css_bjK0hPxoCgN-L1CseCv4xkz0UeAM5CicP34XlqEd9f4ut5oOe6L-HdA0jgOZMkqaD1gfiH1hpDjZcmo_9XC5yANtFr=s1024" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/a/AVvXsEh3LmlEVojDIJEiBjdoTiZkXslSGsG_5LxBdL7y652WMYz8fBhsAN8ChXUMDt8pVSW5Av1jJpeRQJFOrQ41YKsL_n-Bl4Css_bjK0hPxoCgN-L1CseCv4xkz0UeAM5CicP34XlqEd9f4ut5oOe6L-HdA0jgOZMkqaD1gfiH1hpDjZcmo_9XC5yANtFr=s320" width="320" /></a></div><p></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</b></span></span></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Release</span></h3><div style="background-color: white;"><ul><li><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.5.2?utm_sq=gyra03ahlj" target="_blank"><span style="font-family: arial;">OpenRefine v3.5.2 by wetneb</span></a></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Tutorials and Videos</span></h3><div><span style="font-family: arial;"><ul style="background-color: white;"><li style="font-family: "Times New Roman";"><span style="font-family: arial;"><b>English Tutorials:</b></span></li><ul><li><a href="https://digitalorientalist.com/2022/01/04/data-cleaning-chinese-text-with-openrefine-facet/" target="_blank">Data Cleaning Chinese Text with OpenRefine: Facet</a></li><li><a href="https://www.opensanctions.org/articles/2022-01-10-openrefine-reconciliation/" target="_blank">How to sanctions-check a spreadsheet using OpenRefine</a><span style="white-space: pre-wrap;"></span></li></ul></ul></span></div><div><span><ul style="background-color: white;"><li><span style="font-family: arial;"><b>German Tutorial:</b></span></li><ul><li><span style="font-family: arial;"><a href="https://blog.lobid.org/2022/01/20/reconciliation-api-beitrag.html" target="_blank">Ein Protokoll für den Datenabgleich im Web am Beispiel von OpenRefine und der Gemeinsamen Normdatei (GND)</a></span></li></ul></ul><ul style="background-color: white;"><li><b><span style="font-family: arial;">English Videos:</span></b></li><ul><li><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=knY30zUmkGI&ab_channel=wikimediaDE" target="_blank">Wikibase lightning talks: data upload and extensions session (WikidataCon 2021 recording)</a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=cX_2MkShlJk&ab_channel=IITMadras-BScDegreeProgramme" target="_blank"><span style="font-family: arial;">Prepare the data: Cleaning with OpenRefine</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=KJgpjwzVsqk&ab_channel=KnowledgeBase" target="_blank"><span style="font-family: arial;">HTML : Extract a html tag that contains a string in openrefine?</span></a></span></li></ul></ul><div><ul><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Spanish Videos:</b></span></span></li><ul><li style="background-color: white; box-sizing: border-box;"><span style="font-family: arial;">The YouTube channel <a href="https://www.youtube.com/channel/UCYpRC5LQNBb__yZTsnYcj3A" target="_blank">datosgob</a> released a series of OpenRefine tutorials:</span></li><ul><li style="background-color: white; box-sizing: border-box;"><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=9Dmb4CoYmec&ab_channel=datosgob" target="_blank">Preparación de datos en CSV utilizando OpenRefine: carga de CSV y creación de proyecto</a><span style="white-space: pre-wrap;"></span></span></li><li style="background-color: white; box-sizing: border-box;"><a href="https://www.youtube.com/watch?v=uoFtfWLwhfk&ab_channel=datosgob" target="_blank"><span style="font-family: arial;">Preparación de datos en CSV utilizando OpenRefine: modificación de columnas usando funciones GREL</span></a></li><li style="background-color: white; box-sizing: border-box;"><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=wXFCPXgS3RI" target="_blank"><span style="font-family: arial;">Preparación de datos en CSV utilizando OpenRefine: enlazado de valores con fuentes externas</span></a></span></li><li style="background-color: white; box-sizing: border-box;"><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=H8vKkU0ie9E&ab_channel=datosgob" target="_blank"><span style="font-family: arial;">Preparación de datos en CSV utilizando OpenRefine: generación valores para listas controladas SKOS</span></a></span></li></ul></ul></ul></div><ul style="text-align: left;"><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>French Video:</b></span></span></li><ul style="background-color: white;"><li style="box-sizing: border-box;"><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=OCAcNsJgwZM&ab_channel=NicolasVIGNERON" target="_blank"><span style="font-family: arial;">OpenRefine, Lexèmes et SPARQL</span></a></span></li></ul></ul><div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Academic Publication</span></h3></div><div><ul><li><a href="https://digital.sandiego.edu/symposium/2022/2022/15/" target="_blank"><span style="font-family: arial;"><span><google-sheets-html-origin>Use of OpenRefine in: </google-sheets-html-origin></span>"Evaluating Publisher Open Access Agreements"</span></a></li></ul></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-22314738290770614202022-01-04T05:27:00.000-05:002022-01-04T05:27:53.910-05:00OpenRefine December 2021 Review<p><span style="font-family: arial;">Happy January! We wish you a very Happy New Year! For the first month of the year, we decided to share the most relevant and helpful OpenRefine December 2021 community announcements, releases, tutorials, videos, and academic publications with you.</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEg508KlJpc9haCWVbxWv8ZZ9du8gsGgV4FjhL7xIAt5QbTbdLO8i5NU273UKiypoG_HMKADej2wopk8n4seM0sjnlmevvjjztcKgPcqnATry514U8vBqGqAaiuLvZtxliT14MJBpZEIw1myPiL6-bmTy1xnCMpeSEHU_uv9-kgHGYkVPZsp16RcW5f8=s1024" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/a/AVvXsEg508KlJpc9haCWVbxWv8ZZ9du8gsGgV4FjhL7xIAt5QbTbdLO8i5NU273UKiypoG_HMKADej2wopk8n4seM0sjnlmevvjjztcKgPcqnATry514U8vBqGqAaiuLvZtxliT14MJBpZEIw1myPiL6-bmTy1xnCMpeSEHU_uv9-kgHGYkVPZsp16RcW5f8=s320" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><p></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</b></span></span></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Community Announcements</span></h3><div style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><ul style="text-align: left;"><li><span style="white-space: pre-wrap;"><a href="https://openrefine.org/blog/2021/12/01/commons-project-team.html" target="_blank"><span style="font-family: arial;">Structured Data on Commons functionalities: welcome to OpenRefine's new team members!</span></a></span></li></ul><ul style="text-align: left;"><li><span style="white-space: pre-wrap;"><a href="https://openrefine.org/blog/2021/12/12/Advisory-committee-member.html" target="_blank"><span style="font-family: arial;">Join OpenRefine's Advisory Committee</span></a></span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Releases</span></h3><div style="background-color: white;"><ul style="text-align: left;"><li><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.5.1?utm_sq=gxjdlz51wq" target="_blank"><span style="font-family: arial;">OpenRefine v3.5.1 by wetneb</span></a></li></ul><ul style="text-align: left;"><li><span style="color: #24292f;"><span style="font-family: arial;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/4.0-alpha1" target="_blank">OpenRefine 4.0-alpha1 by wetneb</a></span></span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Tutorials and Videos</span></h3><div><span style="font-family: arial;"><ul style="background-color: white;"><li style="font-family: "Times New Roman";"><span style="font-family: arial;"><b>English Tutorials:</b></span></li><ul><li><a href="https://database.factgrid.de/resources/OpenRefine-2021-12-07.mp4" target="_blank">OpenRefine Tutorial on Using OpenRefine on FactGrid with Lucas Werkmeister</a></li><li><a href="https://publiclab.org/notes/fongvania/12-12-2021/data-cleaning-with-openrefine" target="_blank">Data Cleaning with OpenRefine</a><span style="white-space: pre-wrap;"></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.ontotext.com/blog/moving-from-spreadsheets-to-an-rdf-database/?utm_campaign=CS&utm_content=189976065&utm_medium=social&utm_source=twitter&hss_channel=tw-33893047" target="_blank">From Disparate Data to Visualized Knowledge Part I: Moving from Spreadsheets to an RDF Database</a></span></li></ul></ul></span></div><div><span><ul style="background-color: white;"><li><span style="font-family: arial;"><b>German Tutorials:</b></span></li><ul><li><a href="https://fdmlab.landesarchiv-bw.de/post/2021-12-gemeinsam-an-openrefine-projekten-arbeiten/" target="_blank"><span style="font-family: arial;">Gemeinsam an OpenRefine-Projekten arbeiten</span></a></li><li><span style="white-space: pre-wrap;"><a href="https://zenodo.org/record/5776098#.YbfBUL3MLrd" target="_blank"><span style="font-family: arial;">OpenRefine by Kathi Woitas, Digital Scholarship Services, Universitätsbibliothek Bern</span></a></span></li></ul></ul><ul style="background-color: white;"><li><b><span style="font-family: arial;">English Videos:</span></b></li><ul><li><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=vsiybhqy82g&ab_channel=CatholicUUniversityLibraries" target="_blank">CU Digital Scholarship Workshops [Fall 2021]: Using OpenRefine for Cleaning Data</a><br /></span></li><li><a href="https://www.youtube.com/watch?v=RhaDVmLT-Ck&ab_channel=WesternMichiganUniversityLibraries" target="_blank"><span style="font-family: arial;">Data Cleaning in OpenRefine (Library Skills Week 2021)</span></a></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=j5ZucdP1ykw&ab_channel=SWIB" target="_blank"><span style="font-family: arial;">String matching algorithms in OpenRefine clustering and reconciliation functions</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://vimeo.com/653877293" target="_blank"><span style="font-family: arial;">Introduction to OpenRefine: Using Open Software to Weed and Manage a Government Documents Collection</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=Zn793UQfaQc&ab_channel=RomanInflianskas" target="_blank"><span style="font-family: arial;">Creating items on Wikidata using OpenRefine (without sound — subtitles only)</span></a></span></li></ul></ul><div><ul><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Spanish Videos:</b></span></span></li><ul><li style="background-color: white; box-sizing: border-box;"><a href="https://www.youtube.com/watch?v=-VM8GwF_FY8&feature=youtu.be&ab_channel=GRICUPRM" target="_blank"><span style="font-family: arial;">Introducción a Open Refine</span></a></li><li style="background-color: white; box-sizing: border-box;"><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=Ox3yiU-HD4c&ab_channel=PaulaZermoglio" target="_blank"><span style="font-family: arial;">LIMPIEZA DE DATOS DE BIODIVERSIDAD con OpenRefine: Funciones básicas</span></a></span></li><li style="background-color: white; box-sizing: border-box;"><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=jDlXE83TXbk&ab_channel=PaulaZermoglio" target="_blank"><span style="font-family: arial;">LIMPIEZA DE DATOS DE BIODIVERSIDAD con OpenRefine: Funciones avanzadas</span></a></span></li></ul></ul></div><ul><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>French Video:</b></span></span></li><ul style="background-color: white;"><li style="box-sizing: border-box;"><a href="https://www.youtube.com/watch?v=OAuWu3o7dv0&ab_channel=LucGauvreau" target="_blank"><span style="font-family: arial;">De l'ocr vers Word pour OpenRefine: exemples de transformations</span></a></li></ul></ul><div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Academic Publications</span></h3></div><div><ul style="text-align: left;"><li><span style="font-family: arial;"><google-sheets-html-origin><a href="http://rcfba.fcfar.unesp.br/index.php/ojs/article/view/753" target="_blank">Use of OpenRefine in: "Reports of substandard medicines: a lexicographic analysis of the Brazilian Health Surveillance Report System"</a></google-sheets-html-origin></span></li></ul><ul style="text-align: left;"><li><span style="font-family: arial;"><a href="https://escholarship.umassmed.edu/neirug/2021/program/12/" target="_blank">Use of OpenRefine in: "Developing a Comprehensive Faculty Bibliography to Facilitate Scholarly Communications Outreach"</a></span></li></ul><ul style="text-align: left;"><li><span style="font-family: arial;"><a href="https://www.emerald.com/insight/content/doi/10.1108/JFBM-10-2021-0121/full/html" target="_blank">Use of OpenRefine in: "Mapping research on family business in tourism and hospitality: a bibliometric analysis"</a></span></li></ul><ul style="text-align: left;"><li><a href="https://github.com/eeditiones/tei-publisher-components/blob/4ca2b3d70055fa07d501e72c6648329996f6855a/src/authority/reconciliation.js" target="_blank"><span style="font-family: arial;">An example of an OpenRefine Reconciliation Service in Javascript</span></a></li></ul><ul style="text-align: left;"><li><a href="https://ui.adsabs.harvard.edu/abs/2021arXiv211208259N/abstract" target="_blank"><span style="font-family: arial;">or2yw: Modeling and Visualizing OpenRefineHistories as YesWorkflow Diagrams</span></a></li></ul><ul style="text-align: left;"><li><a href="https://oaktrust.library.tamu.edu/handle/1969.1/195023" target="_blank"><span style="font-family: arial;">Use of OpenRefine in "Preparing for a Name Disambiguation Application for Institutional Repositories at Texas A&M University: the Planning and Test Preparation Phases" by the Texas A&M University Libraries</span></a><br /></li></ul></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-481961694409890202021-12-01T11:41:00.003-05:002021-12-01T11:41:52.646-05:00OpenRefine November 2021 Review<p><span style="font-family: arial;">Happy December! Didn't 2021 just fly by? For the last month of this year, we decided to share the most relevant and helpful OpenRefine November 2021 community announcements, releases, tutorials, and videos with you.</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgwkL8Z1NAxbJJiAIC-vrMWBhWp2omAW1QoBkTnBee6ZalhF8WrYVy2exb0xzrw744izJHvKt6vS-MsjWaEMBhdnjC97xExUAfVKJ8KoNdBVdQLJx_1oOvGs_B1ycN63Nqfq_i2PTGqauDruVaioRVdnTG2mWeO-lN2xKWiMfVONDizmVrH_5jkJgsp=s1024" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/a/AVvXsEgwkL8Z1NAxbJJiAIC-vrMWBhWp2omAW1QoBkTnBee6ZalhF8WrYVy2exb0xzrw744izJHvKt6vS-MsjWaEMBhdnjC97xExUAfVKJ8KoNdBVdQLJx_1oOvGs_B1ycN63Nqfq_i2PTGqauDruVaioRVdnTG2mWeO-lN2xKWiMfVONDizmVrH_5jkJgsp=s320" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><p></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</b></span></span></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Community Announcements</span></h3><div style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px;"><ul style="text-align: left;"><li><span style="font-family: arial;">OpenRefine is looking for <a href="https://openrefine.org/blog/2021/11/05/Project-director.html" target="_blank">a Part-time Project Director</a>.</span></li></ul><ul style="text-align: left;"><li><span style="font-family: arial;"><a href="https://outreach.wikimedia.org/wiki/GLAM/Newsletter/October_2021/Contents/Structured_Data_on_Wikimedia_Commons_report" target="_blank">GLAM/Newsletter/October 2021/Contents/Structured Data on Wikimedia Commons report - A Wikimedia Commons Reconciliation Service, You Say?</a></span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Releases</span></h3><div style="background-color: white;"><ul><li><span style="font-family: arial;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.5.0?utm_sq=gw6ptswt9m" target="_blank"><span style="color: #24292f;">OpenRefine v3.5.0 by </span>wetneb</a></span></li></ul><ul><li style="box-sizing: border-box;"><span style="white-space: pre-wrap;"><span style="font-family: arial;"><a href="https://github.com/gitonthescene/csv-reconcile/releases/tag/v0.3.0?utm_sq=gwuwdce5v7" target="_blank">CSV Reconcile 3.0 Release - Change in server intialization by gitonthescene</a></span></span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Tutorials and Videos</span></h3><div><span><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>Spanish Tutorial:</b></span></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.academia.edu/62172704/Primeros_pasos_con_Open_Refine?email_work_card=view-paper" target="_blank"><span style="font-family: arial;">Primeros pasos con OpenRefine</span></a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><b><span style="font-family: arial;">Italian Videos:</span></b></li><ul><li><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=HhhuFsZO-zY&ab_channel=Wikidatainitaliano" target="_blank">OpenRefine, livello base</a></span></li><li><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=h5zP-vQcEO0&ab_channel=Wikidatainitaliano" target="_blank">OpenRefine, livello avanzato</a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><b><span style="font-family: arial;">English Videos:</span></b></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=a6SMftORFPs&ab_channel=CatholicUUniversityLibraries" target="_blank"><span style="font-family: arial;">CU Digital Scholarship Workshops [Fall 2021]: Using OpenRefine for Cleaning Data</span></a></span></li><li><span data-sheets-userformat="{"2":897,"3":{"1":0},"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"An approach to consolidate corporate material master data using free OpenRefine application and Semantic web ontology server"}"><a href="https://www.youtube.com/watch?v=Uqsrp04erfM" target="_blank"><span style="font-family: arial;">An approach to consolidate corporate material master data using free OpenRefine application and Semantic web ontology server</span></a></span></li></ul></ul><div><ul><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Spanish Video:</b></span></span></li><ul><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><a href="https://www.youtube.com/watch?v=etfFcchjP1Q&t=2s&ab_channel=SiBColombia" target="_blank">Ahorra tiempo y esfuerzo con #OpenRefine, valida datos por lotes bajo el estándar Darwin Core (DwC).: ¿Cómo usar Open Refine?</a></span></li></ul></ul></div><ul><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>French Video:</b></span></span></li><ul style="background-color: white;"><li style="box-sizing: border-box;"><span style="font-family: arial; white-space: pre-wrap;"><a href="https://vimeo.com/640025990" target="_blank">Journées Abes 2021 - Les demos des reseaux</a></span></li></ul></ul></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-10204480969876796932021-10-29T15:49:00.001-04:002021-10-29T15:49:24.382-04:00OpenRefine October 2021 Review<p><span style="font-family: arial;">Happy November to all! This month, we shared the most relevant and helpful OpenRefine October 2021 community announcements, releases, tutorials, videos, and academic publications with you.</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgeBm81HqwPDjxC-rlWVeAk2867GBNHFnUX4cfuvwwS3UToXTnVmJusbp1yASygXbN6NHXv1TZDiFmpNbf1-Q18cGYZRsonlab9-450rtLoavy3eBsaFep2ueu_GSYXaFmkKtRUfr4i2ZHrIlm2JY1NaegDgY1t6dTxNrpDIKqMx6e698N8UX25_zsD=s1024" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/a/AVvXsEgeBm81HqwPDjxC-rlWVeAk2867GBNHFnUX4cfuvwwS3UToXTnVmJusbp1yASygXbN6NHXv1TZDiFmpNbf1-Q18cGYZRsonlab9-450rtLoavy3eBsaFep2ueu_GSYXaFmkKtRUfr4i2ZHrIlm2JY1NaegDgY1t6dTxNrpDIKqMx6e698N8UX25_zsD=s320" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><p></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</b></span></span></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Community Announcements</span></h3><div style="background-color: white; box-sizing: border-box; line-height: 1; margin-bottom: 16px; text-align: left;">Check out these new OpenRefine reconciliation services found on <a href="https://reconciliation-api.github.io/testbench/" style="white-space: pre-wrap;">https://reconciliation-api.github.io/testbench/</a><span style="white-space: pre-wrap;">: </span></div><div style="background-color: white;"><div style="text-align: left;"><ul><li><span data-sheets-formula-bar-text-style="font-size:13px;color:#000000;font-weight:normal;text-decoration:none;font-family:'docs-Calibri';font-style:normal;text-decoration-skip-ink:none;" face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif" style="white-space: pre-wrap;"><a href="https://reconcile.ontotext.com/locations" target="_blank">The Ontotext Wikidata Location Reconciliation Service</a></span></li></ul><ul><li><span data-sheets-formula-bar-text-style="font-size:13px;color:#000000;font-weight:normal;text-decoration:none;font-family:'docs-Calibri';font-style:normal;text-decoration-skip-ink:none;" face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif" style="white-space: pre-wrap;"><a href="https://reconciliation.brickschema.org/reconcile" target="_blank">The Brick reconciliation service, for Brick, a uniform metadata schema for buildings</a></span></li></ul><ul><li><span data-sheets-formula-bar-text-style="font-size:13px;color:#000000;font-weight:normal;text-decoration:none;font-family:'docs-Calibri';font-style:normal;text-decoration-skip-ink:none;" face="Roboto, RobotoDraft, Helvetica, Arial, sans-serif" style="white-space: pre-wrap;">The <a href="https://commonsreconcile.toolforge.org/en/api" target="_blank">Wikimedia Commons reconciliation service</a>, developed by Eugene Egbe as part of our project to <a href="https://meta.wikimedia.org/wiki/Grants:Project/CS%26S/Structured_Data_on_Wikimedia_Commons_functionalities_in_OpenRefine" target="_blank">integrate OpenRefine with Wikimedia Commons</a>.</span></li></ul></div></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Releases</span></h3><div style="background-color: white;"><ul><li><span style="background-color: rgba(0, 0, 0, 0.004); color: #0f1419; white-space: pre-wrap;"><a href="https://github.com/OpenRefine/OpenRefine/releases/tag/3.5-beta2?utm_sq=gvs6ox3736" target="_blank"><span style="font-family: arial;">New OpenRefine release: v3.5-beta2</span></a></span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Tutorials and Videos</span></h3><div><span><div><ul style="background-color: white;"><li><span style="font-family: arial;"><b>English Tutorial:</b></span></li><ul><li><a href="https://outreach.wikimedia.org/wiki/GLAM/Newsletter/September_2021/Contents/Structured_Data_on_Wikimedia_Commons_report" target="_blank"><span style="font-family: arial;">First steps for Wikimedia Commons reconciliation service</span></a><span style="font-family: arial;"></span></li></ul></ul><ul style="background-color: white;"><li><b><span style="font-family: arial;">German Tutorials:</span></b></li><ul><li><span style="font-family: arial;"><a href="https://openschoolmaps.ch/pages/materialien.html" target="_blank">Daten sichten, bereinigen und integrieren mit OpenRefine Arbeitsblatt by Open School Maps</a><br /></span></li><li><span style="font-family: arial;"><a href="https://fdmlab.landesarchiv-bw.de/post/2021-10-clustering-von-namen-mit-openrefine/" target="_blank">Clustering von Namen mit OpenRefine</a><span data-sheets-userformat="{"2":897,"3":{"1":0},"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Fünf Dinge, die wir mit OpenRefine nicht (gerne) machen by the FDMLab"}"></span></span></li></ul></ul><ul style="background-color: white;"><li><b><span style="font-family: arial;">English Videos:</span></b></li><ul><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=AW89di7ljeA&ab_channel=WikipediaWeekly" target="_blank"><span style="font-family: arial;">Wikipedia Weekly Network - LIVE Wikidata editing #55 OpenRefine</span></a></span></li><li><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=EkxvbiiGXRA&ab_channel=CoryRandolph" target="_blank">Open Refine - Converts JSON response to CSV</a><br /></span></li><li><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=o5VgSmkKMmM&ab_channel=ManjiriKadam" target="_blank">Assignment 1: Data cleaning with Openrefine (CMPE 255) Manjiri Kadam</a><span style="white-space: pre-wrap;"></span></span></li><li><a href="https://www.youtube.com/watch?v=nxbOXLsDpsA&ab_channel=%E5%AE%87%E5%AE%99%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E7%9F%A5%E8%AD%98%E3%83%97%E3%83%AA%E3%83%B3%E3%82%B7%E3%83%94%E3%82%A2" target="_blank"><span style="font-family: arial;">OpenRefine</span></a></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=_oOCckyLuqA&ab_channel=DataServicesatWashingtonUniversityLibraries" target="_blank"><span style="font-family: arial;">Exploring Your Data With Open Refine</span></a></span></li><li><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=n0ztK2LlBAo&ab_channel=SNACCooperative" target="_blank"><span style="font-family: arial;">SNAC OpenRefine Extension</span></a></span></li></ul></ul><div><ul style="text-align: left;"><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Portuguese Video:</b></span></span></li><ul><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><a href="https://www.youtube.com/watch?v=ihNcXSf7vUE&ab_channel=CaioC%C3%A9sar" target="_blank">Tratando dados de uma planilha utilizando o software OpenRefine</a></span></span></li></ul></ul></div><ul style="text-align: left;"><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Swedish Video:</b></span></span></li><ul style="background-color: white;"><li style="background-color: white; box-sizing: border-box;"><span style="white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=bTWtG3NA0uo&ab_channel=MagnusS%C3%A4lg%C3%B6" target="_blank"><span style="font-family: arial;">SPA API find same as Wikipedia and use OpenRefine in Swedish</span></a></span></li></ul></ul><ul style="text-align: left;"><li><b><span style="font-family: arial;">Spanish Video:</span></b></li><ul><li><span style="background-color: white; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=frhn6CEf96w&ab_channel=WikimediaArgentina" target="_blank"><span style="font-family: arial;">[Construyendo Wikidata] Bases de datos y Open Refine</span></a></span></li></ul></ul></div><div style="background-color: white;"><div style="box-sizing: border-box;"><span style="font-family: arial;"><div style="font-family: arial;"><ul></ul></div><div><h3 style="box-sizing: border-box; font-family: "Times New Roman"; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Academic Publications</span></h3><div><span style="font-family: arial;"><ul><li style="box-sizing: border-box; color: #424242;"><span style="color: black; white-space: pre-wrap;"><a href="https://www.researchgate.net/profile/Rodrigo-Nogueira-16/publication/354935392_ANALISE_E_IDENTIFICACAO_DE_UMA_REDE_DE_COLABORACAO_CIENTIFICA_um_estudo_de_caso_do_workshop_em_sistemas_de_informacao/links/6154f50839b8157d900db08d/ANALISE-E-IDENTIFICACAO-DE-UMA-REDE-DE-COLABORACAO-CIENTIFICA-um-estudo-de-caso-do-workshop-em-sistemas-de-informacao.pdf" target="_blank">Use of OpenRefine in "Análise e identificação de uma rede de colaboração científica: um estudo de caso do workshop em sistemas de informação"</a>
</span></li><li style="box-sizing: border-box; color: #424242;"><span style="color: black; white-space: pre-wrap;"><a href="https://www.degruyter.com/document/doi/10.1515/flin-2021-2038/html" target="_blank">IE6.com. Cleaning data with OpenRefine</a>
</span></li><li style="box-sizing: border-box; color: #424242;"><span style="color: black; white-space: pre-wrap;"><a href="https://pretalx.com/wdcon21/talk/AAVSZV/" target="_blank">Use of OpenRefine in Google Keynote "Improving knowledge availability for Buddhist entities through Wikidata"</a>
</span></li><li style="box-sizing: border-box; color: #424242;"><span style="color: black; white-space: pre-wrap;"><a href="https://digital.csic.es/handle/10261/252628" target="_blank">Use of OpenRefine in "Cómo gestionar los datos de investigación: buenas prácticas, estándares, herramientas. Prácticas"</a></span></li></ul></span></div></div></span></div></div></span></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-9131630574265701964.post-78915350891237951202021-09-30T13:30:00.004-04:002021-09-30T13:51:32.043-04:00OpenRefine September 2021 Review<p><span style="font-family: arial;">We wanted to wish you a very happy October! This month, we decided to share the most relevant and helpful OpenRefine September 2021 community announcements, releases, tutorials, videos, and academic publications with you.</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuMeXbiLyRFaeQbjlZBSv2U_fRntwTeKJWGP-niwRzpz3xcOErAhfPa1Y6mZrlvXeYOlQsDp2n0eFrutELA5UnrZx94BdKDnJLvJf9f-qdr_h54GJNJ5XfrsUOsvyPdJeNr4Cp0ozfz78/s1024/September+2021+Review.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="1024" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuMeXbiLyRFaeQbjlZBSv2U_fRntwTeKJWGP-niwRzpz3xcOErAhfPa1Y6mZrlvXeYOlQsDp2n0eFrutELA5UnrZx94BdKDnJLvJf9f-qdr_h54GJNJ5XfrsUOsvyPdJeNr4Cp0ozfz78/s320/September+2021+Review.jpg" width="320" /></a></div><p></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!</b></span></span></p><p style="background-color: white; box-sizing: border-box; font-size: 12px;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><span></span></span></span></p><a name='more'></a><div style="box-sizing: border-box;"><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;"></span></h3><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Community Announcements</span></h3><div style="background-color: white;"><ul><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://outreach.wikimedia.org/wiki/GLAM/Newsletter/August_2021/Contents/Structured_Data_on_Wikimedia_Commons_report" target="_blank">OpenRefine started Structured Data on Commons development in September 2021</a></span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Releases</span></h3><div style="background-color: white;"><ul><li><span style="color: #0f1419; font-family: arial; white-space: pre-wrap;">Experimental Debian Package<a href="https://ftp-master.debian.org/new/openrefine_3.5~git20210527-1.html" target="_blank">: OpenRefine Version: 3.5~git20210527-1 by Markus Koschany</a></span></li></ul></div><h3 style="background-color: white; box-sizing: border-box; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Tutorials and Videos</span></h3><div><span><div><ul style="background-color: white; text-align: left;"><li><span style="font-family: arial;"><b>Arabic Tutorial:</b></span></li><ul><li><span style="font-family: arial;"><a href="https://ijnet.org/ar/story/%D9%85%D9%82%D8%AF%D9%85%D8%A9-%D8%A5%D9%84%D9%89-%D8%A3%D8%AF%D8%A7%D8%A9-%D8%AA%D9%86%D8%B8%D9%8A%D9%81-%D8%A7%D9%84%D8%A8%D9%8A%D8%A7%D9%86%D8%A7%D8%AA-openrefine" target="_blank">مقدمة إلى أداة تنظيف البيانات OpenRefine</a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li><b><span style="font-family: arial;">German Tutorials:</span></b></li><ul><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://fdmlab.landesarchiv-bw.de/post/2021-09-fuenf-dinge-die-wir-an-openrefine-moegen/" target="_blank">Fünf Dinge, die wir an OpenRefine mögen by the FDMLab</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://fdmlab.landesarchiv-bw.de/post/2021-09-erfahrungsbericht-extraktion-und-abgleich-von-prokuratoren-mit-openrefine/" target="_blank">Erfahrungsbericht - Extraktion und Abgleich von Prokuratoren mit OpenRefine by Landesarchiv Baden-Württemberg's FDMLab</a></span></li><li><span data-sheets-userformat="{"2":897,"3":{"1":0},"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Fünf Dinge, die wir mit OpenRefine nicht (gerne) machen by the FDMLab"}"><a href="https://fdmlab.landesarchiv-bw.de/post/2021-09-fuenf-dinge-die-wir-mit-openrefine-nicht-machen/" target="_blank"><span style="font-family: arial;">Fünf Dinge, die wir mit OpenRefine nicht (gerne) machen by the FDMLab</span></a></span></li></ul></ul><ul style="background-color: white; text-align: left;"><li style="font-family: arial;"><b>Spanish Videos:</b></li><ul><li><a href="https://www.youtube.com/watch?v=0Q27arNeHj0&ab_channel=TatianaRuizPuerto" style="font-family: arial; white-space: pre-wrap;" target="_blank">OpenRefine identificación de errores de datos abiertos. Maxima velocidad.</a></li><li style="font-family: arial;"><a href="https://www.youtube.com/watch?v=vuoalIbYoeQ&ab_channel=TatianaRuizPuerto" style="white-space: pre-wrap;" target="_blank">OpenRefine corrección de errores de datos abiertos de Máxima velocidad.</a></li><li><a href="https://www.youtube.com/watch?v=lqaMhwUWZR0&ab_channel=CarlosAlfonsoTrujillo" style="font-family: arial; white-space: pre-wrap;" target="_blank">Errores en el conjunto de datos Supervisa OpenRefine</a></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=pQN0hGpu_uI&ab_channel=CarlosAlfonsoTrujillo" target="_blank">Depuracion Supervisa OpenRefine</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.facebook.com/watch/live/?v=1161724217647917&ref=watch_permalink" target="_blank">Uso de herramientas de software libre OpenRefine</a></span></li><li><span data-sheets-userformat="{"2":897,"3":{"1":0},"10":1,"11":4,"12":0}" data-sheets-value="{"1":2,"2":"Openrefine lab 1- Introducción"}" style="font-family: arial;"><a href="https://www.youtube.com/watch?v=foD-_sb6nw0&ab_channel=heidyzabala" target="_blank">Openrefine lab 1- Introducción</a><br /><br /></span></li><li><span style="font-family: arial;">The Youtuber Neregy started to record a tutorial based on our <a href="https://courses.tranzf.org/course/view.php?id=18" target="_blank">online courses about OpenRefine</a></span><br /></li><ul><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=4pS6-uvz33Y&ab_channel=Neregy" target="_blank">OpenRefine Text Combining Facet</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=e4pPS6TEleE&ab_channel=Neregy" target="_blank">OpenRefine Sorting Data</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=WEI9ZVVwzc4&ab_channel=Neregy" target="_blank">OpenRefine Date and Number Based Facet</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=aOsQIYPDrJw&ab_channel=Neregy" target="_blank">OpenRefine Text-Based Facet</a></span></li><li><span style="font-family: arial; white-space: pre-wrap;"><a href="https://www.youtube.com/watch?v=kP80MMQ-rGw&ab_channel=Neregy" target="_blank">OpenRefine Lesson 2 Lab Questions</a></span></li></ul></ul></ul><div><br /></div><ul style="text-align: left;"><li style="background-color: white; box-sizing: border-box; font-family: arial;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><b>English Videos:</b></span></span></li><ul><li style="background-color: white; box-sizing: border-box;"><span style="box-sizing: border-box;"><span style="font-family: arial;"><a href="https://vimeo.com/605956479" target="_blank">Week 4 OutwitHub and OpenRefine</a></span></span></li><li style="box-sizing: border-box;"><span style="background-color: white; white-space: pre-wrap;"><span style="font-family: arial;">Recording of @CODATANews Early Career Researcher Schools on #OpenRefine based on the Data Carpentry Lesson:</span></span></li><ul style="background-color: white;"><li style="box-sizing: border-box;"><a href="https://vimeo.com/614304116" target="_blank"><span style="font-family: arial;">OpenRefine - Intro</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614299202" style="font-family: arial;" target="_blank">OpenRefine - 1</a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614299772" target="_blank"><span style="font-family: arial;">OpenRefine - 2</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614300056" target="_blank"><span style="font-family: arial;">OpenRefine - 3</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614300434" target="_blank"><span style="font-family: arial;">OpenRefine - 4</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614300531" target="_blank"><span style="font-family: arial;">OpenRefine - 5</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614300954" target="_blank"><span style="font-family: arial;">OpenRefine - 6</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614301162" target="_blank"><span style="font-family: arial;">OpenRefine - 7</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614301298" target="_blank"><span style="font-family: arial;">OpenRefine - 8</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614301467" target="_blank"><span style="font-family: arial;">OpenRefine - 9</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614301788" target="_blank"><span style="font-family: arial;">OpenRefine - 10</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614302295" target="_blank"><span style="font-family: arial;">OpenRefine - 11</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614303174" target="_blank"><span style="font-family: arial;">OpenRefine - 12</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614303835" target="_blank"><span style="font-family: arial;">OpenRefine - 13</span></a></li><li style="box-sizing: border-box;"><a href="https://vimeo.com/614303947" target="_blank"><span style="font-family: arial;">OpenRefine - 14</span></a></li></ul></ul></ul></div><div style="background-color: white; font-family: arial;"><div style="box-sizing: border-box;"><span style="font-family: arial;"><div><ul></ul></div><div><h3 style="box-sizing: border-box; font-family: "Times New Roman"; font-size: 20px; line-height: 1; margin-bottom: 16px;"><span style="font-family: arial;">Academic Publications</span></h3><div style="font-family: "Times New Roman";"><span style="font-family: arial;"><ul><li style="box-sizing: border-box; color: #424242;"><a href="https://www.degruyter.com/document/doi/10.1515/9783110691597/html" target="_blank">OpenRefine featured in the book "Qualität in der Inhaltserschließung / Quality in Subject Cataloging" by Michael Franke-Maier, Anna Kasprzik, Andreas Ledl and Hans Schürmann</a></li></ul></span></div></div></span></div></div></span></div></div>Unknownnoreply@blogger.com