Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 July 2024

Top 3 Topics with Most Views

エラーBC32042:'BarcodeRrader(Of T)'の型引数が少なすぎます の解消方法について教えてほしい made by @Tatsuya.d with 15 views.

Get week periods based on two data table columns dates made by @Sathish_Kumar_S with 15 views.

Move multiple files to designated folders made by @flashdrive07 with 14 views.

Top 3 Topics with Most Replies

Need to fetch only the Numbers from paragraph made by @sruthesanju with 18 replies.

Can't kill excel process made by @yangyq10 with 12 replies.

Move multiple files to designated folders made by @flashdrive07 with 10 replies.

Top 3 Users Who Posted The Most

@mkankatala made 26 posts!

@ppr made 20 posts!

@sandyarpa767 made 14 posts!

Top 3 Most Liked Posts

This post made by @Chris_Krah received 2 likes!

More information about .local folder from Uipath Project

To answer your specific questions: As far as I can see, references.db contains references used by Studio for a good user experiences, e.g. hashes of files so that changes can be detected faster. If you delete it, then Studio should regenerate it upon opening the project. It’s a LiteDB, so you can look at it yourself e.g. with GitHub - mbdavid/LiteDB: LiteDB - A .NET NoSQL Document Store in a single data file. [image] CodedWorkflow.cs is the base class for coded workflows or coded test fil…

This post made by @tibyan.ralibi received 1 likes!

Up-to-date on the latest of the UiPath Platform? Check with our Quiz! Win your Badge!

[Tibyan Ralibi]

This post made by @Todd_Dickinson received 1 likes!

Select File/Folder Feature on UiPath Forum

Thank you Paul. This is the first time I have tried to contribute. Did you find that the OpenFileDialog.Filter Property value/examples can be found on the Learn.Microsoft.com website? I appreciate your help.

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Data Table sort some columns

We assume that Excel is read into a datatable - dtData For sorting we do have more options like Sort DataTable Activity LINQ: Assign Activity: dtSorted = (From d in dtData.AsEnumerable Let s = d("Name").toString.Trim Let n = d("SID").toString.Trim Order by s, CInt(n) Select r = d).CopyToDataTable

This solution provided by @bavyaravu133 received 1 likes!

Data Extraction and Processing,,

@gantamohan502 -Use the Excel Application Scope activity to open the Excel file. -Use the Read Range activity to read the data into a DataTable. -Loop through each row in the DataTable using a For Each Row activity. -Within the loop, use the Send SMTP Mail Message activity (or the appropriate email activity based on the email service) to send personalized emails. Use the values from the DataTable to fill in the email content. -Handle exceptions and errors using Try Catch activities to ensur…

This solution provided by @bavyaravu133 received 1 likes!

Error Handling and Recovery?

@rajmoin136 -Use the Try Catch activity to handle exceptions within the specific part of the workflow where the error might occur. -Within the Catch block, use the Element Exists activity to check for the presence of the unexpected pop-up. -If the pop-up is detected, use the Click activity to close or dismiss the pop-up. -Optionally, log the error details using the Log Message activity for future analysis. -Implement a retry mechanism using the Retry Scope activity or by re-running the fail…

---

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.