Misi, I am struggling to see the WebService part! Interesting consept. There would be a filter consuming a WebService - and push the attachment into ARS. I can not get my head around that......
Ben, I was origionally thinking of Meta-Update. Thanks, Terje ________________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky [m...@rrr.se] Sent: 28 September 2011 13:34 To: arslist@ARSLIST.ORG Subject: Re: Get attachments from View Forms or direct SQL? Hi, Sorry, I seem to have missed the NOT-part and Access-part completely... It might be easier to set up a WebService-interface to your AR System, where you can let an external system extract the attachments. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * 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. > I am looking into some possible migrations from different databases (SQL > 2005) to BMC 7.6.04 (SQL 2005). I can access the external databases (not > AR SYSTEM) using View Forms. The plans is to build workflow and then > migrate some of the data. > > How can I best solve attachments? I understand that field type 'image' is > not support by view forms. external databases uses the same field format > 'image' as AR System. It should be possible to get these attachments by > direct SQL? Any tips? Any utilities? > ~ > Terje > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"