Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 April 2024

Top 3 Topics with Most Views

Hi, I need to covert date to a particular format. Consider a string "06-23-3" which is in format MM-yyyy-dd . but the robo is reading the date as 23/06/2003 which is wrong made by @Aswin_Sutheesh17 with 58 views.

What is the cron expression for this? made by @mlellison with 49 views.

Specific JSON Schema violation made by @denisse.olsen with 47 views.

Top 3 Topics with Most Replies

Iterating dynamic Table made by @Gabriele_Radici with 14 replies.

RegEx and word document made by @mma with 13 replies.

Bulk item with unique ref made by @Hazem_Saleh with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 33 posts!

@Anil_G made 31 posts!

@Yoichi made 11 posts!

Top 3 Most Liked Posts

This post made by @Yomi_Oluwadara received 3 likes!

Help needed with writing new col Excel and DataTable manipulation

@Anil_G @lrtetala and @vrdabberu Thank you all for the insights. Appreciate it.

This post made by @AJ_Ask received 2 likes!

How to integrate GUI Python script to

You need to install For Windows projects, the Python Scope activity requires you to install the .NET Desktop Runtime 5.0.17

This post made by @ashokkarale received 2 likes!

Bulk item with unique ref

@Hazem_Saleh, Didn’t find exactly for bulk queue item but here is one as starter for you. Search for more you will get it or understanding this one you can do it yourself. [How to add a Queue Item through orchestrator API calls via postman - Part 9] Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

How to integrate GUI Python script to

@sesa499170, I don’t think you would require any other activities than Run Python Script for this. Here is my working sample for you to test. Python 3.12 [image] .Net Runtime 6.0.28 [image] Here is Python Scope configuration: [image] [image] Output: [image] Try this solution if it’s working or not. Main.xaml (7.5 KB) Thanks, Ashok

This solution provided by @mkankatala received 1 likes!

Hi, I need to covert date to a particular format. Consider a string "06-23-3" which is in format MM-yyyy-dd . but the robo is reading the date as 23/06/2003 which is wrong

I have made a small mistake in expression, check the below one… @Aswin_Sutheesh17 - Assign -> InputDate = "06-23-3" - Assign -> OutputDate = DateTime.Parseexact(InputDate.toString, "MM-yy-d", System.Globalization.Cultureinfo.InvariantCulture).toString("dd/MM/yyyy") Hope you understand!!

This solution provided by @avejr748 received 1 likes!

I can't able to fiter empty column

Do a for each row of your datatable then reassign all cells to themselves with trim. For example, inside for each row of datatable Currentrow(0) = Currentrow(0).ToString.Trim

---

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.