<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Ballongtext Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.E-postmall17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.E-postmall18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.E-postmall19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BallongtextChar
{mso-style-name:"Ballongtext Char";
mso-style-priority:99;
mso-style-link:Ballongtext;
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=SV link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Hi,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>I agree with Chris. There is a lot you can do with Excel, but maybe even more with Access. I work as a librarian at Uppsala University in Sweden, and we´ve just decided to drop out of a commercial ERM system. Access is an alternative for us. From my experience Access seems a bit overlooked as far as database managers go. Maybe because of a higher threshold than Excel. For anyone interested in Access I would recommend a YouTube channel called Access All In One (<a href="https://www.youtube.com/channel/UCMJ2I2JP8V0RX1JGEEqX2SA">https://www.youtube.com/channel/UCMJ2I2JP8V0RX1JGEEqX2SA</a>). I´ve certainly leaned a lot from there.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>On topic: We are not currently looking at Sharepoint at the moment. The IT department don’t want another CMS on their hands. Storing the data in local files is not a good option however. An alternative is to use local files that connects to a Microsoft SQL Server. That way we could alter the interface with little effort and still have secure data.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>I looked at ERMes and it looks interesting, but there doesn’t seem like much has happened since 2011. Does anyone know why? Are there still users?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Kind regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Niklas Willén<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;color:#404040'>Niklas Willén<o:p></o:p></span></b></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:#404040'>Librarian<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:#404040'>E-resources Team<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:#404040'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:#404040'>Uppsala University Library<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:#404040'>Box 510, Se-751 20 Uppsala, Sweden<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:#404040'>Phone: +46 70 425 01 73<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:#404040'><a href="http://www.ub.uu.se">www.ub.uu.se</a><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:#404040'><a href="mailto:niklas.willen@ub.uu.se">niklas.willen@ub.uu.se</a><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Från:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Eril-l [mailto:eril-l-bounces@lists.eril-l.org] <b>För </b>Bulock, Christopher J<br><b>Skickat:</b> den 19 maj 2015 18:51<br><b>Till:</b> McCulley, Jerry; eril-l@lists.eril-l.org<br><b>Ämne:</b> Re: [Eril-l] Anyone using Excel PowerQuery and SharePoint for ERMS type features?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Hi Jerry,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>There is certainly a lot you can do with Excel or Access. If you’re thinking of going that route, I’d recommend taking a look at ERMes: <a href="http://murphylibrary.uwlax.edu/erm/">http://murphylibrary.uwlax.edu/erm/</a>. It has a lot of the features you’d want out of an ERMs. If you have some more tech resources at your disposal, the open source CORAL ERMs is a great option: <a href="http://coral-erm.org/">http://coral-erm.org/</a>.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Chris Bulock<br>Oviatt Library<br>California State University Northridge<br>818-677-6302<br><a href="mailto:christopher.bulock@csun.edu">christopher.bulock@csun.edu</a><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Eril-l [<a href="mailto:eril-l-bounces@lists.eril-l.org">mailto:eril-l-bounces@lists.eril-l.org</a>] <b>On Behalf Of </b>McCulley, Jerry<br><b>Sent:</b> Friday, May 15, 2015 12:12 PM<br><b>To:</b> <a href="mailto:eril-l@lists.eril-l.org">eril-l@lists.eril-l.org</a><br><b>Subject:</b> [Eril-l] Anyone using Excel PowerQuery and SharePoint for ERMS type features?<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>I’d love to have a full blown ERMS at my disposal but it’s not in the budget. However, I was talking with our IT director and learned that a lot of the same features can be managed in Excel using SharePoint, with connections to vendor websites for usage stats. My main goals include managing usage stats and keeping up with renewals and license information. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Has anybody explored this? Or using Access with SharePoint? <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Just wondering before I go down that path. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Thanks. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Jerry McCulley<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Team Leader, ERSS<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>District Service Center<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Dallas County Community College District<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>972-860-7788<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div></body></html>