Need suggsetions on how to change attribute values in Livelink v9.2.1

Christopher_Jones_(profin01user3_-_(deleted))

How do I do a bulk update of attribute values by firing a SQL in Livelink 9.2For ex: I want to update some 300 account# to a value where account# is one of the attribute values in the Livelink 9.2v categoryI can fire an update sql to update the table but when I pull the document in Livelink GUI, the document doesn?t reflect the database updated value for the attribute

Find more posts tagged with

Comments

Alex_Kowalenko

I suspect that you are updating the LLAttrData table. This is a write-only table that Livelink maintains for reporting purposes. Any changes to this table are not read by Livelink. The source table for attribute values is LLAttrBLOBData. Attribute values are kept as string-encoded associative arrays ("assoc" for short). This table cannot be updated by simple SQL statements. I would suggest a programmatic approach using the Builder SDK. Or, any third-party tools available?-alex-

volvostephen

As Alex mentioned, there are 2 attribute tables. llattrblobdata as well as llatttrdata. You can do direct SQL Modification however this is not supported in any way. To go the direct SQL route, if you are using SQL Server you can use a SQL Statement something like - set extendeddata = replace(extendeddata, '''ContractNo''=''1234''', '''ContractNo''=''1235''') where extendeddata like '%''ContractNo''=''1234''%' against llattrblobdata. Then just a regular update on llattrdata. In the end however, if you are going to have updates like this required very much in the future - you are better to use Builder and create a generic routine to handle these changes. This is what we have ended up doing extensively and it is quite smple. It takes a lot longer then SQL but in the end, it is more supportable.

Lee_Butler

Message from Lee Butler via eLinkHi Alex, Thought you might be interested to know that in WebReports 4.0.2 wecreated a new class of action sub-tag (NODEACTION, USERACTION,WFACTION). These new sub-tags are fairly simple (stopping, starting,deleting workflows; moving, copying, renaming nodes, etc.) right now butthe plan is to build these out in the next version to provide theability to set ACLs and Category and Attribute data among other things.It's no help right now of course...Thanks,Lee.-----Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com] Sent: Donnerstag, 4. Oktober 2007 02:13To: eLink RecipientSubject: I suspect that you are updating the LLAttrData table. This is awrite-only...I suspect that you are updating the LLAttrData table. This is awrite-only...Posted by Kowalenko, Alex on 10/03/2007 08:07 PMI suspect that you are updating the LLAttrData table. This is awrite-only table that Livelink maintains for reporting purposes. Anychanges to this table are not read by Livelink. The source table forattribute values is LLAttrBLOBData. Attribute values are kept asstring-encoded associative arrays ("assoc" for short). This table cannotbe updated by simple SQL statements. I would suggest a programmaticapproach using the Builder SDK. Or, any third-party tools available?-alex-[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Need suggsetions on how to change attribute values inLivelink v9.2.1https://knowledge.opentext.com/knowledge/llisapi.dll/open/12891695Discussion: Development Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/786303Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.development@elinkkc.opentext.com.