Code Junction

How to convert CSV file to XML file using XSLT

2011-11-17T22:47:00.000+05:30

Whenever the source system is sending the data in the mode of .csv files then for transformation purpose if the target expects in xml format, the below mentioned technique can be used.

In the sample code attached with this post , xslt code is given where it take csv input('file:///d:/abc.csv') and converts it into xml format. This is generic xslt which can be used to convert csv to xml format.

To download the XSLT please click here.

How to Pass XML as a parameter to XSLT in TIBCO

2011-11-17T22:39:00.000+05:30

XSLT is extensively used in the areas where XML transformation is needed. Generally it is used to transfer one xml form to another. However if there are multiple XML’s and the output xml needs to be derived from the set of values in more than one xml’s then XSLT provides you the provision to pass the multiple XML’s as parameter to XSLT.

In this post we will take two XML’s and the output will be generated based on the values from both the XML.

Before implementing it in BW, in order to test in and debug properly let’s see how this can be done using any XSLT editor like Altova XML SPY. The two XML files used in the example are:-

Employee_Personal_Details.xml

Employee_Professional_Details.xml

The XSLT file ‘Transform_Editor.xslt’ is the XSLT used to transform the XML.

In order to do it in Tibco you will need a little modification in XSLT i.e. you need not to pass the parameter as ‘document’.

I have shared the sample BW code.

To download all the artifacts use in this post as a single zip file, click here.

How to Read a CSV file in Tibco BW having a Header, Body and trailer

2011-11-12T01:02:00.002+05:30

Tibco BW provides a ‘Data format’ in order to parse/render the text data. However the palette has a limitation that it can read the file only if file has a fixed sequence.

However in general the CSV file contains a Header section which has the basic information like file creation date/time, number of records etc. The actual data will be present in the section called “Body” and then the last section known as “trailer”.

In order to read such a file in Tibco a small trick is needed.

Please note that you need to create three different data formats one for each header, body and trailer.

I have included the sample file and the BW project in this post. Download the zip file and import the same into BW. Let me know if you have any doubts in the sample included.

Comments/Questions are welcome.

Click here to download sample

Connect to Oracle Queue using RAC URL in TIBCO BW

2011-09-29T22:13:00.003+05:30

Currently, Oracle AQ has not been fully certified with BW yet and TIBCO does not suggest its customers to use the JMS activities to interact with Oracle AQ.

However this can be implemented using JAVA Code activity in TIBCO BW. I am writing a sample code which can be used to connect to oracle queue. Please note that in below code I am using Oracle Thin drier to connect to database.

Before trying the below code following points must be noted:

1. The Code below is only meant for ‘JavaCode’ palette in TIBCO BW. In order to run the below code in other API, it will need a modification.

2. The java classes that need to be imported should be included along with the code by selection full class radio button present in the ‘code’ tab of palette.

3. The basic connection parameters like username, password etc is passed Global Variables.

4. Please note that If you are getting exception like “ClassNotFound” then you must place the jar file “apaqi.jar” in <>/bw/<>/lib folder.

5. The syntax of complete RAC URL(not appearing in screenshot) is:

RAC URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=testhost-vip)(PORT=1561))(ADDRESS=(PROTOCOL=TCP)(HOST=testbackuphost-vip)(PORT=1561)))(CONNECT_DATA=(SERVICE_NAME=oraclsid)))

6. Please refer to screenshot attached in this post in order to view the exact GV’s I have used in this.

Import java.util.*;

Import java.io.*;

Import javax.jms.*;

Import javax.jms.Queue;

Import oracle.jms.*;

Import oracle.jdbc.*;

Import oracle.jdbc.pool.OracleDataSource;

Import java.lang.Object.*;

Import java.lang.Class.*;

Import java.sql.Connection;

//Create Objects for the classes which are needed to create JMS connection

QueueConnection qconn = null;

QueueConnectionFactory qcfact = null;

Queue queue = null;

QueueSession qsess = null;

QueueSender sender = null;

TextMessage txtmsg;

