Hi Irfan, so once you have done the import to p6 from excel when do you change the data-date. Or you change the data-date first and then export the file to excel and do your updates and import back. Im interested to know at which point exactly we change the data-date.
It depends what purpose would you like to export and import. If it is only for updating the activities then the data date is irrelevant to change or not. When you export and import back with updates, you would update Activity %, Actual Dates. So if you change the data date and export with Start and Finish, you can't import Start and Finish as these dates do not change.
If you use Physical % Complete then it is recommended to export Activity %, Actual Start and Finish and Remaining duration for Inprogress activities, update these fields and import back and then change the data date.
While I exporting the data my start date is in the format 04-05-2020 8.00 AM..... after updating the actual start and import the data back ....my some files are updated but there is a warning message not successful......i try so many times.....same error is coming....I rechecked the data ....like status, remaining duration, Activity % complete...and I changed the P6 text too.........but still error can u help me
Try to keep the same format as dates come through export, better to take 24 hours time format. Actual dates should update as you feed the data it is not dependent on duration or % complete.
Please watch the Video lecture 1 from my Channel Video Playlist. There are more upcoming videos to be released soon where I am going to cover all the aspects of basic Primavera training. Thank you for watching please subscribe my channel for not missing upcoming videos.
Is it required to manually update the Activity Status? I hope it will be automatically done after importing in P6...and don't you recommend keeping the Activity % complete of excel in "text" before importing in P6. Waiting for your inputs...
Hi Feros, You need to update the Activity Status as per the current updates in the spreadsheet which you're gonna import to P6. It doesn't matter either you keep Text format, Number or General for Activity % Complete. I hope it clarifies your query. I am going to upload the video about To create Resources and Assign Budgeted Units through Export and Import soon. Please subscribe my channel to get notified for future videos. Thank you
Blessings for you, the most helpfull tutorial ever
Thanks @wendy
VERY USEFUL THANKS
Thank you
Hi Irfan, so once you have done the import to p6 from excel when do you change the data-date. Or you change the data-date first and then export the file to excel and do your updates and import back. Im interested to know at which point exactly we change the data-date.
It depends what purpose would you like to export and import. If it is only for updating the activities then the data date is irrelevant to change or not.
When you export and import back with updates, you would update Activity %, Actual Dates.
So if you change the data date and export with Start and Finish, you can't import Start and Finish as these dates do not change.
If you use Physical % Complete then it is recommended to export Activity %, Actual Start and Finish and Remaining duration for Inprogress activities, update these fields and import back and then change the data date.
SIR I WHICH SOFTWARE R U USING TO MAKE TUTORIAL? KINDLY EXPLAIN
Grab onine
While I exporting the data my start date is in the format 04-05-2020 8.00 AM..... after updating the actual start and import the data back ....my some files are updated but there is a warning message not successful......i try so many times.....same error is coming....I rechecked the data ....like status, remaining duration, Activity % complete...and I changed the P6 text too.........but still error can u help me
Try to keep the same format as dates come through export, better to take 24 hours time format.
Actual dates should update as you feed the data it is not dependent on duration or % complete.
Is There any possibility/plan to start primarvera from scratch for the beginners or any suitable link
Please watch the Video lecture 1 from my Channel Video Playlist.
There are more upcoming videos to be released soon where I am going to cover all the aspects of basic Primavera training. Thank you for watching please subscribe my channel for not missing upcoming videos.
This video is expert user of Primavera who already works but doesn't know about Export and Import option. Thank you
Is it required to manually update the Activity Status? I hope it will be automatically done after importing in P6...and don't you recommend keeping the Activity % complete of excel in "text" before importing in P6.
Waiting for your inputs...
Hi Feros,
You need to update the Activity Status as per the current updates in the spreadsheet which you're gonna import to P6.
It doesn't matter either you keep Text format, Number or General for Activity % Complete.
I hope it clarifies your query.
I am going to upload the video about To create Resources and Assign Budgeted Units through Export and Import soon.
Please subscribe my channel to get notified for future videos.
Thank you
Thanks Irfan...Subscription is done from my side...
What about the remaining duration
You can import Remaining Duration as well.
Sir Please Mere Ek File Hai, Usko Mein Primavera P6 MS Project Ko Export Our Import Kar Raha Ho, But Nahe Ho Raha, Kindly Please Help Me.
You need to match the format between MS project export file and P6 Import.