As a project manager, I’m often faced with the problem of how to deal with configuration management, which is how we make sure that everybody is on the same page. I typically like to use a content management system to handle this issue. For my current project, I’m using Sharepoint, which also has some nice built in collaboration capabilities.

There are two out of the box workflows on the Document Library: “Approval” and “Collect Feedback”.

Both work pretty similarly, and for general document collaboration they work pretty well.

(more…)

Consulting · Document Management · Microsoft · Microsoft SharePoint · Microsoft Visual Studio · Products · Sharepoint · Workflow

I’m a big fan of making people more productive by sharing data entry. In my current project, the tool we have for collaboration is Sharepoint 2007.One of our team members is really comfortable with Access development, and built a nice database for tracking the status of our document deliverables. The problem with this is that since Access is a local sort of solution, it doesn’t allow for people to make updates as they work, so we end up spending a lot of time with the database owner updating status.

The solution (in this particular environment) is to utilize Sharepoint lists. Access 2007 has a nice wizard driven approach to building Sharepoint lists, as long as the database is built correctly.

So here are the iterations I had to go through to make this work …

(more…)

Data Type · Database · Document Management · Microsoft · Microsoft SharePoint · Microsoft SQL Server · Products · Sharepoint

I’ve made a slight change to the way I’m doing meeting minutes for standing meetings that I find helpful.

I am using a feature of OneNote that allows me to check off attendees a bit more easily.

It’s a bit of setup in the beginning, but it really works nicely once you have it done the first time.

Step 1: launch your meeting notes as usual from Outlook (by clicking the OneNote button on the ribbon). If you’ve installed the meeting template you’ll see something like:

Step 2: Now, because we haven’t figured out how to make the fields all flow into the right place in the template, a lot of the meeting information is actually way down at the bottom of the template. So scroll down until you see the meeting information (normally I just delete that). In this example, no attendees show up (I think because it’s not my meeting):

Step 3: Insert the meeting details by choosing “Insert Outlook Meeting Details” from the menu (Do this near the existing text in the notes so that you don’t have to scroll as much):

Step 4: Choose the meeting you want the information for from the list:

Step 5: Now you have a copy of the information for the meeting, including the attendee list (in the order it is in the invite):

Step 6: Copy the list of attendees to the Attendees section of the notes:

Step 7: Highlight the names and choose the “To do” tag from the tags list on the ribbon bar (or hit ctrl-1):

Step 8: Reformat the attendee list in whatever way makes the most sense to you (for long lists I typically split it into multiple columns):

Step 9: use this as the template for your roll call, click the check box for anybody who is in attendance, uncheck if they’re not. If your attendee list doesn’t change much, you can just copy the notes from a prior meeting and go forward with that.

It’s also easier for people receiving the notes to see who was actually there.

App Store · ios · IPhone · Microsoft · Microsoft Office · Microsoft Office 2010 · Microsoft OneNote · Microsoft Windows · OneNote · Time management