Importing Multiple Placemarks at once

Arrange Place, Latitude and Longitude in an excel.

Then import it to Google Fusion Table

Go to the maps in the third tab

Download the content in kml format.

Open it in google map

Excel Table to One Coloumn

Press Alt+F11 to open the VBE

Press Control+R to view the Project Explorer

Sub MakeOneColumn()

    Dim vaCells As Variant
    Dim vOutput() As Variant
    Dim i As Long, j As Long
    Dim lRow As Long

    If TypeName(Selection) = "Range" Then
        If Selection.Count > 1 Then
            If Selection.Count <= Selection.Parent.Rows.Count Then
                vaCells = Selection.Value

                ReDim vOutput(1 To UBound(vaCells, 1) * UBound(vaCells, 2), 1 To 1)

                For j = LBound(vaCells, 2) To UBound(vaCells, 2)
                    For i = LBound(vaCells, 1) To UBound(vaCells, 1)
                        If Len(vaCells(i, j)) > 0 Then
                            lRow = lRow + 1
                            vOutput(lRow, 1) = vaCells(i, j)
                        End If
                    Next i
                Next j

                Selection.ClearContents
                Selection.Cells(1).Resize(lRow).Value = vOutput
            End If
        End If
    End If

End Sub

Changing Excel Column Data to Row

While I was dealing with some climate excel data (rainfall) it was recorded as follows,
2000 - Jan        10
2000 - Feb        16
2000 - Mar        1
2000 - Apr        14
2000 - May        19
2000 - Jun        12
But I wanted data in below format,

Jan        Feb         Mar        Apr        May         Jun  
10         16           1            14            19           12
So the steps are as follows,
Select the coloumn,
Select Copy
Right Click
Paste Spatial 
Select Value (in Paste) , and Transpose
Click OK

SAS plot graph

ata test1;
input xx yy;
cards;
1 2
3 4
5 6
;
proc plot;
plot xx*yy;
run;

SAS hellow world

data test1;
input xx yy;
cards;
1 2
3 4
5 6
;
proc print;
run;

How to speed up web site laoding time part 1

1. Do  not let browser to reside the images.Spend another 45 second on the image-> edit it from photo shop -> then upload
2. remove white space in the code -> better open the code in server it self and check it.
3. load fewer external objects. Do not embed youtube, slideshare in the home page
4. try to minimize java script conditions in the home page.

in Visual Studio how to make components relative to parent

Please follow the below steps to make the Visual Studio components relative to Parent. So when the client expand the windows form components are also adjusting. So very convenient.
1.Select a component.
2.Go the component properties.
3.Use Anchor button to make the component relative to the parent

How to Setup the BlackBerry 1.5 jde in Windows 7

1.Download the jre 1.5 or higher version and install it.
2.Run the BlackBerry_JDE_5.0.0.exe.
3.Go to the start menu and run the jde.
4.If it gives a message window in random time.
5.Run the jde as administrator.
6.If it gives an error message too follow the following steps.
7.Go to the msconfig.exe in start menu.
8.In Tools tab click on Change UAC Settings and click Launch button.
9.Set the motion button to never notify aand click ok.
10.Restart your computer.

Clear loaded projects in Simulator of Blackberry Java Plug in for Eclips

When there are many test blackberry projects loaded to the simulator we get confused. Specially when there are many versions in the same same project.
The best option is to clean your blackberry simulator.
The steps are as follows,
In the top menu go to projects ->
Blackberry ->
Clean Simulator
This make simulator clean and comfortable

Embed Ajax to windows applications

Currently we are doing technical analysis to www.cse.lk advisory and we wanted to present his the details in much attractive manner. So I found a good ajax graphs library and did a web based applications. But later I thought to present them in a windows format so that customer is very convenience on it. So I embed the html pages from visual studio web browser component in the "Common Controls" section. You have to drag the component and set the URL.

Sanetra Solutions on tripadvisor slideshow

Profile Photos Slideshow: Sanjurat’s trip to Colombo, Sri Lanka was created by TripAdvisor. See another Colombo slideshow. Create your own stunning free slideshow from your travel photos.

set default file when navigating to sub folder

I am used to develop joomla sites and host in CLOUDLINUX. So home directory by default redirect to index.php page. Recently I developed a pure HTML site. For testing purposes I used my CLOUD LINUX server. It can read index.html as the default folder file.
In this project customer gave his windows server. Surprisingly it did not read index.html page. But it identifies home.htm page. So I did little change in my structure to priorities home.htm.

Joomla 1.7 how to link to Articles : JCE is not working

I enjoyed JCE editor very much compared to TinyMC editor in Joomla. But joomla 1.7 does not support JCE. I was fed up. But I am catching up with small techniques

How to link to an Article in Joomla 1.7?
I used the basic Strategy. Hidden menu in Joomla to link to article.

• First I create a hidden menu and link all the required articles.
• Then in my main  article I link to those main items.

This sorted my issue. But this is not user friendly. 

FTP vs Cpanel : Softculous

my hosting service providing company provides both cpanel a FTP login details upload the web site. Lot of people prefer FTP compare to cpanel because you can instruct FTP tool to upload the site while you are sleeping
But there is a great advantages in cpael compare to FTP
We are not providing our serer details to ay thir party So it provides great security

But now I am using Softculous. So I do not want cpanel upload or ftp uploads I ca install joomla on the fly.
.

Embed youtube videos to joomla 1.7

When I use joonla 1.5 I was able to embed you tube videos for my web sites with out any issue. But Embedding you tube videos on joomla 1.7 was not straight forward. It requires few additional steps.
Step 01: In Joomla Administrator first go to article options. There under super user (for other required privileged)  set text filtering to "NO" . This is under text filtering section.
Step  02: Now navigate to plugin manager and select tinyMC. Under Basic Options -> Functionality set it to extended.
Step 03: Now in the required article click on insert/edit embeded media. Paste the you tube embed code in Source section.
FYI:
Joomla does not like youtube embeded code with iFrame. So make sure to get youtube old embeded code.

Time Series Terminology and Basics

Univariate Time Series
Multivariate Series
Component Series
Smoothing
Interpolating
Seasonality
Trend
Auto correlation
Negative Auto Correlation
Positive Auto Correlation

Sinhala Font on Joomla CMS based web site

Recently I completed a NGO web site. The main objectives of the web site was to eliminate gender inequality, reduce poverty and so on.The Non Government Organizations name is Gemi Sarana Kendraya The main consumers of the Sinhala rural area people. In order to facilitate them with a better Human Computer Interactions I localized the web site. However the adding Sinhala to web site was not a tedious task as previous. Early days we had to depend on Joomla Fish. Last year I localized www.gunner.lk web site using Joomla Fish extension. However I was able to add Sinlala to www.gemisaranakendraya.com web site using Unicode with out an issue.
You need to add below code to your site.
"iframe id="settdecoder" name="settdecoder" frameborder="0" style="margin:0; padding:0; height:0px; width:0px;" "
"iframe " script type="text/javascript" src="http://sett-decoder.appspot.com/SettUnicodeDecoder.js"" script"
Therefore, even if the client computer done not have Unicode this script eliminate that issue.

Minitab Statistical Software to Predict Sri Lanka Share Price

While fallowing Msc in Applied Statistics course at Post Graduate Institute of Science, University of Peradeniya I got the opportunity to come across the Minitab Statistical software. The Minitab is very user friendly compared to R and SAS.

Also very recently I completed the Raja Senanayake the Economist and Stockbroker official web site : http://rmbsenanayake.com/

After completing his web site he wanted to me to do a Technical Analysis of Environmental Resource Investment Plc.