Wednesday, April 18, 2018

Dot Net Core Preview Tool 3 Missing Issue with yeoman asp core generator with VS 2017 Sample Project

If you have installed VS 2017 RC previously and upgraded to VS 2017 Community version and when you are working with the sample which provided by yeoman asp core generator,you might see this error occurred,

Previously There was separate .NET Core SDK preview tool installation but now it is missing with their web sites.

To build the VS 2017 project with preview tool 3 you need to visit this url and download

.NET Core 1.0.0 SDK – Preview 3-004056

Saturday, April 14, 2018

Azure IoT Getting Started

Hello after a long time.. Today will have a quick post with Azure IoT.

Internet of Things going in Enterprise level and we have to get ready for the upcoming challenges in large scale. To prepare with it let's begin with Azure IoT.

In this article I am going to do the practice of simulating a IoT device and communicate with Azure IoT Hub (Uses MQTT Protocol).

First of all we need to have a Azure account created and enable a free tier subscription or if you already have a that's better.

1. Goto 

2. Search and create the IoT hub

3.It will take several minutes to complete the Azure IoT Hub creation.Once it compete you can navigate inside to it.You need to get some important names and keys from the overview section and  shared policies section.


Then select shared access policies and click on the iothubowner row inorder show the keys and connection strings.

Shared access policies

4.Next step is to integrate with the devices.To do that we have to simulate a device from the code. Here I am using a .net console applications to work as a device. You can download the given sample project from github or just run the command if you have git bash.

git clone

5.Once you get the clone you can open the solution in Visual Studio.There are 3 main console applications
       i.Create Device Identity - Add the simulated device to IoT Hub
       ii.Read Device to Cloud Messages - Read the messages sent from the IoT Hub
       iii.Simulated Device - Sending messages to the IoT Hub

Just add the all related parameters with correct values which are represented in IoT Hub.

6.Set the Create Device Identity project as startup and run it (Add the correct values for properties).

Once you run the application you will see a device key in the console.Note it down and add that key into the Simulated Device project program.cs DeviceId property.

Also check in the Azure portal, it will show up the added device.

Now it's time to get the messages from cloud and send the messages from the device.

Set the required properties as the correct values and run the project Read Device To Cloud Messages.

Sending a message to the device from the IoT Hub

You will receive the messages sent from the IoT hub you can see all the messages in the console.

7. Run Device to Cloud Console application and run a message from the IoT hub using Message to Device option.

8.Finally run the Simulated Device Console application to send the data to IoT hub.

You can see set of messges received from the azure portal IoT hub.

That's all for today with a quick go through .See you next time with an advanced article.

