Bulk Copy

1. Copy the data from the following tables of Source MSSQL DB Server
1. Packages
2. Package Version
3. Package_Version_Linage
4. Application_Groups
5. Applications
6. Application_publish_TOS
2. If package is present in destination server then do not copy but get the package_id which will be added in applications table
   
3. Import the details of package in the following flow
   
1. Packages
2. Package Version
3. Package_Version_Linage
4. Application_Groups
5. Applications
6. Application_publish_TOS

Tips while installing App-V Server

1. Configure MS-SQL Server:

• Activate the TCP/IP Protocols

Tips: Free audio books

audio Anarchy

Aurora-Audiobooks

"NetLibrary now available thru Atlanta Fulton County Public Library

Toldbooks

Free Stories from Thriller / Brilliance Audio podcasts

Podiobooks

Complete Podiobook (Podcast audiobook) directory

LibriVox

Project Gutenberg's Audiobooks

LiteralSystems.org

AssistiveMedia.org

Stories to Go

Miette's Bedtime Story Podcast

Audiobooks For Free

The Story Spieler

Storyline Online

LearnOutLoud Free Audio/Video Directory

Escape Pod

Many Books

Free Classic Audiobooks

Telltale Weekly

New CCEL Website

The Spoken Alexandria Project

Simply Audiobooks

Free Christian Audiobooks

NAXOS audiobook download shop.

Audiobook Store Portal

Listen-Here Free Audiobooks

Thought Audio

Audiobooks.net

Bug: Zune: File fails to sync with Zune

When I first got zune for myself, I was very happy that for only $90 I am getting 30GB Zune, but in few days only i found that it is not for peoples like me, who like freedom and simplicity.

Anyway one of the biggest problem I found was that Zune can not be sync'ed on Linux because Microsoft forgot that there are peoples (like me) who might not have Windows as Operating System.

More App-V Interview Questions

1. Why the Flag files in OSD Scripts should be saved in Virtual File System instead of Physical System


2. How to create default.sprj file.

App-V Interview Questions

FAQ: Ruby GEM error: ERROR: While executing gem ... (URI::InvalidURIError)

set the http_proxy system variable as
set http_proxy=http://proxy.mj.com:8080
instead of
set http_proxy=proxy.mj.com:8080

App-V Interview Questions

1. What is App-V Sequencing
2. What is VFS Sequenging
3. What is MNT Sequencing
4. What is SystemGuard
5. What are the protocols supported for streamming
6. What is active upgrade
7. Which applications can be sequenced.
8. How to manage exclusion list
9. Can network shortcut applications be sequenced
10. Can host files be sequenced
11. What are the different phases in sequencing app-v applications
12. Define the normal upgrade process
13. What precausions are needed while sequencing
14. How reboots are handled while sequencing
15. Can all types of services be sequenced
16. Why application is launched more then once while sequencing.
17. How much disk space is required on sequencing machine
18. Which hardware component be updated to get better performance in sequencing process.
19. What is a suite and how we can create them
20. What is the difference between update and active upgrade
21. What is the difference between suite and dynamic suite
22. Why only Q drive is necessary for sequncing can we have any other also.
23. Name few disadvantages of using SCCM server for deploying App-V Applications
24. Name few advantages of using SCCM server for deploying App-V Applications

Updated list of questions can be downloaded from my AppvHelper project website. http://sourceforge.net/projects/softgridhelper/files/

Convert Virtualbox vdi to VMware vmdk Files

QEMU-IMG can be used to convert virtualbox vdi file to vmware vmdk file

qemu-img.exe convert -O vmdk virtualbox.vdi vmware.vmdk

Demo Calender in wx.python

This is my wx.Calender demo in wx.python

###########################################################################
# -*- coding: ISO-8859-1 -*-
## This program is free software: you can redistribute it and/or modify
## it under the terms of the GNU General Public License as published by
## the Free Software Foundation, either version 3 of the License, or
## (at your option) any later version.
## This program is distributed in the hope that it will be useful,
## but WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
## GNU General Public License for more details.
## You should have received a copy of the GNU General Public License
## along with this program.  If not, see <http://www.gnu.org/licenses>.
__author__ = "Mayank Johri"
__copyright__  = "2009"
__version__ = "0.0.1"
__date__ = "Oct 13 2009"
__license__ = "GNU 3 or latest."
###########################################################################
import re
import datetime
import calendar
import wx
import string
import wx.calendar as cal
import sys
import os
APPDIR = sys.path[0]
TBMENU_RESTORE = wx.NewId()
TBMENU_CLOSE   = wx.NewId()
year = ['January',
     'February',
     'March',
     'April',
     'May',
     'June',
     'July',
     'August',
     'September',
     'October',
     'November',
     'December']
