is there any other way besides map that can import data from csv f

[Joy]

is there any other way besides map that can import data from csv file to ms
project


we encountered an issue with MS 2007. we use UniqueID as merge key to import
tasks' fields to MS 2007. it is strange that each time we do this,
predecessor field will be lost after map. it has not such issue with
versions<2007.

then we use a workaround way to copy pred fields to a field first and then
copy it back. it works fine if pred fileds only have some numbers. however,
the macros run slowly if there are a lot of linked predecessros like
'c:\1.mpp\2'

I am thinking about how to use another way than map to import data so the
pred filed calue will not be lost and the macros run fast ...thank you

 

[JulieS]

Hi Joy,

There was a problem with Project 2007 SP-1 losing predecessor
information on importing data from Excel which may very well be
occurring using the CSV file. I believe the Infrastructure Update
from July 2008 fixed that. Do you have the IU installed?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Joy]

Yeah, after I install IU, it works.

Thank you

another thing is how can I get updates infor of MS project?

 

[JulieS]

Great, I'm glad to hear the IU fixed the problem. Usually updates
for all Office Products are installed through Office Update. I
don't recall if the IU was pushed through Office Update or not. You
can certainly keep an eye on several of the Project Blogs to also
get the latest information on what is going on. See:

http://blogs.msdn.com/project/default.aspx

for starters.

Julie