Problem when exporting Excel => MS Project (2002)

[aelmalki]

Hello,

I make an export from Excel to MS Project (2002), the concern is tha
MS Project has a logic of data processing, it begins to change my dat
in that logical

I'd like to know how to disable this change when exporting?

Thank you very much

 

[Jan De Messemaeker]

Hi,

Most calculations can be "avoided" when in MS Prokect you go to Tools, then
Options, the Calculation, set to Manual.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[aelmalki]

Thank's for reply

This problem is detected in the Date data, calculate manual is no
supported this

How can i make a export excatly data Excel from MS Project.

Thank you again

 

[JulieS]

Hello alemalki,

I don't understand. The dates you see exported to Excel are the
dates and times from Project. In what way are you seeing
differences? Are the dates changing?

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

 

[Mike Glen]

(Julie, I think he's talking about Excel to Project)

Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials


Hello alemalki,

I don't understand. The dates you see exported to Excel are the
dates and times from Project. In what way are you seeing
differences? Are the dates changing?

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

 

[JulieS]

You're right, Mike

Sorry, alemalki. However my question is still -- what date data are
you importing from Excel to Project -- what dates do you expect to
see and what dates are you seeing?

Julie

"Mike Glen" <mcglenAThotmail.com> wrote in message
(Julie, I think he's talking about Excel to Project)

Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials


Hello alemalki,

I don't understand. The dates you see exported to Excel are the
dates and times from Project. In what way are you seeing
differences? Are the dates changing?

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

 

[aelmalki]

Julie thank you for your reply

I have 5 date columns in an Excel sheet, and I map those columns with
columns MS Project, I want to import these columns as in MS Project
without having criteria date superior or other...

Consider an example:
I have 4 date : Beginning Date Project 01/02/2009 | End Date Project
01/09/2009 | Start date Task 03/*01*/2009 | End Date task 03/03/2009

If I import such data into MS Project => an error message tells me that
the Start date Task and less than the Beginning Date project, MS Project
will truncate these values.

Is that there's a way to have these dates (even if they are wrong) in
MS Project ???

Thank you very much !
I really need your precious help...

 

[JulieS]

Hello Aelmalki,

Firstly, you're welcome and thanks for staying with this.

If I understand you correctly, you are attempting, in your example,
to import a task into a project with the following definition:

Project Start date: 01 Feb 2009

You are trying to import a task with a start date of 03 Jan 2009.

You are seeing a message from Project similar to:
"The start of Task X of "your file" is before the project starts.
Try one of the following:
- If you want the project to begin on this date, change the project
start date.
- If you entered a constraint that results in a task start date
earlier than the project start date, change either the constraints
or the project start date."

I just tried the process above on Project 2003. Despite the error
message, I was able to import tasks with start dates prior to the
start date of the Project. I don't know what you mean by
"truncates". Are you seeing the tasks not imported?

There isn't any way to make project ignore the start date of a
project. The start date of the project really should be the start
date of the earliest task. Is there a reason why you cannot set the
project start date to match the earliest date of any task?

Julie

 

[aelmalki]

thank you Julie for your reply

The Project file on which I work, unfortunately, this is not me wh
create.

Is this you can point me to change the constraints fields MS Project?

Thank you very much

 

[JulieS]

You're welcome alemalki.

You can add the Constraint Type field to a task view through Insert

Column. Once you insert the field, you can change the constraint

type back to As Soon As Possible (in a project scheduled from a
start date) and As Late As Possible (in a project scheduled from a
finish date.)

I hope this helps.

Julie