Hi Rabi Yes. What I mean is YOU do not need to know the API - or programming at all. You basically get the power of the API - with no "programming" at all. A "script" is a "short" ASCII file - like a Windows 3.1 "ini" file. You get a few words like Query, QuerySql, File, Loop, to set up iterations, and Update, Create, Merge to update records in Remedy and Output to create files. Scripts can read files including CSVs that other programs like Excel and the import tool, can't - ones like those you speak of (emails) containing embedded line feeds in the values and undoubled quotes etc. You get huge options in your assignments - lookups against CSVs, ARS or SQL Queries, - regex pattern matching and string extracts, - full conditionals, - client and server processes including the standard workflow processes (Application-Generate-GUID, etc). - copy attachments from records that you read into updates, or extract them under a name of your choice. If you find the time to check it out, there's a trial license request form that you can fill in. We are working on a "Script Library" right now. This will allow you to download, edit, try, a wide range of pre-built scripts. With the trial license, we can schedule a 1/2 hr webex where we can install it and run some of the reporting samples. Cheers Ben Chernys
Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:[email protected]> [email protected] Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rabi Tripathi Sent: April 29, 2010 9:28 PM To: [email protected] Subject: Re: API programs: need lazy guy's version of create/update/query tickets on Windows ** Thanks a lot Axton! I actually visited the site before posting, but I got strange behaviors, such as broken pages with scripts showing and even after creating an account, I wasn't able to navigate much. Following your link, all looked fine and I didn't even have to register/login. Must have been local browser issues. Anyway, the site content is awesome and more than what I was looking for. All: One question: how would you handle a situation where one of the parameters (field value) you are sending is big and has special characters? For example, if I'm sending an entire email text to a diary field, I think I will end up breaking the windows command line that invokes the program. I am guessing I need to look for and escape all special characters before invoking the program. Even then there must be some limit to the length of windows command line. Ben: Thanks for the info on Meta-update. It's intriguing. No API? You mean I personally don't have to worry about APIs? I will take a look when I'm free)er). --- On Wed, 4/28/10, Axton <[email protected]> wrote: From: Axton <[email protected]> Subject: Re: API programs: need lazy guy's version of create/update/query tickets on Windows To: [email protected] Date: Wednesday, April 28, 2010, 5:48 PM ** A series of .net utilities for just this purpose: http://arswiki.org/projects/dotnetutil Compiled versions are available for download on the downloads tab. Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Apr 28, 2010 at 1:24 PM, Rabi Tripathi <[email protected]> wrote: > Hi all, I need a way a third party Windows application can create/update/query tickets in Remedy. > > I know there are tons of ways, but if somebody has a sample code in any common windows language (.Net? VB? Java?), or better yet a generic program that can take form name and field/value pairs etc as parameters (there used to be esp_getentry, esp_setentry etc), let me know. I just don't want to spend a lot of time to start from scratch. > > I can't do Web Services (mismatch of Midtier and ARS versions). I am about to search around for a code base to start with, but if anybody has anything handy, send my way or let me know. I have perl code in Unix, but porting that over ti Windows is some work. > > TIA. > > > > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