//Creating Property to get User Name and Password.

Properties connection = new Properties();

connection.put("user",USER);

connection.put("password",PassWord);

//Get Queue Connection factory from Driver and Property initialized above.

qcfact = AQjmsFactory.getQueueConnectionFactory(Driver,connection);

qconn = qcfact.createQueueConnection(USER, PassWord);

//Creating Session and provide the acknowledgement mode

qsess = qconn.createQueueSession(true, Session.CLIENT_ACKNOWLEDGE);

qconn.start();

queue = ((AQjmsSession) qsess).getQueue(QueueUser, Destination_Queue);

// Publishing the message

sender = qsess.createSender(queue);

txtmsg = qsess.createTextMessage();

txtmsg.setJMSCorrelationID(CorrelationID);

txtmsg.setText(XML_DATA);

((AQjmsQueueSender)sender).send(queue,txtmsg);

qsess.commit();

output = "Succesfully placed the message on OracleAdvancedQueue";

// Cleaning up before exiting

qsess.close();

qconn.close();

Cheers,

Vivek

Why,how and what is rooting android?

2011-07-31T15:27:00.002+05:30

What is rooting?
In android each process runs under a seprate user identity and the privilege of root user has been restricted by platform but there are certain hacks using which one can achieve root access and process of gaining the root access is known as rooting. The basic process of rooting includes following steps

Remounting of /system with read/write access.
Copying the patched binary of su into /system/bin/.
Installation of superuser application (Available in market)

How to root my android?
There are many application using which you can root android but i prefer SuperClick utlitiy which is pretty simple and lets you root/unroot android. You can read more or download super click from http://forum.xda-developers.com/showthread.php?t=803682

Why do i require the to root access?
Root access is mostly require to do hacks like inserting module any external kernal module using insmod, accessing/modifcation of system files etc. A normal user never requires root access for performing basic operations.

Mounting windows share on android Froyo

2011-07-31T13:42:00.005+05:30

Recently i bought my first android based mobile (Samsung Galaxy Pro) and since then i was looking for something to access my windows shared folder via wifi. So i started exploring and found that on a rooted device it is possible to mount a window share using using cifs (Common Internet File Sharing Protocol) kernel module (cifs.ko) and mount command. I looked over net and found many builds of cifs.ko but didn't found a build for my kernel version 2.6.23.9-perf PREEMPT so i decided to build my own cifs. To make the kernel module i downloaded firmware source code from samsung's open source code distribution website https://opensource.samsung.com/. During the build i found that cifs module depends on slow-work and for that i build another module slow-work.ko and then i used terminal emulator to exeute mount command for inserting kernel modules and mounting the share.

         insmod /mnt/system/lib/slow-work.ko
         insmod /mnt/system/lib/cifs.ko
         mount -o username=,password= -t cifs anil-pc/d$ /mnt/cifs/d

and wollla now i can access any shared file from laptop on mobile via wifi like any other local file on mobile.

If you are not good at linux commands then you can download Cifs manager https://market.android.com/details?id=ws.plattner.cifsmanager&hl=en to do the same for you.

You can download my build of kernel modules here http://dl.dropbox.com/u/48560079/cifs_and_slow_work_modules_2.6.32.9-perf_PREEMPT.zip (Specific to kernel version: 2.6.23.9-perf PREEMPT, use uname -a command to find your kernel version or goto Settings>About phone>Kernel Version)

Move To Tray

2011-03-13T17:48:00.003+05:30

MoveToTray can move any program from taskbar to system notification area (beside the clock). Just press Ctrl+Alt+M (Move to tray shortcut key) and it will move the active application to the system tray. Once an application is moved to system tray it can be moved back to the taskbar by double click on the application icon in system tray.

Code to find WLAN MAC address of nokia mobile

2011-02-12T11:50:00.000+05:30

MAC address of WLAN device (i.e. wifi NIC) on nokia phones can be reterived using *#62209526# i.e *#MAC0WLAN# code

Installing and Uninstalling ASP.NET on IIS

2011-02-09T23:23:00.000+05:30

