BMC Communities Banner

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 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 Expert 832 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.

vriedweg Expert 832 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.

jgroneng HotShot 118 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

vriedweg Expert 832 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... :)

rgwilliamson Enthusiast 106 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

pauln Expert 270 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

More Like This

  • Retrieving data ...