Creating items by sql and updating index?

Hello everybody,

would it be possible to create items in Livelink/Content server with a sql script? We wrote a sql function which moves items from a source folder in Livelink to a target folder (including the setting of permissions and audit via tables dauditnew and dtreeacl) which works fine. But now we're running into two issues: When we want to create a new subfolder in the target folder we have to create a new dataid but there's no database sequence for this (like "dauditnewsequence" for new audit records). And the second: Is it possible to trigger the Livelink search index by the database so that it gets updated regarding the moved item?

I suspect this will only be possible with oscript/LLBuilder...

Best regards,

Matthias

Find more posts tagged with

Comments

Greg Griffiths

Direct database manipulation will invalidate your support agreement :(Not sure why you need to do it using SQL given that you can use LAPI,WebServices, WebDav etc to get content into the system, these are allmuch simpler - and supported - approaches.

David Templeton

----------------------------

For some reason my response didn't post back, so will do a direct response...

----------------------------

Matthias

I hate to be the bearer of bad news but doing a move like that will likely have messed up the system structure. There are numerous callbacks and other tables that rely on the business logic in oscript to ensure integrity when moving data around the system. There was one customer that tried this same approach and it took them months to rectify the structure.

This of course becomes more complex when you include, facets, columns, RM, xECM, ADN, search Classification just to name a few off the top of my head.

As for creating objects, Greg mentioned a number of supported interfaces to do the job. I would add to that for WebServices, there are CreateSimpleFolder and CreateSimpleDocument that can be used for high ingestion work.

Regards
David

Hans Stoop

Hi Matthias,

You should not make any database changes via SQL. This is because you by pass any business logic that is applied to modules and you end up with an inconsistent database which will result in a lot of problems when upgrading content server. For example, do you update the child count when you move an item. Do you update the facet tables, do you …

Hans

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Montag, 16. Dezember 2013 11:04
To: eLink Recipient
Subject: Creating items by sql and updating index?