Fabre

* [[TV Card|TV Card]] - once on a wiki page is actually a link. I translated a page yesterday and there was 112 of them, there are many more pages to translate.

I am currently translating a wiki using a Translation memory tool (OmegaT), a typical segment will look like this : * [[TV Card|TV Card]] - Configure a TV card What I would like to do is create a macro to replace all strings starting with * [[ and ending with ]] - by a generated value and generate a document with the correspondance So my work document will look like this !100! Configure a TV card and the correspondance document !100! * [[TV Card|TV Card]] - !101! *[[sound Device|Sound Device]] - etc Then once I am done translating do the opposite and replace the values with the corresponding strings. I used Autoit in the past to automate some tasks but I never looked into something so advanced (for me at least) So at this stage I'd just like to get some opinions on the doability and eventually some suggestions if you think there is a better way to do this. The purpose of this is to get better matches from the translation memory when comparing with alreday translated text. "!100! Configure a TV card" will be a 60% match to "!101! Configure a Sound card" Where "*[[TV Card|TV Card]] - Configure a TV card" will only be a 37.5% match "*[[sound Device|Sound device]] - Configure a Sound card"

Thanks LxP I was wondering about this as well.

Thanks a million Randall, I really appreciate your help. --- Now for something completely different Still in devtrack I am using a script to close bugs, a few comboxbox to select from, some Edit fields, etc One of the Edit field is causing me some issue it seems to change number at each new session, so for example it's Edit 14 when I make the script but the on the next day it's Edit13. Is there a way to detect it's ID?

oh okay I will try that tomorrow it's getting late for me. Thanks Randall

I get an error I removed all that was before the first func and pasted this instead Global $FilePath,$var,$AddressExcel, $RowExcel $FilePath=@ScriptDir&"c:\list.xls" $ExcelValue1="A"&@TAB&"B"&@TAB&"C"&@TAB&"D"&@TAB&"E" $var=_ExcelCOM($FilePath,3,"A",2,"Into","Save",$ExcelValue1,1,0,0); Exit but when I launch I get a popup with $sFilePath= C:\Documents and Settings\Fabre\Desktopc:\list.xls OK

Randall I got ExcelUDF1_2.au3 running. And looked at the code, and this is way out of my league. if you are willing to provide me with a modified version where I can put the excel book path in the code (no prompt) and will then paste the text from a txt file in column A row 2 on a specific sheet, I will be most Gratefull. Otherwise I will just use simple mouseclick function. I am willing to learn but this is just to advance for me right now.

Sorry Randall I am having a really tough time understanding how this one works. There no mention of excelcom in the help file and I couldn't make much sense of it in different thread on the forum. Do you have any pointer that would help me understand how this on is working?

Thanks a million for the reminder Randall! The Export already tale care of making the tab separation, so content of the txt file is ready to be past in Excel. So I would need to select tab 3 and paste in column A row 2, what do I need to change in your script to do so? And do i have to copy the text from notepad, or can it be imported straight into excel?

Thanks again for your help Gary, you have been most helpfull. Actually trying the recorder is the first thing I did, It's okay but for a quick macro but I got better result wih maromaker, but it has it's limitation, even in macromaker I ended up doing the maco from scratch but the language used doesn't have 1/4 (maybe even less) of the power of Autoit. Even if it's more complex Autoit is much more enjoyable to work with, I really like that level of control you get on you macros. This bring me to my step 5 Cut and pasting into excel I couldn't find anything on the forum or helpfile on selecting a specific spreadheet by the tab. and the active window info is not reporting anything for that tab. it's not even in the visible or hidden text. Is this actually doable or do I have to resort to mouselick?

I have to do an export for the 3 different project I had hoped to be able to do one script for all 3, the box I need checked are the same but the list are different, I will do a script per project then. checked or not this would give the same result? ControlCommand("Replace","","Button2","Check", "") as $ret = ControlCommand("Replace","","Button2","IsChecked", "") If $ret = 0 then ControlClick ( "Replace", "", "Button2") EndIf So if I want to have Button2, Button3, Button4 checked is there a way to group them in one line or do I need to write a line per item?

Sorry I am not a native english speaker so I don't always search for the good terms, I had looked for ticked, boxes... Anyway so to make sure I don't untick that first box I should put it this way $ret = ControlCommand("Replace","","Button2","IsChecked", "") If $ret = 0 then ControlClick ( "Replace", "", "Button2") EndIf So with this I can make sure all the boxes I need are checked But how can I unchecked all the other boxes without specifying their Control ID?

Nope doesn't work, nevermind I don't need to cancel. So next step is unticking one box, I could do it this way. WinWaitActive("Untitled") WinMenuSelectItem("Untitled", "", "&Edit", "&Replace") WinWaitActive("Replace") ControlClick ( "Replace", "", "Button2") But on the next 4 screens there are list of items with tick boxes, all should be unticked except a few of them. Is there a way of knowing if a box is ticked or not?

Yes it should be but I was trying to test with cancel. But ControlClick("Save As", "&Help", "Button4") doesn't work Active window info in my previous post is for the cancel button

Realized the ControlSend ( "Save As", "FolderView", "&Save", "{ENTER}") was also not working properly So I following your change I tried ControlClick("Save As", "Save", "Button4") But it's not working... >>>>>>>>>>>> Window Details <<<<<<<<<<<<< Title: Save As Class: #32770 Size: X: 192 Y: 339 W: 563 H: 448 >>>>>>>>>>> Mouse Details <<<<<<<<<<< Screen: X: 702 Y: 730 Cursor ID: 2 >>>>>>>>>>> Pixel Color Under Mouse <<<<<<<<<<< RGB: Hex: 0x003A7A Dec: 14970 >>>>>>>>>>> Control Under Mouse <<<<<<<<<<< Size: X: 474 Y: 354 W: 75 H: 23 Control ID: 1038 ClassNameNN: Button4 Text: &Help Style: 0x48030000 ExStyle: 0x00000004 (Control is disabled) (Control is hidden) >>>>>>>>>>> Status Bar Text <<<<<<<<<<< >>>>>>>>>>> Visible Window Text <<<<<<<<<<< Save &in: My Documents FolderView File &name: test.txt test.txt Save as &type: Text Documents (*.txt) &Save Cancel &Encoding: ANSI >>>>>>>>>>> Hidden Window Text <<<<<<<<<<< Open as &read-only &Help