|
|
|
date: Fri, 8 Aug 2008 14:46:18 -0700 (PDT),
group: microsoft.public.project.developer
back
Re: VBA code to automatically (or automagically) populate a project
team from the same resources each time
On Aug 8, 11:45 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
> Yes. Use the EnterpriseResourceGet method. If necessary I can help you do
> this, but now you know about this method it should be straightforward. You
> just need a list of Resources to add and retrieve their GUIDs from the
> Reporting db.
>
> --
>
> Rod Gill
> Microsoft MVP for Project
>
> Author of the only book on Project VBA, see:http://www.projectvbabook.com
>
> "andy.no...@unt.edu" wrote in message
>
> news:cf0d512c-abf6-4bd9-b44c-81ffcce430f5@w7g2000hsa.googlegroups.com...
>
> > In Project Professional 2007 (w/Project Server on the back end), Its
> > pretty darn tough on our development team leaders (as PMs) to have to
> > build the project team over and over and over again for each newly
> > created project, picking the same people (their programmers) each and
> > every time (we track projects as small as 2 weeks).
>
> > Is there a VBA statement I can use to populate the project team with
> > specific enterprise pool resources each time the button is clicked?
>
> > I'm not encouraging the use of TEMPLATES because we will be using
> > Portfolio Server to front end load projects. Once the project is
> > created in Project Server by Portfolio Server, you can't take
> > advantage of the template (or at least I don't think so).
>
> > Please, any and all suggestions will be welcome.
>
> > Thanks,
> > Andy Novak
> > UNT
Rod, thanks. I was able to use EnterpriseResourceGet (3) for example
to add Resource #3 to the project team.
Now for a followup. Is there a way to :
1. Bring in all resources (I'm guessing perhaps not supplying the
Enterprise Resource Number may do the trick)
2. Bring in all resources for a particular RBS level? It would be
great not to have to continue to mod the VBA script each time a new
employee is brought on board for a particular development team (right
now I'm thinking about having a script for each development team or
perhaps have one script where they pick their team from a msgbox)
Thanks,
Andy
date: Sun, 10 Aug 2008 07:21:50 -0700 (PDT)
author: unknown
Re: VBA code to automatically (or automagically) populate a project team from the same resources each time
Yes. I would have a query in the Reporting db that selects the resources you
want then add all of them to the project. Use oledb to read the View. You
could enter a team name into a Project Custom Field and limit the list of
Resources based on that team name.
In the reporting db look at the Views ending with _userview as they include
all custom fields automatically.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
"andy.novak@unt.edu" wrote in message
news:237be69f-a93a-4f8c-b766-96818a9dd595@i76g2000hsf.googlegroups.com...
On Aug 8, 11:45 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
> Yes. Use the EnterpriseResourceGet method. If necessary I can help you do
> this, but now you know about this method it should be straightforward. You
> just need a list of Resources to add and retrieve their GUIDs from the
> Reporting db.
>
> --
>
> Rod Gill
> Microsoft MVP for Project
>
> Author of the only book on Project VBA, see:http://www.projectvbabook.com
>
> "andy.no...@unt.edu" wrote in message
>
> news:cf0d512c-abf6-4bd9-b44c-81ffcce430f5@w7g2000hsa.googlegroups.com...
>
> > In Project Professional 2007 (w/Project Server on the back end), Its
> > pretty darn tough on our development team leaders (as PMs) to have to
> > build the project team over and over and over again for each newly
> > created project, picking the same people (their programmers) each and
> > every time (we track projects as small as 2 weeks).
>
> > Is there a VBA statement I can use to populate the project team with
> > specific enterprise pool resources each time the button is clicked?
>
> > I'm not encouraging the use of TEMPLATES because we will be using
> > Portfolio Server to front end load projects. Once the project is
> > created in Project Server by Portfolio Server, you can't take
> > advantage of the template (or at least I don't think so).
>
> > Please, any and all suggestions will be welcome.
>
> > Thanks,
> > Andy Novak
> > UNT
Rod, thanks. I was able to use EnterpriseResourceGet (3) for example
to add Resource #3 to the project team.
Now for a followup. Is there a way to :
1. Bring in all resources (I'm guessing perhaps not supplying the
Enterprise Resource Number may do the trick)
2. Bring in all resources for a particular RBS level? It would be
great not to have to continue to mod the VBA script each time a new
employee is brought on board for a particular development team (right
now I'm thinking about having a script for each development team or
perhaps have one script where they pick their team from a msgbox)
Thanks,
Andy
date: Mon, 11 Aug 2008 07:41:47 +1200
author: Rod Gill rodATproject-systemsDOTcoDOTnz
Re: VBA code to automatically (or automagically) populate a project
team from the same resources each time
On Aug 10, 2:41 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
> Yes. I would have a query in the Reporting db that selects the resources you
> want then add all of them to the project. Use oledb to read the View. You
> could enter a team name into a Project Custom Field and limit the list of
> Resources based on that team name.
>
> In the reporting db look at the Views ending with _userview as they include
> all custom fields automatically.
>
> --
>
> Rod Gill
> Microsoft MVP for Project
>
> Author of the only book on Project VBA, see:http://www.projectvbabook.com
>
> "andy.no...@unt.edu" wrote in message
>
> news:237be69f-a93a-4f8c-b766-96818a9dd595@i76g2000hsf.googlegroups.com...
> On Aug 8, 11:45 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
>
>
>
> > Yes. Use the EnterpriseResourceGet method. If necessary I can help you do
> > this, but now you know about this method it should be straightforward. You
> > just need a list of Resources to add and retrieve their GUIDs from the
> > Reporting db.
>
> > --
>
> > Rod Gill
> > Microsoft MVP for Project
>
> > Author of the only book on Project VBA, see:http://www.projectvbabook.com
>
> > "andy.no...@unt.edu" wrote in message
>
> >news:cf0d512c-abf6-4bd9-b44c-81ffcce430f5@w7g2000hsa.googlegroups.com...
>
> > > In Project Professional 2007 (w/Project Server on the back end), Its
> > > pretty darn tough on our development team leaders (as PMs) to have to
> > > build the project team over and over and over again for each newly
> > > created project, picking the same people (their programmers) each and
> > > every time (we track projects as small as 2 weeks).
>
> > > Is there a VBA statement I can use to populate the project team with
> > > specific enterprise pool resources each time the button is clicked?
>
> > > I'm not encouraging the use of TEMPLATES because we will be using
> > > Portfolio Server to front end load projects. Once the project is
> > > created in Project Server by Portfolio Server, you can't take
> > > advantage of the template (or at least I don't think so).
>
> > > Please, any and all suggestions will be welcome.
>
> > > Thanks,
> > > Andy Novak
> > > UNT
>
> Rod, thanks. I was able to use EnterpriseResourceGet (3) for example
> to add Resource #3 to the project team.
>
> Now for a followup. Is there a way to :
>
> 1. Bring in all resources (I'm guessing perhaps not supplying the
> Enterprise Resource Number may do the trick)
> 2. Bring in all resources for a particular RBS level? It would be
> great not to have to continue to mod the VBA script each time a new
> employee is brought on board for a particular development team (right
> now I'm thinking about having a script for each development team or
> perhaps have one script where they pick their team from a msgbox)
>
> Thanks,
> Andy
So, just use a variable in the EnterpriseResourceGet function?
Could I just as easily use the RBS rather than creating a special
custom field for this?
I may need a little more detail in that I am fairly new at this VBA
thing.
Thanks,
Andy
date: Sun, 10 Aug 2008 14:29:01 -0700 (PDT)
author: unknown
Re: VBA code to automatically (or automagically) populate a project team from the same resources each time
Hi,
No create a View in the reporting db to return all Resource GUIDs for all
required team members, then use the EnterpriseResourceGet function for each
one to add them to the project.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
"andy.novak@unt.edu" wrote in message
news:ebc2d80e-5775-4645-af7f-8b4f21877c48@j22g2000hsf.googlegroups.com...
On Aug 10, 2:41 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
> Yes. I would have a query in the Reporting db that selects the resources
> you
> want then add all of them to the project. Use oledb to read the View. You
> could enter a team name into a Project Custom Field and limit the list of
> Resources based on that team name.
>
> In the reporting db look at the Views ending with _userview as they
> include
> all custom fields automatically.
>
> --
>
> Rod Gill
> Microsoft MVP for Project
>
> Author of the only book on Project VBA, see:http://www.projectvbabook.com
>
> "andy.no...@unt.edu" wrote in message
>
> news:237be69f-a93a-4f8c-b766-96818a9dd595@i76g2000hsf.googlegroups.com...
> On Aug 8, 11:45 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
>
>
>
> > Yes. Use the EnterpriseResourceGet method. If necessary I can help you
> > do
> > this, but now you know about this method it should be straightforward.
> > You
> > just need a list of Resources to add and retrieve their GUIDs from the
> > Reporting db.
>
> > --
>
> > Rod Gill
> > Microsoft MVP for Project
>
> > Author of the only book on Project VBA,
> > see:http://www.projectvbabook.com
>
> > "andy.no...@unt.edu" wrote in message
>
> >news:cf0d512c-abf6-4bd9-b44c-81ffcce430f5@w7g2000hsa.googlegroups.com...
>
> > > In Project Professional 2007 (w/Project Server on the back end), Its
> > > pretty darn tough on our development team leaders (as PMs) to have to
> > > build the project team over and over and over again for each newly
> > > created project, picking the same people (their programmers) each and
> > > every time (we track projects as small as 2 weeks).
>
> > > Is there a VBA statement I can use to populate the project team with
> > > specific enterprise pool resources each time the button is clicked?
>
> > > I'm not encouraging the use of TEMPLATES because we will be using
> > > Portfolio Server to front end load projects. Once the project is
> > > created in Project Server by Portfolio Server, you can't take
> > > advantage of the template (or at least I don't think so).
>
> > > Please, any and all suggestions will be welcome.
>
> > > Thanks,
> > > Andy Novak
> > > UNT
>
> Rod, thanks. I was able to use EnterpriseResourceGet (3) for example
> to add Resource #3 to the project team.
>
> Now for a followup. Is there a way to :
>
> 1. Bring in all resources (I'm guessing perhaps not supplying the
> Enterprise Resource Number may do the trick)
> 2. Bring in all resources for a particular RBS level? It would be
> great not to have to continue to mod the VBA script each time a new
> employee is brought on board for a particular development team (right
> now I'm thinking about having a script for each development team or
> perhaps have one script where they pick their team from a msgbox)
>
> Thanks,
> Andy
So, just use a variable in the EnterpriseResourceGet function?
Could I just as easily use the RBS rather than creating a special
custom field for this?
I may need a little more detail in that I am fairly new at this VBA
thing.
Thanks,
Andy
date: Mon, 11 Aug 2008 10:39:56 +1200
author: Rod Gill rodATproject-systemsDOTcoDOTnz
Re: VBA code to automatically (or automagically) populate a project
team from the same resources each time
On Aug 10, 5:39 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
> Hi,
>
> No create a View in the reporting db to return all Resource GUIDs for all
> required team members, then use the EnterpriseResourceGet function for each
> one to add them to the project.
>
> --
>
> Rod Gill
> Microsoft MVP for Project
>
> Author of the only book on Project VBA, see:http://www.projectvbabook.com
>
> "andy.no...@unt.edu" wrote in message
>
> news:ebc2d80e-5775-4645-af7f-8b4f21877c48@j22g2000hsf.googlegroups.com...
> On Aug 10, 2:41 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
>
>
>
> > Yes. I would have a query in the Reporting db that selects the resources
> > you
> > want then add all of them to the project. Use oledb to read the View. You
> > could enter a team name into a Project Custom Field and limit the list of
> > Resources based on that team name.
>
> > In the reporting db look at the Views ending with _userview as they
> > include
> > all custom fields automatically.
>
> > --
>
> > Rod Gill
> > Microsoft MVP for Project
>
> > Author of the only book on Project VBA, see:http://www.projectvbabook.com
>
> > "andy.no...@unt.edu" wrote in message
>
> >news:237be69f-a93a-4f8c-b766-96818a9dd595@i76g2000hsf.googlegroups.com..> > On Aug 8, 11:45 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
>
> > > Yes. Use the EnterpriseResourceGet method. If necessary I can help you
> > > do
> > > this, but now you know about this method it should be straightforward> > > You
> > > just need a list of Resources to add and retrieve their GUIDs from the
> > > Reporting db.
>
> > > --
>
> > > Rod Gill
> > > Microsoft MVP for Project
>
> > > Author of the only book on Project VBA,
> > > see:http://www.projectvbabook.com
>
> > > "andy.no...@unt.edu" wrote in message
>
> > >news:cf0d512c-abf6-4bd9-b44c-81ffcce430f5@w7g2000hsa.googlegroups.com.> > > > In Project Professional 2007 (w/Project Server on the back end), Its
> > > > pretty darn tough on our development team leaders (as PMs) to have to
> > > > build the project team over and over and over again for each newly
> > > > created project, picking the same people (their programmers) each and
> > > > every time (we track projects as small as 2 weeks).
>
> > > > Is there a VBA statement I can use to populate the project team with
> > > > specific enterprise pool resources each time the button is clicked?
>
> > > > I'm not encouraging the use of TEMPLATES because we will be using
> > > > Portfolio Server to front end load projects. Once the project is
> > > > created in Project Server by Portfolio Server, you can't take
> > > > advantage of the template (or at least I don't think so).
>
> > > > Please, any and all suggestions will be welcome.
>
> > > > Thanks,
> > > > Andy Novak
> > > > UNT
>
> > Rod, thanks. I was able to use EnterpriseResourceGet (3) for example
> > to add Resource #3 to the project team.
>
> > Now for a followup. Is there a way to :
>
> > 1. Bring in all resources (I'm guessing perhaps not supplying the
> > Enterprise Resource Number may do the trick)
> > 2. Bring in all resources for a particular RBS level? It would be
> > great not to have to continue to mod the VBA script each time a new
> > employee is brought on board for a particular development team (right
> > now I'm thinking about having a script for each development team or
> > perhaps have one script where they pick their team from a msgbox)
>
> > Thanks,
> > Andy
>
> So, just use a variable in the EnterpriseResourceGet function?
>
> Could I just as easily use the RBS rather than creating a special
> custom field for this?
>
> I may need a little more detail in that I am fairly new at this VBA
> thing.
>
> Thanks,
> Andy
Oh, OK. But would I still use a variable with the
EnterpriseResourceGet function to "loop" through the resources?
date: Mon, 11 Aug 2008 08:56:57 -0700 (PDT)
author: unknown
Re: VBA code to automatically (or automagically) populate a project team from the same resources each time
If it holds the GUID, yes and certainly you would have a loop that goes thru
each record from the db with Resource GUIDs..
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
"andy.novak@unt.edu" wrote in message
news:d91fe1f1-4c6c-4152-80ac-d99a7191240a@l64g2000hse.googlegroups.com...
On Aug 10, 5:39 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
> Hi,
>
> No create a View in the reporting db to return all Resource GUIDs for all
> required team members, then use the EnterpriseResourceGet function for
> each
> one to add them to the project.
>
> --
>
> Rod Gill
> Microsoft MVP for Project
>
> Author of the only book on Project VBA, see:http://www.projectvbabook.com
>
> "andy.no...@unt.edu" wrote in message
>
> news:ebc2d80e-5775-4645-af7f-8b4f21877c48@j22g2000hsf.googlegroups.com...
> On Aug 10, 2:41 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
>
>
>
> > Yes. I would have a query in the Reporting db that selects the resources
> > you
> > want then add all of them to the project. Use oledb to read the View.
> > You
> > could enter a team name into a Project Custom Field and limit the list
> > of
> > Resources based on that team name.
>
> > In the reporting db look at the Views ending with _userview as they
> > include
> > all custom fields automatically.
>
> > --
>
> > Rod Gill
> > Microsoft MVP for Project
>
> > Author of the only book on Project VBA,
> > see:http://www.projectvbabook.com
>
> > "andy.no...@unt.edu" wrote in message
>
> >news:237be69f-a93a-4f8c-b766-96818a9dd595@i76g2000hsf.googlegroups.com...
> > On Aug 8, 11:45 pm, "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote:
>
> > > Yes. Use the EnterpriseResourceGet method. If necessary I can help you
> > > do
> > > this, but now you know about this method it should be straightforward.
> > > You
> > > just need a list of Resources to add and retrieve their GUIDs from the
> > > Reporting db.
>
> > > --
>
> > > Rod Gill
> > > Microsoft MVP for Project
>
> > > Author of the only book on Project VBA,
> > > see:http://www.projectvbabook.com
>
> > > "andy.no...@unt.edu" wrote in message
>
> > >news:cf0d512c-abf6-4bd9-b44c-81ffcce430f5@w7g2000hsa.googlegroups.com...
>
> > > > In Project Professional 2007 (w/Project Server on the back end), Its
> > > > pretty darn tough on our development team leaders (as PMs) to have
> > > > to
> > > > build the project team over and over and over again for each newly
> > > > created project, picking the same people (their programmers) each
> > > > and
> > > > every time (we track projects as small as 2 weeks).
>
> > > > Is there a VBA statement I can use to populate the project team with
> > > > specific enterprise pool resources each time the button is clicked?
>
> > > > I'm not encouraging the use of TEMPLATES because we will be using
> > > > Portfolio Server to front end load projects. Once the project is
> > > > created in Project Server by Portfolio Server, you can't take
> > > > advantage of the template (or at least I don't think so).
>
> > > > Please, any and all suggestions will be welcome.
>
> > > > Thanks,
> > > > Andy Novak
> > > > UNT
>
> > Rod, thanks. I was able to use EnterpriseResourceGet (3) for example
> > to add Resource #3 to the project team.
>
> > Now for a followup. Is there a way to :
>
> > 1. Bring in all resources (I'm guessing perhaps not supplying the
> > Enterprise Resource Number may do the trick)
> > 2. Bring in all resources for a particular RBS level? It would be
> > great not to have to continue to mod the VBA script each time a new
> > employee is brought on board for a particular development team (right
> > now I'm thinking about having a script for each development team or
> > perhaps have one script where they pick their team from a msgbox)
>
> > Thanks,
> > Andy
>
> So, just use a variable in the EnterpriseResourceGet function?
>
> Could I just as easily use the RBS rather than creating a special
> custom field for this?
>
> I may need a little more detail in that I am fairly new at this VBA
> thing.
>
> Thanks,
> Andy
Oh, OK. But would I still use a variable with the
EnterpriseResourceGet function to "loop" through the resources?
date: Tue, 12 Aug 2008 07:58:11 +1200
author: Rod Gill rodATproject-systemsDOTcoDOTnz
|
|
