Open Plan Transfer.dat Issue
Featured Partner
Top Posters
Zainab El-Beialy
3 posts
Kamlesh Parmessur
4 posts
MR JUDE C ANYAEGBU
0 posts
GeoVe
0 posts
Ashkan Mohammadi
0 posts
Jeroen De Bauw
0 posts
Senior Planning Engineer
0 posts
Kristian Mcwilliams
1 posts
dagogo dan - jumbo
2 posts
Alex Lyaschenko
27 posts
Our Partners
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
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
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 @ [email protected] :)
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
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!
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.
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
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!
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)
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