FileOpen command

[knubie birkland]

Posted in generals section also. The startdate is incremented with the Work
hours when I import tasks with the Fileopen command in VBA. The is not a
standard Project calculation is it? If I import Startdates without Work and
then type Work hours manually, startdate is not incremented. Constraint type
is even "Must start on". Is this a bug maybe?

 

[JackD]

What do you mean incremented?
You need to post some code for use to make sense of this.

 

[knubiedoo]

Hi
I use this function:
ActiveProject.Application.FileOpen Name:=gsDir
"\activity_convFrom.TXT", Merge:=pjMerge, TaskInformation:=True
Table:="ConvFromFile"

In the file "activity_convFrom.TXT" the Constraint type is "Must star
on" Startdate is "01.OCT.2004 08:00" and Work is 8 hours. Calendar i
set and the resource has no other work.
After import the startdate is set to "01.OCT.2004 16:00" on the task
The startdate has work added (incremented) to it!
Weird, so I have been trying to figure out this one, if I import task
without Work (0) or with Actual Work set to some value, the Startdat
is set correct. The constraint type is "Must start on" which shoul
overrule anything else, right??


-
knubiedo

 

[JackD]

Importing data like this can be tricky. Somewhere in the help it explains
the order of precedence, but I'm too lazy to look it up for you. If you are
having problems I'd make sure I have something unique as a merge key and
even try importing it in a couple of passes