Monthly Archives: September 2022

Power Automated Desktop (RPA) import csv to Excel

Posted on September 26, 2022 by chanmingman

This blog article shows you how to import the data from csv file to Excel. You can achieve what the VBA Read CSV to Excel is doing without write VBA code. I have a csv file like the one below. … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

CTO September 2022 articles and resources

Posted on September 25, 2022 by chanmingman

These are the good reads found in this month. Digital transformation: Top 5 skills you need to succeed 1. Digital fluency 2. Data analytics 3. Digital marketing… https://www.zdnet.com/article/digital-transformation-top-5-skills-you-need-to-succeed/ 4 reasons projects fail – and how to avoid them Workplace culture … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | Leave a comment

VBA Read CSV to Excel

Posted on September 25, 2022 by chanmingman

This blog article shows you how to read csv file into Excel using VBA. Below is the VBA code snippet that read the csv file to Excel (this article expects you to know how to go to the VBA code … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged | 1 Comment

PowerShell Delete Row from SQL Server

Posted on September 25, 2022 by chanmingman

This blog article shows you one of the ways to delete row(s) in SQL Server database table using PowerShell. Firstly, do not forget to install the SqlServer module for PowerShell. Install-Module -Name SqlServer -AllowClobber In this example, I am using … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

ML.NET Machine Learning Image Classification

Posted on September 19, 2022 by chanmingman

This blog article shows you how to use ML.NET to do Image Prediction. First, create a Console App. Click Next. Type in any Project name as you like then click Next. Select .NET 6.0 (Long-term support) and check the Do … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | Leave a comment

Power Automate Desktop (RPA) retrieve data from database

Posted on September 18, 2022 by chanmingman

This blog article shows you how to extract the data from SQL Server database and write to Excel Workbook. To simulate this flow, you need to have SQL Server installed with Northwind database and also Microsoft Excel. Start Power Automate … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, Microsoft Office, Office 365, Operating System | Tagged | Leave a comment

Robotic Process Automation (RPA) and Power Automate Desktop Learning Resources

Posted on September 17, 2022 by chanmingman

This blog article provides the learning resource for Power Automate Desktop (Unfortunately many of the features below need Premium license.). Automate processes with Robotic Process Automation and Power Automate for desktop https://docs.microsoft.com/en-us/training/paths/work-automation-flow/?WT.mc_id=DP-MVP-36769 Define input and output parameters in Power Automate … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, management, Microsoft Office, Office 365, Operating System | Tagged , | 1 Comment

SSIS Invalid time format

Posted on September 16, 2022 by chanmingman

This blog article shows you one of the ways to resolve the “Invalid time format” error. I have a following scenario. I want to run a SQL command using Execute SQL Task with parameter. I have a variable varPositionDate, the … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

PowerShell Create Array of Object

Posted on September 16, 2022 by chanmingman

This blog article shows you how to create object using PowerShell then put them in array. The code sample and explanation using the remark as below. #Declare the object $myObject = [PSCustomObject]@{     Name     = ‘Kevin’     Language = ‘PowerShell’     State    = ‘Texas’ … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, management, Operating System | Tagged | Leave a comment

ML.NET Machine Learning Data Classification with SQL Server

Posted on September 11, 2022 by chanmingman

This blog article shows you how to use ML.NET Data Classification with the data from SQL Server. 1. Create Console App. 2. Right click the project name, select Add, select Machine Learning Model. 3. Select Data classification. 4. I select … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | 1 Comment