Bulk insert of resource assignments

S

Sam

I am looking for a way to do a bulk insert of resource assignments from an
excel spreadsheet. The spreadsheet will be grouped by resource and then by
projects/tasks within resource. Essentially, we want to be able to allow
resource managers to allocate their personnel among the various projects they
are assigned to. Is there a codeplex or SDK solution for this or perhaps,
could you point me in the right direction?
Thanks!
Sam
 
A

Andrew Lavinsky

How about just some VBA or clever formulas to arrange the Excel sheet the
way you would like it, and then using the import from Excel wizard?

Try opening from Excel in MS Project and reviewing the import options.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tasks assigned by project manager is invisible to resource 2
Bulk Resource Substitution in Project Server 2007 2
Creating assignments 3
Creating assignments and PWA 8
New Tasks on View Resource Assignments 1
How do I use PSI to "set the work distribution on the assignments" 2
View Resource Assignments 1
Project Web Access - Resource Center - View Assignments issue 0

Top