Adding resources to Global Resource Pool
Tried that, doesn't seem to make any difference. The EXT_EDIT_REF_DATA
always seems to stay as 1, unlike when you open a normal project and your
changes are imported, then it is set back to NULL.
Quote:
> Try to set the RES_EUID field. This inicates the resources unique ID for
the
> enterproise.
> > Does anybody know how to add Resources to the Global Resource pool
> directly
> > through SQL?
> > We have successfully inserted Resources into the MSP_RESOURCES table
with
> an
> > SQL INSERT statement for a specific project (eg. PROJ_ID = 9) without
any
> > difficulty, so when you later open MS Project, the new Resource appears
in
> > the project. However we want to add additional resources to the Global
> > Resource pool so that the Resources can be available for the entire
> > Enterprise. To do this, you need to specify a PROJ_ID = 1 which is the
> > res_global project. When we add a record to MSP_RESOURCES with PROJ_ID
=
> 1
> > and EXT_EDIT_REF_DATA = 1 (to show that the record has been inserted
> > externally), etc., it will not show up under the Enterprise resource
list
> in
> > MS Project. We've tried setting PROJ_EXT_EDITED = 1 for the res_global
> > project (PROJ_ID = 1), but it doesn't seem to pick up the changes to the
> > resources. We're not really sure what to try next. Any help would be
> > appreciated. Thanks in advance.
> > Kevin
