File Format for importing multiple resources per task

[J. Maloney]

I am trying to build a project from another source. I can build the WBS
structure and am trying to populate it with resources. There are multiple
resources for each task but only one resource is imported for each task.

 

[John]

I am trying to build a project from another source. I can build the WBS
structure and am trying to populate it with resources. There are multiple
resources for each task but only one resource is imported for each task.

J,
Why not put the resources into a comma delimited string [in your
external source] and then import into the Resource Names field (Task
import)?

John
Project MVP

 

[J. Maloney]

John,

Thanks for posting but it was not successful. I already imported the WBS
and that matches well. I loaded the resource sheet by hand and have tried
using the resource ID, NAME, and Initials in various trials. Project only
seams to want to accept the ID. I did concatinate the resource Name and ID
along with the work as a comma delim. string. No success. I'm using the WBS
field as the "Merge Key". When I concat. the resource ID I get an error
because the field is looking for a number not a string.

A snippet of sample data follows:
WBS ID RES CODE START Finish work Res ID Res Name
1.1.1 33 01/01/03 07/01/05 40.00 1 Materials Management
1.1.1 34 01/01/03 07/01/05 1630.00 2 Contracts
1.1.1 35 01/01/03 07/01/05 40.00 3 Manufacturing Support
1.1.1 50 01/01/03 07/01/05 40.00 8 Manufacturing Managers
1.1.1 52 01/01/03 07/01/05 40.00 10 Production Planners
1.1.1 54 01/01/03 07/01/05 40.00 12 Assembly
1.1.1 55 01/01/03 07/01/05 40.00 13 Optician
1.1.1 80 01/01/03 07/01/05 3410.00 14 Program Manager
1.1.1 81 01/01/03 07/01/05 40.00 15 Mechanical Engineer
1.1.1 83 01/01/03 07/01/05 40.00 17 Optical Engineer

I am trying to build a project from another source. I can build the WBS
structure and am trying to populate it with resources. There are multiple
resources for each task but only one resource is imported for each task.

J,
Why not put the resources into a comma delimited string [in your
external source] and then import into the Resource Names field (Task
import)?

John
Project MVP

 

[John]

John,

Thanks for posting but it was not successful. I already imported the WBS
and that matches well. I loaded the resource sheet by hand and have tried
using the resource ID, NAME, and Initials in various trials. Project only
seams to want to accept the ID. I did concatinate the resource Name and ID
along with the work as a comma delim. string. No success. I'm using the WBS
field as the "Merge Key". When I concat. the resource ID I get an error
because the field is looking for a number not a string.

A snippet of sample data follows:
WBS ID RES CODE START Finish work Res ID Res Name
1.1.1 33 01/01/03 07/01/05 40.00 1 Materials Management
1.1.1 34 01/01/03 07/01/05 1630.00 2 Contracts
1.1.1 35 01/01/03 07/01/05 40.00 3 Manufacturing Support
1.1.1 50 01/01/03 07/01/05 40.00 8 Manufacturing Managers
1.1.1 52 01/01/03 07/01/05 40.00 10 Production Planners
1.1.1 54 01/01/03 07/01/05 40.00 12 Assembly
1.1.1 55 01/01/03 07/01/05 40.00 13 Optician
1.1.1 80 01/01/03 07/01/05 3410.00 14 Program Manager
1.1.1 81 01/01/03 07/01/05 40.00 15 Mechanical Engineer
1.1.1 83 01/01/03 07/01/05 40.00 17 Optical Engineer

J,
Why did you try to concatenate all that stuff (i.e. resource name, ID
and Work)? Data from other apps needs to be mapped into fields in
Project. If you concatenate the resource names as the assignments for
each task then you will be replicating the text string of the Resource
Names field in a task view. You could add the allocation values also.
For example:
Joe[50%],Fred[30%]

It does work - I tried it before I suggested it.

John