RoboTask forum

I am new to ROBOTASK. I am trying to develop a task that will rename all the files in a directory.The files are html files, and are named with numbers, e.g. 3425346.htmlI also have an Excel file with two columns, where the first column gives the original names, and the second column give the desired new names with meaningful English words, e.g. NewName1.html.I have produced the following task definition, but it does not work. I run it from the Excel file with the HotKey Shift+Alt+F.I have Robotask 2.5.1. Any help will be greatly appreciated. Thank you in advance.;**********************;* RoboTask Task file *;* Do not edit!       *;********************** [Root]ActionAfterRun=INTEGER|0Actions=FOLDERAutomat=INTEGER|-1CatID=INTEGER|0ContinueOnError=INTEGER|0Events=FOLDERExternalName=STRING|"Task1"Hide=INTEGER|0ID=INTEGER|2130042527Name=STRING|"FilesRenameWikiBU"Priority=INTEGER|3RunOnClose=INTEGER|0RunOnStartup=INTEGER|0ToLog=INTEGER|3[Actions]Action1=FOLDERAction10=FOLDERAction11=FOLDERAction12=FOLDERAction13=FOLDERAction14=FOLDERAction15=FOLDERAction2=FOLDERAction3=FOLDERAction4=FOLDERAction5=FOLDERAction6=FOLDERAction7=FOLDERAction8=FOLDERAction9=FOLDER[Actions\Action1]ActionID=STRING|"A_VARIABLES_CREATE"Enabled=INTEGER|-1Name=STRING|"Create variable ""NEWFILENAME"" with value """""Params=FOLDER[Actions\Action1\Params]expand=STRING|"1"varname=STRING|"NEWFILENAME"[Actions\Action10]ActionID=STRING|"A_CLIPBOARD_COPY"Enabled=INTEGER|-1Name=STRING|"Copy"Params=FOLDER[Actions\Action10\Params]mode=STRING|"1"[Actions\Action11]ActionID=STRING|"A_CLIPBOARD_GET"Enabled=INTEGER|-1Name=STRING|"Get Text"Params=FOLDER[Actions\Action11\Params]variable=STRING|"NEWFILENAME"[Actions\Action12]ActionID=STRING|"A_VARIABLES_SET"Enabled=INTEGER|0Name=STRING|"Set variable ""NEWFILENAME"" with value ""{ClipBoardContent}"""Params=FOLDER[Actions\Action12\Params]expand=STRING|"1"varname=STRING|"NEWFILENAME"varvalue=STRING|"{ClipBoardContent}"[Actions\Action13]ActionID=STRING|"A_FILE_RENAME"Enabled=INTEGER|-1Name=STRING|"Rename File"Params=FOLDER[Actions\Action13\Params]count=STRING|"2"file1=STRING|"C:\Documents and Settings\Owner\Desktop\luisat\_pages\OLDFILENAME"mask=STRING|"NEWFILENAME"subdirs=STRING|"0"[Actions\Action14]ActionID=STRING|"A_MOUSE_MOVE"Enabled=INTEGER|-1Name=STRING|"Move"Params=FOLDER[Actions\Action14\Params]dx=STRING|"-1"dy=STRING|"1"mode=STRING|"1"[Actions\Action15]ActionID=STRING|"A_LOOP_END"Enabled=INTEGER|-1Name=STRING|"End Loop"[Actions\Action2]ActionID=STRING|"A_VARIABLES_CREATE"Enabled=INTEGER|-1Name=STRING|"Create variable ""OLDFILENAME"" with value """""Params=FOLDER[Actions\Action2\Params]expand=STRING|"1"varname=STRING|"OLDFILENAME"[Actions\Action3]ActionID=STRING|"A_VARIABLES_CREATE"Enabled=INTEGER|-1Name=STRING|"Create variable ""LOOPNUMBER"" with value """""Params=FOLDER[Actions\Action3\Params]expand=STRING|"1"varname=STRING|"LOOPNUMBER"[Actions\Action4]ActionID=STRING|"A_MOUSE_MOVETO"Enabled=INTEGER|-1Name=STRING|"Move To Object"Params=FOLDER[Actions\Action4\Params]bottom=STRING|"0"ctrltextexact=STRING|"0"left=STRING|"0"right=STRING|"0"top=STRING|"0"windowtext=STRING|"Microsoft Excel - indexrefNew2Ready.xls"wintextexact=STRING|"1"x=STRING|"0"y=STRING|"0"[Actions\Action5]ActionID=STRING|"A_LOOP_SIMPLE"Enabled=INTEGER|-1Name=STRING|"Simple Loop"Params=FOLDER[Actions\Action5\Params]begin=STRING|"1"end=STRING|"165"variable=STRING|"LOOPNUMBER"[Actions\Action6]ActionID=STRING|"A_CLIPBOARD_COPY"Enabled=INTEGER|-1Name=STRING|"Copy"Params=FOLDER[Actions\Action6\Params]mode=STRING|"1"[Actions\Action7]ActionID=STRING|"A_CLIPBOARD_GET"Enabled=INTEGER|-1Name=STRING|"Get Text"Params=FOLDER[Actions\Action7\Params]variable=STRING|"OLDFILENAME"[Actions\Action8]ActionID=STRING|"A_VARIABLES_SET"Enabled=INTEGER|0Name=STRING|"Set variable ""OLDFILENAME"" with value ""{ClipBoardContent}"""Params=FOLDER[Actions\Action8\Params]expand=STRING|"1"varname=STRING|"OLDFILENAME"varvalue=STRING|"{ClipBoardContent}"[Actions\Action9]ActionID=STRING|"A_MOUSE_MOVE"Enabled=INTEGER|-1Name=STRING|"Move"Params=FOLDER[Actions\Action9\Params]dx=STRING|"1"dy=STRING|"0"mode=STRING|"1"[Events]Event1=FOLDER[Events\Event1]Enabled=INTEGER|-1EventID=STRING|"E_GENERAL_HOTKEY"Params=FOLDER[Events\Event1\Params]hotkey=STRING|"41030"  

