Import of csv losing predecessor

[dave1000]

Hope someone can help me out here. When I import from a .csv file, I am losing the predecessor for some tasks and not others. I have seen the text in the .csv file and it looks fine, but upon import it gets lost for some tasks and not others?

 

[PDQBach]

How did you create your import map? I'm asking in case you have transposed a couple of columns or, perhaps, are importing the spreadsheet column that contains successors into the Project column expected predecessors.

(In other words: are you certain your CSV layout exactly mirrors the Project import map?)

In addition, as a quick workaround, how about copy&paste from the spreadsheet into Project. Perhaps, too, that will generate some error diagnostics that point to a solution to your more general situation.

 

[dave1000]

All good suggestions, but however, I don't think they will help. As I mentioned, this works perfectly sometimes and other times it does not. These rows that fail to update properly are 10 or 20 records into the csv file. Just for kicks, I trimmed the file such that these rows were the only rows in the file and at the top, and it worked.

Go figure? I think MS Project has some problems in parsing these csv files.

Anyway, thanks for your reply

 

[PDQBach]

Fascinating.

I was working on the theory that either you had flipped a couple of columns so there was a mismatch or that one or more of the tasks had a constraint that was causing issues.

What version of Project are you using?

 

[dave1000]

Version is Project Professional 2002 (10.0.2002.0502)

Thanks,

 

[PDQBach]

My earlier message was edited by the mods to eliminate my email address. I was hoping to get a sanitized copy of your file so I could try a few things on it. I'm using 2003 Pro at home

I suppose you could sanitize it and then simply include it in your email. You'd have to post a description of your import mask, too.

Sorry. Wish I could do more follow-up for you. :-(