Time Stamps 0:00 Introduction to the Video Activity IDs Change. 0:44 Export Project Activity to Excel xlsx file/User Defined Field. 02:24 Vlookup New Activity ID from Other Excel File. 03:46 Import Back New Excel updated Project File. 04:38 Global Change to replace old to new Activity Id. 05:31 Closing Out of video session.
@@christinecarreon2578 Welcome, it is great if you that you give feedback. a lot of Helping contact has been shared but the people mostly do not focus to share their comments. Your feedback gives me power more to work for you guys.
@@SoftEdemy There are a lot of silent viewers. Myself, included. but your videos, especially this one, helped me a lot that i feel the need to let you know. :) Keep up the good work! :)
Right-click to the file and open the into to notepad. Then edit the notepad file where it's written 20.12 change it into 19.12 and save it. Now you can open to 19.12.
When i import excel its adding them as new activities at the bototm of the project instead of updating the udf nect to the original activity...anyone else havung this issue?
@316OceanDaylight if you id in excel and import back then definitely. P6 WILL add them as new activities. This is not issue. It's basic of P6. P6 identify activity uniquness from their IDS. If you want to update the IDs to same activities than UDF column add their first than add new ids their and when you import in P6 update existing project not add new. It's simple method .
Excellent explanation
Thanks
great work
Thanks
Time Stamps
0:00 Introduction to the Video Activity IDs Change.
0:44 Export Project Activity to Excel xlsx file/User Defined Field.
02:24 Vlookup New Activity ID from Other Excel File.
03:46 Import Back New Excel updated Project File.
04:38 Global Change to replace old to new Activity Id.
05:31 Closing Out of video session.
Thank you for this tutorial! It helped me a lot.
@@christinecarreon2578 Welcome, it is great if you that you give feedback. a lot of Helping contact has been shared but the people mostly do not focus to share their comments. Your feedback gives me power more to work for you guys.
@@SoftEdemy There are a lot of silent viewers. Myself, included. but your videos, especially this one, helped me a lot that i feel the need to let you know. :) Keep up the good work! :)
@@christinecarreon2578 Thanks
Thank you so much 🙏
Thank you
Welcome
XER is not opening in 19.12 as your version is 20.12 can you please export to open old version so all user can import and can work your example
Right-click to the file and open the into to notepad. Then edit the notepad file where it's written 20.12 change it into 19.12 and save it. Now you can open to 19.12.
When i import excel its adding them as new activities at the bototm of the project instead of updating the udf nect to the original activity...anyone else havung this issue?
@316OceanDaylight if you id in excel and import back then definitely. P6 WILL add them as new activities. This is not issue. It's basic of P6. P6 identify activity uniquness from their IDS.
If you want to update the IDs to same activities than UDF column add their first than add new ids their and when you import in P6 update existing project not add new.
It's simple method .
For any query contact us on our email : info@softedemy.com