IT Employment

Ask something
Discussion Locked

MSProject 2000: Importing hours

0 helpful
7 replies

by aref

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I import timesheet hours form another application where the time is captured? We must see work done and what day it was done.

7 replies

by shanghai sam

I don't need a timesheet system, we have one. I need to get work done by day into project so that when I look at the Resource Usage views I see the actual work and day on which it was done for the resource's tasks.

by flashofblue

It depends on the format of the data you are pulling from the original application. If you can format the data into Excel via comma delimiting, then all you need to do is is create a map and import the data into Project. Once you have the data into Excel you can do this by:
1) Open project that you want to merge to
2) Select File>Open
3) Set "Files of Type" to Excel, CSV, etc. Import mapping window will appear
4) Select "New Map" Define Import/Export window appears.
5) Check the resources box and select the resource mapping tab
6) Select the worksheet name of your time data
7) In the "Method for incorporating imported" field, select Merge (by key) into current project
8) Define keys for merge
9) Select "OK"

Look in the Project 2000 manual for more information on importing with maps if you need better explanation. Good Luck!

by shanghai sam

Thanks but, we had tried that already. I still don't see how to get work done, by day, into project using this method. When I look at the Resource Usage views I need to see actual work and day on which it was done for the resource's tasks.

by realgem

I don't think the mapping will work for you.

You may find that a macro will do the job. I don't have one written myself, but you may be able to write one that copies data from a spreadsheet into the task usage view. If your task usage view is set to display daily actuals.

I also recommend that you try posting your question on the Microsoft Project newsgroup at www.support.microsoft.com.

by mslizny

The resource hour tracking in MS Project is a convenience application, but not a full-fledged timesheet application. I doubt you can get the functionality you want without bringing the information your timesheet program is generating into an Excel format where it can be manipulated to fit into some of the MS Project fields.

by smmiles3

You should also consult Rod Gill's columns in Woody's Project Watch. Typically,the data you want is extracted from Project into an Excel report, not into Project as you are seeking to do.

This discussion is closed to new replies.