Forum Engagement Daily Reports

[system]

Daily Forum Report | 07 November 2024

Top 3 Topics with Most Views

Convert the data from excel to html made by @Kunal_Jain with 24 views.

I am getting this error on Apps made by @shubham.jadhav with 21 views.

Split Main DataTable and Create List of DataTable made by @SP_Bot with 18 views.

Top 3 Topics with Most Replies

Click on Active row made by @dutta.marina with 14 replies.

Orchestrator bot schedule made by @yashashwini2322 with 12 replies.

Convert the data from excel to html made by @Kunal_Jain with 10 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 20 posts!

@Anil_G made 17 posts!

@naveen.s made 12 posts!

Top 3 Most Liked Posts

This post made by @Manisha_Ravindra received 2 likes!

Change excel row color

@Nisha_K21 , You can use Set Range Color activity to change excel row color. Find row index rowIndex = dt.AsEnumerable().Select(Function(row, index) New With {row, index}).Where(Function(x) x.row(“ColumnName”).ToString = “SomeValue”).Select(Function(x) x.index + 2).FirstOrDefault() Use Set Range Color to Color the Specific Row: In the Set Range Color activity, use the following: Range: For example, if rowIndex is 5, set the range as “A” + rowIndex.ToString + “:Z” + rowIndex.ToString (repla…

This post made by @Anil_G received 2 likes!

Studiox type into activity

@A_Learner What error are you getting As @SorenB mentioned it can be one of the fix is visibility is an issue cheers

This post made by @ashokkarale received 2 likes!

It seems that UiPath Academy is being migrated to cloud. But I am not able to find the courses with link

@Gaurav_Malhotra, Old links will not work. Try navigating through the Courses or Learning Path [The image shows the UIPath Academy Learning Plans page, highlighting various automation learning courses such as Automation Developer Associate Training and Automation Business Analyst Associate Training. (Captioned by AI)]

Top 3 Most Liked Solutions

This solution provided by @Manisha_Ravindra received 2 likes!

Change excel row color

@Nisha_K21 , You can use Set Range Color activity to change excel row color. Find row index rowIndex = dt.AsEnumerable().Select(Function(row, index) New With {row, index}).Where(Function(x) x.row(“ColumnName”).ToString = “SomeValue”).Select(Function(x) x.index + 2).FirstOrDefault() Use Set Range Color to Color the Specific Row: In the Set Range Color activity, use the following: Range: For example, if rowIndex is 5, set the range as “A” + rowIndex.ToString + “:Z” + rowIndex.ToString (repla…

This solution provided by @Anil_G received 1 likes!

Click on Active row

@dutta.marina use <webctrl tag='DIV' tablecol='2' /> cheers

---

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.

[system]

Daily Forum Report | 08 November 2024

Top 3 Topics with Most Views

Compare Time column in two different excels and get matching data made by @Manaswini_UI with 22 views.

Folder Name changes after execution made by @Rafael_Carvalho with 21 views.

Update field values made by @dutta.marina with 19 views.

Top 3 Topics with Most Replies

Folder Name changes after execution made by @Rafael_Carvalho with 10 replies.

Community Editionでロボットアカウントが作成できません made by @masuo_ohara with 8 replies.

Microsoft Office365 Move Outlook Mail Message activiti made by @Gayathri_Mk with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 29 posts!

@ashokkarale made 17 posts!

@Yoichi made 8 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

DU Training Model

@Latifa Correct one would be c It is always advised to retrain on the base version with full dataset than incremental retraining Cheers

This post made by @Sanjay_Bhat received 2 likes!

Compare Time column in two different excels and get matching data

Here’s the Query dt_fitered = dt_Excel1.AsEnumerable.Where(Function(row,Index) DateTime.ParseExact(row(“Time”).ToString(),“h:mm tt”, System.Globalization.CultureInfo.InvariantCulture).ToString(“hh:mm”).Equals(dt_Excel2.Rows(Index)(“Time”).ToString(hh:mm)).CopyToDataTable Check this Out! Hope this helps!

This post made by @Josh_James received 1 likes!

Join AI Associate Developer Series 2024!

Hi @cristina.vidu - Thank you for the response. I put in a ticket with Academy, and they were able to help me get my progress up to date in the new Academy. Thanks!

Top 3 Most Liked Solutions

This solution provided by @Akash_Javalekar1 received 1 likes!

DU Training Model

Hi @Latifa I think C The major version remains the same, while the minor version can start from 0 since it represents a new iteration of the combined data. New model is fully trained with the combined dataset (1000+800 pages) and then evaluated using the 100-page evaluation dataset. This will your model will train with new dataset while running full pipeline

This solution provided by @ashokkarale received 1 likes!

It seems that UiPath Academy is being migrated to cloud. But I am not able to find the courses with link

@Gaurav_Malhotra, There could be chances that courses would have been updated, added or removed. You can check this with the support team here:

---

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.

[system]

Daily Forum Report | 09 November 2024

Top 3 Topics with Most Views

Best practices while scheduling Bot made by @SR_9128 with 9 views.

How much difficult actual exam vs practice exam made by @Harikishore_S with 8 views.

Save gmail file attachment not working made by @Abang_Jamuri_Abang_Shoker with 8 views.

Top 3 Topics with Most Replies

Use Excel File: Microsoft Office 2010 or newer is required made by @Adarsh_mamidi with 11 replies.

Need Sample 4 to 6 invoices for PDF made by @vineelag with 7 replies.

Fail to remove duplicates in Excel (error: 0x800A03EC) made by @yangyq10 with 5 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 20 posts!

@vineelag made 6 posts!

@pikorpa made 6 posts!

Top 3 Most Liked Posts

This post made by @Sunnik_Chatterjee received 1 likes!

I encountered an issue in UiPath’s AI Center on the Pro Trial version. After creating a project, the open-source ML packages section appears blank, showing only the 'UiPath' and 'Open Source' headers without listing any packages. I’ve tried refreshing, ch

I am using the Pro Trial version of UiPath and have created a project in the AI Center. However, when I try to access open-source ML packages, the section appears blank, showing only the header labeled ‘UiPath’ and ‘Open Source’ without any package options available

This post made by @Anil_G received 1 likes!

Update field values

@dutta.marina indicate whole row as one element and in innertext you will have the name you need …use variable in place of that and add in that selector as last line and use cheers

This post made by @jast1631 received 1 likes!

Use Excel File: Microsoft Office 2010 or newer is required

These are modern activities you can check excel package and see the pre requisition required Alternative approach you can use now is you can use workbook activities Try using that thanks @Adarsh_mamidi

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Update field values

@dutta.marina indicate whole row as one element and in innertext you will have the name you need …use variable in place of that and add in that selector as last line and use cheers

This solution provided by @lrtetala received 1 likes!

Fail to remove duplicates in Excel (error: 0x800A03EC)

Hi @yangyq10 Can you try the below [The image shows an automated process scope in an Excel file that removes duplicates based on the columns "Order Number" and "SO Line Item" from a specified table. (Captioned by AI)] [This image shows a UiPath workflow where the 'Remove Duplicates' activity is being configured, with the 'Range' argument not yet supplied, displaying the available Excel tables to select from. (Captioned by AI)] Input: [This image shows an Excel spreadsheet containing a li…

---

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.

[system]

Daily Forum Report | 10 November 2024

Top 3 Topics with Most Views

Regex to extract only top data from email body made by @Binod_Kumar_Biswal with 20 views.

Regex Command to get value after non specific symbol location made by @Abang_Jamuri_Abang_Shoker with 14 views.

Regex Flexible configuration how? made by @Abang_Jamuri_Abang_Shoker with 14 views.

Top 3 Topics with Most Replies

Getting a Person or Group type object to Update Sharepoint List made by @kengweechan with 8 replies.

Regex to extract only top data from email body made by @Binod_Kumar_Biswal with 7 replies.

メール本文にあるURLを開き(完了)、開いた先の情報を取得する方法 made by @once10201029 with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 12 posts!

@ashokkarale made 6 posts!

@kengweechan made 4 posts!

Top 3 Most Liked Posts

This post made by @Manisha_Ravindra received 2 likes!

Computer vision in Studio

@Nisha_K21 , Additionally you can refer this YouTube video as well ` https://www.youtube.com/watch?v=64ggPaQPEy4 `

This post made by @Yoichi received 1 likes!

Filtering by quarters of years in Excel

Hi, How about the following sample? [image] dictQuarter = New Dictionary(Of Int32,String)From{{1,"Q1"},{2,"Q1"},{3,"Q1"},{4,"Q2"},{5,"Q2"},{6,"Q2"},{7,"Q3"},{8,"Q3"},{9,"Q3"},{10,"Q4"},{11,"Q4"},{12,"Q4"}} dict = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(CDate(r("Date")).Year,dictQuarter( CDate(r("Date")).Month))).ToDictionary(Function(g) g.Key,Function(g) g.ToArray) Sample Sample20241110-1.zip (7.4 KB) note: please check result.xlsx Regards,

This post made by @Akash_Javalekar1 received 1 likes!

OOB ML Packages are missing. No option to select

I am Also facing the same issue no ml package available under out of box model. @ashokkarale thanks for sharing let me know if anyone has any resolution for this Thanks

Top 3 Most Liked Solutions

This solution provided by @Manisha_Ravindra received 2 likes!

Computer vision in Studio

@Nisha_K21 , Additionally you can refer this YouTube video as well ` https://www.youtube.com/watch?v=64ggPaQPEy4 `

This solution provided by @Yoichi received 1 likes!

Filtering by quarters of years in Excel

Hi, How about the following sample? [image] dictQuarter = New Dictionary(Of Int32,String)From{{1,"Q1"},{2,"Q1"},{3,"Q1"},{4,"Q2"},{5,"Q2"},{6,"Q2"},{7,"Q3"},{8,"Q3"},{9,"Q3"},{10,"Q4"},{11,"Q4"},{12,"Q4"}} dict = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(CDate(r("Date")).Year,dictQuarter( CDate(r("Date")).Month))).ToDictionary(Function(g) g.Key,Function(g) g.ToArray) Sample Sample20241110-1.zip (7.4 KB) note: please check result.xlsx Regards,

This solution provided by @lrtetala received 1 likes!

Regex Flexible configuration how?

Hi @Abang_Jamuri_Abang_Shoker Can you try the below (?<=(N|n)ame\s*:\s*)(.*) [The image shows a regex test platform where the regex pattern "/(?<=(Nn)ame*:*)(.*)/g" is matched against seven lines of text containing variations of the word "Name" followed by different values. (Captioned by AI)] 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.

[system]

Daily Forum Report | 11 November 2024

Top 3 Topics with Most Views

How to re-try failed queue item after specific time interval made by @vighneshgadekar with 28 views.

Is It Best Practice to Keep Config Files in UiPath Orchestrator Storage Buckets? made by @Basit_Xe with 21 views.

How to enter otp in a website which I receive in Gmail made by @Mozammil with 19 views.

Top 3 Topics with Most Replies

How can we split the cell values in excel? made by @naveen5 with 15 replies.

Outlook 365 Default Account made by @jpreziuso with 13 replies.

不要なワークフローを削除するとデバッグできない made by @ChikaA with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 27 posts!

@ashokkarale made 21 posts!

@Yoichi made 12 posts!

Top 3 Most Liked Posts

This post made by @Cosin received 2 likes!

Dev Dives: Leverage AI with Autopilot for Everyone & Clipboard AI

Hello, UiPath Community! Curious to explore more about the new Autopilot for Everyone™ and Clipboard AI™? Join us for the next Dev Dives session and find out more! I am Cosmin Voicu (Principal Product Manager @UiPath) and alongside Alina Capota (Sr. Manager, Technology Services @UiPath), we will show the newest AI-powered capabilities: Autopilot for Everyone™ and Clipboard AI™ We know the hype around AI can feel overwhelming, so in this session we’ll have an open and honest discussi…

This post made by @Phenyo received 2 likes!

3 Million Members and Counting: Advancing the Future of Automation Together

Supported, well said Ashok. The positive and engaging community is rich with knowledge but even more so the desire to relay this too all who are here. We have been gifted a supportive and collaborative environment. Salute!

This post made by @Phenyo received 2 likes!

3 Million Members and Counting: Advancing the Future of Automation Together

Congrats UiPath! Glad to be here, learning with you all and embracing the incredible Path which continues to help us advance and bring value to our clients and our individual pursuits.

Top 3 Most Liked Solutions

This solution provided by @Umadevi_Sanjeevi received 1 likes!

How to re-try failed queue item after specific time interval

Hi @vighneshgadekar , Then you can use Postpone Transaction Item activity to postpone that particular item to your wish time. [image] Thanks!

This solution provided by @ashokkarale received 1 likes!

OOB ML Packages are missing. No option to select

This has been fixed and packages are available now. [The image shows the "ML Packages" section of the UiPath AI Center, featuring both UiPath and open-source packages for document understanding, image analysis, language analysis, and language comprehension. (Captioned by AI)] Thank you team!

---

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.

[system]

Daily Forum Report | 12 November 2024

Top 3 Topics with Most Views

How to write the json data into excel into rows? made by @naveen5 with 38 views.

Selector Failure Issue made by @upasna_singla with 27 views.

Custom Activities cannot be installed because it depends on package 'System.Activities' made by @wang.yu with 26 views.

Top 3 Topics with Most Replies

How to write the json data into excel into rows? made by @naveen5 with 33 replies.

最初にマッチしたURLを取得する方法 made by @once10201029 with 24 replies.

Object reference not set to an instance of an object error in unattended session made by @jaswanthvarma.gottumukkal with 9 replies.

Top 3 Users Who Posted The Most

@naveen5 made 22 posts!

@ashokkarale made 18 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

パブリッシュ先のデフォルト選択をテナントにしたい

こんにちは バージョンにもよるかもしれませんが、これは正確ではないと思います。 デフォルトのフィードは、Studioの接続先フォルダに依存すると思いますので、こちらをテナントフィードを利用するフォルダを選択しておけば、テナントフィードがデフォルトのパブリッシュ先になると思います。（Studioの右下部分を確認ください） [image]

This post made by @adrian.ignat received 1 likes!

Custom Activities cannot be installed because it depends on package 'System.Activities'

Hello, When referencing the System.Activities package use PrivateAssets=“All” like this: <Reference Include="System.Activities.Metadata" Version="6.0.0-20220831.1" PrivateAssets="All"/> Let me know if this works. Thanks, Adrian

This post made by @Rohit_Radhakrishnan received 1 likes!

AI and Automation Unite : Join the UiPath HyperHack 2024 Challenge!

Hi Sarvendra, You can have multiple teams (each team with max 4 members) for any category.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

パブリッシュ先のデフォルト選択をテナントにしたい

こんにちは バージョンにもよるかもしれませんが、これは正確ではないと思います。 デフォルトのフィードは、Studioの接続先フォルダに依存すると思いますので、こちらをテナントフィードを利用するフォルダを選択しておけば、テナントフィードがデフォルトのパブリッシュ先になると思います。（Studioの右下部分を確認ください） [image]

This solution provided by @Binit_Sarkar received 1 likes!

How to assign pic1 Config to other in_Config as Value

Hi @shubham.jadhav If you are trying to assign the ‘in_Config’ value, directly open the ‘Expression Editor’ by clicking on the ‘+’ icon. Avoid clicking on the expandable icon. I hope this is what you meant. If not please elaborate on what you were asking. Thank You Happy Learning.

This solution provided by @ashokkarale received 1 likes!

LINQ query for update column

@JK_MECH, Ok use this one in Invoke Code. It’s tested. dt_AmountList = dt_AmountList.AsEnumerable().Select(Function(row) row("Type") = If(Convert.ToInt32(row("Age")) < 30, "Minor", row("Type")) Return row End Function).CopyToDataTable() Argument should be In/Out direction. [This image shows an Invoke Code activity's settings and arguments in a workflow, including code that filters a DataTable by age and type and its corresponding argument configuration. (Captioned by AI)] Output: …

---

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.

[system]

Daily Forum Report | 13 November 2024

Top 3 Topics with Most Views

How to indicate a column of a Data Table in the variable made by @mnurhaikal with 24 views.

I am unable to fix this error, Though my assistant is connected made by @shubham.jadhav with 22 views.

Not able to install uipath.database.activities made by @jain.priti26 with 17 views.

Top 3 Topics with Most Replies

Optimizing Queue Item Processing and Prioritization made by @logesh_kumar1 with 8 replies.

How to compare two excels data and find the matching rows and avoid seconds in time column made by @Manaswini_UI with 7 replies.

Configurar Gmail con Uipath con contraseña de aplicacion made by @RPA_Trgasa with 6 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 16 posts!

@Anil_G made 12 posts!

@Yoichi made 10 posts!

Top 3 Most Liked Posts

This post made by @emmamartin11233 received 4 likes!

Passed UiPath-ADPv1 Exam Last Night – Feeling Accomplished!

I’m thrilled to share that I successfully passed the UiPath-ADPv1 exam last night! I’ve been a silent follower of this community for a while, and I just want to say a huge thank you to everyone here for all the insights and tips – they were incredibly helpful. I took a prep course about a week ago and kept studying consistently afterward. Yesterday, I decided to go for it and booked the exam just a few hours before. For those interested, the practice exams were spot-on and really helped boost m…

This post made by @aqiffm received 1 likes!

Add new data column by combining other columns data using LINQ

I’ve tried the first method before! but i didnt add new data column bcs I assume the “.Expression” will add the new column for me. thank you!!

This post made by @Yoichi received 1 likes!

ExcelとUipathの連動について（Excelのリンクを一つ一つ開きたい）

こんにちは エラーの内容はファイル内部の不整合のように思えます。 取り急ぎは、それぞれのプロジェクトのアクティビティパッケージのバージョンを同一の最新安定版で統一してから、コピー等してみてはと思います。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

ExcelとUipathの連動について（Excelのリンクを一つ一つ開きたい）

こんにちは エラーの内容はファイル内部の不整合のように思えます。 取り急ぎは、それぞれのプロジェクトのアクティビティパッケージのバージョンを同一の最新安定版で統一してから、コピー等してみてはと思います。

This solution provided by @shubham.jadhav received 1 likes!

I am unable to fix this error, Though my assistant is connected

i tried it but still facing same error. but when I sign out almost 3 times then log in again it worked somehow.

This solution provided by @Yoichi received 1 likes!

SVNとは、プロジェクト依存関係一括更新ツールのこと？

違います。 構成管理システムのSubverisonのことです。 https://subversion.apache.org/

---

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.

[system]

Daily Forum Report | 14 November 2024

Top 3 Topics with Most Views

Avoid the popup made by @Yasir_Yaqoob with 20 views.

How to download automation with for each? made by @bayu.herlambang with 20 views.

Has the Get Assets activity changed? made by @martin.budnarowski with 18 views.

Top 3 Topics with Most Replies

Reply-to is empty but is filled in outlook made by @tomaz with 14 replies.

How to download automation with for each? made by @bayu.herlambang with 12 replies.

メールトリガを使いつつタイムスケジュールを設定する方法 made by @Junya_Koyama with 10 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 19 posts!

@Anil_G made 19 posts!

@Yoichi made 11 posts!

Top 3 Most Liked Posts

This post made by @tolga.kamci received 1 likes!

Send mail on maximum consecutive system exception reached

Hi @Shruthika_r In the Initialization State, you can see the default control about consecutive SE. You can add the mail activty there before Throw activity. [image] Regards.

This post made by @ashokkarale received 1 likes!

After migrating an existing project getting this error: "No Compatible version with windows project"

@harshavardhan3457, Remove these packages from your project and check where and which activity is using these packages. Try finding logic for that.

This post made by @Yoichi received 1 likes!

How to get cell value using numbers in Excel?

HI, Can you try to convert row index and column index to A1 style address, as the following? strAddress = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(c)+r.ToString() Then Excel.Sheet("Hoja1").Cell(strAddress) [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to get cell value using numbers in Excel?

HI, Can you try to convert row index and column index to A1 style address, as the following? strAddress = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(c)+r.ToString() Then Excel.Sheet("Hoja1").Cell(strAddress) [image] Regards,

This solution provided by @pikorpa received 1 likes!

Time trigger multiple processes

Hey @MT8888 The solution you came up with is definitely valid, and it’s a good way to consolidate the triggers by using a single one to manage multiple processes. Another approach you could consider is using multiple triggers - one for each process. This is the most straightforward option and keeps each process independent, which can be easier to manage in some scenarios, especially if you need more flexibility or need to adjust timings for individual processes later on. Another idea would be…

This solution provided by @Manisha_Ravindra received 1 likes!

Remove all duplicates rows based on a column

@Yugal_Raju Try this linq dtInput.AsEnumerable().GroupBy(Function(row)row(“Material”).ToString).Where(Function(g) g.Count() = 1).SelectMany(Function(g) g).CopyToDataTable()

---

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.

[system]

Daily Forum Report | 15 November 2024

Top 3 Topics with Most Views

Duplicate names\values made by @Jeeru_venkat_Rao with 16 views.

WindowsレガシプロジェクトをWindowsプロジェクトに変換するメリットデメリット made by @gorby with 14 views.

Excel is not saving while trying to run in Uipath made by @Vijayan_Sathyagiri_EXTERN with 14 views.

Top 3 Topics with Most Replies

Excel is not saving while trying to run in Uipath made by @Vijayan_Sathyagiri_EXTERN with 11 replies.

Cannot enter Excel data into an application made by @darpan.sharma with 6 replies.

Object Not set to instance error- trying to read excel file made by @Anelisa_Bolosha1 with 6 replies.

Top 3 Users Who Posted The Most

@Chaitanya_Doneparthi made 19 posts!

@Anil_G made 12 posts!

@ashokkarale made 11 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 2 likes!

Unable to use the same variable twice

@brixt.macharia, The error says you have a variable with same name already in the same scope. So instead of d declaring again, just use the variable. Remove Unused will remove any variable which is declared but not used in any activity or expression.

This post made by @Anil_G received 1 likes!

Making Custom Activities with Dependent Dll files

@edevries Please check this Hope this helps Cheers

This post made by @Chaitanya_Doneparthi received 1 likes!

How to decrypt the nugget package(library) to readable code in .net or Visual Studio (Readable code)?

Hey @Nitesh , To address your question about making a UiPath custom activity NuGet package compatible with the Windows version and accessing the underlying code, here’s a step-by-step guide: Important Note: NuGet packages are usually built from source code, but once compiled, they do not contain the original source code (like .cs files). Instead, they contain compiled DLLs. Thus, “decrypting” a NuGet package means extracting and decompiling the DLL files to view the source code. Step-by-Step …

Top 3 Most Liked Solutions

This solution provided by @edevries received 1 likes!

Making Custom Activities with Dependent Dll files

I solved this problem by using an Invoke Code activity. Before the core logic begins, I check if the PDFTronC.dll file is in the working directory. If it is not, I copy the file over from the Y Drive to the working directory. Upon completion or failure of the process I then delete this file to be safe. A janky solution to meet the jankiness of UiPath. string sourcePath = @"Y:\myFolderDirectory\PDFNetC.dll"; string destinationPath = Path.Combine(Environment.CurrentDirectory, "PDFNetC.dll"); i…

This solution provided by @Vijayan_Sathyagiri_EXTERN received 1 likes!

Excel is not saving while trying to run in Uipath

Found the solution Thankyou @ashokkarale in vba Code i disable the code line ws.open and ws.close Dont need to open the excel and close the excel

---

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.

[system]

Daily Forum Report | 16 November 2024

Top 3 Topics with Most Views

Find the difference in two excel files made by @Ryan_Lee with 18 views.

Invoke Process Behaves Strange made by @Jyothi31 with 13 views.

How to define the value of third column in config file made by @anjani_priya with 9 views.

Top 3 Topics with Most Replies

Loop through sub-folder by Reframework and Move pdf's to specific folder made by @Jeeru_venkat_Rao with 9 replies.

Form Extractor template mystery Error made by @Terry_Marr with 8 replies.

I cannot change the file name with rename file activity made by @ozgur.yukcan with 6 replies.

Top 3 Users Who Posted The Most

@Anil_G made 29 posts!

@Terry_Marr made 6 posts!

@Jeeru_venkat_Rao made 6 posts!

Top 3 Most Liked Posts

This post made by @sures400 received 1 likes!

Join AI Associate Developer Series 2024!

Yes Thanks. I"ve received the diploma of completion!!

This post made by @Anil_G received 1 likes!

Optimizing code for conditional "if" assignments

@Matias_Clemente.Arg is this what you are looking for…to make it less clutter [The image depicts a flowchart with nested conditional statements and variable assignments designed to handle different conditions based on the values of "str" and "flag" within a loop ranging from 1 to 20. (Captioned by AI)] this is else if activity cheers

This post made by @Anil_G received 1 likes!

Variable does not type in the email in SMTP mail

@cgs1 Welcome to the community Can you please log the recipentemail variable and show or show ehat value it is… Looks like the email format is wrong Cheers

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 1 likes!

How to Automate Phone Calls via Webex in UiPath?

Hey @FINNNNNNNN You’re right, the UiPath Integration Service is cloud-based. But you can use the HTTP Request activity in UiPath to directly interact with the Webex API. Even in an on-premises setup, as long as you have internet access, API calls are doable. Just set up the API key or OAuth manually.

This solution provided by @Anil_G received 1 likes!

How to define the value of third column in config file

@anjani_priya Ideally only two columns are read by default from the config If you need to get 3 red column values then read config file separately using read range and then filter the name column or first column or perform lookup on first column and get 3rd column value Cheers

This solution provided by @J0ska received 1 likes!

Optimizing code for conditional "if" assignments

This is the dark side of low code You could use coded workflow instead. Cheers

---

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.

[system]

Daily Forum Report | 17 November 2024

Top 3 Topics with Most Views

Main.xaml file takes too long to load made by @Cast with 16 views.

Open browser question made by @A_Learner with 14 views.

Extra attachment in mail automation made by @Sherrie1 with 10 views.

Top 3 Topics with Most Replies

Open browser question made by @A_Learner with 9 replies.

Uipath studio desktop licensing made by @Ragul_sharma with 6 replies.

Main.xaml file takes too long to load made by @Cast with 6 replies.

Top 3 Users Who Posted The Most

@Anil_G made 19 posts!

@A_Learner made 4 posts!

@Ragul_sharma made 3 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Open browser question

@A_Learner after opening use navigate or go to url from the second iteration to open in same browser alternately…you need not navigate also before loop use open and inside loop you need to only search by having all the browsers open cheers

This post made by @Anil_G received 1 likes!

Open browser question

@A_Learner Before loop keep all the different sits you need open in different browsers Inside loop based on the output variables from each browser attach and seaech for product and extract Cheers

This post made by @Anil_G received 1 likes!

Open browser question

@A_Learner Closing inside loop is not good In both options we either reload in same browser in first case And in second we directly reuse via search There is no closing inside loop The advantage is it reduces the turn around time of always closing and oepning Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Open browser question

@A_Learner after opening use navigate or go to url from the second iteration to open in same browser alternately…you need not navigate also before loop use open and inside loop you need to only search by having all the browsers open cheers

---

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.

[system]

Daily Forum Report | 18 November 2024

Top 3 Topics with Most Views

Uipath Data service request limit made by @Mikkel_Bank_Henriksen_MIK with 53 views.

Integration services not working in the new orchestrator update made by @Biswajeet_kumar with 30 views.

How to split the given date range month wise made by @Manaswini_UI with 20 views.

Top 3 Topics with Most Replies

Issue with robot send email not working made by @caris with 14 replies.

On prem to on prem orchestrator migration made by @gokul1904 with 13 replies.

Issue with attach window / screen issue made by @abhijeet.khairkar with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 36 posts!

@Anil_G made 22 posts!

@A_Learner made 9 posts!

Top 3 Most Liked Posts

This post made by @Biswajeet_kumar received 8 likes!

Integration services not working in the new orchestrator update

Hi @UiPath_Community @uipath I wanted to bring attention to an issue happening today. The UiPath Integration Services tab is not loading, causing all activities in Studio related to the Integration Service connector to stop functioning. Looking forward to a quick resolution to this issue. Thank you, Bishwajeet Kumar

This post made by @Mikkel_Bank_Henriksen_MIK received 3 likes!

Uipath Data service request limit

Hi! When running our framework, we utilize UiPath Dataservice, to get a process config , right now we get the following error message when trying to run anything using Dataservice: Get Entity Record By Id - Prod: Error: Resource ID : 1. The request limit for the database is 800 and has been reached. See ‘Resource management in Azure SQL Database - Azure SQL Database | Microsoft Learn’ for assistance., TraceId: 374495ba996941118dad2e8f16861d06 We don’t currently send a lot of requests to the s…

This post made by @jjes received 1 likes!

Uipath Data service request limit

You’re not alone. Data Service seems to be in problems right now. Just tried from a different tenant (with NO previous usage), and getting the same response. Cheers, Jeppe

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

WebサイトからPDFファイルをダウンロードして、直接Googleドライブにアップする方法

ブラウザを使用アクティビティのことでしょうか？ そうであれば一つのブラウザ使用アクティビティの中で、クリック→PDFダウンロード→Googleドライブにアップロードを繰り返せば良いように思えます。

This solution provided by @Yoichi received 1 likes!

BC30561 名前空間または型 'Microsoft.Office.Interrop.Excel,System' からインポートされた’Action’はあいまいです。

ダウングレードするのではなく、 １．新規でWindowsプロジェクトを作成 ２．アクティビティパッケージのバージョンを、上記のマイグレーションしたプロジェクトのそれと同じにする。 ３．マイグレーションしたワークフローをコピーペーストで、新しいプロジェクトに移植 のような感じで一度試してもらえればと思います。

This solution provided by @Anil_G received 1 likes!

Input options

@A_Learner If attended bot then input dialog or forms are the ways If unattended… if you use assets then for every product the same value would be used from start to end of process…basically create an asset and get the values If you need for each transaction or search then use create form task and create a action center task There are other ways as well which are more complex for the scenario Cheers

---

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.