How to import to data in TEXT to SQL Sever

Inserting large amount of data in text files (such as CSV files) to SQL server the easiest solution is using bulk insert. This considerably reduce the execution time and increase efficiency. Assumed Altitude provide a explanation on how to do the basic type of Bulk insert in this post.
The basic insert query would like this,

BULK INSERT TABLE1

FROM 'D:\test.txt'

WITH (FIELDTERMINATOR =',' , ROWTERMINATOR ='\n')

this Here the test.txt text file name and TABLE1 is where data is inserted. this just simplest form of bulk insert. This can be more complex tasks with the use of format files.

Merry Christmas

http://www.assumedaltitude.lkblog.com/2012/12/merry-christmas.html

Thambara Wila (තඹර විල)

The Student Union of Faculty of Engineering, University of Ruhuna consists of nearly 800 students. They are well talented in both academic and non-academic activities. In order to improve their talents engineering faculty Students Union has decided to organize a concert called ‘TAMBARA-WILA’ (තඹර විල) in 24th of June 2012 from 3.00 P.M. to 7.00 p.m. at the Medical Faculty Auditorium, Karapitiya.
The main objective of this concert is to present creative artistic talents of engineering undergraduates to the external parties and make close relationship with them.

How to Import data in Excel sheet to SQL Express Database using AD-HOC Query

Have you tried to get data in Excel sheet to a SQL database? Here is how to do it step by step so anyone can understand it simply. So there is no need to search anymore. This is done using AD HOC query in SQL. You can either import all the columns or selected one as you prefer.

Internship In WSO2

Romesh Malinga a CSE (Computer Science Engineering) student from University of Moratuwa is undergoing his internship in WSO2. He has started blogging about his experience gathered in this internship in wso2. Its under the URL www.iwso2.blogspot.com. This can be helpful to any one who is willing to have a internship in wso2 and anyone interested in technologies AXIS2, OSGi ect.

Electronic Switching

This a article on electronic switching that will act as short-note for students doing electronics. This is from Romesh Malinga Perera's blog Execution Cycle.
This include basic switch types and there graphical representation. Also there is a brief description about how electronic switch operates
Enter Here to see the Original article.

Temple Of Tooth (ශ්‍රි දළදා මාලිගාව)

This is Temple of tooth Relic (Sri Dhaladha Maaligawa-ශ්‍රි දළදා මාලිගාව) in Kandy Sri Lanka.

One of the main tourist attractions in Sri Lanka and the most scared place for all of Buddhists in the world. These images are from post in Assumed Altitude on Temple of tooth.

Sinhala hymns Free Download

Want to download Sinhala Christmas Hymns Go to 'Think Like Malinga'

There you can download lots of famous Sinhala hymns for free and without any waiting. They are all in mp3 format. These include hymns by famous singers like Latha Walpola, Rookantha Gunathilake.
Some of them are,
Sura Geeyai.
Seetha Sulan
Seenu Handin
Reyaka Andura Duru Wela
Raa Tharu Babalanawa
Bethleheme Ada Raa Upanna

Java Script Based Free Feed Module for Joomla

Most of free hosting does not support cross-domain requests. Existing JS feed manager is in very primary state. Web site owners that have hosted there sites on free hosing get affected by this. As an impact, you cannot use normal free module or improved feed manager “FeedGator”.  This is built for all web developers working with Joomla who have hosted their site in free hosing service and want to use the feed facility. Product is named as “JS Feeds for Joomla”.

                This allows feed support in more easy way using JS that gives more interactive feed module that is possible to use with free hosting unlike how it is normally done using CURL and PHP. This Product More attractive, easy to use, do not have to do any cording, gives nice outcome to your site.


To free download the module and more information on this project visit Execution Cycle by Romesh Malinga

A Windows 7 Theme for Month of May 2012 with Calendar

Hey everybody. I like to have the months calendar on my wallpaper. This theme give such wallpapers to you. So enjoy. Down load from here.

Theme pack for Month of May with Calendar Download

Installing Need for Speed World on partition other than System partition

By default you have, the NFS world game on your System drives Program data folder. But if you running low on disk space in C drive you can move them to another partition using Symbolic link

Moving Age of Empires Online Game to another partition from System Partition

Age of Empires Online game files (patch files) are downloaded to users AppData folder. That is “C:\Users\UserName\AppData\Local\Microsoft\Age of Empires Online” to be exact. But if you don’t have enough space o C drive you can move them to another partition where you have enough space. (About 5 GB of disk space)

You can use Symbolic link to do this. Follow the instructions below.

How to install Age of Empires Online to Different Partition than C

Age of Empires Game is initially downloaded, the Game and install it to the drive you specify. This will take about 20 MB of disk space. But when you run the launcher it will download the patch files of about 4 GB to C users AppData folder. They don’t offer any option to change this location.

The option is to use Symbolic link. Here is how to do it.

සුභ අලුත් අවුරුද්දක් වේවා !!!

සුභ අලුත් අවුරුද්දක් වේවා !!!

Real Time Reservoir Water Level Monitoring Using Ultrasonic Autonomous System

Sri Lanka is agriculture-based country from ancient times. There are more than 25000 reservoirs all around the country. Also large portion electricity generation is depend on hydro-power. The rain-water in monsoon seasons were gathered in tanks and used afterwards. There can be heavy rains in these areas so there is risk of overflowing. And the water must be preserved in the dry season.
Therefore keeping track of water level of these reservoirs is important. Department of Irrigation use manual monitoring daily traveling to reservoirs. This is time and labor consuming task. So the water levels are measured only once per day. This means there need a better system to do the job.
The system introduced here is more efficient and accurate. This system automate the data gathering process and provide a centralized monitoring through web interface. There several advantages of this, you always have up-to-date data, collected data is preserved so they can be used for future use in finding patterns in reservoir water level changing,

Ultrasonic measuring device on the reservoir

This project was carried out as Undergraduate group project for Department of Electrical and Information Engineering, Faculty of engineering University of Ruhuna. Project consist two main parts. First one is data collecting and sending to central server. Second part was developing the monitoring interface.
PIC Micro-controller based devise is connected above the water surface and using ultrasonic sensor data was collected. Then the water level was calculated. Then a text messages was generated and send as SMS via a GSM modem.
In the central sever data in the SMS was extracted and stored in a Database. The web site provide ability view the water levels in graphical interface for better understanding. This also provide historical water level data and other information from a password protected interface.

Monitoring Web Interface

This uses Google-maps java-scrip API to display the information on the map. Website was developed in ASP.NET using C#. XML is used to transfer the data. PIC was programmed in MicroC and the GSM modem is configured using AT commands.
Project Members:

1. Shan Perera
2. Kavindra Dilshan
3. Muditha Harshana
4. Tharangi Ireshika

Supervised by:

1. Dr. Cyril Kariawasam
2. Dr. Jayasundara

For more information on how each technology is used and the project report please refer these two articles on Assumed Altitude under Lankan Blogger.

Article 1
Article 2

Abbreviations in Movie Titles

Have you seen words like BRRip, DVDRip, DVDScr in movie titles? If you have downloaded a movie from the internet this is nothing new. So what does these mean? Do you want want to know them? I think it is important to know them.