Hi Welton, We used View forms to pull data from TrackIt. We had an installation that was heavily modified. Croom Consulting's DBLink to SQLServer would be quick way to get Vendor form access to and from the TrashIt er TrackIt tables. I never worked much on the trackit side. Does that admin for trackit know if it is capable of using webservices? You could use web services to publish the ARSystem Ticket for trackit to consume and the View form or webservices to pull the ticket resolution back to the ARSystem. I agree with Kevin. It speaks well of Remedy that we even think of these integrations but the cost of a short term workaround could be better spent migrating to an ARSystem Helpdesk. HTH,
John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen Sent: Wednesday, April 23, 2008 11:50 AM To: [email protected] Subject: Re: Track-It Helpdesk? ** Good news / Bad news - >From the looks of it Track-IT version 4 had two different databases Enterprise used SQL. Standard was stored in the xBASE file file format (using FoxPro 2.5 index and memo format). If you have the SQL database version of Track-IT, you could use a View from in Remedy to pull data from Track-IT. Also, you could use AR System workflow active links, filters, and escalations to send data to external tables and even external databases using Direct SQL. (From Remedy to Track-IT, but you would need to know the Track-IT DB design).. It's going to be messy. The client really needs to take a long look at the cost and design time for this two way system. It would be a shame to create all of this workflow for a lifespan of a few months, only to trash it. Kevin P. ** The client doesn't not want to move Remedy at this time *sigh*. Remedy is our main system and they use Track IT. They would like for use to pass ticket to Track-IT from Remedy and when resolved, close out in Remedy. I was thinking view and vendor forms also but no experience on the Track- It side should prove for a fun time. :D Welton Bryant MCSE,MCP Sr. Business Applications Analyst CareTech Solutions Inc. 248-823-0341 Office 313-408-5188 Cell 800-428-4781 Pager [EMAIL PROTECTED] www.caretechsolutions.com <http://www.caretechsolutions.com/> ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen Sent: Wednesday, April 23, 2008 10:50 AM To: [email protected] Subject: Re: Track-It Helpdesk? ** Good morning Welton, >From the looks at version 8, it uses SQL 2000, 2005 as the main database. If previous versions use SQL, a view form could be easily setup to access data from the Track-IT database and use it in Remedy. Remedy can easily pull information from various sources via View and Vendor forms. By two way integration, what do you mean? Creating, viewing, sharing information in both systems at the same time? Is one the main system? I one a backup? Why two systems? Kevin P. ** Has anyone had to develop a two way integration Between Track-IT from numara software and Remedy Helpdesk software. Any suggestions/integration tools/points that you may have used would be greatly appreciated. Thanks. on Bryant MCSE,MCP Sr. Business Applications Analyst CareTech Solutions Inc. 248-823-0341 Office 313-408-5188 Cell 800-428-4781 Pager ________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. <http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i6 2sR8HDtDypao8Wcj9tAcJ> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist ________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. <http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i6 2sR8HDtDypao8Wcj9tAcJ> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
