PowerShell Logging Module

(Edited 11/30/15 – Completely forgot SqlChow’s contributions! Sorry!)

Wow – two blog posts in two days!  A record for me.  So today’s post I wanted to try something new.  I wanted to start sharing some of my code via a download over this WordPress CMS. Well, that’s not the only reason, I do like to share stuff so if this helps someone out, leave a comment, etc.

So the very first download I want to do was a very useful module that I hobbled together that I used in some of my automated PowerShell scripts — a logging module!

Read more

PowerShell, SharePoint, & MS Access – Oh My!

I’ve been getting into PowerShell scripting a lot at one my clients and I encountered a pretty unique situation that I spent days trying to find the answer to.  I figure I would post a quick note about it and see if I could save someone else some time.

PS-SP-Access

The setup:

One of the tasks I have at this client is to put together a weekly Status Report MS Word document for management.  Although I try to keep the information brief, we are running about 7-8 pages in length (we have a lot of  plates spinning at the same time.)  I have to follow up with a dozen people to get their updates.  Although I’ve tried to get them to submit their information in a standardize format, etc, the information comes in wildly different formats, completeness, or lacks context, etc.  The entire process can take a few hours to pull together – depending on the editing required.  I thought that a better use of time was to come up with a SharePoint solution that would allow everyone to contribute their portion of the status report and have an automated weekly report generated automatically for management.

The Issue:

After setting up my SharePoint site/list, creating the MS Access database, and connecting it to said list, automating MS Access from PowerShell as a scheduled task on a server proved to be quite challenging.  There were a number of error messages and access issues that needed to be addressed before everything worked.

Read more

Latest Challenge: SharePoint, jQuery, and Web Services

Back again!

I don’t write as often as I should and with the new year coming up, I’m hoping to change that (again!)

In keeping with what I’ve been blogging about in the past, I decided to write about my latest challenge/adventure. The last few years I’ve been concentrating on Project Management and not really writing a lot of code.  However, PM’ing at my latest client has given me tons of programming opportunities if I want to pitch in and help.  Lots of PowerShell, Exchange, and Active Directory stuff (with some sprinkling of other types of stuff like SharePoint and faxing, etc.)  My latest challenge is creating a dashboard of the data we’ve collected on the Exchange mailboxes.

Read more

Learning iOS Development – Day 3 & 4: Lynda

Screen Shot 2012-01-15 at 8.50.05 PM.png

It’s been awhile, but I decided to take up this subject (yet again.) Although I do still have access to Safari Online, a friend of mine lent me his copy of iPhone SDK Essential Training DVD from Lynda.com for comparison. I spent the last two days watching the video. It’s just under 7 hours, but I spread it over two days because I was watching Tebow get his butt handed to him against the Patriots (sigh, I was hoping for more.)

The video in a word is Awesome.

Read more

Learning iOS Development – Day 2: lite day…

ios5.jpgToday was a light day for learning. I only made it through a couple of more videos before I had to take care of other things. Strange, I sat down at my computer about 4 hours ago and did work for everyone else but me. I’ll have to make up for it tomorrow. I should be up to the point in the video training that I will actually be able to download and/or write some code. Can’t wait! But for now.. bed.