Direct SQL query instead of using PSI,

[ctd]

Hi,
I have a hard time trying to use PSI to retrieve my RBS custom field - which
is a list of all resources within a certain department, so I'm about to give
up and will try using regular SQL query inside my .NET web app. Just wonder
if anyone has tried using direct SQL and connection string to the reporting
database inside your code, and will that work ?

Thanks,
ctd

 

[Rod Gill]

Hi,

Reading data directly from the reporting db using .net or even VBA works
perfectly. I looked at the schema for the reporting db in the SDK and the
only RBS data I can find is in View dbo.MSPLT_RBS_UserView

Have a look at the data in it and see if it's useful for you.
--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Hi,
I have a hard time trying to use PSI to retrieve my RBS custom field -
which
is a list of all resources within a certain department, so I'm about to
give
up and will try using regular SQL query inside my .NET web app. Just
wonder
if anyone has tried using direct SQL and connection string to the
reporting
database inside your code, and will that work ?

Thanks,
ctd

__________ Information from ESET Smart Security, version of virus
signature database 4966 (20100322) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4966 (20100322) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[ctd]

Hi Rod,
Thanks for your reply. If reading data directly would work, then how about
doing update or insert data directly to published or reporting db ? I doubt
if it would allow this.

Thanks.

 

[Stephen Sanderlin [MVP]]

You would be ill-advised to write directly to the Published, Draft, or
Archive databases -- doing so will move your environment into an
unsupported state and exposes you to a significant risk of data
corruption or other damage to the system.

Writing data to the RDB would serve no purpose as far as updating the
rest of the system since the RDB an output, not an input.

--
Stephen Sanderlin, Project MVP
VP of Technology
msProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com

 

[Lars Hammarberg]

All the views in the reporting database ending with '_UserView' contain (at
the end) columns for all enterprise custom fields.
These views are dynamically updated, which means that if you create a new
enterprise field, the _UserView fields will automatically incorporate the new
field.
For the RBS - check out the MSP_EpmResource_UserView view and the column RBS.

The assignment view MSP_EpmAssignment_UserView also contains the resource
fields, but named with a trailing '_R' - i.e.: the RBS field is name RBS_R in
this view.

 

[Rod Gill]

Stephen is correct, updating the other databases has only pain and grief
appearing in the outcome!! You can however, add tables to the reporting db
and save data there with Project and Task GUIDs to link that data to
existing projects and tasks.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

You would be ill-advised to write directly to the Published, Draft, or
Archive databases -- doing so will move your environment into an
unsupported state and exposes you to a significant risk of data corruption
or other damage to the system.

Writing data to the RDB would serve no purpose as far as updating the rest
of the system since the RDB an output, not an input.

--
Stephen Sanderlin, Project MVP
VP of Technology
msProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com






__________ Information from ESET Smart Security, version of virus
signature database 4972 (20100324) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4972 (20100324) __________

The message was checked by ESET Smart Security.

http://www.eset.com