Importing from Excel: subtasks, links & multiple resource names

[redmadcap]

I am using MS Project 2003 SP3. I am trying to import a large Exce
2003 spreadsheet and am having a few difficulties:
1) all the tasks are in one column. How to I specify the subtasks?
have tried indenting the cell (in Excel), but this doesn't work.
2) How can I import the links? I assume I must import th
predecessor(s). This means that I identify an ID for each line in Exce
(compatible with MSP), then use the same reference system for th
predecessor. How can I specify more than one predecessor?
3) How can I import more than one resource per task? I tried puttin
two resource names in an Excel cell (separated by "," ex: Fred, Susie)
but after the import MSP takes this as one long resource name (
resource called "Fred, Susie").

Thanks

 

[Jim Spiller]

See below:

I am using MS Project 2003 SP3. I am trying to import a large Excel
2003 spreadsheet and am having a few difficulties:
1) all the tasks are in one column. How to I specify the subtasks? I
have tried indenting the cell (in Excel), but this doesn't work.

You must define the Outline Level for this. That's the only way you can
import and create subtasks (indent). For example:

Outline Level,Name
1,Top Level
2,Task One
2,Task Two
2,Next Level
3,Task Three

2) How can I import the links? I assume I must import the
predecessor(s). This means that I identify an ID for each line in Excel
(compatible with MSP), then use the same reference system for the
predecessor.

Yes.

How can I specify more than one predecessor?

Enclose with quotes. ex:

ID,Name,Predecessors
1,Task One,
2,Task Two,
3,Task Three,"1,2"
4,Task Four,3

3) How can I import more than one resource per task? I tried putting
two resource names in an Excel cell (separated by "," ex: Fred, Susie),
but after the import MSP takes this as one long resource name (a
resource called "Fred, Susie").

Enclose in quotes. "Fred,Susie"

 

[redmadcap]

Thanks Jim,

All your suggestions worked great, except the importing of multiple
predecessors. I have tried using quotes, marking the Excel cell as
Text, and various combinations but can't get it to work.

Any other suggestions?

 

[Jim Spiller]

Try importing this:

ID,Name,Predecessors
1,Task One,
2,Task Two,
3,Task Three,"1,2"
4,Task Four,3

If this works, try posting a small sample of what you are trying to import and I'll try it.

 

[Joenel]

Hello I saw your post and I am having a similar problem I have attempted to
define my out dent column but i have not been successful. I have included a
sample of my data and how the indention should look do you have any
suggestions? Thank you

OutDent Level Task
0 888-4100-501
3 888-4100-501-TF
6 888-4100-501-ASMJ
6 888-4100-501-HDLF
3 888-1200-501