I have used SQL Server’s TSQL to generate Excel spreadsheets from Vision data, our ERP, and then deliver the document to various employees. The data in the document is customized to that individual and there are multiple types of audiences that have different reasons for the report, thus need a customized version of it. Even better, Vision …
ERP Data to Active Directory
The ERP I work with is called Vision and is created by Deltek. This holds all the data for all departments in the company, including employee data. Active Directory (AD) is Microsoft’s repository of usernames and passwords that can access a network. But AD stores information about the employees which is then used for display in Outlook …
Clients on a Map
We wanted the ability to show our clients on a map, for various reasons. The GIS department was never able to produce this and anytime I asked about it, there was discussion about using the zip. I wanted a pin point on the address, so I took it upon myself to figure that out. I …
MSA Public Website
In 2011, we hired out the redesign of the public website to a consultant. I was involved only briefly and was able to weigh on the hosting provider as well as the Content Management System (CMS) that was going to be used. That turned out to be less than stellar. We stuck with the host …