Hello Max: The remedy system is running under local account. I don't think it is a permissions problem as I added the following command to the script to see if can see the file and copy it:
Copy %7 importfile.csv It worked file when run thru Remedy. Ciao John John Kenny | Manager, Solutions Architect | Burntsand Inc. | O: 416-234-3837 | M: 416-992-9913 | [email protected] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Murnane, Phil Sent: May-25-10 2:11 PM To: [email protected] Subject: Re: Run Process produces empty data file John: When you ran your successful test from the command line, did you login to windows with the same ID that AR System runs under? If not, you may be seeing a permissions issue. Just a Thought, --Phil -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Kenny Sent: Tuesday, May 25, 2010 14:59 To: [email protected] Subject: Run Process producess empty data file Hello All: ARS: 7.1 P4 Platform: Windows 2003 Server I'm running into an issue where I am running a script that adds data to a csv file. I'm using the SED command (for windows, GNUWin32) to perform the substitution. Basically what this script does is append a column header and Request ID to the data file using SED and then imports the data file: START: cd /d %9 sed s/$/,%1/g %~7 > tempfile.csv sed 1s/%1/IMPORTID/ tempfile.csv > %~7 %2 -u %3 -p %4 -m %5 -d %6 -l "%~8\%~7.log" -o "%~9\%~7" -x <server name> Del tempfile.csv END: Where %1 is the Request ID and %7 is the file name. ARS is installed on the D drive whereas the data file is pushed to the C drive. When run thru a Run Process action, the tempfile.csv created in the first sed command ends up empty and therefore the original file (%7) also ends up empty. But if I run the command from the commandline it works fine. Just not thru Remedy. I even ran a test of pushing the data file to the D drive (D:\AR System) and running sed from there but same result. Added the following to the script after the cd /d %9 command: copy %7 importdatafile.csv The copy command works fine and does copy the file and its contents fine thru Remedy's Run Process so it is not a delay issue of the data file being transferred. Has anyone ever run into this type of behaviour before. Any assistance would be greatly appreciated. Thanx in advance Have a great day ciao john _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