(References - Azure documentation for IoT Hub with .NET (

Wednesday, October 5, 2016

IBM Watson cloud with node Js

Today I'm going to expose you about the IBM Watson Developer cloud using IBM Bluemix cloud platform.

IBM Watson Developer Cloud.
Use language, vision, speech and data insight APIs to add cognitive functionality to your application or service.
(, 2016)

Bluemix is an open standards, cloud platform for building, running, and managing apps and services.
(, 2016)

In this post there will discussions on,
1. Speech to text
2.Text to speech
3.Tone analyser
4.Speech to tone analyser

First go to and sihnup for a free account and follow the instructions to proceed with the application development.Here I will be more discussing about the Speech to tone analyser.

1.Speech to text

There will be a application locally hosted using nodejs. Please follow the following git url and do the practicals as mentioned.

If you needs to have a look about how it works, please visit

2.Text to speech

Please follow the following git url and do the practicals as mentioned.

If you needs to have a look about how it works, please visit

3.Tone analyser

Please follow the following git url and do the practicals as mentioned.

4. Speech to tone analyser

Please follow the following git url and do the practicals as mentioned.

(When you creating tone anlyser service try standard instead of beta .Because this free plan will not give you access to create that beta service.)

Also make sure to change the manifest.yml file to change the service plan text.In my application I have changed it.So make sure to do the change in your application as well.,

In this phase you have to get the application credentials using the command "cf env <application-name>"

Then change the username and password according to it in vcap-local.json

Check manifest.yml file whether it is having the correct service names of the speech to text and tone analyser services.

So following these steps you can be able to to up and run a locally hosted application using node js.
If you need to deploy directly push it to the web, try "cf push" in the command prompt. 

Hope you got some idea about IBM cloud services.Cheers.

Sunday, September 18, 2016

Oracle installation and Migration to MS SQL Server

This is a short blog post about how you can involve in migrating a Oracle based database to SQL Server.

Firstly make sure you have the both latest versions of SQL Server and Oracle.

Oracle -

SQL Server -

Sometimes installing oracle may be a bit difficult task for you as beginner. So let see how to do it quickly .

First you run the setup and wait for the installation window

After a while you get the setup.So it is time to follow the steps ,
In the first view you can enter email and continue the setup

Then you have a selection of installations. Better to select the first option.

Then they ask you whether the configurations for the desktop environment or a server.Surely select the desktop class and continue it.

Then it is time to create a new user for the oracle database home user.So i recommend you to create a new windows user by selecting the second option.This enables a separate user to work with the oracle.

Then the configurations with settings the paths and global name.

Next is the installation process starts and after the setup completion you get the software installed.

If all the things are successfully completed , then type dbca in the command prompt to create a new database for oracle.Here you can manage the database instances as usually .

Let's create a new database

Next is the prerequisite checks

Then you get a summary before creating the database instance

Finally you are creating the database and ready for the migration .

After that you can insert data by creating the tables .So I will not going to do that, I will continue with the database migration tool.

If you need to manipulate the databases and tables you can download SQL Developer tool and continue the work.

There is a tool called SQL Server Migration Assistance for Oracle -

After the installation you get a icon like below

Open the software and you can see a interface as below

So next is the connecting both oracle and SQL Server to this migration tool by giving each servers credentials. You can do it by clicking Connect to oracle and connect to MSSQL Server buttons in left top corner.

After establishing the connection ,you can access to both databases at once and then select the database you need to migrate and click the button Migrate data or convert schema .You can select some option to be compatible with the data types and other fields information.

So that is the end of this short post and hope you will understand the instructions. Cheers .

Saturday, June 20, 2015

Internet of Things(IoT) and Arduino

හුග දවසකට පස්සෙ  අද ගවේෂක ඔයාලට අරන් ආව Electronic සම්බන්ද මේ දවස් වල ජනප්‍රිය #IoT හා සම්බන්ද දෙයක්.

Arduino ගැන අහල ඇතිනෙ කවුරුත් ඒත් දන්නෙ නැත්නම්  #IoT වලට Indtroduction එක්කින්ම පටන් ගන්නම්.

"The Internet of Things (IoT, sometimes Internet of Everything) is the network of physical objects or "things" embedded with electronics, software, sensors and connectivity to enable it to achieve greater value and service by exchanging data with the manufacturer, operator and/or other connected devices based on the infrastructure of International Telecommunication Union's Global Standards Initiative" - WIKI

සරලවම සිංහලෙන් කිව්වොත් electronic උපකරණ භාවිතයෙන් manual දේ automated කිරීමයි.
එමෙන්ම ඒ සදහා යොදාගන්න‍ා Hardware Platform කිහිපයක් නම් ,

  • Arduino

  • Raspberry Pi

  • Banana Pi

  • Intel Galileo

අද වනවිට බොහෝ ව්‍යාපාර IoT පිළිබද විශාල උනන්දුවක් දක්වනවා. 

උදාහරණයක් විදියට කාර්යාලයක කටයුතු ගත් විට බොහෝ සෙයින් එය ස්වයංක්‍රිය පද්ධතියක් බව‍ට පත් වී තිබෙනවා.

ඉහත රූපයේ පරිදි සියලු උපකරනණ එකිනෙක හා සම්බන්ධ වී තිබෙනවා. යම් විටක ගෑස් කාන්කදුවක්,භාහිර පුද්ගලයින් කාර්යාලයට ඇතුලුවීමක් වුවහොත් ඒ බව එසැනින් දැනුම් දීමක් සිදු කරනවා.

ඉතින් මේ වගේ සංකිර්ණ පද්ධති වල අඩිතාලම වෙන්නෙ කුඩා කුඩා circuit වල එකතුවකි. 

 ඒ නිස‍ා ගවේෂක අද Arduino use කරන විදිය මුල සිටම ඔයාලට අරන් එනවා .

අපිට මේ සදහා අවශ්‍යය උපකරණ,
  1. Arduino Borad(Nano/Mega/Uno)
  2. LED Bulb
  3. Resistor 1K
ඉන්පසු LED බල්බය Resistor සමග පහත පරිදි සකසාගන්න. 

(+) අග්‍රය Arduino Borad හි Pin 13 ටත්
(-) GND වෙතත් සම්බන්ද කරගන්න

දැන් USB ‍Cable මගින් Arduino Board එක පරිගනකය හා සම්බන්ද කරගනිමු.

ඉන්පසු Arduino Software එක Open කරගන්න
(To Download Arduino -

දැන් පහත පරිදි ඔබගේ නිවැරදි Arduino Board එක තෝරාගන්න

දැන් Sample Blink Program එක තෝරාගන්න

පහත පරිදි දැන් ඔබට දිස්වේ 

// the setup function runs once when you press reset or power the board
void setup() {
  // initialize digital pin 13 as an output.
  pinMode(13, OUTPUT);

// the loop function runs over and over again forever
void loop() {
  digitalWrite(13, HIGH);   // turn the LED on (HIGH is the voltage level)
  delay(1000);              // wait for a second
  digitalWrite(13, LOW);    // turn the LED off by making the voltage LOW
  delay(1000);              // wait for a second

දැන් ඔබේ program එක ,compile කර upload කරගන්න

ඔබ ඔබගේ .program එක Arduino Board එකට Upload කර ඇත. දැන් LED බල්බය Blink වන ආකාරය ඔබට දැක ගත හැකිය.

Saturday, February 21, 2015

Trigger an email after submitting Google Form

අද ඔයාලට ගවේෂක Google Forms and Triggers ගැන කියන්නයි යන්නෙ..

Event Registrations සදහා වර්තමානයේ ගොඩක්ම ජනප්‍රිය දෙයක් තමයි Google Forms කියන්නෙ. ඔයාල එහෙම Form එකක් submit කරාම ඔයාලගේ mail account එකට email එකක් ඇවිත් එහෙම ඇති නේද ?

ඉතින් අපි බලමු කොහොමද ඒ වැඩේ කරගන්නෙ කියල‍ා.

First you need to goto your google drive and create a form application.

Then give a suitable name for it and add your fields for the form . In this case i added only the email address to enter in the form.

Then goto Tools -> Script editor 

Choose blank project 

 Then add the follow code

var message, means the message you need to send for each registration.It can be manuslly added in your spread sheet.

Also we set a column for email status to check whether email confirmation has been sent or not

So to set the code to be run as a trigger goto Resources->Current Project's triggers

Add it as On Form submit then save it

Then goto your form and enter your email and submit.
After that you can see the following record is there and the email status is changed to "EMAIL_SENT".

Finally chheck your emails :)

I hope you will understand how it was done using triggers .So keep in touch with the explorer. We will meet on next Post .