BMC Communities Banner
Up to Discussions in BMC Remedy AR System

This Question is Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (5 pts)
10 Replies Last post: Oct 16, 2007 4:21 AM by ebenezer  
ebenezer Participant
ebenezer
23 posts since
Oct 11, 2007
Currently Being Moderated

Oct 11, 2007 11:04 AM

Handling Attachments

Hello,

I would like to konw how attachments are handled in Remedy. In fact, I would like to create un interface between Remedy and another application. So, it's important to me to know: when I create a Change Request and add attachments to it, where are they kept, so as for me to choose the best interface.

Regards,

E.

vriedweg Master
vriedweg
847 posts since
Jun 24, 2007
Currently Being Moderated
1. Oct 11, 2007 12:06 PM in response to: ebenezer
Re: Handling Attachments

Hi,

The attachments are stored in the B<schemaid>C<fieldid> tables in the database. There are stored in the blob format.

Vincent.

Report Abuse
ebenezer Participant
ebenezer
23 posts since
Oct 11, 2007
Currently Being Moderated
2. Oct 11, 2007 12:21 PM in response to: ebenezer
Re: Handling Attachments

Thanks a lot for your reply.

Report Abuse
ebenezer Participant
ebenezer
23 posts since
Oct 11, 2007
Currently Being Moderated
3. Oct 11, 2007 12:33 PM in response to: ebenezer
Re: Handling Attachments

Hello,

I have another question concerning attachments. Do you know if web services exposed through Remedy handle file transfert (like attachments)?

Regards

Report Abuse
vriedweg Master
vriedweg
847 posts since
Jun 24, 2007
Currently Being Moderated
4. Oct 11, 2007 1:29 PM in response to: ebenezer
Re: Handling Attachments

I don&#39;t know. I have never tried that.

Report Abuse
jgroneng HotShot
jgroneng
125 posts since
Jul 2, 2007
Currently Being Moderated
5. Oct 11, 2007 2:21 PM in response to: ebenezer
Re: Handling Attachments


Yes, web service can handle attachment(s)

--
Jarl

 

Message was edited by: jgroneng

Report Abuse
vriedweg Master
vriedweg
847 posts since
Jun 24, 2007
Currently Being Moderated
6. Oct 11, 2007 2:41 PM in response to: jgroneng
Re: Handling Attachments

Thanks for the tip Jarl... :)

Report Abuse
rgwilliamson Enthusiast
rgwilliamson
131 posts since
Aug 14, 2007
Currently Being Moderated
7. Oct 11, 2007 3:12 PM in response to: ebenezer
Re: Handling Attachments

one thing to note is that the Incident webservices interfaces doesnt allow attachments in workinfo updates.

R

Report Abuse
ebenezer Participant
ebenezer
23 posts since
Oct 11, 2007
Currently Being Moderated
8. Oct 12, 2007 2:34 AM in response to: ebenezer
Re: Handling Attachments

Thanks for the tip.

Regards

Report Abuse
pauln Expert
pauln
286 posts since
Sep 3, 2007
Currently Being Moderated
9. Oct 16, 2007 1:56 AM in response to: ebenezer
Re: Handling Attachments

Hi,

I have a self help solution where users log tickets and they can add attachments - all the comms to ARS is through web services. It has been running for years, no problem. If I recall correctly you must pass the web service a byte array, a name and the size of the file (the byte array). The remedy admin tool will create the wsdl to handle this when you add an attachment field to your mappings in the web service.

Only limitation I found was that for some reason the web service comms go REALLY slow the moment the attachment is over +-500K, so I limit the attachment size to smaller than that. Never really troubleshooted this to a conclusion.

Cheers
Paul

Report Abuse
ebenezer Participant
ebenezer
23 posts since
Oct 11, 2007
Currently Being Moderated
10. Oct 16, 2007 4:21 AM in response to: ebenezer
Re: Handling Attachments

Thanks Pauln for your contribution.

Regards

Report Abuse

Advertisement

More Like This

  • Retrieving data ...