Thursday, June 28, 2012

Inno Setup Command to Siliently Install vcredist

From the command line:
vcredist_x86.exe /q:a /c:"VCREDI~1.EXE /q:a /c:""msiexec /i vcredist.msi /qn"" "
In an Inno Setup script:
[Files]
Source: {src}\bin\vcredist_x86.exe; DestDir: {app}\bin\;

[Run]
Filename: {app}\bin\vcredist_x86.exe; Parameters: "/q:a /c:""VCREDI~3.EXE /q:a /c:""""msiexec /i vcredist.msi /qn"""" """; WorkingDir: {app}\bin; StatusMsg: Installing Micosoft's C/C++ runtime ...
References

Wednesday, June 20, 2012

Concatenate Multiple Files on the Windows Command Line


If the files are small in size, and you have a small number of them:
type file1.txt > out.txt
type file2.txt >> out.txt
type file3.txt >> out.txt
If you have a large number of large files, this might be a better option:
copy /b file1.dat+file2.dat+file3.dat out.dat /b
or:
copy /b *.dat out.dat /b

Thursday, November 24, 2011

Formula to Increment Month in Excel

Given A1 contains the starting date:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
increments the month.

References

Adding/Subtracting n Month(s) To/From a Date, ozgrid.com
Excel forumula to add a month, Computing.Net

Thursday, December 30, 2010

Registry Setting to View HTML Source in IE6 with GVim

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\View Source Editor\Editor Name]
@="C:\\vim\\vim60\\gvim.exe"

Monday, December 27, 2010

Dump and Load a SVN Repository

These are the steps I took the last time I needed to move a Subversion (SVN) repository from one machine to another.

* Dump the repository to a file:
   svnadmin dump /path/to/repositories/projectrepo > projectrepo.dump
* If your repository is large, you might want to compress it using your favorite tool. This was on Linux, so:
   gzip projectrepo.dump
* Transfer the repository to the target machine.
* Decompress:
   gzip projectrepo.gump.gz
* Create an empty repository:
   svnadmin create /path/to/new/repositories/projectrepo
* Load the project repository:
   svnadmin load /path/to/new/repositories/projectrepo < projectrepo.dump

Friday, April 30, 2010

Recovering a Deleted Google Account

I just deleted one of my Google accounts by mistake. In panic, I done some web searching on how to restore it. This led me to this page, Why can't deleted Google accounts be recovered? . From there I was led to this form, I can't access my account. After filling in as much information as possible, and submitting the form, my account was restored approximately three hours later. Given that others seemed to have less success, I can only guess I succeed without too much trouble because I could recall some significant details about my account, in particular the date I created it, the password for it, the account creation verification number, and because I linked it to another Google account.

Where is Trac installed on Ubuntu Linux?

/usr/share/pyshared/trac/