def thismonth():
    """ Presently not using"""
    calendar.setfirstweekday(0)
    today = datetime.datetime.date(datetime.datetime.now())
    current = re.split('-', str(today))
    current_no = int(current[1])
    current_month = year[current_no-1]
    current_day = int(re.sub('\A0', '', current[2]))
    current_yr = int(current[0])
    myCal = '%s %s' %(current_month, current_yr)
    myCal = myCal + '\n' + "M  T  W  Th F  Sa Su" + '\n'
    month = calendar.monthcalendar(current_yr, current_no)
    nweeks = len(month)
    for w in range(0,nweeks):
        week = month[w]
        for x in xrange(0,7):
            day = week[x]
            if x == 5 or x == 6:
                classtype = 'weekend'
            else:
                classtype = 'day'
            if day == 0:
                classtype = 'X'
                myCal = myCal + str(classtype).ljust(3)
            elif day == current_day:
                myCal = myCal + str(day).ljust(3)
            else:
                myCal = myCal + str(day).ljust(3)
        myCal = myCal + '\n'
    return (myCal)
class MyTaskBarIcon(wx.TaskBarIcon):
    def __init__(self, frame):
        wx.TaskBarIcon.__init__(self)
        self.frame = frame
        icon = wx.Icon(os.path.join(APPDIR, 'clock.ico'), wx.BITMAP_TYPE_ICO)
        self.SetIcon(icon)
        self.Bind(wx.EVT_TASKBAR_LEFT_DCLICK, self.OnTaskBarRightClick)
        self.Bind(wx.EVT_MENU, self.OnTaskBarActivate, id=1)
        self.Bind(wx.EVT_MENU, self.OnTaskBarClose, id=2)
    def OnTaskBarRightClick(self, event):
        if not self.frame.IsShown():
            self.frame.Show()
        else: self.frame.Hide()
    def CreatePopupMenu(self):
        menu = wx.Menu()
        menu.Append(1, 'Show/Hide')
        menu.Append(2, 'Close')
        return menu
    def OnTaskBarClose(self, event):
        self.Destroy()
        self.frame.Destroy()

    def OnTaskBarActivate(self, event):
        if not self.frame.IsShown():
            self.frame.Show()
        else: self.frame.Hide()
    def OnTaskBarDeactivate(self, event):
        if self.frame.IsShown():
            self.frame.Hide()
class MayaCalendar(wx.Dialog):
    def __init__(self, parent, id, title):
        wx.Dialog.__init__(self, parent, title="Maya Calender, Ver: 0.0.1")
        vbox = wx.BoxSizer(wx.VERTICAL)
        calend = cal.CalendarCtrl(self, -1, wx.DateTime_Now(),
            style = cal.CAL_SHOW_HOLIDAYS|cal.CAL_SEQUENTIAL_MONTH_SELECTION)
        vbox.Add(calend, 0, wx.EXPAND | wx.ALL, 20)
        self.Bind(cal.EVT_CALENDAR, self.OnCalSelected, id=calend.GetId())
        self.SetSizerAndFit(vbox)
        self.Show(True)
        self.tskic = MyTaskBarIcon(self)
        self.Centre()
    def OnCalSelected(self, event):
        date = event.GetDate()
        dt = string.split(str(date), ' ')
        s = ' '.join([str(s) for s in dt])
        self.text.SetLabel(s)
class MyApp(wx.App):
    def OnInit(self):
        frame = MayaCalendar(None, -1, 'Maya Calender, Ver: 0.0.1')
        frame.Show(True)
        self.SetTopWindow(frame)
        return True
app = MyApp(0)
app.MainLoop()

demo code for wx.TaskBarIcon

Below is the demo code for wx.TaskBarIcon,

