Consuming web services fails.
Hello Listner We are trying to consume a web services published by Share Point application. We are getting the below error Failed to create internal mapping from wsdl. (ARERR 7012) ERROR: URI not found http://XX.XX.XX.XX:/_vti_bin/KEDBCoreFunctionsWS.asmx?wsdl Additional Details: Connection timed out: connect com.bmc.arsys.ws.util.ARWSException: URI not found http://XX.XX.XX.XX: /_vti_bin/KEDBCoreFunctionsWS.asmx?wsdl at com.bmc.arsys.ws.util.WsdlUtil.validateWSDL(WsdlUtil.java:187) at com.bmc.arsys.ws.util.WsdlUtil.newDocument(WsdlUtil.java:230) at com.bmc.arsys.ws.wsdl.WsdlParser.init(WsdlParser.java:104) at com.bmc.arsys.ws.util.WsdlAdminInterface.parseWsdl(WsdlAdminInterface.java:398) at com.bmc.arsys.ws.util.WsdlAdminInterface.parseWSDLIntoMappingString(WsdlAdminInterface.java:198) However its successfully telneting on the given port if we log to the SunOS and ping the destination. So all the ports required are open. Any checkpoint ? ARS 7.1 Sun OS Oracle. Thanks and Regards, *Ganga Prasad Pattnaik *- +91 988 673 3435 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Consuming web services fails.
Prasanth, ARServer is Located in a different domain and the SharePoint is located in different one. And further due to resource restriction, we have opened the port from the ARServer only(Thats how we are able to telnet on the port ). It wont open in any browser because the rule is not set for the network but for the IP where ARServer is located. Our concern is when we can telnet from the OS and not able to consume from filter, are we missing any check point.. Thanks and Regards, *Ganga Prasad Pattnaik *- +91 988 673 3435 On Mon, Aug 22, 2011 at 9:34 AM, Prabhakaran, Prasanth (GO IN Application Management) p.prabhaka...@logica.com wrote: ** Hi Ganga, ** ** Paste the url in a browser and check you are getting the XML ** ** Regards Prasanth ** ** ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Ganga Prasad *Sent:* Monday, August 22, 2011 2:17 PM *To:* arslist@ARSLIST.ORG *Subject:* Consuming web services fails. ** ** ** Hello Listner We are trying to consume a web services published by Share Point application. We are getting the below error Failed to create internal mapping from wsdl. (ARERR 7012) ERROR: URI not found http://XX.XX.XX.XX:/_vti_bin/KEDBCoreFunctionsWS.asmx?wsdl Additional Details: Connection timed out: connect com.bmc.arsys.ws.util.ARWSException: URI not found http://XX.XX.XX.XX:/_vti_bin/KEDBCoreFunctionsWS.asmx?wsdl at com.bmc.arsys.ws.util.WsdlUtil.validateWSDL(WsdlUtil.java:187) at com.bmc.arsys.ws.util.WsdlUtil.newDocument(WsdlUtil.java:230) at com.bmc.arsys.ws.wsdl.WsdlParser.init(WsdlParser.java:104) at com.bmc.arsys.ws.util.WsdlAdminInterface.parseWsdl(WsdlAdminInterface.java:398) at com.bmc.arsys.ws.util.WsdlAdminInterface.parseWSDLIntoMappingString(WsdlAdminInterface.java:198) However its successfully telneting on the given port if we log to the SunOS and ping the destination. So all the ports required are open. Any checkpoint ? ARS 7.1 Sun OS Oracle. Thanks and Regards, *Ganga Prasad Pattnaik *- +91 988 673 3435 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ Think green - keep it on the screen. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. _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
Quering AP:PreviewInfo lead to Plugin Error
** Hello Listener, We have been working on one of the application which will have Change management integrated with itin one of the requirement We need to find out the present/future approvals attached to the change ticket as soon as the change ticket is saved to retrieve the approal information we are querying calling AP:PreviewInfo vendor form. While calling this form in the filter we are getting ARERR [876...0] can't establish connection to Plug in server(Note : we checked Plug in server is up and running )when we checked arerr.log file we get the error while calling ARSYS.ARDBC.PREVIEW...which is the vendor information of AP:PreviewInfo form in order to check this vendor information we tried to create a new vendor form and tried to find out ARSYS.ARDBC.PREVIEW vendor but could not locate the same... Any thought why so ? Sun OS Oracle ARS 7.6.03 ITSM 7.6.03 Regards, Ganga Prasad _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
Batch renaming of Workflow
Hi All, Some of the workflow were created without following the naming conventions in my system. Now I have the task to rename all those odd WorkFlow according to the naming convention. I am thinking of renaming it in Database ACTLINK table. Before proceeding anyone can think of any side effect of this or any available tool for do it safe? ARS 7.0 NO ITSM ORACLE 10g Thanks Ganga Prasad - 9886733435 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Selective field modification Status
Hello There, I am playing with good and unique Requirement. Almost exhausted my mind. Any idea would be appriciate.. I have a Regular Form with around 600 fields. Out of the 50 are Visible filed to user, 300 workflow purpose field and rest can be viewed by going to other display only forms via clicking different button. I came across a requirement where it says if ONLY 4 Particular fields are modified, then it should not show any message Else it should show a pup-up while saving. Currently we are showing the pup-up on every modify. Logically requirement would look as below Lets call the 4 field as Group1 fields and the rest 596 fields as Group2 fields any/all G1 fields modified + any/all G2 fields modified - message should display any/all G1 fields modified + any G2 fields *NOT *modified - message should NOT display any/all G1 fields *NOT *modified + any/all G2 fields modified - message should display any/all G1 fields *NOT *modified + any/all G2 fields *NOT *modified - NO NEED TO WORRY CAUSE SAVE BUTTON WONT ENABLE Thanks and Regards, Ganga Prasad Pattnaik, - 988-673-3435 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Selective field modification Status
James, This Idea was first to strike my mind, But given 600 fields and more to come in coming enhancements, really looks hard to maintain.. :) Thanks and Regards, Ganga Prasad Pattnaik, - 988-673-3435 On Thu, Feb 12, 2009 at 10:12 PM, jham36 jha...@gmail.com wrote: You can do this with a filter. The problem is checking the DB (database) value for 600 fields against the TR (transaction) values. I would imagine that there would be a limit on the filter qualification. You can probably break it up into multiple filters. The qualification would look something like this: 'Field1' != 'DB.Field1' This compares the field value in the current transaction to what is stored in the database. You would need to do this for all your G2 fields. It could get kind of hairy. You would need to check if any of the G2 fields have changed: 'G2Field1' != 'DB.G2Field1' OR 'G2Field2' != 'DB.G2Field2' ... 'G2Field600' != 'DB.G2Field600' This would trigger the message regardless of any G1 fields changing. You don't even need to check if any of the G1 fields changed or not. James On Feb 12, 10:31 am, Ganga Prasad ganga2...@gmail.com wrote: Hello There, I am playing with good and unique Requirement. Almost exhausted my mind. Any idea would be appriciate.. I have a Regular Form with around 600 fields. Out of the 50 are Visible filed to user, 300 workflow purpose field and rest can be viewed by going to other display only forms via clicking different button. I came across a requirement where it says if ONLY 4 Particular fields are modified, then it should not show any message Else it should show a pup-up while saving. Currently we are showing the pup-up on every modify. Logically requirement would look as below Lets call the 4 field as Group1 fields and the rest 596 fields as Group2 fields any/all G1 fields modified + any/all G2 fields modified - message should display any/all G1 fields modified + any G2 fields *NOT *modified - message should NOT display any/all G1 fields *NOT *modified + any/all G2 fields modified - message should display any/all G1 fields *NOT *modified + any/all G2 fields *NOT *modified - NO NEED TO WORRY CAUSE SAVE BUTTON WONT ENABLE Thanks and Regards, Ganga Prasad Pattnaik, - 988-673-3435 ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Selective field modification Status
Carey, Setup is ARS 7.0P2 ORACLE 10G Adding 600 more temp field wont be a possible solution. Even checking with the transaction value with DB Value for all 596 fields wont be possible with filter Runif... Burning mind to have a generic solution Thanks and Regards, Ganga Prasad Pattnaik, - 988-673-3435 On Thu, Feb 12, 2009 at 11:16 PM, Carey Matthew Black black@gmail.comwrote: Ganga, You did not mention what version of AR System your using So YMMV... If this message can be issued by a filter then I would look into this feature. Ref: BasicGuide-630.2006.05.09.pdf Section: Appendix B—Workflow extras Pg: 619 Application-Copy-Field-Value target_field_ID source_field_ID Then you could set up a data driven way to do the following: ) Loop over the data in the two sets of fields (both group1 and group2) * You can move the value from the current field into a temp field * You can use SQL to get the DB value for that field from the DB into a second temp field * You can see if the two tmp fields are different, if so set the change flag for the group for the selected field group. ) Use the two flag fields that you have set and use the logic you have posted in your question. This however will be a performance drag. You will be making 600 trips from the application server to the db during every Modify. Not to mention the processing time to loop over, let us say 10 filters per loop, 6000 more filters during each and every Modify. However... here is another entirely different approach... Use the Log to File action from a filter. Then write something that parses the output of that file format and returns an indicator if field from either of the two groups were in the Log to File entry. The return value could be a Y or N for each group and ordered by Group1 then Group 2. So the return values would be one of the following: YY, (Yes for Group1, Yes for Group2) YN, (Yes for Group1, No for Group2) NY, ( No for Group1, Yes for Group2) NN, ( No for Group1, No for Group2) So the idea would be: Filter N: If Action: 1 -- Log to File If Action: 2 --'Results_field' = $ PROCESS $ run_your_script $Request_ID_to_Check_Log_file_for$ Filter N+1: Run If: 'Results_field' = YY OR 'Results_field' = NY If action: Message: Bla... But that requires a bit of development outside of AR too. I think their may even be an option to use v7.1 Audit features too. But that might be harder than it looks given when the Audit feature is triggered. ( But maybe you could use it with After Modify Active Links if that would meet the need.) HTH. However, I am also skeptical that a Filter based solution will work for you given that you referenced the change flag not being enabled. Maybe your trying to prompt the user and ask them a question rather than just using a Message action? Anyways.. just some thoughts. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (BRSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Thu, Feb 12, 2009 at 10:31 AM, Ganga Prasad ganga2...@gmail.com wrote: ** Hello There, I am playing with good and unique Requirement. Almost exhausted my mind. Any idea would be appriciate.. I have a Regular Form with around 600 fields. Out of the 50 are Visible filed to user, 300 workflow purpose field and rest can be viewed by going to other display only forms via clicking different button. I came across a requirement where it says if ONLY 4 Particular fields are modified, then it should not show any message Else it should show a pup-up while saving. Currently we are showing the pup-up on every modify. Logically requirement would look as below Lets call the 4 field as Group1 fields and the rest 596 fields as Group2 fields any/all G1 fields modified + any/all G2 fields modified - message should display any/all G1 fields modified + any G2 fields NOT modified - message should NOT display any/all G1 fields NOT modified + any/all G2 fields modified - message should display any/all G1 fields NOT modified + any/all G2 fields NOT modified - NO NEED TO WORRY CAUSE SAVE BUTTON WONT ENABLE Thanks and Regards, Ganga Prasad Pattnaik ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Selection List Window Behaviour
Hi There, I have a tricky problem here I have a Character Field and a Button Beside that on my main form. When I Click the button I am supposed to go back to a BackEnd form and get the relevant data and show in a Selection List. This is implemented with Active Link - Set Field... The feature is behaving as expected... Set up : I have the Field Length of 30 in each main form and BackEnd form. I have data with 30 Char each in BackEnd Form. Problem :: In my selection list I can see only 15 Characters... To the strange, once I am clicking on any row, all the 30 Characters are getting reflected on to the main form No code to truncate the characters on Selection list Any suggestion, how I can retain all my 30 characters on the Selection List would be great My Env : ARS 7.01, ORACLE 10G, NO ITSM I tried in a Different Env ARS 6.3 and OracleXE, It worked fine for me, It showed all the 30 character in the Selection List window.. So I strongly feel it should be a preference issue but I found nothing in ARS Documents so seeking your help here.. Thanks and Regards, Ganga Prasad Pattnaik, - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Selection List Window Behaviour
Thanks Vijayalakshmi, When you say check the Result List definition of your backend form, Can you please elaborate what exactly you want me to check ??? Be noted that all my 30 Character are properly comming to my main form. And the problem is with Selection List Window where I can see only 15 Character. Thanks and Regards, - On Mon, Dec 1, 2008 at 6:47 PM, Vijayalakshmi Paulraj [EMAIL PROTECTED] wrote: ** Hi, The Set Fields action will use your backend form's result list definition to show the List of values when you use it in the active link. So check the Result List definition of your backend form, that particular's column width would have truncated to 15 instead of 30. ThanksRegards, Vijayalakshmi Paulraj -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Monday, December 01, 2008 6:42 PM *To:* arslist@ARSLIST.ORG *Subject:* Selection List Window Behaviour ** Hi There, I have a tricky problem here I have a Character Field and a Button Beside that on my main form. When I Click the button I am supposed to go back to a BackEnd form and get the relevant data and show in a Selection List. This is implemented with Active Link - Set Field... The feature is behaving as expected... Set up : I have the Field Length of 30 in each main form and BackEnd form. I have data with 30 Char each in BackEnd Form. Problem :: In my selection list I can see only 15 Characters... To the strange, once I am clicking on any row, all the 30 Characters are getting reflected on to the main form No code to truncate the characters on Selection list Any suggestion, how I can retain all my 30 characters on the Selection List would be great My Env : ARS 7.01, ORACLE 10G, NO ITSM I tried in a Different Env ARS 6.3 and OracleXE, It worked fine for me, It showed all the 30 character in the Selection List window.. So I strongly feel it should be a preference issue but I found nothing in ARS Documents so seeking your help here.. Thanks and Regards, Ganga Prasad Pattnaik, - __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. __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
Re: Selection List Window Behaviour
Yes Vijayalakshmi It worked Thanks a Lot.. Thanks and Regards, - 2008/12/1 Vijay Nimmala [EMAIL PROTECTED] --- On Mon, 12/1/08, Vijayalakshmi Paulraj [EMAIL PROTECTED] wrote: From: Vijayalakshmi Paulraj [EMAIL PROTECTED] Subject: Re: Selection List Window Behaviour To: arslist@ARSLIST.ORG Date: Monday, December 1, 2008, 5:17 AM ** Hi, The Set Fields action will use your backend form's result list definition to show the List of values when you use it in the active link. So check the Result List definition of your backend form, that particular's column width would have truncated to 15 instead of 30. ThanksRegards, Vijayalakshmi Paulraj From: Action Request ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Any genius idea to consolidate 2 or more def files ??
Hi list I have a typical problem here. I need to consolidate lets say 5 def files and want to make 1 def file out of that. Any my new def file should contain all the latest changes... *Illustration Some of the object are in repetition in the 5 def files. I need to make sure the consolidated def file should contain the latest one. lets say def1 contain object A and object A again repeated in def3 and def5. Now my consolidated def should contain the def5 changes.. NB:: Concatenating all the def files will have this work flow 3 times in the new def file. Will ARSystem take care to take the latest one ?? *ARS 7.0 Oracle 10G NO ITSM* *Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Any genius idea to consolidate 2 or more def files ??
Thanks Carley i was also thinking in the same direction as i mentioned. However the second solution looks more cool. But can you give some idea how to initially create this packing list so that the developers can be instructed for the same ?? Thanks and Regards, Ganga Prasad Pattnaik, - On Wed, Jul 30, 2008 at 5:03 PM, Carey Matthew Black [EMAIL PROTECTED]wrote: Ganga, I have not tested this... but it is my understanding that the Admin tool would take the _last_ (not newest) version of the object from the file. ( Think tar file.) However, if you parse the file then your code should be able to make this a trivial job of this. ( And I even think this task would not be that hard to do.) Every object starts with a ^begin [schema|active link|filter|escalation|container|...]$ and ends with an ^end$. The first line like ^ timestamp : epoch_seconds_value_here$ after the begin marker is the time that the object was _last changed_. So if your script can keep track of the largest integer It finds for each object then pull it should be the merged files as you want. HTH. But personally I would take a very different tact to the problem. ( There are some down sides to this approach, but I think it makes more sense too.) Step 1) I would create one packing list and then export all the objects at the same time. ( Your developer(s) can do this.) Step 2) Test the packing list functionality. (Testing group can do that) Step 2a) If the tests fail return to Step1.( file that was delivered needs fixed) Step 3) Since the test worked... deploy the file to production. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Jul 30, 2008 at 3:30 AM, Ganga Prasad [EMAIL PROTECTED] wrote: ** Hi list I have a typical problem here. I need to consolidate lets say 5 def files and want to make 1 def file out of that. Any my new def file should contain all the latest changes... Illustration Some of the object are in repetition in the 5 def files. I need to make sure the consolidated def file should contain the latest one. lets say def1 contain object A and object A again repeated in def3 and def5. Now my consolidated def should contain the def5 changes.. NB:: Concatenating all the def files will have this work flow 3 times in the new def file. Will ARSystem take care to take the latest one ?? ARS 7.0 Oracle 10G NO ITSM Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - __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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Export Automation -- Possible ??
Here again I need to manually do a selection to export. Is it possible to automate it ?? Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - On Wed, Jul 23, 2008 at 6:20 PM, Roger Medsker [EMAIL PROTECTED] wrote: ** Ganga, The easiest way I have figured out to migrate server objects from one server to another is to sort the objects by date modified, highlight the recently modified object(s) you need to migrate and then right click on one of them and export to a def file. I start with Forms then go on to the remaining objects. You can specify the same file to export to and click on the append button to add the new object type to the existing file. If you know all of the objects you need to migrate are related to specific forms, you can view by those forms and then the refresh of the object lists will take less time. Roger Medsker Remedy Consultant Bluestem Consulting Group, LLC [EMAIL PROTECTED] *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Wednesday, July 23, 2008 12:29 AM *To:* arslist@ARSLIST.ORG *Subject:* Export Automation -- Possible ?? ** Hi List As part of my job role I need to go for frequent Import and Export using my Administrator tool. Every time I need to export from source server and put it into Destination Server. The object list always varies. For that I need to carefully search the object and add it for exporting. This is very tedious as we have a large number of workflows ... Any one have tried to make it automated ?? I am not finding any startup point to go with.. Any help would be really greatful.. ARS 7.0 Oracle 10G NO ITSM Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __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
Re: Export Automation -- Possible ??
Seems interesting. Seems like distributing pressure to hunt for all workflows. Can you please explain how this Packing List is done by individual Developer ?? Thanks and Regards, Ganga Prasad Pattnaik, - On Wed, Jul 23, 2008 at 9:58 PM, LJ Longwing [EMAIL PROTECTED] wrote: ** The methodology that we have adopted at my current job works well. Each developer that needs to have stuff moved from Dev to Test creates a packing list and puts all of their stuff into that PL. When it comes time to move from Dev to Test you simply add the contents of each PL to the export, and that is your def file...no hunting for that elusive AL. -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, July 22, 2008 11:29 PM *To:* arslist@ARSLIST.ORG *Subject:* Export Automation -- Possible ?? ** Hi List As part of my job role I need to go for frequent Import and Export using my Administrator tool. Every time I need to export from source server and put it into Destination Server. The object list always varies. For that I need to carefully search the object and add it for exporting. This is very tedious as we have a large number of workflows ... Any one have tried to make it automated ?? I am not finding any startup point to go with.. Any help would be really greatful.. ARS 7.0 Oracle 10G NO ITSM Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __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
Export Automation -- Possible ??
Hi List As part of my job role I need to go for frequent Import and Export using my Administrator tool. Every time I need to export from source server and put it into Destination Server. The object list always varies. For that I need to carefully search the object and add it for exporting. This is very tedious as we have a large number of workflows ... Any one have tried to make it automated ?? I am not finding any startup point to go with.. Any help would be really greatful.. ARS 7.0 Oracle 10G NO ITSM Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Knowing Row number in table based on a value
Hi List I am in mid of a requirement where I need to walk through every row to get my particular row. Here the data to the table is coming from external Data Base(not of much concern about the source). This external Data Base returns 700-800 rows at once. And walking through 800 rows is really time consuming it takes minutes to find my particular data. Thats why I thought of implementing Binary search in Remedy. It will considerably reduce the time to some seconds. Can eny one give some starting idea for the same.. ?? Syntactically my requirement is : I will be returned with 800 rows. I need to go to the particular row where coumn5 value = XYZ More ever if anyone can suggest how to come to know the row number of row that contain PQR in its column8. ARS 7.0.0 No ITSM (Customized appl) Oracle 10g Unix -- Thanks and Regards, Ganga Prasad Pattnaik, - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Knowing Row number in table based on a value
You are almost there..As I mentioned *I need to go to the particular row where coumn5 value = XYZ *My pupose is once I am selection that particular row I will set field the other colum values also to my regular fields* *-- Thanks and Regards, Ganga Prasad Pattnaik, - On Mon, May 12, 2008 at 11:40 PM, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** Are you wanting to do this for moving to a specific row in a Table field? Some more info on what you are trying to do would be helpful. Fred -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Monday, May 12, 2008 1:00 PM *To:* arslist@ARSLIST.ORG *Subject:* Knowing Row number in table based on a value Hi List I am in mid of a requirement where I need to walk through every row to get my particular row. Here the data to the table is coming from external Data Base(not of much concern about the source). This external Data Base returns 700-800 rows at once. And walking through 800 rows is really time consuming it takes minutes to find my particular data. Thats why I thought of implementing Binary search in Remedy. It will considerably reduce the time to some seconds. Can eny one give some starting idea for the same.. ?? Syntactically my requirement is : I will be returned with 800 rows. I need to go to the particular row where coumn5 value = XYZ More ever if anyone can suggest how to come to know the row number of row that contain PQR in its column8. ARS 7.0.0 No ITSM (Customized appl) Oracle 10g Unix -- Thanks and Regards, Ganga Prasad Pattnaik, - __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
Re: Knowing Row number in table based on a value
Yes Your idea seems good as long as I have the capability to query the Databse. But here as I said the data to the table is coming from external database. I access the web services published by the database using ARSystem plugin c++ code. I don't have any control as the SQL is implemented in the Dabase itself. I can only see the data returned from the external source. Once it reaches my Table i need to to the whole stuff... Any good Idea for this ?? -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - On Tue, May 13, 2008 at 12:53 AM, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** Ok ... Since you are not doing this to have users see and scroll thru the table field values, You can just use standard Set Field actions to get the data you want. If you are getting the rows in a SQL Set fields action just add a Where clause to the SQL -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Monday, May 12, 2008 1:22 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Knowing Row number in table based on a value ** You are almost there..As I mentioned *I need to go to the particular row where coumn5 value = XYZ * My pupose is once I am selection that particular row I will set field the other colum values also to my regular fields* * -- Thanks and Regards, Ganga Prasad Pattnaik, - On Mon, May 12, 2008 at 11:40 PM, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** Are you wanting to do this for moving to a specific row in a Table field? Some more info on what you are trying to do would be helpful. Fred -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Monday, May 12, 2008 1:00 PM *To:* arslist@ARSLIST.ORG *Subject:* Knowing Row number in table based on a value Hi List I am in mid of a requirement where I need to walk through every row to get my particular row. Here the data to the table is coming from external Data Base(not of much concern about the source). This external Data Base returns 700-800 rows at once. And walking through 800 rows is really time consuming it takes minutes to find my particular data. Thats why I thought of implementing Binary search in Remedy. It will considerably reduce the time to some seconds. Can eny one give some starting idea for the same.. ?? Syntactically my requirement is : I will be returned with 800 rows. I need to go to the particular row where coumn5 value = XYZ More ever if anyone can suggest how to come to know the row number of row that contain PQR in its column8. ARS 7.0.0 No ITSM (Customized appl) Oracle 10g Unix -- Thanks and Regards, Ganga Prasad Pattnaik, - __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __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
Switching between Windows
Hi List I have a funny requirement and I am seeking some help to make it easier.Here my requirement goes.. I have 6-7 display only forms. I have a main Regular form My requirement is that I need to traverse through those display only field and come back to my Main from collecting all the input given by the user. Here is the behavior how the windows will open. 0. I have continue, Previous, Cancel, OK button on each form 1. On clicking continue The windows will open depending on the value present in the form Eg.If In 1st window I enter the value Z then 2nd window should open. At the same in 1st window if I enter Value Y then 3rd window should open. 2. On open of every display-only form the parent Display-only form should get closed eg. 1st window should close as soon as any other (2nd or 3rd) window opens. 3. On click of previous, the parent of the form should re-open.(Again Step 1 should be in place) 4 On click of OK every value entered in different fields entered now should mapped to my Main form 5. On cancel on any display- only form the window should close and nothing should be mapped. Please keep in mind that I may require to implement for more than 6-7 form also. Try to give generic answer independent of number of windows. -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Switching between Windows
Preserving the value in each window is ok David. I am more concerned about closing the parent window once the child window is opened. Here which window is to be opened is decided in runtime only .. Can you please focus on it ?? On Tue, Apr 29, 2008 at 6:50 PM, David Sanders [EMAIL PROTECTED] wrote: ** Hi Ganga The key to doing this is to open each of your input screens as a dialog and to use the Window Open mappings to pass the values from the current form to the next one. The fields from all previous input screens need to exist on the next form to be opened (they can be hidden) so that you can retain the earlier values. The final input screen also needs Window Close mappings to pass all the values back to the main form. At each transition, the active link that does a window open action to open the next form and pass the current values through can be followed by a Close Window action which will close the current input screen as the new one opens. HTH David Sanders Remedy Solution Architect *Enterprise** Service Suite @ Work* == *ARS List Award Winner 2005* *Best 3rd party Remedy Application*** * * See the *ESS Concepts Guide*http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Switching between Windows ** Hi List I have a funny requirement and I am seeking some help to make it easier.Here my requirement goes.. I have 6-7 display only forms. I have a main Regular form My requirement is that I need to traverse through those display only field and come back to my Main from collecting all the input given by the user. Here is the behavior how the windows will open. 0. I have continue, Previous, Cancel, OK button on each form 1. On clicking continue The windows will open depending on the value present in the form Eg.If In 1st window I enter the value Z then 2nd window should open. At the same in 1st window if I enter Value Y then 3rd window should open. 2. On open of every display-only form the parent Display-only form should get closed eg. 1st window should close as soon as any other (2nd or 3rd) window opens. 3. On click of previous, the parent of the form should re-open.(Again Step 1 should be in place) 4 On click of OK every value entered in different fields entered now should mapped to my Main form 5. On cancel on any display- only form the window should close and nothing should be mapped. Please keep in mind that I may require to implement for more than 6-7 form also. Try to give generic answer independent of number of windows. -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __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
Re: Switching between Windows
Opening is OK. Mapping is also ok. Now I need to close the previous (Parent) window. I tried RUN PROCESS to send a event to parent form and I captured the event in Parent from to close it. But by the time it sends the event the next window is already opened so not closing the behind parent window. Can you suggest any alternative way ?? On Tue, Apr 29, 2008 at 7:17 PM, David Sanders [EMAIL PROTECTED] wrote: ** What's the problem? You open the next windows by clicking a button to run active links. Use the run-if qualification for the active links to determine which one to run. David Sanders Remedy Solution Architect *Enterprise** Service Suite @ Work* == *ARS List Award Winner 2005* *Best 3rd party Remedy Application* * * See the *ESS Concepts Guide*http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 2:40 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Switching between Windows ** Preserving the value in each window is ok David. I am more concerned about closing the parent window once the child window is opened. Here which window is to be opened is decided in runtime only .. Can you please focus on it ?? On Tue, Apr 29, 2008 at 6:50 PM, David Sanders [EMAIL PROTECTED] wrote: ** Hi Ganga The key to doing this is to open each of your input screens as a dialog and to use the Window Open mappings to pass the values from the current form to the next one. The fields from all previous input screens need to exist on the next form to be opened (they can be hidden) so that you can retain the earlier values. The final input screen also needs Window Close mappings to pass all the values back to the main form. At each transition, the active link that does a window open action to open the next form and pass the current values through can be followed by a Close Window action which will close the current input screen as the new one opens. HTH David Sanders Remedy Solution Architect *Enterprise** Service Suite @ Work* == *ARS List Award Winner 2005* *Best 3rd party Remedy Application* * * See the *ESS Concepts Guide*http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Switching between Windows ** Hi List I have a funny requirement and I am seeking some help to make it easier.Here my requirement goes.. I have 6-7 display only forms. I have a main Regular form My requirement is that I need to traverse through those display only field and come back to my Main from collecting all the input given by the user. Here is the behavior how the windows will open. 0. I have continue, Previous, Cancel, OK button on each form 1. On clicking continue The windows will open depending on the value present in the form Eg.If In 1st window I enter the value Z then 2nd window should open. At the same in 1st window if I enter Value Y then 3rd window should open. 2. On open of every display-only form the parent Display-only form should get closed eg. 1st window should close as soon as any other (2nd or 3rd) window opens. 3. On click of previous, the parent of the form should re-open.(Again Step 1 should be in place) 4 On click of OK every value entered in different fields entered now should mapped to my Main form 5. On cancel on any display- only form the window should close and nothing should be mapped. Please keep in mind that I may require to implement for more than 6-7 form also. Try to give generic answer independent of number of windows. -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __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
Re: Switching between Windows
Tried this one and it is closing the parent window and not opening the child one. AL log also stops after closing the parent window. ACTL Checking Form1:OpenForm2 (0) ACTL - Passed qualification -- perform if actions ACTL 0: Close Window ACTL /* Tue Apr 29 2008 20:41:49 */ ACTL Stop active link processing - On Control WFLG /* Tue Apr 29 2008 20:41:53 */ WFLG Workflow Trace Log -- OFF On Tue, Apr 29, 2008 at 7:40 PM, David Sanders [EMAIL PROTECTED] wrote: ** As I said – use a Close Window action in the same active link that performs the Open Window action, after the Window Open action. The Close window action will run on the current window, not the new one being opened. AL – action 1 – open form 2 Action 2 – Close Window Or AL 1 – Run-If 1 -action 1 – open form 2 Action 2 – Close Window AL 2 – Run-If 2 -action 1 – open form 3 Action 2 – Close Window Or even AL 1 – Run-If 1 -action 1 – open form 2 AL 2 – Run-If 2 -action 1 – open form 3 AL 3 (no run-if, higher execution order) Action 1 – Close Window David Sanders Remedy Solution Architect *Enterprise** Service Suite @ Work* == *ARS List Award Winner 2005* *Best 3rd party Remedy Application* * * See the *ESS Concepts Guide*http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 2:59 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Switching between Windows ** Opening is OK. Mapping is also ok. Now I need to close the previous (Parent) window. I tried RUN PROCESS to send a event to parent form and I captured the event in Parent from to close it. But by the time it sends the event the next window is already opened so not closing the behind parent window. Can you suggest any alternative way ?? On Tue, Apr 29, 2008 at 7:17 PM, David Sanders [EMAIL PROTECTED] wrote: ** __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
Re: Switching between Windows
Revesing the IfActions Opens the form2 and do not closes Form1. Form1 is closed only when From2 is closed. ACTL Checking Form1:OpenForm2 (0) ACTL - Passed qualification -- perform if actions ACTL 0: Open Dialog ACTLServer: localhost ACTLSchema: Form2 ACTLView: ACTL /* Tue Apr 29 2008 22:04:57 */ ACTL Start active link processing -- Operation - On Control ACTL For Schema - Form2 ACTL Linked to field - Next (536870909) ACTL On screen type - DIALOG ACTL Checking From2:Message (0) ACTL - Passed qualification -- perform if actions ACTL 0: Message ACTL Message text: test ACTL /* Tue Apr 29 2008 22:05:01 */ ACTL Stop active link processing - On Control ACTL 1: Close Window ACTL /* Tue Apr 29 2008 22:05:02 */ ACTL Stop active link processing - On Control WFLG /* Tue Apr 29 2008 22:05:08 */ WFLG Workflow Trace Log -- OFF On Tue, Apr 29, 2008 at 9:15 PM, David Sanders [EMAIL PROTECTED] wrote: ** That's what that active link is doing. It has one action (0) – Close Window. You need to add an action before this to Open the new window and map your values across. The Close Window should be the 2nd action. David Sanders Remedy Solution Architect *Enterprise** Service Suite @ Work* == *ARS List Award Winner 2005* *Best 3rd party Remedy Application* * * See the *ESS Concepts Guide*http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 4:16 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Switching between Windows ** Tried this one and it is closing the parent window and not opening the child one. AL log also stops after closing the parent window. ACTL Checking Form1:OpenForm2 (0) ACTL - Passed qualification -- perform if actions ACTL 0: Close Window ACTL /* Tue Apr 29 2008 20:41:49 */ ACTL Stop active link processing - On Control WFLG /* Tue Apr 29 2008 20:41:53 */ WFLG Workflow Trace Log -- OFF On Tue, Apr 29, 2008 at 7:40 PM, David Sanders [EMAIL PROTECTED] wrote: ** As I said – use a Close Window action in the same active link that performs the Open Window action, after the Window Open action. The Close window action will run on the current window, not the new one being opened. AL – action 1 – open form 2 Action 2 – Close Window Or AL 1 – Run-If 1 -action 1 – open form 2 Action 2 – Close Window AL 2 – Run-If 2 -action 1 – open form 3 Action 2 – Close Window Or even AL 1 – Run-If 1 -action 1 – open form 2 AL 2 – Run-If 2 -action 1 – open form 3 AL 3 (no run-if, higher execution order) Action 1 – Close Window David Sanders Remedy Solution Architect *Enterprise** Service Suite @ Work* == *ARS List Award Winner 2005* *Best 3rd party Remedy Application* * * See the *ESS Concepts Guide*http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 2:59 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Switching between Windows ** Opening is OK. Mapping is also ok. Now I need to close the previous (Parent) window. I tried RUN PROCESS to send a event to parent form and I captured the event in Parent from to close it. But by the time it sends the event the next window is already opened so not closing the behind parent window. Can you suggest any alternative way ?? On Tue, Apr 29, 2008 at 7:17 PM, David Sanders [EMAIL PROTECTED] wrote: ** __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __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
Re: Switching between Windows
Not working Rik. Its closing and then STOPS !! ARS 7.0 Customized Appl. On Tue, Apr 29, 2008 at 9:37 PM, Rick Cook [EMAIL PROTECTED] wrote: ** It's counterintuitive, but try it with the Close Window action running before the Open Window action. I've seen that work. Rick On Tue, Apr 29, 2008 at 8:16 AM, Ganga Prasad [EMAIL PROTECTED] wrote: ** Tried this one and it is closing the parent window and not opening the child one. AL log also stops after closing the parent window. ACTL Checking Form1:OpenForm2 (0) ACTL - Passed qualification -- perform if actions ACTL 0: Close Window ACTL /* Tue Apr 29 2008 20:41:49 */ ACTL Stop active link processing - On Control WFLG /* Tue Apr 29 2008 20:41:53 */ WFLG Workflow Trace Log -- OFF On Tue, Apr 29, 2008 at 7:40 PM, David Sanders [EMAIL PROTECTED] wrote: ** As I said – use a Close Window action in the same active link that performs the Open Window action, after the Window Open action. The Close window action will run on the current window, not the new one being opened. AL – action 1 – open form 2 Action 2 – Close Window Or AL 1 – Run-If 1 -action 1 – open form 2 Action 2 – Close Window AL 2 – Run-If 2 -action 1 – open form 3 Action 2 – Close Window Or even AL 1 – Run-If 1 -action 1 – open form 2 AL 2 – Run-If 2 -action 1 – open form 3 AL 3 (no run-if, higher execution order) Action 1 – Close Window David Sanders Remedy Solution Architect *Enterprise** Service Suite @ Work* == *ARS List Award Winner 2005* *Best 3rd party Remedy Application* * * See the *ESS Concepts Guide*http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 2:59 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Switching between Windows ** Opening is OK. Mapping is also ok. Now I need to close the previous (Parent) window. I tried RUN PROCESS to send a event to parent form and I captured the event in Parent from to close it. But by the time it sends the event the next window is already opened so not closing the behind parent window. Can you suggest any alternative way ?? On Tue, Apr 29, 2008 at 7:17 PM, David Sanders [EMAIL PROTECTED] wrote: ** __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __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
Re: Switching between Windows
Fred, I missed the whole detail. Here it is.. ARS : 7.0 OS : Windows XP SP2 DB : IBMDB2 ( I need to implement in Oracle in Real Field. I am trying local DB2) No ITSM, Cutomised Application On Wed, Apr 30, 2008 at 12:28 AM, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** I don't know if you specified what version ARS Server (including db and OS platform) you are using (if you did and I missed it sorry) ARS Version - ? OS - ? db- ? Fred -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 11:36 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Switching between Windows ** Revesing the IfActions Opens the form2 and do not closes Form1. Form1 is closed only when From2 is closed. ACTL Checking Form1:OpenForm2 (0) ACTL - Passed qualification -- perform if actions ACTL 0: Open Dialog ACTLServer: localhost ACTLSchema: Form2 ACTLView: ACTL /* Tue Apr 29 2008 22:04:57 */ ACTL Start active link processing -- Operation - On Control ACTL For Schema - Form2 ACTL Linked to field - Next (536870909) ACTL On screen type - DIALOG ACTL Checking From2:Message (0) ACTL - Passed qualification -- perform if actions ACTL 0: Message ACTL Message text: test ACTL /* Tue Apr 29 2008 22:05:01 */ ACTL Stop active link processing - On Control ACTL 1: Close Window ACTL /* Tue Apr 29 2008 22:05:02 */ ACTL Stop active link processing - On Control WFLG /* Tue Apr 29 2008 22:05:08 */ WFLG Workflow Trace Log -- OFF On Tue, Apr 29, 2008 at 9:15 PM, David Sanders [EMAIL PROTECTED] wrote: ** That's what that active link is doing. It has one action (0) – Close Window. You need to add an action before this to Open the new window and map your values across. The Close Window should be the 2nd action. David Sanders Remedy Solution Architect *Enterprise** Service Suite @ Work* == *ARS List Award Winner 2005* *Best 3rd party Remedy Application* ** See the *ESS Concepts Guide*http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 4:16 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Switching between Windows ** Tried this one and it is closing the parent window and not opening the child one. AL log also stops after closing the parent window. ACTL Checking Form1:OpenForm2 (0) ACTL - Passed qualification -- perform if actions ACTL 0: Close Window ACTL /* Tue Apr 29 2008 20:41:49 */ ACTL Stop active link processing - On Control WFLG /* Tue Apr 29 2008 20:41:53 */ WFLG Workflow Trace Log -- OFF On Tue, Apr 29, 2008 at 7:40 PM, David Sanders [EMAIL PROTECTED] wrote: ** As I said – use a Close Window action in the same active link that performs the Open Window action, after the Window Open action. The Close window action will run on the current window, not the new one being opened. AL – action 1 – open form 2 Action 2 – Close Window Or AL 1 – Run-If 1 -action 1 – open form 2 Action 2 – Close Window AL 2 – Run-If 2 -action 1 – open form 3 Action 2 – Close Window Or even AL 1 – Run-If 1 -action 1 – open form 2 AL 2 – Run-If 2 -action 1 – open form 3 AL 3 (no run-if, higher execution order) Action 1 – Close Window David Sanders Remedy Solution Architect *Enterprise** Service Suite @ Work* == *ARS List Award Winner 2005* *Best 3rd party Remedy Application* ** See the *ESS Concepts Guide*http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 29, 2008 2:59 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Switching between Windows ** Opening is OK. Mapping is also ok. Now I need to close the previous (Parent) window. I tried RUN PROCESS to send a event to parent form and I captured the event in Parent from to close it. But by the time it sends the event the next window
Remedy Tree diagram
Hi List, In remedy Tree veiw of table field, how to know what is the node (node content) the user has clicked on ?? ARS 7.0.01 No ITSM Customized appl. -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Tree diagram
Condria. Nice to ge t quick reply. Infact my requirement is to Identify the node content (The data on what the user has clicked) in the tree view. I need to do some calculation based on the value. On Tue, Apr 15, 2008 at 5:38 PM, CONDREA, Daniel [EMAIL PROTECTED] wrote: ** http://www.buoyantsolutions.net/PUBLIC/ARS7/TreeView.zip -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Tuesday, April 15, 2008 3:06 PM *To:* arslist@ARSLIST.ORG *Subject:* Remedy Tree diagram ** Hi List, In remedy Tree veiw of table field, how to know what is the node (node content) the user has clicked on ?? ARS 7.0.01 No ITSM Customized appl. -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Difference between NULL and
Thanks Fred It should behave equally in the native application in Remedy and the external interface. As it can be seen before I start *My Approch* the system was behaving differently for the native and external application. Not able to get here ?? :( -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - On Fri, Apr 11, 2008 at 6:40 PM, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** Null is defined by the ISO SQL standard as different from both an empty string or the numerical value 0. Null indicates the absence of any value, the empty string and numerical zero both represent actual values. From: http://en.wikipedia.org/wiki/Null_(SQLhttp://en.wikipedia.org/wiki/Null_%28SQL ) Fred -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Friday, April 11, 2008 7:40 AM *To:* arslist@ARSLIST.ORG *Subject:* Difference between NULL and Hi all Is there any difference between NULL and in a character field ?? *My Scenario* I have a character field. The value to the character field is supposed to come from a already existing backend from. *My Requirement.* On saving I should not be able to save any value in the character field other than whatever record is present in the BACKEND Form *My Solution* I wrote a filter (RUNIF : character field != NULL) which will go for a SQL. The SQL will find out the present value in the ticket with the BACKEND record. Once it is finding, it will make a flag field with count of records found (Usually 1). If no backend records found then it will make the flag 0( zero matching records) The very next filter will check for the value in the Flag field; If it is 0 then give a error message *My problem *It is working as expected as long as I am opening my Remedy client and save the ticket. But when I am trying to create a ticket in my application through another application by XML without passing the value to the character field it is throwing an error to the originating system.One strange thing is that if in the xml if i am removing the characterfield completly; it is working fine. *My Approach* I approached with hit and trial method that before going for SQL I set the character field NULL if it is . Now it is working fine. *My Doubt* Is this the way remedy should behave ?? is there any diff between NULL and ?? *My Setup* ARS V 7.0.01 P003 No ITSM Completely Customized appl. -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) - __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
Re: Control over Request ID
Hey I was not there, Hold on. I am not using any ITSM. Mine is completely customised application developed from scratch. -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) On Thu, Mar 6, 2008 at 9:29 PM, Kalyan Krishna Nethy [EMAIL PROTECTED] wrote: ** Hi Ganga, Assuming you are using ITSM 7.x here is the logic to generate the Incident IDs in sequence. Step 1: Write a filter on Submit to generate an Instance ID if the field is NULL. Step 2: Write another filter to push the Instance ID to the NUM Generator form. Don't forget to override the filter phasing. Step 3: Write another filter to set the Incident ID field from the NUM Generator form. I used this workflow to generate the IDs in sequence. Regards, Kalyan. On Thu, Mar 6, 2008 at 2:05 AM, Roger Medsker [EMAIL PROTECTED] wrote: ** Rick, Thomas, Assumption: Ganga is using ITSM 7.x What is happening is the following. When Ganga opens an Incident (or Change), workflow performs a push to a Ticket Num Generator form which generates a request ID for that form just like we're used to. Workflow then sets the Request ID field (NOT field ID 1) for the Incident (or Change) form to $LASTID$. If the Incident (or Change) is saved then the Request ID is used. If the Incident was not saved the Request ID is abandoned. The next time Ganga opens the form the process is repeated. If the previous (by anyone) Request ID was used the current Request ID is one number greater than the previous. If the previous Request ID was abandoned there will be a gap. Roger *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Rick Cook *Sent:* Wednesday, March 05, 2008 1:54 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Control over Request ID ** You are correct, Thomas, except that ITSM 7 doesn't use Entry IDs on the Help Desk form the way we're used to. I've seen this happen myself. Technically, every Entry ID is represented by a record, but some are created and discarded before they're viewable by anyone. I didn't build it... Rick On Wed, Mar 5, 2008 at 11:33 AM, Thomas Bean [EMAIL PROTECTED] wrote: ** Rick, This is NOT the normal, default behavior for a the Request ID assignment on a standard Remedy form. Unless there is workflow to get the next ID value prior to saving the entry, the default behavior is for the Request ID not to be assigned until the entry is initially saved. In the form properties, is 'Enable Next Request ID Block Size' checked? If so, what is the value for the Next Request ID Block Size? --Thomas - Original Message - *From:* Rick Cook [EMAIL PROTECTED] *Newsgroups:* gmane.comp.crm.arsystem.general *To:* arslist@ARSLIST.ORG *Sent:* Wednesday, March 05, 2008 12:38 PM *Subject:* Re: Control over Request ID ** Correct. 12346 was allocated, but was then discarded before it became a viewable Incident. Rick On Wed, Mar 5, 2008 at 10:32 AM, Ganga Prasad [EMAIL PROTECTED] wrote: ** Neel Let me be bit more clearer. Lets say I have last request ID 0012345.I am going ahead with a new ticket. I don't save the ticket and cancel it. Next I am creating a ticket and saving it then my new request ID will be 0012347 instead of 0012346. My understanding behind this in above scenario is I tried to create a instance of the ticket and the Next Reqest ID is incremented by 1 and when i again tried to create a ticket again the Next Reqest ID incremented by 1 and it gave me the number 0012347. Is this the way it work ? -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) On Wed, Mar 5, 2008 at 10:36 PM, Rick Cook [EMAIL PROTECTED] wrote: ** I agree with Neel, whose reasons are sound. The Interface_Create form does not always create an Incident, which is why there are gaps. Rick On Wed, Mar 5, 2008 at 8:57 AM, Neel Guatam [EMAIL PROTECTED] wrote: Ganga, When you say 'requestID generated are not in sequence' - are you referring to; for example; all the incidents created? If so, that's how it works as when you open a new incident and select a customer, it generated an incident ID and increment the nextID for that module. However, when user cancels out and doesn't save that incident, the next incident created will not be in sequence and have a gap of one. If many users in production do that then you'll see the broken sequence and it's normal. IF this is the case then I don't think you should be messing with it. Just my $0.02 Neel Gautam Accenture - Chicago Delivery Centre Core Values:Stewardship * Best People * Client Value Creation* One Global Network * Respect for the Individual
Control over Request ID
Hi All Do we have any control over the sequence of Request ID ? My understanding is that this number us generated automatically. Can we control the way it is getting generated ? Version 7.0.01 Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Control over Request ID
Thanks Rick In fact issue with me is that the request ID generated are not in sequence. So can we make the is possible to break the sequence or if broken then make it in order ? Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) On Wed, Mar 5, 2008 at 10:10 PM, Rick Cook [EMAIL PROTECTED] wrote: ** You can, but should do so carefully. The nextId column in the arschema table contains the number of the next Request ID for the specified form. Manipulating that manually is done by resetting the value via SQL command, which should only be done under specific controlled conditions, which are listed in the Remedy documentation. Failure to think through the process carefully may result in the form being unable to accept further entries until the problem is fixed. If you want to present a different type of number to customers, or exercise more control over it, I would recommend that you create and use a different field. Rick On Wed, Mar 5, 2008 at 8:19 AM, Ganga Prasad [EMAIL PROTECTED] wrote: ** Hi All Do we have any control over the sequence of Request ID ? My understanding is that this number us generated automatically. Can we control the way it is getting generated ? Version 7.0.01 Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __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
Re: Control over Request ID
Neel Let me be bit more clearer. Lets say I have last request ID 0012345.I am going ahead with a new ticket. I don't save the ticket and cancel it. Next I am creating a ticket and saving it then my new request ID will be 0012347 instead of 0012346. My understanding behind this in above scenario is I tried to create a instance of the ticket and the Next Reqest ID is incremented by 1 and when i again tried to create a ticket again the Next Reqest ID incremented by 1 and it gave me the number 0012347. Is this the way it work ? -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) On Wed, Mar 5, 2008 at 10:36 PM, Rick Cook [EMAIL PROTECTED] wrote: ** I agree with Neel, whose reasons are sound. The Interface_Create form does not always create an Incident, which is why there are gaps. Rick On Wed, Mar 5, 2008 at 8:57 AM, Neel Guatam [EMAIL PROTECTED] wrote: Ganga, When you say 'requestID generated are not in sequence' - are you referring to; for example; all the incidents created? If so, that's how it works as when you open a new incident and select a customer, it generated an incident ID and increment the nextID for that module. However, when user cancels out and doesn't save that incident, the next incident created will not be in sequence and have a gap of one. If many users in production do that then you'll see the broken sequence and it's normal. IF this is the case then I don't think you should be messing with it. Just my $0.02 Neel Gautam Accenture - Chicago Delivery Centre Core Values:Stewardship * Best People * Client Value Creation* One Global Network * Respect for the Individual * Integrity -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ganga Prasad Sent: Wednesday, March 05, 2008 10:50 AM To: arslist@ARSLIST.ORG Subject: Re: Control over Request ID ** Thanks Rick In fact issue with me is that the request ID generated are not in sequence. So can we make the is possible to break the sequence or if broken then make it in order ? Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) On Wed, Mar 5, 2008 at 10:10 PM, Rick Cook [EMAIL PROTECTED] wrote: ** You can, but should do so carefully. The nextId column in the arschema table contains the number of the next Request ID for the specified form. Manipulating that manually is done by resetting the value via SQL command, which should only be done under specific controlled conditions, which are listed in the Remedy documentation. Failure to think through the process carefully may result in the form being unable to accept further entries until the problem is fixed. If you want to present a different type of number to customers, or exercise more control over it, I would recommend that you create and use a different field. Rick On Wed, Mar 5, 2008 at 8:19 AM, Ganga Prasad [EMAIL PROTECTED] wrote: ** Hi All Do we have any control over the sequence of Request ID ? My understanding is that this number us generated automatically. Can we control the way it is getting generated ? This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __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
Re: Pad the info
Hi Mark For your purpose try the following ((($Trouble Ticket #$ + ) + RPAD($Company$, LENGTH, ) + ) + $Status$ This LENGHT can be a constant or it can be calculated to be Max Lenght of Company Field. Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) On Tue, Mar 4, 2008 at 6:48 PM, Carey Matthew Black [EMAIL PROTECTED] wrote: Mark, Be warned... your approach assumes that the user will be viewing the output in a fixed width font. If they are using a variable width font (like my gmail account uses) then the value will likely not align. If you really want formatting that is likely to be as you expect it, then either send it in an attached PDF, or as HTML. I know of no better solutions to deal with formatting issues than those two paths. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Mar 3, 2008 at 2:17 PM, Brittain, Mark [EMAIL PROTECTED] wrote: ** Hi All, I have an escalation that looks for Trouble Tickets that have not been touched in a week. When there is a match, I do a set fields to another form. Then I have another escalation that emails out the results. The fields pushed are ((($Trouble Ticket #$ + ) + $Company$) + ) + $Status$ The problem is the Company name can be all different lengths, so the result is wavy. Like this TT#01064088 Corporate Systems - Internal WorkInProgress TT#01077255 NaviSite, Inc. Assigned I would like it to be placed like this TT#01064088 Corporate Systems - InternalWorkInProgress TT#01077255 NaviSite, Inc. Assigned Is there a way to do that? Thanks Mark Mark Brittain ESM Remedy Developer NaviSite Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are