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:arslist@ARSLIST.ORG] On Behalf Of gok's Sent: Monday, July 11, 2011 3:50 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of gok's > Sent: Monday, July 11, 2011 11:02 AM > To: arslist@ARSLIST.ORG > 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:arslist@ARSLIST.ORG] On Behalf Of gok's >> Sent: Friday, July 08, 2011 3:28 PM >> To: arslist@ARSLIST.ORG >> 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"
