How To Bulk Upload Resources Data to Primavera P6 Using Excel

Поділитися
Вставка
  • Опубліковано 15 вер 2024

КОМЕНТАРІ • 55

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

    right to the points, thanks

  • @scottymac734
    @scottymac734 7 місяців тому

    Very good. Right to the point. Best way to share tutorial info.

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

    Thank you you saved my ass right before deadline
    You da best

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

    Bless you! Thanks. I have through about it and find your video. You better then me in this by 1 step! Best regards!

  • @Aryanss5743
    @Aryanss5743 3 роки тому +3

    Hi Sir.Your videos are too much helpful and informative.
    I have one request please can you make a video on how to calculate manpower for a project of atleast 5000 activities

  • @tylerguzinski6772
    @tylerguzinski6772 3 місяці тому

    Very helpful! thanks!

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

    Good example... giving me to explore others technique...as well

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

      Glad it was helpful!, Sure will post more, please subscribe to channel and support.

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

    in this point was useful. many thanks. Could you please generate a video on how to calculate manpower for a project over 4000 activities

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

    Very nice, well done

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

    Hi, If multiple resources are to be assigned for each activity

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

    Hai sir,
    In this video u have shown the excel which you already calculated the budgeted unit's could u please share more information how you have calculated the budgeted unit's.....

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

    Yes, here created resources are assigned to the activities in XER since Resource ID column in excel sheet is filled with created ID's (T1, T2 & T3) respectively...

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

    thanks a lot

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

    Hi, Pls put Video for Resource uploading for all three type resources ( Labour, non labour and materials ) and for cost loading...

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

    Good guidance 🤠

  • @RamA-xd6bt
    @RamA-xd6bt Рік тому

    Thanks for the details and is it possible to upload multiple projects at the same time also could you please elobarate on XER file while you import the data. Looking forward.

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

    hai superbbb

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

    Hi sir, I am working on a base plan of highway project with around 500 activities. I need to load multiple resources types with multiple budgeted quantities against each activity.
    Say earthwork in embankment will attract excavator, dumper, grader, vibrio roller, water tanker, borrowed earth etc. each having different budgeted resources quantities and different BOQ quantities as well. How to do this by excel export and import?
    Your kind support will help me a lot.

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

    Hi, Followed step by step. While importing the file, an error is occurring which is as below-
    The User Preferences used to create this Excel file are not the same as your current preferences. Importing this file could corrupt your data. Please refer to Help for more information about importing data from Excel. Are you sure that you want to continue?
    Can you pls help me out in this?

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

      Hi, First export the schedule into excel to get the right format and then import post entering the data into the excel sheet.

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

    I try this method too but idk in articles which i read dont recommend this method because it can cause some errors.thats why i always assign resources one by one in p6 not using excel

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

    How can we uniquely identify a container WBS element in primavera?

    • @scottymac734
      @scottymac734 7 місяців тому

      Us the Filter tab when selecting fields in the export template.

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

    I want to learn the offline course. Could you provide me.

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

      sure, please write to info@dptutorials.com

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

    Is it possible to add more than 1 resources to an activity through Xel to Xer??How?

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

      yes, it is. Its already shown in this video. you need to just enter the same in a new row for new resource.

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

      I got it..For every new resource copy and paste the respective activities again and again...What if I put “comma” inbetween adding second resource in the same cell of the column( adding two resources inside same cell with comma in between)

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

    How to add Rod,Cement, Stone under multiple activities???

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

    is it possible to import new resources from excel to P6? if yes how.

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

      Yes, It is like normal import only, File > Import > Select Spreadsheet-(XLS).
      I will try to publish a short video on this soon.

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

      @@dptutorials Thank you, please do short video for this.
      I have already tried to import it but the NEW resources wont add to the resource list on P6.

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

      @@dptutorials i think it is not possible to import new Resources to P6. Because Primavera can't read "Resource Type".

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

    Can you please explain how to import the "Resource Names" because the exported excel file has an Asterix (*) in the Resource Name field and is therefore "Un-editable" and ignored by P6 during import.

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

      You can replace the * in the excel

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

    Hi dp...
    Please explain the process slowly! you are very fast sometimes...rest Kudos!

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

      Sure aman, will consider this feedback.