Makes perfect sense, thanks!

I have a "new file in folder" trigger on a script. Script is roughly: get list of files in folder verify the file name is correct for our purposes email the file wait 7 seconds (we recently added this to give users time to close the file so it won't be locked) move the file from current folder to ba...

I switched on passive mode and got it to work. Not sure what passive mode is or does but got it running through trial and error.

ok, error on my part. Was pulling from the wrong folder. Now I get the following
Connected
Connection established
Starting FTP transfer
Transfer complete
"550-I/O Error: java.net.ConnectException: Connection refused: connect"

I'm trying to get FTPPutFile to work and I'm having some issues. Here's the script Let>IGNORESPACES=1 Let>strFileName=\\file-print\shared\CHRLoadTenders\166516.txt FTPPutFile>ftp-test.partnerdomain.com,myusername,passwordcontains)(,21,%strFileName%,To_CHR,,A MessageModal>FTP_RESULT Note that the pas...

I have a script that's moving files. Occasionally the file being moved is in use and the move doesn't happen. How can I monitor for an "in use" error so I can deal with these exceptions?

Thanks

OK thanks, now I've got it. I greatly appreciate the help.

ok, SRT is subroutine, I get that.
Please explain the let>ONERROR=MyErrorHandler
that looks like I'm setting a variable to MyErrorHandler and I'm not sure how that plays into this. Is ONERROR a keyword?

The script in question examines the contents of a shared network folder, moves files from that folder to a different shared network folder, inserts a row into a sql server table and uses the macro scheduler smtpsendmail command to email a copy of the file to a user. I suspect the error might be in m...

I have a script on a trigger of "new file in folder" running on an unattended PC. Occassionaly I get an error but by the time I get to looking at the PC, there is a generic "time out waiting for user input" or something like that. Any way to have all errors sent immediately via email? Any other idea...

I have a few scripts running on my machine in a "beta" mode. They are working well. Now I want to move them to a different machine that will run the scripts non-stop throughout the day. Is there an optimal configuration for a Macro Scheduler unattended PC? Should I turn off automatic windows updates...

Using v9.1.03

I sometimes get a time out exception when opening an ado connection in the VB section of a script. I would like to either increase the connection time out or put in exception handling. Can you guide me or point me to to documentation on either option?

Thanks

I'm using a variable for the body in the SMTPSendMail command. There are commas in the string and everything after the first comma gets cut off. How can I keep the commas? Example: Let>bigbody=Please send me $1,500,000 in cash SMTPSendMail>To,Server,FromAddress,FromName,Subject,bigbody The body of t...

It seems that the error was the result of killing IE then starting IE with the same session ID. I think there were times when the IE session wasn't all the way dead before I started it again. I put a delay between the kill and the start and I haven't received the error since (knock on wood).

I occasionally get the following error when running a script that is using IE:

RPC server not available.

When I get the error, Macro Scheduler seems to be running the script even though IE is not active. I stop the script and restart and all seems to be fine.