Inputting both English and Arabic text problem

[SedoSan]

I have a fairly big database at my company and we are using "Primavera P6" software to input the data however this software doesn't accept large data copy paste method so I created a simple autoit script that would enter the data one by one automatically to the software and it was working well with English only.

Now our company asked us to input the Arabic equivalent of the same cells so I managed to do it (only when inputting arabic). However when I try to input mass cells that contain both languages then I get "??????" when the system is trying to input arabic text!

I have in my code something like this:

Send("G-N2254")
sleep(300)
Send("{ENTER}")
sleep(100)
Send("{ESC}")
sleep(100)
Send("{Right}")
Send("ترانسكو")
Send("{ENTER}")

And depending on the keyboard layout that I have open then it will input the equivalent text, so if I have Arabic keyboard layout then only the arabic text will be input correctly and if I have English keyboard layout then only the English text will be input correctly.

How can I make it that both languages are going to be entered in their correct form?

[jchd]

That's to be expected: Send() sends simulated keystrokes, so what actually gets sent depends on the currently active keyboard layout.

Use ControlSend or ControlSetText instead. These functions directly send a Unicode string to the target control, independantly of the current keyboard and language settings.

[EmilyLove]

Additionally, you can send any glyph using send's asc codes. See the documentation and use Google to get the ascii code you need.

Edited May 29, 2016 by BetaLeaf

[SedoSan]

23 hours ago, jchd said:

That's to be expected: Send() sends simulated keystrokes, so what actually gets sent depends on the currently active keyboard layout.

Use ControlSend or ControlSetText instead. These functions directly send a Unicode string to the target control, independantly of the current keyboard and language settings.

I used

ControlSetText("Primavera P6 Professional R8.3 : (No current project)", "", "TCVirtualQueryGrid2", "شركة")

and

ControlSend("Primavera P6 Professional R8.3 : (No current project)", "", "TCVirtualQueryGrid2", "شركة")

ControlSend worked but it had exactly the same problem as "Send", it only work if keyboard layout is in Arabic, and fail to send English text when layout is in Arabic.

ControlSetText just didn't return anything at all. 

[AutoBert]

Try #RequireAdmin together with ControlSetText.

[SedoSan]

17 hours ago, AutoBert said:

Try #RequireAdmin together with ControlSetText.

Ah man... Thanks for the reply, I don't have admin rights at work and I don't think i'll ever get it...

I guess my best bet right now is bit manipulation changing ascii and inputting them letter by letter >.<

I wonder if there is any other solution