SetNodeMetadata from C#

Hello All,

From a C# program I am able to change Metadata categories if the template has only one level of information as StringValues.

However for certain templates for attribute group like "General Information" , the string metadata that we want to update is nested deep within as DataValue - RowValue - StringValue.

And the DataValue does not have a property "Values".

Please suggest how to iterate through the metadata heirarchy and access the StringValue.

Example Key - 3904518.103.5.6.

Code Snippet -

AttributeGroup genInfoCategoryTemplate = null;

genInfoCategoryTemplate = docMan.GetCategoryTemplate(ref otAuthDocMan, Convert.ToInt32(AppConstants.GenInfoCatID));

DataValue intPartyName = genInfoCategoryTemplate.Values[0] as DataValue;

//StringValue intPartyName = genInfoCategoryTemplate.Values[0] as StringValue;//This is always null as values[0] is a DataValue type.

I need to fill the esixiting node value if we do not have a new value for the attribute. As am trying in the code below. I am not able to iterate beyond the first two levels of nesting as there is no Values property beyond this point. The below code works fine if there is only one level of attributes and StringValue.

if (intPartyName.values == null)

{

var intPartyAttribute = (node.Metadata.AttributeGroups.Where(a => a.DisplayName == "1. General Information").ToArray())

[0].Values.Where(d => d.Description == "Internal Party Name").ToArray();

if (((StringValue)intPartyAttribute[0]).Values != null)

intPartyName = new string[] { ((StringValue)intPartyAttribute[0]).Values[0].ToString() };

}

Any immediate Help in this matter would be highly appreciated as I am racing against time to sort this.

Find more posts tagged with

Comments

Nizar Ghazal

Hi Subhash,

If you point a break-point on a line where you have all the values you need, can you post a screenshot of it, with all values expanded?

I'm having a bit of difficulty visualizing what you're dealing with.

I immediately think about adding DataValues to a List, and then looping through foreach DataValue, perhaps...

Thanks.

appuGmail

The RowValue basically means your category is using either a Set ,if you have access to the GUI look at the Category Definition.The JavaDocs give you better explanation on the structure.

I think you are having trouble understanding a set data structure and parsing.I seem to have worked out a problem similar to this and I think I have a word doc showing the Set in question

perhaps you will understand the set parsing in this

https://appukili.wordpress.com/2017/06/01/metadata-for-the-brave/

Ciao,

..... appnair appunair( Livelink Rocks )

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Wed, Jul 18, 2018 at 3:29 PM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

SetNodeMetadata from C# Posted bysubhash.shetty@pfizer.com (Shetty, Subhash)On 07/15/2018 03:31 PM

Hello All,From a C# program I am able to change Metadata categories if the template has only one level of information as StringValues.However for certain templates for attribute group like "General Information" , the string metadata that we want to update is nested deep within as DataValue - RowValue - StringValue.And the DataValue does not have a property "Values".Please suggest how to iterate through the metadata heirarchy and access the StringValue.Example Key - 3904518.103.5.6. Code Snippet -AttributeGroup genInfoCategoryTemplate = null;genInfoCategoryTemplate = docMan.GetCategoryTemplate(ref otAuthDocMan, Convert.ToInt32(AppConstants.GenInfoCatID));DataValue intPartyName = genInfoCategoryTemplate.Values[0] as DataValue;//StringValue intPartyName = genInfoCategoryTemplate.Values[0] as StringValue;//This is always null as values[0] is a DataValue type. I need to fill the esixiting node value if we do not have a new value for the attribute. As am trying in the code below. I am not able to iterate beyond the first two levels of nesting as there is no Values property beyond this point. The below code works fine if there is only one level of attributes and StringValue.if (intPartyName.values == null){var intPartyAttribute = (node.Metadata.AttributeGroups.Where(a => a.DisplayName == "1. General Information").ToArray())[0].Values.Where(d => d.Description == "Internal Party Name").ToArray();if (((StringValue)intPartyAttribute[0]).Values != null)intPartyName = new string[] { ((StringValue)intPartyAttribute[0]).Values[0].ToString() };} Any immediate Help in this matter would be highly appreciated as I am racing against time to sort this.
[To post a comment, use the normal reply function]
Forum: Content Web Services Forum
Content Server: My Support

AKropp

Hi Subhash,

Sounds like you’re dealing with a Set attribute? I’ve got a very, very quick and dirty bit of code that can do this. The caveat is that my snippet is based on the Category in question having precisely one Set attribute containing precisely one Text attribute. However I’m hoping it might be enough to get you on the right path… something you can extrapolate into some actual functional code. Part of me hopes there’s an easier way to do this, but this is what I was able to put together in an hour when I needed to test the functionality.

/*Updating a set attribute on a node

Node myNode = docManClient.GetNode(ref otAuth, ##replace with DataID##);

AttributeGroup[] myAG = myNode.Metadata.AttributeGroups;

for (int i = 0; i < myAG.Length; i++)

{

if (myAG[i].DisplayName == "CatWithSet") //My Category name is CatWithSet

{

//I've only got one text attribute in one set so I'll be as simple as I can. More values at any level will probably need further iteration.

DataValue[] myDV = new DataValue[1];

myDV[0] = myAG[i].Values[0];

TableValue[] myTableVal = new TableValue[1];

myTableVal[0] = (TableValue)myDV[0];

RowValue[] myRowVal = new RowValue[1];

myRowVal[0] = (RowValue)myTableVal[0].Values[0];

DataValue[] mySetDV = new DataValue[1];

mySetDV[0] = myRowVal[0].Values[0];

//Set the attribute value here

string myString = "Test";

((StringValue)(mySetDV[0])).Values[0] = myString;

}

//Update the node

docManClient.UpdateNode(ref otAuth, myNode);

Hope that helps!

From: eLink Entry: Content Web Services Forum [mailto:otdncontentwebservices971forum@elinkkc.opentext.com]
Sent: Wednesday, July 18, 2018 4:29 PM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: SetNodeMetadata from C#

SetNodeMetadata from C#

Posted bysubhash.shetty@pfizer.com (Shetty, Subhash) On 07/15/2018 03:31 PM

Hello All,

From a C# program I am able to change Metadata categories if the template has only one level of information as StringValues.

However for certain templates for attribute group like "General Information" , the string metadata that we want to update is nested deep within as DataValue - RowValue - StringValue.

And the DataValue does not have a property "Values".

Please suggest how to iterate through the metadata heirarchy and access the StringValue.

Example Key - 3904518.103.5.6.

Code Snippet -

AttributeGroup genInfoCategoryTemplate =null;

genInfoCategoryTemplate = docMan.GetCategoryTemplate(ref otAuthDocMan, Convert.ToInt32(AppConstants.GenInfoCatID));

DataValue intPartyName = genInfoCategoryTemplate.Values[0]as DataValue;

//StringValue intPartyName = genInfoCategoryTemplate.Values[0]as StringValue;//This is always null as values[0] is a DataValue type.

if (intPartyName.values ==null)

{

var intPartyAttribute = (node.Metadata.AttributeGroups.Where(a => a.DisplayName =="1. General Information").ToArray())

[0].Values.Where(d => d.Description =="Internal Party Name").ToArray();

if (((StringValue)intPartyAttribute[0]).Values !=null)

intPartyName = new string[] { ((StringValue)intPartyAttribute[0]).Values[0].ToString() };

}

Any immediate Help in this matter would be highly appreciated as I am racing against time to sort this.

[To post a comment, use the normal reply function]
Forum:	Content Web Services Forum
Content Server:	My Support