Видео

In this video I demonstrate how to query data that is in a DataVerse table using PowerShell. This technique can be used to query, insert, or modify data in a table. So if you need to access data within your DataVerse table from a power automate desktop flow, or remotely in some fashion this can be used. Submit a request and have it featured on our RUclips Channel: www.aipsolutions.tech/videofea...

In this video, we use the OpenAI API key and make calls to ChatGPT using PowerShell. We feed in a serious of questions and multiple choice answers using a spreadsheet and write the answers supplied from ChatGPT to the spreadsheet. Please like and subscribe for more content. 00:00 | Intro 00:41 | Get API Key 01:13 | View Sample Data 01:38 | PowerShell Code 06:37 | Code Execution 06:58 | View Ans...

In this video I demonstrate how to curve and round picture corners using a quick and dirty method in Photopea. Photopea is a free online photo editing website. Thanks for watching.

In this video I demonstrate how to use AirTable API to pull data from Your AirTable and insert it into a PDF template document. Contact us at hello@aipsolutions.tech for your automation needs. Please like and subscribe. @AIPSolutions

In this video I demonstrate how to launch a PowerShell script, or any script really, at login for all users on a non-domain Windows 11 machine. @AIPSolutions

Don't do this, In this video I demonstrate how one would go about launching the active directory users and computers snap in, directly on a domain controller without having administrative rights. But don't do this. @AIPSolutions

In this video I demonstrate using Microsoft Graph API to Download Office 365 email attachments and overcome the 10 emails return limit. Spoiler: Not really a limit. I use PowerShell to invoke the API and go over the setup in the Azure Portal as well. Please Like, Comment and Subscribe to the Channel! @AIPSolutions

In this video I demonstrate how you can automate filling in a Microsoft Word Template with data read from a CSV File. We use Power Automate Desktop along with some PowerShell scripts. Please subscribe to the Channel Email us at hello@aipsolutions.tech for your automation needs. @AIPSolutions

Are you trying to add a .cer or a .crt file to IIS and it disappears? Did you add a PFX file and are getting a message that the password is incorrect? Use PowerShell in conjunction with Open SSL to do the conversion. Download OpenSSL here: slproweb.com/products/Win32OpenSSL.html Command: & "$openssl" pkcs12 -export -certpbe PBE-SHA1-3DES -keypbe PBE-SHA1-3DES -nomac -out $pfxFilePath -inkey $ke...

In this video I demonstrate how to compress the size of multiple PDF documents in a directory. I do this with PowerShell and GhostScript and achieve a 50% reduction without much loss in quality on the PDFs. Download GhostScript: ghostscript.com/releases/gsdnld.html GhostScript Parameters: $parm = " -q -dNOPAUSE -dBATCH -dSAFER -sDEVICE=pdfwrite -dCompatibilityLevel=1.4 -dPDFSETTINGS=/screen -dS...

In this video, we demonstrating writing a PowerShell script that backs up an SQL database and restores the database from a .bak file to a differently named database. 00:00 | Intro 02:05 | Backup Database 06:22 | Restore Database 11:52 | Outro @AIPSolutions

In this video, I configure a PowerShell Script that identifies if a service is running, if it isn't, it will start the service, capture windows logs, and then email those logs to a defined email address. This is a build upon the script in this video: ruclips.net/video/YqB6jehEIc0/видео.html&ab_channel=AIPITSolutions @AIPSolutions For more complex scripts, please reach out to us at aipsolutions....

In this video, I demonstrate how to import a csv file into a SQL Database server using Power Automate Desktop. hello@aipsolutions.tech @AIPSolutions

In this video I show you how you can schedule a power automate desktop flow with task scheduler without needing a premium account. aipsolutions.tech @AIPSolutions

Use Power Automate to Download documents from Hyper Links in your eMail Automatically

Automate FTP Transfers with Python

Power Automate Desktop: Connect To and Read Google Sheets, Parse the Data and action emails on Rows

PowerShell: Compare and Email Changes on Excel Files

Use Power Automate to upload files to One Drive through a web browser

PowerShell: Download Attachments from Email using the IMAP Protocol | Outlook not required!

Configure Textract to use Local Files with PowerShell

Automate Simple Excel Tasks with Python: From Password Protection to PDF creations

Merge PDF Documents and Rename based on Content using Power Automate Desktop

Power Automate Desktop: Launch Outlook, Download Email Attachments, Move email to subfolder

Setup Multiple Websites on Single AWS Server with different domain names

Automate Excel with PowerShell

Automate filling out PDF with data from Spreadsheet

PowerShell: Compare two excel files and highlight differences

PowerShell: Rename files in Directory based on Contents of File