It often occurs that IIS ASP.NET get misconfigured or gets corrupted in such cases we can uninstall and reinstall asp.net on IIS using command prompt utilitiy aspnet_regiis.exe which comes with Microsoft Framework.
Below is the command install asp.net

C:\Windows\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis.exe -i

and to uninstall asp.net from IIS use

C:\Windows\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis.exe -u

Drive Locker

2011-02-08T22:57:00.003+05:30

Now you can hide and lock any drive on your windows OS. You can download the application from

Screen Shot

Reload Group policy using gpupdate and WM_SETTINGCHANGE

2011-02-06T20:18:00.000+05:30

When we change any of the group policy setting using registry then applications does not get notified about the change of policy and the effect take place only when the application gets restart or the user logs off and login again. To avoid restarting application and user logoff we have to notify all application about the change in group policy and so the application will reload the group policies. The applications can be notifiied about the change by using anyone of the below given approach

1. Using gpupdate.exe We can reload group policies by executing below command at command prompt.
gpupdate.exe /Force

2. Using WM_SETTINGCHANGE Message The group policies can be reloaded programatically by broadcasting WM_SETTINGCHANGE message using SendNotifyMessage. SendNotifyMessage take following paramters

hwnd: HWND_BROADCAST = 0xFFFF
msg: WM_SETTINGCHANGE = 0x001A
wParam: 0 when user group policies are applied and 1 when reload machie level group policies are applied.
lParam: pointer to string "Policy".

Here is an implmentation of same using C#.NET

[DllImport("user32.dll", SetLastError = true, CharSet = CharSet.Auto)]

