Hi LJ, Thanks for helping me on this I think I have wrongly written ...after executing the run process command ....the command prompt dialogue box is seen on the client for milliseconds which I don't want it to be like that....what I have to do it.
thanks G LJ LongWing (Head) wrote: > > G, > I'm not familiar with a way to execute a command prompt on the client > machine that doesn't show it on the task bar. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of gok's > Sent: Monday, July 11, 2011 3:50 PM > To: [email protected] > Subject: Re: I need assitance in passing input parameter from RUN PROCESS > command line > > Hi All, > > I want to thank you every one from here wholeheartedly...............I > have > created this Java API first time successfully it is updating the records I > have to work more on it > My process command line is > CMD.exe /c C:\temp\MigrateDataForChangeID.bat $1$ (as Doug > described.....BRAVO...BRAVO :clap::clap: ) > > I have written the .bat file as > > @echo off > Set ChangeID= %1 > Set JAVA_HOME= "C:\Program Files\Java\jdk1.5.0_05\bin\" > > Echo %ChangeID% > Echo %JAVA_HOME% > > "C:\Program Files\Java\jdk1.5.0_05\bin\" -jar RemedyDataMigrator.jar > %ChangeID% > > It worked like charm....one small doubt in this one ....when I am > executing > the workflow on client side I am still able to see the cmd prompt dialogue > box how to get rid of this............. > > > > > > > > > Mueller, Doug wrote: >> >> You still seem to have a syntax error in your command line. >> >> The log file will show you the EXACT command line that is being >> performed. >> >> In your case, it is showing the following: >> >> CMD.exe /c " C:\temp\MigrateDataForChangeID.bat " + 'CHG000000076079' >> >> First, you are not building a Set Fields arithmetic syntax command here. >> You >> are entering the command in the definition exactly as you want it. >> >> Your definition is >> >> CMD.exe /c " C:\temp\MigrateDataForChangeID.bat " + '$1$' >> >> There are lots of extra pieces of syntax here that you should not need. >> >> Why do you have the double quotes around the program name? They should >> not >> be needed. >> >> Why do you have the extra couple of spaces before the program name and >> after >> the program name? >> >> Why do you have the + sign? You don't want that in the final command. >> >> Look at the command that is generated (the first string above that I cut >> and >> pasted. Is that what you would type at the command line to execute? >> That >> is >> what the system is attempting to execute. >> >> I would expect the definition to look more like this >> >> CMD.exe /c C:\temp\MigrateDataForChangeID.bat $1$ >> >> Notice all the extra quotes and the plus signs and such are not there. >> This is >> the command line you are going to execute. The system will substitute >> for >> any >> parameter in $$ that it recognizes. >> >> IF you run the command by hand from the command line and get it to work, >> use >> that exact same syntax. If your parameter requires surrounding single >> quotes, >> put them in. If it requires surrounding double quotes, put them in. >> Whatever >> would be needed from the command line. >> >> >> Note that the Run Process and the SQL syntax is just to type the command >> as you >> want it executed and put in parameters as you wish. No extra quotes. No >> extra >> plus signs. No extra anything. You can see from the command that the >> system >> is attempting to execute in your log, lots of extra bits of things that >> is >> just >> confusing the heck out of your program. >> >> A Set Fields or Push Fields where you are constructing a value and where >> you >> can add numbers or subtract or use functions or whatever needs the syntax >> of >> an arithmetic operation. But, Run Process does not. >> >> >> I hope this helps solve the rest of the problem. >> >> Doug Mueller >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]] On Behalf Of gok's >> Sent: Monday, July 11, 2011 11:02 AM >> To: [email protected] >> Subject: Re: I need assitance in passing input parameter from RUN PROCESS >> command line >> >> Hi Mueller, >> >> I am looking to this mail from Friday because I got a feeling that if >> Mueller and LJ responds to a mail it will be resolved no matter >> what.....and >> to day morning..I started breathing again....thanks for response.... >> >> As you mentioned I have noticed that the "$Change_ID+$" is not getting >> recognized so what I did is I have changed my Change ID to simple like >> ChangeID. >> >> The log file is capturing the change id perfectly so I debugged it as you >> mentioned me it worked....the log file is like this >> >> <ACTL> /* Mon Jul 11 2011 10:50:18 */ >> <ACTL> Start active link processing -- Operation - On Return >> <ACTL> For Schema - CHG:Change_History >> <ACTL> Linked to field - Change ID+ (1) >> <ACTL> On screen type - QUERY >> <ACTL> Checking TEST Active Link 4 (0) >> <ACTL> -> Passed qualification -- perform if actions >> <ACTL> 0: Run Process >> <ACTL> CMD.exe /c " C:\temp\MigrateDataForChangeID.bat " + >> '$1$' >> <ACTL> Process: CMD.exe /c " >> C:\temp\MigrateDataForChangeID.bat " + 'CHG000000076079' >> <ACTL> Return Code: 1l >> >> <ACTL> /* Mon Jul 11 2011 10:50:18 */ >> <ACTL> Stop active link processing - On Return >> >> 1)Do I need to put the ChangeID in single quotes or double quotes... >> >> 2)My .bat file is like this can you suggest me do I need to modify any >> thing.... >> >> @echo off >> set ChangeID=%1 >> Echo %ChangeID% >> >> set Java_Home="C:\Program Files\Java\jdk1.5.0_05\bin\" >> %JAVA_HOME%\Java -jar RemedyDataMigrator.jar %ChangeID% >> >> Pause.. >> >> this is giving error in the cmd prompt like this >> >> http://old.nabble.com/file/p32039891/07-11-2011%2B10-58-35%2BAM.png >> >> My doubt is the ChangeID is passing or not ......can you help me in >> writing >> the bat file.... >> >> >> >> >> >> >> Mueller, Doug wrote: >>> >>> From the output you are seeing in the log, the system has not recognized >>> the >>> parameter. I suspect if you look at an export file, you will find >>> $Change_ID+$ >>> in the definition. You should not see that. If the system recognized >>> this as >>> a field, it would have translated the name to an ID in the stored >>> definition. >>> >>> A couple of different possibilities: >>> >>> 1) There seems to be an inconsistency in capitalization in your >>> discsussion >>> below. >>> >>> At the start you show the command line to be ..... $change_id+$ >>> >>> In the run example, it echos $Change_ID+$ >>> >>> Depending on your database and case sensitivity, these are two >>> different >>> names. Do you have your capitalization right? >>> >>> 2) The fact that the word is Change_ID+ leads me to believe that this is >>> a >>> label. Is the DB name of the field you are trying to map the same as >>> the >>> label? Definitions in workflow key off the field NAME not the LABEL. >>> >>> 3) Have you tried using the field ID instead of a label/name for the >>> field >>> in question. Something like $988203489$ (whatever the ID is of >>> course). >>> >>> This eliminates all possible confusion about case, name/label, >>> spelling, or >>> whatever. >>> >>> I hope these offer some pointers to what might be the issue for you. >>> >>> Doug >>> >>> -----Original Message----- >>> From: Action Request System discussion list(ARSList) >>> [mailto:[email protected]] On Behalf Of gok's >>> Sent: Friday, July 08, 2011 3:28 PM >>> To: [email protected] >>> Subject: I need assitance in passing input parameter from RUN PROCESS >>> command line >>> >>> Hi All, >>> >>> I am trying to pass an input parameter from RUN Process which I am using >>> like this >>> >>> CMD.exe/c "C:\temp\MigrateDataForChangeID.bat" $change_id+$ >>> >>> I have written the Bat file like this >>> >>> @echo off >>> Set ChangeID= %1 >>> Set ChangeID = %Change_ID+%(If I hard code the change id here and start >>> the >>> bat file it is working) >>> Echo %Change_ID+% >>> >>> set Java_home="C:\Program Files\Java\jdk1.5.0_05\bin\" >>> %Java_Home%\java -jar RemedyDataMigrator.jar %Change_ID+% >>> >>> >>> >>> But if I am trying to pass it from RUNPROCESS it is not working as it >>> should >>> be. If I check the log file it is like this >>> >>> <ACTL> /* Fri Jul 08 2011 15:17:11 */ >>> <ACTL> Start active link processing -- Operation - On Return >>> <ACTL> For Schema - CHG:Change_History >>> <ACTL> Linked to field - Change ID+ (1) >>> <ACTL> On screen type - QUERY >>> <ACTL> Checking TEST Active Link 4 (0) >>> <ACTL> -> Passed qualification -- perform if actions >>> <ACTL> 0: Run Process >>> <ACTL> CMD.exe /c " C:\temp\MigrateDataForChangeID.bat" >>> $Change_ID+$ >>> <ACTL> Process: CMD.exe /c " >>> C:\temp\MigrateDataForChangeID.bat" $Change_ID+$ >>> <ACTL> Return Code: 1 >>> >>> can any one suggest me how to pass the input parameter and am I wrote >>> the >>> correct bat file. >>> >>> Thanks >>> G >>> >>> >>> >>> -- >>> View this message in context: >>> > http://old.nabble.com/I-need-assitance-in-passing-input-parameter--from-RUN- > PROCESS-command-line-tp32025056p32025056.html >>> Sent from the ARS (Action Request System) mailing list archive at >>> Nabble.com. >>> >>> > ____________________________________________________________________________ > ___ >>> 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" >>> >>> >> >> -- >> View this message in context: >> > http://old.nabble.com/I-need-assitance-in-passing-input-parameter--from-RUN- > PROCESS-command-line-tp32025056p32039891.html >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> > ____________________________________________________________________________ > ___ >> 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" >> >> > > -- > View this message in context: > http://old.nabble.com/I-need-assitance-in-passing-input-parameter--from-RUN- > PROCESS-command-line-tp32025056p32041687.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > ____________________________________________________________________________ > ___ > 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" > > -- View this message in context: http://old.nabble.com/I-need-assitance-in-passing-input-parameter--from-RUN-PROCESS-command-line-tp32025056p32041952.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
