I am a complete newbie to Remedy, so I'm hoping someone can help me out.. I have been asked to come up with a way of automating the process of importing people into the Remedy system so that it can be run as a nightly job. Currently someone manually imports a flat file using the desktop tools that come with Remedy. I know that the data goes into the T270... and perhaps other tables as well. Is it possible to directly apply inserts and updates to the T270 table using Oracle PL/SQL ? If not, what approach would you recommend ? Our server side is running on a Unix platform.. Thank you in advance for any direction you can provide..
Brad Eggers
University of Pennsylvania

why not automate using the arimportcmd tool? if you have your flat-file dumped into the same directory every night, create a shell script that validates the file is there, imports it (using a mapping file you create), and then archives it.

Should be simple enough. Good luck!

Sorry, brad, I should have added that details on how to use the arimportcmd can be found in the Integrating-700.pdf (around pages 240-245).

I'll give that a shot.. Thanks Matt!

Matt,
I should have asked... can arimportcmd be run from the server side ? I tried executing it on my AIX server which has the AR datbase, and it wasn't there.. (as I said, a newbie).. also, where can I find Integrating-700.pdf ?
Thanks again,
Brad

Brad, the documentation is usually available on the web
try this link:
http://www.bmc.com/support/hou_Support_ProdVersion/0,3648,19097_19695_144856_0,00.html
for a list docs for ARServer
or
http://www.bmc.com/supportu/documents/84/67/58467/58467.pdf
for the PDF (hope this is the one :-))

As for the import tool, I'm not sure if there is a Unix version of it available, I know there is no Unix/Linux version available for the clients (User Tool, Admin Tool)

Regards

Matt,
I have been reading a lot of posts from others who have used a different approach and I would like to get your comments on it...
The approach is to create a table or view on the same oracle database which remedy uses, then to create a Remedy View Form which gets its data from the first view.. Then create a mapping from the View Form to SHR:People and an escalation to automate the pushing of data from the View Form to SHR:People.. Does this seem like a reasonable approach to you ? Your comments greatly appreciated..
Brad

Brad,

What you'll find is that Remedy is flexible enough to allow for multiple solutions to the same problem. You will need to explore the most viable solutions for your particular requirements. It sounds like you have a couple to choose from right now, which is great!

It really depends on your actual requirements. You may actually wish to completely automate and build a filter plug-in that will pull changes in 'people' data directly from your other system-of-record as they are made, rather than relying on batch processing. However, that requires actual programming to accomplish. If you don't have the necessary skill set to do that, then other methods need be explored.

See what I mean? Multiple options.

Good luck!

Thanks Matt!