{"action":"created","issue":{"url":"https://api.github.com/repos/LibraryCarpentry/week-four-library-carpentry/issues/3","labels_url":"https://api.github.com/repos/LibraryCarpentry/week-four-library-carpentry/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/LibraryCarpentry/week-four-library-carpentry/issues/3/comments","events_url":"https://api.github.com/repos/LibraryCarpentry/week-four-library-carpentry/issues/3/events","html_url":"https://github.com/LibraryCarpentry/week-four-library-carpentry/issues/3","id":119567833,"number":3,"title":"Open Refine and Alma","user":{"login":"ClareP","id":11380886,"avatar_url":"https://avatars.githubusercontent.com/u/11380886?v=3","gravatar_id":"","url":"https://api.github.com/users/ClareP","html_url":"https://github.com/ClareP","followers_url":"https://api.github.com/users/ClareP/followers","following_url":"https://api.github.com/users/ClareP/following{/other_user}","gists_url":"https://api.github.com/users/ClareP/gists{/gist_id}","starred_url":"https://api.github.com/users/ClareP/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ClareP/subscriptions","organizations_url":"https://api.github.com/users/ClareP/orgs","repos_url":"https://api.github.com/users/ClareP/repos","events_url":"https://api.github.com/users/ClareP/events{/privacy}","received_events_url":"https://api.github.com/users/ClareP/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-30T19:57:59Z","updated_at":"2015-11-30T22:51:29Z","closed_at":null,"body":"How to get the data out of and then back into Alma in order to work with it in Open Refine"},"comment":{"url":"https://api.github.com/repos/LibraryCarpentry/week-four-library-carpentry/issues/comments/160787102","html_url":"https://github.com/LibraryCarpentry/week-four-library-carpentry/issues/3#issuecomment-160787102","issue_url":"https://api.github.com/repos/LibraryCarpentry/week-four-library-carpentry/issues/3","id":160787102,"user":{"login":"cmh2166","id":6874040,"avatar_url":"https://avatars.githubusercontent.com/u/6874040?v=3","gravatar_id":"","url":"https://api.github.com/users/cmh2166","html_url":"https://github.com/cmh2166","followers_url":"https://api.github.com/users/cmh2166/followers","following_url":"https://api.github.com/users/cmh2166/following{/other_user}","gists_url":"https://api.github.com/users/cmh2166/gists{/gist_id}","starred_url":"https://api.github.com/users/cmh2166/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cmh2166/subscriptions","organizations_url":"https://api.github.com/users/cmh2166/orgs","repos_url":"https://api.github.com/users/cmh2166/repos","events_url":"https://api.github.com/users/cmh2166/events{/privacy}","received_events_url":"https://api.github.com/users/cmh2166/received_events","type":"User","site_admin":false},"created_at":"2015-11-30T22:51:29Z","updated_at":"2015-11-30T22:51:29Z","body":"hmm, well, off the top of my head - you can expose Alma data as MARC/XML via OAI-PMH, and MARCEdit (on Windows) can harvest data from OAI-PMH (with holdings attached in your chosen 9XX bib field), as well as run automated classification using built in support for the OCLC Classify API. This could generate MARC files you could then import back into Alma as part of an overlay procedure.\r\n\r\nAs for connecting Alma to OpenRefine... its not like you can connect the Alma API to OpenRefine in any meaningful way. Basically, you'll need to export data from Alma as binary MARC or MARC/XML - or expose via OAI-PMH, or have a series of MMS ids to retrieve MARC/XML via the Alma bib API, then save the output in either API or OAI case as a local MARC/XML file. Convert those files to .mrk (you can load MARC/XML into OpenRefine, but its ugly, I'll warn you), then load into OR per Owen's discussion on other thread. In OpenRefine, could try to hit the OCLC Classify API as maybe a recon service (not that one exists currently I'm aware of, but I could help you build such a recon service). Then export, reconvert, load into Alma.\r\n\r\nAlternatively, possible to script pulling records from Alma bib API, grab call number/other fields, and hit the OCLC classify API in that script. \r\n\r\nJust a few thoughts, I hope they're not too presumptive of what the use case is."}}