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
Member for
16 years 7 months
Member for16 years7 months
Submitted by Gary Whitehead on Fri, 2009-11-06 09:54
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 xmls or even the sample xmls that came with Open Plan 3.3.1? If so please email me @ sherell.estrada@baesystems.com :)
Member for
22 years 3 months
Member for22 years3 months
Submitted by Kevin Button on Mon, 2009-09-14 20:48
Im new to OPP and have found date import a bit touchy. If you havent yet found a solution to your problem, you could try saving your excel file as .txt then try importing that.
Cheers
Member for
22 years 10 months
Member for22 years10 months
Submitted by Ronald Winter on Tue, 2009-07-14 10:29
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!
Member for
16 years 4 months
Member for16 years5 months
Submitted by SHERELL ESTRADA on Wed, 2009-07-01 18:58
I dont have a problem with importing the Progress% its the actual dates. The Actual Start and Actual Complete dates Im having issues with importing. Its not updating the dates whatsoever. With a 160000+ line item schedule updating progress is very tideous. Thus the purpose behind this script.
Ive honestly tried it both ways a 100 times and am still unable to get the dates import successfully. The developers 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. Ive also exported the file and formated in the way its exported...which is General and it doesnt import the dates that way either. What am I doing wrong!?!?! (Im at boiling point)
Member for
16 years 7 months
Member for16 years7 months
Submitted by Gary Whitehead on Wed, 2009-06-10 08:26
Its 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
Member for
13 years 11 monthsGents, OPP Professional
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
Member for
16 years 7 monthsRE: Open Plan Transfer.dat Issue
Sorry, Sherell -I knew it had to be in csv format all along, but didnt think to mention it!
Glad you sorted it out.
Cheers,
G
Member for
16 years 4 monthsRE: Open Plan Transfer.dat Issue
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 xmls or even the sample xmls that came with Open Plan 3.3.1? If so please email me @ sherell.estrada@baesystems.com :)
Member for
22 years 3 monthsRE: Open Plan Transfer.dat Issue
Im new to OPP and have found date import a bit touchy. If you havent yet found a solution to your problem, you could try saving your excel file as .txt then try importing that.
Cheers
Member for
22 years 10 monthsRE: Open Plan Transfer.dat Issue
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!
Member for
16 years 4 monthsRE: Open Plan Transfer.dat Issue
I dont have a problem with importing the Progress% its the actual dates. The Actual Start and Actual Complete dates Im having issues with importing. Its not updating the dates whatsoever. With a 160000+ line item schedule updating progress is very tideous. Thus the purpose behind this script.
Member for
19 years 10 monthsRE: Open Plan Transfer.dat Issue
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
Member for
16 years 7 monthsRE: Open Plan Transfer.dat Issue
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!
Member for
16 years 4 monthsRE: Open Plan Transfer.dat Issue
Ive honestly tried it both ways a 100 times and am still unable to get the dates import successfully. The developers 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. Ive also exported the file and formated in the way its exported...which is General and it doesnt import the dates that way either. What am I doing wrong!?!?! (Im at boiling point)
Member for
16 years 7 monthsRE: Open Plan Transfer.dat Issue
Its 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