Author Archive: Joseph Parchem

About Joseph Parchem

Father of 2, amateur remodeling, web programmer, network administrator.

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 and Lync: Such as phone, mobile, address, title, name, supervisor, and so on. Having this information accurate is critical. Rather than creating some kind of procedure or policy to govern it, I created code.

I could create a custom workflow DLL using Vision’s API. The catch was, at the time, I had to go back to Visual Studio 2003 to do this, per the requirements of Vision. No problem: Microsoft will send me a copy and I can learn it quick. Using C# .NET, I was able to read the active employee list from Vision, impersonate a network administrator, query AD using LDAP, and match Vision employees to AD objects. Then it was a simple matter of determining what AD called the fields in code and just mapping in the appropriate data from Vision. (more…)

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 knew that I could easily convert an address to latitude and longitude coordinates on Google Maps so I needed to do this for our client addresses stored in our ERP. After some digging around I found out this was called geocoding. Great. Then hunt for geocoding web services began. I had about 15,000 addresses to do and most of the APIs on the Internet would allow a couple hundred in a day, or 1,000 total. Until I found the MapQuest Goecoding API, which provided a very open service that I allowed 5,000 addresses per day. (more…)

Our Public Website

MSA Professional Services, Inc. Public Website 2012

Visit Site >

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 and CMS, but decided have the Marketing Manager and myself redesign the content, graphics, and organization. And we ended up adding features as we went along.

My main role was functionality. The Marketing Manager outsourced the design to the same designer that had been retooling our print materials. That consultant created a mock-up of the site in Photoshop that we acquired and were able to better translate to the web medium. I began modifying the layout and would pass it through Marketing for tweaks and approval, so the graphics and user interface quickly became my responsibility. Tthere were other design elements for the features we were adding that needed graphic treatment as well, putting me in the great position of back-end development all the way through to the user front-end. I loved it. (more…)

What’s In a Name

477784_10201314869823315_1565453723_o

I have been called many things over the years. Some of them very appropriate, even if negative, and some of them just noise. One of the best titles I have attained is Dad. I really liked being called Daddy, but Dad has this familiarity to it, an essence of calm and trust, a maturity to it that Daddy doesn’t have. As of today, my daughter Harper is 7 and my son Atlas is 3. Incidentally, even though unplanned, that is the same age difference between my sister and I, and she is older too!