Here's a way to automatically synchronize MS Project files with your timesheet. It is completely automatic. Once it's set up, you won't have to touch a thing. Your MPP files will be synchronized with the timesheet nightly. When you come into the office in the morning all your tasks will be up to date.

Watch the video below and leave your comments. We want to know what you think.

 

 

In this video I'm going to show you an interesting little program that synchronizes your Microsoft Project files with your timesheet.

You can have your project managers, supervisors, team leads updating your MSP file. And then engineers, technicians, employees working on their timesheets and this little program will synch it up.

No need to touch anything, does it automatically. Let's take a look.

I've switched over to my screen and let's take a look at this amazing little program that can synchronize between Microsoft Project and Standard Time®.

The name of the program is MSP.exe; it's a little console application completely independent of MSP, completely independent of Standard Time. It's a little piece of glue that pulls down all of the tasks from MSP.

It puts them into the Standard Time database, brings all of the employee hours up from the timesheet and puts them into the actual work column and into the task usage view in MSP.

It turns out you can't actually run this program on its own because you need some parameters to run. So you're gonna to have to bring in your IT person to take a look at this and set this up so that you can use it.

What I've done is create a little batch file that has those parameters that allow me to run this and perform the synchronization. I know this is getting advanced and a little techy but the advantages are really great. Because you'll be able to run this multiple times a day, you can run it at night, you come in in the morning all of your tasks are updated in Standard Time.

All of your actual work has been pushed up to MSP. So the advantages are wonderful but it's a little techy and your IT person may have to create batch files or set up a scheduler to do this.

I'll run this little batch file we'll look into to how it works. So this little program is running, it's opening up MSP performing the synchronization and then shutting it down. There it is, it's all done. I can switch over to Standard Time and see what happens.

What is happened is that there is a new project out here that now has all of the tasks that came down from MSP. If I switch over to the timesheet I see the tasks that are assigned to me. This is nothing new, you've already seen this if you've looked at the other videos on synchronizing between Standard Time and MSP.

You can go type some hours into these tasks and we can shut down Standard Time because this little program will now synchronize them. I'll go ahead and run it again presumably this would happen at night or during the day sometime.

The synchronization has occurred and now I've opened up MSP to take a look at what has happened over there. I go to the view menu click on the task usage view and you can see some of the hours that have come down here. This is nothing new you may want to look at the videos on the MSP add-in that does the same thing or in Standard Time there is a menu item that does the same thing.

This little application, I'll switch back to the program, this application is completely independent. That's the real value of this. Let's take a look at what's inside this little batch file. If I right click on it, choose edit, you'll first of all see it's calling the msp.exe program. You need a project in Standard Time that this is going to connect to. You need to be able to connect to the Standard Time database, so that's what these are for. Then you need an mpp file that this little program can open up.

Give it those parameters and this thing will fire right up and run. Actually it won't fire right up, you need a batch file and double click on it. Or you can go over to the control panel, go into system and security under administrative tools there is a thing called schedule tasks. You can use this to schedule this little program to run on a nightly basis. And when you do this thing will run automatically on a completely different machine or server.

Where ever you want to have it run, you'll need MSP on your machine. This little thing will sit there and run all the time. And will do that synchronization for you.

Very neat little program that you should take a look at in addition to the MSP add-in or plug-in that we have. And the menu item in Standard Time. Lots of different ways to get your actual hours up to MSP and your tasks down to Standard Time. Have a look at this if you want an automated way to synchronize MSP with your timesheet.

 

More Microsoft Project links: Integrate Standard Time with Microsoft Project, Microsoft Project Info, Double the Value of Your Timesheet

 

Back to Videos

 

More videos on YouTube

 

 

 

 

 

 

 

    More videos to explore

  • Short Intros (60 sec)

    Short intros to the basics of time tracking and project management techniques. Learn how employees use the timesheet. Read More
  • Instructional (3 - 6 min)

    Screencast videos with deeper instruction for project management, employee timesheets, PTO, expenses, and client invoicing Read More
  • Cartoons (60 sec)

    The lighter side of time tracking and project management, in cartoon format. Learn what the makers of Standard Time really think! Read More
  • Quick Questions (2 - 4 min)

    Answers to quick questions we have received regarding the employee timesheet, projects tracking, and PTO. See the product in action. Read More
  • Old-Timey (60 sec)

    Tracking time and expenses in the modern world? See the most modern technique for time sheets and time management Read More
  • Animated (30 sec)

    Introduce and inspire use of the timesheet and project management techniques. You will learn what can be done and be tempted to try it. Read More
  • Interviews (2 - 3 min)

    Interviews about timesheets, project tracking, PTO, and management techniques. Get the general concepts of time and project tracking. Read More
  • Whiteboard (60 sec)

    Introductions to time tracking and project management. Get ideas, get inspired, try new things, and learn what your timesheet can do Read More
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8

 

FREE TRIAL


Download a fully functional timesheet that will remain active for 30 days.
Company Name
Please enter your company name
Full Name
Please type your full name.
E-mail
Invalid email address.
Number of Employees
How many employees will use this?
Enter the text below
Enter the text below
Please enter the text above