static extern bool SendNotifyMessage(IntPtr hWnd, uint Msg, IntPtr wParam,

private void reloadPolicies()
{
   IntPtr hwnd = new IntPtr(0xFFFF);
   IntPtr wparam = new IntPtr(0);
   IntPtr lparam = Marshal.StringToHGlobalUni("Policy");
   SendNotifyMessage(hwnd, 0x1A, wparam, lparam);
   System.Threading.Thread.Sleep(1500);
   Marshal.FreeHGlobal(lparam);
}

C# .NET creating a IntPtr to a int

2011-02-06T12:56:00.001+05:30

A IntPtr to int can be simply created using a constructor of IntPtr.
Example: In many windows message queue API function we need to send a brodacast message to all top level window using hwnd = 0xFFFF and for such cases we can get the IntPtr to 0xFFFF using

IntPtr hwnd = new IntPtr(0xFFFF);

String To IntPtr

2011-01-26T13:56:00.001+05:30

Often we required to copy our managed string into unmanaged memory and gets it pointer to pass string's integer pointer (IntPtr) to the unmanaged api. To create a copy of managed string into unmanaged memory call one of the below given static method of Marshal class.

1. Marshal.StringToHGlobalAnsi : Creates the ANSI encoded unmanaged copy of the string.

public static IntPtr StringToHGlobalAnsi (string s)

E.g.
string str = "my string";
IntPtr ptrStr Marshal.StringToHGlobalAnsi(str);

2. Marshal.StringToHGlobalUni : Creates the Unicoded encoded unmanaged copy of the string.

public static IntPtr StringToHGlobalUni (string s)

E.g.
string str = "my string";
IntPtr ptrStr = Marshal.StringToHGlobalUni(str);

Releasing the unmanaged resources
The unamanaged resources are not disposed or released by the garbage collector so we must release the unmanaged resource after its use and to release our unmanaged string from memory we uses another static method Marshal class which is Marshal.FreeHGlobal

public static void FreeHGlobal (IntPtr hglobal)

E.g.
FreeHGlobal(ptrStr);

C#.NET Combinational mouse and Keyboard shortcuts

2011-01-26T11:52:00.000+05:30

Often it is required to implement combinational keyboard shortcut like shift+left Click or Shift+Right Click but we cannot implement them so easily in provided mouse and keyboard events like (mousedown, click, keydown, keypress or keyup) because in all these events one of the event information either Key events or mouse events are missing. So to implement such shortcut we can use Microsoft.VisualBasic.Device.KeyBoard class.

The same is discussed with example by me at eggheadcafe's FAQ section
http://www.eggheadcafe.com/sample-code/csharp.NET/d5c0ae86-2bd8-4abf-9c88-335779499169/net-keydown-events-like-shiftclick-or-altclick.aspx

Registry Trick: Keeping the Outlook 2002 in system tray instead of taskbar

2011-01-22T10:17:00.002+05:30

If you are using outlook 2002 and you want to keep the outlook in system tray like th outlook 2003 and above you have to addd registry value. Which will put the outlook in system tray when minimized.

Step1: Goto start>run type regedit and press enter

Step2: Browse to the below registry key
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook\Preferences

Step3: Modify or create the value MinToTray of DWORD datatype and set its value to 0 = Disabled or 1 = Enabled

Step4: Exit regedit and restart outlook.

Now on minimizing outlook it will move to system tray.

Registry Trick: Hide and lock any drive(s) using regedit

2011-01-21T23:26:00.001+05:30

You can hide any of drive(s) by just adding two keys in windows registry

goto start>run

Type regedit and press enter. This will bring you to the registry editor.To hide any drive you have to follow these 2 steps

STEP1: Hidding Drive
goto HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer now create a new DWORD value NoDrives and set its value as

2^(Alpha Number of Drive Letter-1)
where Alpha number are simple counting of alphabets from A to Z as 1 - 26

for example: to hide C drive
Alpha number of C is 3 so 2^(3-1) = 4 (decimal value)

If you want to hide more than one drive than calculate the value of each drive as explained and then set sum of those numbers as value

Step2: Prevent Access to the drive
Now as we have make our drive invissible but it is still accesible so to lock the drive we will create another DWORD value at

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer
create a new DWORD value NoViewOnDrive and set its value same as you have calculated for hidding the drive(s)

Now your drive is locked. If you want to unlock and unhidden the drive then just delete these two keys and your drive is again accessible. You can also create two .reg files one for hidding and locking and another one for unlocking and unhidding

javascript Date difference in days

2010-12-11T21:18:00.002+05:30

Many times it is required to compare two Date object and get the difference between the dates in days. Following javascript function will get you the difference in days

Date.getDaysDifference = function(fromDate,toDate)
{
   fromDate = new Date(fromDate.getFullYear(),fromDate.getMonth(),fromDate.getDate());
   toDate = new Date(toDate.getFullYear(),toDate.getMonth(),toDate.getDate());
   return ((toDate-fromDate)/86400000); //Total millisends in day =1000*60*60*24
}

Date.prototype.getDaysDifference = function(toDate)
{
   return Date.getDaysDifference(this,toDate);
}

Usage Example

var fromDate= new Date(2010,1,1);
var toDate= new Date(); //today's date
alert(Date.getDaysDifference(fromDate,toDate));
//or
alert(fromDate.getDaysDifference(toDate));

Registry Trick: Multiple instances of yahoo messenger

2010-11-20T00:05:00.001+05:30

Have you ever felt the need of using multiple yahoo messenger instance from the same machine? Yes, then here is the way to do it.

•Click start then run. Write regedit, press enter
•Goto "HKEY_CURRENT_USER\Software\Yahoo\Pager\Test"
•Create a DWORD registry value named "Plural" by right clicking the right hand side window.
•Double click the new DWORD entry and set the value to 1
Now you remain online with two or more different yahoo ids at the same time.

source: http://www.thinkdigit.com/forum/showthread.php?t=55350

Timeout Expired in SqlConnection.Open method

2010-11-17T15:43:00.001+05:30

Recently we encoutered a strange exception at SqlConnection.Open method in our application. The exception raised was

Exception Type: SqlException
Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Stack Trace: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()

The application task was to call a procedure on receiving data in a file which the application keeps on monitoring. After looking into the sql server logs and Activity monitor for the reason we came to know that there were too many opened connections. We thought that this could be the possible reason and we patched the application accordingly and closed all the Connection immediately after use but this doesn't worked and the exception was still occuring.

This brings us to conclude that there must be some problem with the server and thus we started googling and found the most possible reason that the IPSec is blocking the random port which SqlClient is picking up to connect to the server(see here). To fix this we changed the network protocol to be used by the sql client in the connection string. We used shared memory protocol because the application was running on server and it provide a better performance than any other protocol. Till now we have not received the exception yet and we hope it will not occur again.

MAC Spoofing

2010-11-14T14:07:00.000+05:30

What is MAC address?

Each and every network device in this world have a unique MAC (Medium access control) address. A MAC address is a 6 byte address which is often displayed in XX-XX-XX-XX-XX-XX where each X is a hex digit like 00-1D-2F-BE-BA-01 or AE-01-AE-29-BE-0F.

In windows we can get the mac address by using ipconfig /all command or using getmac command. These commands will return you the mac address each NIC (network interface card) connected to the computer. E.g.

What is MAC Spoofing?

Changing of MAC address for making a node (computer or any device) get the identity of other node(desiguse) in the network is know as MAC spoofing. By changing the MAC address we spoof the network routing device like switch and router. Many switch and router provides a interface using which administrator can restrict the nodes in the network, typically called as MAC address filtering. Administrator can there define the MAC address of devices which are allowed to connect to the network and thus prevents conectivity of unidentified node to the network.

How to change a MAC address?

In windows we can change the MAC address using multiple ways.

Method1: Using network card configuration window. Goto Control Panel>Network Connections select the network right click on it select properties this will open up Network connection properties.
Now click on the configuration button this will open the NIC device (using which network is communicating) properties which can be also opened via device manager. Select the Advanced tab from the NIC device property window and select the "Network Address" from the property list and set its new value to any desired valid MAC address.

Javascript injections and Javascript debugging techniques.

2010-11-10T22:14:00.001+05:30

Javascript injection is a technique of executing javascript in already loaded page in a browser. JS injections are commonly used for executing XSS(cross side scripting), SQL injection, for bypassing client side validations and also for debugging javascript in webpages.
There are many approach by which we can execute a javascript injection, few of them are shown here

1. Query inside address bar (works in almost all brower): Like we write javascript statement in anchor href attribute which gets executed on click of anchor. In the same way we can put javascript in address bar and execute them.

E.g. Copy and paste below given line in address bar and press enter
javascript: alert("This is a simple js injection.");
we can also add a js function using js injection like
javascript: void(window.myfunc = function(){alert("This alert is shown via myfunc function.");}); func();

2. Using browser js debugger: Almost all modern browser have there debugger for the web developers. Like IE Developer Tools (which comes with IE8 and onwards), firebug in Mozilla, Dragonfly in Opera. These all tools have a javascipt console where we can write javascript and execute them. Using these tools we can even write multiline javascript.

C# like trim(),trimStart(),trimEnd() function in javascript

2009-11-17T21:13:00.001+05:30

String.prototype.trimStart=function(c)
{
c = c?c:' ';
var i=0;

for(;i
return this.substring(i);
}
String.prototype.trimEnd=function(c)
{
c = c?c:' ';
var i=this.length-1;
for(;i>=0 && this.charAt(i)==c;i--);
return this.substring(0,i+1);
}
String.prototype.trim=function(c)
{
return this.trimStart(c).trimEnd(c);
}
Example:
" anil soni ".trim()

Hide your information in Images

2007-01-15T15:11:00.001+05:30

Now every one here on internet want to hide there data like usernames and password etc. So here i am telling
you the method used by spies. Take any of your faourite Image(should be a jpeg file) for eg. myimage.jpeg now
put all your secret data in a text file and then archive this file with winzip, winrar any software. Now open command prompt and type
[code]copy /b myimge.jpeg+hidden.zip newfile.jpeg [Press enter][/code]
now this will create a new image file - newfile.jpeg if you will open this file you will see your favourite image but when you open this file in winzip or winrar then you will see your hidden files inside it. Extract those file and read
them.