Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 January 2023

Top 3 Topics with Most Views

Trouble adding Color Detector Package to Project Dependencies made by @beatorres2 with 52 views.

Filtering dates in Excel / CSV made by @Henson_Ibon with 45 views.

Excelに記載している日付表示を変更したい made by @miwa_yamamoto with 42 views.

Top 3 Topics with Most Replies

"Column name" is not set or is invalid ? Need help fixing this made by @Ryhan_Ahmed with 19 replies.

Excelに記載している日付表示を変更したい made by @miwa_yamamoto with 17 replies.

How NOT to change separator inside quotes made by @Matheus_Dallasta with 11 replies.

Top 3 Users Who Posted The Most

@Yoichi made 48 posts!

@Anil_G made 29 posts!

@ppr made 19 posts!

Top 3 Most Liked Posts

This post made by @Diana_Tufan received 3 likes!

UiPath products now available in Traditional Chinese!

We’re happy to announce that starting with this month almost all UiPath GA products support a new language - Traditional Chinese. The new language will be supported in all products via Automation Suite starting with 2023.4. We trust this language release will enable our users from Traditional Chinese speaking markets to navigate our products easier in their own language. Please refer to this page for a full product localization overview and don’t hesitate to get in touch vi…

This post made by @supermanPunch received 2 likes!

Datatable Manipulation To Converge Specific Rows of a Specific Column

@FilipeChiou , I believe this could be done by @Yoichi 's Implementation provided above, You would just require to perform the Operation of Deciding if it is OK or not OK inside the For Each Loop and then maybe use an If Condition and decide if it is OK or NOK using an Assign Activity. As the logic of Deciding OK or NOK is still not exposed to us, we could only maybe suggest you the approach. Let us know if you were not able to understand the above approach suggested.

This post made by @FilipeChiou received 2 likes!

Datatable Manipulation To Converge Specific Rows of a Specific Column

Hi @Yoichi, I would like to apoligize, I shouldve understood your reply and think about it further rather than respond immediately (I am a beginner in UiPath), yes you are absolutely right, I dont need to create an dt_aux since I can just put an if in the for each to run only on NULL rows. I am sorry for wasting your time, I should read and understood your reply more carefully. Lesson Learned Thank you @Yoichi and @supermanPunch for your time and help, its solved now!

Top 3 Most Liked Solutions

This solution provided by @Joe_Matuch received 2 likes!

Compilation Error in Process but not in Library: "Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. Please ensure that the workflow has been compiled."

Hi, everyone. This issue is most likely due to 1 or more package misalignments. Specifically, the library is using UiPath.System.Activities 22.4.5, but the process that is using that library is on 22.10.3. Furthermore, our Studio is version 22.4. Still working on confirming that this is the issue, but it is more likely than not the cause. Word for the wise: keep your versions aligned! UPDATE: Confirmed that having the 22.10.3 version in the process interf…

This solution provided by @Ranjit_Nayak1 received 2 likes!

Issue running bot after moving the project to a different system

After long time spent, found that issue was because of Check Activity, I have used this for radio buttons, check boxes. I have changed the activity based on version and this worked fine.

This solution provided by @Yoichi received 1 likes!

How do you read date from excel and compare?

Hi, It’s excel serial value. Can you try the following condition? [image] fecha_doc=DateTime.FromOADate(CDbl(fecha_SBS)).ToString("yyyy.MM.dd") Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.