Bulk Add Queue Items - How to push UTF-8 values?

[JenJen (Jennifer)]

Hey hey,

I have a question about queue items and its encoding. I am using an Excel table which is uploaded to orchestrator as bulk add queue items. Unfortunately UTF-8 related variables turn into chaotic ASCII char codes so the value itself is not readable anymore.

“straße” results in “stra\u00dfe 5” which is for sure not allowed.

Is there any possibility to solve this issue?
I already tried converting to CSV file and using the resulting DT for Bulk Add Queue Items - but same issue here

[Marcelo_Guimaraes (Marcelo Guimarães)]

Hi @JenJen!

Please check if you get your answer in this post:

Bulk Add Queue Items write nonenglish values

If the goal is to dynamically handle your input file, then that would be the way. I would say you will need one For Each activity that loops over dt.Columns, maybe one more IF statement in the loop to ignore columns that shouldn’t be handled and then Add Column activity. After setting the argument type of the For Each loop to a data table column you will be able extract the column name with something like item.name

Best Regards

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @JenJen and @Marcelo_Guimaraes ,

Here is the thread showing you how to fix this error.

[Solved] The trouble with the queues and non-ASCII characters - Build - UiPath Community Forum

We have used it since last 3 months, no issues.