(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
Hello Everyone,
Need some help. Can we Export Activity to Excel and then populate the resorce in it and import it back to P6. And that too if the same activity has multiple resource like,
Activity - Foundation for Tank
Resource:
Steel Fixer - 40 Hrs
Carpenter - 16 Hrs
Mason - 16 Hrs
Labor - 112 Hrs
I would like to see in the imported Excel something like this so that it easy to load the resource,
| Activity ID | Activity | Steel Fixer | Carpenter | Mason | Labor |
| A-1000 | Foundation for Tank | 40 | 16 | 16 | 112 |
Thanks
Jithin
Printer-friendly version
Send to friend
assign the resources to the activities in p6 then export to excel then populate then import to p6
Kirill,
Thank you, I look forward to seeing more about it.
Unfortunately there are no materials in English for now.
We are in the process of creating a new website, the English version will be ready in a month i think.
Unfortunately there are no materials in English for now.
We are in the process of creating a new website, the English version will be ready in a month i think.
Kirill,
Thats an interesting application - but seems to be only available for the Russian market? Is there any infromation availabel in English - other than a website auto-translation?
I think you are looking for something like this:
Hi Kannan,
I stared doing that. Filter it by Activity ID then populate.
Ya that is one more Idea, let me see which would be faster and better.
Regards
Jithin
Jithin,
The XLS import/export work as the Database tables are written, to have one line per activity with all the resoures horiztonally would not be a flat data file.
You could develop some excel forumals using INDEX and VLOOKUP formulas to achieve what you're after.
Hi Jithin,
I believe that after the exporting, you can't change the basic structure of the excel file ( top-down to horizontal).
You can filter the act-ID and populate the resource units much faster in the excel file, and then you can import it.
BR
Kannan
Hi Santosh,
Ya did that and Yes it showing but in a Horizontal Way. Like if for 1 Activity if there is 10 Resource then the 10 Resource would be shown Vertically.
But before it is been exported under the Template, in the Subject Area you have to select Resource Assigment and add the related columnn
If the resource was shown Horizontally per Activty then the Resource loading would have been better.
Thanks
Regards
Just manually populate one activity with the resources and units you want to include.
Then select FILE>EXPORT>XLS>RESOURCE ASSIGNMENTS and it will be easy to see how this is done
Then complete populating in Excel and select FILE>IMPORT>XLS and point to the same file exported above.
Hi David,
Thanks, could you guide me with an example like how the template would be in actual. I am in Oil and Gas same as you, so my current scenario for example there is a deliverable Design Basis for which all the Dicipline needs to give there input so that 1 Deliverable would have hours of Process, Mechanical, Piping, Electrical, Instrumentation, Civil. So I need to put hours of all of this dicipline into to this Delvierable as a separate resource.
I will be working on a Project in which there would be many engineering deliverable.
So could you help me out with an example
Regards
Jithin
Jithin,
Yes you can export a template of resource assignments, and import them with new values BUT it cannot be done in the format you want.
It must be one row in the spreadsheet, one resource assignment:
A-1000 Steelfixer 40
A-1000 Carpenter 16
A-1000 Mason 16
etc.
Email: PPadmin@planningplanet.com
Replies