Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Open Plan Transfer.dat Issue

11 replies [Last post]
SHERELL ESTRADA
User offline. Last seen 14 years 18 weeks ago. Offline
Joined: 9 Jun 2009
Posts: 12
Groups: None
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. It’s 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!

Replies

abrugar jons
User offline. Last seen 7 years 40 weeks ago. Offline
Joined: 23 Jan 2017
Posts: 9
Groups: None

Such a Great Post

 

Thank you all

Kenneth Rodrigues
User offline. Last seen 8 years 8 weeks ago. Offline
Joined: 23 Nov 2011
Posts: 10

Gents, OPP Professional Transfer.dat works 100% fine. You problem is with the Date format.

Please read the Developer Manual or use the Online context sensitive Help. It does give you the relevant formats for the Date before data can be Import to or from Excel. But Importing is one have to be very careful it demands certain requirements if not it will corrupt your schedule only. So if you don't bother to read the manual then just then ditch that idea and join the real world and enter update manually as Mike Testro said.


If you over complicate things ...it leads to just more work for you. Also not all Activities update all at the same time even with a 100 nodes Schedule. 

Best regards , Kenneth

 

Gary Whitehead
User offline. Last seen 5 years 22 weeks ago. Offline
Sorry, Sherell -I knew it had to be in csv format all along, but didn’t think to mention it!

Glad you sorted it out.

Cheers,

G
SHERELL ESTRADA
User offline. Last seen 14 years 18 weeks ago. Offline
Joined: 9 Jun 2009
Posts: 12
Groups: None
I found a solution. The save the xls as a csv however for it to import the dates correctly I ad to do a custom format of the dates as such: yyyy/mm/dd. Hopefully, my dilemma helps someone else going through this. I was wondering if anyone have any special xml’s or even the sample xml’s that came with Open Plan 3.3.1? If so please email me @ sherell.estrada@baesystems.com :)
Kevin Button
User offline. Last seen 2 years 45 weeks ago. Offline
Joined: 16 Jul 2003
Posts: 112
Groups: None
I’m new to OPP and have found date import a bit touchy. If you haven’t yet found a solution to your problem, you could try saving your excel file as .txt then try importing that.

Cheers
Ronald Winter
User offline. Last seen 3 years 34 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None
Perhaps OP is expecting you to import text when you import a date. When you enter a date into an Excel sheet, it automatically converts it into a Julian Date (a double number) and then translates this into the date and time that you see on the screen. When you export this field to OP, you are actually exporting a double number.

I do not have OP, so this is only a guess; try this to see if it works. Format your date fields at “Text” and then enter your dates. Now try an export to OP. It’s worth a try. Good luck!
SHERELL ESTRADA
User offline. Last seen 14 years 18 weeks ago. Offline
Joined: 9 Jun 2009
Posts: 12
Groups: None
I don’t have a problem with importing the Progress% it’s the actual dates. The Actual Start and Actual Complete dates I’m having issues with importing. It’s not updating the dates whatsoever. With a 160000+ line item schedule updating progress is very tideous. Thus the purpose behind this script.
Mike Testro
User offline. Last seen 33 weeks 7 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Hi Sherrel

In every form of software that is worth anything you can set up a "Progress %" column and copy paste directly from excell into the column - job done.

Have you thought of that?

If you do not have the facility in Open Plan then ditch it and join the real world.

Best regards

Mike Testro
Gary Whitehead
User offline. Last seen 5 years 22 weeks ago. Offline
In that case I am at a loss, I’m affraid.
I don’t have OP any more so I can’t have a play and work it out, but I still think it will be the date format.
Is there anyone else you know that has successfully imported dates? Maybe you could take a look at their script & import file?

Good luck!
SHERELL ESTRADA
User offline. Last seen 14 years 18 weeks ago. Offline
Joined: 9 Jun 2009
Posts: 12
Groups: None
I’ve honestly tried it both ways a 100 times and am still unable to get the dates import successfully. The developer’s guide states to create a custom date format as such: mm/dd/yyyy hh:mm and save the file in that format prior to import. Which did not work. I’ve also exported the file and formated in the way it’s exported...which is ’General’ and it doesn’t import the dates that way either. What am I doing wrong!?!?! (I’m at boiling point)
Gary Whitehead
User offline. Last seen 5 years 22 weeks ago. Offline
It’s almost certainly the formatting of the dates, yes.

Easiest way to find the correct formatting is to use your script to export existing data from a project into excel, and ensure the formatting on your input sheet matches. That or it is described in the developers guide.

NB: You may want to include remaining duration in your import as well

Cheers,

G