import wx
class sysTrayDemo(wx.Frame):
    def __init__(self, parent, id, title):
        pass
        wx.Frame.__init__(self, parent, -1, title, size = (800, 600),
                         style=wx.DEFAULT_FRAME_STYLE|wx.NO_FULL_REPAINT_ON_RESIZE)
        # FIXME: substitute your icon file here.
        icon = wx.Icon('systray.ico', wx.BITMAP_TYPE_ICO)
        self.SetIcon(icon)
        if wx.Platform == '__WXMSW__':
            # setup a taskbar icon, and catch some events from it
            self.tbicon = wx.TaskBarIcon()
            self.tbicon.SetIcon(icon, "SysTray Demo")
            wx.EVT_TASKBAR_LEFT_DCLICK(self.tbicon, self.OnTaskBarActivate)
            wx.EVT_TASKBAR_RIGHT_UP(self.tbicon, self.OnTaskBarMenu)
            wx.EVT_MENU(self.tbicon, self.TBMENU_RESTORE, self.OnTaskBarActivate)
            wx.EVT_MENU(self.tbicon, self.TBMENU_CLOSE, self.OnTaskBarClose)
        wx.EVT_ICONIZE(self, self.OnIconify)
        return
    def OnIconify(self, evt):
        self.Hide()
        return
    def OnTaskBarActivate(self, evt):
        if self.IsIconized():
            self.Iconize(False)
        if not self.IsShown():
            self.Show(True)
        self.Raise()
        return
    def OnCloseWindow(self, event):
        if hasattr(self, "tbicon"):
            del self.tbicon
        self.Destroy()
    TBMENU_RESTORE = 1000
    TBMENU_CLOSE   = 1001
    def OnTaskBarMenu(self, evt):
        menu = wx.Menu()
        menu.Append(self.TBMENU_RESTORE, "Restore SysTray Demo")
        menu.Append(self.TBMENU_CLOSE,   "Close")
        self.tbicon.PopupMenu(menu)
        menu.Destroy()
    #---------------------------------------------
    def OnTaskBarClose(self, evt):
        self.Close()
        # because of the way wx.TaskBarIcon.PopupMenu is implemented we have to
        # prod the main idle handler a bit to get the window to actually close
        wx.GetApp().ProcessIdle()
class MyApp(wx.App):
    def OnInit(self):
        self.redirect=True
        frame = sysTrayDemo(None, -1, "SysTray Demo")
        frame.Show(True)
        return True
def main():
    app = MyApp()
    app.MainLoop()
if __name__ == '__main__':
    main()

Sequencing Project 2003 Issue

Add the "%appdata%\Microsoft\MS project\" to exclusion list to avoid error while streaming

MSI Interview Questions

1. Explain the difference between Property and PROPERTY


2. Describe the process flow of an installation in terms of the User Interface, Immediate and Deferred sequences


3. What are the ADDLOCAL and ADDSOURCE properties?


4. What is the difference between installations using ALLUSERS=””, ALLUSERS=1 and ALLUSERS=2 option?


5. Advertised vs non-advertised shortcuts, what’s the difference?


6. Maximum how many files you can add in msi?


7. ProductCode, PackageCode, UpgradeCode, Explain them


8. Explain Backend mechanism of Self repair


9. Suppose you’re in an environment where you can’t use advertisement, explain how you would go about setting userspecific settings


10. What is the impact of leaving COM information in a generic registry component as apposed to in each relevant component


11. How many sequences are there in an MSI


12. Please sketch the entire process of creating a package, from the software request up to package delivery


13. How many different sequance tables are there in an MSI


14. Difference between dll/ocx and exe registraction


15. How we can make two applications with same GUID to install on the same machine?


16. How we create the small,minor and major upgrade?


17. what is the disadvantage of using lock permissions table


18. What are secure custom properties


19. What is the difference between Repair and Self healing?


20. What is entry point for MSI?


21. What should be the condition of a custom action if we want to run it during installation and uninstallation ?


22. Difference between Run, Run Once, Active Setup


23. Use of INSTALLLEVEL Property


24. Self-Heal (advertised shortcut) Vs Install on Demand (product Advertising)


25. Self-Heal Vs Repair


26. Per-user installation Vs Per-machine installation


27. The reason why during a repair, bringing back missing files to System Folders is possible for a standard user who actually does not have a write permission to these folders.


