Re: Please help me

2013-07-04 Thread Robin Mathew
Thanks everyone for your inputs.

Ranjit, I am looking into your proposal.Thanks once again.

Regards
Robin

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: Please help me

2013-07-04 Thread ranjit jadhav
Robin,

I would suggest to create a vendor form to fetch records from external source, 
you will have to write your own ardbc plugin (c or java and you must implement 
GetListEntryWithFields in plugin). Once vendor form is in place , write an 
active link that executes on enter and performs set field action. For active 
link set field action, read the data from this vendor form and select option to 
display list for multiple record match.

regards
Ranjit



On Thu, 7/4/13, Robin Mathew  wrote:

 Subject: Please help me
 To: arslist@ARSLIST.ORG
 Date: Thursday, July 4, 2013, 2:04 PM
 
 Hi,
 
 Requirement
 
 When user enters a value in a field in Remedy form and press
 Enter,pull matching records from an external system and
 display them in a table field.
 
 External System:Telecordia Granite/Oracle
 
 Additional information
 
 1.The matching records can be many records(50-100)
 
 2.Direct interaction with external system database is not
 supported.
 
 3.Not required to store returned matching records in Remedy
 system.
 
 Proposed solution
 
 I proposed view form based solution,but the external team is
 not supporting it.
 
 Please help me if you know any other solution for this
 requirement.Thanks.
 
 Regards
 Robin
 
 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 "Where the Answers Are, and have been for 20 years"
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: Please help me

2013-07-04 Thread Misi Mladoniczky
Hi,

Anything using the C or Java API is supported from the servers standpoint.

The .net-api is a wrapper around a supported API, so if your program manages
to submit records, the submitted record will be a supported record.

If the .net-api lacks functionality, which you would quickly find out. There
is no guarantee that it will be added.

There is also no guarantee of new versions. Old (current) versions of the API
will work against newer servers. At least two major releases will work, but
probably a lot more than two versions.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> is net API supported ?  Eg creating a record. This seemed to come and go over
> the last 12 years
>
> Sent from my iPhone
>
> On Jul 4, 2013, at 4:41 AM, Mahendra Mahalkar 
> wrote:
>
>> **
>> Hi,
>> There are OOTB APIs like Java API, .NET API and C API. I belive you can
>> achive the required functionality ​with these APIs.
>>
>>
>>
>>
>>
>> Regards,
>> Mahendra Mahalkar
>>
>>
>> On Thu, Jul 4, 2013 at 12:34 PM, Robin Mathew 
>> wrote:
>>> Hi,
>>>
>>> Requirement
>>>
>>> When user enters a value in a field in Remedy form and press Enter,pull
>>> matching records from an external system and display them in a table field.
>>>
>>> External System:Telecordia Granite/Oracle
>>>
>>> Additional information
>>>
>>> 1.The matching records can be many records(50-100)
>>>
>>> 2.Direct interaction with external system database is not supported.
>>>
>>> 3.Not required to store returned matching records in Remedy system.
>>>
>>> Proposed solution
>>>
>>> I proposed view form based solution,but the external team is not supporting
>>> it.
>>>
>>> Please help me if you know any other solution for this requirement.Thanks.
>>>
>>> Regards
>>> Robin
>>>
>>> ___
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> "Where the Answers Are, and have been for 20 years"
>>
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: Please help me

2013-07-04 Thread Alan Truelove
is net API supported ?  Eg creating a record. This seemed to come and go over 
the last 12 years

Sent from my iPhone

On Jul 4, 2013, at 4:41 AM, Mahendra Mahalkar  
wrote:

> **
> Hi,
> There are OOTB APIs like Java API, .NET API and C API. I belive you can 
> achive the required functionality ​with these APIs.
> 
>  
>  
>  
>  
> Regards,
> Mahendra Mahalkar 
> 
> 
> On Thu, Jul 4, 2013 at 12:34 PM, Robin Mathew  wrote:
>> Hi,
>> 
>> Requirement
>> 
>> When user enters a value in a field in Remedy form and press Enter,pull 
>> matching records from an external system and display them in a table field.
>> 
>> External System:Telecordia Granite/Oracle
>> 
>> Additional information
>> 
>> 1.The matching records can be many records(50-100)
>> 
>> 2.Direct interaction with external system database is not supported.
>> 
>> 3.Not required to store returned matching records in Remedy system.
>> 
>> Proposed solution
>> 
>> I proposed view form based solution,but the external team is not supporting 
>> it.
>> 
>> Please help me if you know any other solution for this requirement.Thanks.
>> 
>> Regards
>> Robin
>> 
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
> 
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: Please help me

