integrating sub contractor schedule and Contractor schedule

K
Kannan CP 👤 Member for 18 years

Hi All,

In our project we have different sub contractors, providng their schedules to update the master schedule. In the beginning, the sub contractor schedule(without resources) was added to the our master schedule. Then I added the resources in our master schedule to make it as the baseline programme-and approved by the Client.

Now during the updating of our schedule, I was trying to incorporate the updated schedule(without resources) of sub contractor in our schedule, by importing it. The problem is that , as the sub cont schedule is without resources, during updating, our resource (budgeted units/cost) in the schedule  is also changing. The start & finish dates are getting updated properly.

How to keep the resources(budgeted units/cost) in my schedule as it is, while importing the sub cont schedule with out resources?

 

Thanks in advance

Kannan

Z
Zoltan Palffy 👤 Member for 16 years 11 months

I am not sure what further needs to be explained just create a new user go to

admin

users (right hand side add users) and create one

then go to admin

then go to security profiles

global profiles then add a new profile call it temp or whatever

then under its Privileges make sure that Delete Resource is not checked

make sure that add resources is not checked

make sure that edit resource is not checked

now when you want to import that project without the resource login with the new users you created

this user will not be permited to import the resoures but everthing else should be able to be imported.

 

K
Kannan CP 👤 Member for 18 years

Hi Zoltan,

Regarding the new user and the capability, is it possible for you to explain a little bit more?

 

Thanks

 

Kannan

Z
Zoltan Palffy 👤 Member for 16 years 11 months

another work around is to create another USER and change the users rights to not to have the capability to import resources.

so create a new user named Temp or Pseudo and set his rights to NOT import resource 

K
Kannan CP 👤 Member for 18 years

Hi Mike,

 

Thanks for reply.

Its working while importing as you said, except the below difficulties.

1. After exporting the resources to excel, the resources in my schedule (only for the sub contractor section) to be removed manually one by one (may be there will be an easy option, but I didn't find it), before importing the updated sub cont schedule (without resources).

2. After incorporating the sub contractor schedule (updated one but without resources) in to my schedule and importing the excel back to my schedule- the "at complete budgeted units and cost"  is not the same any more. I have to correct it manually. I looked for a global change to make "At Complete Units" equals to "Budgeted Units", but didn't find any option.

Regards

Kannan

M
Mike Testro 👤 Member for 20 years 6 months

Hi Kannan

Before importing your sub contractor's programme export your resources to excell and then import them back afterwards.

Best regards

Mike Testro

K
Kannan CP 👤 Member for 18 years

Hi Shahul,

There are no resources in sub contractor schedule. I am only incorporating their updated schedule into our schedule(with resources). While importing the sub cont schedule, with updating option, my schedule resources are changing or getting removed.

 

Kannan

K
Kannan CP 👤 Member for 18 years

Hi Zoltan,

 

Thanks for the reply. In the modify data for activities, I already changed the resource assignment status to " Keep Existing". Problem is that, the "activities relationship" and  activity status also changing to Keep Existing. The issue still exist.

 

Kannan

Z
Zoltan Palffy 👤 Member for 16 years 11 months

during the importing process you can select what you want and donot want to import. When you import the project and get to the Update Project Options select Modify and under the Data Activity Type for the Activity Resource Assignment select Keep Existing 

S
Shah. HB 👤 Member for 17 years 6 months

Hi Kannan,

 

If you rename the resource ID’s (Unique) of master schedule, there will not be any conflicts, if any previous happened due to same usage of resource ID’s between master schedule and subcontract schedule.

Cheers

Shahul Badhusha

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts