Saturday, December 29, 2012

Open Without Password Field Prompt - Office 2007



Open Without Password Field Prompt - Office 2007
Environment: MS Excel 2007


Excel password-protected file without password prompt when startup, which made the file unable to open.

I suspect it caused by the file is saved from Office 2010.

Finally, I fixed it after install the patch via the link below:
http://www.microsoft.com/en-us/download/details.aspx?id=3

It is Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats


if you are using Office 2007, and encounter the same problem, give a try



Friday, September 28, 2012

Cisco - Network Port & Interface Administratively Down


Cisco - Network Port & Interface Administratively Down
Environment: cisco c2960 / ios 12.2(44)

Configure Terminal
#conf t

access to the interface ( XX represents the port number ):
(conf)#int fa0/xx

Make the port to "Down"
(conf-if)#shut
 
Make the port to "Up"
(conf-if)#no shut

Exit twice & Save Setting:
(conf-if)#exit
(conf)#exit
#wr mem 

Check the result:
#show interface fa0/xx

Sunday, September 16, 2012

Basic commands of Apache / PHP on Linux


Basic Commands Of Apache/PHP on Linux
Environment: CentOS 6.2

Check PHP version:
#php -v

Restart the apache:
#/etc/init.d/httpd restart 

Reload the apache:
#/etc/init.d/httpd reload
 

to-be-continue...

Saturday, September 15, 2012

Windows 2008 GPO - Map Drive : Unable applied to Windows XP


Windows 2008 GPO - Map Drive : Unable applied to Windows XP
Environment: MS Windows2008 Server

The company I m working for, which is 50% XP & 50% windows 7
Don't ask me why the windows version is inconsistency ... =\"/=



When I apply the GPO to mapping network drive, it works fine on 7, but none of XP got the drive.
After I search around I found that it mentioned in Microsoft KB943729

After applied the patch to the Windows XP clients, the problem gone.

KB943729 - Group Policy Preference Clients Side Extension.
http://www.microsoft.com/en-us/download/search.aspx?q=KB943729

System Requirement:

Windows XP
Windows XP 64bit
Windows Vista
Windows Vista 64bit
Windows 2003
Windows 2003 64bit




Monday, August 06, 2012

Installing BeautifulSoup For Python 3 on Windows


Installing BeautifulSoup For Python 3
Environment: MS Windows 7


Python 3.4 or above:

Normally, the command for calling pip is pip3.4 as below

(Linux) #pip3.4 install beautifulsoup4 
(Windows) #python -m pip install beautifulsoup4
Successfully installed BeautifulSoup4-4.3.2


Previous Version (<3.4) 2015 Apr 13: pip is included in Python 3.4, solution below is not necessary
Did you encounter problem during install BeautifulSoup? For me (newbie) , YES
I tried the following command, but not work
>python setup.py install

Finally, I have find my way out. It's pretty simple acutally.

-----------------------------------------------------------------------------------------------------------------------
First of all, you must download BeautifulSoap version which able to support Python 3.

You can find the latest version here:
http://www.crummy.com/software/BeautifulSoup/bs4/download


How to Install?
You can easily install BS with easy_install

For the installation of easy_install (If you can't find it in C:\Python\Scripts\ )
download: http://pypi.python.org/packages/source/d/distribute/ 



Please see the picture below:








Friday, July 20, 2012

Determine duplicate cell in Excel 2010


Excel 2010
Please see the picture below:




COUNTIF(A$2:A$7, $B2) > 0
Return : True or False
Explain:
Compare the value between (A2 to A7) and B2, count the number if duplicated.
If the count is bigger than 0, return True.

If not, then return false.

IF(..... , "Duplicated", "")
Return : "Duplicated" or ""
Explain: 
If the formula returns true, then shows "duplicated" in the cell
if not, shows nothing.

Really simple !


Sunday, March 18, 2012

Automated FTP Synchronize with winscp



Platform: Windows server 2003

I have searched the solution to do a File Synchronize for a long time.
There are not many choices if looking for a free for business use software.

Finally, I  look into winscp.
I downloaded the portable version. It works well for me.



Now, I will tell you what I did to complete the task - FTP Synchronize & scheduled it


1) download winscp (I choose the portable version, click "winscp" to download page)

2) write operation script into .txt as the following:

For Example :

File Name: winscp_script.txt
--------------------------------------------------------------------------------
# errors without confirm
option batch on
option confirm off


# Connect
open ftp://[domain name / ip]

# binary mode transfer
option transfer binary

synchronize local E:\[
Local Folder] /[Remote Folder]

# Exit
exit

--------------------------------------------------------------------------------

Explanation :
     - replace [domain name / ip] by the remote host IP or domain name
     - replace [Local Folder] by the Target folder in your local disk
     - replace [Remote Folder] by the source folder in the FTP folder, if the folder isn't in the root folder
       ( just leave / if the source folder is the root folder. )

3) Add a new schedule task in windows.

Run Field:
c:\[winscp location]\WinSCP.exe /console /script=c:\[script location]\winscp\WinscpScriptFile.txt /log=c:\[log file  location]\log_WinscpScriptFile.txt




Explanation :
make it simple
to open winscp with the following parameter, and schedule this command in specified date/time
winscp.exe /console /script=[location] /log=[location]


just 3 steps, very Simple, right?