Custom Property IDs

  • Thread starter Fernando A. Gómez F.
  • Start date
F

Fernando A. Gómez F.

Hello all,

How can I know a Custom Field Property's GUID and ID?

I need to create a project and send it to Project Server. I need to
populate the ProjectDataSet.ProjectCustomFields table. For that, I do
something like:

row = dataset.ProjectCustomFields.NewProjectCustomFieldsRow();
row.CUSTOM_FIELD_UID = Guid.NewGuid();
row.PROJ_UID = projectId; // projectId taken elsewhere
row.MD_PROP_UID = propUid; //<------------------ here is the gotcha
row.MD_PROP_ID = propId; //<---|
row.FIELD_TYPE_ENUM = (byte)fieldType;

Now, the values provided to row.MD_PROP_UID and row.MD_PROP_ID must come
from somewhere, presumably from the Project Server database. My question
is, where can I get these values? Should I look into Project Server's
database, or is there another place where I can see them?

Thanks in advance.

Regards.
 
F

Fernando A. Gómez F.

Fernando said:
Hello all,

How can I know a Custom Field Property's GUID and ID?

I need to create a project and send it to Project Server. I need to
populate the ProjectDataSet.ProjectCustomFields table. For that, I do
something like:

row = dataset.ProjectCustomFields.NewProjectCustomFieldsRow();
row.CUSTOM_FIELD_UID = Guid.NewGuid();
row.PROJ_UID = projectId; // projectId taken elsewhere
row.MD_PROP_UID = propUid; //<------------------ here is the gotcha
row.MD_PROP_ID = propId; //<---|
row.FIELD_TYPE_ENUM = (byte)fieldType;

Now, the values provided to row.MD_PROP_UID and row.MD_PROP_ID must come
from somewhere, presumably from the Project Server database. My question
is, where can I get these values? Should I look into Project Server's
database, or is there another place where I can see them?

Thanks in advance.

Regards.
Click to expand...

Doh! I found this stored procedure:

msp_customfield_read

which I believe returns me what I wanted. I'm I right?

Thanks.
 
S

Stephen Sanderlin

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to get subprojects' file propertites. 1
How to save project custom field value thru PSI 1
Calculated Custom Fields and PDS <ProjectCodeValues> method 2
Can I set a value of new task custom field via PSI? 3
Creating projects using PSI 5
How To Add Custom Field for A Task using PSI 1
PDS - Enterprise Custom Field 4
PDS - Enterprise Custom Field 0

Top