Importing multiple predecessors/successors

[David Lewis]

Is there any way to import multiple predecessors and/or successors
from Excel (or anything external)? The "23, 25, 32" format produces
odd results, at best. And, that's how exported multiple predecessors
look.

Thanks.

 

[Steve House]

Those number are task id numbers. In what way do you mean the results are
"odd?" What do you get and what are you expecting to get?

Steve House
MS Project MVP

 

[David Lewis]

Upon retesting, this function does appear to work when
creating a new project (one of the three options for the
import). I tested it previously by appending it to an
existing project, and that does give screwy results.

Here is an illustration. I created a project file,
exported it and imported it via excel using the same map.
Here is the original (lines 1-8):

Name Succ Pred
task 1 2
task 2 4 1
task 3 4
task 4 6 3,2
task 5 6,8
task 6 8 4,5
task 7 8
task 8 7,6,5

and here is what it looks like after importing by appending
to a completely fresh/empty project. Note the new tasks
(9-11) created without names.

Name Succ Pred
task 1 9,2
task 2 10,4 1
task 3 9,4
task 4 10,6 3,2
task 5 9,11,6,8
task 6 10,8 4,5
task 7 9,8
task 8 7,6,5
1,3,5,7
2,4,6
5

In any case, now that I know it works by creating a fresh
project, I can probably accomplish what I want. I'm not
sure inserting such an import into an existing project
makes total sense. I was just testing that way for convenience.

Thanks. --David.

 

[Guest]

A neat feature of importing would, of course, be transient
task id's in the external file (Excel or whatever), that
were just used for specifying predecessors and/or
successors, and resolved to the MSProject line number (ID)
upon import. With that, it would be a lot easier to import
fragments of a project.

--David.