Stephen Heider has a .net program he wrote that exercises the attachment capabilities:
http://arswiki.org/projects/dotnetutil/browser/ARS_CreateAttachmentsForm/Trunk http://arswiki.org/projects/dotnetutil/browser/ARS_CreateAttachmentsForm/Trunk/Module1.vb I haven't used it much myself. When I first read your description, I thought your staging form was a regular db table. What are you using to write to the db? native sybase, remedy api, etc. Axton On 8/17/07, RAMTRI, Nisha, IDC <[EMAIL PROTECTED]> wrote: > Hi Axton, > > Can you elaborate a little more on the first option? What I have understood > is as follows: > > 1. Allow .NET to store the value in whatever form is being stored in the db. > 2. When this value is in the d/b, use the remedy api to retrieve the > attachment from db and pass it to attachment data type field on the form. > > Is my understanding correct? In case yes, can you let me know some details > about the api? > > Thanks! > > Rgds, > Nisha Ramtri > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Axton > Sent: 17 August 2007 10:39 > To: [email protected] > Subject: Re: Attachment fields and d/b > > You will need to use the remedy api to write the binary data to a remedy > attachment field. > > Two approaches off the top of my head: > > Use the native .net/sybase to store the data in whatever native format > sybase uses to store binary data, then either write something triggered in > the view form/ticket creation to use the remedy api to retrieve the > attachment from the db, > > Use the remedy .net api to store the write the binary data into an > attachment field in a regular remedy form, then relate or copy the remedy > attachment data to your ticketing form. > > Axton > > On 8/17/07, RAMTRI, Nisha, IDC <[EMAIL PROTECTED]> wrote: > > ** > > > > Hi List, > > > > We are on ARS 6.3 and Sybase 5.1 here in the organisation. We are in > > the process of building a console which allows our users to submit > > calls in a customised form. This has a .NET front-end which through a > > stored procedure inserts records in a Remedy staging table (which is a > > regular form) and this staging form in turn inserts records in other main > forms at the back-end. > > > > Now we have a requirement to allow users to attach some files as > > attachments in the GUI and send them to final attachment fields on the > > regular form. Can anyone give ideas for a good way of doing this? I > > have made an attachment field in the staging form so that it can pass > > the files to the other regular forms. But my stored procedure is not > > able to update/pass value to this attachment field on staging form. Hence > I am stuck in this. > > > > Can anyone suggest what I should be doing in this case? > > > > Thanks. > > > > Warm Regards, > > > > Nisha Ramtri > > IEA Remedy Team > > RBS India Development Centre > > > > ********************************************************************** > > ************* The Royal Bank of Scotland plc. Registered in Scotland > > No 90312. Registered > > Office: 36 St Andrew Square, Edinburgh EH2 2YB. > > Authorised and regulated by the Financial Services Authority > > > > This e-mail message is confidential and for use by the addressee only. > > If the message is received by anyone other than the addressee, please > > return the message to the sender by replying to it and then delete the > > message from your computer. Internet e-mails are not necessarily > > secure. The Royal Bank of Scotland plc does not accept responsibility > > for changes made to this message after it was sent. > > > > Whilst all reasonable care has been taken to avoid the transmission of > > viruses, it is the responsibility of the recipient to ensure that the > > onward transmission, opening or use of this message and any > > attachments will not adversely affect its systems or data. No > > responsibility is accepted by The Royal Bank of Scotland plc in this > > regard and the recipient should carry out such virus and other checks > > as it considers appropriate. > > Visit our websites at: > > www.rbs.com > > www.rbs.com/gbm > > www.rbsgc.com > > ********************************************************************** > > ************* > > > > > > ______________________________________________________________________ > > This email has been scanned by the MessageLabs Email Security System. > > For more information please visit > > http://www.messagelabs.com/email > > ______________________________________________________________________ > > __20060125_______________________This posting was submitted with HTML > > in it___ > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
