[Eril-l] Anyone using Excel PowerQuery and SharePoint for ERMS type features?

[Bulock, Christopher J]

Hi Jerry,

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: http://murphylibrary.uwlax.edu/erm/. 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: http://coral-erm.org/.

Chris Bulock
Oviatt Library
California State University Northridge
818-677-6302
christopher.bulock at csun.edu

From: Eril-l [mailto:eril-l-bounces at lists.eril-l.org] On Behalf Of McCulley, Jerry
Sent: Friday, May 15, 2015 12:12 PM
To: eril-l at lists.eril-l.org
Subject: [Eril-l] Anyone using Excel PowerQuery and SharePoint for ERMS type features?

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.

Has anybody explored this?   Or using Access with SharePoint?
Just wondering before I go down that path.

Thanks.


Jerry McCulley
Team Leader, ERSS
District Service Center
Dallas County Community College District
972-860-7788

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20150519/9bdde525/attachment-0001.html>