{"id":789,"date":"2012-10-03T15:35:43","date_gmt":"2012-10-03T19:35:43","guid":{"rendered":"http:\/\/blog.uvm.edu\/ctl-projects\/?p=119"},"modified":"2012-10-03T15:35:43","modified_gmt":"2012-10-03T19:35:43","slug":"experts-database","status":"publish","type":"post","link":"https:\/\/blog.uvm.edu\/waw\/2012\/10\/03\/experts-database\/","title":{"rendered":"Experts database"},"content":{"rendered":"<p>Amanda K. Waite,Web News Editor,\u00a0University Communications asked:<\/p>\n<blockquote><p><em>University Communications is looking into the possibility of using data generated by Digital Measures (the new faculty reporting tool being implemented on campus) to update the experts database.\u00a0We need a spreadsheet of netids, names and biography fields from the database to explore the possibility a bit more. I have access to an old expertds.dbf file, but I don&#8217;t think I can get into the current database. Would you be able to export and send me the current database in an Excel spreadsheet (or a tab or comma-delineated .txt file I can import into Excel)?<\/em><\/p><\/blockquote>\n<p>Not as easy as it sounds. First, I had to find the database, created years ago by a former web team intern. Then, I had a fight between mySQL and Excel. Several fights: treatment of carriage returns\/line-feeds in database fields, and treatment of commas and quotes. Eventually, Excel conceded defeat before my powerful kung-fu dragon style.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Amanda K. Waite,Web News Editor,\u00a0University Communications asked: University Communications is looking into the possibility of using data generated by Digital Measures (the new faculty reporting tool being implemented on campus) to update the experts database.\u00a0We need a spreadsheet of netids, &hellip; <a href=\"https:\/\/blog.uvm.edu\/waw\/2012\/10\/03\/experts-database\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41826],"tags":[42758],"class_list":["post-789","post","type-post","status-publish","format-standard","hentry","category-wes","tag-boffins"],"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/comments?post=789"}],"version-history":[{"count":0,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/789\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/media?parent=789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/categories?post=789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/tags?post=789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}