P6005 - Create WBS Structure from Excel to Primavera P6 in 5 Minutes

Поділитися
Вставка
  • Опубліковано 6 вер 2024
  • WBS Structure to create from Excel to Primavera in 5 minutes.
    Work Smartly and Increase your productivity.
    Follow the link to watch other Advance Primavera P6 Tutorial Videos.
    • HOW QUICKLY WE CAN CRE...
    Follow below link to watch Previous Training Sessions
    Free Online Primavera P6 Training Session 1
    • P6001 - Free Online Pr...
    Free Online Primavera P6 Training Session 2
    • P6002 - Free Online P...
    Free Online Primavera P6 Training Session 3
    • P6003 - Free Online Pr...
    Please subscribe to my UA-cam channel to remain informed of new videos and following Training session.
    / @projectplanningtacts5330
    Join Facebook Group
    / 1171501816550855
    Connect on LinkedIn
    / irfan-khan-lodhi-5a135394
    #projectplanningtacts #students #engineers #training #free #primaverap6 #planning #projectcontrols #construction

КОМЕНТАРІ • 63

  • @TripleXQUSAI
    @TripleXQUSAI 3 роки тому +1

    thank you very much, you are LIFE SAVER i really appreciated the helping its very useful & fast, i wish you the best

  • @osamaalshaer7523
    @osamaalshaer7523 Рік тому

    Amazing method to create WBS faster. Thanks Irfan, good job

  • @thenedak
    @thenedak 2 роки тому +1

    Thanks a lot my Friend i know when we work together that you are great Planner this vedio help me too much today

    • @projectplanningtacts5330
      @projectplanningtacts5330  2 роки тому

      It's a pleasure to get a kind feedback from one of the best planners I have worked with. 💪

  • @ziya-ur-rahman3852
    @ziya-ur-rahman3852 Рік тому

    Great job bro
    You make it so easy
    Huge respect to you.
    Keep it up 😊

  • @venkineelath1423
    @venkineelath1423 3 роки тому +1

    Really an awesome trick to upload WBS

  • @danialshaikh7796
    @danialshaikh7796 6 місяців тому

    Thanks a lot bro🤍🤍🙏🙏🙏🙏

  • @muhamedessawy3662
    @muhamedessawy3662 4 місяці тому

    Thanks and appreciate your report

  • @yonghwalee-sc4817
    @yonghwalee-sc4817 4 роки тому

    It is smart way of WBS development in P6 ! But just in case we should make a backup before doing this job. Thank you for information.

    • @projectplanningtacts5330
      @projectplanningtacts5330  4 роки тому

      Yes, it is. I always recommend to have Backup files. I have created a Backup in this video as well.
      Thanks for your feedback.

  • @dionesiocapili2705
    @dionesiocapili2705 3 роки тому +1

    Great Stuff. Keep it coming!

  • @muhamedessawy3662
    @muhamedessawy3662 Рік тому

    Great my brother

  • @karunanandalelwala9710
    @karunanandalelwala9710 8 місяців тому

    Hi, it is a quick method to create Activities. However, your explanation is very fast and difficult to follow. Could you explain the chart in Excel in a more clear way so that understanding that could be easier. I would suggest you to follow how these things are explained like in TENSIX for example

  • @gilanglois1078
    @gilanglois1078 Рік тому

    I like this video >3

  • @mdwajeedali403
    @mdwajeedali403 Місяць тому

    Hi sir thnx
    Can u please tell how u have updated from note pad file to WBS file

  • @abdel-nasermohammad5848
    @abdel-nasermohammad5848 8 місяців тому

    AWESOME , THANK YOU ALOT BRO

  • @businessshout228
    @businessshout228 Рік тому

    Great 👍

  • @roomto820
    @roomto820 4 місяці тому

    Hello Sir
    If sequence no. are not come at Excel sheet .
    Then how to solve this problem😊

  • @munawarjack91
    @munawarjack91 3 роки тому +1

    Aslm Mr.Irfan saheb I m a regular viewer of ur UA-cam videos on primavera p6 on wbs but i need to learn how u prepare excel wbs in excel and if u have prepare relationships feom excel to p6 tutorials then share it link to learn more about it i will be thanks for your help Alhz

    • @projectplanningtacts5330
      @projectplanningtacts5330  3 роки тому

      Thank you for watching my videos. If you follow the video you understand how I am defining the codes. There is a logic behind it but not any external links etc. Try to understand the method. I do not keep excel files for videos. I demonstrate and remove it. Good luck 👍

  • @shijukoshy7649
    @shijukoshy7649 6 місяців тому

    Can you share the Excel file for practice

  • @ssarkar2006india
    @ssarkar2006india 2 роки тому

    Very nice

  • @nooni3420
    @nooni3420 3 роки тому +1

    Salam Irfan this is awesome stuff. Can you please upload a video for how to update big schedules from subcontractors by using excel to p6.

    • @projectplanningtacts5330
      @projectplanningtacts5330  3 роки тому

      W Salam
      Please have a look
      ua-cam.com/video/BDnJn4ro5Sk/v-deo.html

    • @nooni3420
      @nooni3420 3 роки тому

      @@projectplanningtacts5330 thanks Irfan bhai but this is uploading activities. I meant to say receiving monthly progess updates from subcontractors in excel and uploading them in p6. I have heard that big schedules like 15,000 activities. Mostly planners dont update the schedule in p6. They get their subcontractors to provide updates in excel and then planner uploads them to p6. I am sure you must have come across this.

    • @projectplanningtacts5330
      @projectplanningtacts5330  3 роки тому +1

      @@nooni3420 as long as you have updates in excel, you can update those activities through import to P6. The process is same as I mentioned earlier.

    • @nooni3420
      @nooni3420 3 роки тому +1

      @@projectplanningtacts5330 Makes sense. Thanks :-)

  • @rogeriopsvalle
    @rogeriopsvalle 2 роки тому

    Mr.
    I hope this message finds you well.
    Do you have by any chance, tips or Works related to criation of S Curve with primavera P6 conected to SQL DB
    If you could share I would aprecciated.
    Thanks in advance
    Regards.

  • @neonk3655
    @neonk3655 Рік тому

    thank you so much for this!
    Quick question, when i use arabic names, the notepad doesn't like it and doesn't save them and give me ????????? instead. do you know how to fix it?

  • @feroskhan9529
    @feroskhan9529 4 роки тому +1

    Please upload- How to add relationship from Excel to Primavera P6

    • @projectplanningtacts5330
      @projectplanningtacts5330  4 роки тому

      I will upload it sooner

    • @turgutboyacilar2884
      @turgutboyacilar2884 2 роки тому

      @@projectplanningtacts5330 sir, any updates? i could not found anything on your youtube profile. btw thank you for all these informations. may god bless you

    • @projectplanningtacts5330
      @projectplanningtacts5330  2 роки тому +1

      @Turgut boyacilar Hi, I have been very busy with some commitments, but I will resume these videos soon.

    • @turgutboyacilar2884
      @turgutboyacilar2884 2 роки тому +1

      @@projectplanningtacts5330 thank you so much i look forward to it

  • @rubenaugustine8666
    @rubenaugustine8666 2 роки тому

    Thank you for this video. Wh I tried to import the file, P6 closed up. Any thoughts?

    • @projectplanningtacts5330
      @projectplanningtacts5330  2 роки тому +1

      If it happens again and again you need to check if your machine is not performing good. I don't think it's P6 issue. You may also try to uninstall and reinstall P6.

  • @ramiepayas909
    @ramiepayas909 2 роки тому

    I found this method but it doesn't seem to work on my P6 V21.
    It always has an error message with this. I tried importing 279 WBS.
    Import Failed: The import file contains projects with invalid parent WBS IDs. The following WBS nodes do not have a valid parent_wbs_id in the wbs_id field.
    Tried it multiple times but it has the same error message.

    • @projectplanningtacts5330
      @projectplanningtacts5330  2 роки тому +2

      I believe you might be missing something.
      The method is same for any XER file regardless of the p6 version.
      Well, I haven't tried that in p6 v21

    • @ramiepayas909
      @ramiepayas909 2 роки тому

      @@projectplanningtacts5330 I created the Project and then the exact WBS Structure in P6 with 276 WBS Items. I exported the XER File, then I just renamed the WBS Name. When I imported back the XER File in P6 it says:
      Import Failed: The import file contains projects with invalid parent WBS IDs. The following WBS nodes do not have a valid parent_wbs_id in the wbs_id field.
      I just can't seem to execute this process. It is quite time consuming to manually type all 276 WBS Name in P6.

    • @ziya-ur-rahman3852
      @ziya-ur-rahman3852 Рік тому

      Make sure all of your stuff in excel must be in text firmate

  • @mohamedgasim2526
    @mohamedgasim2526 3 роки тому

    PLEASE! I want know how to create activity relationships by excel and imported them to p6?

  • @lasanthawalgampola9394
    @lasanthawalgampola9394 Рік тому

    Its good but it doesn't update WBS structure for some reason

  • @Muhammadjaved-qi8nr
    @Muhammadjaved-qi8nr 3 роки тому

    Sir, Please primavera download and installation is b 1 led den.

    • @projectplanningtacts5330
      @projectplanningtacts5330  3 роки тому

      Hi
      Please follow the link
      facebook.com/groups/1171501816550855/permalink/1177583062609397/?sfnsn=mo

  • @syedobaid8598
    @syedobaid8598 Рік тому

    Can you please share this file

    • @projectplanningtacts5330
      @projectplanningtacts5330  Рік тому +1

      I haven't kept the file but it's not a format but a logic which is explained in the video. You must understand the logic and implement to your required WBS.

    • @syedobaid8598
      @syedobaid8598 Рік тому

      @@projectplanningtacts5330 Brother i have use this and it worked , but when i went on using it again its not working, as when i try to copy the wbs using notepad there is something else coming up along with the export, which is guid, templ guid, plan open state, how to resolve it ??

    • @projectplanningtacts5330
      @projectplanningtacts5330  Рік тому

      @@syedobaid8598 you need to find out what you have missed or added from the xer file data except replacing the wbs part of the xer in notepad.
      Basically you need to only change the wbs section from xer in notepad.

    • @syedobaid8598
      @syedobaid8598 Рік тому

      @@projectplanningtacts5330 i have changed the WBS only, the main issue is when i export the xer file and open it in the notepad there is some extra columns are coming which are not symmetrical to each other , for example we have all the others columns same which we can copy and paste by adding no. of rows as per your no. of wbs, but these extra columns has some different different texts and words which are not identical, and the extra columns are guid, templ guid, open state,
      as the data is not identical when i copy and paste also its not working , i have shared one email along with the pictures on your gmail. for better understanding of the issue

    • @ziya-ur-rahman3852
      @ziya-ur-rahman3852 Рік тому

      Bro before pasting it on note pad make sure your excel stuff in text formate