28. What are your thoughts and experiences for patching .msi files? What approaches have worked the best? What hasn’t worked? Why?


29. Describe a methodology for populating the user’s profile with Windows Installer functionality. That one was funny because the interviewer was looking for Active Setup which I didn’t consider to be specific to Windows Installer.


30. How do you configure an installation for an application that requires administrative privileges to work if the end user is not a local machine administrator?


31. Have you ever had to modify a .msi directly without a graphic interface? Which tables did you modify and why?


32. Describe the most difficult project you have worked on. What was the problem? How did you solve it? What did you learn?


33. What tools are in your “packaging toolkit?”


34. Have you had to edit permissions?


35. How would you change permissions on files and registry entries?


36. What are the differences between the lock permissions table and external tools for editing?


37. How would you populate components from a machine-based installation to a user profile?


38. What tools do you regularly use asides from your primary tool (WPS or IS or etc…) in the process of creating a package?


39. An example of a condition you would use, and what it would be useful for.


40. If you were to receive a vendor MSI, how would you repackage it to comply with company standards?


41. Do you recommed modifying vendor MSIs? Why/why not?


42. What are the advantages of using MSIs?


43. Explain to me what self healing is and how you can leverage it for user specific files/registries


44. Besides self-healing, what other options do you have for creating user specific files/registries and under what scenarios would you use those?


45. How would you troubleshoot an application that does not run on a locked down environment but does run as administrator?


46. When would you use Setup Capture and what kind of clean up would you performed on a captured MSI?


47. Have you created merge modules? Why?


48. What is the purpose of Validation and how do you handle ICE errors on vendor MSIs?


49. Walk me through the entire packaging process from request to deployment you’ve been exposed to in previous roles.

Howto: Delete Rows in wx.Grid

def fm_bDeleteServerDetails(self, event):

lst = self.m_gdServerDetails.GetNumberRows()

selected = []

for r in range(lst):

if self.m_gdServerDetails.IsInSelection(r, 0) == True:

selected.append(r)

selected.reverse()

for r in selected:

self.m_gdServerDetails.DeleteRows(r,1)

	def fm_bDeleteServerDetails(self, event):
		lst = self.m_gdServerDetails.GetNumberRows()
		selected = []
		for r in range(lst):
			if self.m_gdServerDetails.IsInSelection(r, 0) == True:
				selected.append(r)
		selected.reverse()
		for r in selected:
			self.m_gdServerDetails.DeleteRows(r,1)

processTame

import os
import sys
import win32process
import win32api
import subprocess
import win32con
def setpriority(pid=None,priority=1):
	priorityclasses = [win32process.IDLE_PRIORITY_CLASS,
	win32process.BELOW_NORMAL_PRIORITY_CLASS,
	win32process.NORMAL_PRIORITY_CLASS,
	win32process.ABOVE_NORMAL_PRIORITY_CLASS,
	win32process.HIGH_PRIORITY_CLASS,
	win32process.REALTIME_PRIORITY_CLASS]
	if pid == None:
	        pid = win32api.GetCurrentProcessId()
        handle = win32api.OpenProcess(win32con.PROCESS_ALL_ACCESS, True, pid)
        win32process.SetPriorityClass(handle, priorityclasses[priority])
if (len(sys.argv) == 0):
    print("usage: processtame.exe ")
else:
    if (os.path.exists(sys.argv[1])):
    app = subprocess.Popen(sys.argv[1])
    pid = app.pid
    setpriority(pid, 0)
    app.wait()

Searching Machine & User in OU

users: dsquery user -name "username"
Computers: dsquery computer -name "computername"

MultiBoot WinXP and Linux using Grub.

If winxp is installed on second drive and linux is installed on first drive then add/update the following entries in the /boot/grup/menu.lst file

title Windows
map (hd0) (hd1)
map (hd1) (hd0)
root (hd1,0)
chainloader +1

Bug: PCLinuxOS 2007: LiveCD fails to boot on System's with SATA Harddrive

Error:

LiveCD fails to boot with the following error:

Searching for the loop image [DONE]

ERROR: Unable to mount the livecd
Dropping you to a limited shell ................

Resolution

Add the following word on grub menu

all-generic-ide

SFTSequencer.com failes with "Installer failed in execution"

Resolution:
shutdown the windows update service.