topic RE: Cyrillic Characters not recognined in Product Forum

Cyrillic Characters not recognined

EduardoGS_Carva — Mon, 14 Sep 2020 20:00:00 GMT

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
------------------------------

RE: Cyrillic Characters not recognined

AndreyKudinov — Tue, 15 Sep 2020 07:33:00 GMT

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
------------------------------

RE: Cyrillic Characters not recognined

zdenek.kabatek — Tue, 15 Sep 2020 13:24:00 GMT

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
------------------------------

RE: Cyrillic Characters not recognined

EduardoGS_Carva — Tue, 15 Sep 2020 17:57:00 GMT

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
------------------------------

RE: Cyrillic Characters not recognined

EduardoGS_Carva — Tue, 15 Sep 2020 17:59:00 GMT

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
------------------------------

RE: Cyrillic Characters not recognined

zdenek.kabatek — Tue, 15 Sep 2020 21:02:00 GMT

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
------------------------------

RE: Cyrillic Characters not recognined

EduardoGS_Carva — Thu, 17 Sep 2020 12:35:00 GMT

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
------------------------------

RE: Cyrillic Characters not recognined

EduardoGS_Carva — Fri, 18 Sep 2020 19:03:00 GMT

Thank you so much, @Zdenek Halamik

It worked perfectly!

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

RE: Cyrillic Characters not recognined

zdenek.kabatek — Fri, 18 Sep 2020 19:38:00 GMT

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
------------------------------