We do this with a very small perl program. What we did was define a additional column in the Oracle table ( TRANSFER_STATUS Number(15) DEFAULT 0 NOT NULL ) that maps to a Remedy Selection list ( "New", "Ready to Process", "Processed", "Delete" ). All of the processing is performed by filters that fire on Modify,Merge when Transfer_Status = "Ready to Process" The perl script does the following Connects to Oracle thru DBD/DBI. Connects to Remedy thru the API. Does a select (in a loop) of the Oracle data where TRANSFER_STATUS = 0 For each row selected does an API call to set TRANSFER_STATUS = 1 Once all records are processed the prog does a logout from Remedy and disconnects from the DB then exits Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Atherly Sent: Monday, April 23, 2007 8:23 AM To: [email protected] Subject: Oracle feed into ARS 6.3 question ** I'm told that you can only setup Oracle to feed into 6.3 to a view form and that ARS doesn't see the feed as New, Submit or Modify. We currently have Oracle feeding employee information into our 6.3 to a view form and then an escalation runs and pushes this information to a regular form to be processed. This has been working great but we have added another push to feed SMS asset and software into 6.3 also by a view form and another escalation. During the SMS load the escalation took over four days to run in which no other escalation ran. I'm looking for another way to get the information in with out using an escalation. John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
