Archive for the ‘Office’ Category

Out of the box Sharepoint Workflows

Friday, June 25th, 2010

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…)

Converting an Access DB to Sharepoint

Monday, June 14th, 2010

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…)

Meeting Roll Call with OneNote

Tuesday, June 1st, 2010

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

There’s a bit of setup to get the OneNote document set up the first time, but it makes calling roll a quite a bit easier.

meeting_roll_call_with_onenote_step9.PNG

(more…)

Premium Plaxo for Comcast users …

Friday, August 28th, 2009

Comcast logo I recently switched from DSL (which I’d had since it first was invented) to Comcast Cable for my Internet connection (and TV and phone). By doing so I saved about a hundred bucks a month over AT&T and DirecTV. Of course as soon as I switched, AT&T started calling me with a bundle that was roughly the same price, but that’s a different story.

One of the things that happened a while back was that Plaxo was bought by Comcast. I have always been a premium Plaxo user, feeling that I wanted to support them since I find the product so incredibly useful. What I learned was that if you are a Comcast subscriber, you are automatically a Plaxo premium user.

Now, being a premium subscriber used to only mean you got VIP support and access to a couple of tools (like the address and calendar deduplication tool). But now Plaxo has announced that the Outlook synch is a premium member only tool. While I worry that this decreases the value of the service (since there will be fewer reasons for people to sign up, therefore fewer members, and decreasing the number of automatic updates I get), what is interesting is that every Comcast subscriber gets access to these premium services.

(more…)

Microsoft Office self-incompatibilities …

Thursday, July 30th, 2009

I received an post on a group I follow reminding people not to send out documents in the Office 2007 format of Word. Now, I’ve been using the 2007 suite since the first betas (way before 2007), and have learned this lesson more than once (mostly because of lost settings when I’ve had to do a reinstall).

The new format for files in Office was created by Microsoft in an attempt to create an open file structure. Any file you save in a default install of 2007, will have the letter “x’ appended to the file extension, signifying that it is saved in this new format.

There are many ways to deal with this problem, and the most successful strategy is actually to simply configure your 2007 products to default to saving in the older format. (more…)