Importing items using unixshell and oracle

Mattias_Segerdahl_(x-msegerdahl_-_(deleted))

Has anyone come up with a good way to import items using the unix shell, I've created a log statistic generator and I'd like it to import files from the unix shell using a crontab. Tho, I do not have the knowledge how to do this, maybe someone could give me a hint on what to use.Best RegardsMattias Segerdahl

Find more posts tagged with

Comments

Robert_Davies_(unlondonadmin_-_(deleted))

Hi Mattias.I wouldn't advise trying to "home brew" this talking directly to Oracle. While you could insert the data it could be complex to get all the relationships/ID's right & safe.This is a job for the LAPI interface. I have a Java program called "funnel" that monitors a directory and shoves all files it finds into the Enterprise workspace. I intend to modify it to handle any workspace/folder and then release it. It would be easy to modify to just upload single file(s) to a specific location.In fact I am surprised OTC don't provide such a utility themselves...Best regards/matt.

Mattias_Segerdahl_(x-msegerdahl_-_(deleted))

Thanks for your information matt, i've noticed that livelink uses very complexed sql calls to do all this, but even tho we can do this in java my mission is to create it the unix shell, if I succeed, well, then ofcourse the OTC will have the source code from me, and they can decide from there what to do with it. I've done something simmular with an useradd util, that looks like the solaris useradd for root, but works with livelink under unix instead.Mattias