Maintaining Test Cases in Excel

Applications may sometimes have test cases maintained in Excel Sheet.

Usually the columns are something like this:

  1. USE CASES
    1. S. No.
    2. Description
    3. Category (Functional Or Non-Functional)
    4. SubCategory (Security, Data, Exception, Performance etc.)
    5. Comments
  2. TEST CASES
    1. Test Case No.
    2. Use Case No.
    3. Initial State
    4. Test Case Description
    5. Expected Result
    6. Comments
  3. SCREENSHOTS and LOGS of the test results can be maintained (for every test case) in a doc file.
Advertisements

How to create a follow up Meeting by copying an existing Outlook meeting

Searched for:

  1. Create recurring meetings in outlook 2013 at different times
  2. How to create a follow up meeting from any outlook 2013 meeting
  3. how to copy a meeting when setting up a new meeting in outlook 2013

What Worked

  1. http://social.technet.microsoft.com/Forums/office/en-US/97ad7beb-75cf-4dd8-b612-e9606d3295aa/looking-for-a-way-to-create-a-new-meeting-from-a-previous-meeting-followup-meeting?forum=outlook OR http://www.msoutlook.info/question/549
    1. Copy the meeting item in your calendar: Press Ctrl and drag the meeting onto your desired data.
    2. Update and Send: Double click the copy one and modify the subject(may be add [follow up]), location, add or remove attendees etc. Click Send update to complete.

Bonus Tips:

  1. http://www.scrubly.com/blog/how-to-outlook/boost-your-email-productivity-with-these-3-inbox-rules-for-outlook-2013/
  2. Meeting Workspace: http://support.microsoft.com/kb/831055

Make your Google Calendar visible in Outlook

To do this you have to :

  1. Simply go to the calendar view and in the Ribbon, select “Open Calendar”.
  2. From Internet
  3. Find the ICL address of your Google Cal: https://support.google.com/calendar/answer/37103?hl=en
    1. Mine is: https://www.google.com/calendar/ical/tkhemani%40gmail.com/public/basic.ics
    2. Note that u have to make ur calendar public for this to work

 

Using Room Finder in Outlook 2013

  1. View the Room Calendar for any Room in your calendar Tab
    1. Simply go to the calendar view and in the Ribbon, select “Open Calendar”.
    2. Then select From Room List
    3. See: http://it.eku.edu/support/outlook-2010-room-finder
  2. Use the Room Finder:
    1. For this the rooms have to be configured like so: http://exchangeserverpro.com/find-meeting-rooms/
    2. http://community.spiceworks.com/topic/219275-outlook-2010-room-finder-not-showing-any-rooms

 

JIVE for Office 2013 plugin issue

I have been using Jive for Office 2.0 app in the Past with Office 2010 and it worked perfectly with Word 2010.

Now since upgrading to 2013, it stopped working and in the File – Options menu I see that it says “Runtime load error for this addin”.

Online I found that:

This new v2.5 release of Jive for Office features:

  • Support for Office 2013
    and Windows 8

https://community.jivesoftware.com/docs/DOC-80820

ALSO found that :

Jive for Office v2.5 supports Jive 6.0.1+, on the Microsoft side Office 2003/2007/2010/2013 are supported

DOWNLOAD FROM: http://files.jivesoftware.com/extended-apis/office/manual/JiveForOfficeClient.zip

Ok, so I downloaded and installed the latest version…but it didn’t frekin work even after an hr of troubleshooting, summarized below:

1.            Delete normal.dotm from: C:\Users\<name>\AppData\Roaming\Microsoft\Templates   (coz the jive installation made it corrupt)

a.This got rid of the error but the plugin still doesn’t work

2.            Debug the issue with enabling errors: http://www.scinaptic.com/support/0053.html

a.This does not display any errors at startup for me and the plugin still doesn’t work

3.            BEST: http://blogs.msdn.com/b/vsod/archive/2008/04/22/troubleshooting-com-add-in-load-failures.aspx

a. No help

4.            http://social.msdn.microsoft.com/Forums/office/en-US/192b4460-22be-4218-8609-61ef37cefac3/addins-not-loaded-a-runtime-error-occurred-during-the-loading-of-the-com-addin?forum=exceldev

Fiddled with the registry a lot to no avail…

FINALLY got it to working on intuition…

1.       Uninstalled the plugin from control panel (for the 4th time today)

2.       Installed it again from the exe (note, my version is 20.5.593.15184) jive-for-office.exe

3.       But this time I went into advanced settings while installing and installed it for the machine instead of the user (which is the default setting)

4.       That did the trick and now its working !!!

–>

Normal.dotm corrupt in word 2013

Normal.dotm corrupt in word 2013

Error: we can’t open normal.dotm beacuse we found problems with its contents

Resolution:

1.       Delete it from: C:\Users\khematar\AppData\Roaming\Microsoft\Templates

a.       This got rid of the error but the plugin still doesn’t work

2.       Debug the issue with enabling errors: http://www.scinaptic.com/support/0053.html

a.       This does not display any errors at startup for me and the plugin that caused the corruption
still doesn’t work

Anyways this issue is resolved as after deleting the dotm file, word was able to create a new one in the next startup, and for future, In the advanced options I checked the NOTIFY ON STYLE  CHANGE option and so if anyone tries to change the normal.dotm file, I get notified.

 

 

–>

Power Pivot in Microsoft Excel 2013

How To Enable: http://office.microsoft.com/en-us/excel-help/start-power-pivot-in-microsoft-excel-2013-add-in-HA102837097.aspx

TUTORIAL : Power View
and PowerPivot HelloWorldPicnic Samples for SQL Server 2012

Instructions: http://technet.microsoft.com/library/hh759325(v=sql.110).aspx

Steps:

1.       Simply
Clk on manage in Pivot Tab and then select other souces-> Excel table and
select source : C:\Docs\Downloads\PowerViewPowerPivotHelloWorldPicnicSamples\HelloWorldPicnicPowerViewRTM.xlsx

2.       Then
do OK and there u go…

 

 

–>