Uhm, actually, I'm working on BI project, knew these tools for awhile, now having time, take a quick look, and found that it's very useful, worth to investigate and use it for your BI projects! Will 4share.net for a copy. Furthermore I will find its competitive tools
http://www.red-gate.com/products/
Showing posts with label To do. Show all posts
Showing posts with label To do. Show all posts
Sunday, January 15, 2012
Monday, June 1, 2009
Want to do
JRuby, IronPython, and WATSUP (Windows Application Test System by Using Python), doing research on stress/load testing for web (make million connections to web server)
Wednesday, March 25, 2009
Things to do, web to read for Automation Project
Windows Automation Snapin for PowerShell
http://wasp.codeplex.com/
PowerShell Remoting
http://powershellremoting.codeplex.com/
PowerShell wrapper functions for Log4net
http://log4posh.codeplex.com/
NSsh SSH Server
http://nssh.codeplex.com/
white
http://white.codeplex.com/
http://wasp.codeplex.com/
PowerShell Remoting
http://powershellremoting.codeplex.com/
PowerShell wrapper functions for Log4net
http://log4posh.codeplex.com/
NSsh SSH Server
http://nssh.codeplex.com/
white
http://white.codeplex.com/
Sunday, December 7, 2008
Books to read this months
There are 2 e-books (online), that is interesting ebook, i really love to read, but i don't have enough time, so i put it here just to keep track
The Tao Of Programming
http://www.canonical.org/~kragen/tao-of-programming.html
The Art of Unix Programming
http://www.faqs.org/docs/artu/
The Tao Of Programming
http://www.canonical.org/~kragen/tao-of-programming.html
The Art of Unix Programming
http://www.faqs.org/docs/artu/
Thursday, December 4, 2008
Ideas for this month, making google-map like for Hochiminh, Elearning for vietnam
Google map-like for hochiminh
http://www.yp.com.mo/map/
vietnamlearn.net (Vu Q Lam)
search google his name
http://www.yp.com.mo/map/
vietnamlearn.net (Vu Q Lam)
search google his name
Monday, November 17, 2008
A busy week, sad news, many stuffs need to be done
I had plan to do many stuffs, to document many tech. articles. But the sad news was coming, our client in US, they closed the contract after almost 4years with us, built up really strong relationship; because of US economy
I was so sad, my team as well, we was worked together, high dedication, the time we worked together, see people more than the time I was at home, anyway, we need to overcome this situation, and move forward. I do hope to have a chance to work with my client again in future
Squid, a web proxy, i had just completed in US lab, Remote Computer Management to track the resource consumption in Test Automation. Python, etc. "How to motivate team members", I did completed many stuffs and want to document it, but...
After almost 4 years working for client I had experience in Unix/Linux, DBMS as well, but unfortunately I haven't documented it yet, the project closed!
I was so sad, my team as well, we was worked together, high dedication, the time we worked together, see people more than the time I was at home, anyway, we need to overcome this situation, and move forward. I do hope to have a chance to work with my client again in future
Squid, a web proxy, i had just completed in US lab, Remote Computer Management to track the resource consumption in Test Automation. Python, etc. "How to motivate team members", I did completed many stuffs and want to document it, but...
After almost 4 years working for client I had experience in Unix/Linux, DBMS as well, but unfortunately I haven't documented it yet, the project closed!
Wednesday, October 1, 2008
web2.0 tools/utilities javascript components
http://extjs.com/products/extjs/
This looks good, and open source, any ideas to implement for your own web?
http://mashable.com/2007/07/31/facebook-powertools-1/
This looks good, and open source, any ideas to implement for your own web?
http://mashable.com/2007/07/31/facebook-powertools-1/
Monday, September 29, 2008
VirtualBox: another Virtualization host software, it is open source
I did many investigation on many virtualization software, and VMware is the best to me, at least up to now
VirtualBox, through the website, what it says is so impressive, and it is open-source as well
I will try to use it, and report the comparision later
http://virtualbox.org/wiki/Downloads
VirtualBox, through the website, what it says is so impressive, and it is open-source as well
I will try to use it, and report the comparision later
http://virtualbox.org/wiki/Downloads
Saturday, September 27, 2008
Using "Tag' to tag 'Human Resource Information', local filesystem
This is my idea, is there any software to allow us to help us manage Word documents, Excel, etc. pictures, jpg, then we can tag them, like: travel, cambodia, san diego, etc.
Then later on, we can find any related documents on our file system, base on those tag/keyword Does it seem like Google Desktop?
Another idea, we have a lot of Human Resource Resume, for each CV, they describe there skill sets in diffrent way, so it is little bit hard for us to search appropriate candidate, my idea is to attach their CV in an application, and tag their name with appropriate skill sets, then later on, I can query any candidates that has the required skill sets. Can be done by Google Desktop, Windows Search
OK!!!! GOOD, I will put Google Desktop to search my CV folders, Put Windows to run index service for CV folder, so I can approach any candidate easier
Then later on, we can find any related documents on our file system, base on those tag/keyword Does it seem like Google Desktop?
Another idea, we have a lot of Human Resource Resume, for each CV, they describe there skill sets in diffrent way, so it is little bit hard for us to search appropriate candidate, my idea is to attach their CV in an application, and tag their name with appropriate skill sets, then later on, I can query any candidates that has the required skill sets. Can be done by Google Desktop, Windows Search
OK!!!! GOOD, I will put Google Desktop to search my CV folders, Put Windows to run index service for CV folder, so I can approach any candidate easier
Some improvement for QTP in my project
I'm sorry, this is my brainstorming, not for publishing purpose
The most important idea: (as my experience in developing web crawler, apply artificial interllienge)
-If we use too much properties to identify an object, obviously, we assume that object identify will more accurately. But in some case, if the object in real life, sometime, miss some properties, our application cannot recognize the object (html object is rarely the same all the time). And this process is a result of training object identifier in a 'too large environment' where we have many object, and the application always try the best to unique the object (in test automation is a large set of test case that use the same object repository, and object in repository absolutely has many properties, and cause sometime it cannot recognize the object)
=> increase of number properties to identify object
Another case, if there are too much object has the same properties so to unique the object QTP will reject any duplicated properties, lead to
=> reduce number of properties to identify object. So QTP cannot identify any object (even in small environment)
==>This all is a result of training QTP in a large environment
-1/ too many object, window on the desktop at the time of training
-2/ you train QTP to recognize objects (then store in the same OBJECT REPOSITORY) but you train it many times, each time is of another Application (another test case)
-But, what if we use less properties to identify the object? In the small environment where there are several objects only, it is very easy to unique an object. But when we put the test in to large environment (where there are many test case that open many windows/object) the it will be very hard to unique an object
=> So, we are tester, developer, we understand much, which case will use which type of object. We can leverage dynamic object repository load functionality of QTP to:
1/ For each test case, we know exactly which object we would like to interact, so we can load exactly OR file of that object only. So if we have 2 more objects that similiar in different test cases, but we are testing 1 test case only, we can elimiate 1 remain test case,
2/ For each OR file, we will try to get as much unique properties as possible
Compose two above, we will have a good solution to avoid any duplicated object on the system by elimiate each OR / test case, interact objects/windows in sequence
3/ We need to get investigation, graph to balance, how many properties is good enough for our application to identify? for each test case if possible
1/ Separate our test case into small piece, to limit, and increase object identify performance, increase accurate
2/ Dynamic load object repository for each set of test case
- One more thing, there are some guys around the world, they use programatic to identify object, not relay on Object Repository anymore. That is perfect, so they how to identify their object clearly and to avoid any impact from the change of interface GUI , coding, what if developer, and sudently add some very funny properties into you object?
Ref: http://www.softwareinquisition.com/2006/04/new-object-repository-interface-in-quicktest-pro-9#comment-21844
Below is the detail:
-Dynamic load Object Repository, separate object repository by screen, test case, to increase performace, accurately identify
-In some case, update the object property in object repository to reflect the actually object that known by tester
-Try to understand and have good use of QTP Object properties
Objects Properties:
-Try to understand and have good use of QTP checkpoint functionalities
"
Mandatory Properties: Predefined sets of properties QuickTest learns for each test object.
Assistive Properties: Assistive properties are properties that QuickTest learns only if the mandatory properties are NOT sufficient to create a unique description.
Ordinal Identifier: The Ordinal Identifier assigns the object a numerical value that indicates its order relative to other objects for those have same values for all properties specified in the mandatory and Assistive property lists. This ordered value enables QuickTest to create a unique description when the mandatory and Assistive properties are not sufficient to do so.
SmartTesting @ January 28, 2008"
"
ISSUE: How to set a property value of an object in the Object Repository during runtime?
Issues, Quick Test Pro, Test Automation
Solution: We can modify the properties of the temporary version of the object during the run session without affecting the permanent values in the object repository by adding a SetTOProperty method. The SetTOProperty method can be inserted from the Keyword view using step generator or inserted to the expert view.
How?
The regular expression checkbox needs to be selected for the specified object .
Either through the Object Repository or through the Object Properties window, the regular expression checkbox needs to be selected before running the test.
To go through the Object Repository:
1. Select Resources -> Object Repository.
2. Select the object that will be used with the SetTOProperty method.
3. Select the property that will be used with the SetTOProperty method.
4. Select the “Edit Constant Value Options” button, which is to the right of the Constant field.
5. Select the “Regular expression” checkbox.
6. Click.
7. Click.
After modifying the setting, you can specify the regular expression using the SetTOProperty method.
Example:
Window(”Notepad”).WinEditor(”Edit”).SetTOProperty “text”, “test.*” "
The most important idea: (as my experience in developing web crawler, apply artificial interllienge)
-If we use too much properties to identify an object, obviously, we assume that object identify will more accurately. But in some case, if the object in real life, sometime, miss some properties, our application cannot recognize the object (html object is rarely the same all the time). And this process is a result of training object identifier in a 'too large environment' where we have many object, and the application always try the best to unique the object (in test automation is a large set of test case that use the same object repository, and object in repository absolutely has many properties, and cause sometime it cannot recognize the object)
=> increase of number properties to identify object
Another case, if there are too much object has the same properties so to unique the object QTP will reject any duplicated properties, lead to
=> reduce number of properties to identify object. So QTP cannot identify any object (even in small environment)
==>This all is a result of training QTP in a large environment
-1/ too many object, window on the desktop at the time of training
-2/ you train QTP to recognize objects (then store in the same OBJECT REPOSITORY) but you train it many times, each time is of another Application (another test case)
-But, what if we use less properties to identify the object? In the small environment where there are several objects only, it is very easy to unique an object. But when we put the test in to large environment (where there are many test case that open many windows/object) the it will be very hard to unique an object
=> So, we are tester, developer, we understand much, which case will use which type of object. We can leverage dynamic object repository load functionality of QTP to:
1/ For each test case, we know exactly which object we would like to interact, so we can load exactly OR file of that object only. So if we have 2 more objects that similiar in different test cases, but we are testing 1 test case only, we can elimiate 1 remain test case,
2/ For each OR file, we will try to get as much unique properties as possible
Compose two above, we will have a good solution to avoid any duplicated object on the system by elimiate each OR / test case, interact objects/windows in sequence
3/ We need to get investigation, graph to balance, how many properties is good enough for our application to identify? for each test case if possible
1/ Separate our test case into small piece, to limit, and increase object identify performance, increase accurate
2/ Dynamic load object repository for each set of test case
- One more thing, there are some guys around the world, they use programatic to identify object, not relay on Object Repository anymore. That is perfect, so they how to identify their object clearly and to avoid any impact from the change of interface GUI , coding, what if developer, and sudently add some very funny properties into you object?
Ref: http://www.softwareinquisition.com/2006/04/new-object-repository-interface-in-quicktest-pro-9#comment-21844
Below is the detail:
-Dynamic load Object Repository, separate object repository by screen, test case, to increase performace, accurately identify
-In some case, update the object property in object repository to reflect the actually object that known by tester
-Try to understand and have good use of QTP Object properties
Objects Properties:
-Try to understand and have good use of QTP checkpoint functionalities
"
Mandatory Properties: Predefined sets of properties QuickTest learns for each test object.
Assistive Properties: Assistive properties are properties that QuickTest learns only if the mandatory properties are NOT sufficient to create a unique description.
Ordinal Identifier: The Ordinal Identifier assigns the object a numerical value that indicates its order relative to other objects for those have same values for all properties specified in the mandatory and Assistive property lists. This ordered value enables QuickTest to create a unique description when the mandatory and Assistive properties are not sufficient to do so.
SmartTesting @ January 28, 2008"
"
ISSUE: How to set a property value of an object in the Object Repository during runtime?
Issues, Quick Test Pro, Test Automation
Solution: We can modify the properties of the temporary version of the object during the run session without affecting the permanent values in the object repository by adding a SetTOProperty method. The SetTOProperty method can be inserted from the Keyword view using step generator or inserted to the expert view.
How?
The regular expression checkbox needs to be selected for the specified object .
Either through the Object Repository or through the Object Properties window, the regular expression checkbox needs to be selected before running the test.
To go through the Object Repository:
1. Select Resources -> Object Repository.
2. Select the object that will be used with the SetTOProperty method.
3. Select the property that will be used with the SetTOProperty method.
4. Select the “Edit Constant Value Options” button, which is to the right of the Constant field.
5. Select the “Regular expression” checkbox.
6. Click
7. Click
After modifying the setting, you can specify the regular expression using the SetTOProperty method.
Example:
Window(”Notepad”).WinEditor(”Edit”).SetTOProperty “text”, “test.*”
QTP: dynamic load object repository
Thanks blogger for this information. I will apply it into my project, current Framework. So for each application/test case, window, it will has its own object repository, to increase accurately object identify, improve QTP performance during recognising object
Repository from the Script
Examples, Quick Test Pro, VB Scripts
Sometime there could be multiple object repositories in a test. It is possible the scripts or reusable actions browse through multiple application, and each apps has separate object repository. One of the problem with QTP8.2, we cannot associate multiple repositories at the same time. Here is a function that switches the repositories from the script.
###############################
‘Purpose: This function switches between desired object repositories
‘Example: Call Switch_ObjRepo(”C:\ObjectRepositories\”, “ApplicationRepGlb.tsr”)
‘###############################
Function Switch_ObjRepo (new_path, ObjRepo_name)
Dim qtApp, qtTestResources, fullpath
Set qtApp = CreateObject(”QuickTest.Application”) ‘ Create the Application object
Set qtTestResources = qtApp.Test.Settings.Resources
fullpath = new_path & ObjRepo_name
qtTestResources.ObjectRepositoryPath = fullpath
Set qtTestResources = Nothing
Set qtApp = Nothing
End Function
--------------------------------------------------------------------------------
Repository from the Script
Examples, Quick Test Pro, VB Scripts
Sometime there could be multiple object repositories in a test. It is possible the scripts or reusable actions browse through multiple application, and each apps has separate object repository. One of the problem with QTP8.2, we cannot associate multiple repositories at the same time. Here is a function that switches the repositories from the script.
###############################
‘Purpose: This function switches between desired object repositories
‘Example: Call Switch_ObjRepo(”C:\ObjectRepositories\”, “ApplicationRepGlb.tsr”)
‘###############################
Function Switch_ObjRepo (new_path, ObjRepo_name)
Dim qtApp, qtTestResources, fullpath
Set qtApp = CreateObject(”QuickTest.Application”) ‘ Create the Application object
Set qtTestResources = qtApp.Test.Settings.Resources
fullpath = new_path & ObjRepo_name
qtTestResources.ObjectRepositoryPath = fullpath
Set qtTestResources = Nothing
Set qtApp = Nothing
End Function
--------------------------------------------------------------------------------
QTP: Object identify: dynamic, descriptive, etc.
There are 3 ways to identify an object in QTP:
http://sqafront.com/2008/02/12/issueworking-with-dynamic-object-using-quick-test-professional-qtp/
"
Issue:Working with Dynamic Object using Quick Test Professional (QTP)
Issues, Quick Test Pro, Test Automation
There are several ways to work with dynamically generated object:
Using Regular Expression
Using alternative object property to uniquely identify the dynamic object
Descriptive programming
Use regular expressions for the dynamic property.
Open the Object Repository, and find the object from the left side of the Object repository window.
From the list of the properties, select the dynamic property.
Click the edit icon, which is next to the Constant edit field.
Check the ‘Regular expression’ checkbox.
Replace the dynamic portion of the string with wild cards (*) and Click “OK”.
Modify the Object Repository for the dynamic object to use different property to uniquely identify the object:
Open Object repository, and select the dynamic object
Click on the Add/Remove Button
Choose a different property to identify the object uniquely
Use descriptive programming which allows using object properties directly to the script.
Example:
Set BillingOptions = Description.Create
BillingOptions(”title “).Value =”\Billing Options.*”
BillingOptions(”creationtime”).Value =1
SmartTesting @ February 12, 2008
"
http://sqafront.com/2008/02/12/issueworking-with-dynamic-object-using-quick-test-professional-qtp/
"
Issue:Working with Dynamic Object using Quick Test Professional (QTP)
Issues, Quick Test Pro, Test Automation
There are several ways to work with dynamically generated object:
Using Regular Expression
Using alternative object property to uniquely identify the dynamic object
Descriptive programming
Use regular expressions for the dynamic property.
Open the Object Repository, and find the object from the left side of the Object repository window.
From the list of the properties, select the dynamic property.
Click the edit icon, which is next to the Constant edit field.
Check the ‘Regular expression’ checkbox.
Replace the dynamic portion of the string with wild cards (*) and Click “OK”.
Modify the Object Repository for the dynamic object to use different property to uniquely identify the object:
Open Object repository, and select the dynamic object
Click on the Add/Remove Button
Choose a different property to identify the object uniquely
Use descriptive programming which allows using object properties directly to the script.
Example:
Set BillingOptions = Description.Create
BillingOptions(”title “).Value =”\Billing Options.*”
BillingOptions(”creationtime”).Value =1
SmartTesting @ February 12, 2008
"
You want to follow someone, spy them, watch them? what they are doing?
Actually, I did many spy like this when I recruite some new engineer, they usually put their email, in CV, profile, and I did searched them on internet to see their activities, to see how good they are, their characteristic before doing interview
But now, instead of googling them, Ooops, actually, I did another way is to Yahoo Pipe :-)
http://twitter.com/help/how
And, what is it? I don't know!!
But now, instead of googling them, Ooops, actually, I did another way is to Yahoo Pipe :-)
http://twitter.com/help/how
And, what is it? I don't know!!
System tools for dev/tester/admin
This link helps me to recap what I know so far, suddently, I remember I had many tools like this, I will add some useful on my laptop/pc into blog as well
http://automated-chaos.blogspot.com/search/label/API
http://automated-chaos.blogspot.com/2008/06/my-top-5-ultimate-utilities.html
Gadwin Printscreen, woa, the tool I love most, now in my Framework, I can automatically scrap screen in failed test case, perfect
"Showing posts with label API. Show all posts Showing posts with label API. Show all posts
June 3, 2008
My Top 5 Ultimate Utilities for Testing
This is my list of top 5 utilities I use for (automated) testing. I use them as helper programs in the (automated) test process, so this is not a list stating automated test tools, bug loggers etc. Every header is a link to the location where you can find the application.
5. API Viewer
http://www.activevb.de/rubriken/apiviewer/index-apiviewereng.html
View all useable functions and constants from all common Window API's and auto generate C/VB code for it.
4. Pycron
http://sourceforge.net/project/showfiles.php?group_id=77456
Your own cron tab under Windows, with GUI for editing events. You can run this as command line or as service. Stable, small and can run stand alone.
3. Notepad++ Portable
A notepad with many options. Simular to text editors as ultraedit except this one is free and can run stand alone (if you choose the portable version).
2. Synergy
http://sourceforge.net/project/showfiles.php?group_id=59275
Very useful when having multiple PCs with multiple monitors, but when you only want to use 1 keyboard/mouse combination. Mouse movement works just as you would expect from a dual/triple monitor setup, only you cannot drag your windows to the other screen (because it is a physical other machine). However the application manages to get copy pasting of text working most of the time.
1. Gadwin Printscreen
http://www.gadwin.com/download/
A customizable screen dump tool with one major advantage above lots of others: It can be called by the Command line. This gives it a great usage during automated testing.
Contains all features you'll expect in an ultimate tool: jpg, png, bmp and gif formats, custom filename, incremential filename, silence mode etc.
This application works stand alone (once unpacked, there is no installation needed on specific workstations, just run the executable).
Posted by Bas M. Dam 2 comments "
http://automated-chaos.blogspot.com/search/label/API
http://automated-chaos.blogspot.com/2008/06/my-top-5-ultimate-utilities.html
Gadwin Printscreen, woa, the tool I love most, now in my Framework, I can automatically scrap screen in failed test case, perfect
"Showing posts with label API. Show all posts Showing posts with label API. Show all posts
June 3, 2008
My Top 5 Ultimate Utilities for Testing
This is my list of top 5 utilities I use for (automated) testing. I use them as helper programs in the (automated) test process, so this is not a list stating automated test tools, bug loggers etc. Every header is a link to the location where you can find the application.
5. API Viewer
http://www.activevb.de/rubriken/apiviewer/index-apiviewereng.html
View all useable functions and constants from all common Window API's and auto generate C/VB code for it.
4. Pycron
http://sourceforge.net/project/showfiles.php?group_id=77456
Your own cron tab under Windows, with GUI for editing events. You can run this as command line or as service. Stable, small and can run stand alone.
3. Notepad++ Portable
A notepad with many options. Simular to text editors as ultraedit except this one is free and can run stand alone (if you choose the portable version).
2. Synergy
http://sourceforge.net/project/showfiles.php?group_id=59275
Very useful when having multiple PCs with multiple monitors, but when you only want to use 1 keyboard/mouse combination. Mouse movement works just as you would expect from a dual/triple monitor setup, only you cannot drag your windows to the other screen (because it is a physical other machine). However the application manages to get copy pasting of text working most of the time.
1. Gadwin Printscreen
http://www.gadwin.com/download/
A customizable screen dump tool with one major advantage above lots of others: It can be called by the Command line. This gives it a great usage during automated testing.
Contains all features you'll expect in an ultimate tool: jpg, png, bmp and gif formats, custom filename, incremential filename, silence mode etc.
This application works stand alone (once unpacked, there is no installation needed on specific workstations, just run the executable).
Posted by Bas M. Dam 2 comments "
QuickTest Pro, Object Repository export problem, recognize object
This should be in my todo list. In the current Framework, we did a lot of GUI interact actions, more than 1200 actions
Sometime, QTP got crash, stuck, cannot recognize object, the version 8.0 is quiet stable, but QTP9.5 is suck, even we submit ticket but didn't get any support from HP
So, what I want to do here is to write myself API for interacting some objects that QTP cannot or not stable enough. To support that goal, I really want to know deep inside how QTP organize objects. This link, post
"4. There is no fast way to export the object repository to plain text
Unlike WinRunner, where the GUI map was just a plain text file, it is not possible to easily export (and manipulate) the object repository. It is possible though, but you'll have to do it through COM automation on the QTP application. I tried it today, but I failed miserably because I could not access the ActiveX object (probably not enough authorization on my workstation).
However, if I get it working, I will post the code on Automated Chaos."
http://automated-chaos.blogspot.com/search/label/object%20repository
Little bit same what I need to know. If you have any experience, idea, can you please share with me? Nice to see you around
Sometime, QTP got crash, stuck, cannot recognize object, the version 8.0 is quiet stable, but QTP9.5 is suck, even we submit ticket but didn't get any support from HP
So, what I want to do here is to write myself API for interacting some objects that QTP cannot or not stable enough. To support that goal, I really want to know deep inside how QTP organize objects. This link, post
"4. There is no fast way to export the object repository to plain text
Unlike WinRunner, where the GUI map was just a plain text file, it is not possible to easily export (and manipulate) the object repository. It is possible though, but you'll have to do it through COM automation on the QTP application. I tried it today, but I failed miserably because I could not access the ActiveX object (probably not enough authorization on my workstation).
However, if I get it working, I will post the code on Automated Chaos."
http://automated-chaos.blogspot.com/search/label/object%20repository
Little bit same what I need to know. If you have any experience, idea, can you please share with me? Nice to see you around
Subscribe to:
Posts (Atom)