Cyrillic Characters not recognined

[EduardoGS_Carva]

Hello, guys,

Please, I get data from an Excel worksheet which might contain foreign characters.
However, it is not recognized by BluePrism when I paste that data in SAP.

I checked if BluePrism correctly reads the data from Excel, but I found out that the data collection or data item has "question marks" instead of the cyrillic characters. I have found no similar topic solution in Community Portal. How should I proceed to read foreign (cyrillic) characters?

Thank you very much in advance,

Regards,

------------------------------
Eduardo
------------------------------

[AndreyKudinov]

Cyrillic works fine with Blueprism. Question marks usually indicate that either you get data in wrong encoding or simply that font in blueprism can't display it for some reason.
Check if they are fine in excel.
Check if you can write them back to excel or any other simple app like notepad. If you can, then it is just a display issue, although we dont have such problems.
Otherwise there is some kind of encoding issues, how do you get that data from excel? Excel VBO or queries or something else?

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

[zdenek.kabatek]

Hi, Eduardo,

you need to open your Excel VBO on Initialise action and double click on big rectangle and go to the tab called Global Code. Search for 

Clipboard.GetDataObject().GetData(DataFormats.Text, True))

and replace it with

Clipboard.GetDataObject().GetData(DataFormats.UnicodeText, True))

That should solve it.

Regards,


------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

[EduardoGS_Carva]

Hello, Andrey, and thanks for your answer.

1) Are they fine in Excel? Yes, they appear fine.

2) How do you get that data from excel? Excel VBO, queries or something else?
I am using "BP MS Excel VBO"'s action "Get Worksheet Range as Collection" to get the data.

3) Can you write it back to notepad?
No, if write it back, only "???? ????" (question marks) ​are sent.
So, it is not only a display issue in BluePrism.

------------------------------
Eduardo
------------------------------

[EduardoGS_Carva]

Hello, ​Zdenek, and thanks for your reply.

Is there a way to apply this change specifically only to this call to the Excel VBO?
So it doesn't impact other Process that use this Excel VBO.

Thank you very much,

------------------------------
Eduardo
------------------------------

[zdenek.kabatek]

Hi, Eduardo,

see the screen shot - I duplicated the action Get Worksheet As Collection and called it Get Worksheet As Collection (Unicode). Then in the code stage I removed "Dim data As String = GetClipboardText()" and put this from the Initialise Action-Global Code. That should fulfill your requirement.

Dim data As String = Nothing
With New Threading.Thread(Sub() data = Clipboard.GetDataObject().GetData(DataFormats.UnicodeText, True))
.SetApartmentState(Threading.ApartmentState.STA)
.Start()
.Join()
End With

Regards,

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

[EduardoGS_Carva]

Thank you a lot for your help, @Zdenek Halamik​, I am checking with my team to implement this (internal security reasons, Excel VBO is a locked object here), but as I try it I'll update this answer.

Thanks again!
​

------------------------------
Eduardo
------------------------------

[EduardoGS_Carva]

​Thank you so much, @Zdenek Halamik

It worked perfectly!

​​

------------------------------
Eduardo
------------------------------

[zdenek.kabatek]

Hi, @EduardoGS_Carva,

I am glad it worked. Just to correct you - I am not Zdenek Halamik but Zdenek Kabatek ;).

Cheers,

Zdenek​

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------