Convert XLSX to HTML / MHT

During certain scenarios we want to automate file conversion for sending reports via email. If we need to send emails to external recipients; Macro enabled excel sheets might get blocked on the go.

To overcome such situations, I found a site to convert excel “XLSX” to “XLS”. I would like to thank to owner of the blog and courtesy to use the script.

http://kuzmin.ca/blog/?p=578

But this may not help us since even XLS file extensions with Macros will be blocked by exchange. So I modified script to get HTM/MHT format which can easily be sent via emails without any hiccups.

VB Script is as below

Set objExcel = CreateObject(“Excel.Application”)
Set objWorkbook = objExcel.Workbooks.Open(Wscript.Arguments(0))
objExcel.Application.Visible = False
objExcel.Application.DisplayAlerts = False
objExcel.ActiveWorkbook.SaveAs Wscript.Arguments(1), 45
objExcel.ActiveWorkbook.Close
objExcel.Application.DisplayAlerts = True
objExcel.Application.Quit
WScript.Quit
‘ XLSX->XLS conversion script by Michael Kuzmin
http://kuzmin.ca/blog/?p=578
‘ This is how you can you it:
‘ c:\xlsx2htm.vbs “C:\inputdocument.xlsx” “C:\outputdocument”
‘ file format numnber 57 is for pdf format
’44 is for html
’45 is for mht

‘end of script

Copy above script to notepad and save it as “cc:\xlsx2htm.vbs”

Open command prompt and type

c:\xlsx2htm.vbs “C:\inputdocument.xlsx” “C:\outputdocument

output file will be in “MHT” format.

Celerra CAVA Servers

Imagine a situation where EMC NAS’s CIFS servers are configured and joined to Domain A and your CAVA servers are joined to Domain B. What happens later is a big mess…

Sometimes Celerra fails to authenticate with CAVA servers and anti virus scan may not work.

To overcome such situations we can define FQDN of CAVA servers in viruschk.conf file instead of IP address of CAVA servers.

Eg: addr=abc.domain.com can be used instead of the CAVA server ip x.x.x.x in viruschk.conf file.

DIY: Simplest method to add cronjob

We need to run some  scripts hourly, daily, mothly etc.. But consfued with syntax to be used in crontab…. Stop worrying about learning how to do it. Lets use CCPT (Cut, Copy Paste Technology!!)

Here is the simplest way to add cronjob.

Step 2.  Select your options like every 1/2 hour, every day or month etc..
Step 3. Provide path to the script file and click on “YES”
Step 4. “Yes!”, its done… Use CCPT and then type “crontab -e” and paste and the end of file. CTRL+O will  ask you to save and CTRL+X will exit from editing “crontab”
Step 5. Thats it! now run “crontab -l” to check whether you saved it successfully.
Step 6: For verification whether “Cron Jobs” are running or not; run the command “grep CRON /var/log/syslog”. The output will show that your script executed at specified time, hour etc…
PS: We you use this “http://www.generateit.net” for many other stuffs like FavIcon, Email to Image, CSS Layout Generators etc…
I’ve bookmarked it; what about you…

Good blogs on VMAX

Take a look at latest VMAX stuffs from below link

http://virtualgeek.typepad.com/virtual_geek/2012/05/vmax-40k5876-powerful-trusted-smart-more.html

EMC VNX Drawbacks – Mapped pools for File

EMC VNX has a feature to have mapped pools for File which is a nothing but a direct association of Storage pools for Block. But the biggest drawback is that we can’t extend the pool from either volumes or disks. So the option of extend or shrink of pools will be disabled at VNX level.

Workaround: Never create a system default pools for File. Manually create user defined pools for File in VNX

.Image

vpnc – Open source VPN Client

How to connect to Cisco VPN  for accessing office  computer from LINUX?

Is this possible? Was the question raised in my mind when I try to connect and check emails using outlook. Little bit of search in techno-bible (Google) allowed me to explore “vpnc” (www.vpnc.org). I apt-get it and it was ready to use. Wait, I have only .pcf file with me… I tried using .pcf file directly but it not work out. Below are the steps required to configure VPNC to connect office comp.
Step1: # vim /etc/vpnc/officevpn
IPSec gateway <gateway.address.of.vpn>
IPSec ID <groupname as per PCF file>
IPSec secret <decrypted group password*>
Xauth username <your username>
Xauth password <your password can be left as blank>
save the file and exit from vim
*Use the below uri to decrypt encrypted group password
Step 2: # vpnc officevpn
after execution of above command, we need to provide password if not provided earlier. It will connect to the office VPN and then with necessary routing info added to your home computer, we can access office computer.
Hail Work From Home!

Automysqlbackup

Simple MySQL backup tool in Linux

I’ve found automysqlbackup as the simplest MySQL DB backup tool. Its so simple that you dont have to do anything after install. Just apt-get it and forget, it will backup your DB’s daily, weekly and monthly! Its worth to try it; personally I would rate this 10/10.
Steps for Debian based OS
Step1. apt-get install automysqlbackup

Step2: run as root “automysqlbackup”

After running the above command, it creates dir’s under /var/lib/automysqlbackup by the names of your DB’s. Under each DB dir you’ll find “daily”, “weekly” and  “monthly” dirs. As the name itself suggests that it stores daily, weekly and monthly backups of the respective DB’s.