Mass update of attribute value

Hi,

I have a requirement for mass the update (more than 1MM items) of the value of attribute value that is table key look up.

I made and update to the table LLAttrBlobData and LLAttrData and so far is working so far, do i need be aware to chane the value in other table?

Regards,

P.S this attribute is not in a facet.

Find more posts tagged with

Comments

Patrick Pidduck

One minor item to be aware of is that if you are directly changing the database, these new values are not being reflected in the search index.

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Friday, October 10, 2014 6:24 PM
To: eLink Recipient
Subject: Mass update of attribute value

Mass update of attribute value

Posted byocovault@colp.com.pe (Covault, Orlando) On 10/10/2014 06:18 PM

Hi,

I have a requirement for mass the update (more than 1MM items) of the value of attribute value that is table key look up.

I made and update to the table LLAttrBlobData and LLAttrData and so far is working so far, do i need be aware to chane the value in other table?

Regards,

P.S this attribute isnot in a facet.

[To post a comment, use the normal reply function]
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

eLink User

I am a developer who has always believed OT when they say do not touch the livelink database with a sql tool but rather use api's oscript or others.Has that changed now?

can you change llattrblobdata and llattrdata with a sqltool and still have a working or supported livelink?

..Appu

I wonder how one could debug livelink if Fiddler, Wireshark and Softerra LDAP browser was not invented and not free

On Fri, Oct 10, 2014 at 5:29 PM, eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

RE Mass update of attribute value Posted byppidduck@opentext.com (Pidduck, Patrick)On 10/10/2014 06:29 PM

One minor item to be aware of is that if you are directly changing the database, these new values are not being reflected in the search index. From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Friday, October 10, 2014 6:24 PM
To: eLink Recipient
Subject: Mass update of attribute value

Mass update of attribute value

Posted byocovault@colp.com.pe (Covault, Orlando) On 10/10/2014 06:18 PM

Hi,

I have a requirement for mass the update (more than 1MM items) of the value of attribute value that is table key look up.

I made and update to the table LLAttrBlobData and LLAttrData and so far is working so far, do i need be aware to chane the value in other table?

Regards,

P.S this attribute isnot in a facet.

[To post a comment, use the normal reply function]
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	Mass update of attribute value
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

Kyle_Swidrovich

No, that has not changed.

Direct modifications to the database are not supported and will cause many more problems than one may realize.

More than just search may care if category attribute information has changed.

@Orlando: Please revert your changes and use appropriate APIs to make modifications to ensure that all necessary callbacks fire and every interested module is notified of the changes.

Orlando_Covault

Hi Kyle.

I did this in my DEV enviroment just for test and factibility purposes.

Do you recommend any other alternative besides object importer?

Regards,

Hans Stoop

In services we have a module called Multi-Processing that is used for these kind of requests.

Hans

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Dienstag, 14. Oktober 2014 21:14
To: eLink Recipient
Subject: RE Re RE Mass update of attribute value

RE Re RE Mass update of attribute value

Posted byocovault@colp.com.pe (Covault, Orlando) On 10/14/2014 03:07 PM

Hi Kyle.

I did this in my DEV enviroment just for test and factibility purposes.

Do you recommend any other alternative besides object importer?

Regards,

[To post a comment, use the normal reply function]
Topic:	Mass update of attribute value
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

eLink User

If you create a list of dataid's that need the upgrade,which can be found by doing llattrdata queries,which you have proved you know the schema

Then on two or three dedicated livelink servers you will create program either oscript, webservices or lapi to upgrade the category and put any new values etc reading off this dataid list.

In essence with this approach you will get enough number of threads to do the upgrade.OT OOB buids a query and goes thru this huge list so there is no multi plexing.

Essentially the Distributed Agent framework is ideal for this but in our org we created a smart upgrader which can work on essentially a set of dataids that will not collide.

What Hans is posting is something similar and I am guessing it will have good bells and whistles to stop,start,show statistics etc...

Playing SQL with livelink tables is bad we have systems that have bad llattrblobdata and llattrdata that nobody can figure how it got there.Essentially those metadata is unusable and will linger

hence I thought of warning you.

..Appu

I wonder how one could debug livelink if Fiddler, Wireshark and Softerra LDAP browser was not invented and not free

On Tue, Oct 14, 2014 at 2:13 PM, eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

RE Re RE Mass update of attribute value Posted byocovault@colp.com.pe (Covault, Orlando)On 10/14/2014 03:07 PM

Hi Kyle. I did this in my DEV enviroment just for test and factibility purposes. Do you recommend any other alternative besides object importer? Regards, OC
[To post a comment, use the normal reply function]Topic:Mass update of attribute valueForum:Content Server Development ForumContent Server:Knowledge Center

Jean-Francois Larente

I built a .NET console app which connects to the Content Web Services.

It starts at a given level (parent id) and recursively loops through all children and sets the attribute value based on a changed TKL value.

It was definitely a lengthy undertaking but now I can update any attribute from any category using this utility.

From a performance standpoint, I got it up to 6.5 documents per second.

Parthaw Kumar

You cab use webreport for bulk change. Get the dataid in the sheet and set the values as per your requirement using cataction