Required Information

SADIQ AKBAR

Hi All,

Im newbie with Opentext,I would like to ask help on Opentext API,I have some employee documents in opentext and each document has unique value like Employee Number,and I need to add one more field and update all the existing records with new value which exists in another MS SQL Table

Lets say ,records in Opentext has as following

EmpNo , name , JoinDate (new Field)

1011 , Jack,
1019 , Nelson,
1022 , Roi,

In Ms Sql Table ,i have
EmpNo , name , JDate
1011 , Jack , 10/10/2009
1019 , Nelson , 21/12/2011
1022 , Roi , 28/03/2012

I need to update JDate with Join Date in Open text ,How can i achieve this ?Please help

Greg Griffiths

you would need to add the new Attribute to the Category and then Upgrade it to make it available in the system, you would then need to populate it - this can via a variety of methods such as REST, WebService or OScript (the Content Server development language).