The INCLUDE> statement points to a static path.
I've compiled with the static path, without the static path, and even without the INCLUDE statement.
Am still getting the same External Error, but once I click OK on that window, it continues to (I believe) go through the compile process, presents a window saying that the .exe has been created, and I can see 2 files in the directory where I pointed the output of the compile: TransferCredits.exe (file type Application, 2,177kb, with todays date/time modified); and ircv.dll (file type Application Extension, 1,862kb, with a date modified of 07/25/2013 13:07).
I'm thinking it's a setup deal, since I am getting the external exception. The compile process is seeing something that it perceives as an external reference or external file and can't find it?
I'll post my setup momentarily, meanwhile, here is the script I'm trying to compile. I have commented the INCLUDE statement. Know that the script does run in debug mode with no problems. Lots of comments, and it's unfinished, but does what I've told it to do. Comments at the end are what I'm trying to accomplish.
Code: Select all
// COMPILE_OPTS|C:\DiamondD_Robots\Robots\TransferCredits\TransferCredits.exe||CONSOLE=0|INCLUDES=1| /NOSYSTRAY|RUNTIMES=1|BMPS=0
GetFileList>S:\customer\Southwest University\Robot project\credit transfers\*.xls*,ws-file-list,|
Separate>ws-file-list,|,ws-name-files
If>ws-name-files_count = 0
MessageModal>No excel files to process, ending script
GoTo>EndRoutine
endif
//INCLUDE>C:\Documents and Settings\Administrator\My Documents\Macro Scheduler 14\swu_rdp_login.scp
SetFocus>SWUniversity4*
wait>1
//Bring up the student master select by clicking on Registrar, then Student Master from the dropdown
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\MenuOptions\Registrar\registrar.bmp,SCREEN,0.2,1,RegX,RegY,NumFound,CCOEFF
If>NumFound>0
MouseMove>RegX_0,RegY_0
Lclick
Wait>1
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\MenuOptions\Registrar\studentMaster.bmp,SCREEN,0.2,1,XArr,YArr,NumFound,CCOEFF
If>NumFound>0
MouseMove>XArr_0,YArr_0
LClick
Else
MessageModal>Error opening Student Master/Select student screen
GoTo>EndRoutine
Endif
else
MessageModal>Error clicking on registrar dropdown
GoTo>EndRoutine
Endif
wait>1
let>i=0
Repeat>i
let>i=i+1
//open an xls file
XLOpen>ws-name-files_%i%,0,ws-name-xl-handle
//pull the ssan, school, and term. remove - from ssan
XLGetCell>ws-name-xl-handle,Sheet1,7,2,ws-no-ssan
XLGetCell>ws-name-xl-handle,Sheet1,4,4,ws-name-school
XLGetCell>ws-name-xl-handle,Sheet1,9,2,ws-date-term
//split the ssan into 3 parts - can't send '-' to diamondd
MidStr>ws-no-ssan,1,3,ssan-1
MidStr>ws-no-ssan,5,2,ssan-2
MidStr>ws-no-ssan,8,4,ssan-3
//from here: show vars as a debug. this will be removed on install
MessageModal>SSAN: %ws-no-ssan% SCHOOL: %ws-name-school% TERM: %ws-date-term%
//to here
SetFocus>SWUniversity*
Wait>1
Press TAB
wait>1
Send>%ssan-1%
Wait>1
Send>%ssan-2%
Wait>1
Send>%ssan-3%
Press Enter
Wait>3
//need to determine error handling here. no error is displayed on invalid ssan entry
//maybe if we are still seeing 'Select a Student' on the screen?
//First time through, CTRL TAB puts us on the history tab. Subsequent opens already are focused on History
SetFocus>SWUniversity*
If>i<2
Press CTRL
Press TAB
Release TAB
Release CTRL
Wait>1
EndIf
//here, we need to compare the First Term Date and Program in the excel spreadsheet to the fields
//First Term Date and Program. If they don't match, this file errors out and we close it, move to errors,
//and try the next file. need to figure out how to do this
//
//Now, pull up the transfer credits screen under Registrar/Transfer Credits
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\MenuOptions\Registrar\registrar.bmp,SCREEN,0.2,1,RegX,RegY,NumFound,CCOEFF
If>NumFound=0
MessageModal>Can't pull up transfer credits
goto>EndRoutine
Endif
MouseMove>RegX_0,RegY_0
Lclick
Wait>1
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\MenuOptions\Registrar\transferCredit.bmp,SCREEN,0.2,1,XArr,YArr,NumFound,CCOEFF
If>NumFound=0
MessageModal>Error opening Registrar/Transfer Credit
GoTo>EndRoutine
Endif
MouseMove>XArr_0,YArr_0
LClick
wait>1
//now. start at row 16. while our course-id is not 'Total', find a blank hours cell. perform subroutine
let>row=16
let>ws-flag-first=Y
XLGetCell>ws-name-xl-handle,Sheet1,row,1,ws-id-course
while>ws-id-course<>Total
XLGetCell>ws-name-xl-handle,Sheet1,row,3,ws-hours
If>ws-hours<1
Gosub>processCredits
EndIf
let>row=row+1
XLGetCell>ws-name-xl-handle,Sheet1,row,1,ws-id-course
EndWhile
SetFocus>SWUniversity*
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\exit.bmp,SCREEN,0.2,1,XArr,YArr,NumFound,CCOEFF
If>NumFound=0
MessageModal>Error exiting Registrar/Transfer Credit
GoTo>EndRoutine
Endif
MouseMove>XArr_0,YArr_0
LClick
Wait>1
//Press the select button in prep for the next ssan to be sent
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\select.bmp,SCREEN,0.2,1,XArr,YArr,NumFound,CCOEFF
If>NumFound=0
MessageModal>Error going to select the next student
GoTo>EndRoutine
Endif
MouseMove>XArr_0,YArr_0
LClick
XLQuit>ws-name-xl-handle
MessageModal>Pausing here to go to next file
Until>i,ws-name-files_count
//We've reached the end of the directory listing, so close out windows and log off of DiamondD
SetFocus>SWUniversity4*
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\cancel.bmp,SCREEN,0.2,1,XArr,YArr,NumFound,CCOEFF
If>NumFound=0
MessageModal>Error cancelling the select screen
GoTo>EndRoutine
Endif
MouseMove>XArr_0,YArr_0
LClick
Wait>1
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\exit.bmp,SCREEN,0.2,1,XArr,YArr,NumFound,CCOEFF
If>NumFound=0
MessageModal>Error exiting the student master screen
GoTo>EndRoutine
Endif
MouseMove>XArr_0,YArr_0
LClick
Wait>1
//and here, close the rdp window - need to also close out diamondD!
//WindowAction>3,SWUniversity4*
MessageModal>Finished looping thru spreadsheets
SRT>processCredits
//Now we transfer/enter info to the screen by sending keystrokes to tab
//After F9 to save, exit the Transfer Credit screen
//First time thru - If the student has multiples, focus on a blank record
If>ws-flag-first=N
GoTo>Continue
EndIf
Let>ws-flag-first=N
SetFocus>SWUniversity4*
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\endRecords.bmp,SCREEN,0.2,1,Xarr,Yarr,NumFound,CCOEFF
If>NumFound>0
MouseMove>Xarr_0,Yarr_0
Lclick
Else
FindImagePos>C:\DiamondD_Robots\MacroScreenShots\CreditTransfers\ScreenShot.bmp,SCREEN,0.2,1,Xarr,Yarr,NumFound,CCOEFF
If>NumFound>0
MouseMove>Xarr_0,Yarr_0
LClick
else
MessageModal>Can't click on blank screen to set focus
GoTo>EndRoutine
EndIf
EndIf
Label>Continue
SendText>%ws-name-school%
Wait>1
Press TAB *3
Wait>1
SendText>ws-id-course
Wait>1
Press TAB *5
SendText>A
Wait>1
Press TAB
SendText>30
Wait>1
Press TAB
SendText>3
Press TAB
Wait>1
Press Enter
MessageModal>%ws-id-school%,%ws-id-course%,%ws-id-program% on line %row%
SetFocus>SWUniversity*
END>processCredits
//OPEN THE DIRECTORY LISTING FILE
//LOOP THIS:
// READ A LINE FROM DIRECTORY LISTING
// AT END GO TO EXIT-LOOP
// OPEN THE .XLS FILE
// SAVE THE SSAN, SCHOOL, TERM
// INQUIRE IN REGISTRAR/STUDENT MASTER ON SSAN
// ERROR HANDLING:
// IF NOT FOUND GO TO HANDLE ERROR SRT
// IF NOT CURRENT TERM GO TO HANDLE ERROR SRT
// SAVE STUDENT ID
// INITIATE REGISTRAR/TRANSFER CREDITS
// SELECT BY STUDENT ID
// LOOP THIS: -- LIKE A DO/WHILE
// SEARCH WORKSHEET FOR BLANK HOURS
// AT END OF WORKSHEET GO TO COMPLETE-FILE
// POPULATE COURSE, SCHOOL HOURS, CREDITS
// ENTER
// ERROR HANDLING:
// CLOSE TRANSFER CREDITS SCREEN
// GO TO HANDLE ERROR SRT
// GO TO LOOP
// END OF THIS LOOP
//
// COMPLETE-FILE
// F9 TO SAVE SCREEN
// CLOSE TRANSFER CREDITS SCREEN
// CLOSE XLS FILE
// MOVE XLS FILE TO /COMPLETED
// GO TO OUTER LOOP
//
// HANDLE-ERROR
// CLOSE XLS FILE
// MOVE XLS FILE TO /ERRORS
// GO TO OUTER LOOP
//EXIT-LOOP
//
//FINISH SCRIPT:
//CLOSE STUDENT MASTER SCREEN
//EXIT DIAMONDD
//TERMINATE REMOTE SESSION
//CLOSE DIRECTORY LISTING?
//(RE)MOVE DIRECTORY LISTING?
//END
Label>EndRoutine