{"id":1879,"date":"2017-03-07T18:00:02","date_gmt":"2017-03-07T18:00:02","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?p=1879"},"modified":"2017-04-01T02:17:23","modified_gmt":"2017-04-01T02:17:23","slug":"march-7-2017","status":"publish","type":"post","link":"https:\/\/www.mollieecheverria.com\/?p=1879","title":{"rendered":"March 7, 2017"},"content":{"rendered":"<div class='booster-block booster-read-block'>\n                <div class=\"twp-read-time\">\n                \t<i class=\"booster-icon twp-clock\"><\/i> <span>Read Time:<\/span>1 Minute, 34 Second                <\/div>\n\n            <\/div><h3 class=\"c5\"><span class=\"c24 c13 c1\">Installing Elysa<\/span><\/h3>\n<p><span class=\"c2\">I spent much of last week attempting unsuccessfully to install the Carnegie\u2019s Elysa tool. Elsya has not been updated in almost two years, and I\u2019m having issues installing Foreman, the process manager it runs on.<\/span><\/p>\n<p><span class=\"c2\">It has been a learning process in general working with the Carnegie\u2019s tools, as they are all built with Ruby, a language I have not previously worked with.<\/span><\/p>\n<p><span class=\"c2\">In general, the Carnegie\u2019s tools seem to require a high degree of technical skills to use. Given that one of the Carnegie\u2019s stated goals with the ArtTracks project is to make these tools freely available to institutional collaborators, and that they are meant to facilitate interoperability, I feel like the complexity of their use and installation kind of limits their applicability of use to institutions with robust IT departments. I can\u2019t really see someone in the curatorial department of a smaller museum being able to install Elysa, though the Carnegie does state they will provide technical support.<\/span><\/p>\n<h3><span class=\"c24 c13 c1\">Karma vs. OpenRefine RDF Plugin<\/span><\/h3>\n<p>Having played around with OpenRefine, I want to test whether Karma (<span class=\"c4\"><a class=\"c18\" href=\"http:\/\/usc-isi-i2.github.io\/karma\/\">http:\/\/usc-isi-i2.github.io\/karma\/<\/a><\/span><span class=\"c2\">) alone might allow for sufficient normalization to skip the step of OpenRefine.<\/span><\/p>\n<p><span class=\"c2\">I first separated all the different sheets in my master Google Sheet for the Founding Collection using this script:<\/span><\/p>\n<p class=\"c23 c16\"><span class=\"c4\"><a class=\"c18\" href=\"https:\/\/www.drzon.net\/export-all-google-sheets-to-csv\/\">https:\/\/www.drzon.net\/export-all-google-sheets-to-csv\/<\/a><\/span><\/p>\n<p class=\"c23 c16\"><a class=\"swipebox\" href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1880\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34-785x452.png\" alt=\"\" width=\"785\" height=\"452\" srcset=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34-785x452.png 785w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34-300x173.png 300w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34-768x442.png 768w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34.png 1999w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/a><a class=\"swipebox\" href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image29.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1881\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image29-785x387.png\" alt=\"\" width=\"785\" height=\"387\" srcset=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image29-785x387.png 785w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image29-300x148.png 300w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image29-768x379.png 768w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image29-800x395.png 800w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image29.png 1999w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<h3 class=\"c23\"><span class=\"c24 c13 c1\">MySQL Workbench<\/span><\/h3>\n<p><span class=\"c2\">I\u2019m trying to create a MySQL database to import into Karma using my CSV files. Updating to the latest version of MySQL Community Server, however, has proven problematic.<\/span><\/p>\n<h3 class=\"c23\"><span class=\"c24 c13 c1\">MySQL<\/span><\/h3>\n<p><span class=\"c2\">Most of my afternoon was spent importing individual CSV files into MySQL and connecting them relationally.<\/span><\/p>\n<p><span class=\"c2\">I also did end up having to do some work with OpenRefine.<\/span><\/p>\n<p><span class=\"c2\">I\u2019m hoping to eventually feed this database directly into Karma, as working with so many separate CSV files is rather confusing.<\/span><\/p>\n        <div class=\"booster-block booster-reactions-block\">\n            <div class=\"twp-reactions-icons\">\n                \n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-1\" post-id=\"1879\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/happy.svg\" alt=\"Happy\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Happy                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                        \n                                                <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-2\" post-id=\"1879\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/sad.svg\" alt=\"Sad\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Sad                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-3\" post-id=\"1879\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/excited.svg\" alt=\"Excited\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Excited                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-6\" post-id=\"1879\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/sleepy.svg\" alt=\"Sleepy\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Sleepy                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                        \n                                                <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-4\" post-id=\"1879\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/angry.svg\" alt=\"Angry\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">Angry<\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                        \n                    <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-5\" post-id=\"1879\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/surprise.svg\" alt=\"Surprise\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">Surprise<\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n            <\/div>\n        <\/div>\n\n    ","protected":false},"excerpt":{"rendered":"<p>Installing Elysa I spent much of last week attempting unsuccessfully to install the Carnegie\u2019s Elysa tool. Elsya has not been updated in almost two years, and I\u2019m having issues installing Foreman, the process manager it runs on. It has been a learning process in general working with the Carnegie\u2019s tools, as they are all built [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1879","post","type-post","status-publish","format-standard","hentry","category-whitney-journal"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mollie Echeverr\u00eda<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mollieecheverria.com\/?p=1879\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"amanda\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879\"},\"author\":{\"name\":\"amanda\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"headline\":\"March 7, 2017\",\"datePublished\":\"2017-03-07T18:00:02+00:00\",\"dateModified\":\"2017-04-01T02:17:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879\"},\"wordCount\":308,\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image34-785x452.png\",\"articleSection\":[\"Whitney Linked Open Data Fellowship Journal\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879\",\"name\":\"Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image34-785x452.png\",\"datePublished\":\"2017-03-07T18:00:02+00:00\",\"dateModified\":\"2017-04-01T02:17:23+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1879#primaryimage\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image34.png\",\"contentUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image34.png\",\"width\":1999,\"height\":1150},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/\",\"name\":\"Mollie Echeverr\u00eda\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\",\"name\":\"amanda\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g\",\"caption\":\"amanda\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/mollie.echeverria\",\"https:\\\/\\\/www.instagram.com\\\/mollie_echeverria\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/mollieecheverria\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mollie Echeverr\u00eda","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mollieecheverria.com\/?p=1879","twitter_misc":{"Written by":"amanda","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mollieecheverria.com\/?p=1879#article","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1879"},"author":{"name":"amanda","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"headline":"March 7, 2017","datePublished":"2017-03-07T18:00:02+00:00","dateModified":"2017-04-01T02:17:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1879"},"wordCount":308,"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1879#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34-785x452.png","articleSection":["Whitney Linked Open Data Fellowship Journal"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?p=1879","url":"https:\/\/www.mollieecheverria.com\/?p=1879","name":"Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1879#primaryimage"},"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1879#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34-785x452.png","datePublished":"2017-03-07T18:00:02+00:00","dateModified":"2017-04-01T02:17:23+00:00","author":{"@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?p=1879"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mollieecheverria.com\/?p=1879#primaryimage","url":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34.png","contentUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image34.png","width":1999,"height":1150},{"@type":"WebSite","@id":"https:\/\/www.mollieecheverria.com\/#website","url":"https:\/\/www.mollieecheverria.com\/","name":"Mollie Echeverr\u00eda","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mollieecheverria.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084","name":"amanda","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g","caption":"amanda"},"sameAs":["https:\/\/www.facebook.com\/mollie.echeverria","https:\/\/www.instagram.com\/mollie_echeverria\/","https:\/\/www.linkedin.com\/in\/mollieecheverria\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1879","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1879"}],"version-history":[{"count":1,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1879\/revisions"}],"predecessor-version":[{"id":1882,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1879\/revisions\/1882"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}