Foreign language characters

[Pyt]

Hello everyone,

I have a problem with my keyboard being danish. This means that certain characters have been moved to different positions and for some reason Automation Anywhere looks at my keyboard as being english.

This means when I try to enter the caracters : or \ or æ,ø,å (danish characters) it inputs the wrong characters.

What can I do to make it input the right characters? I've tried to have it input ascii commands (ALT+58 inputs but it doesn't seem to work.

--Update:
I just found out that I cannot work with danish characters at all. I can't even copy&paste them anywhere.

Do anyone have any ideas? I've tried on Vista and XP both, just to check if it was Vista that had some strange language support. But nothing worked.

Thanks,

Jens Pytlich

[forumsupport]

Currently Automation Anywhere Record/Replay functionality works for all languages. So if you record a task with special Danish characters it will work fine.

One thing you can do is, copy paste the characters as part of the task. For e.g. if you want to type some danish characters in Microsoft Excel. Then have a notepad or word open with your danish characters already written and in the task , perform a copy operation using Ctrl + C and then paste it (Ctrl + V) in your target application i.e. Excel.

Hope that helps.

[marcgallant]

I am getting data from a database and some of the characters are french (é, É, ô, etc.). When AA encounters these values, it simply ommits the letter. For example, I returned the value "réunion" but AA typed in "runion". I am using SQL Server 2000 as my DB. Any suggestions?

[forumsupport]

Hello,

Can you please try the following suggestion?

After you connect to database and execute the query, the result set of the SQL query is stored in the System Variable $Dataset Column$. Now, instead of retrieving data directly through $Dataset Column$, assign value of $Dataset Column$ to clipboard using ‘Assign to Clipboard’ command (under Clipboard command) and paste the value in required application using ‘Ctrl+v’ shortcut. The text format of commands would look something like this,

1) Connect to 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db.mdb;Persist Security Info=False'
2) Delay: (300 ms)
3) Execute SQL Statement: select * from TableName
4) Delay: (300 ms)
5) Start Loop " Each row in a SQL query dataset"
6) Assign value of variable "$Dataset Column(Index)$"to Clipboard
7) Delay: (300 ms)
8) Keystrokes: [CTRL DOWN]v[CTRL UP][ENTER] in "Untitled - Notepad"
9) Delay: (300 ms)
10) End Loop

Hope that helps.

[marcgallant]

That did work, but I would hope that this can be fixed as this would mean that whenever I retrieve data from the DB, I would have to send it to the clipboard before inputting it to screen. I have over 100 tasks so far and are creating more each week, and each one has probably on average 2 or 3 Select statements that i would have to modify.

Thank you for the work-around though.