1. The "Move" action moves mouse cursor on specified amount of pixels, not a cells. I recommend to use "Send keystroke" action instead of "Move" (send arrow keys to Excel document). Also I recommend to put some pauses between sending keystrokes.

2. I think that you have to use
C:\Documents and Settings\Owner\Desktop\luisat\_pages\{OLDFILENAME}
and
{NEWFILENAME}
strings in "Rename file" action.

Thank you Oleg.I made the changes you suggested, and few other ones that were needed. Now the program flow moves well in the data, but I still get this error message: W: 29/05/2009 2:36:33 PM: Can't rename file C:\Documents and Settings\Owner\Desktop\luisat\_pages\53485000000114001.htmlThe new version is:;**********************;* RoboTask Task file *;* Do not edit!       *;********************** [Root]ActionAfterRun=INTEGER|0Actions=FOLDERAutomat=INTEGER|0CatID=INTEGER|0ContinueOnError=INTEGER|0Events=FOLDERExternalName=STRING|"Task2"Hide=INTEGER|0ID=INTEGER|386816237Name=STRING|"FilesRenameWikiBU (imported)"Priority=INTEGER|3RunOnClose=INTEGER|0RunOnStartup=INTEGER|0ToLog=INTEGER|3[Actions]Action1=FOLDERAction10=FOLDERAction11=FOLDERAction12=FOLDERAction13=FOLDERAction14=FOLDERAction15=FOLDERAction16=FOLDERAction17=FOLDERAction18=FOLDERAction2=FOLDERAction3=FOLDERAction4=FOLDERAction5=FOLDERAction6=FOLDERAction7=FOLDERAction8=FOLDERAction9=FOLDER[Actions\Action1]ActionID=STRING|"A_VARIABLES_CREATE"Enabled=INTEGER|-1Name=STRING|"Create variable ""NEWFILENAME"" with value """""Params=FOLDER[Actions\Action1\Params]expand=STRING|"1"varname=STRING|"NEWFILENAME"[Actions\Action10]ActionID=STRING|"A_CLIPBOARD_GET"Enabled=INTEGER|-1Name=STRING|"Get Text"Params=FOLDER[Actions\Action10\Params]variable=STRING|"NEWFILENAME"[Actions\Action11]ActionID=STRING|"A_CLIPBOARD_COPY"Enabled=INTEGER|-1Name=STRING|"Copy"Params=FOLDER[Actions\Action11\Params]mode=STRING|"1"[Actions\Action12]ActionID=STRING|"A_VARIABLES_SET"Enabled=INTEGER|-1Name=STRING|"Set variable ""NEWFILENAME"" with value ""{ClipBoardContent}"""Params=FOLDER[Actions\Action12\Params]expand=STRING|"1"varname=STRING|"NEWFILENAME"varvalue=STRING|"{ClipBoardContent}"[Actions\Action13]ActionID=STRING|"A_FILE_RENAME"Enabled=INTEGER|-1Name=STRING|"Rename File"Params=FOLDER[Actions\Action13\Params]count=STRING|"2"file0=STRING|"C:\Documents and Settings\Owner\Desktop\luisat\_pages\{OLDFILENAME}"mask=STRING|"{NEWFILENAME}"subdirs=STRING|"0"[Actions\Action14]ActionID=STRING|"A_GENERAL_SENDKEYS"Enabled=INTEGER|-1Name=STRING|"Send keys to ""Excel"""Params=FOLDER[Actions\Action14\Params]currentwindow=STRING|"0"fixedwindow=STRING|"1"keylayout=STRING|"0"keys=STRING|"{LEFT}{DOWN}"sendkind=STRING|"0"wincaption=STRING|"Excel"[Actions\Action15]ActionID=STRING|"A_LOOP_END"Enabled=INTEGER|-1Name=STRING|"End Loop"[Actions\Action16]ActionID=STRING|"A_VARIABLES_REMOVE"Enabled=INTEGER|-1Name=STRING|"Remove variable ""OLDFILENAME"""Params=FOLDER[Actions\Action16\Params]varname=STRING|"OLDFILENAME"[Actions\Action17]ActionID=STRING|"A_VARIABLES_REMOVE"Enabled=INTEGER|-1Name=STRING|"Remove variable ""NEWFILENAME"""Params=FOLDER[Actions\Action17\Params]varname=STRING|"NEWFILENAME"[Actions\Action18]ActionID=STRING|"A_VARIABLES_REMOVE"Enabled=INTEGER|-1Name=STRING|"Remove variable ""LOOPNUMBER"""Params=FOLDER[Actions\Action18\Params]varname=STRING|"LOOPNUMBER"[Actions\Action2]ActionID=STRING|"A_VARIABLES_CREATE"Enabled=INTEGER|-1Name=STRING|"Create variable ""OLDFILENAME"" with value """""Params=FOLDER[Actions\Action2\Params]expand=STRING|"1"varname=STRING|"OLDFILENAME"[Actions\Action3]ActionID=STRING|"A_VARIABLES_CREATE"Enabled=INTEGER|-1Name=STRING|"Create variable ""LOOPNUMBER"" with value """""Params=FOLDER[Actions\Action3\Params]expand=STRING|"1"varname=STRING|"LOOPNUMBER"[Actions\Action4]ActionID=STRING|"A_MOUSE_MOVETO"Enabled=INTEGER|-1Name=STRING|"Move To Object"Params=FOLDER[Actions\Action4\Params]bottom=STRING|"0"ctrltextexact=STRING|"0"left=STRING|"0"right=STRING|"0"top=STRING|"0"windowtext=STRING|"Microsoft Excel - indexrefNew2Ready.xls"wintextexact=STRING|"1"x=STRING|"0"y=STRING|"0"[Actions\Action5]ActionID=STRING|"A_LOOP_SIMPLE"Enabled=INTEGER|-1Name=STRING|"Simple Loop"Params=FOLDER[Actions\Action5\Params]begin=STRING|"1"end=STRING|"165"variable=STRING|"LOOPNUMBER"[Actions\Action6]ActionID=STRING|"A_CLIPBOARD_GET"Enabled=INTEGER|-1Name=STRING|"Get Text"Params=FOLDER[Actions\Action6\Params]variable=STRING|"OLDFILENAME"[Actions\Action7]ActionID=STRING|"A_CLIPBOARD_COPY"Enabled=INTEGER|-1Name=STRING|"Copy"Params=FOLDER[Actions\Action7\Params]mode=STRING|"1"[Actions\Action8]ActionID=STRING|"A_VARIABLES_SET"Enabled=INTEGER|-1Name=STRING|"Set variable ""OLDFILENAME"" with value ""{ClipBoardContent}"""Params=FOLDER[Actions\Action8\Params]expand=STRING|"1"varname=STRING|"OLDFILENAME"varvalue=STRING|"{ClipBoardContent}"[Actions\Action9]ActionID=STRING|"A_GENERAL_SENDKEYS"Enabled=INTEGER|-1Name=STRING|"Send keys to ""Excel"""Params=FOLDER[Actions\Action9\Params]currentwindow=STRING|"0"fixedwindow=STRING|"1"keylayout=STRING|"0"keys=STRING|"{RIGHT}"sendkind=STRING|"0"wincaption=STRING|"Excel"[Events]Event1=FOLDER[Events\Event1]Enabled=INTEGER|-1EventID=STRING|"E_GENERAL_HOTKEY"Params=FOLDER[Events\Event1\Params]hotkey=STRING|"41030"