I am currently using Deltek Open Plan Verison 3.2.0874. I am modifying the script in the Transfer.dat in an attempt to import Progress via Microsoft Excel. Here is the script I’ve written thus far:
IMPORT csv PROGRESS UPDATE
DATE_FORMAT %C/%M/%D
TABLE ACT
UPDATE
FIELD ACT_ID
FIELD ASDATE
FIELD AFDATE
FIELD PROGTYPE
FIELD PROGVALUE
FIELD PPC
I do not wish to overlay any existing data in the project. I would like it to "update" the exisitng information that’s there or if there isn’t data, for example in the Actual Start or Actual Finish date fields then write to it. However, thus far I have not been successful in accomplishing this. Its not updating the ASDATE/AFDATE, the script is making them null. Is it the format of my date field prior to importing? Could you please provide me with what it is I am doing wrong? Am I missing something? Thanks!
IMPORT csv PROGRESS UPDATE
DATE_FORMAT %C/%M/%D
TABLE ACT
UPDATE
FIELD ACT_ID
FIELD ASDATE
FIELD AFDATE
FIELD PROGTYPE
FIELD PROGVALUE
FIELD PPC
I do not wish to overlay any existing data in the project. I would like it to "update" the exisitng information that’s there or if there isn’t data, for example in the Actual Start or Actual Finish date fields then write to it. However, thus far I have not been successful in accomplishing this. Its not updating the ASDATE/AFDATE, the script is making them null. Is it the format of my date field prior to importing? Could you please provide me with what it is I am doing wrong? Am I missing something? Thanks!