Click here to Skip to main content
15,890,670 members
Everything / DevOps / Automation

Automation

automation

Great Reads

by raddevus
Steps for building a device you can add to your existing garage door, which implements an atmega328, bluetooth (hc-05) and relay module which will allow you to open your garage door from any paired Android device.
by Ben M Watson
Five more attributes of highly effective programmers
by Michael Haephrati
Now you can store your own voice recordings kept by Amazon but not made available to customers
by Adam Tibi
Exposing .NET functions to be consumed as Excel functions, otherwise known in Excel as "User Defined Functions" . Those .NET exposed functions can be easily used from Excel's cells. This article presents two ways to achieve this and the pros and cons of each.

Latest Articles

by Yevgeniy Shunevych
An introduction to Atata C#/.NET web UI test automation full-featured framework based on Selenium WebDriver
by Wessel Beulink
Azure spearheads cloud evolution, Azure Automation Runbooks manage hybrid/SOC environments effectively
by Suhagkumar Vamja
In this article, we learn about Playwright, how it works, and why it is a good choice for web automation with Java.
by Suhagkumar Vamja
In this article, we will learn how to set up Cypress and run the web automation tests (in series and parallel) on the LambdaTest cloud grid.

All Articles

Sort by Updated

Automation 

U 23 Apr 2024 by Yevgeniy Shunevych
An introduction to Atata C#/.NET web UI test automation full-featured framework based on Selenium WebDriver
14 Feb 2024 by Member 12505620
I am using c sharp language in the windows form. There are different options for each student in the same column in the database as shown in the picture. I want to mark the data I received according to the information in this column to the...
13 Feb 2024 by cmarcotte
I am not expert in C#, but in VB. But, with Word and Excel, you can use their macro recorders. You will need to modify your macro to to include interop objects in macro statements, but most part of the work will already be made with macro...
25 Jan 2024 by Wessel Beulink
Azure spearheads cloud evolution, Azure Automation Runbooks manage hybrid/SOC environments effectively
25 Nov 2023 by Member 13958707
Use @BeforeMethod annotation instead of @BeforeClass as @BeforeMethod invokes multiple times before execution of each test method and @BeforeClass annotation will run only once before starting all test cases. ...
25 Nov 2023 by Member 13958707
I have one utility class as DataManager.java where I have written a method to read data from an excel sheet. public static XSSFWorkbook xssfWorkbook; public static XSSFSheet xssfSheet; public static Object[][] readUserCredentials(String...
22 Nov 2023 by Suhagkumar Vamja
In this article, we learn about Playwright, how it works, and why it is a good choice for web automation with Java.
20 Nov 2023 by Suhagkumar Vamja
In this article, we will learn how to set up Cypress and run the web automation tests (in series and parallel) on the LambdaTest cloud grid.
16 Mar 2023 by Relmon
Hello I am a student and we are getting online lessons. Teachers provide us 6 digit number codes so we can enter them to a mobile application to check we are absence in the lesson. What I want to do is when a teacher or student writes 6 digit...
16 Mar 2023 by OriginalGriff
So let me see if I understand you ... your teachers want to be sure that you are actually present in a lesson and not sleeping at your computer or goofing off playing games when you should be learning, and you need our help to cheat the system so...
13 Feb 2023 by Member 14874302
I am trying to automate Oracle form Java Applet using Java Access Bridge through c#. I am able to get value from text field, click on buttons but setTextContents is not working. This is always giving false response only for Oracle form Java...
10 Feb 2023 by Kenji Elzerman
I know how to create and link a schedule via the Azure portal to an existing runbook. But now I want to add it via C# code. The runbook works and doesn't need any change. There is a parameter with the name "Id", which I can enter when using the...
10 Feb 2023 by Kostadin Terziev 2023
Look at this documentation AutomationRunbookCollection Class (Azure.ResourceManager.Automation) - Azure for .NET Developers | Microsoft Learn[^] It looks like there is CreateOrUpdate method in this AutomationRunbookCollection class. You can get...
22 Jan 2023 by Graeme_Grant
I think that this is what you are looking for: Job Schedule - Create - REST API (Azure Automation) | Microsoft Learn[^]
3 Jan 2023 by rsuki
Hi, I need to validate some reports that are printed to PDF . The Production floor says sometimes the data gets truncated or values gets printed elsewhere or full report is not displayed etc . Is there any way to validate this . I am working...
3 Jan 2023 by Member 15883921
Hi, I have the same problem to solve, is there any solution for this?
15 Nov 2022 by Manojkumar-dll
i have created a word automation project which working fine in local were as if i install in windows server its not working and shows failed due to class not registered and researched in internet that word automation will not work if MS Office...
15 Nov 2022 by CHill60
The documentation states (bold mine)Quote: All current versions of Microsoft Office were designed, tested, and configured to run as end-user products on a client workstation. They assume an interactive desktop and user profile. They do not...
3 Nov 2022 by RickZeeland
To get the week number you can use: Calendar.GetWeekOfYear() See: Calendar.GetWeekOfYear(DateTime, CalendarWeekRule, DayOfWeek) Method (System.Globalization) | Microsoft Learn[^] Here is some code from the CodeProject article Converting Numbers...
3 Nov 2022 by Manojkumar-dll
Hello everyone i have created a word automation and email sending project (Sorry for my poor english) which automatically put the values according to the variables i have placed but for each week i have to renmae it like...
12 Oct 2022 by Member 15796272
For this: @when('he enters search term "{text}"') def step_he_enters_searchterm(context,text): context.driver.find_element_by_id("cludoquery").send_keys(text) You need to write this: And he enters search term "rate" And if you get undefined...
12 Oct 2022 by Gerald McAuley
I writing a simple BDD script using Cucumber(Behave), python and selenium. The first two steps of my feature and script work but I having trouble getting a parameter from my Behave feature to my Python script. I keep getting this error when I runt the behave feature: You can implement step...
29 Aug 2022 by Shedronne Nicia
I am trying to connect to Veeam to automate the process of making a backup report of all the available system. But I cannot seem to find a way to connect to the Veeam API. Does anyone know how this can be done by using Python? What I have...
29 Aug 2022 by Sandeep Mewara
Seems they have quite a few examples shared to get you going here: GitHub - shapedthought/veeam-easy-connect: Makes Veeam APIs Easy![^] Also,handful of youtube videos by them:...
24 Aug 2022 by Manojkumar-dll
I'm having a report mailing project in that ,i have completed generation and sending mail to corresponding mail now i have to automate it to send itself every 7 days once at 00:00:00 IST the problem is with elastic in that data is fetching as...
24 Aug 2022 by Michael Hulthin
Not sure if I understood your question correct or not, but if you want to convert utc to ist. This works for me : var timeZone = TimeZoneInfo.FindSystemTimeZoneById("IST"); var utcNow = DateTime.UtcNow; // From 'elastic' in your case? var...
17 Aug 2022 by CCT TestPSQA
We presently use Automation Framework with MStest and Selenium C# POM framework for the e-commerce domain in our organization. Currently, organizations are moving toward an AB testing strategy for a few pages. Therefore, I am unsure of the...
4 Aug 2022 by 0x01AA
One can address a specific cell directly by row/column index. E.g. like firstTable.Rows[1].Cells[1].Range.Text = "My Value for that Cell"; Note: Keep in mind that for office interop the index of a collection starts at '1' and ends at...
4 Aug 2022 by Manojkumar-dll
I want to insert values into the cells of the table in my word file in c# using Microsoft interop and i have used foreach in the below code for dummy number that automatically insert as per the cell position i want to repace with it my own values...
4 Aug 2022 by Richard MacCutchan
You just need a set of data (an array or collection) that you want to put in the cells. So replace (cell.RowIndex - 3 + cell.ColumnIndex).ToString() with each item of your data.
2 Aug 2022 by Maciej Los
To create another table you have to call Tables.Add(Range, Int32, Int32, Object, Object) Method (Microsoft.Office.Interop.Word)[^] Assuming that you have a 9 paragraphs, you can insert into them 9 tables: //on the top of file using Word =...
2 Aug 2022 by Manojkumar-dll
I want to add 9 tables in my word file while try the below code it only adds rows instead of a table in my report automation how to do it What I have tried: private void CreateDocument() { try { ...
19 Jul 2022 by Member 15711665
I have a main function which runs with and without taking command line arguments. The given command goes to else logic and exits with value. But my query is, if user runs without command line argument then logic should not got to exit so can run...
27 May 2022 by Phoenix Liveon
How do we implement some buildTypes and flavors configs for our project(library or an application). I had a hard time finding tutorials or references about it, especially if it is implemented in kotlin-dsl. I tried to simulate the concepts from...
27 May 2022 by Rick York
I am not entirely clear on what you are asking but I'll take a shot. First, there are two kinds of libraries you can build - statically linked and dynamically lined. You define which kind(s) in the project settings of the library's solution. ...
13 Apr 2022 by T1xT
not all the pages; but some of them, specially those containing ads, take really long to be loaded while the elements that are going to be clicked are already usable. how to set selenium to click on the elements after 1-2 seconds regardless of if...
10 Apr 2022 by Scyasa
Goal: I'm trying to automate Canva.exe to create designs via GUI automation. Specs: Spyder V5 (via anaconda) and Python 3.8 on Windows 11 Home OS Problem: pywinauto is finding duplicate target values for the last 2 lines of my code (below) and...
1 Apr 2022 by T1xT
how to open a new tab in a new window that is opened in selenium firefox webdriver? What I have tried: the following code: public static void main(String[] args) { System.setProperty("webdriver.firefox.marionette", "some directory"); ...
1 Apr 2022 by Richard MacCutchan
driver.switchTo().window(tabs....
12 Mar 2022 by Mugiwara Luffy 2022
I am trying to create an HTTP request bot to automate simple web tasks in JS. Filling out a forum, adding a product to a cart, clicking a button, etc. Currently, I am using Axios and Cheerio to scrape information from the site, but I'm not sure...
12 Mar 2022 by Oliver Bleckmann
Axios and Cheerio are just http request and processing libraries. They DO NOT replace a full featured browser like puppeteer does. So, your first approach for 'pressing buttons' on a website was the right choice. Go back to puppeteer, maybe...
18 Feb 2022 by Zúñiga Almaraz Leonardo
Translation: How to implement in a lexical, syntactic and semantic analysis - automata ll with C # Good friends I am making a compiler and I have already advanced a large part but I lack these points and I do not know how to implement them,...
18 Feb 2022 by Maciej Los
I'd strongly suggest to read this MSDN article: Create a Language Compiler for the .NET Framework Using C# | Microsoft Docs[^]
17 Feb 2022 by OriginalGriff
While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for...
9 Jan 2022 by damien couesnon
Hello, My project is to create an automatic Word form generation which will be generated using software and which would render as follows: https://prnt.sc/26bj3ui For this, I had proposed a model which is: https://prnt.sc/26bj4pp ...
9 Jan 2022 by Richard MacCutchan
You can use VBA in a Word template to generate such a form. See word template vba - Google Search[^] for suggestions.
1 Jan 2022 by Jayant Tewarie
Hey much respected IT sisters and brothers, I have to send a daily mail with information from different listitems in Sharepoint to related team-members associated with these items. Is this possible? I have no Outlook365 account. Case 1: An...
1 Jan 2022 by g_p_l
Reading this page Solved: Sending Email through flow TO a NON 365 account - Power Platform Community[^] It appears the email notification (V3) action can do this, but there is a limit on the number of emails you can send in a 24hr period
4 Nov 2021 by User 15325224
I've been trying to use TestProject OpenSDK for Python to generate HTML test reports for my automated tests (with pytest), but I'm getting the following error: No module named 'src.testproject'. I've followed the directions laid out on the...
26 Oct 2021 by Richard MacCutchan
See https://developers.facebook.com/docs/whatsapp/[^]
13 Oct 2021 by User 15325224
I've been teaching myself Pytest (using Selenium web driver). All my test functions were in a single file, test_web.py: import time import pytest from selenium import webdriver from selenium.webdriver import Firefox from...
12 Aug 2021 by s_qa
Can anyone sense the cause of this error for the below code ? TypeError: Cannot read property 'close' of null 18 | 19 | afterAll(async () => { > 20 | await browser.close(); (Please don't mind the style, as a...
1 Aug 2021 by Code Fan
The standard solution today is to use Autocomplete | jQuery UI[^]. Your JavaScript skill seems good enough to handle this, because you're already using jQuery. Use standard UI tools. Never reinvent wheels. After you become proficient with jQuery...
25 Jul 2021 by André Marcos (Advisor), Luciano Santos de Jesus
Automation with Arduino Prototype for an Alarm Device based on Audiometric Sounds Pattern Control
24 Jul 2021 by Member 15299879
I am trying to automate some form filling. But i am having an issue with a field which is drop down with an autocomplete search bar. The drop down shows after completing 3 characters. https://i.stack.imgur.com/GniwI.png[^]
12 Jul 2021 by Nazim.Ali.90
My problem is that,i want to present my presentation on automata so that i need simple real life example, automata (Diagram) of that example and C# program on CFG - context free grammar. if you have so please kindly posted here i will very thanks full to you.Note: i need simple program...
17 Jun 2021 by PRASHANT MALIK 2021
I am looking for alternates of manual deployments in Windows servers. I have two types of applications and I follow the below manual steps which I want to automate. : 1. Window Services (written in C#) Backup the existing folders -- > Download...
26 May 2021 by 15160877
When I run my java application like this: import java.util.concurrent.TimeUnit; import org.openqa.selenium.By; import org.openqa.selenium.chrome.ChromeDriver; public class ChromeExample { public static void main(String[] args) { //Setting...
26 May 2021 by Richard MacCutchan
See How To Resolve Element Not Interactable Exception Selenium[^]
31 Mar 2021 by Frank Boucher
How to build a continuous integration and continuous deployment solution for Docker
2 Mar 2021 by jaideepsinh
I am trying to create an azure ci/cd pipeline for my python application. I have tried many ways but not get success. I can create CI successfully even in some cases cd also but not able to see the output on the azure app service. I use Linux app...
2 Mar 2021 by jaideepsinh
Solved by configuring the steps as mentiond in below post: flask - Azure devops for Python - Stack Overflow[^]
27 Feb 2021 by Stefan_Lang
In my excel worksheet I am using automation to insert formulas like this: worksheet.Cells[X_index][current_row_index].Formula = "=AC17+ABS(100*$Y$10* COS(((G17+J17+M17+Q17-180)*PI/180)))"; or worksheet.Cells[X_index][current_row_index].Formula =...
26 Feb 2021 by Maciej Los
As @embar.k.adero mentioned, when you use local names of functions (in your nativve language), you have to use FormulaLocal[^], but when you want general solution (no matter of regional settings), you have to use Formula with English names and...
24 Feb 2021 by W Balboos, GHB
OUtlook mail, and any other mail utility, is not a browser. They do not necessarily render all HTML, and more so, CSS. That being said, you also need to check browser settings to make sure the email was marked as HTML vs RTF vs plaintext. ...
24 Feb 2021 by Madhur Bakliwal
I tried to remove horizonal line from hr tag with below code.The same is working fine in Chrome,but not working in Outlook mail. What I have tried:
12 Feb 2021 by Maciej Los
In ASP.NET Core you're able to quickly change between development and production versions. See: Use multiple environments in ASP.NET Core | Microsoft Docs[^] When you work with WinForms, you're able to achieve something like that with project's...
11 Feb 2021 by Patrick Skelton
In the project I am working on, there are ten projects. Several of these have configuration files that have different versions depending on whether the software needs to run on my dev box or in the client's live environment. Note that this does...
10 Feb 2021 by Richard MacCutchan
Try Project Properties and Build Events. You can add simple cmd commands to the pre-Build or Post-Build box. The Macros button on the event dialog provides simple shortcuts to the different input and output locations of the project, or you can...
2 Feb 2021 by Member 13938502
I am trying to get only the Info from the log and Exclude all the Warnings can any one help me below is my Log4j property file What I have tried: log4j.rootLogger=INFO,CONSOLE,HTML // appender...
25 Jan 2021 by RishuMehra.Info
Hi Everyone,I've an Excel spreadsheet where so many URLs are mentioned by my client to edit them. So currently I go the each URL and open it manually in browser. Which takes up lot of my time and makes me sick of doing the same step again and again.Can someone please suggest me how to...
14 Dec 2020 by OriginalGriff
Talk to the API providers: they will know a lot more about their code than we will, and should be able to help you a lot quicker and more thoroughly.
4 Dec 2020 by Aniket945
I am writing a code in C/C++ with Win32API which Automates Chrome(I know there is Selenium and I used that but there is BOT detection available. Just forget about slenium).In my code There are extra features too ie.-If you have multiple Chrome...
2 Dec 2020 by Member 15010622
Hello, Sorry for the late answer. I had the same problem that you, so I developed a library to control directly the Remote app using the pywinauto library. Sorry, there is no doc or comments. Let me know if you have troubles. ...
28 Nov 2020 by Member 3615972
I want to automate two CAM nesting and cut applications by adding API funcionality and interact programmatically with them. One of them (named as software A and programmed in VB.NET) expose methods and properties through COM interface, and I've...
28 Nov 2020 by Member 3615972
I've finally giving up with C++ option. Below is parcial example on how I've made automatic nesting by pressing a button in a form of a C#.NET executable. Thus a CAM application with COM DLLs can be automated through an external executable.I...
25 Nov 2020 by Gerry Schmitz
Consuming Unmanaged DLL Functions | Microsoft Docs[^]
2 Aug 2020 by Amit Saini
Hello Everyone ,My motive is to control visual studio by voice commands by using microsoft speech services. I want to control visual studio from my another window form app in c#. I have a little bit success but there is some problem in SendKeys...
27 Jul 2020 by Member 14900256
Hello, I am trying to automate Imaging Edge Desktop using pyautogui. I was able to get this to work using the attached code( see What have you tried). The problem is I'd like to have this program control my camera autonomously without a...
27 Jul 2020 by Gerry Schmitz
E-Mail Delivery in Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Docs[^]
20 Apr 2020 by Iqra Ali
This article gives a practical overview of using GitHub Actions to automate a CI pipeline to build C++ project which is configured using CMake.
2 Mar 2020 by Haider Nafees
I have deployed Azure resources using ARM templates and linked it with WebHooks. Now I want to make a call of WebHook URL along with parameters using Postman. Can someone please let me know if there is a way to do it? What I have tried: I have...
2 Mar 2020 by Viswanatha Swamy
@HaiderNafees, Good morning. Looks like it should be possible. Could you please try with 1. Invoke-WebRequest, and then replicate with Postman. Could you please refer the below links. Starting an Azure Automation runbook with a webhook |...
21 Feb 2020 by Member 14196861
Hi, I have Automated the task till logging in External site. But after login, i need to perform some tasks like...selecting the menu options...clicking on Download links without any manual efforts.. Please Suggest me some code which detects the...
4 Jan 2020 by Member 13926859
hello every one i spend a lot of time creating manually a windows form application and class in visuel studio that contains connection . so i want to creat a script that i can run it with cmd that creates me a new project in visual studio with windows form and a calss . i don t know houw to...
4 Jan 2020 by Richard MacCutchan
You can easily create your own project templates in Visual Studio. See Project and item template parameters - Visual Studio | Microsoft Docs[^].
4 Jan 2020 by OriginalGriff
Try this: Adding your items to Visual Studio default files[^]
4 Jan 2020 by phil.o
Maybe that can give you a clue for starting: Extending Projects[^] Devenv command-line switches[^]
30 Dec 2019 by Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
5 Dec 2019 by RickZeeland
Maybe this will help: Using selenium, how to select a the text in a paragraph which is nested in a div element? - Stack Overflow[^] Or take a look at an alternative for Selenium like Zaptest: automation-testing-tools-for-a-medium-team-5-10-testers[^]
5 Dec 2019 by Member 10037347
I want to select a whole paragraph and then the selected text of this paragraph appears in a text area. I tried many solution but it selects from middle to the end or middle to the start of the paragraph. What I have tried: I have this paragraph: A paragraph is a self-contained unit of a...
14 Nov 2019 by OriginalGriff
No. Windows handles are a limited resource, and are allocated dynamically on demand when a window is created at run time, and recycled when the window is closed. In addition, an application does not have "one windows handle", it will commonly have many - at least one for each form, and for each...
14 Nov 2019 by isaketranjan
I need to somehow find the folder's window handle (e.g. Quote: hwnd=0x002C0F1A 64bit class="DirectUIHWND" style=0x56000000 ex=0x0 ) inside any folder e.g. DOWNLOADS folder, Please help me as i am stuck What I have tried: Cannot find the same using uiautomationclient dll.
7 Nov 2019 by Michael Haephrati
Now you can store your own voice recordings kept by Amazon but not made available to customers
6 Nov 2019 by isaketranjan
Trying to automate the IE's window which appears when any file gets downloaded, need to click on "Open with" option which is a part of SplitButton, Unable to find the "Open with" option as Child/Descendant of the window, Although rest of the...
6 Nov 2019 by OriginalGriff
You can't - you have no control over what the client browser does with the download: understandably, this is a security thing to prevent unwanted downloads being capable of automatically executing and installing malware.
9 Oct 2019 by 09hadi
For our day-to-day operations at the office we use Azure DevOps to keep track of the Scrum artifacts and the activities. Working in the UAT team, each member is assigned to a different scrum team and they show up on DevOps as such, but for reporting purposes, I have created a separate query to...
4 Sep 2019 by du lich
Hello friends. I have a problem that needs your advice. I am controlling a WPF application from another windows application through UI Automation. Now, I know how to click a button through UI automation, but lets say if I am clicking some dialog button manually in WPF application than how would...
4 Sep 2019 by RickZeeland
Maybe you can find something here: GitHub - TestStack/White: TestStack.White[^]
2 Sep 2019 by Thomas Daniels
To find the handle of the button, you can use FindWindowEx: FindWindowExA function (winuser.h) | Microsoft Docs[^] pinvoke.net: FindWindowEx (user32)[^] And then, if you want to listen for clicks on that button, you can use SetWindowsHookEx: SetWindowsHookExA function (winuser.h) | Microsoft...