IT Employment

Ask something
Discussion Locked

Importing Data into MS Project

0 helpful
3 replies

by gemuse99

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does any one know if there are some scripts out there that I can use to import data into MS project? (I know the import function that is built in Project, but this is insufficient for my need).

What I need is to be able to import the actual hours from another application (in Excel or text file), and tie that into the tasks within Project by the resource name and some unique task ID.

3 replies

by dklippert

Where does the Import function fail you? If the data is consistant, you can record the process and "play it back".
Would Access serve your purpose better as a data repository?

by gemuse99

Maybe I don't know the full feature of the Import function, but it fails b/c my company forces my resources to log their hours on a proprietary software, which I can get the data in a text file.

When the resources log their times on this software, they logged against a particular project. A resource could be on multiple projects and a project could have multiple resources.

I need to take the hours that they entered and import it on the project plan to give me the actual hours.

by kees.valkenswaard

What you probably need is to apply a resource pool for all your projects. In this way, you could log resources against several projects. Has your text file real hours or decimal hours? Is there any information about the resource and the project? If yes, you would have to prepare a special input table with the required fields. Else, you may have to add specific information. Perhaps a two-tier solution is what you need. I.e. first, import the text file into Excel. Do some magic with a few functions and import that file into Project. In Project with an import/export table, you can define which field in Excel [the top row of every column] should be matched to a certain field in Project. If you would like to know more about this mail me at: testregelneef@hetnet.nl
Good luck.

This discussion is closed to new replies.