2013-07-04 Thread Kiran Patil
Hi Robin,

As per your requirement, I would suggest remedy Web Services.

Case Study -
1. When user will hit enter on field, push entry record in one of the
custom form lets say "A"
2. Write consume third party web service (Telecordia Granite/Oracle) on
form "A" with the help of filter.
3. As Web service consume result - you can create single or multiple
records in second staging form say "B"
Please refer BMC Third Party Integration Guide for more details.
4. Create table field on form which will visible to end user i.e where end
user hit enter.
5. Point table field to Form "B" and refresh it using same workflow.

This is very convinient way in such requirement as stated above.

I hope this will help you.

Thanks
Kiran Patil





On Thu, Jul 4, 2013 at 2:04 PM, Robin Mathew  wrote:

> Hi,
>
> Requirement
>
> When user enters a value in a field in Remedy form and press Enter,pull
> matching records from an external system and display them in a table field.
>
> External System:Telecordia Granite/Oracle
>
> Additional information
>
> 1.The matching records can be many records(50-100)
>
> 2.Direct interaction with external system database is not supported.
>
> 3.Not required to store returned matching records in Remedy system.
>
> Proposed solution
>
> I proposed view form based solution,but the external team is not
> supporting it.
>
> Please help me if you know any other solution for this requirement.Thanks.
>
> Regards
> Robin
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>



-- 
*Regards*
*
**Kiran Patil*
*Cognizant Technology Solutions*
*Pune, India*
*Mob No: +91 989 037 7125
*

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: Please help me

2013-07-04 Thread Chris Jones
Hi Robin,

Is there a specific reason for not supporting the View Form?

You could use the APIs as Mahendra suggested, or you could create a stored 
procedure on your ARSystem database to pull the data into a temporary table and 
have a view form of that.

Performance won't be a good as a View Form of the external table but if only 
50-100 records then it may be acceptable.

Regards,

Chris

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Robin Mathew
Sent: 04 July 2013 09:34
To: arslist@ARSLIST.ORG
Subject: Please help me

Hi,

Requirement

When user enters a value in a field in Remedy form and press Enter,pull 
matching records from an external system and display them in a table field.

External System:Telecordia Granite/Oracle

Additional information

1.The matching records can be many records(50-100)

2.Direct interaction with external system database is not supported.

3.Not required to store returned matching records in Remedy system.

Proposed solution

I proposed view form based solution,but the external team is not supporting it.

Please help me if you know any other solution for this requirement.Thanks.

Regards
Robin

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: Please help me

2013-07-04 Thread Mahendra Mahalkar
Hi,
There are OOTB APIs like Java API, .NET API and C API. I belive you can
achive the required functionality ​with these APIs.

**
**
**
**
*Regards,*
*Mahendra Mahalkar
*


On Thu, Jul 4, 2013 at 12:34 PM, Robin Mathew wrote:

> Hi,
>
> Requirement
>
> When user enters a value in a field in Remedy form and press Enter,pull
> matching records from an external system and display them in a table field.
>
> External System:Telecordia Granite/Oracle
>
> Additional information
>
> 1.The matching records can be many records(50-100)
>
> 2.Direct interaction with external system database is not supported.
>
> 3.Not required to store returned matching records in Remedy system.
>
> Proposed solution
>
> I proposed view form based solution,but the external team is not
> supporting it.
>
> Please help me if you know any other solution for this requirement.Thanks.
>
> Regards
> Robin
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Please help me

2013-07-04 Thread Robin Mathew
Hi,

Requirement

When user enters a value in a field in Remedy form and press Enter,pull 
matching records from an external system and display them in a table field.

External System:Telecordia Granite/Oracle

Additional information

1.The matching records can be many records(50-100)

2.Direct interaction with external system database is not supported.

3.Not required to store returned matching records in Remedy system.

Proposed solution

I proposed view form based solution,but the external team is not supporting it.

Please help me if you know any other solution for this requirement.Thanks.

Regards
Robin

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"